javaEE期末复习指南

准备 项目结构

数据库 Book表

usertab表

jar包

web.xml

  test02
  
    index.html
    index.htm
    index.jsp
    default.html
    default.htm
    default.jsp
  
  
  
  	contextConfigLocation
  	classpath:applicationContext.xml
  
  
  
  	org.springframework.web.context.ContextLoaderListener
  
  
  
  	encoding
  	org.springframework.web.filter.CharacterEncodingFilter
  	
  	
  		encoding
  		UTF-8
  	
  
  
  
  	encoding
 	/*
  
  
  
  
  	springmvc
  	org.springframework.web.servlet.DispatcherServlet
  	
  	
  		contextConfigLocation
  		classpath:springmvcConfig.xml
  	
  	
  	1
  
  
  
  	springmvc
  	/
  

db.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/mydb
jdbc.username=root
jdbc.password=root

springmvcConfig.xml

applicationContext.xml

	
	
	
		
		
		
		
	
	
	
		
	
	
	
	
	
		
		 
		
			
				
					
						mysql
						true
					
				
			
		
	
	
	
		
	
	

登录注册界面

<%@ page language="java" contentType="text/html; charset=utf-8"
	pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/";
%>







	
 
	

		

			

				
			
			

			
				

					
登录
					
					  
					

						没有账号？注册
					
				
			
		

		

		

			

				

					
注册
					   
					

						已有账号？登录
					
				
			
			

				
			
		
	
	
	

实体层 pojo类

///Book类
public class Book {
	private int bookid;
	private String name;
	private double price;
	public int getBookid() {
		return bookid;
	}
	public void setBookid(int bookid) {
		this.bookid = bookid;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public double getPrice() {
		return price;
	}
	public void setPrice(double price) {
		this.price = price;
	}
	public Book() {
		super();
	}
	public Book(int bookid, String name, double price) {
		super();
		this.bookid = bookid;
		this.name = name;
		this.price = price;
	}
	@Override
	public String toString() {
		return "Book [bookid=" + bookid + ", name=" + name + ", price=" + price + "]";
	}
}

User类

public class User {
	private int id;
	private String uname;
	private String password;
	public User() {
		super();
	}

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getPassword() {
		return password;
	}

	public void setPassword(String password) {
	    this.password = password;
	}

	public String getUname() {
		return uname;
	}

	public void setUname(String uname) {
		this.uname = uname;
	}

	public User(int id, String uname, String password) {
		super();
		this.id = id;
		this.uname = uname;
		this.password = password;
	}

	@Override
	public String toString() {
		return "User [id=" + id + ", uname=" + uname + ", password=" + password + "]";
	}
}

mapper层 BookMapper.java

import java.util.List;
import org.springframework.stereotype.Repository;
import cn.itcast.pojo.Book;
@Repository
public interface BookMapper {
	public List getAllBooks();
	
	public List queryByBookid(int bookid);
	public List queryByName(String name);
	
	public int addBook(Book book);
	public int deleteBook(int bookid);
	public int updateBook(Book book);
}

BookMapper.xml

	
	
		select * from book
	

	
	
		select * from book where bookid=#{_parameter}
	

	
	
		select * from book where name like concat('%',#{_parameter},'%')
	

	
	
		insert into book(name,price) values(#{name},#{price})
	

	
	
		delete from book where
		bookid=#{_parameter}
	

	
	
		update book set
		name=#{name},price=#{price} where bookid=#{bookid}
	

 
UserMapper.java 
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import cn.itcast.pojo.User;
@Repository
public interface UserMapper {
	User loginCheck(@Param("uname")String uname,@Param("password")String password);
	int registerCheck(User user);
}
 
UserMapper.xml 



	
		select * from usertab
	
	
	
		select * from usertab where uname =#{uname} and password=#{password}
	
	
	
		insert into usertab(uid,uname,password) values(0,#{uname},#{password});
	

service层 BookService.java

import java.util.List;
import cn.itcast.pojo.Book;

public interface BookService {
	public List getAllBooks();
	
	public List queryByBookid(int bookid);
	public List queryByName(String name);
	
	public int addBook(Book book);
	public int deleteBook(int bookid);
	public int updateBook(Book book);
}

BookService.java

package cn.itcast.service;

import java.util.List;
import cn.itcast.pojo.Book;

public interface BookService {
	public List getAllBooks();
	
	public List queryByBookid(int bookid);
	public List queryByName(String name);
	
	public int addBook(Book book);
	public int deleteBook(int bookid);
	public int updateBook(Book book);
}

BookServiceImpl.java

import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import cn.itcast.mapper.BookMapper;
import cn.itcast.pojo.Book;
@Service
public class BookServiceImpl implements BookService {
	@Autowired
	BookMapper bookMapper;
	
	@Override
	public List getAllBooks() {
		return bookMapper.getAllBooks();
	}
	@Override
	public List queryByBookid(int bookid) {
		return bookMapper.queryByBookid(bookid);
	}
	@Override
	public List queryByName(String name) {
		return bookMapper.queryByName(name);
	}

	@Override
	public int addBook(Book book) {
		return bookMapper.addBook(book);
	}

	@Override
	public int deleteBook(int bookid) {
		return bookMapper.deleteBook(bookid);
	}

	@Override
	public int updateBook(Book book) {
		return bookMapper.updateBook(book);
	}
}

UserService.java

import cn.itcast.pojo.User;

public interface UserService {
	User loginCheck(String uname,String password);
	int registerCheck(User user);
}

UserServiceImpl.java

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import cn.itcast.mapper.UserMapper;
import cn.itcast.pojo.User;
@Service
public class UserServiceImpl implements UserService {

	@Autowired
	private UserMapper userMapper;

	@Override
	public int registerCheck(User user) {
		return userMapper.registerCheck(user);
	}

	@Override
	public User loginCheck(String uname, String password) {
		return userMapper.loginCheck(uname, password);
	}
}

控制层 UserController.java

package cn.itcast.controller;


import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import cn.itcast.pojo.User;
import cn.itcast.service.UserService;
@Controller
@RequestMapping("/user")
public class UserController{
	@Autowired
	private UserService userService;
	@RequestMapping("/loginCheck")
	public String checkLogin(HttpServletRequest req,String uname,String password) {
		
		System.out.println("uname:"+uname);
		System.out.println("password:"+password);
		User user = userService.loginCheck(uname,password);
		System.out.println(user);
		HttpSession session=req.getSession();
		session.setAttribute("u", user.getUname());
		return "redirect:/book/getAllBook";
//		return "forward:/book/getAllBook";
	}
	@RequestMapping("/register")
	public String register(User u) {
		int result=userService.registerCheck(u);
		System.out.println("result"+result);
		return "/registerSuccess";
	}
}

BookController.java

package cn.itcast.controller;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;

import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;

import cn.itcast.pojo.Book;
import cn.itcast.service.BookService;

@Controller
@RequestMapping("/book")
public class BookController {
	@Autowired
	BookService bookService;

	@RequestMapping("/queryByBookid")
	public String queryBook(int bookid, Model model,@RequestParam(defaultValue = "1") int pageNum,
			@RequestParam(defaultValue = "4") int pageSize) {
		if (pageNum == 0)
			pageNum = 1;
		PageHelper.startPage(pageNum, pageSize);// 开始分页，pageNum表示当前第几页，pageSize表示每页显示几条记录
		List book = bookService.queryByBookid(bookid);
		
		PageInfo p = new PageInfo(book);// 封装了分页后的信息
		model.addAttribute("booklist", book);
		model.addAttribute("pageinfo", p);
		model.addAttribute("bookid", bookid);

		return "queryInfoById";
	}

	@RequestMapping("/queryByBookName")
	public String queryByName(String name, Model model, @RequestParam(defaultValue = "1") int pageNum,
			@RequestParam(defaultValue = "4") int pageSize) {
	
		System.out.println("name:"+name);
		if (pageNum == 0)
			pageNum = 1;
		PageHelper.startPage(pageNum, pageSize);// 开始分页，pageNum表示当前第几页，pageSize表示每页显示几条记录
		List book = bookService.queryByName(name);// 查询所有用户的信息

		PageInfo p = new PageInfo(book);// 封装了分页后的信息
		model.addAttribute("booklist", book);
		model.addAttribute("pageinfo", p);
		model.addAttribute("name", name);
		return "queryInfoByName";
	}
	@RequestMapping("/getAllBook")
	public String getAllBook(Model model, @RequestParam(defaultValue = "1") int pageNum,
			@RequestParam(defaultValue = "4") int pageSize) {
		PageHelper.startPage(pageNum, pageSize);// 开始分页，pageNum表示当前第几页，pageSize表示每页显示几条记录
		List book = bookService.getAllBooks();// 查询所有用户的信息

		PageInfo p = new PageInfo(book);// 封装了分页后的信息
		model.addAttribute("booklist", book);
		model.addAttribute("pageinfo", p);
		System.out.println("信息："+p);
		return "bookInfo";
	}

	@RequestMapping("/toAddBook")
	public String toAddBook() {/// 跳转到添加用户界面
		return "addBook";
	}
	@RequestMapping("/addBook")
	public String addBook(Book book) {/// 执行添加用户的功能
		int result=bookService.addBook(book);
		if(result>0) {
			return "forward:getAllBook";
		}else {
			return "error";
		}
	}
	@RequestMapping("/deleteBook")
	public String deleteBook(int bookid) {
		int result=bookService.deleteBook(bookid);
		if(result>0) {
			return "forward:getAllBook";
		}else {
			return "error";
		}
	}
	@RequestMapping("/toUpdateBook")
	public String toUpdateBook() {/// 跳转到修改用户界面
		return "updateBook";
	}
	@RequestMapping("/updateBook")
	public String updateUser(Book book) {
		int result=bookService.updateBook(book);
		if(result>0) {
			return "forward:getAllBook";
		}else {
			return "error";
		}
	}
}

jsp addBook.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>







	
		

			书名：
 价格：
 

		
	

bookInfo.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>








欢迎你，<%=session.getAttribute("u") %>

	

		
		
		添加
	


	
	

		
		
	



	
			
				
				
					

		

			
编号
			
书名
			
价格
			
操作
		
		
没有查到相关信息！
			
			

						
${x.bookid}
						
${x.name}
						
${x.price}
					
						
修改/删除
  
					
					
			
		
	
	第${pageinfo.pageNum }页/共${pageinfo.pages}页

	上一页
	
		${y}
	
		下一页
	

updateBook.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>







	
		

			编号：" readonly="readonly" />

			书名：
 价格：

			
 

		
	

queryInfoById.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>











	
			
				
				
					

		

			
书编号
			
书名
			
价格
			
操作
		

		
没有查到相关信息！
			
			

						
${x.bookid}
						
${x.name}
						
${x.price}
					
						
修改/删除
  
					
					
			
		
	
	
	第${pageinfo.pageNum }页/共${pageinfo.pages }页

	上一页
	
		${y}
	
	下一页
	

queryInfoByName.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>











	
			
				
				
					

		

			
书编号
			
书名
			
价格
			
操作
		
		
没有查到相关信息！
			
			

						
${x.bookid}
						
${x.name}
						
${x.price}
					
						
修改/删除
  
					
					
			
		
	
	
	第${pageinfo.pageNum }页/共${pageinfo.pages }页

	上一页
	
		${y}
	
	下一页
	

总结

奋斗的青春最美丽！希望期末javaEE一遍过！加油！