public List GetConnection(){
// 连接数据库
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
try {
Class.forName("oracle.jdbc.OracleDriver");
conn= DriverManager.getConnection("jdbc:oracle:thin:@172.22.1.62:1221/user", "username", "passworde");
// 创建窗口对象
stmt= conn.createStatement();
String sql="select * from table1";
//执行sql
rs= stmt.executeQuery(sql);
List list =new ArrayList();
while(rs.next()){
//将对象加入到集合中(如果数据为int则getInt()获取)
list.add(rs.getString(1));
}
return list;
} catch (Exception e) {
e.printStackTrace();
}finally{
// 先打开的后关闭,
try{
if(rs!=null){rs.close();}
if(stmt!=null){stmt.close();}
if(conn!=null){conn.close();}
}catch (Exception e) {
e.printStackTrace();
}
}
return null;
}