personalinfo.java

完成图书管理系统的一些简单的功能

package dal;
import java.sql.*;
import java.util.*;
import model.*;
import util.Database;
import iDal.IPersonalInfo;;
public class PersonalInfo implements IPersonalInfo {
	public PersonalInfo()
	{}
	public ArrayList<User> getUserInfoById(String id)
	{
		ArrayList<User> alUser=new ArrayList<User>();
		Database db=new Database();
		String[] str=id.split(",");
		int i=0;
		String sql=new String();
		try{
		while(true)
		{
			if(str[i]!=null)
			{
				sql="select * from tb_user where userid='" + str[i] + "'";
				ResultSet rs=db.executeQuery(sql);
				User user=new User(rs.getString("userid"),rs.getString("password"),rs.getString("username"),rs.getByte("sex"),rs.getDate("birthday"),rs.getString("tel"),rs.getString("email"),rs.getString("address"),rs.getString("question"),rs.getString("answer"),rs.getDate("regtime"));
				alUser.add(user);
			}
			else break;
		}
		}catch(Exception e)
		{
			System.err.print("Unhandled Exception!");
		}
		return alUser;
	}
	
}