第6个练习 卡片管理系统(SSM框架)

第6个练习的记录

 

效果图1

 

效果图2

 

 

效果图3

 

效果图4

 

效果图5

 

效果图6

 

效果图7 卡组页面

 

效果图8 二级联动下的增删改查

 

效果图9 图书管理页面

 

效果图10 上传图片功能

 

项目列表1

 

 

项目列表2

 

MVC三层

Controller层

package shanhai.controller;

import java.io.UnsupportedEncodingException;
import java.util.HashMap;
import java.util.Map;

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

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.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;

import shanhai.pojo.Card;
import shanhai.pojo.Logininfo;
import shanhai.pojo.QueryVo;
import shanhai.pojo.User;
import shanhai.service.CardService;
import utils.Page;

@Controller
public class CardController {
    @Autowired
    private CardService c;
//    HttpServletRequest request;
//    HttpServletResponse response;
    
    @RequestMapping(value = "/card/list")                        // 分页
    public String list(QueryVo vo,Model model) throws UnsupportedEncodingException{
        
        Page<Card> page = c.selectPageByQueryVo(vo);              // 条件查询
        
        int currentPage_number = page.getPage();                // 当前页数,
        if(currentPage_number < 1) {currentPage_number = 1;}    // 条件查询后为0,要设置成1 
        
        int total = page.getTotal();                            // 总记录数
        int size = page.getSize();                                // 每页显示条数
        int tP = (int) Math.ceil(total/size);                    // 总页数tP,向上取整
        if(true){tP+=1;}                                        // 比实际值要少1,所以要+1
        
        model.addAttribute("page", page);
        model.addAttribute("Total_number", total);
        model.addAttribute("totalPage_number", tP);
        model.addAttribute("currentPage_number", currentPage_number);
        model.addAttribute("Size_number", size);
        
        model.addAttribute("Name", vo.getName());    
        model.addAttribute("Race", vo.getRace());
        
        return "card";
        
    }
    
    @RequestMapping(value = "/card/add.action",method=RequestMethod.POST)            
    public String Edit(Card card,Model model){                // 添加数据
        c.addCard(card);
        return "card";
    }
    
    @RequestMapping(value = "/card/showFormCard.action",method=RequestMethod.POST)    
    public @ResponseBody
    Card showFormCard(Integer id,Model model){                // id查询
        return c.showFormCard(id);    
    }
    
    @RequestMapping(value = "/card/modalUpdateSubmit.action")    
    public @ResponseBody                
    String updateSubmit(Card card,Model model){                // 修改数据    
        c.updateSubmit(card);
        return "OK";
    }
    
    @RequestMapping(value = "/card/delete.action")    
    public @ResponseBody                
    String deleteAjax(Integer id,Model model){                // 删除数据    
        c.deleteAjax(id);
        return "OK";
    }
    
    
    @RequestMapping(value = "/user/login.action",method=RequestMethod.GET)
    public String intoLogin(){                                // 进入登录的jsp页面    
        return "login";                                        
    }
    
    @RequestMapping(value = "/user/userLogin.action")        // 接收用户登录的信息    
    public String userlogin(User user,Model model,HttpSession session,
            String rememberme,String remembermePassword, String autoLogin,
            HttpServletRequest request, HttpServletResponse response) 
            throws UnsupportedEncodingException{    
        boolean s = c.userLogin(user);            // 如果用户信息存在,值为true  即登录成功,反之失败
        String loginUser = user.getUsername();    // 从接收参数上取用户名  虽密码错误,但要重进登录ye
        
        String logintime = c.logintime(user);                // 2 上次访问时间 
        int loginNumber = c.loginNumber(user);                // 12 历史登录次数
        
        User myProfileUser = c.myProfileName(user);            // 我的资料 显示名称(非用户名)
//        System.out.println("登录时,db查询,是个对象,而非str: " + myProfileUser);  //若get则空指针
        
        String usernameOfIfelse = null;                // 7 判断从db中查询到的结果是否为null  
        if(c.getUsername(loginUser)==null) {        // 从db获取用户名,若为空则进入错误提示
            usernameOfIfelse ="db查询结果为null,若获得用户名则空指针";
        } else{
            usernameOfIfelse = user.getUsername();  
        }
        
        // 14 记住用户名  通过形参rememberme传递
//        System.out.println("记住用户名时传递的input值 " + rememberme);
//        remembermeUserName(user,rememberme,request,response);
        
        // 16 记住用户名和密码
//        System.out.println("记住用户名和密码时,传递的input值: " + remembermePassword);
        remembermePassword(user,remembermePassword,request,response);
        
        if(s){                                                        // 若用户信息存在,登录成功
            session.setAttribute("logintime", logintime);            // 上次登录时间
            session.setAttribute("loginNumber", loginNumber);         // 历史登录次数(算本次)
            session.setAttribute("loginUserName",loginUser);        //  myProfileUserName
            session.setAttribute("myProfileUser", myProfileUser);    // 显示在我的资料页面
            session.setAttribute("newMy", myProfileUser.getMy());    // 第一次进入我的资料页面显示个性签名
            return "forward:/user/loginSuccess";                    // 设session,进登录成功的ye
        } else 
            // 7 在这里判断,虽然登录失败了,但是否是用户名正确,密码错了的情况?若是,则进入登录页面
            if(loginUser == usernameOfIfelse){    // 登录的用户名和查询的结果(已除去空指针)相等  
            session.setAttribute("UsePasswordError", 
                    "用户名正确,但密码错误,请检查用户名和密码,并重新输入");
            return "redirect:/user/login.action";                // 重新进入登录ye
            } else {
                // 6 登录失败时,提示信息
                session.setAttribute("loginFailure", "用户登录失败,请注册");      
                return "redirect:/user/toRegister.action";        // 重定向到新的方法,去注册    
            }
    }
    
    // 14 记住用户名,在登录的方法之中再调用的()
    /*public void remembermeUserName(User user,String rememberme) 
        throws UnsupportedEncodingException {
        
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");
            
        if("1".equals(rememberme)){            // rememberme有空指针的可能性  由数字改为str即无
//            System.out.println("记住用户名: " + rememberme);
            Cookie remembermeCookie = new Cookie("remembermeCookie",user.getUsername());
            remembermeCookie.setPath("/");
            remembermeCookie.setMaxAge(60*60*24*7);
            response.addCookie(remembermeCookie);
        } else if(rememberme == null){    
            // 当没有勾选"记住用户名"时,要清理掉上次可能保存下来的用户名
            Cookie remembermeCookie = new Cookie("remembermeCookie",user.getUsername());
            remembermeCookie.setPath("/");
            remembermeCookie.setMaxAge(0);
            response.addCookie(remembermeCookie);
        }
        
    } */// 14 记住用户名  登录的方法中再调用的()
    
    // 16 记住用户名和密码,在登录的方法中再调用的()
    void remembermePassword(User user,String remembermePassword,
            HttpServletRequest request, HttpServletResponse response) 
        throws UnsupportedEncodingException {        
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");
        
//        System.out.println("记住用户名和密码: " + remembermePassword);
        if("1".equals(remembermePassword)){            
            Cookie remembermeCookie = new Cookie(
                    "remembermeCookie",user.getUsername());
            remembermeCookie.setPath("/");
            remembermeCookie.setMaxAge(60*60*24*7);
            response.addCookie(remembermeCookie);          // 往cookie中存入用户名
            
            Cookie remembermeCookiePassword = new Cookie(
                    "remembermeCookiePassword",user.getPassword());
            remembermeCookiePassword.setPath("/");
            remembermeCookiePassword.setMaxAge(60*60*24*7);
            response.addCookie(remembermeCookiePassword);        // 往cookie中存入密码
            
//            System.out.println(user.getUsername() + ":" +user.getPassword());
            
        } else if(remembermePassword == null){    
            // 未勾选"记住用户名和密码"时,要清理掉上次可能保存下来的密码,用户名!!!
            
            Cookie remembermeCookie = new Cookie(
                    "remembermeCookie",user.getPassword());
            remembermeCookie.setPath("/");
            remembermeCookie.setMaxAge(0);
            response.addCookie(remembermeCookie);                    // 未勾选时,清除密码
            
            Cookie remembermeCookiePassword = new Cookie(
                    "remembermeCookiePassword",user.getPassword());
            remembermeCookiePassword.setPath("/");
            remembermeCookiePassword.setMaxAge(0);
            response.addCookie(remembermeCookiePassword);            // 未勾选时,清除密码
        }
    }
    
    @RequestMapping(value = "/user/loginSuccess")
    public String LoginSuccess(User user, Model model){            // 进入登录成功的页面
        return "LoginSuccess";                                
    }
    
    @RequestMapping(value = "/user/homepage.action")        
    public String homepage(User user,Model model) {                // 登录成功的页面进入主页面
        return "redirect:/card/list";                
    }
    
    @RequestMapping("/user/toRegister.action")                    // 进注册的ye    
    public String toRegisterJsp(HttpSession session) {            // 方式一,注册链接,二登录失败时
        return "register";    
    }
    
    @RequestMapping(value = "/user/register.action")    
    public String userRegister (User user,Model model){        // 查询用户信息不一致时,去注册页面
        c.userRegister(user);                                  // 假设数据格式正确,所以不用返回值
        return "redirect:/user/login.action";    
    }
    
    @RequestMapping(value = "/user/logOut.action")
    public String logOut(HttpSession session) {                // 暂时不考虑Cookie,当有时则要删除
        session.removeAttribute("loginUserName");            // 从session中将user删除
        return "redirect:/card/list";
    }
    
    @RequestMapping(value = "user/ajaxUserName.action") 
    public @ResponseBody 
    Map<String,Object> ajaxUserName(String username,Model model) {    // 校验用户名是否可以注册
        
        Map<String,Object> resultMap = new HashMap<String, Object>();
        boolean isExist = c.ajaxUserName(username);                    // 用户不存在时,false
        
        resultMap.put("isExist", isExist);
        return resultMap;
    }
    
    @RequestMapping(value = "/user/myProfile.action")        
    public String myProfile (Model model){                    //     查看我的资料中的用户名
        return "myProfile";                                    // 进入 我的资料页面
    }
    
    @RequestMapping(value = "/user/updateMyProfile.action")                // 更新我的资料
    public String updateMyProfile (String loginUserName,String myProfileName,
            String my ,String userInfo,Model model,HttpSession session){            
//        System.out.println("长文本提交的用户信息: " + userInfo);
        
        c.updateMyProfile(loginUserName,myProfileName,my,userInfo);        // 通过用户名改名称
        
        // 由于修改input后,重定向到我的资料,值还是原值,所以下4行代码解决这个问题
        // 修改成功后,显示的是原值,虽然数据表已经更新,我在我的资料页面中input中三元运算符判断了
        
        // 需要更新后的用户,用于显示     
        User u = c.updateShow(loginUserName,myProfileName,my,userInfo);  
        session.setAttribute("newUpdate", u.getName());     // 在我的资料ye中显示修改后的名称
        session.setAttribute("newMy", u.getMy());
        session.setAttribute("newUserInfo", u.getUserInfo());
        
        return "redirect:/user/myProfile.action";                                
    }
    
    @RequestMapping(value = "/baidu.action")
    public String baidu() {                                      // 进入百度一下的主页的方式1
        return "redirect:http://www.baidu.com";
    }
    
    @RequestMapping(value = "/user/UpdatePassword.action",
            produces = "text/html;charset=UTF-8")                // 4 据用户名修改密码 修改版
    public @ResponseBody
        String updatePassword(String usernameUpdatePassword, String password1,
                String password2,String updatePassword) {      // 目前接收session值的方式    
        
        // 如果我们不希望抛出500错误页面，但仍需要进行事务回滚
        // 那么我们就要在controller中将service实现类抛出的异常捕获
        try {
            boolean b = c.updatePassword(usernameUpdatePassword,password1,
                    password2,updatePassword);
            return "修改密码成功";
        } catch (Exception e) {            //  如果捕获了异常，说明修改密码失败
            return "修改密码失败";
        }
        
    }
    
    @RequestMapping(value = "user/securityQuestion.action"
            ,produces = "text/html;charset=UTF-8")
    public @ResponseBody String security_Question(Logininfo logininfo){        // 8 设置密保问题
        c.sQ(logininfo);
        
        return "目前默认修改成功";
    }
    
    @RequestMapping(value = "/user/toForGet.action")
    public String forGetPassword() {                        // 9 忘记密码
        return "sQJSP";                                        // 进入,忘记密码时,重设密码的页面
        
    }
    
    /*@RequestMapping(value = "/user/toSQ.action",produces = "text/html;charset=UTF-8") 
    public @ResponseBody 
        String toSQ(Logininfo logininfo) {                    // 9 忘记密码,重设后的密码提交到此
        // 如果我们不希望抛出500错误页面，但仍需要进行事务回滚
        // 那么我们就要在controller中将service实现类抛出的异常捕获
        try {
            boolean b = c.forGetPassword(logininfo);
            return "通过密保问题修改密码成功";
        } catch (Exception e) {
            return "密保问题修改密码失败,已经通过事务回滚";    // 如果捕获了异常，说明修改密码失败
        }
    }*/
    
    @RequestMapping(value = "/user/toSQ.action") 
    // 9 忘记密码,进行密保问题答案的验证
    public String toSQ(Logininfo logininfo,HttpSession session) {                
        // 如果我们不希望抛出500错误页面，但仍需要进行事务回滚
        // 那么我们就要在controller中将service实现类抛出的异常捕获
        try {
            boolean b = c.forGetPassword(logininfo);
            session.setAttribute("sQusername", logininfo.getUsername());
            return "sqPassword";
        } catch (Exception e) {
            return "login";    // 如果捕获了异常，说明修改密码失败
        }
    }
    
    @RequestMapping(value = "user/sQUpdatePassword.action")
    public String tosQ(String sQusername, String sQupdatePassword){      // 9 密保问题验证,设密码
        c.sQUpdatePassword(sQusername,sQupdatePassword);              // 重设后的密码提交到此
        return "redirect:/user/login.action";
    }

/*    @RequestMapping(value = "/card/.action")        // 路径 
    public @ResponseBody                            // 返回json注解                
    String method (Model model){                    // 形参,mode往前台传值            
        // 调用service层接口  c.方法名(形参);
        model.addAttribute("", );
        return "forward:/user/";                    // 转发
        return "redirect:/card/list";                // 重定向
        return "card";                                // 进入card.jsp
        return "OK";                                // ?
    }
*/
    
    
/*    @RequestMapping(value = "/baidu.action")
    public void baidu(HttpServletResponse response) throws IOException {
        response.sendRedirect("https://www.baidu.com");        // 进入百度一下的主页的方式2
    } */
    
}

package shanhai.controller;

import java.sql.Date;
import java.util.List;

import javax.servlet.http.HttpSession;

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.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;

import shanhai.pojo.Books;
import shanhai.pojo.Card;
import shanhai.pojo.magic_trapCard;
import shanhai.service.DeckService;

@Controller
public class DeckController {
    
    @Autowired
    private DeckService c;
    
    // 38 查询当前月份的书籍            
    @RequestMapping(value = "/readingDateQuery.html",params={"Query136"},
            method=RequestMethod.GET)
    public String ReadingDateQuery136(Integer Query136,HttpSession session){
//        System.out.println(Query136);
        List<Books> BookList = c.ReadingDateQuery136(Query136);
        session.setAttribute("BookList", BookList);
        
        return "book";
    }
    
    /*@RequestMapping(value = "/deck/BookReadingDateQuery136")        // 38 查询当前月份的书籍            
    public String ReadingDateQuery136(Integer Query136, HttpSession session){
        
        List<Books> BookList = c.ReadingDateQuery136(Query136);
        session.setAttribute("BookList", BookList);
        
        return "book";
    }*/
    
    @RequestMapping(value = "/deck/BookReadingDateQuery")            // 38 书籍据时间段查询            
    public String ReadingDateQuery(Date startDateQuery,Date endDateQuery,
            HttpSession session){
        List<Books> BookList = null;
        
        BookList = c.ReadingDateQuery(startDateQuery,endDateQuery);
        
        session.setAttribute("BookList", BookList);
        
        return "book";
    }
    
    @RequestMapping(value = "/deck/deletesMagicTrap")            // 35 批量删除魔陷
    public String deletesMagicTrap(Integer[] ids,String deletesCardId,
            HttpSession session){        
        String str = deletesCardId.substring(0, deletesCardId.indexOf(","));  // 截取,前的部分
        
        if(ids != null && ids.length != 0){
            /*for (Integer integer : ids) {
                System.out.println("批量删除魔陷时,提交的id数组为: " + integer);
            }*/
            c.deletesMagicTrap(ids,str);
        }
        
//        List<magic_trapCard> magic_trapList = c.magic_trapOption(magic_trapOne,magic_trapTwo);
//        session.setAttribute("magic_trapList", magic_trapList);
        
//        return "magic_trapDeck";
//        return "redirect:/deck/magic_trapList";        // 重定向到,进入菜单-魔陷
//        return "forward:/deck/magic_trapList";        // 转发到,进入 菜单-魔陷
//        return "forward:/deck/magic_trapOption";    // 转发到,进入 列表联动
        
        // 36 为了显示出操作后的页面效果,所以在这里利用str查询db
        List<magic_trapCard> magic_trapList = c.magic_trapOptionStr(str);
        session.setAttribute("magic_trapList", magic_trapList);
        return "magic_trapDeck";
    }
    
    @RequestMapping(value = "/deck/deleteMagicTrap")    
    public @ResponseBody                
    String deleteMagicTrap(Integer magicTrapId,String cardType,Model model){    // 34 单次删除
        c.deleteMagicTrap(magicTrapId,cardType);
        return "OK";
    }
    
    @RequestMapping(value = "/deck/modalUpdateSubmitMagicTrap")    
    public @ResponseBody                
    String updateSubmitMagicTrap(magic_trapCard mt,Model model){    // 33魔陷修改 模态框提交的修改的值    
        c.updateSubmitMagicTrap(mt);
        return "OK";
    }
    
    @RequestMapping(value = "/deck/showFormMagicTrap")    
    public @ResponseBody
    // 32 魔陷  模态框显示魔陷卡信息,查询    修改魔限卡时,提交的ID为magicTrapId,类型为cardType
    magic_trapCard showFormMagic_trap(Integer magicTrapId,String cardType,Model model){        
        // 二级联动 据ID查询的魔限卡信息为:
        magic_trapCard mt = c.showFormMagicTrap(magicTrapId,cardType);    
        return mt;
    }
    
    @RequestMapping(value = "/deck/addMagic_trap")            
    public String Magic_trap(magic_trapCard mt,Model model){                // 31 添加魔陷
        c.addMagic_trap(mt);
        return "magic_trapDeck";
    }
    
    
    @RequestMapping(value = "/deck/deletesBook.action",method=RequestMethod.POST)    
    public String deletesBook(Integer[] ids,HttpSession session){            // 27 批量删除书籍
        if(ids != null && ids.length != 0){
            /*for (Integer integer : ids) {
                System.out.println("批量删除书籍时,提交的id数组为: " + integer);
            }*/
            c.deletesBook(ids);
        }
        
        List<Books> BookList = c.BookList();             // 23 菜单 书籍再查询一遍db中的书籍列表
        session.setAttribute("BookList", BookList);
        
        return "book";
    }
    
    @RequestMapping(value = "/deck/deleteBook.action")    
    public @ResponseBody                
    String deleteBook(Integer id,Model model){                // 26 删除书籍
        c.deleteBook(id);
        return "OK";
    }
    
    @RequestMapping(value = "/deck/modalUpdateSubmitBook.action")    
    public @ResponseBody                
    String updateSubmitBook(Books books,Model model){    // 25 书籍修改 模态框提交的修改的值    
        c.updateSubmitBook(books);
        return "OK";
    }
    
    @RequestMapping(value = "/deck/showFormBook.action")    
    public @ResponseBody                                
    Books showFormBook(Integer id,Model model){        // 25 书籍修改  模态框显示书籍信息,查询
        return     c.showFormBook(id);                    // 查询到的书籍信息,id修改书籍时,提交的书名
    }
    
    @RequestMapping(value = "/deck/addBook.action")            
    public String addBook(Books books,Model model){                // 24 添加书籍
        c.addBook(books);
        return "book";
    }
    
    @RequestMapping(value = "/book/list")
    public String MenuBook(HttpSession session) {
        List<Books> BookList = c.BookList();                             // 23 菜单 书籍
        session.setAttribute("BookList", BookList);
        return "book";
    }
    
    @RequestMapping(value = "/deck/magic_trapOption")                    // 22 魔陷卡组列表
    public String magic_trapOption(String magic_trapOne,String magic_trapTwo,
            HttpSession session) {                                        // 形参为两个列表提交
        List<magic_trapCard> magic_trapList = c.magic_trapOption(magic_trapOne,magic_trapTwo);
        
        session.setAttribute("magic_trapList", magic_trapList);
        return "magic_trapDeck";
    }
    
    @RequestMapping(value = "/deck/magic_trapList")                        // 22 菜单新增魔陷卡组
    public String magic_trapDeck() {
        return "magic_trapDeck";
    }
    
    @RequestMapping(value = "deck/list")
    public String deck(String deckOne, String deckTwo,String deckInfo,
            HttpSession session) {                    // 17 卡组联动 参数:第一分类,第二分类
        List<Card> SelectDeckList = c.selectDeck(deckOne,deckTwo);                                        // 17 补全
        
        String newDeckInfo = c.deckInfo(deckOne,deckTwo);                    // 19 卡组信息
        
        session.setAttribute("deckIdList",SelectDeckList);
        session.setAttribute("deckInfo",newDeckInfo);
        
        return "deck";
    }
    
    /*@RequestMapping(value = "deck/list")
    public String deck(Integer deckId, HttpSession session) {            // 13 选择卡组
        System.out.println("接收到的选择的卡组ID为: " + deckId);
        
        List<Card> SelectDeckList = c.deckId(deckId);
//        System.out.println("据列表提交的值,从db中查询到的卡组,遍历结果为: " + SelectDeckList);
        
        if(SelectDeckList == null) {
            System.out.println("结果为null");
        } else {
            for (Card card : SelectDeckList) {
                System.out.println(card);        // 据列表提交的值,db中查询到的卡组,遍历结果
            }
        }
        
        session.setAttribute("deckIdList",SelectDeckList);
        return "deck";
    }*/
    

/*    @RequestMapping(value = "/card/.action")        // 路径 
public @ResponseBody                            // 返回json注解                
String method (Model model){                    // 形参,mode往前台传值            
    // 调用service层接口  c.方法名(形参);
    model.addAttribute("", );
    return "forward:/user/";                    // 转发
    return "redirect:/card/list";                // 重定向
    return "card";                                // 进入card.jsp
    return "OK";                                // ?
}
*/
    
}    // DeckController类的结束    

package shanhai.controller;

import java.io.File;
import java.util.List;
import java.util.UUID;

import javax.servlet.http.HttpSession;

import org.apache.commons.io.FilenameUtils;
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.RequestMethod;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.servlet.ModelAndView;

import shanhai.pojo.Picture;
import shanhai.service.PictureService;

