login
<%@page contentType="text/html" pageEncoding="gbk"%>
<!DOCTYPE html>
<html>
<head>
<title>企业信息管理系统--登录页面</title>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
</head>
<body background="image/1.png">
<br><br><br><br><br><br>
<br><br><br><br><br><br>
<br>
<center>
<form action="loginCheck.jsp" method="post">
<table border="0">
<tr>
<td>
<table border="0" cellspacing="0" cellpadding="0" width="360" height="200">
<tr height="130">
<td align="center">
用户姓名:<input type="text" name="userName" size="22" ><br>
<br>
用户密码:<input type="password" name="password" size="22" ><br>
<br>
<input type="submit" value="登 录" size="12"/>
<input type="reset" value="清 除" size="12"/>
</td>
</tr>
<tr>
<td>
<p align="center"><a href="http://localhost:8080/EIMS/register/register.jsp">注册</a></p>
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</center>
</body>
</html>
logincheck
<%@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>
<%
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;
ResultSet rs = null;
if(userName.equals("")) {
response.sendRedirect("login.jsp");
}
try{
Class.forName("com.mysql.jdbc.Driver");
/*url后面加的?useUnicode=true&characterEncoding=gbk,是为了处理向数据库中添加数据时出现乱码的问题。*/
String url="jdbc:mysql://localhost:3306/eims?useUnicode=true&characterEncoding=gbk";
con=DriverManager.getConnection(url,"root","21328");
st=con.createStatement();
String query="select * from user where userName='" + userName + "'";
rs=st.executeQuery(query);
if(rs.next()){
String query2 ="select * from user where password='" + password + "'";
rs=st.executeQuery(query2);
if(rs.next()){
response.sendRedirect("main/main.jsp");
}else{
response.sendRedirect("login.jsp");
}
}
}catch(Exception e){
e.printStackTrace();
}finally{
rs.close();
st.close();
con.close();
}
%>
</body>
</html>