很奇怪的问题 resultSet.getLong(1);数据库字段类型为int在windows下正常在linux下报错.高手给解释下吧 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 #include <string.h>int main(){ printf("Size of int is %d\n",sizeof(int)); printf("Size of long is %d\n",sizeof(long)); return 0;}请分别到不同系统下运行! String sql = "select * from achievementappraiseitem where userid=? and year=? order by type"; List list = new ArrayList(); Connection conn = null; PreparedStatement pstmt = null; ResultSet rs = null; try { conn = DBManager.getConnection(); pstmt = conn.prepareStatement(sql); pstmt.setInt(1, userid); pstmt.setInt(2, year); rs = pstmt.executeQuery(); System.out.println(sql); System.out.println(userid); System.out.println(year); while (rs.next()) { System.out.println("test"); AchievementAppraiseItem item = new AchievementAppraiseItem(); System.out.println("test1"); item.setId(rs.getLong(1)); System.out.println("test2"); item.setName(rs.getString(2)); System.out.println("test3"); item.setTaskQuantity(rs.getInt(3)); System.out.println("test4"); item.setWeight(rs.getInt(4)); System.out.println("test5"); item.setLowerLimit(rs.getDouble("lowerlimit")); System.out.println("test6"); item.setUpperLimit(rs.getDouble("upperlimit")); System.out.println("test7"); item.setRe(rs.getString(7)); System.out.println("test8"); item.setJan(rs.getDouble("jan")); System.out.println("test10"); item.setFeb(rs.getDouble("feb")); System.out.println("test11"); item.setMar(rs.getDouble("mar")); System.out.println("test12"); item.setApr(rs.getDouble("apr")); System.out.println("test13"); item.setMay(rs.getDouble("may")); System.out.println("test14"); item.setJune(rs.getDouble("june")); System.out.println("test15"); item.setJuly(rs.getDouble("july")); System.out.println("test16"); item.setAug(rs.getDouble("aug")); System.out.println("test17"); item.setSept(rs.getDouble("sept")); System.out.println("test18"); item.setOct(rs.getDouble("oct")); System.out.println("test19"); item.setNov(rs.getDouble("nov")); System.out.println("test20"); item.setDec(rs.getDouble("december")); System.out.println("test21"); item.setType(rs.getInt("type")); System.out.println("test22"); item.setFinishedtasks(rs.getString("finishedtasks")); System.out.println("test23"); item.setYear(rs.getInt("year")); System.out.println("test24"); item.setLimitconfig(rs.getString("limitconfig")); System.out.println("test25"); list.add(item); System.out.println("test26"); } System.out.println("ok"); } catch (Exception e) { LogUtil.logErr(e); e.printStackTrace(); } finally { DBManager.closeAll(conn, pstmt, rs); } return list;这是全部代码,就是看不出哪的错 System.out.println(sql); System.out.println(userid); System.out.println(year);这三个正常打印,test也打印除了,往后就没打印了 c++ 中有有点数据类型是按字长定义的,所以不同机器的字长不同,数据类型的字节数会变但是java的字段没有按字长定义的 楼主怎么用System.out.println("");进行调试啊建议调试模式运行,这样错误更好查啊 如果不配置actionform不知道怎么得到 text里面的内容??? 在线等myeclipse问题 JSP 音乐播放器。问题! 部署到服务器上的tomcat后出现的错误 求jfreechart0.9.20和它的开发文档 非常简单的问题。JSP使用bean的问题!!! tomcat + sqlserver2000 遇到问题 请高手指点 求助登陆页面的问题 关于java 与DLL 进行通讯问题(高分赠送) 请教一个SERVLET的问题 jsp 页面数据 导出文本文件 一个小问题
int main()
{
printf("Size of int is %d\n",sizeof(int));
printf("Size of long is %d\n",sizeof(long));
return 0;
}请分别到不同系统下运行!
String sql = "select * from achievementappraiseitem where userid=? and year=? order by type";
List list = new ArrayList();
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
conn = DBManager.getConnection();
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, userid);
pstmt.setInt(2, year);
rs = pstmt.executeQuery();
System.out.println(sql);
System.out.println(userid);
System.out.println(year);
while (rs.next()) {
System.out.println("test");
AchievementAppraiseItem item = new AchievementAppraiseItem();
System.out.println("test1");
item.setId(rs.getLong(1));
System.out.println("test2");
item.setName(rs.getString(2));
System.out.println("test3");
item.setTaskQuantity(rs.getInt(3));
System.out.println("test4");
item.setWeight(rs.getInt(4));
System.out.println("test5");
item.setLowerLimit(rs.getDouble("lowerlimit"));
System.out.println("test6");
item.setUpperLimit(rs.getDouble("upperlimit"));
System.out.println("test7");
item.setRe(rs.getString(7));
System.out.println("test8");
item.setJan(rs.getDouble("jan"));
System.out.println("test10");
item.setFeb(rs.getDouble("feb"));
System.out.println("test11");
item.setMar(rs.getDouble("mar"));
System.out.println("test12");
item.setApr(rs.getDouble("apr"));
System.out.println("test13");
item.setMay(rs.getDouble("may"));
System.out.println("test14");
item.setJune(rs.getDouble("june"));
System.out.println("test15");
item.setJuly(rs.getDouble("july"));
System.out.println("test16");
item.setAug(rs.getDouble("aug"));
System.out.println("test17");
item.setSept(rs.getDouble("sept"));
System.out.println("test18");
item.setOct(rs.getDouble("oct"));
System.out.println("test19");
item.setNov(rs.getDouble("nov"));
System.out.println("test20");
item.setDec(rs.getDouble("december"));
System.out.println("test21");
item.setType(rs.getInt("type"));
System.out.println("test22");
item.setFinishedtasks(rs.getString("finishedtasks"));
System.out.println("test23");
item.setYear(rs.getInt("year"));
System.out.println("test24");
item.setLimitconfig(rs.getString("limitconfig"));
System.out.println("test25");
list.add(item);
System.out.println("test26");
}
System.out.println("ok");
} catch (Exception e) {
LogUtil.logErr(e);
e.printStackTrace();
} finally {
DBManager.closeAll(conn, pstmt, rs);
}
return list;
这是全部代码,就是看不出哪的错
System.out.println(sql);
System.out.println(userid);
System.out.println(year);
这三个正常打印,test也打印除了,往后就没打印了
但是java的字段没有按字长定义的
建议调试模式运行,这样错误更好查啊