JDBC的数据库连接

最近面试的时候，老程序员也让你写个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();
	}