import java.sql.*;
import java.util.*;
import java.text.*;
public class Score1 {
public int Sum,Ids,Sums;
DBconn db=new DBconn();
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,-60);
Lastday=sdf.format(today.getTime());
}
public void scoress() throws Exception{ //Scoree ss=new Scoree();
List list=sx.scores(Lastday,Today);
Iterator iter=list.iterator();
while(iter.hasNext()){
ScoreBean sb=(ScoreBean)iter.next();
Ids=Integer.parseInt(sb.getId());
Sums=getSum(Ids,Lastday,Today);
db.executeInsert("insert into Score values('"+Ids+"','"+Sums+"')");
}
}
public int getSum(int Id,String Lastday,String Today) throws NumberFormatException, SQLException{
Sum=sx.getX(Id,Lastday,Today,"CostumeComm");
return Sum;
}
}
解决方案 »
- 江湖救急,关于Software caused connection abort: recv failed问题,一直解决不了,请街坊邻居指教和观光看一下
- 这个arrayList性能问题? 如何优化呢???
- 快去找工作(java)了,现在工作的哥哥姐姐们,请说说你们当时找工作的经验。谢谢!散100分。
- JScrollPane滚动条永远都不滚动的问题
- 如何响应树控件的展开事件!!!
- jar是否可以解压到指定的路径(盘与盘之间),是否可以压缩到指定的路径?
- 怎样得到系统字体?
- java初学者紧急问题
- 救救我!!!!紧急!!!
- 请问,怎么实现文件和目录的上传,用什么方法,最好有实例!谢谢大吓 了!
- 高价 求美容管理软件
- 使用BigDecimal进行浮点数运算 会影响效率么?
import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.List;
public class Scoree{
private int a,b,c;
private jihe.jiheinfo.DBconn db=new DBconn();
public int getX(int UserId,String Lastday,String Today,String table)
throws NumberFormatException, SQLException{
String sql="select count(*) from CostumeComm where(HostManId='"+UserId+"')and(times between '"+Lastday+"'and '"+Today+"')";
ResultSet rs=db.executeQuery(sql);
while(rs.next()){
c=Integer.parseInt(rs.getString(1));
}
return c;
}
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.java提示:
DBconn.executeUpdate:[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]插入
错误: 列名或所提供值的数目与表定义不匹配。
把你执行时生成的sql打印出来,然后放到pl/sql或sql/plus里面,找到问题所在