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>
