我的问题

[qq200577]

package db;

import java.sql.*;
import java.util.*;
import vo.*;

public class DBManager {

private static final String driver = "org.gjt.mm.mysql.Driver";
private static final String url = "jdbc:mysql://localhost:3306/dreamshop";
private static final String cmdsql = "select * from shop_member_info";
private static final String lable = "account,address,age,date_time,email,pwd";
private static DBManager dbManager = null;
private Connection conn = null;

private DBManager() {
try {
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url);
}
catch (Exception ex) {
ex.printStackTrace();
}
}

public static synchronized DBManager getInitialization() {
if (dbManager == null) {
dbManager = new DBManager();
}
return dbManager;
}
public ArrayList getLable(){
ArrayList lableList = new ArrayList();
lableList.add("account");
lableList.add("address");
lableList.add("age");
lableList.add("date_time");
lableList.add("email");
lableList.add("pwd");
return lableList;
}

/**
* 获得表中的数据
* @return
*/
public ArrayList getValueInfo() throws SQLException {
UserVO userVO = null ;
ArrayList valueList = new ArrayList();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(cmdsql);
while(rs.next()){
ArrayList list=new ArrayList();
Iterator it=this.getLable().iterator();
while (it.hasNext()){
String value=rs.getString(it.next().toString());
list.add(value);
}
valueList.add(list);
}
return valueList;
}

public static void main(String[] args) throws SQLException {
DBManager db = DBManager.getInitialization();
ArrayList valueList=db.getValueInfo();
Iterator it=valueList.iterator();
while(it.hasNext()){
ArrayList list=(ArrayList)it.next();
Iterator row=list.iterator();
System.out.println(list.size());
while(row.hasNext()){
System.out.print(" "+row.next());
}
System.out.println();
}
}

}

[qq200577]

try {
response.setContentType(CONTENT_TYPE);
ArrayList lableList = (ArrayList) request.getAttribute("lableList");
ArrayList valueList = (ArrayList) request.getAttribute("valueList");
response.setContentType(CONTENT_TYPE);
InputStream in = this.getClass().getResourceAsStream(
"/template/printaccount.xls");
Workbook wb = Workbook.getWorkbook(in);
WritableWorkbook wwb = Workbook.createWorkbook(response
.getOutputStream(), wb);
WritableSheet ws = wwb.getSheet(0);
Label lable = null;
WritableFont font = new WritableFont(WritableFont.createFont("新宋体"),10,WritableFont.BOLD);

WritableCellFormat wcf = null;
int i = -1;
int j = 0;
Iterator lableit = lableList.iterator();
Iterator valueit = valueList.iterator();
wcf = new WritableCellFormat(font);
wcf.setAlignment(Alignment.CENTRE);
int row1 = 0;
while (lableit.hasNext()) {
i++;
j++;
String lablevalue = (String) lableit.next();
lable = new Label(i, 1, lablevalue, wcf);
ws.addCell(lable);
}
row1 = 1;
int column = -1;
int maxcolumn = 0;
while (valueit.hasNext()) {
row1++;
ArrayList list = (ArrayList) valueit.next();
System.out.println("33333333" + list.size());
Iterator row = list.iterator();
System.out.println(list.size());
while (row.hasNext()) {
column++;
String rowValue = (String) row.next();
lable = new Label(column, row1, rowValue);
ws.addCell(lable);
maxcolumn = column;
}
column = -1;
}
int currentlydate = row1 + 2;
Label labledate = new Label(maxcolumn+1,currentlydate,"当前时间");
ws.addCell(labledate);
jxl.write.DateFormat df = new jxl.write.DateFormat("dd MM yyyy hh:mm:ss");
jxl.write.WritableCellFormat wcfDF = new jxl.write.WritableCellFormat(df);
jxl.write.DateTime labelDTF = new jxl.write.DateTime(maxcolumn+2, currentlydate, new java.util.Date(), wcfDF);
ws.addCell(labelDTF);
wwb.write();
wwb.close();
}
catch (Exception e) {
e.printStackTrace();
}

[asd_]

你是不是该告诉大家你出了什么问题了？？？