int result=statement.executeUpdate(sql);

问题遇到的现象和发生背景

int result=statement.executeUpdate(sql);这里运行不出来
if (result>0)
out.print("");
else
out.print("");

用代码块功能插入代码,请勿粘贴截图

<%
String dbName="studb";
String userName="root";
String userPassword="xm123456";
String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPassword;
Class.forName("com.mysql.jdbc.Driver");
Connection conn= DriverManager.getConnection(url);
Statement statement=conn.createStatement();
String sql="INSERT into student VALUES ('"+id+"','"+stuName+"','"+stuBirthday+"','"+stuClass+"')";
int result=statement.executeUpdate(sql);
if (result>0)
out.print("");
else
out.print("");
sql="select * from student";
rs=statement.executeQuery(sql);
%>

运行结果及报错内容

org.apache.jasper.JasperException: 在 [30] 行处理 [/addnew.jsp] 时发生异常

27: Connection conn= DriverManager.getConnection(url);
28: Statement statement=conn.createStatement();
29: String sql="INSERT into student VALUES ('"+id+"','"+stuName+"','"+stuBirthday+"','"+stuClass+"')";
30: int result=statement.executeUpdate(sql);
31: if (result>0)
32: out.print("");
33: else

idea或者eclipse的控制台报错截图,截全点。

那就是没连接上数据库,或者执行sql语句有问题

端口号加上。localhost:3306
有帮助的话采纳一下哦!