JSP第七周作业
用户表: uid (主键,自动增长) uname upwd
使用分层实现注册。(必做)
使用分层实现登录。(选做)
User.java
package com.ee.bean; public class User { private int uid; private String uname; private String upwd; //访问器 public int getUid() { return uid; } public void setUid(int uid) { this.uid = uid; } public String getUname() { return uname; } public void setUname(String uname) { this.uname = uname; } public String getUpwd() { return upwd; } public void setUpwd(String upwd) { this.upwd = upwd; } //构造器 public User(int uid, String uname, String upwd) { super(); this.uid = uid; this.uname = uname; this.upwd = upwd; } public User() { super(); } }
UserDao.java
package com.ee.dao; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import javax.resource.cci.ResultSet; import com.ee.bean.User; public class UserDao { public int addUser(User u){ int i=0; try { //加载驱动 Class.forName("com.mysql.jdbc.Driver"); //建立连接 Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql?useUnicode=true&characterEncoding=utf8", "root", "123456"); //写SQL语句 String sql="insert into user2(uname,upwd) values(?,?)"; //执行 PreparedStatement ps=con.prepareStatement(sql); ps.setString(1, u.getUname()); ps.setString(2, u.getUpwd()); i=ps.executeUpdate(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } return i; } public int selectUser(User u){ int n=0; try{ Class.forName("com.mysql.jdbc.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql?useUnicode=true&characterEncoding=utf8", "root", "123456"); String sql="select uname,upwd from user2 where uname=?and upwd=?"; PreparedStatement ps=con.prepareStatement(sql); ps.setString(1, u.getUname()); ps.setString(2, u.getUpwd()); n=ps.executeUpdate(); } catch (Exception e) { e.printStackTrace(); } return n; } }
index.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <style> body{ width:600px; height:500px; overflow: hidden; position: relative; background-repeat: no-repeat; background-image:url(chengshi_yejing-007.jpg); } form{ width: 300px; height: 150px; padding-top: 10px; margin: 150px auto; background: #00000000; border-radius: 20px; border: 3px solid #f8fcfc; opacity: 0.9;} table{ width: 300px; height: 80px; padding-top: 0px; margin: 50px auto; background: #00000000; position:relative; } } </style> <head> </head> <body> <form name="form1" method="post" action="control.jsp" > <table> <tr> <tr> <td>用户名:</td> <td> <input type="text" name="uname" id="userName" ></td> </tr> <tr> <td>输入登录密码:</td> <td><input type="password" name="upwd" id="pwd"></td> </tr> <tr> <td colspan="2">      <input type="submit" value="注册"> <input type="submit" value="登录"></td> </tr> </table> </form> </body> </html>
control.java
<%@page import="com.ee.dao.UserDao"%> <%@page import="com.ee.bean.User"%> <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <% User u = new User(); String uname = request.getParameter("uname"); u.setUname(uname); String upwd = request.getParameter("upwd"); u.setUpwd(upwd); UserDao ud=new UserDao(); if(ud.addUser(u)>0){ //跳转注册成功页面 }else{ //错误页面 } %> <% if(uname.equals("zs")&&upwd.equals("123")){ //跳转成功登录页面 request.getRequestDispatcher("welcome.jsp").forward(request, response); session.setAttribute("uname",uname); } else{ //错误页面 request.getRequestDispatcher("index.jsp").forward(request, response); } %>
welcome.jsp
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> </head> <body> 您已成功登录! </body> </html>