JSP Web 应用开发 数据库
executeUpdate()方法抛出异常
个人查错定位到24行
运行到23行输出2,抛出SQLExcepion异常输出1,3未输出求解
源代码
<%--
Created by IntelliJ IDEA.
User: 26316
Date: 2023/3/19
Time: 19:50
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page import="java.sql.*" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<%
Connection conn = null;
Statement stmt = null;
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/jqe_school?characterEncoding=utf-8";
conn = DriverManager.getConnection(url,"root","newpassword");
stmt = conn.createStatement();
String sql = "insert into Student values(907,'李强','男',1990,'电子系','北京市西城区')";out.println("2");
int num = stmt.executeUpdate(sql);out.println("3");
stmt.close();
conn.close();
out.print("插入数据影响的行数为"+num);
}catch (ClassNotFoundException e){
e.printStackTrace();
}catch (SQLException e){
out.println("1");
e.printStackTrace();
}
%>
</body>
</html>