register
<%@page contentType="text/html" pageEncoding="gbk"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<title>个人信息管理系统--注册页面</title>
</head>
<body>
<table align="center">
<tr>
<td colspan="3" align="center">
<h3><font color="black">请填写以下注册信息</font></h3>
</td>
</tr>
<tr>
<td >
<form action="http://localhost:8080/EIMS/login.jsp" method="post">
<table border="2" cellspacing="0" cellpadding="0">
<tr>
<td>
登录名字
</td>
<td>
<input type="text" name="userName" size="22"/>
</td>
</tr>
<tr>
<td>
用户密码
</td>
<td>
<input type="password" name="password" size="22"/>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" value="确 定" size="12">
<input type="reset" value="清 除" size="12">
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</body>
</html>
registercheck
<%@page import="java.sql.*"%>
<%@page contentType="text/html" pageEncoding="gbk"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<title>处理合同添加数据</title>
</head>
<body bgcolor="#99aaee" background="../image/back.jpg">
<%
String userName=new String(request.getParameter("userName").getBytes("ISO-8859-1"),"gbk");
String password=new String(request.getParameter("password").getBytes("ISO-8859-1"),"gbk");
Connection con=null;
Statement st=null;
try{
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/eims?useUnicode=true&characterEncoding=gbk";
con=DriverManager.getConnection(url,"root","21328");
st=con.createStatement();
String sql="insert into user(userName,password) values ('"+userName+"','"+password+"')";
st.executeUpdate(sql);
response.sendRedirect("http://localhost:8080/EIMS/login.jsp");
}
catch(Exception e){
e.printStackTrace();
}
finally{
st.close();
con.close();
}
%>
</body>
</html>