/**
*
*/
package com.szz.bean;
import com.szz.base.bean.BaseObject;
/**
* @author Administrator
*
*/
public class User extends BaseObject {
private String ID;
/**
* @return the iD
*/
public String getID() {
return ID;
}
/**
* @param iD the iD to set
*/
public void setID(String iD) {
ID = iD;
}
/**
* @return the nAME
*/
public String getNAME() {
return NAME;
}
/**
* @param nAME the nAME to set
*/
public void setNAME(String nAME) {
NAME = nAME;
}
/**
* @return the pASSWORD
*/
public String getPASSWORD() {
return PASSWORD;
}
/**
* @param pASSWORD the pASSWORD to set
*/
public void setPASSWORD(String pASSWORD) {
PASSWORD = pASSWORD;
}
private String NAME;
private String PASSWORD;
/* (non-Javadoc)
* @see com.szz.base.bean.BaseObject#toString()
*/
/* (non-Javadoc)
* @see java.lang.Object#toString()
*/
@Override
public String toString() {
return "User [ID=" + ID + ", NAME=" + NAME + ", PASSWORD=" + PASSWORD
+ "]";
}
}
二、創建com.szz.dao包；裡面用來定義需要對數據進行操作的實體類型DAO接口
/**
*
*/
package com.szz.dao;
import java.util.List;
import com.szz.bean.User;
/**
* @author Administrator
*
*/
public interface UserDao {
/*
* 查詢
*/
public List selectAll();
public User findById(String id);
public User findByUserName(String userName);
public int countAll();
/*
* 更新刪除插入
*/
public int insert(User user);
public int update(User user);
public int delete(String userName);
/* //返回插入數據的ID
public int findInsertUserID(User user);*/
/*//批處理 插入多條數據
public void insertUsers(List users);*/
}
insert into SM_USER(ID,NAME,PASSWORD) VALUES(#{ID},#{NAME},#{PASSWORD})
update SM_USER
NAME=#{NAME},PASSWORD=#{PASSWORD}
where ID=#{ID}
delete FROM SM_USER WHERE ID=#{ID}
package com.szz.service;
import java.util.List;
import com.szz.bean.User;
public interface UserService {
public List getUsers();
/*
* 濡傛灉ID涓虹┖灏辨壘username 濡傛灉username涓虹┖灏辨壘ID锛?閮藉～鎸夌収ID
*/
public User getUserInfo(String ID,String userName);
public int getCount();
// public int saveUser(User user);
public int insertUser(User user);
public int updateUser(User user);
public int deleteUser(String ID);
}
七‘services接口的實現類 serviceImpl
/**
*
*/
package com.szz.service.impl;
import java.util.List;
import org.mybatis.spring.SqlSessionTemplate;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.szz.bean.User;
import com.szz.dao.UserDao;
import com.szz.service.UserService;
/**
* @author Administrator
*
*/
@Service("userService")
public class UserServiceImpl implements UserService {
@Autowired
private UserDao userDao;
/*
@Autowired
private SqlSessionTemplate sessionTemplate;*/
public UserDao getUserDao() {
return userDao;
}
/**
* @param userDao the userDao to set
*/
public void setUserDao(UserDao userDao) {
this.userDao = userDao;
}
@Override
public List getUsers() {
// TODO Auto-generated method stub
return userDao.selectAll();
//return sessionTemplate.getMapper(UserDao.class).selectAll();
}
@Override
public User getUserInfo(String ID, String userName) {
// TODO Auto-generated method stub
if(ID!=null){
return userDao.findById(ID);
}
else
return userDao.findByUserName(userName);
}
@Override
public int getCount() {
// TODO Auto-generated method stub
return userDao.countAll();
}
@Override
public int insertUser(User user) {
// TODO Auto-generated method stub
return userDao.insert(user);
}
@Override
public int updateUser(User user) {
// TODO Auto-generated method stub
return userDao.update(user);
}
@Override
public int deleteUser(String ID) {
// TODO Auto-generated method stub
return userDao.delete(ID);
}
}
八、創建控制類controller包/**
/**
*
*/
package com.szz.action;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.PathVariable;
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.servlet.ModelAndView;
import com.szz.base.acion.BaseAction;
import com.szz.bean.User;
import com.szz.service.UserService;
/**
* @author Administrator
*
*/
@Controller
@RequestMapping(value="/user")
public class UserAction extends BaseAction {
@Autowired
private UserService userService;
@RequestMapping(value="/login",method=RequestMethod.POST)
public String login(){
return "redirect:/user/userList";
}
@RequestMapping(value="userList")
public ModelAndView showAll(){
System.out.println("index......");
ModelAndView MV = new ModelAndView("user/index");
List userList = new ArrayList();
userList = userService.getUsers();
MV.addObject("userList",userList);
return MV;
}
@RequestMapping(value="/add")
public ModelAndView login(HttpServletRequest request,@RequestParam(value="username", required=true, defaultValue="szz") String name){
System.out.println("/user/login....");
ModelAndView mv = new ModelAndView("user/success");
mv.addObject("add", "娣誨姞");
return mv;
}
@RequestMapping(value="/edituser")
public ModelAndView edit(@RequestParam(value="ID") String ID){
ModelAndView mv = new ModelAndView("user/edit");
User user = userService.getUserInfo(ID, null);
mv.addObject("user",user);
return mv;
}
@RequestMapping(value="/deleteuser")
public String deleteuser(@RequestParam(value="ID") String ID){
userService.deleteUser(ID);
return "redirect:/user/userList";
}
@RequestMapping(value="/userset",method=RequestMethod.POST)
public String user(@ModelAttribute("user")User user ) {
System.out.println(user.getNAME());
return "user/success";
}
@RequestMapping(value="/insertuser",method=RequestMethod.POST)
public String insertUser( User userInfo ) throws Exception {
userService.insertUser(userInfo);
return "redirect:/user/userList";
}
@RequestMapping(value="/updateuser",method=RequestMethod.POST)
public String updateUser( User userInfo ) throws Exception {
userService.updateUser(userInfo);
return "redirect:/user/userList";
}
}
