spring+springmvc+hibernate crud

一.vo User实体类
package com.vo;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

import org.hibernate.annotations.GenericGenerator;

@Entity
@Table(name=”user”)
public class User {
@Id
@GeneratedValue(strategy=GenerationType.AUTO)
private int id ;
@Column
private String name;
@Column(length=32)
private String pwd;
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 getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}

}
二：service
package com.service;

import java.util.List;

import com.vo.User;

public interface UserService {
public int add(User user);
public int delete(User user);
public int update(User user);
public User getById(int id);
public List getAll();
public User login(User user);
public User out(User user);

}

三：UserviceServiceImpl
package com.service.impl;

import java.util.List;

import com.dao.UserDao;
import com.service.UserService;
import com.vo.User;

public class UserviceServiceImpl implements UserService{
private UserDao userDao;
public void setUserDao(UserDao userDao) {
this.userDao = userDao;
}
public UserDao getUserDao() {
return userDao;
}
@Override
public int add(User user) {

    return userDao.add(user);}@Overridepublic int delete(User user) {    return userDao.delete(user);}@Overridepublic int update(User user) {    return userDao.update(user);}@Overridepublic User getById(int id) {    return userDao.getById(id);}@Overridepublic List<User> getAll() {    return userDao.getAll();}@Overridepublic User login(User user) {    return userDao.login(user);}@Overridepublic User out(User user) {    return userDao.out(user);}

}
四：userdao
package com.dao;

import java.util.List;

import com.vo.User;

public interface UserDao {
public int add(User user);
public int update(User user);
public int delete(User user);
public User getById(int id);
public List getAll();
public User login(User user);
public User out(User user);

}
五：UserDaoImpl
package com.daoimpl;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.SessionFactory;

import com.dao.UserDao;
import com.vo.User;

public class UserDaoImpl implements UserDao {
private static SessionFactory sessionFactory;
public static void setSessionFactory(SessionFactory sessionFactory) {
UserDaoImpl.sessionFactory = sessionFactory;
}

@Overridepublic int add(User user) {    return  (Integer) this.sessionFactory.getCurrentSession().save(user);}@Overridepublic int update(User user) {    String  hql=" INSERT  into   `user`  (id,name,pwd) VALUES (?,?,?) ";    Query   q  =sessionFactory.getCurrentSession().createQuery(hql);    q.setInteger(0,user.getId());    q.setString(1, user.getName());    q.setString(2, user.getPwd());    q.executeUpdate();    return 1;}@Overridepublic int delete(User user) {    String  hql="DELETE  from   user  WHERE  id =? ";    Query   q  = sessionFactory.getCurrentSession().createQuery(hql);    q.setInteger(0, user.getId());    q.executeUpdate();    return 1;}@Overridepublic User getById(int id) {    String  sql="SELECT  *  from   `user`   WHERE  id  =?  " ;    Query  q   = sessionFactory.getCurrentSession().createQuery(sql);    q.setInteger(0, id);    q.executeUpdate();    return null;}@Overridepublic List<User> getAll() {    String  hql=" * from  user   " ;    Query q  = sessionFactory.getCurrentSession().createQuery(hql);    q.executeUpdate();          return q.list();}@Overridepublic User login(User user) {    String  hql ="SELECT  *  from   `user`   WHERE  `name` = ?  and pwd =?  " ;    Query  q  =sessionFactory.getCurrentSession().createQuery(hql);    q.setString(0, user.getName());    q.setString(1, user.getPwd());    q.executeUpdate();    return user;}@Overridepublic User out(User user) {    sessionFactory.getCurrentSession().clear();    return user;}

}
六：controller
package com.controller;

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

import com.service.UserService;
import com.vo.User;
@Controller
public class UserController {
@Autowired
private UserService userService ;
public void setUserService(UserService userService) {
this.userService = userService;
}
@RequestMapping(“/add.do”)
public String add(User user){
userService.add(user);
//跳到list.jsp
return “list”;

}@RequestMapping("/delete.do")public String    delete(User  user){    userService.delete(user);    //跳到list.jsp    return "list";}@RequestMapping("/update.do")public String    update(User  user){    userService.update(user);    //跳到list.jsp    return "list";}@RequestMapping("/getAll.do")public String    getAll(){    userService.getAll();    //跳到list.jsp    return "list";}@RequestMapping("/getById.do")public String    getById(int  id){    userService.getById(id);    //跳到list.jsp    return "list";}

}

七：配置文件
web.xml