JSP+JDBC实现在可视化页面中插入数据到SQL数据库

原创

本篇博客创建一个如下图所示的JSP页面，将用户填入的数据插入到对应的数据库中。

JSP页面代码：

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>输入界面</title>
    </head>
    <body>
        请填写需要插入的数据:<br><br>
        <form action="recept.jsp" method="post">
            学号:<input type="text" name="id"><br><br>
            姓名:<input type="text" name="name"><br><br>
            性别:<input type="text" name="sex"><br><br>
            年龄:<input type="text" name="age"><br><br>
            体重:<input type="text" name="weight"><br><br>
            身高:<input type="text" name="hight"><br><br>
            <input type="submit" value="提交">&nbsp;&nbsp;&nbsp;
            <input type="reset" value="取消">
        </form>
    </body>
</html>

JDBC代码：

<%@ page language="java" import="java.sql.*,java.util.*" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>接收页面</title>
    </head>
    <body>
        <%
            //连接数据库
            String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
            String dbURL="jdbc:sqlserver://localhost:1433;DatabaseName=DB OF CWM";
            String userName="sa";
            String pwd="dearcwm*0.";
            Class.forName(driverName);
            Connection conn=DriverManager.getConnection(dbURL,userName,pwd);
            String sql="insert into stu_info(id,name,sex,age,weight,hight)values(?,?,?,?,?,?)";
            PreparedStatement stmp=conn.prepareStatement(sql);
            request.setCharacterEncoding("UTF-8");
            int id=Integer.parseInt(request.getParameter("id"));
            String name=request.getParameter("name");
            String sex=request.getParameter("sex");
            int age=Integer.parseInt(request.getParameter("age"));
            float weight=Float.parseFloat(request.getParameter("weight"));
            float hight=Float.parseFloat(request.getParameter("hight"));
            stmp.setInt(1,id);
            stmp.setString(2,name);
            stmp.setString(3,sex);
            stmp.setInt(4,age);
            stmp.setFloat(5,weight);
            stmp.setFloat(6,hight);
            int n=stmp.executeUpdate();
            if(n==1){ %> 数据插入操作成功！<%
                
            } %><%else{ %>数据插入操作失败!<%}
            if(stmp!=null){
                stmp.close();
            }
            if(conn!=null){
                conn.close();
            }
            %>
    </body>
</html>

16:25:16

2018-09-30