@Controller
@RequestMapping(value ="/picture")
public class PictureController {

    @Autowired
    private PictureService cP;

    @RequestMapping(value = "/list")                    // 新增 查看图片列表
    public ModelAndView methodPicture (HttpSession session,Model model){
        // 根据数据表中存储的名称,查看本地磁盘中的图片
        List<Picture> pictureList = cP.queryAll();

        /*for (Picture a : pictureList) {
            System.out.println("list中的图片类的名称为: " + a.getPicName());
        }*/
        
        ModelAndView mav = new ModelAndView();
        mav.addObject("pictureList", pictureList);
        mav.setViewName("picture");
        return mav;                                
    }
    
    @RequestMapping(value = "/picture2",method=RequestMethod.POST)
    // 形参名称要和form中的nmae相同
    public String updateitem(MultipartFile pictureFile) throws Exception{
        // 假设接收到的图片名称是1
        
        // 保存图片到 
        // 为了处理出现重名现象, 将原始文件名去掉,通过UUID算法生成新的文件名
        String name = UUID.randomUUID().toString().replaceAll("-", "");
        
        // jpg
        String ext = FilenameUtils.getExtension(pictureFile.getOriginalFilename());
            
        // 指定带盘符的路径,物理路径
        pictureFile.transferTo(new File("D:\\upload\\" + name + "." + ext));
        
        String picName = new String(name + "." + ext);
        
        cP.addPicName(picName);        // 在数据表中保存图片的名称
        
        return "redirect:/picture/pictureShow.action?picName=" + picName;
    }    

    @RequestMapping(value = "/pictureShow.action")         
    public ModelAndView show1 (String picName,HttpSession session,Model model){    
        
        ModelAndView mav = new ModelAndView();
        mav.addObject("picName", picName);                // 接收到的licName值
        mav.setViewName("picture");
        return mav;
    }
    
    /*@RequestMapping(value = "/picture/video/list")     // 已使用多请求路径,请注意
    public String showVideo() {                            // 显示静态资源的视频
        return "video";
    }*/
    
    /* @RequestMapping(value = "/card/.action")         
    public @ResponseBody                                        
    String method (Model model){                                
        // 调用service层接口  c.方法名(形参);
        model.addAttribute("", );
        return "forward:/user/";                    
        return "redirect:/card/list";                
        return "card";                                
    }
    */
}

 

Tomcat的配置

 

package shanhai.controller;

import java.util.List;

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.ui.Model;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;

import shanhai.pojo.UserTest;

@Controller
public class TestController {
    
    @Autowired
    HttpServletRequest request;
    
    @RequestMapping(value="/test/Test53",method=RequestMethod.POST)
    public @ResponseBody UserTest requestBody53(                        // 53 写注释
            @RequestBody List<UserTest> usertestList){
        
        System.out.println(usertestList);
        
        UserTest uT = usertestList.get(2);
        System.out.println("List中取出第三个对象: " + uT);
        
        for(UserTest u : usertestList){
            System.out.println("姓名:" + u.getUserName() +"," + 
                        "密码:" + u.getPassWord()+
                        "别称:" + u.getName());
        }
        
        return uT;
    }
    
    @ResponseBody
    @RequestMapping(value="/test/requestBodyTest52.action",method=RequestMethod.POST)
//    public String requestBody52(@RequestBody BillForm billForm ,Model model){
        public String requestBody52(Model model){
        System.out.println("进入test52");                    // 52 测试接收对象+List 失败
        
        return "ok";
    }
    
    // 51 尝试 c层向ajax传递List类型的对象
    @RequestMapping(value="/test/requestBodyTest51.action",method=RequestMethod.POST)
    public @ResponseBody UserTest requestBody51(@RequestBody List<UserTest> usertestList ,Model model){
        
        System.out.println(usertestList);
        
        UserTest uT = usertestList.get(0);
        System.out.println("List中取出第一个对象: " + uT);
        
        for(UserTest u : usertestList){
            System.out.println("姓名:" + u.getUserName() +"," + "密码:" + u.getPassWord());
        }
        
        return uT;
    }
    
    // 50 c层向ajax传递单个java对象,已经成功
    @RequestMapping(value="/test/requestBodyTest50.action",method=RequestMethod.POST)
    public @ResponseBody UserTest requestBody50(@RequestBody List<UserTest> usertestList ,Model model){
        
        System.out.println(usertestList);
        
        UserTest uT = usertestList.get(0);
        System.out.println("List中取出第一个对象: " + uT);
        
        for(UserTest u : usertestList){
            System.out.println("姓名:" + u.getUserName() +"," + "密码:" + u.getPassWord());
        }
        
        return uT;
    }
    
    // 49 传递List的json数据  给c层
    @ResponseBody
    @RequestMapping(value="/test/requestBodyTest49.action",method=RequestMethod.POST)
    public String requestBody49(@RequestBody List<UserTest> usertestList ,Model model){
        
        System.out.println(usertestList);
        
//        UserTest uT = usertestList.get(0);
//        System.out.println("List中取出第一个对象: " + uT);
        
        for(UserTest u : usertestList){
            System.out.println("姓名:" + u.getUserName() +"," + "密码:" + u.getPassWord());
        }
        
        return "ok";
    }
    
    @RequestMapping(value="/test/requestBodyTest48.action")        // 48@RequestBody,未收到值
    public @ResponseBody 
    UserTest requestBody48(@RequestBody UserTest usertest,Model model){
//    UserTest requestBody48(String userNmae,String passWord){    // 普通的方式可以传递
        System.out.println("进入@RequestBody测试的方法中");
        System.out.println(usertest);
        
        return usertest;                    
    }
    
    @RequestMapping(value="/test/requestParam.html")            // 47@RequestParam
    public String getRequestParam(@RequestParam("name") String name){        
        System.out.println("name值为: " + name);                    // 前端须有对应的名称
        return "testJSP";
    }
    
    @RequestMapping(value="/test/params/{id}")            // 46@PathVariable
    public String getParams(@PathVariable int id){        // 如果接收的参数和形参一致,直接注解即可
        System.out.println("id值为: " + id);
        return "testJSP";
    }
    
    /*@RequestMapping(value="/test/params/{id}")            // 46@PathVariable
    public String getParams(@PathVariable("id") int idValue){    // 如果id和idValue不一致,需别名
        System.out.println("id值为: " + idValue);
        return "testJSP";
    }*/
    
    @RequestMapping(value="/test/into")            // 43 自动注入
    public String intoTest(){                    // 进入测试用的jsp页面
        return "testJSP";
    }
    
    @RequestMapping(value={"/test/session","/test/getSession"})
    public String getSession(){                    // 在测试ye中,点链接,在控制台获得session中的值
        HttpSession httpSession = request.getSession();
        System.out.println("deckInfo值为: " + httpSession.getAttribute("deckInfo"));
        System.out.println(httpSession);
        
        return"testJSP";
    }
    
}

 

Service层

package shanhai.service;

import java.util.List;

import shanhai.pojo.Card;
import shanhai.pojo.Logininfo;
import shanhai.pojo.QueryVo;
import shanhai.pojo.User;
import utils.Page;

public interface CardService {
    public List<Card> selectList();                            // 查询所有
    public void addCard(Card card);                            // 添加数据
    public Card showFormCard(int id);                        // id查询
    public void updateSubmit(Card card);                    // 修改数据
    public void deleteAjax(Integer id);                        // 删除数据
    public Page<Card> selectPageByQueryVo(QueryVo vo);        // 分页按钮跳转
    public boolean userLogin(User user);                    // 用户登录
    public void userRegister(User user);                    // 注册用户
    public boolean ajaxUserName(String username);            // 校验用户名是否可以注册
    public User myProfileName(User user);                    // 我的资料 显示名称(非用户名)
    
    // 通过用户名修改名称   这里不受后续选择的方式1还是方式2的影响,返回只要一个结果
    public void updateMyProfile(String loginUserName, String myProfileName,
            String my,String userInfo);
    
    // 需要更新后的用户,用于显示
    public User updateShow(String loginUserName, String myProfileName,
            String my,String userInfo);
    
    // 修改用户密码  使用了事务
    public boolean updatePassword(String usernameUpdatePassword,String password1, 
            String password2, String updatePassword);

    public String logintime(User user);                        // 上次登录时间
    
    public String getUsername(String loginUser);            // 据用户名从db中查询用户信息
    
    public void sQ(Logininfo logininfo);                    // 8 密保问题
    
    public boolean forGetPassword(Logininfo logininfo);        // 9 忘记密码
    
    // 9 密保问题验证,设密码
    public void sQUpdatePassword(String sQusername, String sQupdatePassword);
    
    // 12 历史登录次数
    public int loginNumber(User user);    
    
}

package shanhai.service;

import java.util.Date;
import java.util.List;
import java.util.UUID;

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

import shanhai.mapper.CardDao;
import shanhai.pojo.Card;
import shanhai.pojo.Logininfo;
import shanhai.pojo.QueryVo;
import shanhai.pojo.User;
import utils.Page;

@Service
public class CardServiceImpl implements CardService {
    @Autowired
    private CardDao d;                            
    
    public List<Card> selectList() {                // 查询所有
        return d.selectList();
    }
    
    public void addCard(Card card) {                // 添加数据
        d.addCard(card);    
    }
    
    public Card showFormCard(int id) {                // id查询
        return d.showFormCard(id);
    }

    public void updateSubmit(Card card) {            // 修改数据
        d.updateSubmit(card);
    }
    
    public void deleteAjax(Integer id) {            // 删除数据
        d.deleteAjax(id);
    }

    public Page<Card> selectPageByQueryVo(QueryVo vo) {                   // 分页按钮跳,未条件查询
        Page<Card> page = new Page<Card>();
        page.setSize(5);    // 每页数
        vo.setSize(5);        
        if (null != vo) {
            if (null != vo.getPage()) {                                // 判断当前页 不能为空
                page.setPage(vo.getPage());
                vo.setStartRow((vo.getPage() -1)*vo.getSize());        // 算结果
            }
                
            if(null != vo.getName() && !"".equals(vo.getName().trim())){
                vo.setName(vo.getName().trim());
            }
            
            if(null != vo.getRace() && !"".equals(vo.getRace().trim())){    // 下拉列表的值
                vo.setRace(vo.getRace().trim());
            }
            if(null != vo.getRace() && !"".equals(vo.getRace().trim())){
                vo.setRace(vo.getRace().trim());
            }
            
            if(null != vo.getAtk1() && !"".equals(vo.getAtk1())){            // 无法去除空格
                vo.setAtk1(vo.getAtk1());
            }
            if(null != vo.getAtk2() && !"".equals(vo.getAtk2())){
                vo.setAtk2(vo.getAtk2());
            }
            
            page.setTotal(d.page2QuerytotalCount(vo));
            page.setRows(d.pageQuery2(vo));
        }
        return page;
    }

    public boolean userLogin(User user) {                // 用户登录
        User queryUser = d.userLogin(user);             // 登录信息和数据表中存储的数据对比
        
        if(queryUser!=null) {                            // 判断用户登录是否成功,
            return true;                                // 返回值给controller
        }else{                                            // 如果登录信息错误,就会返回null
            return false;                                // 因为用户信息和数据库存储的数据不一致
        }
        
    }

    public void userRegister(User user) {                // 用户注册
        user.setUid(UUID.randomUUID().toString());        // user表使用的随机生成的字符串
        user.setState(0);
        user.setCode("0");
        
        // 省市联动  目前只能接收省的值为数字,在这里转换成str        河北,四川,广东,江西
        switch(user.getProvinces()) {
            case "0" :
               user.setProvinces("河北省");
               break;
            case "1" :
               user.setProvinces("四川省");
               break;
            case "2" :
               user.setProvinces("广东省");
               break;
            case "3" :
               user.setProvinces("江西省");
               break;       
        }
        
        d.userRegister(user);        // 设置后的省的值为user.getProvinces()
        
    }

    public boolean ajaxUserName(String username) {        // 校验用户名是否可以注册
        User u = d.ajaxUserName(username);
        
        if(u == null) {    
            return false;
        }else {
            return true;
        }
        
    }

    public User myProfileName(User user) {                // 我的资料 显示名称(非用户名)
        return d.myProfileName(user);
    }

    // 通过用户名修改名称 方式1  应该有能接收多参数传入的方式,先用之前的方式,后续改用@param注解
    /* public void updateMyProfile(String loginUserName, String myProfileName) {
        // 将获得的参数设置成一个对象,
        User u= new User();
        u.setUsername(loginUserName);
        u.setName(myProfileName);
        d.updateMyProfile(u);
    }*/
    
    // 新增修改个性签名的参数
    // 通过用户名修改名称 方式2,尝试使用@param注解来传递多个参数值
    public void updateMyProfile(String loginUserName, String myProfileName,
            String my,String userInfo) {
        d.updateMyProfile(loginUserName,myProfileName,my,userInfo);
    }
    
    // 需要更新后的用户对象,用于显示 方式1  准备传入一个user类
    /*public User updateShow(String loginUserName, String myProfileName) {
        // 将获得的参数设置成一个对象,
        User updateShow = new User();
        updateShow.setUsername(loginUserName);
        updateShow.setName(myProfileName);
        return d.updateShow(updateShow);
    }*/
    
    // 需要更新后的用户对象,用于显示 方式2 使用@param注解来传递多个参数值
    public User updateShow(String loginUserName, String myProfileName,
            String my,String userInfo) {
        return d.updateShow(loginUserName,myProfileName,my,userInfo);
    }

    // 修改用户密码  使用事务
    @Transactional
    public boolean updatePassword(String usernameUpdatePassword, String password1, 
            String password2, String updatePassword) {
        String username = usernameUpdatePassword;            // 据当前用户名修改密码
        
        User user1 = d.queryPassword1(username,password1);    // 旧用户的uid
        User user2 = d.queryPassword2(username,password2);
        
        d.updatePassword(username,updatePassword);
        
        // 这里不能使用|| ||代表任意一个条件为真,判断结果就是真,不满足需求
        if(user1 != null && user2 !=null ) {    // 如果查询和更新都成功，返回true，表示成功
            return true;
        } else {                                // 否则，抛出异常，回滚事务，表示失败
            throw new RuntimeException();
        }
        
    } // 修改用户密码的方法的结束括号

    
    public String logintime(User user) {                            // 2 上次登录时间
        String s = null ;                                            // 准备返回的值
        
        String usernameLogintime = user.getUsername();                // 获取当前用户名
        
        // 将if-else改为根据当前用户名查询到的数值,再判断是否为null 
        // 改在else中查询,预期是只执行一次即可
        
        // 从db中获取上次时间  后由string改为类Logininfo    作用if-else判断用
        // 预期效果为: 此用户是第一次登录时,返回null  不是时,返回一个对象,包含用户名和时间
        Logininfo selectTime = d.selectLogintime(usernameLogintime);    
        
        if(selectTime!= null) {                                        // db有值,代表非第一次登录
            Date Date = new Date();
            d.firstLoginTime(usernameLogintime,Date);                // 在db中设置当前时间
            selectTime = d.selectLogintime(usernameLogintime);        // 再次获取时间
            s = selectTime.getLogintime();
        } else {                                                    // 无,代表第一次 
            s = "当前用户是第一次登录,下次登录时则会显示具体时间";
            
            // 在这里将用户名存入db中,因为else只会执行一次,也就是时间为null时,所以不用考虑其它
            d.setLogininfoUsername(usernameLogintime);
        }
        return s;
    }    // 上次登录时间的结束括号

    public String getUsername(String loginUser) {        // 据用户名从db中查询用户信息
        return d.getUsername(loginUser);
    }

    public void sQ(Logininfo logininfo) {                            // 8 密保问题  未使用事务
        
        String Username = logininfo.getUsername();        // 密保问题中,当前的用户名
        
        String securityQuestion1 = logininfo.getSecurityQuestion1();    // 设置密保问题1
        d.setSQ1(Username,securityQuestion1);                             
        
        Logininfo q1 = d.querySQ1(Username,securityQuestion1);            // 从db查询密保问题1
        String q1str = q1.getSecurityQuestion1();
        
        String securityQuestion2 = logininfo.getSecurityQuestion2();    // 设置密保问题2
        d.setSQ2(Username,securityQuestion2);                         
        
        Logininfo q2 = d.querySQ2(Username,securityQuestion2);            // 从db查询密保问题2
        String q2str = q2.getSecurityQuestion2();
        
        
        String securityQuestion3 = logininfo.getSecurityQuestion3();    // 设置密保问题3
        d.setSQ3(Username,securityQuestion3);
        
        Logininfo q3 = d.querySQ3(Username,securityQuestion3);            // 从db查询密保问题3
        String q3str = q3.getSecurityQuestion3();
    }

    @Transactional 
    public boolean forGetPassword(Logininfo logininfo) {                // 9 忘记密码 要使用事务
        String Username = logininfo.getUsername();
        
        String securityQuestion1 = logininfo.getSecurityQuestion1();    // form接收到的问题1
        Logininfo q1 = d.querySQ1(Username,securityQuestion1);            // 从db查询到的问题1
        String dbsQ1 = q1.getSecurityQuestion1();
        
        String securityQuestion2 = logininfo.getSecurityQuestion2();    // form接收到的问题2
        Logininfo q2 = d.querySQ2(Username,securityQuestion2);            // 从db查询到的问题2
        String dbsQ2 = q2.getSecurityQuestion2();
        
        String securityQuestion3 = logininfo.getSecurityQuestion3();    // form接收到的问题3
        Logininfo q3 = d.querySQ3(Username,securityQuestion3);            // 从db查询到的问题3
        String dbsQ3 = q3.getSecurityQuestion3();
        
        // 当form接收到的问题的答案 和 db中用户名+问题查询的结果  共3次,额外有3次接收值不为空的判断
        // 不能判断不为空,因为刚一进入的页面时,必须是空的
        // securityQuestion1 != null && securityQuestion2 != null  && securityQuestion1 != null
        if(securityQuestion1.equals(dbsQ1) && securityQuestion2.equals(dbsQ2) &&
                securityQuestion3.equals(dbsQ3)) {    
            return true;
        } else {                                // 否则，抛出异常，回滚事务，表示失败
            throw new RuntimeException();
        }
        
    }

    // 9 密保问题验证,设密码
    public void sQUpdatePassword(String sQusername, String sQupdatePassword) {
        d.sQUpdatePassword(sQusername,sQupdatePassword);
    }

    // 12 历史登录次数 
    public int loginNumber(User user) {
        String username = user.getUsername();                         // 当前用户名
        
        Logininfo logininfo = d.loginNumber(username);                // 查询登录次数 
        int loginSuccessNumber = logininfo.getLoginNumber();
        
        loginSuccessNumber++;     // 本次登录成功,则往logininfo中loginNumber的值+1
        
        d.setLoginNumber(username,loginSuccessNumber);                // +1后存入db
        
        return loginSuccessNumber;
    }
    
} // CardServiceImpl的结束括号

 

package shanhai.service;

import java.sql.Date;
import java.util.List;

import shanhai.pojo.Books;
import shanhai.pojo.Card;
import shanhai.pojo.magic_trapCard;

public interface DeckService {
    List<Card> deckId(Integer deckId);                            // 13 选择卡组
    List<Card> selectDeck(String deckOne, String deckTwo);        // 17 卡组联动,选择具体的卡组
    String deckInfo(String deckOne, String deckTwo);            // 19 卡组信息

    // 22 魔陷卡组列表
    List<magic_trapCard> magic_trapOption(String magic_trapOne, String magic_trapTwo);
    List<Books> BookList();                                        // 23 书架列表查询
    public void addBook(Books books);                            // 24 添加书籍
    Books showFormBook(int id);                                // 25 模态框显示书籍信息,查询
    void updateSubmitBook(Books books);                        // 25 书籍修改 模态框提交的修改的值
    void deleteBook(Integer id);                            // 26 删除书籍
    void deletesBook(Integer[] ids);                        // 27 批量删除书籍
    void addMagic_trap(magic_trapCard mt);                    // 31 添加魔陷
    
    // 32 魔陷  模态框显示魔陷卡信息,查询
    magic_trapCard showFormMagicTrap(Integer magicTrapId,String cardType);
    // 33魔陷修改 模态框提交的修改的值    
    void updateSubmitMagicTrap(magic_trapCard mt);
    void deleteMagicTrap(Integer magicTrapId, String cardType);        // 34 单次删除
    void deletesMagicTrap(Integer[] ids, String str);                // 35 批量删除
    
    // 36 为了显示出操作后的页面效果,所以在这里利用str查询db
    List<magic_trapCard> magic_trapOptionStr(String str);
    // 38 书籍据时间段查询
    List<Books> ReadingDateQuery(Date startDateQuery, Date endDateQuery);
    // 38 查询当前月份的书籍
    List<Books> ReadingDateQuery136(Integer query136);

}

package shanhai.service;

import java.sql.Date;
import java.util.List;

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

import shanhai.mapper.DeckDao;
import shanhai.pojo.Books;
import shanhai.pojo.Card;
import shanhai.pojo.magic_trapCard;

@Service
public class DeckServiceImpl implements DeckService{
    @Autowired
    private DeckDao d;

    public String deckInfo(String deckOne, String deckTwo) {        // 19 卡组信息
        String selectDeckInfo = null ;            // 准备根据列表传递过来的值,来从db查询卡组信息
        
        // 0:黑魔术师  0:黑魔导少女   1:自然竹笋 1:自然木鳞龙   不同于查询卡组内容,这是查询卡组信息
        if("0".equals(deckOne)){
            
            switch(deckTwo) {
                case "黑魔术师" :
                    selectDeckInfo = d.selectDeckInfo2();            // 黑魔术师卡组
                    break;
                case "黑魔导少女" :
                    selectDeckInfo = d.selectDeckInfo3();            // 黑魔导少女卡组
                    break;    
            }
        }
        
        if("1".equals(deckOne)) {
            switch(deckTwo) {
                case "自然竹笋" :
                    selectDeckInfo = d.selectDeckInfo4();            // 自然竹笋卡组
                    break;
                case "自然木鳞龙" :
                    selectDeckInfo = d.selectDeckInfo5();             // 自然木鳞龙卡组
                    break;
                case "自然木龙兽" :
                    selectDeckInfo = d.selectDeckInfo6();            // 自然木龙兽
            }
        }
        
        return selectDeckInfo;
    }
    
    
    public List<Card> selectDeck(String deckOne, String deckTwo) {    // 17 卡组联动,选择具体的卡组
        List<Card> deckIdList = null ;            // 准备根据列表传递过来的值,来选择从db中查询 
        
        // 0:黑魔术师  0:黑魔导少女   1:自然竹笋 1:自然木鳞龙
        if("0".equals(deckOne)){
            switch(deckTwo) {
                case "黑魔术师" :
                    deckIdList = d.deckId2();            // 黑魔术师卡组
                    break;
                case "黑魔导少女" :
                    deckIdList = d.deckId3();            // 黑魔导少女卡组
                    break;
            }
        }
        
        if("1".equals(deckOne)) {
            switch(deckTwo) {
                case "自然竹笋" :
                    deckIdList = d.deckId4();            // 自然竹笋卡组
                    break;
                case "自然木鳞龙" :
                    deckIdList = d.deckId5();             // 自然木鳞龙卡组
                    break;    
                case "自然木龙兽" :
                    deckIdList = d.deckId6();            // 自然木龙兽
            }
        }
        
        return deckIdList;
    }
    

