1：首先设计用户表和图书表，设计的字段和类型如下图所示
1.1:用户表user
1.2:图书表book
2:第二写实体类user.java和book.java
1 package com.bie.po;View Code
2
3 import java.io.Serializable;
4
5 /**
6 * @author BieHongLi
7 * @version 创建时间：2017年2月21日 上午9:59:03
8 * 用户的实体类
9 */
10 public class User implements Serializable{
11
12 //增加序列号
13 private static final long serialVersionUID = 1L;
14 private Integer id;
15 private String name;
16 private String password;
17 private String email;
18 private String phone;
19 public Integer getId() {
20 return id;
21 }
22 public void setId(Integer id) {
23 this.id = id;
24 }
25 public String getName() {
26 return name;
27 }
28 public void setName(String name) {
29 this.name = name;
30 }
31 public String getPassword() {
32 return password;
33 }
34 public void setPassword(String password) {
35 this.password = password;
36 }
37 public String getEmail() {
38 return email;
39 }
40 public void setEmail(String email) {
41 this.email = email;
42 }
43 public String getPhone() {
44 return phone;
45 }
46 public void setPhone(String phone) {
47 this.phone = phone;
48 }
49
50 //重写toString 方法
51 @Override
52 public String toString() {
53 return "User [id=" + id + ", name=" + name + ", password=" + password + ", email=" + email + ", phone=" + phone
54 + "]";
55 }
56
57
58 }
1 package com.bie.po;View Code
2
3 import java.io.Serializable;
4
5 /**
6 * @author BieHongLi
7 * @version 创建时间：2017年2月23日 上午10:19:08
8 * 图书的实体类
9 */
10 public class Book implements Serializable{
11
12
13 private static final long serialVersionUID = 1L;
14 private Integer bookid;
15 private String bookname;
16 private Double price;
17 private String author;
18 private String pic;
19 private String publish;
20 public Integer getBookid() {
21 return bookid;
22 }
23 public void setBookid(Integer bookid) {
24 this.bookid = bookid;
25 }
26 public String getBookname() {
27 return bookname;
28 }
29 public void setBookname(String bookname) {
30 this.bookname = bookname;
31 }
32 public Double getPrice() {
33 return price;
34 }
35 public void setPrice(Double price) {
36 this.price = price;
37 }
38 public String getAuthor() {
39 return author;
40 }
41 public void setAuthor(String author) {
42 this.author = author;
43 }
44 public String getPic() {
45 return pic;
46 }
47 public void setPic(String pic) {
48 this.pic = pic;
49 }
50 public String getPublish() {
51 return publish;
52 }
53 public void setPublish(String publish) {
54 this.publish = publish;
55 }
56 //重写toString()方法
57 @Override
58 public String toString() {
59 return "Book [bookid=" + bookid + ", bookname=" + bookname + ", price=" + price + ", author=" + author
60 + ", pic=" + pic + ", publish=" + publish + "]";
61 }
62
63
64 }
3:第三写登陆页面login.jsp
1 <%@ page language="java" contentType="text/html; charset=UTF-8"View Code
2 pageEncoding="UTF-8"%>
3 <%
4 //获取绝对路径路径 ,开发项目一定要使用绝对路径，不然肯定出错
5 String path = request.getContextPath();
6 String basePath = request.getScheme() + "://"
7 + request.getServerName() + ":" + request.getServerPort()
8 + path + "/";
9 %>
10 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
11 <html>
12 <head>
13 <base href="<%=basePath %>" />
14 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
15 <title>用户登陆页面</title>
16 <style type="text/css">
17 h1{text-align:left;}
18 h4{text-align:left;color:red;}
19 body{background:url(images/1.png)}
20 a{text-decoration:none;font-size:20px;color:black;}
21 a:hover{text-decoration:underline;font-size:24px;color:red;}
22 </style>
23
24 </head>
25 <body>
26 <form action="info.jsp" method="post">
27 <h1>用户登陆页面</h1>
28 <h4>装饰中......</h4>
29 <hr/>
30 <table align="left">
31 <tr>
32 <td>账号：</td>
33 <td><input type="text" name="name" id="name"></td>
34 </tr>
35 <tr>
36 <td>密码：</td>
37 <td><input type="password" name="password" id="password"></td>
38 <td><a href="searchPassword.jsp">找回密码</a></td>
39 </tr>
40 <tr>
41 <td colspan="1">
42 </td>
43 <td>
44 <input type="submit" value="登陆"/>
45 <input type="reset" value="重置"/>
46 <a href="register.jsp" target="_blank">注册</a>
47 </td>
48 </tr>
49 </table>
50 </form>
51 </body>
52 </html>
4：写完登陆页面就需要实现登陆的功能了，开始写后台BaseDao.java连接数据库
1 package com.bie.utils;View Code
2
3 import java.sql.Connection;
4 import java.sql.DriverManager;
5 import java.sql.PreparedStatement;
6 import java.sql.ResultSet;
7 import java.sql.SQLException;
8 import java.util.ResourceBundle;
9
10
11 /**
12 * @author BieHongLi
13 * @version 创建时间：2017年2月21日 上午10:01:14
14 * 数据交互层dao层
15 */
16 public class BaseDao {
17
18
19 private static String driver="com.mysql.jdbc.Driver";
20 private static String url="jdbc:mysql:///test";
21 private static String user="root";
22 private static String password="123456";
23
24 /***
25 * 连接数据库的方法
26 * @return
27 * @throws ClassNotFoundException
28 * @throws SQLException
29 */
30 public static Connection getCon() throws ClassNotFoundException, SQLException{
31 Class.forName(driver);//加载数据库驱动
32 System.out.println("测试加载数据库成功");
33 Connection con=DriverManager.getConnection(url, user, password);
34 System.out.println("测试数据库链接成功");
35 return con;
36 }
37
38 /***
39 * 关闭数据库的方法
40 * @param con
41 * @param ps
42 * @param rs
43 */
44 public static void close(Connection con,PreparedStatement ps,ResultSet rs){
45 if(rs!=null){//关闭资源，避免出现异常
46 try {
47 rs.close();
48 } catch (SQLException e) {
49 // TODO Auto-generated catch block
50 e.printStackTrace();
51 }
52 }
53 if(ps!=null){
54 try {
55 ps.close();
56 } catch (SQLException e) {
57 // TODO Auto-generated catch block
58 e.printStackTrace();
59 }
60 }
61 if(con!=null){
62 try {
63 con.close();
64 } catch (SQLException e) {
65 // TODO Auto-generated catch block
66 e.printStackTrace();
67 }
68 }
69 }
70
71 /***
72 * 同意增删改的方法
73 * @param sql
74 * @param arr
75 * @return
76 */
77 public static boolean addUpdateDelete(String sql,Object[] arr){
78 Connection con=null;
79 PreparedStatement ps=null;
80 try {
81 con=BaseDao.getCon();//第一步 ：连接数据库的操作
82 ps=con.prepareStatement(sql);//第二步：预编译
83 //第三步：设置值
84 if(arr!=null && arr.length!=0){
85 for(int i=0;i<arr.length;i++){
86 ps.setObject(i+1, arr[i]);
87 }
88 }
89 int count=ps.executeUpdate();//第四步：执行sql语句
90 if(count>0){
91 return true;
92 }else{
93 return false;
94 }
95 } catch (ClassNotFoundException e) {
96 // TODO Auto-generated catch block
97 e.printStackTrace();
98 } catch (SQLException e) {
99 // TODO Auto-generated catch block
100 e.printStackTrace();
101 }
102 return false;
103 }
104
105 /*public static void main(String[] args) {
106 try {
107 BaseDao.getCon();
108 System.out.println("测试数据库链接成功");
109 } catch (ClassNotFoundException e) {
110 // TODO Auto-generated catch block
111 e.printStackTrace();
112 } catch (SQLException e) {
113 // TODO Auto-generated catch block
114 e.printStackTrace();
115 }
116 }*/
117
118
119 }
5:写完工具类BaseDao.java开始写UserDao.java接口和UserDaoImpl.java实现类
1 package com.bie.dao;View Code
2
3 import java.util.List;
4
5 import com.bie.po.User;
6
7 /**
8 * @author BieHongLi
9 * @version 创建时间：2017年2月21日 上午10:38:40
10 * 创建一个接口用于声明用户登陆注册的方法
11 */
12 public interface UserDao {
13
14 /***
15 * 用户登陆的方法声明
16 * @param user
17 * @return
18 */
19 public User login(User user);
20
21 /***
22 * 用户注册的方法声明
23 * @param user
24 * @return
25 */
26 public boolean register(User user);
27
28 /***
29 * 查询用户的信息
30 * @param sql
31 * @param arr
32 * @return
33 */
34 public List<User> selectUser(String sql,Object[] arr);
35 }
1 package com.bie.dao.impl;View Code
2
3 import java.sql.Connection;
4 import java.sql.PreparedStatement;
5 import java.sql.ResultSet;
6 import java.sql.SQLException;
7 import java.util.ArrayList;
8 import java.util.List;
9
10 import com.bie.dao.UserDao;
11 import com.bie.po.Book;
12 import com.bie.po.User;
13 import com.bie.utils.BaseDao;
14
15 /**
16 * @author BieHongLi
17 * @version 创建时间：2017年2月21日 上午10:38:56
18 *
19 */
20 public class UserDaoImpl implements UserDao{
21
22 @Override
23 public User login(User user) {
24 Connection con=null;
25 PreparedStatement ps=null;
26 ResultSet rs=null;
27 try {
28 con=BaseDao.getCon();//1:获取数据库的连接
29 //2:书写sql语句
30 String sql="select * from user where name=? and password=? ";
31 ps=con.prepareStatement(sql);//3：预编译
32 //4：设置值
33 ps.setString(1, user.getName());
34 ps.setString(2, user.getPassword());
35 rs=ps.executeQuery();//5:执行sql语句
36 User users=null;
37 if(rs.next()){
38 users=new User();
39 //从数据库中获取值设置到实体类的setter方法中
40 users.setId(rs.getInt("id"));
41 users.setName(rs.getString("name"));
42 users.setPassword(rs.getString("password"));
43 users.setEmail(rs.getString("email"));
44 users.setPhone(rs.getString("phone"));
45
46 return user;
47 }else{
48 return null;
49 }
50
51 } catch (ClassNotFoundException e) {
52 // TODO Auto-generated catch block
53 e.printStackTrace();
54 } catch (SQLException e) {
55 // TODO Auto-generated catch block
56 e.printStackTrace();
57 }finally{
58 //关闭资源，避免出现异常
59 BaseDao.close(con, ps, rs);
60 }
61 return null;
62 }
63
64 /***
65 * 插入的方法，即注册
66 */
67 @Override
68 public boolean register(User user) {
69 String sql="insert into user values(0,?,?,?,?) ";
70 List<Object> list=new ArrayList<Object>();
71 list.add(user.getName());
72 list.add(user.getPassword());
73 list.add(user.getEmail());
74 list.add(user.getPhone());
75
76 boolean flag=BaseDao.addUpdateDelete(sql,list.toArray());
77 if(flag){
78 return true;
79 }else{
80 return false;
81 }
82 }
83
84 @Override
85 public List<User> selectUser(String sql, Object[] arr) {
86 Connection con=null;
87 PreparedStatement ps=null;
88 ResultSet rs=null;
89 try {
90 con=BaseDao.getCon();//第一步连接数据库
91 ps=con.prepareStatement(sql);//第二步：预编译
92 if(arr!=null){
93 for(int i=0;i<arr.length;i++){
94 ps.setObject(i+1, arr[i]);
95 }
96 }
97 //第四步执行sql
98 rs=ps.executeQuery();
99 List<User> list=new ArrayList<User>();
100 while(rs.next()){
101 User user=new User();
102 user.setId(rs.getInt("id"));
103 user.setName(rs.getString("name"));
104 user.setPassword(rs.getString("password"));
105 user.setEmail(rs.getString("email"));
106 user.setPhone(rs.getString("phone"));
107 //System.out.println(user);//测试数据
108 list.add(user);
109 }
110 return list;
111 } catch (ClassNotFoundException e) {
112 // TODO Auto-generated catch block
113 e.printStackTrace();
114 } catch (SQLException e) {
115 // TODO Auto-generated catch block
116 e.printStackTrace();
117 }finally{
118 //关闭资源，避免出现异常
119 BaseDao.close(con, ps, rs);
120 }
121
122 return null;
123 }
124
125
126 }
6：写完dao层，写service层的接口和实现类
1 package com.bie.service;View Code
2
3 import java.util.List;
4
5 import com.bie.po.User;
6
7 /**
8 * @author BieHongLi
9 * @version 创建时间：2017年2月23日 下午1:58:59
10 *
11 */
12 public interface UserService {
13
14 /***
15 * 用户查询的信息
16 * @param user
17 * @return
18 */
19 public List<User> selectUser(User user);
20 }
1 package com.bie.service.impl;View Code
2
3 import java.util.ArrayList;
4 import java.util.List;
5
6 import com.bie.dao.UserDao;
7 import com.bie.dao.impl.UserDaoImpl;
8 import com.bie.po.User;
9 import com.bie.service.UserService;
10
11 /**
12 * @author BieHongLi
13 * @version 创建时间：2017年2月23日 下午1:59:36
14 *
15 */
16 public class UserServiceImpl implements UserService{
17
18 private UserDao dao=new UserDaoImpl();
19
20 @Override
21 public List<User> selectUser(User user) {
22 //sql语句
23 //String sql="select * from user ";
24 StringBuilder sql=new StringBuilder("select * from user where 1=1 ");
25 List<Object> list=new ArrayList<Object>();
26 if(user!=null){
27 //按照姓名查询
28 if(user.getName()!=null && !user.getName().equals("")){
29 sql.append(" and name = ? ");
30 list.add(user.getName());
31 }
32 //按照email查询
33 if(user.getEmail()!=null && !user.getEmail().equals("")){
34 sql.append(" and email = ? ");
35 list.add(user.getEmail());
36 }
37
38 }
39 return dao.selectUser(sql.toString(), list.toArray());
40 }
41
42
43 }
7：然后就可以进行登陆了，由于登陆之后显示的是book列表，所以把图书的查询的dao层和service层也列出来
1 package com.bie.dao;View Code
2
3 import java.util.List;
4
5 import com.bie.po.Book;
6
7 /**
8 * @author BieHongLi
9 * @version 创建时间：2017年2月23日 上午10:22:45
10 * 图书信息的接口
11 */
12 public interface BookDao {
13
14 /***
15 * 图书信息查询的方法
16 * @param sql
17 * @param arr
18 * @return
19 */
20 public List<Book> select(String sql,Object[] arr);
21
22 /***
23 * 获取图书的编号进行查询
24 * @param book
25 * @return
26 */
27 public Book getBook(Integer id);
28 }
1 package com.bie.dao.impl;View Code
2
3 import java.sql.Connection;
4 import java.sql.PreparedStatement;
5 import java.sql.ResultSet;
6 import java.sql.SQLException;
7 import java.util.ArrayList;
8 import java.util.List;
9
10 import com.bie.dao.BookDao;
11 import com.bie.po.Book;
12 import com.bie.utils.BaseDao;
13
14 /**
15 * @author BieHongLi
16 * @version 创建时间：2017年2月23日 上午10:24:02
17 *
18 */
19 public class BookDaoImpl implements BookDao{
20
21 @Override
22 public List<Book> select(String sql, Object[] arr) {
23 Connection con=null;
24 PreparedStatement ps=null;
25 ResultSet rs=null;
26 try {
27 con=BaseDao.getCon();//第一步连接数据库
28 ps=con.prepareStatement(sql);//第二步：预编译
29 if(arr!=null){
30 for(int i=0;i<arr.length;i++){
31 ps.setObject(i+1, arr[i]);
32 }
33 }
34 //第四步执行sql
35 rs=ps.executeQuery();
36 List<Book> list=new ArrayList<Book>();
37 while(rs.next()){
38 Book book=new Book();
39 book.setBookid(rs.getInt("bookid"));
40 book.setBookname(rs.getString("bookname"));
41 book.setPrice(rs.getDouble("price"));
42 book.setAuthor(rs.getString("author"));
43 book.setPic(rs.getString("pic"));
44 book.setPublish(rs.getString("publish"));
45
46 list.add(book);
47 }
48 return list;
49 } catch (ClassNotFoundException e) {
50 // TODO Auto-generated catch block
51 e.printStackTrace();
52 } catch (SQLException e) {
53 // TODO Auto-generated catch block
54 e.printStackTrace();
55 }finally{
56 //关闭资源，避免出现异常
57 BaseDao.close(con, ps, rs);
58 }
59
60 return null;
61 }
62
63 @Override
64 public Book getBook(Integer id) {
65 Connection con=null;
66 PreparedStatement ps=null;
67 ResultSet rs=null;
68 try {
69 con=BaseDao.getCon();//第一步连接数据库
70 String sql="select * from book where bookid = ? ";
71 ps=con.prepareStatement(sql);//第二步：预编译
72 ps.setInt(1, id);
73
74 //第四步执行sql
75 rs=ps.executeQuery();
76 while(rs.next()){
77 Book books=new Book();
78 books.setBookid(rs.getInt("bookid"));
79 books.setBookname(rs.getString("bookname"));
80 books.setPrice(rs.getDouble("price"));
81 books.setAuthor(rs.getString("author"));
82 books.setPic(rs.getString("pic"));
83 books.setPublish(rs.getString("publish"));
84
85 return books;
86 }
87 } catch (ClassNotFoundException e) {
88 // TODO Auto-generated catch block
89 e.printStackTrace();
90 } catch (SQLException e) {
91 // TODO Auto-generated catch block
92 e.printStackTrace();
93 }finally{
94 //关闭资源，避免出现异常
95 BaseDao.close(con, ps, rs);
96 }
97
98 return null;
99 }
100
101
102 }
1 package com.bie.service;View Code
2
3 import java.util.List;
4
5 import com.bie.po.Book;
6
7 /**
8 * @author BieHongLi
9 * @version 创建时间：2017年2月23日 上午10:56:42
10 *
11 */
12 public interface BookService {
13
14 /***
15 * 图书信息查询的方法
16 * @return
17 */
18 public List<Book> select(Book book);
19
20 /***
21 * 根据id进行查询
22 * @param id
23 * @return
24 */
25 public Book getBook(Book book);
26 }
1 package com.bie.service.impl;View Code
2
3 import java.util.ArrayList;
4 import java.util.List;
5
6 import com.bie.dao.BookDao;
7 import com.bie.dao.impl.BookDaoImpl;
8 import com.bie.po.Book;
9 import com.bie.service.BookService;
10
11 /**
12 * @author BieHongLi
13 * @version 创建时间：2017年2月23日 上午10:57:01
14 *
15 */
16 public class BookServiceImpl implements BookService{
17
18 private BookDao dao=new BookDaoImpl();
19
20 public List<Book> select(Book book){
21 //String sql="select * from book ";
22 StringBuilder sql=new StringBuilder("select * from book where 1=1 ");
23 //sql语句
24 List<Object> list=new ArrayList<Object>();
25 if(book!=null){
26
27 if(book.getBookid()!=null && book.getBookid()!=0){
28 sql.append(" and bookid=? ");
29 list.add(book.getBookid());
30 }
31 /*list.add(book.getBookname());
32 list.add(book.getPrice());
33 list.add(book.getAuthor());
34 list.add(book.getPic());
35 list.add(book.getPublish());*/
36 }
37
38 return dao.select(sql.toString(), list.toArray());
39 }
40
41 @Override
42 public Book getBook(Book book) {
43 if(book.getBookid()!=null && book.getBookid()!=0){
44 return dao.getBook(book.getBookid());
45 }
46 return null;
47 }
48
49 }
8：现在展示登陆之后的页面
9:现在展示注册的功能，由于dao层和service层在上面都已经说过了，这里只显示没写的register.jsp页面和doregister.jsp页面
1 <%@ page language="java" contentType="text/html; charset=UTF-8"View Code
2 pageEncoding="UTF-8"%>
3 <%
4 //获取绝对路径路径 ,开发项目一定要使用绝对路径，不然肯定出错
5 String path = request.getContextPath();
6 String basePath = request.getScheme() + "://"
7 + request.getServerName() + ":" + request.getServerPort()
8 + path + "/";
9 %>
10 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
11 <html>
12 <head>
13 <base href="<%=basePath %>" />
14 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
15 <title>注册的页面</title>
16 <style type="text/css">
17 h1{text-align:center;}
18 h4{text-align:right;color:red;}
19 body{background:url(images/2.png)}
20 </style>
21
22 <script type="text/javascript" src="js/jquery.min.js"></script>
23 <script type="text/javascript">
24 $(document).ready(function(){
25 //alert("测试jQuery是否能用");
26 $("#form1").submit(function(){
27 var name=$("#name").val();//获取提交的值
28 if(name.length==0){//进行判断，如果获取的值为0那么提示账号不能为空
29 //alert("aa");//测试使用
30 $("#nameError").html("账号不能为空");
31 return false;
32 }
33
34 //密码进行验证不能为空
35 var password=$("#password").val();//获取提交的密码的值
36 if(password.length==0){
37 $("#passwordError").html("密码不能为空");
38 return false;
39 }
40
41 //确认密码进行验证
42 var relpassword=$("#relpassword").val();//获取提交的确认密码的值
43 if(relpassword.length==0){
44 $("#relpasswordError").html("确认密码不能为空哦");
45 return false;
46 }
47
48 if(password!=relpassword){
49 $("#relpasswordError").html("确认密码输入不正确，请重新输入");
50 return false;
51 }
52 });
53
54 });
55 </script>
56 </head>
57 <body>
58 <form action="doregister.jsp" method="post" id="form1">
59 <h1>用户注册页面</h1>
60 <h4>装饰中......</h4>
61 <hr/>
62 <table align="center">
63 <tr>
64 <td>账 号：</td>
65 <td>
66 <input type="text" name="name" id="name"/>
67 <div id="nameError" style="display:inline;color:red;"></div>
68 </td>
69 </tr>
70 <tr>
71 <td>密 码：</td>
72 <td>
73 <input type="password" name="password" id="password">
74 <div id="passwordError" style="display:inline;color:red;"></div>
75 </td>
76 </tr>
77 <tr>
78 <td>确认密码：</td>
79 <td>
80 <input type="password" name="relpassword" id="relpassword">
81 <div id="relpasswordError" style="display:inline;color:red;"></div>
82 </td>
83 </tr>
84 <tr>
85 <td>电话号码：</td>
86 <td><input type="text" name="phone" id="phone"></td>
87 </tr>
88 <tr>
89 <td>电子邮件：</td>
90 <td><input type="text" name="email" id="email"></td>
91 </tr>
92 <tr>
93 <td colspan="1">
94 </td>
95 <td>
96 <input type="submit" value="注册"/>
97 <input type="reset" value="重置"/>
98 <a href="login.jsp" target="_blank">登陆</a>
99 </td>
100 </tr>
101 </table>
102 </form>
103 </body>
104 </html>
1 <%@page import="com.bie.dao.impl.UserDaoImpl"%>View Code
2 <%@page import="com.bie.dao.UserDao"%>
3 <%@page import="com.bie.po.User"%>
4 <%@ page language="java" contentType="text/html; charset=UTF-8"
5 pageEncoding="UTF-8"%>
6 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
7 <html>
8 <head>
9 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
10 <title>处理注册的页面</title>
11 </head>
12 <body>
13 <%
14 User user=new User();
15 //获取login.jsp页面提交的账号和密码
16 String name=request.getParameter("name");
17 String password=request.getParameter("password");
18 String email=request.getParameter("email");
19 String phone=request.getParameter("phone");
20
21 //获取register.jsp页面提交的账号和密码设置到实体类User中
22 user.setName(name);
23 user.setPassword(password);
24 user.setEmail(email);
25 user.setPhone(phone);
26
27 //引入数据交互层
28 UserDao dao=new UserDaoImpl();
29 boolean flag=dao.register(user);
30
31 if(flag){
32 response.sendRedirect("login.jsp");
33 }else{
34 response.sendRedirect("register.jsp");
35 }
36 %>
37 </body>
38 </html>
效果如下所示：
10:找回密码的功能searchPassword.jsp页面和dosearchPassword.jsp和search.jsp页面
1 <%@ page language="java" contentType="text/html; charset=UTF-8"View Code
2 pageEncoding="UTF-8"%>
3 <%
4 //获取绝对路径路径 ,开发项目一定要使用绝对路径，不然肯定出错
5 String path = request.getContextPath();
6 String basePath = request.getScheme() + "://"
7 + request.getServerName() + ":" + request.getServerPort()
8 + path + "/";
9 %>
10 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
11 <html>
12 <head>
13 <base href="<%=basePath %>" />
14 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
15 <title>找回密码</title>
16 <style type="text/css">
17 body{background:url(images/3.jpg)}
18 </style>
19 </head>
20 <body>
21 <h1>找回密码</h1>
22 <hr/>
23 <a href="javascript: window.history.go(-1)">返回上一级</a>
24 <form action="dosearchPassword.jsp" method="post">
25 <table>
26 <tr>
27 <td>请输入账号：</td>
28 <td><input type="text" name="name"/></td>
29 </tr>
30 <tr>
31 <td colspan="1"></td>
32 <td>
33 <input type="submit" value="提交">
34 <input type="reset" value="重置">
35 </td>
36 </tr>
37 </table>
38 </form>
39
40 </body>
41 </html>
1 <%@page import="java.util.List"%>View Code
2 <%@page import="com.bie.service.impl.UserServiceImpl"%>
3 <%@page import="com.bie.po.User"%>
4 <%@ page language="java" contentType="text/html; charset=UTF-8"
5 pageEncoding="UTF-8"%>
6 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
7 <html>
8 <head>
9 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
10 <title>处理找回密码的页面</title>
11 </head>
12 <body>
13 <%
14 User user=new User();
15 //获取login.jsp页面提交的账号和密码
16 String name=request.getParameter("name");
17 user.setName(name);
18
19 UserServiceImpl service=new UserServiceImpl();
20 List<User> list=service.selectUser(user);
21 request.setAttribute("list", list);
22 for(User u:list){
23 request.setAttribute("user", u);
24 out.print(u);
25 }
26 if(user!=null){
27 //response.sendRedirect("search.jsp");//不传输数据的转发
28 request.getRequestDispatcher("search.jsp").forward(request, response);
29 }
30
31
32 %>
33 </body>
34 </html>
1 <%@ page language="java" contentType="text/html; charset=UTF-8"View Code
2 pageEncoding="UTF-8"%>
3 <%
4 //获取绝对路径路径 ,开发项目一定要使用绝对路径，不然肯定出错
5 String path = request.getContextPath();
6 String basePath = request.getScheme() + "://"
7 + request.getServerName() + ":" + request.getServerPort()
8 + path + "/";
9 %>
10 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
11 <html>
12 <head>
13 <base href="<%=basePath %>" />
14 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
15 <title>弹出信息</title>
16
17
18 <script type="text/javascript">
19 alert("您的密码是：${user.password}");
20 </script>
21
22 </head>
23 <body style="background-color:pink;">
24 <h1>您的密码是：${user.password}</h1>
25 <a href="javascript: window.history.go(-1)">返回上一级</a>
26 </body>
27 </html>
效果如下所示：
11:图书列表的功能和图书详情的功能book.jsp页面，doInfo.jsp页面，detail.jsp页面
1 <%@ page language="java" contentType="text/html; charset=UTF-8"View Code
2 pageEncoding="UTF-8" %>
3 <%@ page import="java.util.List" %>
4 <%@ page import="com.bie.po.Book" %>
5 <%@ page import="com.bie.service.impl.BookServiceImpl" %>
6
7 <%@ include file="head.jsp" %>
8 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
9 <html>
10 <head>
11 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
12 <title>图书处理页面</title>
13 <style type="text/css">
14 h1{text-align:center;}
15 </style>
16 </head>
17 <body>
18 <%
19 Book book=new Book();
20 BookServiceImpl service=new BookServiceImpl();
21 List<Book> list=service.select(book);
22 %>
23 <h1>图书列表</h1>
24 <a href="javascript: window.history.go(-1)">返回上一级</a>
25 <table align="center" cellpadding="10" cellspacing="10">
26
27 <tr bgcolor="green">
28 <td>编号</td>
29 <td>书名</td>
30 <td>价格</td>
31 <td>作者</td>
32 <td>封皮</td>
33 <td>出版社</td>
34 </tr>
35 <%-- <%
36 for(Book b:list){
37 %> --%>
38 <%
39 String bg="";
40 for(int i=0;i<list.size();i++){
41 Book b=list.get(i);
42 if(i%2==0)
43 bg="pink";
44 else
45 bg="yellow";
46 %>
47 <tr bgcolor="<%=bg%>">
48 <td><%=b.getBookid() %></td>
49 <td><a href="doInfo.jsp?bookid=<%=b.getBookid() %>"><%=b.getBookname() %></a></td>
50 <td><%=b.getPrice() %></td>
51 <td><%=b.getAuthor() %></td>
52 <td><%=b.getPic() %></td>
53 <td><%=b.getPublish() %></td>
54 </tr>
55 <%
56 }
57 %>
58
59 </table>
60 </body>
61 </html>
1 <%@ page language="java" contentType="text/html; charset=UTF-8"View Code
2 pageEncoding="UTF-8"%>
3 <%@ page import="com.bie.po.Book" %>
4 <%@ page import="com.bie.service.BookService" %>
5 <%@ page import="com.bie.service.impl.BookServiceImpl" %>
6 <%
7 //获取绝对路径路径 ,开发项目一定要使用绝对路径，不然肯定出错
8 String path = request.getContextPath();
9 String basePath = request.getScheme() + "://"
10 + request.getServerName() + ":" + request.getServerPort()
11 + path + "/";
12 %>
13 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
14 <html>
15 <head>
16 <base href="<%=basePath %>" />
17 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
18 <title>书籍详细信息的页面</title>
19 </head>
20 <body>
21 <%
22 Book book=new Book();
23 String sid=request.getParameter("bookid");
24 Integer id=Integer.parseInt(sid);
25 BookService service=new BookServiceImpl();
26 book.setBookid(id);
27 Book books=service.getBook(book);
28
29 session.setAttribute("book", books);
30 response.sendRedirect("detail.jsp");
31 %>
32 </body>
33 </html>
1 <%@ page language="java" contentType="text/html; charset=UTF-8"View Code
2 pageEncoding="UTF-8"%>
3 <%@ page import="com.bie.po.Book" %>
4 <%@ page import="com.bie.service.BookService" %>
5 <%@ page import="com.bie.service.impl.BookServiceImpl" %>
6
7 <%@ include file="head.jsp" %>
8 <%
9 //获取绝对路径路径 ,开发项目一定要使用绝对路径，不然肯定出错
10 String path = request.getContextPath();
11 String basePath = request.getScheme() + "://"
12 + request.getServerName() + ":" + request.getServerPort()
13 + path + "/";
14 %>
15 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
16 <html>
17 <head>
18 <base href="<%=basePath %>" />
19 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
20 <title>图书详细信息页面</title>
21
22 <style type="text/css">
23 h1{text-align:center;}
24 a{font-size:24px;text-decoration:none;}
25 a:hover{text-decoration:underline;font-size:28px;}
26 </style>
27 </head>
28 <body>
29 <h1>图书详细信息的页面</h1>
30 <a href="javascript: window.history.go(-1)">返回上一级</a>
31 <%
32 Book book=(Book)session.getAttribute("book");
33 %>
34 <table align="center" cellpadding="20" cellspacing="20">
35 <tr>
36 <td>图书编号</td>
37 <td>图书名称</td>
38 <td>图书价格</td>
39 <td>图书作者</td>
40 <td>图书封皮</td>
41 <td>图书出版社</td>
42 </tr>
43 <tr>
44 <td><%=book.getBookid() %></td>
45 <td><%=book.getBookname() %></td>
46 <td><%=book.getPrice() %></td>
47 <td><%=book.getAuthor() %></td>
48 <td><img src="images/<%=book.getPic() %>"></td>
49 <td><%=book.getPublish() %></td>
50 </tr>
51 <tr>
52 <td colspan="3"></td>
53 <td></td>
54 <td colspan="2"></td>
55 </tr>
56 </table>
57 <div style="text-align:center;font-size:36px;">
58 <a href="doCard.jsp">添加到购物车</a>
59 <a href="book.jsp">图书列表</a>
60 </div>
61 </body>
62 </html>
效果如下所示：
12:页面最上面显示欢迎用户的功能和安全退出的功能logout.jsp和head.jsp
1 <%@ page language="java" contentType="text/html; charset=UTF-8"View Code
2 pageEncoding="UTF-8"%>
3 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
4 <html>
5 <head>
6 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
7 <title>退出登陆</title>
8 </head>
9 <body>
10 <%
11 session.invalidate();
12 response.sendRedirect("login.jsp");
13 %>
14 </body>
15 </html>
1 <%@page import="com.bie.po.User"%>View Code
2 <%@ page language="java" contentType="text/html; charset=UTF-8"
3 pageEncoding="UTF-8"%>
4 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
5 <html>
6 <head>
7 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
8 <title>头部信息</title>
9 <style type="text/css">
10 #head{background-color:#eee;height:60px;}
11 a{font-size: 36px;}
12 </style>
13 </head>
14 <body>
15 <%
16 User user=(User)session.getAttribute("user");
17 if(user==null){
18 response.sendRedirect("login.jsp");
19 }else{
20 %>
21
22 <div id="head">
23 <table width=100%>
24 <tr>
25 <td>欢迎您 : <%=user.getName() %></td>
26 <td align="right">
27 <a href="cart.jsp">我的购物车</a>
28 <a href="logout.jsp">安全退出</a>
29 </td>
30 </tr>
31 </table>
32 <%} %>
33 </div>
34 </body>
35 </html>
效果如下所示：
13:购物车功能cart.jsp和添加到购物车doCard.jsp的实现
1 <%@page import="java.util.Set"%>View Code
2 <%@page import="java.util.Map"%>
3 <%@page import="com.bie.po.CardItem"%>
4 <%@ page language="java" contentType="text/html; charset=UTF-8"
5 pageEncoding="UTF-8"%>
6 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
7 <html>
8 <head>
9 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
10 <title>购物车</title>
11 <style type="text/css">
12 tr,td{text-align:center;background-color:#eee;}
13
14 </style>
15 </head>
16 <body>
17 <table width="100%" align="center">
18 <tr>
19 <th>书本编号</th>
20 <th>书本名称</th>
21 <th>书本单价</th>
22 <th>书本数量</th>
23 <th>书本小计</th>
24 </tr>
25 <%
26
27 Map<Integer,CardItem> cart=(Map<Integer,CardItem>)session.getAttribute("cart");
28
29 //Set<Map.Entry<Integer,CardItem>> entrys=cart.entrySet();
30 //if(entrys==null || entrys.isEmpty()){
31 //response.sendRedirect("book.jsp");
32 //}
33 double count=0;//总价格
34 //for(Map.Entry<Integer,CardItem> entry : entrys){
35 for(Map.Entry<Integer,CardItem> entry : cart.entrySet()){
36
37 //小计
38 double price=entry.getValue().getNumber() * entry.getValue().getBook().getPrice();
39 //总价格
40 count=count+price;
41 %>
42 <tr>
43 <td><%=entry.getKey() %></td>
44 <td><%=entry.getValue().getBook().getBookname() %></td>
45 <td><%=entry.getValue().getBook().getPrice()%></td>
46 <td><%=entry.getValue().getNumber() %></td>
47 <td><%=price%></td>
48 </tr>
49 <%} %>
50 <tr>
51 <td colspan="4" align="right">价格总计</td>
52 <td><%=count %></td>
53 </tr>
54 </table>
55 <div style="text-align:right;font-size:36px;margin-top:20px;">
56 <a href="book.jsp">继续购买图书</a>
57 <a href="login.jsp">登陆页面</a>
58 </div>
59 </body>
60 </html>
1 <%@ page language="java" contentType="text/html; charset=UTF-8"View Code
2 pageEncoding="UTF-8"%>
3 <%@ page import="com.bie.po.Book" %>
4 <%@page import="java.util.HashMap"%>
5 <%@page import="com.bie.po.CardItem"%>
6 <%@page import="java.util.Map"%>
7
8
9 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
10 <html>
11 <head>
12 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
13 <title>处理购物车</title>
14 </head>
15 <body>
16
17 <%
18 //购物车功能
19 //1：我购买的是哪一本书籍,将将要购买的书本先放到session域中
20 Book book=(Book)session.getAttribute("book");
21
22 //2：如何把该书籍存放到购物车中???
23 //2.1：先判断是否有购物车，如果没有购物车，那么创建购物车，如果有购物车，则直接使用购物车
24 //2.2：购物车使用什么数据类型？
25 //数组(数组是固定大小的，所以不适合)
26 //List集合(list集合是可以存放相同的对象，所以不适合)
27 //Set集合，Map集合(使用Map集合是因为Map集合存储速度比较快) key:存放商品编号;value:存放购物车项;
28
29 //先将购物车从session中拿出来，然后判断是否存在，不存在就创建。
30 Map<Integer,CardItem> cart=(Map<Integer,CardItem>)session.getAttribute("cart");
31 //如果没有购物车，只有第一次访问，才会操作
32 if(cart==null){
33 //就new一个购物车
34 cart=new HashMap<Integer,CardItem>();
35 }
36
37 //把书籍存放到购物车
38 //第二次判断，判断购物车中是否有该书籍
39 //从购物车中，获取该书籍，如果为空，表示购物车中没有该书籍
40 CardItem item=cart.get(book.getBookid());
41 if(item==null){//购物车中不存在这本书，创建，数量默认为1
42 item=new CardItem();
43 item.setBook(book);
44 item.setNumber(1);
45 }else{//购物车中，存在该书籍，直接把数量加1
46 item.setNumber(item.getNumber()+1);
47 }
48
49
50 //把购物车项存放到购物车
51 cart.put(book.getBookid(), item);
52
53 //把购物车存放到session
54 session.setAttribute("cart", cart);
55
56 response.sendRedirect("book.jsp");
57 %>
58
59
60 </body>
61 </html>
效果如下所示：
基本的功能都已经实现了，权当练习的小项目的，欢迎交流