public List selectByUser(String userName,String userPassword){
List list=new ArrayList();
try{
conn=baseDao.getConnection();
String sql="select * from admin where userName=? and userPasswrod=?";
pStatement=conn.prepareStatement(sql);
pStatement.setString(1,userName);
pStatement.setString(2,userPassword);
rs=pStatement.executeQuery();
while(rs.next()){
Admin admin=new Admin();
admin.setUserName(rs.getString("userName"));
admin.setUserPassword(rs.getString("userPasswrod"));
admin.setName(rs.getString("name"));
admin.setAge(rs.getInt("age"));
admin.setBirthday(rs.getString("birthday"));
admin.setNation(rs.getString("nation"));
admin.setSex(rs.getString("sex"));
list.add(admin);
}
}catch(Exception e){
e.printStackTrace();
}finally{
baseDao.closeResultSet(rs);
baseDao.closePreparedStatement(pStatement);
baseDao.closeConnection(conn);
}
return list;
}
这是在实体层上写的方法。我在Servlet里面进行调用
List list= eService.selectByUser(userName, userPassword);//红色部分报错
for(int i=0;i<list.size();i++){
enterService es=list.get(i);
session.setAttribute("list", es);
}
List list=new ArrayList();
try{
conn=baseDao.getConnection();
String sql="select * from admin where userName=? and userPasswrod=?";
pStatement=conn.prepareStatement(sql);
pStatement.setString(1,userName);
pStatement.setString(2,userPassword);
rs=pStatement.executeQuery();
while(rs.next()){
Admin admin=new Admin();
admin.setUserName(rs.getString("userName"));
admin.setUserPassword(rs.getString("userPasswrod"));
admin.setName(rs.getString("name"));
admin.setAge(rs.getInt("age"));
admin.setBirthday(rs.getString("birthday"));
admin.setNation(rs.getString("nation"));
admin.setSex(rs.getString("sex"));
list.add(admin);
}
}catch(Exception e){
e.printStackTrace();
}finally{
baseDao.closeResultSet(rs);
baseDao.closePreparedStatement(pStatement);
baseDao.closeConnection(conn);
}
return list;
}
这是在实体层上写的方法。我在Servlet里面进行调用
List list= eService.selectByUser(userName, userPassword);//红色部分报错
for(int i=0;i<list.size();i++){
enterService es=list.get(i);
session.setAttribute("list", es);
}
List import错了,import java.awt.List了?