jsp连接mysql数据库连接异常_JSP连接MySQL数据库(坑!!!!!!!)
Class.forName("com.mysql.jdbc.Driver");Connection conn = null;String url = "jdbc:mysql://192.168.1.3:3306/stu";//stu数据库名字try{conn = DriverManager.getConnection(url, "root", "123456");...
·
Class.forName("com.mysql.jdbc.Driver");
Connection conn = null;
String url = "jdbc:mysql://192.168.1.3:3306/stu"; //stu数据库名字
try{
conn = DriverManager.getConnection(url, "root", "123456"); //账号密码
}catch(Exception e){ //异常提醒
out.println("数据库连接失败");
}
String sql = "select dName from stu01"; //SQL语句
Statement statement;
try{
statement = conn.createStatement();
ResultSet rest = statement.executeQuery(sql); //执行SQL语句
}
}catch(Exception e){
out.print("数据库查询失败"); //异常提醒
}
%>
更多推荐
所有评论(0)