// �d�ߦC��
public List<Admin> queryAdminList() throws SQLException {
sql = "SELECT A.ID,A.ACCOUNT,A.PASSWORD,A.ROLE " + "FROM HUR_ADMIN A ";
List<Admin> list = new ArrayList<Admin>();
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(sql);
while (rs.next()) {
Admin admin = new Admin();
admin.setUserid(rs.getString("ID"));
admin.setAccount(rs.getString("ACCOUNT"));
admin.setPassword(rs.getString("PASSWORD"));
admin.setRole(rs.getString("ROLE"));
list.add(admin);
}
st.close();
rs.close();
return list;
}
public Admin queryAdminByAccount(String account) throws SQLException {
Admin admin = null;
sql = "SELECT A.ID,A.ACCOUNT,A.PASSWORD,A.ROLE " + "FROM HUR_ADMIN A " + "WHERE A.ACCOUNT=? ";
PreparedStatement pst;
pst = conn.prepareStatement(sql);
pst.setString(1, account);
ResultSet rs = pst.executeQuery();
while (rs.next()) {
admin = new Admin();
admin.setUserid(rs.getString("ID"));
admin.setAccount(rs.getString("ACCOUNT"));
admin.setPassword(rs.getString("PASSWORD"));
admin.setRole(rs.getString("ROLE"));
}
pst.close();
rs.close();
return admin;
}
