提交页面添加学生信息然后添加到数据库 

 1 <%@ page language="java" contentType="text/html; charset=UTF-8"
 2     pageEncoding="UTF-8"%>
 3 <!DOCTYPE html>
 4 <html>
 5 <head>
 6 <meta charset="UTF-8">
 7 <title>添加任意学生的提交页面</title>
 8 </head>
 9 <body>
10 <form action="insert_stu_2.jsp" method="post">
11     <table border="0" width="238" height="252">
12            <tr> 
13            <td>学号</td>
14             <td><input type="text" name="id"> </td>      
15            </tr>
16             <tr> 
17            <td>姓名</td>
18             <td><input type="text" name="name"> </td>      
19            </tr>
20             <tr> 
21            <td>性别</td>
22             <td><input type="text" name="sex"> </td>      
23            </tr>
24             <tr> 
25            <td>年龄</td>
26             <td><input type="text" name="age"> </td>      
27            </tr>
28             <tr> 
29            <td>体重</td>
30             <td><input type="text" name="weight"> </td>      
31            </tr>
32             <tr> 
33            <td>身高</td>
34             <td><input type="text" name="height"> </td>      
35            </tr>
36            <tr align="center"> 
37               <td colspan="2">
38               <input type="submit" value="提  交">&nbsp;&nbsp;&nbsp;&nbsp;
39               <input type="reset" value="取 消">
40                </td>
41            </tr>
42     </table>
43 </form>
44 </body>
45 </html>
 1 <%@page import="java.sql.*"%>
 2 <%@ page language="java" contentType="text/html; charset=UTF-8"
 3     pageEncoding="UTF-8"%>
 4 <!DOCTYPE html>
 5 <html>
 6 <head>
 7 <meta charset="UTF-8">
 8 <title>添加一条记录</title>
 9 </head>
10 <body>
11       <%
12           String className="com.mysql.jdbc.Driver";
13           String url="jdbc:mysql://localhost:3306/db_shangke";
14           String user="root";
15           String password="root";
16           Class.forName(className);
17           Connection conn=DriverManager.getConnection(url, user, password);
18           String sql="Insert into stu_info values(?,?,?,?,?,?)";
19           PreparedStatement pstmt=conn.prepareStatement(sql);
20           request.setCharacterEncoding("utf-8");
21           int id=Integer.parseInt(request.getParameter("id"));
22           String name=request.getParameter("name");
23           String sex=request.getParameter("sex");
24           int age=Integer.parseInt(request.getParameter("age"));
25           int weight=Integer.parseInt(request.getParameter("weight"));
26           int height=Integer.parseInt(request.getParameter("height"));
27           pstmt.setInt(1, id);
28           pstmt.setString(2, name);
29           pstmt.setString(3, sex);
30           pstmt.setInt(4, age);
31           pstmt.setInt(5,weight);
32           pstmt.setInt(6,height);
33           
34           int n=pstmt.executeUpdate();
35           if(n==1){%>数据插入操作成功!<br><%} 
36           else{ %>数据插入操作失败!<br> <% }
37           
38             if(pstmt!=null){
39                 pstmt.close();
40           }
41             if(conn!=null){
42                 conn.close();
43             }
44       %>
45 </body>
46 </html>

 

posted @ 2021-04-11 17:48  丁帅帅dss  阅读(243)  评论(0)    收藏  举报