/**
* 获得报错信息
*/
public String getErrmsg(){
return errMsg;
}
/**
*获得库存中超额和差额的备件种类
* @return 返回预警的备件种类信息
*/
private Vector getSpare(){
Vector vc = new Vector();
String sql = "select sp_sparetype from pm_spare where sp_stock > sp_max or sp_stock < sp_min order by sp_id";
try{
con = new DBConnection();
result = con.executeQuery(sql);
while (result.next()){
vc.add(result.getString(1));
}
result.close();
}catch (SQLException e){
errMsg = e.toString();
vc = null;
}catch (Exception e){
errMsg = e.toString();
vc = null;
}finally{
con.destroy();
return vc;
}
}
/**
* 获得有请购信息的管理处
* @return 管理处信息
*/
private Vector getBuy(){
Vector vc = new Vector();
String sql = "select ba_subcorp from pm_buyapply where ba_state =0 ";
try{
con = new DBConnection();
result = con.executeQuery(sql);
while (result.next()){
vc.add(result.getString(1));
}
result.close();
}catch(SQLException e){
errMsg = e.toString();
vc = null;
}catch(Exception e){
errMsg = e.toString();
vc = null;
}finally{
con.destroy();
return vc;
}
}
/**
* 获得到期提醒的房间租赁信息
* @param building 楼栋序号
* @return
*/
private Vector getTenancy (){
Vector vc = new Vector();
Vector tmp = new Vector();
StringBuffer sql = new StringBuffer();
try{
con = new DBConnection();
//获得房间的租赁信息
sql = new StringBuffer();
sql.append("select d.ro_building,a.te_room,a.te_begindate,a.te_enddate,").
append(" from pm_tenancy a,pm_client b,pm_feegettype c,pm_room d").
append(" where a.te_room=d.ro_code and a.te_client=b.cl_code and a.te_calcfee=c.ft_id ").
append(" and d.ro_hirestate=2 and a.te_quit=0").
append(" order by a.te_room,a.te_id desc");
result = con.executeQuery(sql.toString());
while(result.next()){
tmp.add(Tools.formatRoomno(result.getString(1)));
tmp.add(result.getString(2));
tmp.add(Tools.formatDate(result.getDate(3)));
tmp.add(result.getDate(4));
}
result.close();
java.util.Date enddate;
java.util.Date now = Tools.formatString(Tools.getNowString());
int days = 0;
for(int i=0;i<tmp.size();i=i+4){
enddate = (java.util.Date)tmp.get(i+3);
days = Tools.getDay(enddate,now);
if(enddate.compareTo(now) < 1 || days <= 7){
vc.add(tmp.get(i));
vc.add(tmp.get(i+1));
vc.add(tmp.get(i+2));
vc.add(Tools.formatDate((java.util.Date)tmp.get(i+3)));
执行到String sql = "select us_dept from pm_user where us_login ='"+ user +"'";
try{
result = con.executeQuery(sql);
就出现了java.lang.NullPointerExcetion
大虾估计是什么原因那?