jsp第七次作业
用户表： uid (主键，自动增长) uname upwd
使用分层实现注册。（必做）
使用分层实现登录。（选做）
stu.java
package com.xz.beans; public class stu { private int id; private String uname; private String upwd; //访问器 public int getId() { return id; } public void setId(int id) { this.id = id; } 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 stu(int id, String uname, String upwd) { super(); this.id = id; this.uname = uname; this.upwd = upwd; } public stu() { super(); } }
stuDao.java
package com.xz.dao; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; public class stuDao { //用户数据访问类 //添加用户 public int addBean(stuDao b){ int i=0; try { //加载驱动 Class.forName("com.mysql.jdbc.Driver"); //建立连接 Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/homweb", "root", "root"); //写SQL语句 String sql="insert into boss(uname,upwd) values(?,?)"; //执行 PreparedStatement ps=con.prepareStatement(sql); //ps.setInt(1, b.getId()); ps.setString(1, b.getUname()); ps.setString(2, b.getUpwd()); i=ps.executeUpdate(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } return i; }//登录 private String getUpwd() { // TODO Auto-generated method stub return null; } private String getUname() { // TODO Auto-generated method stub return null; } public int denBean(stuDao b){ int i=0; ResultSet rs =null; try { //加载驱动 Class.forName("com.mysql.jdbc.Driver"); //建立连接 Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/homweb", "root", "root"); //写SQL语句 String sql="select uname,upwd from boss where uname=? and upwd=?"; //执行 PreparedStatement ps=con.prepareStatement(sql); //ps.setInt(1, b.getId()); ps.setString(1, b.getUname()); ps.setString(2, b.getUpwd()); rs = ps.executeQuery(); if(rs.next()){ System.out.print("用户登录成功"); i=1; }else{ System.out.print("用户登录失败"); i=0; } rs.close(); ps.close(); con.close(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } return i; } }
login.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>用户登录页面</title>
</head>
<body>
<h2 align="center">
<font color=red>用户登录页面</font>
</h2>
<form action="success.jsp" method="post">
<table align="center" border="1">
<tr>
<td>用户名:</td>
<td><input type="text" name="name">
</td>
</tr>
<tr>
<td>密 码:</td>
<td><input type="text" name="password">
</td>
</tr>
<tr>
<td><input type="submit" value="登录" name="login">
</td>
<td><input type="reset" value="重置" name="reset">
</td>
</tr>
</table>
<p align="center">
<a href="register.jsp" color=blue>注册用户</a>
</p>
</form>
</body>
</html>
register.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body align="center">
<h2>新用户注册</h2>
<form action="seccess.jsp" method="post">
<table align="center">
<tr align="center">
<td>请输入用户名:</td>
<td><input type="text" name=name autofocus="autofocus"></td>
</tr>
<tr align="right">
<td>请输入密码:</td>
<td><input type="text" name=password></td>
</tr>
<tr align="right">
<td>请输入确认密码:</td>
<td><input type="text" name=refill></td>
</tr>
</table>
<input type="submit" name=register value="注册" >
<input type="reset" name=refill value="重填" >
</form>
</body>
</html>
判断是否成功
<%@page import="java.sql.*"%> <%@page import="javax.sql.*"%> <%@page import="javax.naming.*"%> <%request.setCharacterEncoding("utf-8"); %> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>判断登录</title> </head> <body> <% Context ctx = null; DataSource ds = null; Statement stmt =null; ResultSet rs = null; Connection con = null; String name = request.getParameter("name").trim(); String password = request.getParameter("password").trim(); try{ ctx = new InitialContext(); ds = (DataSource)ctx.lookup("java:comp/env/jdbc/mysql");//mysql是在创建连接池时自己创建的名字 语句功能找到配置的数据库 con = ds.getConnection();//创建数据库连接 stmt = con.createStatement(); rs=stmt.executeQuery("select * from user where name='"+name+"'"); if(rs.next()){ rs=stmt.executeQuery("select * from user where name='"+name+"' and password='"+password+"'"); if(rs.next()){ out.print(name+"登录成功"); }else{ out.print("密码输入错误！！！<br>"+"重新<a href=\"login.jsp\">登录</a>"); } }else{ out.print("<font color=red>"+name+"</font>用户不存在！！！<br>"+"请点击<a href=\"register.jsp\">注册</a>"); } }catch(Exception e){ out.print(e); }finally{ if(rs!=null) rs.close(); if(stmt!=null) stmt.close(); if(con!=null) con.close(); } %> </body> </html>
