SpringMVC+Hibernate+Spring整合（二） (四)

package com.tgb.dao;

import java.util.List;

import com.tgb.entity.User;

public interface UserDao {

public User getUser(String id);

public List getAllUser();

public void addUser(User user);

public boolean delUser(String id);

public boolean updateUser(User user);
}
实现类UserDaoImpl：

[java] package com.tgb.dao;

import java.util.List;

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

import com.tgb.entity.User;

public class UserDaoImpl implements UserDao {

private SessionFactory sessionFactory;

public void setSessionFactory(SessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
}

@Override
public User getUser(String id) {

String hql = "from User u where u.id= ";
Query query = sessionFactory.getCurrentSession().createQuery(hql);
query.setString(0, id);

return (User)query.uniqueResult();
}

@Override
public List getAllUser() {

String hql = "from User";
Query query = sessionFactory.getCurrentSession().createQuery(hql);

return query.list();
}

@Override
public void addUser(User user) {
sessionFactory.getCurrentSession().save(user);
}

@Override
public boolean delUser(String id) {

String hql = "delete User u where u.id = ";
Query query = sessionFactory.getCurrentSession().createQuery(hql);
query.setString(0, id);

return (query.executeUpdate() > 0);
}

@Override
public boolean updateUser(User user) {

String hql = "update User u set u.userName = ,u.age= where u.id = ";
Query query = sessionFactory.getCurrentSession().createQuery(hql);
query.setString(0, user.getUserName());
query.setString(1, user.getAge());
query.setString(2, user.getId());

return (query.executeUpdate() > 0);
}

}

package com.tgb.dao;

import java.util.List;

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

import com.tgb.entity.User;

public class UserDaoImpl implements UserDao {

private SessionFactory sessionFactory;

public void setSessionFactory(SessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
}

@Override
public User getUser(String id) {

String hql = "from User u where u.id= ";
Query query = sessionFactory.getCurrentSession().createQuery(hql);
query.setString(0, id);

return (User)query.uniqueResult();
}

@Override
public List getAllUser() {

String hql = "from User";
Query query = sessionFactory.getCurrentSession().createQuery(hql);

return query.list();
}

@Override
public void addUser(User user) {
sessionFactory.getCurrentSession().save(user);
}

@Override
public boolean delUser(String id) {

String hql = "delete User u where u.id = ";
Query query = sessionFactory.getCurrentSession().createQuery(hql);
query.setString(0, id);

return (query.executeUpdate() > 0);
}

@Override
public boolean updateUser(User user) {

String hql = "update User u set u.userName = ,u.age= where u.id = ";
Query query = sessionFactory.getCurrentSession().createQuery(hql);
query.setString