问题遇到的现象和发生背景
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