if (c!=null){
x=c.size();
a = new String[x][4];
d=new int[x];
f=new int[x];
try { //取得库连接
conn = DBAccess.getConnection();
if (conn == null)
throw new VnetException(VnetException.DATABASE_ERROR, "数据库链接为空。");
for (int i = 0; i < c.size(); i++) {
String code = c.get(i).toString(); System.out.println(code);
// x=c.size();
a = new String[x][4];
a[i][0]=code;
//d=new int[x];
System.out.print(a[i][0]);
String sql1 = "select sum(card_num) from card_batch where card_code='" +
code + "'and status='01'";
PreparedStatement pstmt = conn.prepareStatement(sql1);
ResultSet res1 = pstmt.executeQuery();
if (res1.next())
{a[i][1] =String.valueOf(res1.getInt("sum(card_num)"));
System.out.println("haha------you are boy");
System.out.println(a[i][1]);
d[i]=res1.getInt("sum(card_num)"); }
res1.close();
pstmt.close();
// }
// catch (Exception e) {
// e.printStackTrace();
//return null;}
//finally {
//if (conn!=null)
// DBAccess.rollback(conn); // }
//try { //取得库连接
// conn = DBAccess.getConnection();
if (conn == null)
throw new VnetException(VnetException.DATABASE_ERROR, "数据库链接为空。");
// for (int i = 0; i < c.size(); i++) {
// String code = c.get(i).toString();
//x=c.size();
String sql2 = "select count(*) from card_detail t where card_id like '" +
code + "%' and t.activate_date is not null";
//PreparedStatement pstmt = conn.prepareStatement(sql2);
pstmt = conn.prepareStatement(sql2);
//ResultSet res1 = pstmt.executeQuery();
res1 = pstmt.executeQuery();
//f=new int[x];
if (res1.next())
{a[i][2] = String.valueOf(res1.getInt("count(*)"));
System.out.println("haha------you are gay");
System.out.println(a[i][0]);
System.out.println(a[i][1]);
System.out.println(a[i][2]);
f[i]=res1.getInt("count(*)");}
res1.close();
pstmt.close();}
}
catch(Exception e) {
e.printStackTrace();}
finally { //if (conn!=null)
// DBAccess.rollback(conn);
} // for (int i = 0; i < c.size(); i++)
// {
// a[i][3]=String.valueOf(d[i]-f[i]);}
// for (int i=0;i<c.size();i++)
// {for (int j=0;j<4;j++)
// {System.out.println(a[i][j]);}}
System.out.println(a[1][0]);
return a;
}
else return null;
}
x=c.size();
a = new String[x][4];
d=new int[x];
f=new int[x];
try { //取得库连接
conn = DBAccess.getConnection();
if (conn == null)
throw new VnetException(VnetException.DATABASE_ERROR, "数据库链接为空。");
for (int i = 0; i < c.size(); i++) {
String code = c.get(i).toString(); System.out.println(code);
// x=c.size();
a = new String[x][4];
a[i][0]=code;
//d=new int[x];
System.out.print(a[i][0]);
String sql1 = "select sum(card_num) from card_batch where card_code='" +
code + "'and status='01'";
PreparedStatement pstmt = conn.prepareStatement(sql1);
ResultSet res1 = pstmt.executeQuery();
if (res1.next())
{a[i][1] =String.valueOf(res1.getInt("sum(card_num)"));
System.out.println("haha------you are boy");
System.out.println(a[i][1]);
d[i]=res1.getInt("sum(card_num)"); }
res1.close();
pstmt.close();
// }
// catch (Exception e) {
// e.printStackTrace();
//return null;}
//finally {
//if (conn!=null)
// DBAccess.rollback(conn); // }
//try { //取得库连接
// conn = DBAccess.getConnection();
if (conn == null)
throw new VnetException(VnetException.DATABASE_ERROR, "数据库链接为空。");
// for (int i = 0; i < c.size(); i++) {
// String code = c.get(i).toString();
//x=c.size();
String sql2 = "select count(*) from card_detail t where card_id like '" +
code + "%' and t.activate_date is not null";
//PreparedStatement pstmt = conn.prepareStatement(sql2);
pstmt = conn.prepareStatement(sql2);
//ResultSet res1 = pstmt.executeQuery();
res1 = pstmt.executeQuery();
//f=new int[x];
if (res1.next())
{a[i][2] = String.valueOf(res1.getInt("count(*)"));
System.out.println("haha------you are gay");
System.out.println(a[i][0]);
System.out.println(a[i][1]);
System.out.println(a[i][2]);
f[i]=res1.getInt("count(*)");}
res1.close();
pstmt.close();}
}
catch(Exception e) {
e.printStackTrace();}
finally { //if (conn!=null)
// DBAccess.rollback(conn);
} // for (int i = 0; i < c.size(); i++)
// {
// a[i][3]=String.valueOf(d[i]-f[i]);}
// for (int i=0;i<c.size();i++)
// {for (int j=0;j<4;j++)
// {System.out.println(a[i][j]);}}
System.out.println(a[1][0]);
return a;
}
else return null;
}
解决方案 »
- struts1遇到的问题。。。。,DispatchAction 的
- 关于无法访问tomcat问题
- 最近想学学java 高手们进来指点一下吧
- .net的DATATABLE好象挺好的,JAVA中有吗?既然 他可以做那么多事情,为什么他不是持久层和hibernate差别在哪里?
- 请问各位大虾:在spring+hibernate中处理提交数据部分如何进行!不知如何用Hibernate作数据处于部分,郁闷 !!!
- 请教各位高人,BDP是什么的简写?
- 结识EJB方面的专业人士,散分。
- easystruts在eclipse中建立工程,总是报错!
- EJB菜鸟问题,请各位高手过来看看!!!在线等待中
- 谁有wrox网站上的<jsp站点设计变成指南>此书中的源代码?或有struts开发的系统源码?
- eclipse+lomboz +tomcat 每次修类重新编译后都要发布一次,并且要删除tomcat下的已发布的目录,才可更新!发布一次要几分种!
- 请问深圳好的人才网站有那些
为什么不用arraylist???