原生链接数据库方法

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;
	}