userdaoesql.java

JSP+AJAX开发的聊天室(毕业设计)

package org.yeeku.dao.esql;

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



import org.yeeku.model.*;
import org.yeeku.dao.*;

public class UserDaoEsql extends BaseDao implements UserDao  
{
    /**
     * 根据id查找用户
     * @param id 需要查找的用户id
     */  
    public User get(int id) throws Exception
    {
        String sql = "select id,username,password,lasttime from user_message where id="+id;
	return esql.query(User.class, sql);
       
    }

    /**
     * 增加用户
     * @param user 需要增加的用户
     */       
    public void save(User user) throws Exception
    {  
        esql.update("insert into user_message(username,password,lasttime)values(?,?,?)",user.getUsername(),user.getPassword(),user.getLasttime());

    }

    /**
     * 修改用户
     * @param user 需要修改的用户
     */  
    public void update(User user) throws Exception
    {
         esql.update("insert into user_message(username,password,lasttime)values(?,?,?)",user.getUsername(),user.getPassword(),user.getLasttime());
    }

    /**
     * 删除用户
     * @param id 需要删除的用户id
     */  
    public void delete(int id) throws Exception
    {
         String sql = "delete from user_message where id="+id;
	 esql.update(sql);
    }

    /**
     * 删除用户
     * @param user 需要删除的用户
     */  
    public void delete(User user) throws Exception
    {
        int id=user.getId();
         String sql = "delete from user_message where id="+id;
	 esql.update(sql);
    }

    /**
     * 查询全部用户
     * @return 获得全部用户
     */ 
    public List<User> findAll() throws Exception
    {
        String sql = "select id,username,password,lasttime from user_message";
	return esql.list(User.class, sql);
    }

    /**
     * 根据用户名，密码查找用户
     * @param username 查询所需的用户名
     * @param pass 查询所需的密码
     * @return 对应的用户
     */ 
    public User findUserByNameAndPass(String user , String pass) throws Exception
    {
         
        List ul=esql.list(User.class,"select id,username,password,lasttime from user_message au where au.username = ? and au.password = ?",user,pass);
        if (ul != null && ul.size() >= 1)
        {
            return (User)ul.get(0);
        }
        return null;
    }

    /**
     * 根据用户名查找用户
     * @param user 查询所需的用户名
     * @return 对应的用户
     */ 
    public User findUserByName(String user) throws Exception
	{
          List ul=esql.list(User.class,"select id,username,password,lasttime from user_message au where au.user = ?",user);
          if (ul != null && ul.size() >= 1)
           {
             return (User)ul.get(0);
           }
          return null;
	}
   
    public List<Message> checkNewMessage(String name) throws Exception
     {
        return esql.list(Message.class,"select id,fromUser,toUser,content,messageTime,isnew from message au where au.toUser = ? and au.isnew=1",name);
       
      }
    public  List<Message> getMessageByName(String name) throws Exception 
      {
         return esql.list(Message.class,"select id,fromUser,toUser,content,messageTime,isnew from message au where au.toUser = ? order by id",name);
        
      }
    public List<Message> getMessageFrom(String fromname,String username) throws Exception
       {
          return esql.list(Message.class,"select id,fromUser,toUser,content,messageTime,isnew from message au where au.fromUser = ? and au.toUser= ? order by id",fromname,username);
        
       }
    public void saveMessage(Message message) throws Exception
      {            
         esql.update("insert into message(fromUser,toUser,messageTime,isnew,content)values(?,?,?,?,?)",message.getFromuser(),message.getTouser(),message.getMessagetime(),message.getIsnew(),message.getContent());
      }
      public void deleteMessage(int id) throws Exception
      {
          String sql = "delete from message where id="+id;
	  esql.update(sql);
      }
}