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

wolf00781 2007-01-15 03:35:20
还总是出现端口错误十分的不稳定。不知道这方面有没有人遇到情况。
这两个类很简单,我把从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){}
}





}




...全文
140 1 打赏 收藏 转发到动态 举报
写回复
用AI写文章
1 条回复
切换为时间正序
请发表友善的回复…
发表回复
wolf00781 2007-01-15
  • 打赏
  • 举报
回复
每人啊哟,

62,612

社区成员

发帖
与我相关
我的任务
社区描述
Java 2 Standard Edition
社区管理员
  • Java SE
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