最近面试的时候,老程序员也让你写个JDBC,很是无奈。
public Connection getcon(){
Connection con=null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
System.out.println("驱动加载....");
con=DriverManager.getConnection("jdbc:oracle:thin:@192.168.20.167:1521:pera","cflow","cflow");
System.out.println("连接成功....");
} catch (Exception e) {
e.printStackTrace();
}
return con;
}
public void closeCon(ResultSet rs,PreparedStatement ps,Connection con){
try {
if(rs!=null)rs.close();
if(ps!=null)ps.close();
if(con!=null)con.close();
System.out.println("关闭数据成功....");
} catch (Exception e) {
e.printStackTrace();
}
}
public List getList(){
Connection con=null;
PreparedStatement ps=null;
ResultSet rs=null;
List list=new ArrayList();
try {
con=getcon();
System.out.println("开始读取数据....");
ps=con.prepareStatement("select node_id,node_name from pera_flow_task");
rs=ps.executeQuery();
while (rs.next()) {
System.out.println(rs.getString("node_name"));
}
} catch (Exception e) {
e.printStackTrace();
}finally{
closeCon(rs, ps, con);
}
return list;
}
public static void main(String[] args) throws Exception {
new Test().getList();
}