usermanager.java

地址薄

package javabean;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

public class UserManager {

	private Dao dao=Dao.Instance();
	
	public UserManager()
	{
		
	}
	public int insertUserInfo(UserInfo userInfo)
	{		
		String sql="insert into userInfo (name,password,email,birthday) values ('"+userInfo.getName()
		  +"','"+userInfo.getPassword()+"','"+userInfo.getEmail()+"','"
		  +userInfo.getBirthday()+"')";
		int i=dao.executeUpdate(sql);
		return i;
	}
	
	public int deleteUserInfo(int id)
	{
	   String sql="delete userInfo where id="+id;
	   int i=dao.executeUpdate(sql);
	   return i;
	}
	
	public int updateUserInfo(UserInfo userInfo)
	{
	   String sql="update userInfo set name='"+userInfo.getName()+"',password='"+userInfo.getPassword()
	      +"',email='"+userInfo.getEmail()+"',birthday='"+userInfo.getBirthday()
	      +"' where id="+userInfo.getId();
	   int i=dao.executeUpdate(sql);
	   return i;
	}
	
	public Vector queryUserInfo(String condition)
	{
		ResultSet rs=dao.executeQuery(condition);
		Vector vector=new Vector();
		try {
			while(rs.next())
			{
				UserInfo userInfo=new UserInfo();
				userInfo.setId(rs.getInt("id"));
				userInfo.setName(rs.getString("name"));
				userInfo.setPassword(rs.getString("password"));
				userInfo.setEmail(rs.getString("email"));
				userInfo.setBirthday(rs.getDate("birthday").toString());
				vector.add(userInfo);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally
		{
			dao.CloseDB();
		}
		return vector;
	}
	
	public boolean isExisted(String name)
	{
		boolean flag=true;
		String sql="select * from userInfo where name='"+name+"'";
		Vector vector=queryUserInfo(sql);
		int i=vector.size();
		if(i==0)
			flag=false;
		return flag;
	}
	
	public boolean isRight(String name,String password)
	{
		boolean flag=false;
		String sql="select * from userInfo where name='"+name+"' and password='"+password+"'";
		Vector vector=queryUserInfo(sql);
		if(vector.size()==1)
			flag=true;
		return flag;
	}
	
	public UserInfo getUserInfo(String name,String password)
	{
		boolean flag=false;
		String sql="select * from userInfo where name='"+name+"' and password='"+password+"'";
		Vector vector=queryUserInfo(sql);
		if(vector.size()==1)
	    {
			UserInfo userInfo=(UserInfo)vector.elementAt(0);
			return userInfo;
		}
		return null;
	
	}
	
//	public static void main(String[] args)
//	{
//		UserManager userManager=new UserManager();
//		System.out.println(userManager.isRight("aaaa", "123"));
//	}
}