我写的两个类来查询12张表，但是总是又数据丢失，就是说有些符合条件的数据不能够查询出来

Question

还总是出现端口错误十分的不稳定。不知道这方面有没有人遇到情况。
这两个类很简单，我把从12张表中查询出来的数据根据ID号加起来，载插入到一张表中
类Scoree:package jihes.jiheinfos;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
public class Scoree{
 private int a;
     private DBconn db=new DBconn();

    public int getX(int UserId,String Lastday,String Today,String table,int Y) 
                  throws NumberFormatException, SQLException{
       
        String sql="select count(HostManId)* '"+Y+"' from "+table+" where HostManId='"+UserId+"' and Times between '"+Lastday+"' and '"+Today+"'";
        ResultSet rs=db.executeQuery(sql);
                   while(rs.next()){
                    a=Integer.parseInt(rs.getString(1));
                            }
          return a;
         }//积分数
           
   public List scores(String Lastday,String Today) throws SQLException,Exception{
 List list=new ArrayList(); String SQL="select Id from Users  where LastTimes between '"+Lastday+"' and '"+Today+"'";
ResultSet rs=db.executeQuery(SQL);
while(rs.next()){ ScoreBean sb=new ScoreBean();
sb.setId(rs.getString("Id"));
list.add(sb);

      }
      
return list;
}   //有多少人员
    
}
类Score1：package jihes.jiheinfos;
import java.sql.*;
import java.util.*;
import java.text.*;
public class Score1 {

      public int Sum,Ids,Sums;
      public int Comm,Upload,Revert,Question,Group,Topic;
      public int Comms,Uploads,Reverts,Questions,Groups,Topics;
      
      private static String Today=null;
      private static String Lastday=null;
      Scoree sx=new Scoree();   
                                                             
     public Score1(){
       Calendar today=Calendar.getInstance();
            SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
           Today=sdf.format(today.getTime());
  
           today.add(Calendar.DATE,-7);            
           Lastday=sdf.format(today.getTime());
     }     public int getSum(int Id,String Lastday,String Today) throws NumberFormatException, SQLException{
 
      Sum=sx.getX(Id,Lastday,Today,"CostumeComm",1)+sx.getX(Id,Lastday,Today,"OrnamentComm",1)
           +sx.getX(Id,Lastday,Today,"ToiletryComm",1)+sx.getX(Id,Lastday,Today,"ShopComm",1)
         +sx.getX(Id,Lastday,Today,"Costume",3)+sx.getX(Id,Lastday,Today,"Ornament",3)
         +sx.getX(Id,Lastday,Today,"Toiletry",3)+sx.getX(Id,Lastday,Today,"Shop",3)
       
       +sx.getX(Id,Lastday,Today,"CostumeCommRevert",1)+sx.getX(Id,Lastday,Today,"OrnamentCommRevert",1)
       +sx.getX(Id,Lastday,Today,"ToiletryCommRevert",1)+sx.getX(Id,Lastday,Today,"ShopCommRevert",1)
       +sx.getX(Id,Lastday,Today,"UserTopicRevert",1)+sx.getX(Id,Lastday,Today,"QuesRevert",1)
       
       +sx.getX(Id,Lastday,Today,"UserGroupTopic",1)+sx.getX(Id,Lastday,Today,"Question",2)
       +sx.getX(Id,Lastday,Today,"QuesRes",2);
  
      return Sum;        
   }                        
   
     public int getComm(int Id,String Lastday,String Today) throws NumberFormatException,SQLException{
       Comm=sx.getX(Id,Lastday,Today,"CostumeComm",1)+sx.getX(Id,Lastday,Today,"OrnamentComm",1)
         +sx.getX(Id,Lastday,Today,"ToiletryComm",1)+sx.getX(Id,Lastday,Today,"ShopComm",1);
      
       return Comm;     
     }   
     
     public int getUpload(int Id,String Lastday,String Today) throws NumberFormatException,SQLException{
      Upload=+sx.getX(Id,Lastday,Today,"Costume",1)+sx.getX(Id,Lastday,Today,"Ornament",1)
    +sx.getX(Id,Lastday,Today,"Toiletry",1)+sx.getX(Id,Lastday,Today,"Shop",1);
      
      return Upload;
     }
     
     public int getQuestion(int Id,String Lastday,String Today)throws NumberFormatException,SQLException{
      Question=sx.getX(Id,Lastday,Today,"Question",1);
      
      return Question;
     } 
     
     public int getRevert(int Id,String Lastday,String Today)throws NumberFormatException,SQLException{
      Revert=sx.getX(Id,Lastday,Today,"CostumeCommRevert",1)+sx.getX(Id,Lastday,Today,"OrnamentCommRevert",1)
  +sx.getX(Id,Lastday,Today,"ToiletryCommRevert",1)+sx.getX(Id,Lastday,Today,"ShopCommRevert",1)
  +sx.getX(Id,Lastday,Today,"UserTopicRevert",1)+sx.getX(Id,Lastday,Today,"QuesRevert",1);
      
      return Revert;
     }     
     
     public int getGroup(int Id,String Lastday,String Today)throws NumberFormatException,SQLException{
      Group=sx.getX(Id,Lastday,Today,"UserGroup",1);
      
      return Group;
     }
     
     public int getTopic(int Id,String Lastday,String Today)throws NumberFormatException,SQLException{
      Topic=sx.getX(Id,Lastday,Today,"UserGroupTopic",1);
      
      return Topic;
     }
                  
     
 public void scoress() throws Exception{     
   Score1 score1=new Score1();
   DBconn db=new DBconn();
   String SQL="delete Scores";
   db.executeDelete(SQL); 
           List list=sx.scores(score1.Lastday,score1.Today);
   Iterator iter=list.iterator();
   try{
   while(iter.hasNext()){
   ScoreBean sb=(ScoreBean)iter.next();
   Ids=Integer.parseInt(sb.getId());    
           Sums=getSum(Ids,score1.Lastday,score1.Today);
              
           Comms=getComm(Ids,score1.Lastday,score1.Today);
           Uploads=getUpload(Ids,score1.Lastday,score1.Today);
           Questions=getQuestion(Ids,score1.Lastday,score1.Today);
           Reverts=getRevert(Ids,score1.Lastday,score1.Today);
           Groups=getGroup(Ids,score1.Lastday,score1.Today);
           Topics=getTopic(Ids,score1.Lastday,score1.Today);
                  
          
           //System.out.print(Ids+"/");
           //System.out.print(Sums+"/");
           /** System.out.print(Comms+"/");
           System.out.print(Uploads+"/");
           System.out.print(Questions+"/");
          System.out.print(Reverts+"*");  
          */     
          String sqls="insert into Scores values('"+Ids+"','"+Sums+"','"+Comms+"','"+Uploads+"','"+Questions+"','"+Reverts+"','"+Groups+"','"+Topics+"')";
       //String sqls="insert into Scores(UserId,Score) values('"+Ids+"','"+Sums+"')";
           db.executeUpdate(sqls);     
   
       } 
   }catch(Exception e){}              
  }   
 
 

           

}