Collection col = new ArrayList(); Model model = null; //与数据库对应的model ResultSet rs = .... while(rs.next()){ model.setXXX(rs.getString("XXX")); col.add(model); }
Collection col = new ArrayList(); Model model = null; //与数据库对应的model ResultSet rs = .... while(rs.next()){ model=new Model();///这个可不能少哦,呵呵,不然就不是每次生成新的对象了 model.setXXX(rs.getString("XXX")); col.add(model); }
自定义一个类啊。 把数据先放到类对象中,再add到ArrayList中。
定义一个class A,里面的变量对应DB中的一些字段 Class A{ String strID=""; String strName=""; }然后 ArrayList al=new ArrayList(); A a = new A(); while(rs.next()){ a.strID=(rs.getString("XXX")); a.strName=(rs.getString("XXX")); al.add(a); }
import java.sql.*; import java.util.*; public class oracle{ public Connection conn = null; public Statement stmt = null; public ResultSet rs = null; public void startora(){ try{ Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); String url="jdbc:oracle:thin:@192.168.2.3:1521:ecydeen"; conn = DriverManager.getConnection(url,"pan_open","pan_open"); }catch(Exception e){ System.out.println("connect oracle faile"); } } public void shutora(){ try{ if(rs != null)rs.close(); if(stmt != null)stmt.close(); if(conn != null)conn.close(); }catch(Exception e1){ e1.printStackTrace(); } } public static void main(String args[]){ oracle ora = new oracle(); ora.startora(); Statement stmta;try{ stmta = ora.conn.createStatement(); ora.rs = stmta.executeQuery("select * from TBL_CODE_TABLE"); HashMap hp = null; ArrayList TBL_CODE_NAME = new ArrayList(); ResultSetMetaData rsData = ora.rs.getMetaData(); int number = rsData.getColumnCount(); String type[] = new String[number+1]; for(int i=1;i<=number;i++){ type[i] = rsData.getColumnLabel(i); } System.out.println(rsData.getColumnLabel(1)+" "+rsData.getColumnTypeName(1)); ora.rs.next();while(ora.rs.next()){ hp = new HashMap(); for(int i=1;i<=number;i++){ hp.put(type[i],ora.rs.getObject(i)); }TBL_CODE_NAME.add(hp); }System.out.println(TBL_CODE_NAME); }catch(Exception e){ System.out.println(e.toString()); }finally{ System.out.println(" end "); } ora.shutora(); } }
Model model = null; //与数据库对应的model
ResultSet rs = ....
while(rs.next()){
model.setXXX(rs.getString("XXX"));
col.add(model);
}
Model model = null; //与数据库对应的model
ResultSet rs = ....
while(rs.next()){
model=new Model();///这个可不能少哦,呵呵,不然就不是每次生成新的对象了
model.setXXX(rs.getString("XXX"));
col.add(model);
}
把数据先放到类对象中,再add到ArrayList中。
Class A{
String strID="";
String strName="";
}然后
ArrayList al=new ArrayList();
A a = new A();
while(rs.next()){
a.strID=(rs.getString("XXX"));
a.strName=(rs.getString("XXX"));
al.add(a);
}
import java.util.*;
public class oracle{
public Connection conn = null;
public Statement stmt = null;
public ResultSet rs = null;
public void startora(){
try{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@192.168.2.3:1521:ecydeen";
conn = DriverManager.getConnection(url,"pan_open","pan_open");
}catch(Exception e){
System.out.println("connect oracle faile");
}
}
public void shutora(){
try{
if(rs != null)rs.close();
if(stmt != null)stmt.close();
if(conn != null)conn.close();
}catch(Exception e1){
e1.printStackTrace();
}
}
public static void main(String args[]){
oracle ora = new oracle();
ora.startora();
Statement stmta;try{
stmta = ora.conn.createStatement();
ora.rs = stmta.executeQuery("select * from TBL_CODE_TABLE");
HashMap hp = null;
ArrayList TBL_CODE_NAME = new ArrayList();
ResultSetMetaData rsData = ora.rs.getMetaData();
int number = rsData.getColumnCount();
String type[] = new String[number+1];
for(int i=1;i<=number;i++){
type[i] = rsData.getColumnLabel(i);
}
System.out.println(rsData.getColumnLabel(1)+" "+rsData.getColumnTypeName(1));
ora.rs.next();while(ora.rs.next()){
hp = new HashMap();
for(int i=1;i<=number;i++){
hp.put(type[i],ora.rs.getObject(i));
}TBL_CODE_NAME.add(hp);
}System.out.println(TBL_CODE_NAME);
}catch(Exception e){
System.out.println(e.toString());
}finally{
System.out.println(" end ");
}
ora.shutora();
}
}