Question

netbeans连接mysql数据库总是连接不上

try
{
Class.forName("org.gjt.mm.mysql.Driver");
}
catch(ClassNotFoundException e)
{
System.out.println("驱动程序加载错误");
}
try
{
Connection con = DriverManager.getConnection("jdbc:mysql//127.0.0.1:3306;DatabaseName=stu","root","gao");
Statement sql = con.createStatement();
ResultSet rs =sql.executeQuery("Select * from students where english>=60");
out.println("<table border ='1' bgcolor ='cyan'");
out.println("<tr>");
out.println("<td width = '50'>"+"学号"+"</td>");
out.println("<td width = '50'>"+"姓名"+"</td>");
out.println("<td width = '100'>"+"数学成绩"+"</td>");
out.println("<td width = '100'>"+"英语成绩"+"</td>");
out.println("<td width = '100'>"+"物理成绩"+"</td>");
out.println("</tr>");
while(rs.next())
{
................

}
out.println("</table>");
}
catch(SQLException e)
{
out.println("查询错误");
}





Answer 1

jdbc:mysql//127.0.0.1:3306;DatabaseName=stu
改为
jdbc:mysql//127.0.0.1:3306/stu

追问

还是不行耶，一直都只显示这个

追答

后台捕获的SQL异常具体是什么？
把异常e打印出来就知道了

现在建议使用com.mysql.jdbc.Driver这个驱动

追问

搞定了，将com.mysql.jdbc.Driver驱动放到tomcat池里就行了，郁闷....不过还是谢谢你了