    public List<Card> deckId(Integer deckId) {                    // 13 选择卡组
        // 目前有3种情况1,null 2是数值为1(代表自然竹笋卡组),3是数值为2(代表黑魔导少女卡组)
        if(deckId == null) {
            deckId = 0; 
        }
        
        List<Card> deckIdList = null ;            // 准备根据列表传递过来的值,来选择从db中查询 
        
        switch(deckId) {
            case 0 :
                // 无卡组
                break;
            case 1 :
                deckIdList = d.deckId2();        // 从db中查询deck2  自然竹笋
                break;
            case 2  :
                deckIdList = d.deckId3();        // 从db中查询deck3
                break;
        }
        
        /*if(deckIdList == null ) {
            deckIdList.add(new Card(1,"0","0","0",0,0));
        }*/
        
        return deckIdList;
    }

    // 22 魔陷卡组列表
    public List<magic_trapCard> magic_trapOption(String magic_trapOne, String magic_trapTwo) {
        List<magic_trapCard> magic_trapList = null ;            
        
        if("0".equals(magic_trapOne)){
            switch(magic_trapTwo) {
                case "场地魔法卡" :
                    magic_trapList = d.magic1();            
                    break;
                case "普通魔法卡" :
                    magic_trapList = d.magic2();            
                    break;    
            }
        }
        
        if("1".equals(magic_trapOne)) {
            switch(magic_trapTwo) {
                case "普通陷阱卡" :
                    magic_trapList = d.trap1();    
                    break;
                case "反击陷阱卡" :
                    magic_trapList = d.trap2();    
                    break;    
            }
        }
        
        return magic_trapList;
    }

    public List<Books> BookList() {                    // 23 书架列表查询
        List<Books> ListBook = d.BookList();
        
        return ListBook;
    }

    public void addBook(Books books) {                    // 24 添加书籍
        d.addBook(books);
    }

    public Books showFormBook(int id) {                    // 25 模态框显示书籍信息,查询
        // 在些尝试一下能否从db中查询出timestamp类型的数据
        
        
        
        return d.showFormBook(id);
    }

    public void updateSubmitBook(Books books) {            // 25 书籍修改 模态框提交的修改的值
        d.updateSubmitBook(books);
    }

    public void deleteBook(Integer id) {                // 26 删除书籍
        d.deleteBook(id);
    }

    
    public void deletesBook(Integer[] ids) {            // 27 批量删除书籍
        d.deletesBook(ids);
    }


    public void addMagic_trap(magic_trapCard mt) {        // 31 添加魔陷
        String s = mt.getCardType();        //  据cardType类型,选择不同的数据表,然后再添加
        switch(s){
            case "场地魔法卡":
                d.addMagic_card1(mt);        // 添加到magic_card1
                break;
            case "普通魔法卡":
                d.addMagic_card2(mt);        // 添加到magic_card2
                break;
            case "普通陷阱卡":
                d.addTrap_card1(mt);        // 添加到trap_card1
                break;
            case "反击陷阱卡":
                d.addTrap_card2(mt);        // 添加到trap_card2
                break;    
        }
        
    }

    // 32 魔陷  模态框显示魔陷卡信息,查询
    public magic_trapCard showFormMagicTrap(Integer magicTrapId,String cardType) {
        //  据cardType类型,选择不同的数据表,然后再查询
        magic_trapCard magic_trapCard = null;
        
        switch(cardType){
            case "场地魔法卡":
                magic_trapCard = d.showFormMagic1(magicTrapId);        // 查询魔陷中的魔法卡列表1
                break;
            case "普通魔法卡":
                magic_trapCard = d.showFormMagic2(magicTrapId);        // 查询魔陷中的魔法卡列表2
                break;
            case "普通陷阱卡":
                magic_trapCard = d.showFormTrap1(magicTrapId);        // 查询魔陷中的陷阱卡列表1
                break;
            case "反击陷阱卡":
                magic_trapCard = d.showFormTrap2(magicTrapId);        // 查询魔陷中的陷阱卡列表2
                break;    
        }
        
        return magic_trapCard;
    }

    // 33魔陷修改 模态框提交的修改的值    
    public void updateSubmitMagicTrap(magic_trapCard mt) {
        String s = mt.getCardType();        // 据魔陷卡的卡片类型来判断修改到哪个表中
        
        switch(s) {
            case "场地魔法卡" :
                d.updateSubmitMagic1(mt);
                break;
            case "普通魔法卡" :
                d.updateSubmitMagic2(mt);
                break;
            case "普通陷阱卡" :
                d.updateSubmitTrap1(mt);
                break;
            case "反击陷阱卡" :
                d.updateSubmitTrap2(mt);
                break;
        }
        
    }

    public void deleteMagicTrap(Integer magicTrapId, String cardType) {        // 34 单次删除
            switch(cardType){                //  据cardType类型,选择不同的数据表,然后再删除
                case "场地魔法卡":
                    d.deleteMagic1(magicTrapId);        // 查询魔陷中的魔法卡列表1
                    break;
                case "普通魔法卡":
                    d.deleteMagic2(magicTrapId);        // 查询魔陷中的魔法卡列表2
                    break;
                case "普通陷阱卡":
                    d.deleteTrap1(magicTrapId);            // 查询魔陷中的陷阱卡列表1
                    break;
                case "反击陷阱卡":
                    d.deleteTrap2(magicTrapId);            // 查询魔陷中的陷阱卡列表2
                    break;    
            }
    }

    public void deletesMagicTrap(Integer[] ids, String str) {        // 35 批量删除
        switch(str){                //  据前端隐藏input传递的str,选择不同的数据表,然后再删除
            case "场地魔法卡":
                d.deletesMagic1(ids);            // 批量删除魔陷卡列表中的魔法卡列表1
                break;
            case "普通魔法卡":
                d.deletesMagic2(ids);            
                break;
            case "普通陷阱卡":
                d.deletesTrap1(ids);            
                break;
            case "反击陷阱卡":
                d.deletesTrap2(ids);            
                break;    
        }
    }

    // 36 为了显示出操作后的页面效果,所以在这里利用str查询db
    public List<magic_trapCard> magic_trapOptionStr(String str) {
        List<magic_trapCard> mtList = null;
        
        switch(str) {
            case "场地魔法卡":
                mtList = d.selectMagic1();            
                break;
            case "普通魔法卡":
                mtList = d.selectMagic2();            
                break;
            case "普通陷阱卡":
                mtList = d.selectTrap1();            
                break;
            case "反击陷阱卡":
                mtList = d.selectTrap2();            
                break;    
        }
        
        return mtList;
    }

    // 38 书籍据时间段查询
    public List<Books> ReadingDateQuery(Date startDateQuery, Date endDateQuery) {
        return d.ReadingDateQuery(startDateQuery,endDateQuery);
    }

    // 38 查询当前月份的书籍 
    public List<Books> ReadingDateQuery136(Integer Query136) {
        List<Books> bookList = null;
        
        switch(Query136){
            case 1:
                bookList = d.ReadingDateQuery1();
                break;
            case 3:
                bookList = d.ReadingDateQuery3();
                break;
            case 6:
                bookList = d.ReadingDateQuery6();
                break;
        }
        
        return bookList;
    }
    
}    // DeckServiceImpl类的结束括号

 

package shanhai.service;

import java.util.List;
import shanhai.pojo.Picture;

public interface PictureService {

    public void addPicName(String picName);            // 在数据表中保存图片的名称

    public List<Picture> queryAll();                // 查询图片列表 

}

package shanhai.service;

import java.util.List;

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

import shanhai.mapper.PictureDao;
import shanhai.pojo.Picture;

@Service
public class PictureServiceImpl  implements PictureService  {

    @Autowired
    private PictureDao pD;

    public void addPicName(String picName) {        // 在数据表中保存图片的名称
        pD.addPicName(picName);
    }

    public List<Picture> queryAll() {
        return pD.queryAll();
    }
    
}

 

Dao层

package shanhai.mapper;

import java.util.Date;
import java.util.List;

import org.apache.ibatis.annotations.Param;

import shanhai.pojo.Card;
import shanhai.pojo.Logininfo;
import shanhai.pojo.QueryVo;
import shanhai.pojo.User;

public interface CardDao {
    public List<Card> selectList();                        // 查询所有
    public void addCard(Card card);                        // 添加数据
    public Card showFormCard(int id);                    // id查询
    public void updateSubmit(Card card);                // 修改数据
    public void deleteAjax(int id);                        // 删除数据
    public Integer page2QuerytotalCount(QueryVo vo);    // 根据条件,查询总条数
    public List<Card> pageQuery2(QueryVo vo);            // 根据条件,返回分页的结果
    public User userLogin(User user);                    // 用户登录
    public void userRegister(User user);                // 用户注册
    public User ajaxUserName(String username);            // 校验用户名是否可以注册
    public User myProfileName(User user);                // 我的资料 显示名称(非用户名)
    //    public void updateMyProfile(User u);             // 通过用户名修改名称 第一种方式 
    public void updateMyProfile(                        // 通过用户名修改名称 方式2  新增my
            @Param("username") String loginUserName, 
            @Param("name") String myProfileName,
            @Param("my") String my,
            @Param("userInfo") String userInfo);
    
    //    public User updateShow(User updateShow);        // 需要更新后的用户对象,用于显示 方式1
    public User updateShow(                                  // 需要更新后的user来显示  方式2  新增my
            @Param("username") String loginUserName, 
            @Param("name") String myProfileName,
            @Param("my") String my,
            @Param("userInfo") String userInfo);
    
    public User queryPassword1(                                // 第一次查询密码
            @Param("username") String username, 
            @Param("password") String password1);    
    
    public User queryPassword2(                                // 第二次查询密码
            @Param("username") String username, 
            @Param("password") String password2);
    
    public void updatePassword(                                // 更新密码
            @Param("username") String username,
            @Param("password") String updatePassword);
    
    // 第一次登录时,记录当前时间  后续传入用户名   后改为每次登录时都设置
    public void firstLoginTime(
            @Param("username") String usernameLogintime,
            @Param("logintime") Date Date);
    
    public Logininfo selectLogintime(                        // 从db中查询上次登录的时间
            @Param("username") String usernameLogintime);
    
    // 利用if-elst设置一次,将用户名保存到logininfo中
    public void setLogininfoUsername(
            @Param("username") String usernameLogintime);
    
    // 据用户名从db中查询用户信息
    public String getUsername(
            @Param("username") String loginUser);
    
    // 8 密保问题 设置密保问题1
    public String setSQ1(
            @Param("username") String Username,
            @Param("securityQuestion1") String securityQuestion1);
    
    // 从db中查询密保问题1的结果
    public Logininfo querySQ1(
            @Param("username") String Username,
            @Param("securityQuestion1") String securityQuestion1);
    
    
    // 设置密保问题2 
    public void setSQ2(
            @Param("username") String Username,
            @Param("securityQuestion2") String securityQuestion2);
    
    // 从db中查询密保问题2的结果
    public Logininfo querySQ2(
            @Param("username") String Username,
            @Param("securityQuestion2") String securityQuestion2);
    
    
    // 设置密保问题3
    public void setSQ3(
            @Param("username") String Username,
            @Param("securityQuestion3") String securityQuestion3);    
    
    // 从db中查询密保问题3的结果
    public Logininfo querySQ3(
            @Param("username") String Username,
            @Param("securityQuestion3") String securityQuestion3);
    
    // 9 密保问题验证,设密码
    public void sQUpdatePassword(
            @Param("username") String sQusername, 
            @Param("password") String sQupdatePassword);
    
    // 12 查询登录次数
    public Logininfo loginNumber(
            @Param("username") String username);
    
