package com.yue.controller;
import java.util.List;
import javax.validation.Valid;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import com.yue.model.Page;
import com.yue.model.User;
import com.yue.service.UserService;
@Controller
public class MyBatisTest {
@Autowired
private UserService userService;
User user = new User();
Page page = new Page();
List<User> userAll;
@RequestMapping(value="findAllUser.do")
public String findAllUser(Model model){
System.out.println("------------------------------>findAllUser");
this.page = new Page();
List<User> users = userService.findAllUser();
userAll = users;
getPage(users,model);
getSubList(users,model);
return "main";
}
@RequestMapping(value="add")
public String add(){
System.out.println("------------------------------->add");
return "add";
}
@RequestMapping(value="alter")
public String alter(@RequestParam(value="id") int id,Model model){
System.out.println("------------------------------->alter");
for(int i=0;i<userAll.size();i++){
User user = userAll.get(i);
if(user.getId()==id){
model.addAttribute("user", user);
}
}
return "add";
}
@RequestMapping(value="mergeUser.do")
public String mergeUser(@ModelAttribute("user") @Valid User user,Model model){
System.out.println("-------------------------------->mergeUser");
userService.mergeUser(user);
List<User> users = userService.findAllUser();
userAll = users;
getPage(users,model);
getSubList(users,model);
return "main";
}
@RequestMapping(value="deleteUser.do")
public String deleteUser(@ModelAttribute("page") @Valid Page page,@RequestParam(value="id") int id,Model model){
System.out.println("-------------------------------->deleteUser");
this.page=page;
int flag = userService.deleteUser(id);
System.out.println("***flag="+flag);
List<User> users = userService.findAllUser();
if((page.getCurrentPage()-1)*page.getRowsPerPage() == users.size()){
page.setCurrentPage(page.getCurrentPage()-1);
}
userAll = users;
getPage(users,model);
getSubList(users,model);
return "main";
}
@RequestMapping(value="selectUser.do")
public String selectUser(@ModelAttribute("page") @Valid Page page,Model model){
System.out.println("------------------------------->selectUser");
this.page = page;
List<User> users = userService.selectUser(page.getUsername_cx());
userAll = users;
page.setRowsPerPage(3);
page.setCurrentPage(1);
getPage(users,model);
getSubList(users,model);
return "main";
}
@RequestMapping(value="turnPage.do")
public String turnPage(@ModelAttribute("page") @Valid Page page,Model model){
System.out.println("------------------------------->turnPage");
this.page = page;
getPage(userAll,model);
getSubList(userAll,model);
return "main";
}
public void getSubList(List<User> users,Model model){
int rowsCount = users.size();
int start = (page.getCurrentPage()-1)*page.getRowsPerPage() ;
int end = page.getCurrentPage()*page.getRowsPerPage() ;
int startIndex = start>rowsCount?1:start;
int endIndex = end>rowsCount?rowsCount:end;
List<User> userList = userAll.subList(startIndex,endIndex);
model.addAttribute("userList",userList);
}
public void getPage(List<User> users,Model model){
int rowsCount = users.size();
int totalPage = rowsCount/page.getRowsPerPage()+(rowsCount%page.getRowsPerPage()>0?1:0);
page.setRowsCount(rowsCount);
page.setTotalPage(totalPage);
model.addAttribute("page",page );
}
/*
@RequestMapping(value="insertUser.do")
public String insertUser(@ModelAttribute("user") @Valid User user){
System.out.println("------------------------------->insertUser");
int flag = userService.insertUser(user);
System.out.println("****flag="+flag);
return "hello";
}
@RequestMapping(value="updateUser")
public String updateUser(){
System.out.println("-------------------->updateUser");
user.setId(10);
user.setUsername("赵月10");
int flag = userService.updateUser(user);
System.out.println("***flag="+flag);
return "hello";
}*/
}
/*import java.io.IOException;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.Controller;
import com.yue.dao.UserDAO;
import com.yue.model.User;
public class MyBatisTest implements Controller{
public ModelAndView handleRequest(HttpServletRequest arg0,HttpServletResponse arg1) throws Exception {
SqlSession sqlSession = getSessionFactory().openSession();
UserDAO userDao = sqlSession.getMapper(UserDAO.class);
List<User> users = userDao.findUser();
System.out.println("------------------------------>selectUser");
for(int i=0;i<users.size();i++){
User user = users.get(i);
System.out.println("****username="+user.getUsername()+"****email="+user.getEmail());
}
System.out.println("------------------------------>insertUser");
User userModel = new User();
userModel.setEmail("98923892@163.com");
userModel.setId(322);
userModel.setUsername("testyueyue");
userModel.setPassword("123456");
int user_insert = userDao.insertUser(userModel);
System.out.println("insert_result="+user_insert);
return new ModelAndView("/hello");
}
private static SqlSessionFactory getSessionFactory() {
SqlSessionFactory sessionFactory = null;
String resource = "MyBatis-config.xml";
try {
sessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsReader(resource));
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return sessionFactory;
}
}
*/
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
mybatis.rar (59个子文件)
mybatis
需要的jar包.png 9KB
项目目录结构1.png 16KB
Spring-study
.settings
com.genuitec.eclipse.j2eedt.core.prefs 1009B
org.eclipse.wst.jsdt.ui.superType.name 6B
org.eclipse.ltk.core.refactoring.prefs 106B
org.eclipse.wst.common.project.facet.core.xml 252B
org.eclipse.core.resources.prefs 78B
org.eclipse.wst.common.component 474B
org.eclipse.wst.jsdt.ui.superType.container 49B
.jsdtscope 500B
org.eclipse.jdt.core.prefs 364B
src
mysql.properties 145B
MyBatis-config.xml 412B
com
yue
dao
mapper
userMapper.xml 2KB
IUser.java 345B
model
User.java 1KB
Page.java 933B
controller
MyBatisTest.java 6KB
service
UserService.java 783B
.project 2KB
WebRoot
META-INF
MANIFEST.MF 36B
WEB-INF
web.xml 1KB
classes
mysql.properties 145B
MyBatis-config.xml 412B
com
yue
dao
mapper
userMapper.xml 2KB
IUser.class 480B
model
User.class 2KB
Page.class 1KB
controller
MyBatisTest.class 5KB
service
UserService.class 1KB
index.jsp 46B
jsp
main.jsp 5KB
hello.jsp 839B
add.jsp 2KB
spring-mvc
daoContext.xml 2KB
spring-mvc.xml 1KB
lib
spring-beans-3.1.2.RELEASE.jar 578KB
spring-context-support-3.1.2.RELEASE.jar 105KB
mybatis-spring-1.1.0.jar 40KB
jsf-impl.jar 1.15MB
spring-tx-3.1.1.RELEASE.jar 241KB
spring-webmvc-3.1.2.RELEASE.jar 564KB
spring-asm-3.1.2.RELEASE.jar 52KB
jsf-api.jar 314KB
spring-context-3.1.2.RELEASE.jar 813KB
ojdbc6.jar 2.59MB
spring-expression-3.1.2.RELEASE.jar 172KB
commons-pool-1.3.jar 61KB
jstl-1.2.jar 405KB
spring-web-3.1.2.RELEASE.jar 536KB
spring-core-3.1.2.RELEASE.jar 439KB
spring-jdbc-3.1.1.RELEASE.jar 395KB
commons-logging-1.0.2.jar 26KB
spring-aop-3.1.2.RELEASE.jar 325KB
mybatis-3.1.1.jar 636KB
.mymetadata 309B
.classpath 2KB
.myeclipse
项目目录结构2.png 13KB
user_my.sql 2KB
共 59 条
- 1
zhaoxiaoyueyeu
- 粉丝: 13
- 资源: 7
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
- 3
- 4
- 5
前往页