编写程序,实现对数据库StudentInfo中的表student进行插入操作。要求使用预处理语句对象PreparedStatement完成以下数据的插入: insert into student values('001','张三',18,'女') 注:给定数据库登录用户名:sa,密码:123。 Input.jsp: <body> <form action = "addStudent.jsp" method = "post"> 请输入待新增的学生信息<br> 学号:<input type="text" name="sno"/><br> 姓名:<input type="text" name= "sname"/><br> 年龄:<input type="text" name= "sage"/><br> 性别:<input type="text" name= "sex"/><br> <input type = "submit" value= "新增"/> </form> </body> addStudent.jsp: <body> <% String url="jdbc:sqlserver://localhost;databaseName=StudentInfo"; request.setCharacterEncoding("utf-8"); String sno = request.getParameter("sno"); String sname = request.getParameter("sname"); int sage = Integer.valueOf(request.getParameter("sage")); String sex = request.getParameter("sex"); try{ //补全此部分代码 } // 捕获异常 catch(SQLException ex) { System.out.println ("\n*** 发生SQL异常 ***\n"+ex.getMessage()); } catch(ClassNotFoundException ex) { System.out.println(ex); }
时间: 2023-12-17 16:06:04 浏览: 52
补全代码如下:
```java
<%
String url="jdbc:sqlserver://localhost;databaseName=StudentInfo";
request.setCharacterEncoding("utf-8");
String sno = request.getParameter("sno");
String sname = request.getParameter("sname");
int sage = Integer.valueOf(request.getParameter("sage"));
String sex = request.getParameter("sex");
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn = DriverManager.getConnection(url,"sa","123");
String sql = "insert into student values(?,?,?,?)";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, sno);
pstmt.setString(2, sname);
pstmt.setInt(3, sage);
pstmt.setString(4, sex);
pstmt.executeUpdate();
out.println("新增成功");
conn.close();
}
// 捕获异常
catch(SQLException ex) {
System.out.println ("\n*** 发生SQL异常 ***\n"+ex.getMessage());
}
catch(ClassNotFoundException ex) {
System.out.println(ex);
}
%>
```