JSP登陆界面
- 格式:doc
- 大小:584.00 KB
- 文档页数:5
用Jsp做的一个简单的登陆界面,连接Mysql,数据库名字为school,表为user。
主要分为四个Jsp界面:index.jsp登陆界面,check.jsp检验页面,main.jsp登陆成功界面,error.jsp登陆失败界面。
如下所示:<%@page language="java"import="java.util.*" pageEncoding="utf-8"%><html><head><meta http-equiv="Content-Type" content="text/html;charset=UTF-8"><title>登陆界面</title></head><body><br><br><br><br><br><br><br><br><center><form action="check.jsp"method="post"><table width="380"border="2"bgcolor="#95BDFF"><tr><td><br><h1>      欢迎光临,请登陆</h1></td></tr><tr><td><br>        用户名字:  <input name="username"type="text" size="28"><br><br>        用户密码 :  <input name="userpass"type="password" size="29"><br><br>                 <input type="submit"name="submit"value="提交"style="height:30px;width:80px">           <input type="reset"name="reset"value="取消"style="height:30px;width:80px"><br> </td></tr></table></form></center></body></html><%@page language="java"import="java.sql.*" pageEncoding="utf-8"%><html><head><meta http-equiv="Content-Type" content="text/html;UTF-8"><title>登陆界面</title></head><body><%String username = new String(request.getParameter("username").getBytes("ISO-8859-1") ,"utf-8");String password = new String(request.getParameter("userpass").getBytes("ISO-8859-1") ,"utf-8");session.setAttribute("name",username);Connection dbconn = null;Statement stmt = null;ResultSet rs = null;if(username.equals("")){response.sendRedirect("index.jsp");}try{String driver = "com.mysql.jdbc.Driver";String url = "jdbc:mysql://localhost:3306/school";String user = "sa";String Password = "123";Class.forName(driver);dbconn = DriverManager.getConnection(url, user, Password);stmt = dbconn.createStatement();String sql1 = "select * from user where username='"+username+"'";rs = stmt.executeQuery(sql1);if(rs.next()){//String sql2 = "select * from user where password='"+password+"'";//rs = stmt.executeQuery(sql2);//判断用户密码是否正确String userpass = rs.getString("password");if(userpass.equals(password)){response.sendRedirect("main.jsp");}else{response.sendRedirect("error.jsp");}}else{response.sendRedirect("error.jsp");}}catch(Exception e){e.printStackTrace();}finally{rs.close();stmt.close();dbconn.close();}%></body></html><%@page language="java"import="java.util.*" import="java.text.*"pageEncoding="utf-8"%><html><head><meta http-equiv="Content-Type" content="text/html;charset=UTF-8"><title>登陆成功界面</title></head><body><h1>登陆成功,<%=session.getAttribute("name")%>欢迎您!</h1><%Date now = new Date();DateFormat mediumDateFormat = DateFormat.getDateTimeInstance( DateFormat.MEDIUM, DateFormat.MEDIUM);%><h2>       <%out.println(mediumDateFormat.format(now));%></h2> </body></html><%@page language="java"import="java.util.*" pageEncoding="utf-8"%><html><head><meta http-equiv="Content-Type" content="text/html;charset=UTF-8"><title>登陆失败界面</title></head><body><h1>登陆失败,您输入的用户名或者密码不正确!</h1></body></html>。