Statement stmt = null;
ResultSet rs = null;
ArrayList model = null;
try{
stmt = conn.createStatement();
String kbnStr = String.valueOf(kbn);
String hjncdStr = String.valueOf(hjncd);
String sql = "SELECT MEICDC,MEICDN,MEINM1,MEINM2,MEINM3,MEINM4,MEINM5 FROM M_MEI WHERE MEIKBN=" + kbnStr + " AND HJNCD=" + hjncdStr;
System.out.println("sql:"+sql);
rs = stmt.executeQuery(sql);
model = new ArrayList();
while(rs.next()){
String meicdc = rs.getString("MEICDC");
int meicdn = rs.getInt("MEICDN");
String meinm1 = rs.getString("MEINM1");
String meinm2 = rs.getString("MEINM2");
String meinm3 = rs.getString("MEINM3");
String meinm4 = rs.getString("MEINM4");
String meinm5 = rs.getString("MEINM5");
ArrayList item=new ArrayList();
item.add(mei1);
item.add(mei2);
item.add(mei3);
model.add(item);
}
} catch (SQLException sqle) {
sqle.printStackTrace();
throw new DAOException(sqle);
} catch (Exception e) {
throw e;
} finally {
if (rs != null){
rs.close();
}
if(stmt != null){
stmt.close();
}
}
ResultSet rs = null;
ArrayList model = null;
try{
stmt = conn.createStatement();
String kbnStr = String.valueOf(kbn);
String hjncdStr = String.valueOf(hjncd);
String sql = "SELECT MEICDC,MEICDN,MEINM1,MEINM2,MEINM3,MEINM4,MEINM5 FROM M_MEI WHERE MEIKBN=" + kbnStr + " AND HJNCD=" + hjncdStr;
System.out.println("sql:"+sql);
rs = stmt.executeQuery(sql);
model = new ArrayList();
while(rs.next()){
String meicdc = rs.getString("MEICDC");
int meicdn = rs.getInt("MEICDN");
String meinm1 = rs.getString("MEINM1");
String meinm2 = rs.getString("MEINM2");
String meinm3 = rs.getString("MEINM3");
String meinm4 = rs.getString("MEINM4");
String meinm5 = rs.getString("MEINM5");
ArrayList item=new ArrayList();
item.add(mei1);
item.add(mei2);
item.add(mei3);
model.add(item);
}
} catch (SQLException sqle) {
sqle.printStackTrace();
throw new DAOException(sqle);
} catch (Exception e) {
throw e;
} finally {
if (rs != null){
rs.close();
}
if(stmt != null){
stmt.close();
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货