好像这个错误是很简单的,只是好久没弄了,就突然还是患了
/**
* 根据用户组代号和部门编号得到用户组所有的成员
* @param userid1
* @return
*/
public static List getDepartmentPerson(String departid,String usercode)
{
// UserNameGroup usernamegroup=new UserNameGroup();
String sql=null;
CEgovDB db = null;
Connection mConn = null;
Statement mStmt = null;
ResultSet mRs = null;
List list=new ArrayList();
try {
db = new CEgovDB();
mConn=db.getConnection();
mStmt=mConn.createStatement();
sql="select id,code,name,departid from t_user"+
" where departid='"+departid+"' and code<>'"+usercode+"'";
mRs=mStmt.executeQuery(sql);
if(mRs==null)
{
return list;
}
while(mRs.next()){
UserNameGroup usernamegroup=new UserNameGroup();
usernamegroup.setId(mRs.getString("id"));
usernamegroup.setCode(mRs.getString("code"));
usernamegroup.setName(mRs.getString("name"));
usernamegroup.setDepartid(mRs.getString("departid"));
list.add(usernamegroup);
}
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
} catch (NamingException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
return list;
}
与
/**
* 根据用户组代号和部门编号得到用户组所有的成员
* @param userid1
* @return
*/
public static List getDepartmentPerson(String departid,String usercode)
{
UserNameGroup usernamegroup=new UserNameGroup();
String sql=null;
CEgovDB db = null;
Connection mConn = null;
Statement mStmt = null;
ResultSet mRs = null;
List list=new ArrayList();
try {
db = new CEgovDB();
mConn=db.getConnection();
mStmt=mConn.createStatement();
sql="select id,code,name,departid from t_user"+
" where departid='"+departid+"' and code<>'"+usercode+"'";
mRs=mStmt.executeQuery(sql);
if(mRs==null)
{
return list;
}
while(mRs.next()){
// UserNameGroup usernamegroup=new UserNameGroup();
usernamegroup.setId(mRs.getString("id"));
usernamegroup.setCode(mRs.getString("code"));
usernamegroup.setName(mRs.getString("name"));
usernamegroup.setDepartid(mRs.getString("departid"));
list.add(usernamegroup);
}
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
} catch (NamingException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
return list;
}
第二个是错的,好像这个错蛮经典的!