package com.javao.msg; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class DBUtil { public static Connection getConnection() { try { // 1 加载驱动 Class.forName("com.mysql.cj.jdbc.Driver"); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } String user = "root"; String password = "123456"; String url = "jdbc:mysql://localhost:3306/student?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false"; Connection connection = null; try { // 2 创建链接对象connection connection = DriverManager.getConnection(url, user, password); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return connection; } // 关闭资源的方法 public static void close(Connection connection) { try { if (connection != null) { connection.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static void close(PreparedStatement preparedStatement) { try { if (preparedStatement != null) { preparedStatement.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static void close(ResultSet resultSet) { try { if (resultSet != null) { resultSet.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <%--设置页面的脚本支持语言为java—导入util包中的类—申明编码方式为UTF-8--%> <% request.setCharacterEncoding("UTF-8"); //设置响应的编码为UTF-8 response.setCharacterEncoding("UTF-8"); //设置响应的编码为UTF-8 %> <% String path = request.getContextPath(); //相对Path设置 String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/"; //相对Path设置 %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <%--文档声明--%> <html> <head> <title>添加学生信息</title> <%--页面标题--%> <body> <script type="text/javascript" language="JavaScript"> //JS function validate() { var username = document.forms[0].username.value;//账号 var password = document.forms[0].password.value;//密码 var name = document.forms[0].name.value; //姓名 var sex = document.forms[0].sex.value; //性别 var num = document.forms[0].num.value;//学号 var e_mail = document.forms[0].e_mail.value; //邮箱 var school = document.forms[0].school.value; //学校 var zhuan = document.forms[0].zhuan.value; //专业 var ban = document.forms[0].ban.value; //班级 var year = document.forms[0].year.value; //年份 var diqu = document.forms[0].diqu.value; //生源地 var bei = document.forms[0].bei.value; //备注 /*var username = validate(document.form.user_name.value); var password = validate(document.form.password.value); var name = validate(document.form.name.value); var sex = validate(document.form.sex.value); var num = validate(document.form.num.value); var e_mail = validate(document.form.e_mail.value); var school = validate(document.form.school.value); var zhuan = validate(document.form.zhuan.value); var ban = validate(document.form.ban.value); var year = validate(document.form.year.value); var diqu = validate(document.form.diqu.value); var bei = validate(document.form.bei.value);*/ if (username[0]<‘A‘||username[0]>‘z‘) { alert("必须以字母开头！"); return false; } else if (12<username.length||username.length <6) { //判断姓名位数，必填 alert("账号必须6-12位！"); return false; } else if (password.length <= 8) { alert("请输入八位以上的密码！"); return false; } else if (name.length <= 0) { alert("姓名不能为空，请输入姓名！"); return false; } else if (num.length<8) { alert("学号必须是8位！"); return false; } else if (num[0]==‘2‘&&num[1]==‘0‘&&num[2]==‘1‘&&num[3]==‘7‘) { alert("前四位必须是2018！"); return false; } else if (e_mail.length <= 0) { alert("邮箱不能为空，请输入邮箱！"); return false; } else if(!/(\S)+[@]{1}(\S)+[.]{1}(\w)+/.test(e_mail)) { alert("请输入格式正确的 e-mail 地址！"); return false; } else { return true; } //document.getElementById("form").submit(); } </script> </head> <body> <br> <%--换行--%> <center> <h2>添加学生信息</h2> <hr size="1" noshade color="#000000"> <%--横线--%> <form action="insert.jsp" method="post" id="form" onSubmit="return validate()"> <%--跳转到insert.jsp文件，方法为post--%> <table width="800" border="0" align="center"> <%--表格的宽为800，居中对齐--%> <%--表格的宽为800，居中对齐--%> <tr> <td>账号： <input type="text" name="username"></td> </tr> <tr> <td>密码： <input type="password" name="password"></td> </tr> <tr> <td>姓名： <input type="text" name="name"> </td> </tr> <tr> <td>性别: <input id="pingtaijb" name="sex" type="checkbox" value="男">男 </input> <input id="pingtaijb" name="sex" type="checkbox" value="女" />女 </input> </td> </tr> <tr> <td>学号： <input type="text" name="num"></td> </tr> <tr> <td>邮箱： <input type="text" name="e_mail"> </td> </tr> <tr> <td>学校： <input type="text" name="school"> </td> </tr> <tr> <td>专业： <input type="text" name="zhuan"> </td> </tr> <tr> <td>班级： <input type="text" name="ban"> </td> </tr> <tr> <td>年份： <input type="text" name="year"> </td> </tr> <tr> <td>生源地： <select name="diqu" οnchange="showUser(this.value)"> <option value="1">北京市</option> <option value="2">天津市</option> <option value="3">河北省</option> <option value="4">山西省</option> </select> </td> </tr> <tr> <td>备注： <input type="text" name="bei"> </td> </tr> <tr> <td> <input name="submit" type="submit" value="添加" /> <input type="reset" value="重置"></td> </tr> </table> <p> </p> </form> </center> </body> </html>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <%--设置页面的脚本支持语言为java—导入util包中的类—申明编码方式为UTF-8--%> <%@ page import="java.sql.*"%> <%--导入java中的sql包--%> <%@page import="com.javao.msg.DBUtil"%> <% request.setCharacterEncoding("UTF-8"); //设置响应的编码为UTF-8 response.setCharacterEncoding("UTF-8"); //设置响应的编码为UTF-8 %> <% String path = request.getContextPath(); //相对Path设置 String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/"; //相对Path设置 %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <%--文档声明--%> <html> <head> <base href="<%=basePath%>"> <%--设置基础路径,basepath为变量--%> <title>添加学生信息</title> <%--页面标题--%> </head> <body> s <% request.setCharacterEncoding("UTF-8"); //设置响应的编码为UTF-8 String username1 = request.getParameter("username"); String password = request.getParameter("password"); String name = request.getParameter("name"); String sex = request.getParameter("sex"); String num = request.getParameter("num"); String e_mail = request.getParameter("e_mail"); String school = request.getParameter("school"); String zhuan = request.getParameter("zhuan"); String ban = request.getParameter("ban"); String year = request.getParameter("year"); String diqu = request.getParameter("diqu"); String bei = request.getParameter("bei"); Connection conn = null; //定义静态数据库连接 Statement stat = null; ResultSet rs = null; //将rs滞空。 conn = DBUtil.getConnection(); stat = conn.createStatement(); //String sql = ; //向对应的数据字段添加数据 stat.executeUpdate("insert into clc(username,password,name,sex,num,e_mail,school,zhuan,ban,year,diqu,bei) values(‘" + username1 + "‘,‘" + password + "‘,‘" + name + "‘,‘" + sex + "‘,‘" + num + "‘,‘" + e_mail + "‘,‘" + school + "‘,‘" + zhuan + "‘,‘" + ban + "‘,‘" + year + "‘,‘" + diqu + "‘,‘" + bei + "‘)"); rs = stat.executeQuery("select * from clc"); //查找data表 %> <center> <% if (rs.next()) { out.print("<br><h3>添加成功!</h3>"); } else { out.print("<br><h3>添加失败!</h3>"); } %> <%--<br> <a href=add.jsp>返回用户信息添加页面</a><br /> --%> <%--<br /> <a href=show.jsp>进入用户信息查询页面</a> --%> </center> </center> <% if (rs != null) { rs.close(); //关闭结果集，但是rs还是有null值。 rs = null; //将rs滞空。 } if (stat != null) { stat.close(); //关闭stat。 stat = null; //滞空stat。 } if (conn != null) { conn.close(); //关闭数据库连接 conn = null; } %> </body> </html>
原文：https://www.cnblogs.com/xrj-/p/11714971.html