还总是出现端口错误十分的不稳定。不知道这方面有没有人遇到情况。
这两个类很简单,我把从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){}
}
}
这两个类很简单,我把从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){}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货