我建议不要采用arraylist作为参数对象,这样做的话可能会在序列化上有问题,最好采用业务逻辑Bean的对象数组,这个是肯定不会有问题的.
解决方案 »
- byte[]转换成String
- jsp页面onload事件问题
- 用form.get****()取出的中文出现乱码,求高手解决
- Web Service, 序列化错误
- Jbuilder中EJB的打包问题
- 关于J2EE运行的问题,急!!!
- 关于FlippingBook逼真flash翻页效果问题,如何自动翻页,急求!!!!!
- 这怎么回事???
- 静态存根方式的客户端编码怎么写?请高手指教小妹!谢谢!
- 线程池executors.newSingleThread 使用出现如下错误代码
- hibernate 插入多条记录问题 报错Could not execute JDBC batch update 困惑我2天了!
- 關于AJAX,希望大家幫忙
/**
* 查询所有AA008表中的数据,返回值以AA008 的java bean数组
* @return AA008 的java bean数组
* @throws java.io.IOException
* @throws SQLException
*/
public Aa008[] doPost() throws java.io.IOException,SQLException{
Aa008[] monthDown=null;
long startTime = System.currentTimeMillis();
ResultSet rs,rs1 = null;
String selectSqlStr = "";
// SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); System.out.println("请开始!");
SqlBean aae010Bean = new SqlBean();
String countSqlStr ="SELECT count(*) FROM AA008";
System.out.println(countSqlStr);
rs1 = aae010Bean.executeQuery(countSqlStr);
int s =0;
if (rs1.next()) {
s = rs1.getInt(1);
}
System.out.println("取得的总记录数量:"+s);
int i = s;
try { selectSqlStr = "SELECT * FROM AA008";
rs = aae010Bean.executeQuery(selectSqlStr);
System.out.println("Start Insert JDYB");
monthDown=new Aa008[i];
int a=0;
while (rs.next() && (a<i)) {
Aa008 urs = new Aa008();
urs.setAab001(rs.getString("Aab001"));
urs.setAai002(rs.getString("Aai002"));
urs.setAai003(rs.getString("Aai003"));
urs.setAai004(rs.getString("Aai004"));
urs.setAai005(rs.getString("Aai005"));
urs.setAai006(rs.getLong("Aai006"));
urs.setAai007(rs.getLong("Aai007"));
urs.setAai008(rs.getLong("Aai008"));
urs.setAai009(rs.getLong("Aai009"));
urs.setAai010(rs.getLong("Aai010"));
urs.setAai011(rs.getLong("Aai011"));
urs.setAai012(rs.getLong("Aai012"));
urs.setAai013(rs.getLong("Aai013"));
urs.setAai014(rs.getLong("Aai014"));
urs.setAai015(rs.getLong("Aai015"));
urs.setAai016(rs.getLong("Aai016"));
urs.setAai017(rs.getLong("Aai017"));
urs.setAai019(rs.getLong("Aai019"));
urs.setAai020(rs.getLong("Aai020"));
urs.setAai021(rs.getLong("Aai021"));
urs.setAai022(rs.getLong("Aai022"));
urs.setAai023(rs.getLong("Aai023"));
urs.setAai024(rs.getLong("Aai024"));
urs.setAai025(rs.getLong("Aai025"));
urs.setAai026(rs.getLong("Aai026"));
urs.setAai027(rs.getString("Aai027"));
urs.setAai028(rs.getLong("Aai028"));
urs.setAai029(rs.getLong("Aai029"));
urs.setAai030(rs.getLong("Aai030")); monthDown[a] = (Aa008) urs;
System.out.println("第"+(a+1)+"条记录");
System.out.println("第一字段值:"+monthDown[a].getAab001());
System.out.println("第getAai002字段值:"+monthDown[a].getAai002());
System.out.println("第getAai003字段值:"+monthDown[a].getAai003());
System.out.println("第getAai004字段值:"+monthDown[a].getAai004());
System.out.println("第getAai005字段值:"+monthDown[a].getAai005());
System.out.println("第getAai006字段值:"+monthDown[a].getAai006());
System.out.println("第getAai007字段值:"+monthDown[a].getAai007());
System.out.println("第getAai008字段值:"+monthDown[a].getAai008());
System.out.println("第getAai009字段值:"+monthDown[a].getAai009());
System.out.println("第getAai010字段值:"+monthDown[a].getAai010());
System.out.println("第getAai011字段值:"+monthDown[a].getAai011());
System.out.println("第getAai012字段值:"+monthDown[a].getAai012());
System.out.println("第getAai013字段值:"+monthDown[a].getAai013());
System.out.println("第getAai014字段值:"+monthDown[a].getAai014());
System.out.println("第getAai015字段值:"+monthDown[a].getAai015());
System.out.println("第getAai016字段值:"+monthDown[a].getAai016());
System.out.println("第getAai017字段值:"+monthDown[a].getAai017());
System.out.println("第getAai018字段值:"+monthDown[a].getAai018());
System.out.println("第getAai019字段值:"+monthDown[a].getAai019());
System.out.println("第getAai020字段值:"+monthDown[a].getAai020());
System.out.println("第getAai021字段值:"+monthDown[a].getAai021());
System.out.println("第getAai022字段值:"+monthDown[a].getAai022());
System.out.println("第getAai023字段值:"+monthDown[a].getAai023());
System.out.println("第getAai024字段值:"+monthDown[a].getAai024());
System.out.println("第getAai025字段值:"+monthDown[a].getAai025());
System.out.println("第getAai026字段值:"+monthDown[a].getAai026());
System.out.println("第getAai027字段值:"+monthDown[a].getAai027());
System.out.println("第getAai028字段值:"+monthDown[a].getAai028());
System.out.println("第getAai029字段值:"+monthDown[a].getAai029());
System.out.println("第getAai030字段值:"+monthDown[a].getAai030());
a++;
} } catch (Exception e) {
System.out.println(e.getMessage());
e.printStackTrace();
} finally {
aae010Bean.closeConnection();
aae010Bean.closeConnection();
System.out.println("最后完事了:");
}
long endTime = System.currentTimeMillis();
System.out.println("执行需要时间:"+(endTime - startTime) + "ms");
return monthDown;
}
* 该java类对应数据库表aa008的java类,用于返回表AA008中数据
* @author Administrator
*
*/
public class Aa008 {
private String Aab001;
private String Aai002; //日期类型
private String Aai003; //日期类型
private String Aai004;
private String Aai005;
private long Aai006;
private long Aai007;
private long Aai008;
private long Aai009;
private long Aai010;
private long Aai011;
private long Aai012;
private long Aai013;
private long Aai014;
private long Aai015;
private long Aai016;
private long Aai017;
private long Aai018;
private long Aai019;
private long Aai020;
private long Aai021;
private long Aai022;
private long Aai023;
private long Aai024;
private long Aai025;
private long Aai026;
private String Aai027; //日期类型
private long Aai028;
private long Aai029;
private long Aai030; public String getAab001() {
return Aab001;
}
public void setAab001(String aab001) {
Aab001 = aab001;
}
public String getAai002() {
return Aai002;
}
public void setAai002(String aai002) {
Aai002 = aai002;
}
public String getAai003() {
return Aai003;
}
public void setAai003(String aai003) {
Aai003 = aai003;
}
public String getAai004() {
return Aai004;
}
public void setAai004(String aai004) {
Aai004 = aai004;
}
public String getAai005() {
return Aai005;
}
public void setAai005(String aai005) {
Aai005 = aai005;
}
public long getAai006() {
return Aai006;
}
public void setAai006(long aai006) {
Aai006 = aai006;
}
public long getAai007() {
return Aai007;
}
public void setAai007(long aai007) {
Aai007 = aai007;
}
public long getAai008() {
return Aai008;
}
public void setAai008(long aai008) {
Aai008 = aai008;
}
public long getAai009() {
return Aai009;
}
public void setAai009(long aai009) {
Aai009 = aai009;
}
public long getAai010() {
return Aai010;
}
public void setAai010(long aai010) {
Aai010 = aai010;
}
public long getAai011() {
return Aai011;
}
public void setAai011(long aai011) {
Aai011 = aai011;
}
public long getAai012() {
return Aai012;
}
public void setAai012(long aai012) {
Aai012 = aai012;
}
public long getAai013() {
return Aai013;
}
public void setAai013(long aai013) {
Aai013 = aai013;
}
public long getAai014() {
return Aai014;
}
public void setAai014(long aai014) {
Aai014 = aai014;
}
public long getAai015() {
return Aai015;
}
public void setAai015(long aai015) {
Aai015 = aai015;
}
public long getAai016() {
return Aai016;
}
public void setAai016(long aai016) {
Aai016 = aai016;
}
public long getAai017() {
return Aai017;
}
public void setAai017(long aai017) {
Aai017 = aai017;
}
public long getAai018() {
return Aai018;
}
public void setAai018(long aai018) {
Aai018 = aai018;
}
public long getAai019() {
return Aai019;
}
public void setAai019(long aai019) {
Aai019 = aai019;
}
public long getAai020() {
return Aai020;
}
public void setAai020(long aai020) {
Aai020 = aai020;
}
public long getAai021() {
return Aai021;
}
public void setAai021(long aai021) {
Aai021 = aai021;
}
public long getAai022() {
return Aai022;
}
public void setAai022(long aai022) {
Aai022 = aai022;
}
public long getAai023() {
return Aai023;
}
public void setAai023(long aai023) {
Aai023 = aai023;
}
public long getAai024() {
return Aai024;
}
public void setAai024(long aai024) {
Aai024 = aai024;
}
public long getAai025() {
return Aai025;
}
public void setAai025(long aai025) {
Aai025 = aai025;
}
public long getAai026() {
return Aai026;
}
public void setAai026(long aai026) {
Aai026 = aai026;
}
public String getAai027() {
return Aai027;
}
public void setAai027(String aai027) {
Aai027 = aai027;
}
public long getAai028() {
return Aai028;
}
public void setAai028(long aai028) {
Aai028 = aai028;
}
public long getAai029() {
return Aai029;
}
public void setAai029(long aai029) {
Aai029 = aai029;
}
public long getAai030() {
return Aai030;
}
public void setAai030(long aai030) {
Aai030 = aai030;
}
}
创建一个和服务端一样的AA008 的java bean调用Web服务发布的doPost() 方法(发布服务会吧?),得到AA008 的java bean数组,数组里的每一条记录就是数据里的相应记录。