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>Insert title here</title>
</head>
<body>
<%
Object message = request.getAttribute("message");
if(message!=null && !"".equals(message)){
%>
<script type="text/javascript">
alert("<%=request.getAttribute("message")%>");
</script>
<%} %>
<div align="center">
<h1 style="color: red;">添加学生信息</h1>
<form action="CourseServlet?method=add" method="post" onsubmit="return check()">
<div class="a">
登录账号:<input type="text" id="zhanghao" name="zhanghao"/>
</div>
<div class="a">
登录密码 :<input type="password" id="mima" name="mima"/>
</div>
<div class="a">
性别:<input type="radio" name="sex" id="sex" value="男" checked>男
<input type="radio" name="sex" id="sex" value="女">女
</div>
<div class="a">
姓名:<input type="text" id="name" name="name" />
</div>
<div class="a">
学号:<input type="text" id="xuehao" name="xuehao"/>
</div>
<div class="a">
电子邮件:<input type="text" id="youxiang" name="youxiang" />
</div>
<div class="a">
所在学院:<input type="text" id="school" name="school" />
</div>
<div class="a">
所在系:<input type="text" id="xi" name="xi" />
</div>
<div class="a">
所在班级:<input type="text" id="classes" name="classes" />
</div>
<div class="a">
入学年份(届):<select id="nianfen" name="nianfen">
<option value="1998">1998</option>
<option value="1997">1997</option>
<option value="1999">1999</option>
</select>届
</div>
<div class="a">
生源地<input type="text" id="shengyuandi" name="shengyuandi" />
</div>
<div class="a">
备注<input type="text" id="beizhu" name="beizhu"/>
</div>
<div class="a">
<button type="submit" >添加</button>
</div>
</form>
<div class="a">
</div>
</div>
<script type="text/javascript">
function check() {
var zhanghao = document.getElementById("zhanghao");;
var mima = document.getElementById("mima");
var sex = document.getElementById("sex");;
var name = document.getElementById("name");
var xuehao = document.getElementById("xuehao");;
var youxiang = document.getElementById("youxiang");
var school = document.getElementById("school");;
var xi = document.getElementById("xi");
var classes = document.getElementById("classes");;
var nianfen = document.getElementById("nianfen");
var shengyuandi = document.getElementById("shengyuandi");;
var beizhu = document.getElementById("beizhu");
//非空
if (!zhanghao.value.match(/^[a-zA-Z]\w{5,11}$/)) {
alert("用户名由六到十二英文母.数字和下划线组成，以英文字母开头");
zhanghao.focus();
return false;
}
else if (!mima.value.match(/^(?![0-9]+$)(?![a-zA-Z]+$)[0-9A-Za-z]{8,}$/)) {
alert(" 密码由八 位以上 英文 和数 字 组成");
mima.focus();
return false;
}
else if (!xuehao.value.match(/^2018\d{4}$/)) {
alert(" 学号由八位构成且 前四位为2018");
xuehao.focus();
return false;
}
else if (!youxiang.value.match(/^[a-z0-9]+([._\\-]*[a-z0-9])*@([a-z0-9]+[-a-z0-9]*[a-z0-9]+.){1,63}[a-z0-9]+$/)) {
alert(" 邮箱格式错误");
youxiang.focus();
return false;
}
else if(sex.value == '') {
alert('性别为空');
sex.focus();
return false;
}
else if(name.value == '') {
alert('姓名为空');
name.focus();
return false;
}
else if(school.value == '') {
alert('所在学校为空');
school.focus();
return false;
}
else if(xi.value == '') {
alert('所在系为空');
xi.focus();
return false;
}
else if(classes.value == '') {
alert('所在班级为空');
classes.focus();
return false;
}
else if(nianfen.value == '') {
alert('年份为空');
nianfen.focus();
return false;
}
else if(shengyuandi.value == '') {
alert('生源地为空');
shengyuandi.focus();
return false;
}
else if(beizhu.value == '') {
alert('备注为空');
beizhu.focus();
return false;
}
}
</script>
</body>
</html>
dao
package add;
import java.sql.*;
//import DBUtil.DBUtil;
//import javaweb.fa;
public class dao {
public static boolean add(fa x) {
String sql = "insert into aaa(sno,number,passer,sex,name,xuehao,mail,xueyuan,xi,banji,nian,place,beizhu) values('" + x.getSno() + "','" + x.getNumber() +"','" + x.getPasser() +"','" + x.getSex() +"','" + x.getName() + "','" + x.getXuehao() + "','" + x.getMail() + "','" + x.getXueyuan() + "','" + x.getXi() + "','" + x.getBanji() + "','" + x.getNian() + "','" + x.getPlace() + "','" + x.getBeizhu() + "')";
Connection conn = DBUtil.getConn();
Statement state = null;
boolean f = false;
int a = 0;
try {
state = conn.createStatement();
a = state.executeUpdate(sql);
} catch (Exception e) {
e.printStackTrace();
} finally {
DBUtil.close(state, conn);
}
if (a > 0) {
f = true;
}
return f;
}
}
（未完待续）