    // 12 +1后存入db
    public void setLoginNumber(
            @Param("username") String username, 
            @Param("loginNumber") int loginSuccessNumber);
    
}

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="shanhai.mapper.CardDao">        <!-- 命名空间，包名可能会变 -->
    
    <!--  12 +1后存入db -->
    <update id="setLoginNumber">
        UPDATE logininfo
        <set>
            loginNumber = #{loginNumber} 
        </set>
        <where>
            username = #{username}
        </where>
        
    </update>    
    
    <!-- 12 历史登录次数1 查询登录次数-->
    <select id="loginNumber" resultType="Logininfo">
        SELECT * FROM logininfo 
        <where>
            <if test="username != null and username != ''">    
                username = #{username}
            </if>
        </where>
    </select>
    
    <!-- 9 密保问题验证后,设置密码-->
    <update id="sQUpdatePassword">
        UPDATE user
        <set>
            password = #{password}
        </set>
        <where>
            <if test="username != null and username != ''">    
                username = #{username}
            </if>
        </where>
    </update>        
    
    <!-- 从db中查询密保问题3的结果 -->
    <select id="querySQ3" resultType="Logininfo">
        SELECT * FROM logininfo 
        <where>
            <if test="username != null and username != ''">    
                username = #{username}
            </if>
            <if test="securityQuestion3 != null and securityQuestion3 != ''">    
                and securityQuestion3 = #{securityQuestion3}
            </if>
        </where>
    </select>
    
    <!-- 设置密保问题3 -->
    <select id="setSQ3">
        UPDATE logininfo
        <set>
            securityQuestion3 = #{securityQuestion3}
        </set>
        <where>
            <if test="username != null and username != ''">    
                username = #{username}
            </if>
        </where>
    </select>
    
    
    <!-- 从db中查询密保问题2的结果 -->
    <select id="querySQ2" resultType="Logininfo">
        SELECT * FROM logininfo 
        <where>
            <if test="username != null and username != ''">    
                username = #{username}
            </if>
            <if test="securityQuestion2 != null and securityQuestion2 != ''">    
                and securityQuestion2 = #{securityQuestion2}
            </if>
        </where>
    </select>
    
    <!-- 设置密保问题2 -->
    <select id="setSQ2">
        UPDATE logininfo
        <set>
            securityQuestion2 = #{securityQuestion2}
        </set>
        <where>
            <if test="username != null and username != ''">    
                username = #{username}
            </if>
        </where>
    </select>
    
    <!-- 从db中查询密保问题1的结果 -->
    <select id="querySQ1" resultType="Logininfo">
        SELECT * FROM logininfo 
        <where>
            <if test="username != null and username != ''">    
                username = #{username}
            </if>
            <if test="securityQuestion1 != null and securityQuestion1 != ''">    
                and securityQuestion1 = #{securityQuestion1}
            </if>
        </where>
    </select>
    
    <!-- 8 密保问题 设置密保问题1 -->
    <select id="setSQ1">
        UPDATE logininfo
        <set>
            securityQuestion1 = #{securityQuestion1}
        </set>
        <where>
            <if test="username != null and username != ''">    
                username = #{username}
            </if>
        </where>
    </select>
    
    <!-- 据用户名从db中查询用户信息
         SELECT * FROM USER WHERE username = '1';  -->
    <select id="getUsername" resultType="String">
        SELECT * FROM user 
        <where>
            <if test="username != null and username != ''">    
                username = #{username}
            </if>
        </where>    
    </select>
    
    <!-- 利用if-elst设置一次,将用户名保存到logininfo中 -->
    <!-- public void setLogininfoUsername(String usernameLogintime); -->
    <insert id="setLogininfoUsername" parameterType="String">
        INSERT INTO logininfo (username) VALUES (#{username});
    </insert>

    <!-- 根据当前用户名,从db中查询上次登录的时间 -->
    <!-- 这是,不用用户名就能直接查询时间的版本 -->
    <!-- <select id="selectLogintime" resultType="String">
        SELECT logintime FROM logininfo ;
    </select> -->
    
    <!-- 根据当前用户名,从db中查询上次登录的时间 -->
    <!-- 真正的根据当前用户名查询,而非上个版本的直接查询 -->
    <!-- <select id="selectLogintime" resultType="String">
        SELECT logininfo
        <where>
            <if test="username != null and uaername != ''">
            username = #{username}
            <if test="logintime != null and logintime != ''">
            and logintime = #{logintime}
        </where>
    </select> -->

    <!-- 根据当前用户名,从db中查询上次登录的时间 -->
    <!-- 真正的根据当前用户名查询,而非上个版本的直接查询 -->
    <!-- 改为使用占位符,不然总是能查询到 -->
    <select id="selectLogintime" resultType="Logininfo">
        SELECT * FROM logininfo 
        <where>
            <if test="username != null and username != ''">    
            username = #{username}
            </if>
        </where>
            
    </select>
    
    <!-- 第一次登录时,记录当前时间   后弃用parameterType="Date" -->
    <insert id="firstLoginTime" >
        UPDATE logininfo 
        <set>
            logintime = #{logintime}
        </set>
        <where>username = #{username}</where>
    </insert>

    <!-- 更新密码 根据用户名来设置密码 -->
    <select id="updatePassword" >
        UPDATE user
        <set>
            password = #{password}
        </set>
        <where> username = #{username} </where>
    </select>

    <!-- 第二次查询密码  -->
    <select id="queryPassword2" resultType="User">
        SELECT * FROM user 
        <where>
            <if test="username != null and username != ''">    
                username = #{username}
            </if>
            <if test="password != null and password != ''">    
                and password = #{password}
            </if>
        </where>    
    </select>

    <!-- 第一次查询密码   -->
    <select id="queryPassword1" resultType="User">
        SELECT * FROM user 
        <where>
            <if test="username != null and username != ''">    
                username = #{username}
            </if>
            <if test="password != null and password != ''">    
                and password = #{password}
            </if>
        </where>    
    </select>

    <!-- 需要更新后的用户,用于显示    方式2 使用@param注解,这里不用写传入的参数 -->
    <select id="updateShow" resultType="User">
        SELECT * FROM user 
        <where>
            <if test="username != null and username != ''">    
                username = #{username}
            </if>    
            <if test="name != null and name != ''">
                and name = #{name}
            </if>    
            <if test="my != null and my != ''">
                and my = #{my}
            </if>
            <if test="userInfo != null and userInfo != ''">
                and userInfo = #{userInfo}
            </if>
        </where>
    </select>    
        
    <!-- 需要更新后的用户,用于显示    方式1 即传入一个类 具体参数类型为User -->
    <!-- <select id="updateShow" parameterType="User" resultType="User">
        select * from user where username = #{username} and name = #{name}
    </select> -->

    <!-- 通过用户名修改名称    方式2 使用@param注解,这里不用写传入的参数 -->
    <update id="updateMyProfile" >
         UPDATE user
         <set> name = #{name},my = #{my},userInfo = #{userInfo} </set>
         <where> username = #{username} </where>
    </update>
    
    <!-- 通过用户名修改名称    方式1 即传入一个类 具体参数类型为User -->    
    <!-- <select id="updateMyProfile" parameterType="User" >
         UPDATE user
         <set>name = #{name}</set>
         <where>username = #{username}</where>
    </select> -->

    <!-- 我的资料 显示名称(非用户名) -->
    <select id="myProfileName" parameterType="String" resultType="User">
        SELECT * FROM user
        <where> username = #{username} </where>
    </select>

    <!-- 校验用户名是否可以注册  -->
    <select id="ajaxUserName" parameterType="String" resultType="User">
        SELECT * FROM user
        <where> username = #{username} </where>
    </select>

    <!-- 用户注册,state,code没有详细设置 -->
    <select id="userRegister" parameterType="User" >
        INSERT INTO user (uid,username,password,email,name,sex,provinces,provinceCity,birthday,state,code)
        VALUES(#{uid},#{username},#{password},#{email},#{name},#{sex},#{provinces},
        #{provinceCity},#{birthday},#{state},#{code})
    </select>

    <!-- 用户登录 -->
    <select id="userLogin" parameterType="User" resultType="User">
        SELECT * FROM user
        <where> username = #{username} and password = #{password} </where>
    </select>

    <!-- 总条数  注意条件,目前有3个 -->
    <select id="page2QuerytotalCount" parameterType="QueryVo" resultType="Integer">
        SELECT COUNT(1) FROM deck
        <where>
            <if test="name != null and name != ''">
                name like "%"#{name}"%"
            </if>
            <if test="race != null and race != ''">
                AND race = #{race}
            </if>
            <if test="atk1 != null and atk1 != ''">
                AND atk BETWEEN #{atk1} AND #{atk2}
            </if>
        </where>
    </select>

    <!-- 结果集,新增查询条件race,新增范围查询的范围值2个,总条数的SQL要设置好相对应的条件 -->
    <!-- 方法返回类型是List<Card>,但是这里的返回类型是集合中的元素的类型  -->
    <select id="pageQuery2" parameterType="QueryVo" resultType="Card">
        SELECT * FROM deck 
        <where>
            <if test="name != null and name != ''">
                name like "%"#{name}"%"
            </if>
            <if test="race != null and race != ''">
                AND race = #{race}
            </if>
            <if test="atk1 != null and atk1 != ''">
                AND atk BETWEEN #{atk1} AND #{atk2}
            </if>
            
        </where>
        limit #{startRow},#{size}
    </select>

    <!-- 删除数据 -->
    <delete id="deleteAjax" parameterType="int">
        DELETE FROM deck
        <where> id = #{id} </where>
    </delete>

    <!-- 修改数据 -->
    <update id="updateSubmit" parameterType="Card">
        UPDATE deck 
        <set> name=#{name},attribute=#{attribute},race=#{race},atk=#{atk},def=#{def} </set>
        <where> id=#{id} </where>
    </update>
    
    <!-- 通过id查询,并返回结果在表单中显示,有传参,有返回值 -->
    <select id="showFormCard" parameterType="int" resultType="Card">
        SELECT * FROM deck
        <where> id = #{id} </where>
    </select>
    
    <!-- 添加数据,无返回结果 -->
    <select id="addCard" parameterType="Card">
        INSERT INTO deck (id,name,attribute,race,atk,def)
        VALUES(#{id},#{name},#{attribute},#{race},#{atk},#{def})
    </select>
    
    <!-- 查询所有,未传参-->
    <select id="selectList" resultType="Card">
        SELECT * FROM deck
    </select>
    
</mapper>

 

package shanhai.mapper;

import java.sql.Date;
import java.util.List;

import org.apache.ibatis.annotations.Param;

import shanhai.pojo.Books;
import shanhai.pojo.Card;
import shanhai.pojo.magic_trapCard;

public interface DeckDao {
//    public List<Card> deckId2();                // 13 选择卡组  选择从db中查询deck2表中的卡组
    public List<Card> deckId2();                // 17 卡组联动 改为黑魔术师卡组

//    public List<Card> deckId3();                // 13 选择卡组 从db中查询deck3
    public List<Card> deckId3();                // 17 卡组联动 改为黑魔导少女卡组
    
    public List<Card> deckId4();                // 17 卡组联动 改为自然竹笋卡组
    public List<Card> deckId5();                // 17 卡组联动 改为自然木鳞龙卡组

    public String selectDeckInfo2();            // 19 卡组信息 
    public String selectDeckInfo3();            // 19 卡组信息
    public String selectDeckInfo4();            // 19 卡组信息
    public String selectDeckInfo5();            // 19 卡组信息

    public List<Card> deckId6();                // 21 新增 自然木龙兽卡组
    public String selectDeckInfo6();            // 21 新增 自然木龙兽卡组信息

    public List<magic_trapCard> magic1();        // 22 查询 场地魔法卡
    public List<magic_trapCard> trap1();        // 22 查询普通陷阱卡
    public List<magic_trapCard> magic2();        // 22 查询 普通魔法卡
    public List<magic_trapCard> trap2();        // 22 查询 反击陷阱卡

    public List<Books> BookList();                // 23 书架列表查询
    public void addBook(Books books);            // 24 添加书籍
    public Books showFormBook(int id);            // 25 模态框显示书籍信息,查询
    public void updateSubmitBook(Books books);    // 25 书籍修改 模态框提交的修改的值

    public void deleteBook(Integer id);            // 26 删除书籍
    public void deletesBook(Integer[] ids);        // 27 批量删除书籍

    public void addMagic_card1(magic_trapCard mt);        // 31 添加魔陷    添加到magic_card1
    public void addMagic_card2(magic_trapCard mt);        // 添加到magic_card2
    public void addTrap_card1(magic_trapCard mt);        // 添加到trap_card1
    public void addTrap_card2(magic_trapCard mt);        // 添加到trap_card2

    // 32 魔陷  模态框显示魔陷卡信息,据ID查询,并且返回一个魔陷卡的对象
    public magic_trapCard showFormMagic1(Integer magicTrapId);
    public magic_trapCard showFormMagic2(Integer magicTrapId);
    public magic_trapCard showFormTrap1(Integer magicTrapId);
    public magic_trapCard showFormTrap2(Integer magicTrapId);

    // 33 模态框修改魔陷 提交的修改的值
    public void updateSubmitMagic1(magic_trapCard mt);
    public void updateSubmitMagic2(magic_trapCard mt);
    public void updateSubmitTrap1(magic_trapCard mt);
    public void updateSubmitTrap2(magic_trapCard mt);

    // 34 单次删除
    public void deleteMagic1(Integer magicTrapId);
    public void deleteMagic2(Integer magicTrapId);
    public void deleteTrap1(Integer magicTrapId);
    public void deleteTrap2(Integer magicTrapId);

    // 35 据前端隐藏input传递的str,选择不同的数据表,然后再删除
    public void deletesMagic1(Integer[] ids);
    public void deletesMagic2(Integer[] ids);
    public void deletesTrap1(Integer[] ids);
    public void deletesTrap2(Integer[] ids);

    // 36 为了显示出操作后的页面效果,所以在这里利用str查询db
    public List<magic_trapCard> selectMagic1();
    public List<magic_trapCard> selectMagic2();
    public List<magic_trapCard> selectTrap1();
    public List<magic_trapCard> selectTrap2();

    // 38 书籍据时间段查询
    public List<Books> ReadingDateQuery(
            @Param("startDateQuery") Date startDateQuery, 
            @Param("endDateQuery") Date endDateQuery);

    // 38 查询当前月份的数据
    public List<Books> ReadingDateQuery1();
    public List<Books> ReadingDateQuery3();
    public List<Books> ReadingDateQuery6();
    
}

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="shanhai.mapper.DeckDao">        <!-- 命名空间，包名可能会变 -->
    
    <select id="ReadingDateQuery6" resultType="Books">
        SELECT * FROM book 
        <where>
            <![CDATA[
            startDate >= DATE_SUB(NOW(),INTERVAL 6 MONTH) ]]>
        </where>
    </select>
    
    <select id="ReadingDateQuery3" resultType="Books">
        SELECT * FROM book 
        <where>
            <![CDATA[
            startDate >= DATE_SUB(NOW(),INTERVAL 3 MONTH) ]]>
        </where>
    </select>
    
    <!-- 39 查看当前月份的数据  其实也会查询当前这个月之后的数据,只是我们不添加即可 -->
    <!-- SELECT * FROM book WHERE startDate >= DATE_SUB(NOW(),INTERVAL 1 MONTH); -->
    <select id="ReadingDateQuery1" resultType="Books">
        SELECT * FROM book 
        <where>
            <![CDATA[startDate >= DATE_SUB(NOW(),INTERVAL 1 MONTH) ]]>
        </where>
    </select>
    
    <!-- 38 书籍据时间段查询
    public void ReadingDateQuery(
            @Param("startDateQuery") Date startDateQuery, 
            @Param("endDateQuery") Date endDateQuery); -->
    <select id="ReadingDateQuery" resultType="Books">
        SELECT * FROM book 
        <where>
            startDate BETWEEN #{startDateQuery} and #{endDateQuery}
        </where>
    </select>        
    
    <select id="selectTrap2" resultType="magic_trapCard">
        SELECT * FROM trap_card2
    </select>
    
    <select id="selectTrap1" resultType="magic_trapCard">
        SELECT * FROM trap_card1
    </select>
    
    <select id="selectMagic2" resultType="magic_trapCard">
        SELECT * FROM magic_card2
    </select>
    
    <!-- 36 为了显示出操作后的页面效果,所以在这里利用str查询db -->
    <select id="selectMagic1" resultType="magic_trapCard">
        SELECT * FROM magic_card1
    </select>
    
    <delete id="deletesTrap2" parameterType="java.lang.Integer">
          delete from trap_card2 where magicTrapId in
          <foreach item="ids" collection="array" index="no" open="(" separator="," close=")">
                #{ids}
          </foreach>
    </delete>
    
    <delete id="deletesTrap1" parameterType="java.lang.Integer">
          delete from trap_card1 where magicTrapId in
          <foreach item="ids" collection="array" index="no" open="(" separator="," close=")">
                #{ids}
          </foreach>
    </delete>
    
    <delete id="deletesMagic2" parameterType="java.lang.Integer">
          delete from magic_card2 where magicTrapId in
          <foreach item="ids" collection="array" index="no" open="(" separator="," close=")">
                #{ids}
          </foreach>
    </delete>
    
    <!-- 35 批量删除 -->
    <delete id="deletesMagic1" parameterType="java.lang.Integer">
          delete from magic_card1 where magicTrapId in
          <foreach item="ids" collection="array" index="no" open="(" separator="," close=")">
                #{ids}
          </foreach>
    </delete>
    
    <delete id="deleteTrap2" parameterType="java.lang.Integer">
        DELETE FROM trap_card2
        <where> magicTrapId=#{magicTrapId} </where>
    </delete>
    
    <delete id="deleteTrap1" parameterType="java.lang.Integer">
        DELETE FROM trap_card1
        <where> magicTrapId=#{magicTrapId} </where>
    </delete>
    
    <delete id="deleteMagic2" parameterType="java.lang.Integer">
        DELETE FROM magic_card2
        <where> magicTrapId=#{magicTrapId} </where>
    </delete>
    
    <!-- 34单次删除-->
    <delete id="deleteMagic1" parameterType="java.lang.Integer">
        DELETE FROM magic_card1
        <where> magicTrapId=#{magicTrapId} </where>
    </delete>
    
    <update id="updateSubmitTrap2" parameterType="magic_trapCard">
        UPDATE trap_card2
        <set> cardName=#{cardName},cardType=#{cardType},deckMatch=#{deckMatch},
              effect=#{effect}
        </set>
        <where> magicTrapId=#{magicTrapId} </where>
    </update>
    
    <update id="updateSubmitTrap1" parameterType="magic_trapCard">
        UPDATE trap_card1
        <set> cardName=#{cardName},cardType=#{cardType},deckMatch=#{deckMatch},
              effect=#{effect}
        </set>
        <where> magicTrapId=#{magicTrapId} </where>
    </update>
    
    <update id="updateSubmitMagic2" parameterType="magic_trapCard">
        UPDATE magic_card2
        <set> cardName=#{cardName},cardType=#{cardType},deckMatch=#{deckMatch},
              effect=#{effect}
        </set>
        <where> magicTrapId=#{magicTrapId} </where>
    </update>
    
    <!-- 33 模态框修改魔陷 提交的修改的值 -->
    <update id="updateSubmitMagic1" parameterType="magic_trapCard">
        UPDATE magic_card1
        <set> cardName=#{cardName},cardType=#{cardType},deckMatch=#{deckMatch},
              effect=#{effect}
        </set>
        <where> magicTrapId=#{magicTrapId} </where>
    </update>
    
    
    <select id="showFormTrap2" parameterType="java.lang.Integer" resultType="magic_trapCard">
        SELECT * FROM trap_card2
        <where> magicTrapId = #{magicTrapId}</where>
    </select>
    
    <select id="showFormTrap1" parameterType="java.lang.Integer" resultType="magic_trapCard">
        SELECT * FROM trap_card1
        <where> magicTrapId = #{magicTrapId}</where>
    </select>
    
    <select id="showFormMagic2" parameterType="java.lang.Integer" resultType="magic_trapCard">
        SELECT * FROM magic_card2
        <where> magicTrapId = #{magicTrapId}</where>
    </select>
    
    <!-- 32 魔陷  模态框显示魔陷卡信息,查询魔法卡1的列表中的ID -->
    <select id="showFormMagic1" parameterType="java.lang.Integer" resultType="magic_trapCard">
        SELECT * FROM magic_card1
        <where> magicTrapId = #{magicTrapId}</where>
    </select>
    
    <insert id="addTrap_card2" parameterType="magic_trapCard">
        INSERT INTO trap_card2 (magicTrapId,cardName,cardType,deckMatch,effect)
        VALUES(#{magicTrapId},#{cardName},#{cardType},#{deckMatch},#{effect})
    </insert>
    
    <insert id="addTrap_card1" parameterType="magic_trapCard">
        INSERT INTO trap_card1 (magicTrapId,cardName,cardType,deckMatch,effect)
        VALUES(#{magicTrapId},#{cardName},#{cardType},#{deckMatch},#{effect})
    </insert>
    
    <insert id="addMagic_card2" parameterType="magic_trapCard">
        INSERT INTO magic_card2 (magicTrapId,cardName,cardType,deckMatch,effect)
        VALUES(#{magicTrapId},#{cardName},#{cardType},#{deckMatch},#{effect})
    </insert>
    
    <!-- 31 添加魔陷 -->
    <insert id="addMagic_card1" parameterType="magic_trapCard">
        INSERT INTO magic_card1 (magicTrapId,cardName,cardType,deckMatch,effect)
        VALUES(#{magicTrapId},#{cardName},#{cardType},#{deckMatch},#{effect})
    </insert>
    
    <!-- 27 批量删除书籍  public void deletesBook(Integer[] ids);        -->
    <delete id="deletesBook" parameterType="java.lang.Integer">
          delete from book where id in
          <foreach item="ids" collection="array" index="no" open="(" separator="," close=")">
                #{ids}
          </foreach>
    </delete>
    
    <!-- 26 删除书籍 -->
    <delete id="deleteBook" parameterType="int">
        DELETE FROM book
        <where> id = #{id} </where>
    </delete>
    
    <!-- 25 修改书籍-->
    <update id="updateSubmitBook" parameterType="Books">
        UPDATE book 
        <set> bookTitle=#{bookTitle},progress=#{progress},unreadChapters=#{unreadChapters},
        subject=#{subject},note=#{note},demo=#{demo},bookUse=#{bookUse},format=#{format},
        startDate=#{startDate},endDate=#{endDate}</set>
        <where> id=#{id} </where>
    </update>
    
    <!-- 25 模态框显示书籍信息,查询 -->
    <select id="showFormBook" parameterType="int" resultType="Books">
        SELECT * FROM book
        <where> id = #{id}</where>
    </select>
    
    <!-- 24 添加书籍 public void addBook(Books books); -->
    <!-- 添加数据,无返回结果 -->
    <select id="addBook" parameterType="Books">
        INSERT INTO book (bookTitle,progress,unreadChapters,subject,note,demo,bookUse,format,
        startDate,endDate)
        VALUES(#{bookTitle},#{progress},#{unreadChapters},#{subject},#{note},#{demo},
        #{bookUse},#{format},#{startDate},#{endDate})
    </select>
    
    <!-- 23 书架列表查询 -->
    <select id="BookList" resultType="Books">
        SELECT * FROM book
    </select>
    
    <!-- 22 查询 反击陷阱卡 -->
    <select id="trap2" resultType="magic_trapCard">
        SELECT * FROM trap_card2
    </select>
    
    <!-- 22 查询 普通魔法卡 -->
    <select id="magic2" resultType="magic_trapCard">
        SELECT * FROM magic_card2
    </select>
    
    <!-- 22 查询 普通陷阱卡 -->
    <select id="trap1" resultType="magic_trapCard">
        SELECT * FROM trap_card1
    </select>
    
    <!-- 22 查询 场地魔法卡 -->
    <select id="magic1" resultType="magic_trapCard">
        SELECT * FROM magic_card1
    </select>
    
    <!-- 21 新增 自然木龙兽卡组信息 -->
    <select id="selectDeckInfo6" resultType="String">
        SELECT Info FROM deckinfo WHERE deckId ='6'
    </select>
    
    <!-- 21 新增 自然木龙兽卡组 -->
    <select id="deckId6" resultType="Card">
        SELECT * FROM deck6
    </select>
    
    <select id="selectDeckInfo5" resultType="String">
        SELECT Info FROM deckinfo WHERE deckId ='5'
    </select>
    
    <select id="selectDeckInfo4" resultType="String">
        SELECT Info FROM deckinfo WHERE deckId ='4'
    </select>
    
    <select id="selectDeckInfo3" resultType="String">
        SELECT Info FROM deckinfo WHERE deckId ='3'
    </select>
    
    <!-- 19 卡组信息 -->
    <!-- SELECT Info FROM deckinfo WHERE deckId='2'; -->
    <select id="selectDeckInfo2" resultType="String">
        SELECT Info FROM deckinfo WHERE deckId ='2'
    </select>
    
    <!-- 17卡组联动 改为自然木龙兽卡组 -->
    <select id="deckId5" resultType="Card">
        SELECT * FROM deck5
    </select>
    
    <!-- 17 卡组联动 改为自然竹笋卡组 -->
    <select id="deckId4" resultType="Card">
        SELECT * FROM deck4
    </select>
    
    <!-- 17 卡组联动 改为黑魔导少女卡组 -->
    <select id="deckId3" resultType="Card">
        SELECT * FROM deck3
    </select>
    
    <!-- 17卡组联动  由13选择卡组更改而成 -->
    <select id="deckId2" resultType="Card">
        SELECT * FROM deck2
    </select>
    
    
    <!-- 13 选择卡组  选择从db中查询deck3表中的卡组 -->
    <!-- <select id="deckId3" resultType="Card">
        SELECT * FROM deck3
    </select> -->
    
    <!-- 13 选择卡组  选择从db中查询deck2表中的卡组 -->
    <!-- <select id="deckId2" resultType="Card">
        SELECT * FROM deck2
    </select> -->    
    
    
</mapper>

 

package shanhai.mapper;

import java.util.List;
import shanhai.pojo.Picture;

public interface PictureDao {
    public void addPicName(String picName);                // 在数据表中保存图片的名称
    public List<Picture> queryAll();                    // 查询图片列表

}

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="shanhai.mapper.PictureDao">        <!-- 命名空间，包名可能会变 -->
    
    <!--  在数据表中保存图片的名称  public void addPicName(String picName);  -->
    <insert id="addPicName" parameterType="String">
        INSERT INTO picture (picName) VALUES(#{picName})
    </insert>

    <!--  查询图片列表  public List<String> queryAll();  --> 
    <!-- java.lang.String -->
    <select id="queryAll" resultType="Picture">
        SELECT * FROM picture 
    </select>
    
</mapper>

 

WEB-INF下jsp包中的jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page trimDirectiveWhitespaces="true"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="itheima" uri="http://itcast.cn/common/"%>
<%
    String path = request.getContextPath();
    String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
            + path + "/";
%>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>书架</title>
<link href="<%=basePath%>css/bootstrap.min.css" rel="stylesheet">
<link href="<%=basePath%>css/metisMenu.min.css" rel="stylesheet">
<link href="<%=basePath%>css/dataTables.bootstrap.css" rel="stylesheet">
<link href="<%=basePath%>css/sb-admin-2.css" rel="stylesheet">
<link href="<%=basePath%>css/font-awesome.min.css" rel="stylesheet" type="text/css">
<link href="<%=basePath%>css/boot-crm.css" rel="stylesheet" type="text/css">
</head>
<body>

    <jsp:include   page="head.jsp" flush="true"/>
<div class="col-sm-10"> 
    <div  id="mainContent">    
<div class="panel panel-info">
    <div class="panel-heading">
        <h3 class="panel-title">自学时,阅读的编程相关的书籍,记录进度</h3>
    </div>
    <div class="panel-body">    

<!-- 38 查询当前月份的数据-->
<%-- <form action="${pageContext.request.contextPath }/deck/BookReadingDateQuery136">
        <select name="Query136">
            <option>--请选择时间段--</option>
            <option value="1">当前月份内</option>
            <option value="3">3个月内</option>
            <option value="6">6个月内</option>
        </select>
        <input type="submit" class="btn btn-default" value="查询" name="submit" >
</form>     --%>    

<!-- 39 历史时间查询,分别为一,三,六个月内 -->    
<nav class="navbar navbar-default" role="navigation">
    <div class="container-fluid"> 
    <div class="navbar-header">
        <a class="navbar-brand" href="#">时间</a>
        <ul class="nav navbar-nav">
            <li class="dropdown">
                <a href="#" class="dropdown-toggle" data-toggle="dropdown">
                    历史
                    <b class="caret"></b>
                </a>
<ul class="dropdown-menu">
    <li><a href="${pageContext.request.contextPath }/readingDateQuery.html?Query136=1">本月</a></li>
    <li><a href="${pageContext.request.contextPath }/readingDateQuery.html?Query136=3">三个月内</a></li>
    <li><a href="${pageContext.request.contextPath }/readingDateQuery.html?Query136=6">六个月内</a></li>
</ul>
            </li>
        </ul>
    </div>
    </div>
</nav>

<!-- 38 据时间段查询 -->
<form action="${pageContext.request.contextPath }/deck/BookReadingDateQuery">
        <label>起始时间: </label>
        <input type="date" class="date_info" name="startDateQuery">-
        <input type="date" class="date_info" name="endDateQuery">
        <input type="submit" class="btn btn-default" value="查询" name="submit" >
</form>


<!-- 29 批量删除 使用的form -->    
<form id="form1" action="${pageContext.request.contextPath }/deck/deletesBook.action" method="post">    

<!-- </form> -->

    <table class="table table-hover table-striped table-bordered">
        <thead>
            <tr>
<th><input type="checkbox" onclick="checkBox()"  id="ids" name="ids" value="" form="form1"></th>
                <th>id</th>
                <th>bookTitle</th>
                <th>progress</th>
                <th>unreadChapters</th>
                <th>subject</th>
                <th>note</th>
                <th>demo</th>
                <th>bookUse</th>
                <th>format</th>
                <th>startDate</th>
                <th>endDate</th>
                
<th>                 <!-- 24 书籍添加-->    
    <button type="button" class="btn btn-primary btn-xs" data-toggle="modal" data-target="#bookAdd">添加</button>
    <input type="submit" value="删除" form="form1" class="btn btn-danger btn-xs">
</th>
            </tr>
        </thead>
        
        <tbody>
            <c:forEach items="${BookList}" var="list">
                <tr>
                    <!-- name由ids改成checkOne -->
                    <td><input type="checkbox" name="ids" value="${list.id}"></td>
                    <td>${list.id}</td>
                    <td>${list.bookTitle}</td>
                    <td>${list.progress}</td>
                    <td>${list.unreadChapters}</td>
                    <td>${list.subject}</td>
                    <td>${list.note}</td>
                    <td>${list.demo}</td>
                    <td>${list.bookUse}</td>
                    <td>${list.format}</td>
                    <td>${list.startDate}</td>
                    <td>${list.endDate}</td>
        
<td>
    <button type="button" class="btn btn-primary btn-xs" data-toggle="modal" 
    data-target="#bookUpdateModal" onclick="showFormBook(${list.id})">修改</button>
    <button type="button" class="btn btn-danger btn-xs" onclick="ajaxDelBook(${list.id})">删除</button>                
</td>

                </tr>
            </c:forEach>
        </tbody>
    </table>
    
</form>    


</div>
</div>

<div class="modal fade" id="bookAdd" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-hidden="true">
                    &times;
                </button>
                <h4 class="modal-title" id="myModalLabel">
                    添加书籍
                </h4>
            </div>
            
<div class="modal-body">
<!-- 【添加】 模态框中的表单form -->        
<form class="form-horizontal" id="modaladdBook">
        <div>
            <label>bookTitle:</label>
            <input type="text" id="bookTitle" name="bookTitle" autocomplete="off">
        </div>
        <div>
            <label>progress: </label>
            <select id="progress" name="progress" required>
                <option>--请选择--</option>
                <option value="已读">已读</option>
                <option value="正在读">正在读</option>
                <option value="放弃">放弃</option>
            </select>
        </div>
        <div>
            <label>unread:</label>
            <input type="text" id="unreadChapters" name="unreadChapters" autocomplete="off">
        </div>
        <div>
            <label>subject:</label>
            <input type="text" id="subject" name="subject" autocomplete="off"> 
        </div>
        <div>
            <label>note: </label>
            <select id="note" name="note" required>
                <option>--请选择--</option>
                <option value="无">无</option>
                <option value="Word">Word</option>
                <option value="Excel">Excel</option>
            </select>
        </div>
        <div>
            <label>demo: </label>
            <select id="demo" name="demo" required>
                <option>--请选择--</option>
                <option value="未练习">未练习</option>
                <option value="练习">练习</option>
            </select>
        </div>
        <div>
            <label>bookUse: </label>
            <select id="bookUse" name="bookUse" required>
                <option>--请选择--</option>
                <option value="未使用">未使用</option>
                <option value="应用">应用</option>
            </select>
        </div>
        <div>
            <label>format: </label>
            <select id="format" name="format" required>
                <option>--请选择--</option>
                <option value="PDF">PDF</option>
                <option value="实体书">实体书</option>
            </select>
        </div>
        <div>
            <label>startDate</label>
            <input type="date" id="startDate2" name="startDate">
        </div>
        <div>
            <label>endDate:</label>
            <input type="date" id="endDate2" name="endDate"> 
        </div>
        <!-- <div>
            <label>startDate:</label>
            <input type="text" id="startDate" name="startDate" autocomplete="off"> 
        </div>
        <div>
            <label>endDate:</label>
            <input type="text" id="endDate" name="endDate" autocomplete="off"> 
        </div> -->
</form>                
</div>
            <div class="modal-footer">
                <button type="button" class="btn btn-primary" onclick="modalAddBook()">添加</button>
                <button type="button" class="btn btn-default" data-dismiss="modal">关闭</button>
            </div>
        </div>    
    </div>    
</div>    <!-- 【添加】 模态框的结束div，包含form -->


<div class="modal fade" id="bookUpdateModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel2" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-hidden="true">
                    &times;
                </button>
                <h4 class="modal-title" id="myModalLabel2">
                    修改书籍信息
                </h4>
            </div>
            <div class="modal-body">
    <!-- 【修改】 模态框中的表单form -->
    <form class="form-horizontal" id="modalUpdate_formBook">
        <div>
            <label>id:</label>
            <input type="text" id="id2" name="id" autocomplete="off">
        </div>
        <div>
            <label>bookTitle:</label>
            <input type="text" id="bookTitle2" name="bookTitle" autocomplete="off">
        </div>
        <div>
            <label>progress:</label>
            <input type="text" id="progress2" name="progress" autocomplete="off">
        </div>
        <div>
            <label>unread:</label>
            <input type="text" id="unreadChapters2" name="unreadChapters" autocomplete="off">
        </div>
        <div>
            <label>subject:</label>
            <input type="text" id="subject2" name="subject" autocomplete="off"> 
        </div>
        
        <div>
            <label>note:</label>
            <input type="text" id="note2" name="note" autocomplete="off">     
        </div>
        <div>
            <label>demo:</label>
            <input type="text" id="demo2" name="demo" autocomplete="off">
        </div>
        <div>
            <label>bookUse:</label>
            <input type="text" id="bookUse2" name="bookUse" autocomplete="off">
        </div>
        <div>
            <label>format:</label>
            <input type="text" id="format2" name="format" autocomplete="off">
        </div>
        <div>
            <label>startDate</label>
            <input type="date" id="startDate2" name="startDate">
        </div>
        <div>
            <label>endDate:</label>
            <input type="date" id="endDate2" name="endDate"> 
        </div>
        <!-- <div>
            <label>startDate:</label>
            <input type="text" id="startDate2" name="startDate" autocomplete="off"> 
        </div>
        <div>
            <label>endDate:</label>
            <input type="text" id="endDate2" name="endDate" autocomplete="off"> 
        </div> -->
        
    </form>                
        </div>    
            <div class="modal-footer">
                <button type="button" class="btn btn-primary" onclick="modalUpdateSubmitBook()">修改</button>
                <button type="button" class="btn btn-default" data-dismiss="modal">关闭</button>
            </div>
        </div>
    </div>
</div>        <!--【修改】 的结束div -->


</div>
</div>

<script type="text/javascript">

        function modalAddBook() {        // 24添加  获得添加的模态框的表单中填写的数据
            $.ajax({        
                type:"POST",
                url:"<%=basePath%>deck/addBook.action",
                data:$("#modaladdBook").serialize(),        // 添加的模态框中的form的id
                success:function() {
                    alert("添加书籍成功");
                    $("#bookAdd").modal("hide");        // 通过模态框的id，隐藏模态框 
                    $(".modal-backdrop").remove();        // 去除,模态框添加后,灰屏
                    history.go(0);                        // 去除灰屏后,无法打开模态框,so刷新一下
                }
            });
        }
        
        function showFormBook(id) {         // 【修改】  打开模态框时显示"准备修改的内容" 
            $.ajax({
                type:"POST",
                url:"<%=basePath%>deck/showFormBook.action",
                data:{"id":id},
                success:function(data) {                          // 返回通过bookTitle查询    
//                     alert(data);
                    
                    $("#id2").val(data.id);                        // 将返回的数据，设置给form    
                    $("#bookTitle2").val(data.bookTitle);            
                    $("#progress2").val(data.progress);
                    $("#unreadChapters2").val(data.unreadChapters);
                    $("#subject2").val(data.subject);
                    $("#note2").val(data.note);
                    $("#demo2").val(data.demo);
                    $("#bookUse2").val(data.bookUse);
                    $("#format2").val(data.format);
                    $("#startDate2").val(data.startDate);
                    $("#endDate2").val(data.endDate);
                },
                dataType:"json"
            });
        }
        
        function modalUpdateSubmitBook() {    // 【修改】 将从修改的模太框中的表单获得的数据提交
            $.ajax({        
                type:"POST",    
                url:"<%=basePath%>deck/modalUpdateSubmitBook.action",
                data:$("#modalUpdate_formBook").serialize(),    // 获得修改的模态框中的表单
                success:function() {    
                    alert("修改书籍成功");
                    $("#bookUpdateModal").modal("hide");    
                    $(".modal-backdrop").remove();        // 去除,模态框修改数据后,灰屏
                    history.go(0);                        // 去除灰屏后,无法打开模态框,so刷新一下
                }                                            
            });  
        }
        
        function ajaxDelBook(id) {                // 【删除】使用AJAX提交id到服务器
            $.ajax({
                type:"POST",
                url:"<%=basePath%>deck/deleteBook.action",
                data:{"id":id},                    // 准备接收的是id
                success:function() {              // 返回通过id查询到的卡片的数据        
                    alert("删除成功");
                    history.go(0);
                }
            });
        }
        
        /* function todelect(){
            var Checkbox = false;                            //默认复选框为空
            $("input[name='id']").each(function(){            //获取复选框节点id
                if (this.checked==true) {        
                    Checkbox=true;                            //已勾选
                }
            });
            
            if (Checkbox){                                    //boolean值为true
                var t=confirm("您确认要删除选中的内容吗？");  //弹出对话进行警告
                if (t==false) return false;                    //不勾选不处理
                obj = document.getElementsByName("id");  //将复选框定义成一个jquery对象
                heck_val = [];                             //定义一个数组
                for(k in obj){                             //k相当于i,往这个jquery对象添加勾选的id;
                    if(obj[k].checked)                     //选中的都放进 数组里
                    check_val.push(obj[k].value);
                } */
        
            
        <%-- function deletsBook(ids) {                // 29 批量删除 修改版    
            alert("准备批量删除")
            alert(ids);
        
            $.ajax({
                type:"POST",
                url:"<%=basePath%>deck/deletesBook.action",
                data:{"ids":ids},
                success:function() {                  
                    alert("批量删除成功");
                    history.go(0);
                }
            });
        } --%>
        
        function checkBox(){    // 29 全选 当全选的复选框勾选时,设置主体中的复选框的值为勾选,为false。                    
            var checkAllEle = document.getElementById("ids");    
            if(checkAllEle.checked==true){         
                var checkOnes = document.getElementsByName("ids");
                for(var i=0;i<checkOnes.length;i++){
                    checkOnes[i].checked=true;
                }
            }else{        // 否则，即全不选，主体中的复选框的值什么都不传，并不是false。
                var checkOnes = document.getElementsByName("ids");
                for(var i=0;i<checkOnes.length;i++){
                    checkOnes[i].checked=false;        // 由于手动设置为false，最终才为false
                }
            }
        } 
        
        $(document).ready(function () {
            var time = new Date();
            var day = ("0" + time.getDate()).slice(-2);
            var month = ("0" + (time.getMonth() + 1)).slice(-2);
            var today = time.getFullYear() + "-" + (month) + "-" + (day);
            $('.date_info').val(today);
        })
        
</script>    


</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page trimDirectiveWhitespaces="true"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="itheima" uri="http://itcast.cn/common/"%>
<%
    String path = request.getContextPath();
    String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
            + path + "/";
%>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>管理系统的主页面</title>
<link href="<%=basePath%>css/bootstrap.min.css" rel="stylesheet">
<link href="<%=basePath%>css/metisMenu.min.css" rel="stylesheet">
<link href="<%=basePath%>css/dataTables.bootstrap.css" rel="stylesheet">
<link href="<%=basePath%>css/sb-admin-2.css" rel="stylesheet">
<link href="<%=basePath%>css/font-awesome.min.css" rel="stylesheet" type="text/css">
<link href="<%=basePath%>css/boot-crm.css" rel="stylesheet" type="text/css">
</head>
<body>
    
    <%-- 您使用的账户的用户名为: ${loginUserName } </br>  <!-- 显示用户信息   --> --%>
    <div class="text-right">                                    
        <c:if test="${empty loginUserName }">                          <!-- 【用户名显示】 -->
            <a href="<%=basePath%>/user/login.action">登录</a>          <!-- 【用户登录】 -->
            <a href="<%=basePath%>/user/toRegister.action">注册</a>      <!-- 【用户注册】 -->    
        </c:if>
        <c:if test="${!empty loginUserName }">
            欢迎您,${loginUserName } &nbsp;
            <a href="<%=basePath%>/user/myProfile.action">我的资料</a>
            <a href="<%=basePath%>/user/logOut.action">退出</a>
        </c:if>
    </div>
    
    <jsp:include   page="head.jsp" flush="true"/>    

<div class="col-sm-10"> 
    <div  id="mainContent">
<div class="panel panel-success">
    <div class="panel-heading">
        <h3 class="panel-title">卡片页面</h3>
    </div>
    <div class="panel-body">
        
        
        <form class="form-inline" action="${pageContext.request.contextPath }/card/list" method="post">
            <div class="form-group">
                <label for="Name">名称</label> 
                <input type="text" class="form-control" id="Name" 
                    value="${Name }" name="Name" >
            </div>
                
            <div class="form-group">
                <label for="raceFrom">种族</label> 
                <select    class="form-control" id="raceFrom" placeholder="种族" name="race" >
                        <option value="">${Race }</option>
                        <option value="">默认为空</option>
                        <option value ="兽族">兽族</option>
                        <option value ="岩石族">岩石族</option>
                        <option value="龙族">龙族</option>
                        <option value="植物族">植物族</option>
                        <option value="昆虫族">昆虫族</option>
                        <option value="魔法师族">魔法师族</option>
                </select>
            </div>
            
            <div class="form-group">
                <label>攻击力范围</label>
                <input id="atk1" name="atk1" /> -
                <input id="atk2" name="atk2" />
            </div>
            
            <button type="submit" class="btn btn-default">查询</button>
        </form>
    </div>
</div>

    <table class="table table-hover table-striped table-bordered">
        <thead>
            <tr>
                <th>ID</th>
                <th>名称</th>
                <th>属性</th>
                <th>种族</th>
                <th>攻击力</th>
                <th>守备力</th>
                <th>     <!-- 【添加】-->    
                    <button class="btn btn-primary btn-xs" data-toggle="modal" data-target="#AddModal">添加</button>
                    <button class="btn btn-primary btn-xs" >全选</button>
                </th>

            </tr>
        </thead>
        
        <tbody>    <!-- 使用分页查询后,由list改为了page.rows -->
            <c:forEach items="${page.rows}" var="list">
                <tr>
                    <td>${list.id}</td>
                    <td>${list.name}</td>
                    <td>${list.attribute}</td>
                    <td>${list.race}</td>
                    <td>${list.atk}</td>
                    <td>${list.def}</td>
<td>
<button class="btn btn-primary btn-xs" data-toggle="modal" 
data-target="#cardUpdateModal" onclick="showFormCard(${list.id})">修改</button>
<button class="btn btn-danger btn-xs" onclick="ajaxDelCard(${list.id})">删除</button>            
</td>
                </tr>
            </c:forEach>
        </tbody>
</table>
    
    总记录数: ${Total_number }    <br>
    总页数: ${totalPage_number } <br>
    当前页数: ${currentPage_number }    <br>
    每页显示条数: ${Size_number } <br>

    <!-- 分页按钮跳转 -->
    <div class="col-md-12 text-center">        
        <itheima:page url="${pageContext.request.contextPath }/card/list.action" />
    </div>
    
    
<!--【添加】 通过id可以打开 -->     
<div class="modal fade" id="AddModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-hidden="true">
                    &times;
                </button>
                <h4 class="modal-title" id="myModalLabel">
                    添加数据
                </h4>
            </div>
            <div class="modal-body">
    <!-- 【添加】 模态框中的表单form -->        
    <form class="form-horizontal" id="modaladdform">
        <div>
            <label>id:</label>
            <input type="text" id="id" name="id" autocomplete="off">
        </div>
        <div>
            <label>name:</label>
            <input type="text" id="name" name="name" autocomplete="off">
        </div>
        <div>
            <label>attribute:</label>
            <input type="text" id="attribute" name="attribute" autocomplete="off">
        </div>
        <div>
            <label>race:</label>
            <input type="text" id="race" name="race" autocomplete="off"> 
        </div>
        <div>
            <label>atk:</label>
            <input type="text" id="atk" name="atk" autocomplete="off">     
        </div>
        <div>
            <label>card_def:</label>
            <input type="text" id="def" name="def" autocomplete="off">
        </div>
    </form>                
</div>
            <div class="modal-footer">
                <button type="button" class="btn btn-primary" onclick="modalAddCard()">添加</button>
                <button type="button" class="btn btn-default" data-dismiss="modal">关闭</button>
            </div>
        </div>    
    </div>    
</div>    <!-- 【添加】 模态框的结束div，包含form -->

<!-- 【修改】 在模态框中修改表单、提交表单。需要表单有id才可能通过id进行操作 -->
<div class="modal fade" id="cardUpdateModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel2" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-hidden="true">
                    &times;
                </button>
                <h4 class="modal-title" id="myModalLabel2">
                    模态框标题：修改
                </h4>
            </div>
            <div class="modal-body">
    <!-- 【修改】 模态框中的表单form -->
    <form class="form-horizontal" id="modalUpdate_form">
        <div>
            <label>id:</label>
            <input type="text" id="id2" name="id" autocomplete="off">
        </div>
        <div>
            <label>name:</label>
            <input type="text" id="name2" name="name" autocomplete="off">
        </div>
        <div>
            <label>attribute:</label>
            <input type="text" id="attribute2" name="attribute" autocomplete="off">
        </div>
        <div>
            <label>race:</label>
            <input type="text" id="race2" name="race" autocomplete="off"> 
        </div>
        <div>
            <label>atk:</label>
            <input type="text" id="modalatk2" name="atk" autocomplete="off">     
        </div>
        <div>
            <label>def:</label>
            <input type="text" id="def2" name="def" autocomplete="off">
        </div>
    </form>                
        </div>    
            <div class="modal-footer">
                <button type="button" class="btn btn-primary" onclick="modalUpdateSubmit()">修改</button>
                <button type="button" class="btn btn-default" data-dismiss="modal">关闭</button>
            </div>
        </div>
    </div>
</div>        <!--【修改】 的结束div -->     

</div>
</div>

    <script src="<%=basePath%>js/jquery.min.js"></script>
    <script src="<%=basePath%>js/bootstrap.min.js"></script>
    <script src="<%=basePath%>js/metisMenu.min.js"></script>
    <script src="<%=basePath%>js/jquery.dataTables.min.js"></script>
    <script src="<%=basePath%>js/dataTables.bootstrap.min.js"></script>
    <script src="<%=basePath%>js/sb-admin-2.js"></script>    
    
<script type="text/javascript">

        function modalAddCard() {        // 【添加】 获得添加的模态框的表单中填写的数据
            $.ajax({        
                type:"POST",
                url:"<%=basePath%>card/add.action",
                data:$("#modaladdform").serialize(),        // 添加的模态框中的form的id
                success:function() {
                    alert("添加数据成功");
                    $("#AddModal").modal("hide");            // 通过模态框的id，隐藏模态框 
                    $(".modal-backdrop").remove();        // 去除,模态框添加后,灰屏
                    history.go(0);                        // 去除灰屏后,无法打开模态框,so刷新一下
                }
            });
        }
        
        function showFormCard(id) {            // 【修改】  打开模态框时显示"准备修改的内容" 
            $.ajax({
                type:"POST",
                url:"<%=basePath%>card/showFormCard.action",
                data:{"id":id},
                success:function(data) {                      // 返回通过id查询到的卡片数据    
                    $("#id2").val(data.id);                    // 将返回的数据，设置给form    
                    $("#name2").val(data.name);
                    $("#attribute2").val(data.attribute);
                    $("#race2").val(data.race);
                    $("#modalatk2").val(data.atk);
                    $("#def2").val(data.def);
                },
                dataType:"json"
            });
        }
        
        function modalUpdateSubmit() {    // 【修改】 将从修改的模太框中的表单获得的数据提交
            $.ajax({        
                type:"POST",    
                url:"<%=basePath%>card/modalUpdateSubmit.action",
                data:$("#modalUpdate_form").serialize(),    // 获得修改的模态框中的表单
                success:function() {                        
                    alert("修改数据并提交成功");                
                    $("#cardUpdateModal").modal("hide");    
                    $(".modal-backdrop").remove();        // 去除,模态框修改数据后,灰屏
                    history.go(0);                        // 去除灰屏后,无法打开模态框,so刷新一下
                }                                            
            });  
        }
        
        function ajaxDelCard(id) {            // 【删除】使用AJAX提交id到服务器
            $.ajax({
                type:"POST",
                url:"<%=basePath%>card/delete.action",
                data:{"id":id},                // 准备接收的是id
                success:function() {          // 返回通过id查询到的卡片的数据        
                    alert("删除成功");
                    history.go(0);
                }
            });
        }
        
</script>

</html>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page trimDirectiveWhitespaces="true"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="itheima" uri="http://itcast.cn/common/"%>
<%
    String path = request.getContextPath();
    String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
            + path + "/";
%>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>查看卡组</title>
<link href="<%=basePath%>css/bootstrap.min.css" rel="stylesheet">
<link href="<%=basePath%>css/metisMenu.min.css" rel="stylesheet">
<link href="<%=basePath%>css/dataTables.bootstrap.css" rel="stylesheet">
<link href="<%=basePath%>css/sb-admin-2.css" rel="stylesheet">
<link href="<%=basePath%>css/font-awesome.min.css" rel="stylesheet" type="text/css">
<link href="<%=basePath%>css/boot-crm.css" rel="stylesheet" type="text/css">

<script src="<%=basePath%>js/jquery.min.js"></script>
<script src="<%=basePath%>js/bootstrap.min.js"></script>
<script src="<%=basePath%>js/metisMenu.min.js"></script>
<script src="<%=basePath%>js/jquery.dataTables.min.js"></script>
<script src="<%=basePath%>js/dataTables.bootstrap.min.js"></script>
<script src="<%=basePath%>js/sb-admin-2.js"></script>
</head>
<body>
    
    <jsp:include   page="head.jsp" flush="true"/>
    
<div class="col-sm-10"> 
    <div  id="mainContent">
        
<div class="panel panel-info">
    <div class="panel-heading">
        <h3 class="panel-title">卡组页面</h3>
    </div>
    <div class="panel-body">
    

    <!-- 13 选择卡组 -->
    <form class="form-inline" action="${pageContext.request.contextPath }/deck/list" method="post">
        
        <!-- <select name="deckId">   原13选择卡组时,使用的单个列表,后改为列表联动,即17卡组联动
            <option value="1">自然竹笋</option>
            <option value="2">黑魔导少女</option>
        </select> -->
        
        <div class="form-group">
            <label for="province">种类</label>
            <select id="deckOne" name="deckOne" required>
                <option>--请先选择--</option>
                <option value="0">黑魔导</option>
                <option value="1">自然</option>
            </select>
            <select id="deckTwo" name="deckTwo">
                <option>--请再选择--</option>

            </select>
        </div>
        <button type="submit" class="btn btn-default">查询</button>
    </form>

            
    <!-- 19 卡组信息 -->
    <div>
         <label>卡组信息</label>
             <textarea name="deckInfo" maxlength="20" 
                 placeholder="请在列表中,选择不同种类和流派的卡组">${deckInfo}</textarea> 
    </div>
    
    <table class="table table-hover table-striped table-bordered">
        <thead>
            <tr>
                <th>ID</th>
                <th>名称</th>
                <th>属性</th>
                <th>种族</th>
                <th>攻击力</th>
                <th>守备力</th>
            </tr>
        </thead>
        
        <tbody>        <!-- 使用分页查询后,由list改为了page.rows -->
            <c:forEach items="${deckIdList}" var="list">
                <tr>
                    <td>${list.id}</td>
                    <td>${list.name}</td>
                    <td>${list.attribute}</td>
                    <td>${list.race}</td>
                    <td>${list.atk}</td>
                    <td>${list.def}</td>
                </tr>
            </c:forEach>
        </tbody>
    </table>

</div>
</div>

</div>
</div>    

<script type="text/javascript">
        
        $(function(){        // 17 卡组联动
            var cities = new Array(2);
            cities[0] = new Array("黑魔术师","黑魔导少女");
            cities[1] = new Array("自然竹笋","自然木鳞龙","自然木龙兽");
            
            $("#deckOne").change(function(){
                $("#deckTwo").empty();
                
                var val = this.value;
                $.each(cities,function(i,n){
                    if(val==i){
                        $.each(cities[i], function(j,m) {
                            var textNode = document.createTextNode(m);
                            var opEle = document.createElement("option");
                            $(opEle).append(textNode);
                            $(opEle).appendTo($("#deckTwo"));
                        });
                    }
                });
                
            });
        });

</script>

</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page trimDirectiveWhitespaces="true"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%
    String path = request.getContextPath();
    String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
            + path + "/";
%>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>左侧导航栏</title>
<link href="<%=basePath%>css/bootstrap.min.css" rel="stylesheet">
<link href="<%=basePath%>css/metisMenu.min.css" rel="stylesheet">
<link href="<%=basePath%>css/dataTables.bootstrap.css" rel="stylesheet">
<link href="<%=basePath%>css/sb-admin-2.css" rel="stylesheet">
<link href="<%=basePath%>css/font-awesome.min.css" rel="stylesheet" type="text/css">
<link href="<%=basePath%>css/boot-crm.css" rel="stylesheet" type="text/css">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://cdn.staticfile.org/font-awesome/4.7.0/css/font-awesome.css">

</head>
<body>
    <div class="col-sm-2"> 
        <div class="panel-body">
            <h4><i class="fa fa-pencil"></i> 所有菜单</h4>
            <ul class="nav nav-pills nav-stacked mail-nav" >
                <li><a href="<%=basePath%>/card/list" style="font-size:16px;">卡片</a></li>
                <li><a href="<%=basePath%>/deck/list" style="font-size:16px;">卡组</a></li>
                <li><a href="<%=basePath%>/deck/magic_trapList" style="font-size:16px;">魔陷</a></li>
                <li><a href="<%=basePath%>/book/list" style="font-size:16px;">书籍</a></li>
                <li><a href="<%=basePath%>/picture/list" style="font-size:16px;">图片</a></li>
                <li><a href="<%=basePath%>/test/into" style="font-size:16px;">测试</a></li>
            </ul>
        </div>
    </div>

<script src="<%=basePath%>js/jquery.min.js"></script>
<script src="<%=basePath%>js/bootstrap.min.js"></script>
<script src="<%=basePath%>js/metisMenu.min.js"></script>
<script src="<%=basePath%>js/jquery.dataTables.min.js"></script>
<script src="<%=basePath%>js/dataTables.bootstrap.min.js"></script>
<script src="<%=basePath%>js/sb-admin-2.js"></script>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page trimDirectiveWhitespaces="true"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%
    String path = request.getContextPath();
    String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
            + path + "/";
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>用户登录</title>
<link href="<%=basePath%>css/bootstrap.min.css" rel="stylesheet">
<link href="<%=basePath%>css/metisMenu.min.css" rel="stylesheet">
<link href="<%=basePath%>css/dataTables.bootstrap.css" rel="stylesheet">
<link href="<%=basePath%>css/sb-admin-2.css" rel="stylesheet">
<link href="<%=basePath%>css/font-awesome.min.css" rel="stylesheet" type="text/css">
<link href="<%=basePath%>css/boot-crm.css" rel="stylesheet" type="text/css">

<script src="<%=basePath%>js/jquery.min.js"></script>
<script src="<%=basePath%>js/bootstrap.min.js"></script>
<script src="<%=basePath%>js/metisMenu.min.js"></script>
<script src="<%=basePath%>js/jquery.dataTables.min.js"></script>
<script src="<%=basePath%>js/dataTables.bootstrap.min.js"></script>
<script src="<%=basePath%>js/sb-admin-2.js"></script>
</head>
<body>

    <!-- 7 用户名正确,密码密码时,重新进入登录页面  UsePasswordError -->
    <div>
        <c:if test="${!empty UsePasswordError }">        <!--当提示信息不为空时,才进入提示-->                      
            <font color="red" size="5" >${UsePasswordError }</font>
        </c:if>
    </div>

     <!-- 【用户登录】使用form表格提交，后续会在form中加入其它功能-->
    <form action="${pageContext.request.contextPath }/user/userLogin.action" method="post">    
        <div>
            <label>用户名：</label>
            <input id="username" type="text" name="username" autocomplete="off"
                value="${cookie.remembermeCookie.value}">    
        </div>
        <div>
            <label>密码： </label>
            <input id="password" type="password" name="password" 
                value="${cookie.remembermeCookiePassword.value}">
        </div>
    
        <div class="checkbox">    
            <label>     
                <!-- 14 记住用户名    -->
                <%-- <input type="checkbox" name="rememberme" value="1"
                    ${not empty cookie.remembermeCookie? "checked='checked'" : ""}> 
                    记住用户名 --%>
                    
                <!-- 16 记住用户名和密码 -->    
                <input type="checkbox" name="remembermePassword" value="1"
                ${not empty cookie.remembermeCookiePassword? "checked='checked'" : ""}> 
                    记住用户名和密码    
                    
            </label>
        </div>
        
        <div>
            <input id="login" class="btn btn-default" type="submit" value="登录" >    
            <input type="reset" class="btn btn-default" value="重置">
        </div>
    </form>
    
    <!-- 3 登录页面,添加注册链接 -->
    <div class="btn btn-default">
        <a href="<%=basePath%>/user/toRegister.action">注册</a>
    </div>
    
    <!-- 9 忘记密码  -->
    <div class="btn btn-default">
        <a href="<%=basePath%>/user/toForGet.action">忘记密码</a>    
    </div>
      
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page trimDirectiveWhitespaces="true"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%
    String path = request.getContextPath();
    String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
            + path + "/";
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>登录成功的页面</title>
<link href="<%=basePath%>css/bootstrap.min.css" rel="stylesheet">
<link href="<%=basePath%>css/metisMenu.min.css" rel="stylesheet">
<link href="<%=basePath%>css/dataTables.bootstrap.css" rel="stylesheet">
<link href="<%=basePath%>css/sb-admin-2.css" rel="stylesheet">
<link href="<%=basePath%>css/font-awesome.min.css" rel="stylesheet" type="text/css">
<link href="<%=basePath%>css/boot-crm.css" rel="stylesheet" type="text/css">

<script src="<%=basePath%>js/jquery.min.js"></script>
<script src="<%=basePath%>js/bootstrap.min.js"></script>
<script src="<%=basePath%>js/metisMenu.min.js"></script>
<script src="<%=basePath%>js/jquery.dataTables.min.js"></script>
<script src="<%=basePath%>js/dataTables.bootstrap.min.js"></script>
<script src="<%=basePath%>js/sb-admin-2.js"></script>
</head>
<body>

    <div>恭喜您登录成功</div>
    <%--  您使用的账户的用户名为: ${loginSuccessUserName } </br>  <!-- 显示用户信息   -->  --%>

    <!-- 2 上次登录时间 -->
    <div>您上次登录时间为: ${logintime }</div> 
    
    <!-- 12 历史登录次数 -->
    <div>您总共登录次数(算本次)为: ${loginNumber} </div>
    
    <!-- 从session中取出 -->
    <div>您使用的账户的用户名为: ${loginUserName }</div>     
    
    <a href="<%=basePath%>/user/myProfile.action">我的资料</a>    <br>
    <a href="<%=basePath%>user/homepage.action">进入主页面</a>    
    
    
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page trimDirectiveWhitespaces="true"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="itheima" uri="http://itcast.cn/common/"%>
<%
    String path = request.getContextPath();
    String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
            + path + "/";
%>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>查看魔法卡和陷阱卡列表</title>
<link href="<%=basePath%>css/bootstrap.min.css" rel="stylesheet">
<link href="<%=basePath%>css/metisMenu.min.css" rel="stylesheet">
<link href="<%=basePath%>css/dataTables.bootstrap.css" rel="stylesheet">
<link href="<%=basePath%>css/sb-admin-2.css" rel="stylesheet">
<link href="<%=basePath%>css/font-awesome.min.css" rel="stylesheet" type="text/css">
<link href="<%=basePath%>css/boot-crm.css" rel="stylesheet" type="text/css">

<script src="<%=basePath%>js/jquery.min.js"></script>
<script src="<%=basePath%>js/bootstrap.min.js"></script>
<script src="<%=basePath%>js/metisMenu.min.js"></script>
<script src="<%=basePath%>js/jquery.dataTables.min.js"></script>
<script src="<%=basePath%>js/dataTables.bootstrap.min.js"></script>
<script src="<%=basePath%>js/sb-admin-2.js"></script>
</head>
<body>
    
    <jsp:include   page="head.jsp" flush="true"/>
    
<div class="col-sm-10"> 
    <div  id="mainContent">
        
<div class="panel panel-primary">
    <div class="panel-heading">
        <h3 class="panel-title">魔法卡和陷阱卡展示的页面</h3>
    </div>
    <div class="panel-body">    

    <!-- 22 魔陷卡组新增  -->
    <form class="form-inline" action="${pageContext.request.contextPath }/deck/magic_trapOption" method="post">
        <div class="form-group">
            <label for="province">种类</label>
            <select id="magic_trapOne" name="magic_trapOne" required>
                <option>--请先选择--</option>
                <option value="0">魔法卡</option>
                <option value="1">陷阱卡</option>
            </select>
            <select id="magic_trapTwo" name="magic_trapTwo">
                <option>--请再选择--</option>

            </select>
        </div>
        <button type="submit" class="btn btn-default">查询</button>
    </form>
    

<form id="form2" action="${pageContext.request.contextPath }/deck/deletesMagicTrap" method="post">    
    
    <table class="table table-hover table-striped table-bordered">
        <thead>
            <tr>
<th><input type="checkbox" onclick="checkBox()"  id="ids" name="ids" value="" form="form2"></th>
                <th>卡片ID</th>
                <th>卡片名称</th>
                <th>卡片类型</th>
                <th>搭配卡组</th>
                <th>效果</th>
<th>                 <!-- 31 魔陷卡添加-->    
    <button type="button" class="btn btn-primary btn-xs" data-toggle="modal" data-target="#magicTrapAdd">添加</button>
    <input type="submit" value="删除" form="form2" class="btn btn-danger btn-xs">
</th>
            </tr>
        </thead>
        
        <tbody>        <!-- 使用分页查询后,由list改为了page.rows -->
            <c:forEach items="${magic_trapList}" var="list">
                <tr>
                    <td>
                        <input type="checkbox" name="ids" value="${list.magicTrapId}">
                        <input type="hidden" name="deletesCardId" value="${list.cardType}">
                    </td>
                    <td>${list.magicTrapId}</td>
                    <td>${list.cardName}</td>
                    <td>${list.cardType}</td>
                    <td>${list.deckMatch}</td>
                    <td>${list.effect}</td>
<td>        
    <%-- <button type="button" class="btn btn-primary btn-xs" 
        data-toggle="modal" data-target="#magicTrapUpdateModal" 
        onclick="showFormMagicTrap(${list.magicTrapId},${list.cardType})">修改</button> --%>
        
        <button type="button" class="btn btn-primary btn-xs" 
        data-toggle="modal" data-target="#magicTrapUpdateModal" 
        onclick="showFormMagicTrap('${list.magicTrapId}','${list.cardType}')">修改</button>

        <button type="button" class="btn btn-danger btn-xs"
        onclick="ajaxDelMagicTrap('${list.magicTrapId}','${list.cardType}')">删除</button>                
</td>
                </tr>
            </c:forEach>
        </tbody>
    </table>
</form>    <!-- 批量删除时用到的form -->    

</div>
</div>


</div>
</div>

<div class="modal fade" id="magicTrapAdd" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-hidden="true">
                    &times;
                </button>
                <h4 class="modal-title" id="myModalLabel">
                    添加魔陷卡
                </h4>
            </div>
            
<div class="modal-body">
<!-- 【添加】 模态框中的表单form -->        
<form class="form-horizontal" id="modaladdMagic_trap">
        <div>
            <label>卡片ID:</label>
            <input type="text" id="magicTrapId" name="magicTrapId" autocomplete="off">
        </div>
        <div>
            <label>卡片名称:</label>
            <input type="text" id="cardName" name="cardName" autocomplete="off">
        </div>
        <div>
            <label>卡片类型: </label>
            <select id="cardType" name="cardType" required>
                <option>--请选择--</option>
                <option value="场地魔法卡">场地魔法卡</option>
                <option value="普通魔法卡">普通魔法卡</option>
                <option value="普通陷阱卡">普通陷阱卡</option>
                <option value="反击陷阱卡">反击陷阱卡</option>
            </select>
        </div>
        <div>
            <label>搭配卡组:</label>
            <input type="text" id="deckMatch" name="deckMatch" autocomplete="off">
        </div>
        <div>
            <label>效果:</label>
            <input type="text" id="effect" name="effect" autocomplete="off"> 
        </div>
</form>                
</div>
            <div class="modal-footer">
                <button type="button" class="btn btn-primary" onclick="modalAddMagic_trap()">添加</button>
                <button type="button" class="btn btn-default" data-dismiss="modal">关闭</button>
            </div>
        </div>    
    </div>    
</div>    <!-- 【添加】 模态框的结束div，包含form -->

<!-- 魔陷的模态框修改  -->
<div class="modal fade" id="magicTrapUpdateModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel2" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-hidden="true">
                    &times;
                </button>
                <h4 class="modal-title" id="myModalLabel2">
                    修改魔陷卡
                </h4>
            </div>
            <div class="modal-body">

<!-- 【修改】 模态框中的表单form -->
    <form class="form-horizontal" id="modalUpdate_formMagicTrap">
        <div>
            <label>卡片ID:</label>
            <input type="text" id="magicTrapId2" name="magicTrapId"  readonly="readonly">
            目前禁止修改
        </div>
        <div>
            <label>卡片名称:</label>
            <input type="text" id="cardName2" name="cardName" autocomplete="off">
        </div>
        <div>
            <label>卡片类型: </label>
            <input type="text" id="cardType2" name="cardType" autocomplete="off">
        </div>
        <div>
            <label>搭配卡组:</label>
            <input type="text" id="deckMatch2" name="deckMatch" autocomplete="off">
        </div>
        <div>
            <label>效果:</label>
            <input type="text" id="effect2" name="effect" autocomplete="off"> 
        </div>
    </form>                
        </div>    
            <div class="modal-footer">
                <button type="button" class="btn btn-primary" onclick="modalUpdateSubmitMagicTrap()">修改</button>
                <button type="button" class="btn btn-default" data-dismiss="modal">关闭</button>
            </div>
        </div>
    </div>
</div>        <!--【修改】 的结束div -->


<script type="text/javascript">
        
        $(function(){        // 17 卡组联动
            var cities = new Array(2);
            cities[0] = new Array("场地魔法卡","普通魔法卡");
            cities[1] = new Array("普通陷阱卡","反击陷阱卡");
            
            $("#magic_trapOne").change(function(){
                $("#magic_trapTwo").empty();
                
                var val = this.value;
                $.each(cities,function(i,n){
                    if(val==i){
                        $.each(cities[i], function(j,m) {
                            var textNode = document.createTextNode(m);
                            var opEle = document.createElement("option");
                            $(opEle).append(textNode);
                            $(opEle).appendTo($("#magic_trapTwo"));
                        });
                    }
                });
                
            });
        });
        
        function modalAddMagic_trap() {            // 31添加  添加功能的模态框调用
            $.ajax({        
                type:"POST",
                url:"<%=basePath%>deck/addMagic_trap",
                data:$("#modaladdMagic_trap").serialize(),        // 添加的模态框中的form的id
                success:function() {
                    alert("添加魔陷卡成功");
                    $("#magicTrapAdd").modal("hide");        // 通过模态框的id，隐藏模态框 
                    $(".modal-backdrop").remove();            // 去除,模态框添加后,灰屏
                    history.go(0);                            // 去灰屏后,无法打开模态框,so刷新
                }
            });
        }
        
        // 32 显示查询  打开模态框时显示"准备修改的内容" 
        function showFormMagicTrap(magicTrapId,cardType) {    
//             alert("可以");
//             alert(magicTrapId);
//             alert(cardType);
                
            $.ajax({
                type:"POST",
                url:"<%=basePath%>deck/showFormMagicTrap",
                data:{"magicTrapId":magicTrapId, "cardType":cardType},
                success:function(data) {                              // 返回通过bookTitle查询    
                    $("#magicTrapId2").val(data.magicTrapId);        // 将返回的数据，设置给form    
                    $("#cardName2").val(data.cardName);                        
                    $("#cardType2").val(data.cardType);            
                    $("#deckMatch2").val(data.deckMatch);
                    $("#effect2").val(data.effect);
                },
                dataType:"json"
            });
        }

        function modalUpdateSubmitMagicTrap() {     // 32修改 将从修改的模太框中的表单获得的数据提交
            $.ajax({        
                type:"POST",    
                url:"<%=basePath%>deck/modalUpdateSubmitMagicTrap",
                data:$("#modalUpdate_formMagicTrap").serialize(),    // 获得修改的模态框中的表单
                success:function() {                        
                    alert("修改魔陷卡信息并提交成功");                
                    $("#magicTrapUpdateModal").modal("hide");    
                    $(".modal-backdrop").remove();        // 去除,模态框修改数据后,灰屏
                    history.go(0);                        // 去除灰屏后,无法打开模态框,so刷新一下
                }                                            
            });  
        }
        
        function ajaxDelMagicTrap(magicTrapId,cardType) {    // 34单次删除 使用AJAX提交id到服务器
            $.ajax({
                type:"POST",
                url:"<%=basePath%>deck/deleteMagicTrap",
                data:{"magicTrapId":magicTrapId, "cardType":cardType},        // 准备接收的是id
                success:function() {                                  
                    alert("删除成功");
                    history.go(0);
                }
            });
        }
        
        function checkBox(){    // 35 全选 当全选的复选框勾选时,设置主体中的复选框的值为勾选,为false。                    
            var checkAllEle = document.getElementById("ids");    
            if(checkAllEle.checked==true){         
                var checkOnes = document.getElementsByName("ids");
                for(var i=0;i<checkOnes.length;i++){
                    checkOnes[i].checked=true;
                }
            }else{        // 否则，即全不选，主体中的复选框的值什么都不传，并不是false。
                var checkOnes = document.getElementsByName("ids");
                for(var i=0;i<checkOnes.length;i++){
                    checkOnes[i].checked=false;        // 由于手动设置为false，最终才为false
                }
            }
        } 
        
</script>

</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page trimDirectiveWhitespaces="true"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%
    String path = request.getContextPath();
    String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
            + path + "/";
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>我的资料</title>
<link href="<%=basePath%>css/bootstrap.min.css" rel="stylesheet">
<link href="<%=basePath%>css/metisMenu.min.css" rel="stylesheet">
<link href="<%=basePath%>css/dataTables.bootstrap.css" rel="stylesheet">
<link href="<%=basePath%>css/sb-admin-2.css" rel="stylesheet">
<link href="<%=basePath%>css/font-awesome.min.css" rel="stylesheet" type="text/css">
<link href="<%=basePath%>css/boot-crm.css" rel="stylesheet" type="text/css">

<script src="<%=basePath%>js/jquery.min.js"></script>
<script src="<%=basePath%>js/bootstrap.min.js"></script>
<script src="<%=basePath%>js/metisMenu.min.js"></script>
<script src="<%=basePath%>js/jquery.dataTables.min.js"></script>
<script src="<%=basePath%>js/dataTables.bootstrap.min.js"></script>
<script src="<%=basePath%>js/sb-admin-2.js"></script>
</head>
<body>
    
    <a href="<%=basePath%>user/homepage.action" >进入主页面</a>    <br>
    
    <%-- ${loginUserName }  (目前用户名设置为不可以修改)  </br> --%>
    <%-- 2 我的名称是:${myProfileUser.getName() } --%>
    
    <!-- 28 修改我的资料  -->
    <form action="<%=basePath%>user/updateMyProfile.action" method="post">
        <div>
            <label>用户名:</label> 
            <!-- 禁止修改输入框中的数值,因为用户名要保证唯一性,方便查询数据表 -->
            <!-- 这里禁用修改,form也就不会提交,controller也就接收不到了 disabled="disabled"  -->
             <input type="text" value="${loginUserName }"  name="loginUserName">
        </div>
             
        <div>
            <!-- 如果newUpdate不为空,则显示,否则显示 -->
             <!-- ${not empty cookie.remembermeCookie? "checked='checked'" : ""} -->
              <label>名称:</label>
            <%-- <input type="text" value="${myProfileUser.getName() }" name="myProfileName" > --%>
              <input type="text" value="${empty newUpdate?myProfileUser.getName() : newUpdate }" 
                      name="myProfileName" >
        </div>
         
         <div>
             <label>个性签名</label>    
             <input type="text" value="${newMy }" name="my">
         </div>
         
         <!-- 18 长文本框 个人信息,最多20字 -->
         <div>
             <label>用户信息</label>
                 <textarea name="userInfo" maxlength="20" 
                     placeholder="请在此输入,最多20字">${newUserInfo }</textarea> 
         </div>
         
        <div>
            <input type="submit" class="btn btn-default" value="修改" >    
            <input type="reset" class="btn btn-default" value="重置">
        </div>
    </form>
    
    <!-- 8 设置密保问题 -->
    <br>
    <div> 设置密保问题,修改密码</div>
    <form action="<%=basePath%>/user/securityQuestion.action" method="post">
        <div>当前账户的用户名为: ${loginUserName }</div>
        
        <div>
            <label>用户名： </label>
            <input type="text" name="username" 
                value="${loginUserName }" readonly="true">
        </div>
        <div>
            <label>密保问题1: 最喜欢的颜色 </label>
            <input type="text" name="securityQuestion1" >
        </div>
        <div>
            <label>密保问题2: 最喜欢的事情 </label>
            <input type="text" name="securityQuestion2" >
        </div>
        <div>
            <label>密保问题3: 最喜欢的游戏</label>
            <input type="text" name="securityQuestion3" >
        </div>
        
        <div>
            <input type="submit" class="btn btn-default" value="修改" >    
            <input type="reset" class="btn btn-default" value="重置">
        </div>
    </form>
    
    <br>
    <!-- 使用修改功能时,要注意,目前已经使用了 事务管理
    如果两次输入的密码,错误(哪怕错一次),也是修改不成功的
    目前没有想出办法,怎么在这里获得用户名(主键),所以使用是模拟的用户名 1 -->

    <form action="<%=basePath%>user/UpdatePassword.action" method="post">
        <div>使用事务，修改密码</div>    
        <!-- 4-2 获得当前的用户名 -->
        <div>当前账户的用户名为: ${loginUserName }</div>
        
        <div>
            <label>用户名： </label>
            <input type="text" name="usernameUpdatePassword" 
                value="${loginUserName }" readonly="true">
        </div>

        <div>
            <label>第一次输入密码： </label>
            <input type="password" name="password1" >
        </div>
        
        <div>
            <label>第二次输入密码： </label>
            <input type="password" name="password2" >
        </div>
        
        <div>
            <label>想要修改的密码： </label>
            <input type="password" name="updatePassword" >
        </div>
    
        <div>
            <input type="submit" class="btn btn-default" value="修改" >    
            <input type="reset" class="btn btn-default" value="重置">
        </div>
    </form>
    
    <br>
    
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page trimDirectiveWhitespaces="true"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%
    String path = request.getContextPath();
    String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
            + path + "/";
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>图片</title>
<link href="<%=basePath%>css/bootstrap.min.css" rel="stylesheet">
<link href="<%=basePath%>css/metisMenu.min.css" rel="stylesheet">
<link href="<%=basePath%>css/dataTables.bootstrap.css" rel="stylesheet">
<link href="<%=basePath%>css/sb-admin-2.css" rel="stylesheet">
<link href="<%=basePath%>css/font-awesome.min.css" rel="stylesheet" type="text/css">
<link href="<%=basePath%>css/boot-crm.css" rel="stylesheet" type="text/css">

<script src="<%=basePath%>js/jquery.min.js"></script>
<script src="<%=basePath%>js/bootstrap.min.js"></script>
<script src="<%=basePath%>js/metisMenu.min.js"></script>
<script src="<%=basePath%>js/jquery.dataTables.min.js"></script>
<script src="<%=basePath%>js/dataTables.bootstrap.min.js"></script>
<script src="<%=basePath%>js/sb-admin-2.js"></script>
</head>
<body>
    <jsp:include   page="head.jsp" flush="true"/>
    
    <div class="col-sm-10"> 
    <div  id="mainContent">    
    
<div class="panel panel-info">
    <div class="panel-heading">
        <h3 class="panel-title">图片页面</h3>
    </div>
    <div class="panel-body">
    
    
        显示图片 <br>
        <a href="#"> 
            <img src="${pageContext.request.contextPath}/img/1.jpg" 
                width="144" height="108"/>
        </a>
    
    <br>
    <br>
    
    <!-- 上传图片是需要指定form的属性 enctype="multipart/form-data" -->
    <!-- <form id="itemForm" action="" method="post" enctype="multipart/form-data"> -->
    <!-- src="/pic/1.jpg"可以直接显示本地的图片-->
    <form id="itemForm"    action="<%=basePath%>/picture/picture2" method="post" enctype="multipart/form-data">
        <table width="100%" border=1>
            <tr>
                <td> 
                    <c:if test="${picName == null}">准备上传图片</c:if>
                    <c:if test="${picName != null}">预览(点击左侧图片菜单,重新进入后,可查看图片列表)</c:if>
                </td>
                <td>
                    <c:if test="${picName !=null}">
                        <img src="/pic/${picName}" width=100 height=100/>
                        <br/>
                    </c:if>
                    <input type="file"  name="pictureFile"/> 
                </td>
            </tr>
            
            <tr>
                <td><input type="submit" value="上传图片" /> </td>
            </tr>
        </table>

    </form>
    
    
    <table width="100%" class="table table-hover table-striped table-bordered"> 
        <thead>        
            <tr>    
                <th>图片</th>
            </tr>     
        </thead>     
             
        <tbody>        
          <tr>    
            <c:forEach items="${pictureList }" var="list">        
              <tr>         
                <td>
                    <img src="/pic/${list.picName} " width=100 height=100/>
                </td>
              </tr>
            </c:forEach>
          </tr>        
        </tbody>        
     </table>
    
    </div>    <!-- 左侧导航栏2,右侧侧内容10的结束div -->

</div>
</div>
</div>

</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page trimDirectiveWhitespaces="true"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%
    String path = request.getContextPath();
    String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
            + path + "/";
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>注册的页面</title>
<link href="<%=basePath%>css/bootstrap.min.css" rel="stylesheet">
<link href="<%=basePath%>css/metisMenu.min.css" rel="stylesheet">
<link href="<%=basePath%>css/dataTables.bootstrap.css" rel="stylesheet">
<link href="<%=basePath%>css/sb-admin-2.css" rel="stylesheet">
<link href="<%=basePath%>css/font-awesome.min.css" rel="stylesheet" type="text/css">
<link href="<%=basePath%>css/boot-crm.css" rel="stylesheet" type="text/css">

<script src="<%=basePath%>js/jquery-1.8.3.js"></script>

<script src="<%=basePath%>js/jquery.min.js"></script>
<script src="<%=basePath%>js/bootstrap.min.js"></script>
<script src="<%=basePath%>js/metisMenu.min.js"></script>
<script src="<%=basePath%>js/jquery.dataTables.min.js"></script>
<script src="<%=basePath%>js/dataTables.bootstrap.min.js"></script>
<script src="<%=basePath%>js/sb-admin-2.js"></script>
    
<script src="<%=basePath%>js/jquery.validate.min.js"></script>
<script src="<%=basePath%>js/messages_zh.js"></script>
<script src="<%=basePath%>js/demo1.js"></script>
</head>
<body>

    <!-- 6 用户登录失败,提示信息 loginFailure 这里的失败,实际上就是db中查询不到有这个对象 -->
    <!-- ${loginFailure } == 用户登录失败,请注册 -->
    <div>
        <!--当提示信息不为空时,才进行提示-->                      
        <c:if test="${!empty loginFailure }">        
            <font color="red" size="5" >${loginFailure }</font>
        </c:if>
    </div>

    <!-- 11【用户注册】 -->
    <form id="registerForm" action="${pageContext.request.contextPath }/user/register.action" method="post" >    
        <div>
            <label>用户名</label>
            <input id="username" type="text" name="username">
            <span id="usernameInfo"></span>        <!-- 【异步校验-注册用户名】  --> 
        </div>
                        
        <div>
            <label>密码</label>
            <input id="password1" type="password" name="password">
        </div>
                        
        <div>
            <label>确认密码</label>
            <input id="password2" type="password" name="password2" onkeyup="validate()">
            <span id="passwordVerify"></span>        <!-- 19 【密码不同】 提示信息 -->
        </div>
        
        <div>    <!-- 53 【完善表单】 新增邮箱、姓名、性别、出生日期。让注册时填写的信息更全面。 -->    
            <label>Email</label>
            <input type="text" name="email" id="email">
        </div>
        
        <div>    
            <label>姓名</label>
            <input type="text" name="name">
        </div>
    
        <!-- 1 省市联动 -->
        <div class="form-group">
            <label for="province">籍贯</label>
                <select id="province" name="provinces">
                <option>--请选择--</option>
                <option value="0">河北省</option>
                <option value="1">四川省</option>
                <option value="2">广东省</option>
                <option value="3">江西省</option>
            </select>
            <select id="city" name="provinceCity">
                <!-- <option value="0"></option>
                     <option value="1"></option>
                     <option value="2"></option> -->
            </select>
        </div>
        
        
        <div>
            <label>性别</label>
            <input type="radio" name="sex" value="男"/>男
            <input type="radio" name="sex" value="女"/>女
            <label for="sex" style="display: none;"></label>    <!-- class="error"作用是？ -->
        </div>
        
        <div>
            <label>出生日期</label>
            <input type="text" name="birthday">
        </div>
        
        <div>
            <input type="submit" class="btn btn-default" value="注册" name="submit" >
            <input type="reset" class="btn btn-default" value="重置">
        </div>
        
</form>

<%--     <script src="<%=basePath%>js/jquery-1.8.3.js"></script>

    <script src="<%=basePath%>js/jquery.min.js"></script>
    <script src="<%=basePath%>js/bootstrap.min.js"></script>
    <script src="<%=basePath%>js/metisMenu.min.js"></script>
    <script src="<%=basePath%>js/jquery.dataTables.min.js"></script>
    <script src="<%=basePath%>js/dataTables.bootstrap.min.js"></script>
    <script src="<%=basePath%>js/sb-admin-2.js"></script>
    
    <script src="<%=basePath%>js/jquery.validate.min.js"></script>
    <script src="<%=basePath%>js/messages_zh.js"></script>
    <script src="<%=basePath%>js/demo1.js"></script> --%>
    
<!-- <script src="js/jquery-1.11.3.min.js"></script> -->
<!-- 54 【表单校验】 引入的文件，共3个。在填写注册的表单时，填写错误时会有提示。防止填写错误的格式 -->
<!-- <script type="text/javascript" src="js/jquery-1.8.3.js"></script> -->
<!-- validate.js是建立在jquery之上的，所以得先导入jquery的类库-->
<!-- <script type="text/javascript" src="js/jquery.validate.min.js"></script> -->
<!-- 引入国际化js文件-->
<!-- <script type="text/javascript" src="js/messages_zh.js"></script> -->
<!-- 引入自定义的js文件 -->
<!-- <script src="js/demo1.js"></script> -->

<script type="text/javascript">     

    $(function(){        
        $("#registerForm").validate({                // 54 【表单校验】      
            rules:{                                    // 规则
                username:{
                    required:true,                    // 必须
                    minlength:2                        // 最小2位
                },
                password:{
                    required:true,                    // 必须    
                    digits:true,                    // 数字
                    minlength:1                        // 最小1位
                },
                // password2                        // 不能为空    
                password2:{
                    required:true,                    // 必须    
                },
                email:{                                // 邮箱格式
                    required:false,
                    email:true
                },
                name:{                                // 姓名
                    required:true,
                    maxlength:12
                },
                sex:{                                // 性别
                    required:true
                },
                birthday:{                            // 请输入有效的日期    新增 
                    required:true,                    // 必须
                    date:true
                }
            },
            messages:{                                // 消息
                username:{
                    required:"用户名不能为空!",
                    minlength:"用户名不得少于2位！"
                },
                password:{
                    required:"密码不能为空!",
                    digits:"密码必须是整数!",
                    minlength:"密码不得少于1位!"
                },
                password2:{
                    required:"密码不能为空!",
                },
                email:{
                    required:"邮箱不能为空!",
                    email:"邮箱格式不正确!"
                },
                name:{        
                    required:"姓名不能为空!",
                    maxlength:"姓名不得多于12位!"
                },
                sex:{
                    required:"性别必须勾选!"
                },
                birthday:{
                    required:"日期必须存在，日期格式(YYYY-MM-DD)",
                    date:"请输入有效的日期，日期格式(YYYY-MM-DD)"        //不写这一行，则为：请输入有效的日期
                }
            }
        });
    });        // 54 【表单校验】 的函数的结束括号


    $(function(){    
        $("#username").blur(function(){                    // 【异步校验-注册用户名】    
            var usernameInput = $(this).val();
            $.post(
                "<%=basePath%>user/ajaxUserName.action",
                {"username":usernameInput},
                function(data){                            // 服务器返回的json格式的数据
                    var isExist = data.isExist;            
//                     alert(isExist);                        // resultMap这种方式的测试
                    
                    var usernameInfo = "";
                    if(isExist){          
                        usernameInfo = "该用户名已经存在";
                        $("#usernameInfo").css("color","red");
                    }else{                
                        usernameInfo = "该用户名不存在，当符合校验规则时，可以使用√"
                        $("#usernameInfo").css("color","green");
                    }
                    $("#usernameInfo").html(usernameInfo);    
                },
                "json"
            );    //pose方法的结束括号
        });    // 获取username的值的方法的结束括号
    });    // 【异步校验-注册用户名】的结束括号
    
    
    // 【密码不同】 用户注册时，在表单中填写的两次密码，对两次的值进行判断，并提示相关信息
    // 获得两次输入的值、进行判断、根据结果显示相关的信息。不一样时，禁用使用注册按钮。
    function validate() {
        var password1 = document.getElementById("password1").value;
        var password2 = document.getElementById("password2").value;
        if(password1 == password2) {
            document.getElementById("passwordVerify").innerHTML="<font color='green'>两次密码相同</font>";
            document.getElementById("submit").disabled = false;     
            //disabled 禁用submit元素，由于设置的是false，即不能点击注册按钮
        }
        else {
            document.getElementById("passwordVerify").innerHTML="<font color='red'>两次密码不相同</font>";
            document.getElementById("submit").disabled = true;
            //disable 禁用submit元素，由于设置的是true，所以可以使用。
        }
    }
    
            /* 省市联动 */
            $(function(){
                var cities = new Array(1);
                cities[0] = new Array("河北省","石家庄市","唐山市","沧州市");
                cities[1] = new Array("四川省","成都市","乐山市","雅安市");
                cities[2] = new Array("广州省","汕头市","深圳市","潮州市");
                cities[3] = new Array("江西省","南昌市","九江市","赣州市");
                
                $("#province").change(function(){
                    $("#city").empty();
                    
                    var val = this.value;
                    $.each(cities,function(i,n){
                        if(val==i){
                            $.each(cities[i], function(j,m) {
                                var textNode = document.createTextNode(m);
                                var opEle = document.createElement("option");
                                $(opEle).append(textNode);
                                $(opEle).appendTo($("#city"));
                            });
                        }
                    });
                    
                });
            });
    
</script>    
    

</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page trimDirectiveWhitespaces="true"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%
    String path = request.getContextPath();
    String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
            + path + "/";
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>忘记密码时,重新设置密码的页面</title>
<link href="<%=basePath%>css/bootstrap.min.css" rel="stylesheet">
<link href="<%=basePath%>css/metisMenu.min.css" rel="stylesheet">
<link href="<%=basePath%>css/dataTables.bootstrap.css" rel="stylesheet">
<link href="<%=basePath%>css/sb-admin-2.css" rel="stylesheet">
<link href="<%=basePath%>css/font-awesome.min.css" rel="stylesheet" type="text/css">
<link href="<%=basePath%>css/boot-crm.css" rel="stylesheet" type="text/css">

<script src="<%=basePath%>js/jquery.min.js"></script>
<script src="<%=basePath%>js/bootstrap.min.js"></script>
<script src="<%=basePath%>js/metisMenu.min.js"></script>
<script src="<%=basePath%>js/jquery.dataTables.min.js"></script>
<script src="<%=basePath%>js/dataTables.bootstrap.min.js"></script>
<script src="<%=basePath%>js/sb-admin-2.js"></script>
</head>
<body>

    <div> 输入用户名,验证3个密保问题,然后可以修改密码</div>
    <form action="<%=basePath%>/user/toSQ.action" method="post">
        <div>
            <label>用户名： </label>
            <input type="text" name="username">
        </div>
        <div>
            <label>密保问题1: 最喜欢的颜色 </label>
            <input type="text" name="securityQuestion1" >
        </div>
        <div>
            <label>密保问题2: 最喜欢的事情 </label>
            <input type="text" name="securityQuestion2" >
        </div>
        <div>
            <label>密保问题3: 最喜欢的游戏</label>
            <input type="text" name="securityQuestion3" >
        </div>
        
        <div>
            <input type="submit" class="btn btn-default" value="验证" >    
            <input type="reset" class="btn btn-default" value="重置">
        </div>
    </form>
    
    
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page trimDirectiveWhitespaces="true"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%
    String path = request.getContextPath();
    String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
            + path + "/";
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>通过密保问题验证后,修改密码的页面</title>
<link href="<%=basePath%>css/bootstrap.min.css" rel="stylesheet">
<link href="<%=basePath%>css/metisMenu.min.css" rel="stylesheet">
<link href="<%=basePath%>css/dataTables.bootstrap.css" rel="stylesheet">
<link href="<%=basePath%>css/sb-admin-2.css" rel="stylesheet">
<link href="<%=basePath%>css/font-awesome.min.css" rel="stylesheet" type="text/css">
<link href="<%=basePath%>css/boot-crm.css" rel="stylesheet" type="text/css">

<script src="<%=basePath%>js/jquery.min.js"></script>
<script src="<%=basePath%>js/bootstrap.min.js"></script>
<script src="<%=basePath%>js/metisMenu.min.js"></script>
<script src="<%=basePath%>js/jquery.dataTables.min.js"></script>
<script src="<%=basePath%>js/dataTables.bootstrap.min.js"></script>
<script src="<%=basePath%>js/sb-admin-2.js"></script>
</head>
<body>
    
    <!-- 在通过密保问题验证后,需要重新设置密码 -->
    <form action="<%=basePath%>user/sQUpdatePassword.action" method="post">
        <div>
            <label>用户名： </label>
            <input type="text" value="${sQusername} " 
                name="sQusername" readonly="true">
        </div>
        
        <div>
            <label>想要修改的密码：</label>
            <input type="password" name="sQupdatePassword" >
        </div>
        <div>
            修改成功后,会自动进入登录页面
        </div>
        <div>
            <input type="submit" class="btn btn-default" value="修改" >    
            <input type="reset" class="btn btn-default" value="重置">
        </div>
    </form>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page trimDirectiveWhitespaces="true"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="itheima" uri="http://itcast.cn/common/"%>
<%
    String path = request.getContextPath();
    String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
            + path + "/";
%>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>测试SSM项目专用的页面</title>
<link href="<%=basePath%>css/bootstrap.min.css" rel="stylesheet">
<link href="<%=basePath%>css/metisMenu.min.css" rel="stylesheet">
<link href="<%=basePath%>css/dataTables.bootstrap.css" rel="stylesheet">
<link href="<%=basePath%>css/sb-admin-2.css" rel="stylesheet">
<link href="<%=basePath%>css/font-awesome.min.css" rel="stylesheet" type="text/css">
<link href="<%=basePath%>css/boot-crm.css" rel="stylesheet" type="text/css">

<script src="<%=basePath%>js/jquery.min.js"></script>
<script src="<%=basePath%>js/bootstrap.min.js"></script>
<script src="<%=basePath%>js/metisMenu.min.js"></script>
<script src="<%=basePath%>js/jquery.dataTables.min.js"></script>
<script src="<%=basePath%>js/dataTables.bootstrap.min.js"></script>
<script src="<%=basePath%>js/sb-admin-2.js"></script>

</head>
<body>

<ol>
    <li>
        <a href="${pageContext.request.contextPath }/test/session">获取session中的值</a>
    </li>
    <li>
        <a href="${pageContext.request.contextPath }/test/getSession">获取session中的值,映射多请求</a>
    </li>
    <li>
        <a href="${pageContext.request.contextPath }/test/params/626">只提交数值,@PathVariable</a>
    </li>
    <li>
        <a href="${pageContext.request.contextPath }/test/requestParam.html?name=shanhai">
        提交名称+数值,@RequestParam</a>
    </li>
    <li>
        <button class="btn btn-primary btn-xs" onclick="requestBody48()">@RequestBody</button>
    </li>
    <li>
        <input type="button" onclick="requestBody49()" value="测试49,传list到c层">
    </li>
    <li>
        <input type="button" onclick="requestBody50()" value="测试50,c层传java对象到ajax">
    </li>
    <li>
        <input type="button" onclick="requestBody51()" value="测试51,c层传list到ajax">
    </li>
    <li>
        <input type="button" onclick="requestBody52()" value="测试52,ajax传对象+list">
    </li>
    <li>
        <input type="button" onclick="requestBody53()" value="测试53,ajax注释">
    </li>
</ol>

<script type="text/javascript">

        function requestBody53() {                                // 写好注释 
            var saveDataAry=[];                                  // 声明一个js数组,用来保存数据 
            var data1={"userName":"山海","passWord":"123"};     // 声明一个对象,准备存入数组中
            var data2={"userName":"大地","passWord":"456"};
            var data3={"userName":"海洋","passWord":"789","name":"海"};   
//             var data4={"userName":"海洋","Test54":{[test54{"10", "11"},{"20", "21"}]}};   
            saveDataAry.push(data1);                              // 向数组存入对象     
            saveDataAry.push(data2);
            saveDataAry.push(data3);                            // 新增对象3,且对象3新增属性
//             saveDataAry.push(data4);                            // 新增对象4,且对象3新增数组 
            
            $.ajax({                                             
                type:"POST",                                 // 必须POST,因为get无请求体 
                url:"<%=basePath%>test/Test53", 
                dataType:"json",                              // 设置收到fu数据的格式
                contentType:"application/json",             // 设置发送给fu数据的格式
                data:JSON.stringify(saveDataAry),             // 将js值转为json字符串
                success:function(data){                     // 接收c层传递的java对象
//                     alert("c层传递java对象到ajax");    
//                     alert(data);                            // 直接data则会[object Object]
                    $.each(data,function(k,v){                // 遍历收到的对象中的属性 
                         alert(k +":"+ v);                        
                        });
                }
             }); 
        }
        


        function requestBody52() {
            $.ajax({ 
                type:"POST", 
                url:"<%=basePath%>test/requestBodyTest52.action", 
                dataType:"json",      
                contentType:"application/json",               
                data:{id:1,
                    address:[{
                                name:'贵州',
                                areaCode:'564432'
                            },
                            {
                                name:'西安',
                                areaCode:'512344'
                            }],
                },
                success:function(data){ 
                    alert("成功");                   
                }
             }); 
        }


        function requestBody51() {        // 51 c层传递list类型的对象 未解决
            var saveDataAry=[];                      
            var data1={"userName":"山海","passWord":"123"};  
            var data2={"userName":"大地","passWord":"456"};
            saveDataAry.push(data1);  
            saveDataAry.push(data2);
            
            $.ajax({ 
                type:"POST", 
                url:"<%=basePath%>test/requestBodyTest51.action", 
                dataType:"json",      
                contentType:"application/json",               
                data:JSON.stringify(saveDataAry), 
                success:function(data){ 
                    alert("controller层传递java对象到ajax中");
                    $.each(data,function(k,v){
                         alert(k +":"+ v);
                        });
                }
             }); 
        }


        function requestBody50() {            // 50 c层传递一个java对象给ajax
            var saveDataAry=[];  
            var data1={"userName":"山海","passWord":"123"};  
            var data2={"userName":"大地","passWord":"456"};
            saveDataAry.push(data1);  
            saveDataAry.push(data2);
            
            $.ajax({ 
                type:"POST", 
                url:"<%=basePath%>test/requestBodyTest50.action", 
                dataType:"json",      
                contentType:"application/json",               
                data:JSON.stringify(saveDataAry), 
                success:function(data){ 
                    alert("controller层传递java对象到ajax中");
                    $.each(data,function(k,v){                    // 遍历 
                         alert(k +":"+ v);
                        });
                    
//                     alert(data);                // [object Object]
//                     alert(data.username);       // undefined    
//                     alert("成功");                   
                }
             }); 
        }

        function requestBody49() {                        // 49 ajax提交List类型的对象
            var saveDataAry=[];  
            var data1={"userName":"山海","passWord":"123"};  
            var data2={"userName":"大地","passWord":"456"};
            saveDataAry.push(data1);  
            saveDataAry.push(data2);
            
            $.ajax({ 
                type:"POST", 
                url:"<%=basePath%>test/requestBodyTest49.action", 
                dataType:"json",      
                contentType:"application/json",               
                data:JSON.stringify(saveDataAry), 
                success:function(data){ 
                    alert(data);                // [object Object]
                    alert(data.username);       // undefined    
                    alert("成功");                   
                }
             }); 
        }
    
    
    function requestBody48() {                            // 测试RequestBody,但未能收到数据
        $.ajax({
            url:"<%=basePath%>test/requestBodyTest48.action",
            dataType:"json",
            contentType:"application/json",
            data:'{"userName":"admin","passWord","123"}',
            type:"post",
            success:function(data) {
                alert(data);
            },error:function(error){
                alert(error);
            }
        });
    }

</script>
    
</body>
</html>

 

 

SSM框架配置

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
  <display-name>yugioh6</display-name>
  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
    <welcome-file>index.htm</welcome-file>
    <welcome-file>index.jsp</welcome-file>
    <welcome-file>default.html</welcome-file>
    <welcome-file>default.htm</welcome-file>
    <welcome-file>default.jsp</welcome-file>
  </welcome-file-list>
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:spring/applicationContext-*.xml</param-value>
  </context-param>
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  <filter>
    <filter-name>encoding</filter-name>
    <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
    <init-param>
      <param-name>encoding</param-name>
      <param-value>UTF-8</param-value>
    </init-param>
  </filter>
  <filter-mapping>
    <filter-name>encoding</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>
  <servlet>
    <servlet-name>springmvc</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <init-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath:spring/springmvc.xml</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
  </servlet>
  <servlet-mapping>
    <servlet-name>springmvc</servlet-name>
    <url-pattern>/</url-pattern>
  </servlet-mapping>
</web-app>

 

 src/spring包下

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
    http://www.springframework.org/schema/context  http://www.springframework.org/schema/context/spring-context-4.0.xsd  http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd  http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">
    <!-- 以上为Spring的头文件，是Service层的 -->

    <!-- 配置Service扫描，包名可能会变 -->
    <context:component-scan base-package="shanhai.service" />
    
    
</beans>

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd http://www.springframework.org/schema/context  http://www.springframework.org/schema/context/spring-context-4.0.xsd
    http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd  http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">
    <!-- 以上为Spring的头文件，是Dao层的 -->

    <!-- 读取配置文件，文件名为jdbc.properties -->
    <context:property-placeholder location="classpath:spring/jdbc.properties" />
    
    <!-- 配置 数据源 -->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="${jdbc.driver}" />
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.username}" />
        <property name="password" value="${jdbc.password}" />
    </bean>
    
    <!-- 配置SqlSessionFactory -->
    <bean class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- 设置MyBatis核心配置文件，实际路径可能会变 -->
        <property name="configLocation" value="classpath:spring/SqlMapConfig.xml" />
        <!-- 设置数据源 -->
        <property name="dataSource" ref="dataSource" />
    </bean>
    
    <!-- 配置Mapper扫描 -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!-- 设置Mapper扫描包，包名可能会变 -->
        <property name="basePackage" value="shanhai.mapper" />
    </bean>
    
    <!-- 注解事务 -->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>
    
    <!-- 开启注解 -->
    <tx:annotation-driven transaction-manager="transactionManager"/>
</beans>

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

    <!-- 别名，包名可能会变 -->
    <typeAliases>
        <package name="shanhai.pojo"/>
    </typeAliases>

</configuration>

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/yugioh7?characterEncoding=utf-8
jdbc.username=真实名称
jdbc.password=真实密码

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p" xmlns:context="http://www.springframework.org/schema/context" xmlns:mvc="http://www.springframework.org/schema/mvc" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
    http://www.springframework.org/schema/mvc  http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd  http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">
    <!-- 以上为Spriv MVC的头文件，是Controller层的 -->
    
    <!-- 配置Controller扫描，包名可能会变 -->
    <context:component-scan base-package="shanhai.controller" />
    
    <!-- 配置注解驱动 -->
    <mvc:annotation-driven />
    
    <!-- 对静态资源放行  -->
    <mvc:resources location="/css/" mapping="/css/**"/>
    <mvc:resources location="/js/" mapping="/js/**"/>
    <mvc:resources location="/fonts/" mapping="/fonts/**"/>
    <mvc:resources location="/img/" mapping="/img/**"/>
    
    <!-- 上传图片配置实现类 -->
    <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
        <!-- 上传图片的大小   B   5M  1*1024*1024*5-->
        <property name="maxUploadSize" value="5000000"/>
     </bean>
    
    <!-- 配置视图解析器，jsp文件夹的位置改到了WEB-INF下，和lib文件夹同级 -->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <!-- 前缀 -->
        <property name="prefix" value="/WEB-INF/jsp/" />
        <!-- 后缀 -->
        <property name="suffix" value=".jsp" />
    </bean>
    
</beans>

 

pojo

package shanhai.pojo;

import java.io.Serializable;
import java.sql.Date;

public class Books implements Serializable{
    private static final long serialVersionUID = 1L;
    
    private int id;                            // ID
    private String bookTitle;                // 书名
    private String progress;                // 进度
    private String unreadChapters;            // 未读章节
    private String subject;                    // 科目
    private String note;                    // 笔记
    private String demo;                    // 阅读时的示例
    private String bookUse;                    // 使用
    private String format;                    // 书籍格式
    private Date startDate;                    // 起始阅读日期
    private Date endDate;                    // 结束阅读日期
    
    public Books() {
        super();
    }

    public Books(int id, String bookTitle, String progress, String unreadChapters, String subject, String note,
            String demo, String bookUse, String format, Date startDate, Date endDate) {
        super();
        this.id = id;
        this.bookTitle = bookTitle;
        this.progress = progress;
        this.unreadChapters = unreadChapters;
        this.subject = subject;
        this.note = note;
        this.demo = demo;
        this.bookUse = bookUse;
        this.format = format;
        this.startDate = startDate;
        this.endDate = endDate;
    }

    public Date getStartDate() {
        return startDate;
    }

    public void setStartDate(Date startDate) {
        this.startDate = startDate;
    }

    public Date getEndDate() {
        return endDate;
    }

    public void setEndDate(Date endDate) {
        this.endDate = endDate;
    }
    

    public int getId() {
        return id;
    }

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

    public String getBookTitle() {
        return bookTitle;
    }

    public void setBookTitle(String bookTitle) {
        this.bookTitle = bookTitle;
    }

    public String getProgress() {
        return progress;
    }

    public void setProgress(String progress) {
        this.progress = progress;
    }

    public String getUnreadChapters() {
        return unreadChapters;
    }

    public void setUnreadChapters(String unreadChapters) {
        this.unreadChapters = unreadChapters;
    }

    public String getSubject() {
        return subject;
    }

    public void setSubject(String subject) {
        this.subject = subject;
    }

    public String getNote() {
        return note;
    }

    public void setNote(String note) {
        this.note = note;
    }

    public String getDemo() {
        return demo;
    }

    public void setDemo(String demo) {
        this.demo = demo;
    }

    public String getBookUse() {
        return bookUse;
    }

    public void setBookUse(String bookUse) {
        this.bookUse = bookUse;
    }

    public String getFormat() {
        return format;
    }

    public void setFormat(String format) {
        this.format = format;
    }

    @Override
    public String toString() {
        return "Books [id=" + id + ", bookTitle=" + bookTitle + ", progress=" + progress + ", unreadChapters="
                + unreadChapters + ", subject=" + subject + ", note=" + note + ", demo=" + demo + ", bookUse=" + bookUse
                + ", format=" + format + ", startDate=" + startDate + ", endDate="
                + endDate + "]";
    }
}

package shanhai.pojo;

import java.io.Serializable;

// 目前只有一个空参,一个全参,全部的get/set方法,toString方法
// 在创建需要返回不同参数的Card对象时，需要留意是否有相应的构造方法
// 这是不会报异常的，到时出了问题后找不到原因，留个记录
// 接收注册的对象只会输出2个属性值,原来toString只设置了两个属性
public class Card implements Serializable{            
    private static final long serialVersionUID = 1L;
    
    private int id;
    private String name;
    private String attribute;
    private String race;
    private int atk;
    private int def;
    
    public Card() {
        super();
    }
    
    public Card(int id, String name, String attribute, String race, int atk, int def) {
        super();
        this.id = id;
        this.name = name;
        this.attribute = attribute;
        this.race = race;
        this.atk = atk;
        this.def = def;
    }
    
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getAttribute() {
        return attribute;
    }
    public void setAttribute(String attribute) {
        this.attribute = attribute;
    }
    public String getRace() {
        return race;
    }
    public void setRace(String race) {
        this.race = race;
    }
    public int getAtk() {
        return atk;
    }
    public void setAtk(int atk) {
        this.atk = atk;
    }
    public int getDef() {
        return def;
    }
    public void setDef(int def) {
        this.def = def;
    }

    @Override
    public String toString() {
        return "Card [id=" + id + ", name=" + name + ", attribute=" + attribute + ", race=" + race + ", atk=" + atk
                + ", def=" + def + "]";
    }
    
}

package shanhai.pojo;

public class Logininfo {                        // 表 logininfo  登录信息相关的内容
    private String username;                    // 用户名
    private String logintime;                    // 上次登录时间    
    private String securityQuestion1;            // 密保问题1
    private String securityQuestion2;            // 密保问题2
    private String securityQuestion3;            // 密保问题3
    private int loginNumber;                    // 历史登录次数
    
    public Logininfo() {
        super();
    }

    public Logininfo(String username, String logintime, String securityQuestion1, String securityQuestion2,
            String securityQuestion3, int loginNumber) {
        super();
        this.username = username;
        this.logintime = logintime;
        this.securityQuestion1 = securityQuestion1;
        this.securityQuestion2 = securityQuestion2;
        this.securityQuestion3 = securityQuestion3;
        this.loginNumber = loginNumber;
    }

    public int getLoginNumber() {        // 12 历史登录次数 的 get/set()
        return loginNumber;
    }

    public void setLoginNumber(int loginNumber) {
        this.loginNumber = loginNumber;
    }

    public String getSecurityQuestion1() {
        return securityQuestion1;
    }

    public void setSecurityQuestion1(String securityQuestion1) {
        this.securityQuestion1 = securityQuestion1;
    }

    public String getSecurityQuestion2() {
        return securityQuestion2;
    }

    public void setSecurityQuestion2(String securityQuestion2) {
        this.securityQuestion2 = securityQuestion2;
    }

    public String getSecurityQuestion3() {
        return securityQuestion3;
    }

    public void setSecurityQuestion3(String securityQuestion3) {
        this.securityQuestion3 = securityQuestion3;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getLogintime() {
        return logintime;
    }

    public void setLogintime(String logintime) {
        this.logintime = logintime;
    }
    
}

package shanhai.pojo;

import java.io.Serializable;

public class magic_trapCard implements Serializable{        // 魔法卡和陷阱卡
    private static final long serialVersionUID = 1L;
    private int magicTrapId;            // 魔陷卡ID
    private String cardName;            // 卡片名称
    private String cardType;            // 卡片类型
    private String deckMatch;            // 搭配的卡组
    private String effect;                // 效果
    
    public magic_trapCard() {
        super();
    }

    public magic_trapCard(int magicTrapId,String cardName, String cardType, String deckMatch,
            String effect) {
        super();
        this.magicTrapId = magicTrapId;
        this.cardName = cardName;
        this.cardType = cardType;
        this.deckMatch = deckMatch;
        this.effect = effect;
    }
    
    public int getMagicTrapId() {
        return magicTrapId;
    }

    public void setMagicTrapId(int magicTrapId) {
        this.magicTrapId = magicTrapId;
    }
    

    public String getEffect() {
        return effect;
    }
    

    public void setEffect(String effect) {
        this.effect = effect;
    }

    public String getDeckMatch() {
        return deckMatch;
    }

    public void setDeckMatch(String deckMatch) {
        this.deckMatch = deckMatch;
    }

    public String getCardName() {
        return cardName;
    }

    public void setCardName(String cardName) {
        this.cardName = cardName;
    }

    public String getCardType() {
        return cardType;
    }

    public void setCardType(String cardType) {
        this.cardType = cardType;
    }

    public String toString() {
        return "magic_trapCard [magicTrapId=" + magicTrapId + ", cardName=" + cardName + ", cardType=" + cardType
                + ", deckMatch=" + deckMatch + ", effect=" + effect + "]";
    }
}

package shanhai.pojo;

import java.util.ArrayList;
import java.util.List;

public class PageBean<T> {
    private int currentPage;        //当前页
    private int currentCount;        //当前页显示的条数
    private int totalCount;            //总条数
    private int totalPage;            //总页数
    private List<T> cardList = new ArrayList<T>();        //每页显示的数据
    private String likename;        //存储条件查询的关键字，在分页的情况下
    
    private int index;            // ServiceImpl根据(当前页面数-1)/总条数计算出来的分页查询条件
    
    public int getIndex() {
        return index;
    }
    public void setIndex(int index) {
        this.index = index;
    }
    public String getLikename() {
        return likename;
    }
    public String setLikename(String likename) {
        return this.likename = likename;
    }
    public int getCurrentPage() {
        return currentPage;
    }
    public void setCurrentPage(int currentPage) {
        this.currentPage = currentPage;
    }
    public int getCurrentCount() {
        return currentCount;
    }
    public void setCurrentCount(int currentCount) {
        this.currentCount = currentCount;
    }
    public int getTotalCount() {
        return totalCount;
    }
    public void setTotalCount(int totalCount) {
        this.totalCount = totalCount;
    }
    public int getTotalPage() {
        return totalPage;
    }
    public void setTotalPage(int totalPage) {
        this.totalPage = totalPage;
    }
    public List<T> getCardList() {
        return cardList;
    }
    public void setCardList(List<T> cardList) {
        this.cardList = cardList;
    }
}

package shanhai.pojo;

import java.util.ArrayList;
import java.util.List;

public class PageBean2<T> {
    private int currentPage;        //当前页
    private int currentCount;        //当前页显示的条数
    private int totalCount;            //总条数
    private int totalPage;            //总页数
    private List<T> cardList = new ArrayList<T>();        //每页显示的数据
    private String likename;        //存储条件查询的关键字，在分页的情况下
    
    private Integer size = 10;         //每页数
    private Integer startRow = 0;    //开始行    
    
    public String getLikename() {
        return likename;
    }
    public String setLikename(String likename) {
        return this.likename = likename;
    }
    public int getCurrentPage() {
        return currentPage;
    }
    public void setCurrentPage(int currentPage) {
        this.currentPage = currentPage;
    }
    public int getCurrentCount() {
        return currentCount;
    }
    public void setCurrentCount(int currentCount) {
        this.currentCount = currentCount;
    }
    public int getTotalCount() {
        return totalCount;
    }
    public void setTotalCount(int totalCount) {
        this.totalCount = totalCount;
    }
    public int getTotalPage() {
        return totalPage;
    }
    public void setTotalPage(int totalPage) {
        this.totalPage = totalPage;
    }
    public List<T> getCardList() {
        return cardList;
    }
    public void setCardList(List<T> cardList) {
        this.cardList = cardList;
    }
}

package shanhai.pojo;

public class Picture {
    private String picName;            // 图片的名称

    public Picture() {
        super();
    }
    
    public Picture(String picName) {
        super();
        this.picName = picName;
    }

    public String getPicName() {
        return picName;
    }

    public void setPicName(String picName) {
        this.picName = picName;
    }

    @Override
    public String toString() {
        return "Picture [picName=" + picName + "]";
    }
    
}

package shanhai.pojo;

public class QueryVo {
    // 每新增一个属性就要同时添加相应的get/set方法    
    String name;                        // 条件查询时使用的查询条件关键字
    String race;                        // 下拉列表时使用的种族
    
    Integer atk;
    Integer atk1;                        // 根据攻击力范围进行查询,使用的两个参数
    Integer atk2;
    
    private Integer page;                // 当前页
    private Integer size = 10;             // 每页数
    private Integer startRow = 0;        // 开始行
    
    public Integer getAtk() {
        return atk;
    }
    public void setAtk(Integer atk) {
        this.atk = atk;
    }
    public Integer getAtk1() {
        return atk1;
    }
    public void setAtk1(Integer atk1) {
        this.atk1 = atk1;
    }
    public Integer getAtk2() {
        return atk2;
    }
    public void setAtk2(Integer atk2) {
        this.atk2 = atk2;
    }
    
    public String getRace() {
        return race;
    }
    public void setRace(String race) {
        this.race = race;
    }
    
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    
    public Integer getPage() {
        return page;
    }
    public void setPage(Integer page) {
        this.page = page;
    }
    public Integer getSize() {
        return size;
    }
    public void setSize(Integer size) {
        this.size = size;
    }
    public Integer getStartRow() {
        return startRow;
    }
    public void setStartRow(Integer startRow) {
        this.startRow = startRow;
    }
    
}

package shanhai.pojo;

public class User {                    // yugioh7中user表,用于保存用户信息
    private String uid;                // user表使用的随机生成的字符串
    private String username;        // 用户名
    private String password;        // 密码
    private String email;            // 邮箱 新增
    private String name;            // 姓名 新增
    private String sex;                // 性别 新增
    private String provinces;        // 省市 新增
    private String provinceCity;
    
    private String birthday;        // 出生日期 新增
    private int state;                // 激活状态
    private String code;            // 激活码        由于要传入null只能使用String?
    private String my;                // 个性签名  
    private String userInfo;        // 用户信息
    
    // 新增属性后,要记得生成get/set方法,全参构造也要及时更新
    
    public User(String username, String password) {
        this.username = username;
        this.password = password;
    }
    
    public User( String uid, String username, String password) {    // 新增uid 
        this.uid = uid;
        this.username = username;
        this.password = password;
    }
    
    public User() {
    }
    
    // 全参构造,增加属性后要及时更新   ******
    public User(String uid, String username, String password, String email, 
            String name, String sex, String provinces,String provinceCity, 
            String birthday, int state, String code, String my, String userInfo) {
        super();
        this.uid = uid;
        this.username = username;
        this.password = password;
        this.email = email;
        this.name = name;
        this.sex = sex;
        this.provinces = provinces;
        this.provinceCity = provinceCity;
        this.birthday = birthday;
        this.state = state;
        this.code = code;
        this.my = my;
        this.userInfo = userInfo;
    }
    
    public String getUserInfo() {
        return userInfo;
    }

    public void setUserInfo(String userInfo) {
        this.userInfo = userInfo;
    }

    public String getProvinces() {            // 省市的get/set
        return provinces;
    }

    public void setProvinces(String provinces) {
        this.provinces = provinces;
    }

    public String getProvinceCity() {
        return provinceCity;
    }

    public void setProvinceCity(String provinceCity) {
        this.provinceCity = provinceCity;
    }

    public String getMy() {                // 个性签名的get和set方法
        return my;
    }

    public void setMy(String my) {
        this.my = my;
    }

    public String getCode() {            // 激活码 的get和set方法
        return code;
    }

    public void setCode(String code) {
        this.code = code;
    }

    public int getState() {                // 激活状态 的get和set方法
        return state;
    }

    public void setState(int i) {
        this.state = i;
    }

    public String getSex() {            // 性别 的get和set方法
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getBirthday() {            // 出生日期 的get和set方法
        return birthday;
    }

    public void setBirthday(String birthday) {
        this.birthday = birthday;
    }

    public String getEmail() {                // 邮箱 的get和Set方法
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getName() {                // 姓名 的get和Set方法
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getUid() {
        return uid;
    }

    public void setUid(String uid) {
        this.uid = uid;
    }

    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }

    @Override
    public String toString() {
        return "User [uid=" + uid + ", username=" + username + ", password=" + password + ", email=" + email + ", name="
                + name + ", sex=" + sex + ", birthday=" + birthday + ", state=" + state + ", code=" + code + ", my="
                + my + "]";
    }

}

package shanhai.pojo;

public class UserTest {
    private String userName;
    private String passWord;
    private String name;
    
    public UserTest() {
        super();
    }

    public UserTest(String userName, String passWord, String name) {
        super();
        this.userName = userName;
        this.passWord = passWord;
        this.name = name;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getPassWord() {
        return passWord;
    }

    public void setPassWord(String passWord) {
        this.passWord = passWord;
    }

    @Override
    public String toString() {
        return "UserTest [userName=" + userName + ", passWord=" + passWord + ", name=" + name + "]";
    }
}

 

utils包下的工具类

package utils;

import java.io.IOException;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.jsp.JspException;
import javax.servlet.jsp.JspWriter;
import javax.servlet.jsp.tagext.TagSupport;

/**
 * 显示格式 上一页 1 2 3 4 5 下一页
 */
public class NavigationTag extends TagSupport {    //只要继承这个类，就可以自定义
    
    
    static final long serialVersionUID = 2372405317744358833L;
    
    /**
     * request 中用于保存Page<E> 对象的变量名,默认为“page”
     */
    private String bean = "page";
    
    /**
     * 分页跳转的url地址,此属性必须
     */
    private String url = null;
    
    /**
     * 显示页码数量
     */
    private int number = 5;
    
    @Override
    public int doStartTag() throws JspException {
        JspWriter writer = pageContext.getOut();
        HttpServletRequest request = (HttpServletRequest) pageContext.getRequest();
        Page page = (Page)request.getAttribute(bean); 
        if (page == null) 
            return SKIP_BODY;
        url = resolveUrl(url, pageContext);
        try {
            //计算总页数
            int pageCount = page.getTotal() / page.getSize();
            if (page.getTotal() % page.getSize() > 0) {
                pageCount++;
            }
            writer.print("<nav><ul class=\"pagination\">");
            //显示“上一页”按钮
            if (page.getPage() > 1) {
                String preUrl = append(url, "page", page.getPage() - 1);
                preUrl = append(preUrl, "rows", page.getSize());
                writer.print("<li><a href=\"" + preUrl + "\">上一页</a></li>");
            } else {
                writer.print("<li class=\"disabled\"><a href=\"#\">上一页</a></li>");
            }
            //显示当前页码的前2页码和后两页码 
            //若1 则 1 2 3 4 5, 若2 则 1 2 3 4 5, 若3 则1 2 3 4 5,
            //若4 则 2 3 4 5 6 ,若10  则 8 9 10 11 12
            int indexPage = (page.getPage() - 2 > 0)? page.getPage() - 2 : 1;  
            for(int i=1; i <= number && indexPage <= pageCount; indexPage++, i++) {
                if(indexPage == page.getPage()) {
                    writer.print( "<li class=\"active\"><a href=\"#\">"+indexPage+"<span class=\"sr-only\">(current)</span></a></li>");
                    continue;
                }
                String pageUrl  = append(url, "page", indexPage);
                pageUrl = append(pageUrl, "rows", page.getSize());
                writer.print("<li><a href=\"" + pageUrl + "\">"+ indexPage +"</a></li>");
            }
            //显示“下一页”按钮
            if (page.getPage() < pageCount) {
                String nextUrl  = append(url, "page", page.getPage() + 1);
                nextUrl = append(nextUrl, "rows", page.getSize());
                writer.print("<li><a href=\"" + nextUrl + "\">下一页</a></li>");
            } else {
                writer.print("<li class=\"disabled\"><a href=\"#\">下一页</a></li>");
            }
            writer.print("</nav>");
        } catch (IOException e) {
            e.printStackTrace();
        }
        return SKIP_BODY;
    }
    
    private String append(String url, String key, int value) {

        return append(url, key, String.valueOf(value));
    }
    
    /**
     * 为url 参加参数对儿
     * 
     * @param url
     * @param key
     * @param value
     * @return
     */
    private String append(String url, String key, String value) {
        if (url == null || url.trim().length() == 0) {
            return "";
        }

        if (url.indexOf("?") == -1) {
            url = url + "?" + key + "=" + value;
        } else {
            if(url.endsWith("?")) {
                url = url + key + "=" + value;
            } else {
                url = url + "&amp;" + key + "=" + value;
            }
        }
        
        return url;
    }
    
    /**
     * 为url 添加翻页请求参数
     * 
     * @param url
     * @param pageContext
     * @return
     * @throws javax.servlet.jsp.JspException
     */
    private String resolveUrl(String url, javax.servlet.jsp.PageContext pageContext) throws JspException{
        //UrlSupport.resolveUrl(url, context, pageContext)
        Map params = pageContext.getRequest().getParameterMap();
        for (Object key:params.keySet()) {
            if ("page".equals(key) || "rows".equals(key)) continue;
            Object value = params.get(key);
            if (value == null) continue;
            if (value.getClass().isArray()) {
                url = append(url, key.toString(), ((String[])value)[0]);
            } else if (value instanceof String) {
                url = append(url, key.toString(), value.toString());
            }
        }
        return url;
    }
    
    

    /**
     * @return the bean
     */
    public String getBean() {
        return bean;
    }

    /**
     * @param bean the bean to set
     */
    public void setBean(String bean) {
        this.bean = bean;
    }

    /**
     * @return the url
     */
    public String getUrl() {
        return url;
    }

    /**
     * @param url the url to set
     */
    public void setUrl(String url) {
        this.url = url;
    }

    public void setNumber(int number) {
        this.number = number;
    }
    
}

package utils;

import java.util.List;

public class Page<T> {
    
    private int total;        // 总记录数,就是数据表中的总条数
    private int page;        // 当前页数,代表当前是第几页 
    private int size;        // 每页显示的条数大小
    private List<T> rows;
    public int getTotal() {
        return total;
    }
    public void setTotal(int total) {
        this.total = total;
    }
    public int getPage() {
        return page;
    }
    public void setPage(int page) {
        this.page = page;
    }
    public int getSize() {
        return size;
    }
    public void setSize(int size) {
        this.size = size;
    }
    public List<T> getRows() {
        return rows;
    }
    public void setRows(List<T> rows) {
        this.rows = rows;
    }
    
    
    
}

Web-INF下的tld

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE taglib
  PUBLIC "-//Sun Microsystems, Inc.//DTD JSP Tag Library 1.2//EN"
  "http://java.sun.com/dtd/web-jsptaglibrary_1_2.dtd">
<taglib>
    <tlib-version>2.0</tlib-version>
    <jsp-version>1.2</jsp-version>
    <short-name>common</short-name>
    <uri>http://itcast.cn/common/</uri>
    <display-name>Common Tag</display-name>
    <description>Common Tag library</description>

    <tag>
        <name>page</name>
        <tag-class>utils.NavigationTag</tag-class>
        <body-content>JSP</body-content>
        <description>create navigation for paging</description>
        <attribute>
            <name>bean</name>
            <rtexprvalue>true</rtexprvalue>
        </attribute>
        <attribute>
            <name>number</name>
            <rtexprvalue>true</rtexprvalue>
        </attribute>
        <attribute>
            <name>url</name>
            <required>true</required>
            <rtexprvalue>true</rtexprvalue>
        </attribute>
    </tag>
</taglib>

 

Linux部署Web项目， VMware + SSH Secure

 

Web项目部署

 

MySQL数据库列表