java JDBC-ORM原理-使用list加object数组封装mysql数据

**客户端**
public class Demo12 {
	public static void main(String[] args) {
		Connection conn=jdbcutil.getMysqlConn();
		PreparedStatement ps=null;
		ResultSet rs=null;
		List<Object[]> list=new ArrayList<Object[]>();
		
		try {
			ps = conn.prepareStatement("select empname,salary,age from emp where id=?");
			ps.setInt(1, 1);
			rs=ps.executeQuery();

			while(rs.next())
			{
				Object[] objs=new Object[3]; //将一条数据放入数组里
			//	System.out.println(rs.getString(1)+"--"+rs.getDouble(2)+"--"+rs.getInt(3));
				objs[0]=rs.getString(1);
				objs[1]=rs.getObject(2);
				objs[2]=rs.getObject(3);
				
				list.add(objs);
			}
			
			
		} catch (SQLException e) {
			e.printStackTrace();
		}finally
		{
			jdbcutil.close(rs, ps, conn);
		}  
		
		for(Object[] obj:list)
		{
			System.out.println(""+obj[0]+obj[1]+obj[2]);
		}
	}
	
**工具类**
public class jdbcutil {
static Properties pros = null;   //可以帮助读取和处理资源文件中的信息
	
	static {   //加载JDBCUtil类的时候调用
		pros = new Properties();
		try {
			pros.load(Thread.currentThread().getContextClassLoader().getResourceAsStream("db.properties"));
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
	
	
	public static Connection getMysqlConn(){
		try {
			Class.forName(pros.getProperty("mysqlDriver"));
			return DriverManager.getConnection(pros.getProperty("mysqlURL"),
					pros.getProperty("mysqlUser"),pros.getProperty("mysqlPwd"));
		} catch (Exception e) {
			e.printStackTrace();
			return null;
		}
	}
	
	
	public static void close(ResultSet rs,Statement ps,Connection conn){
		try {
			if(rs!=null){
				rs.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		try {
			if(ps!=null){
				ps.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		try {
			if(conn!=null){
				conn.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	public static void close(Statement ps,Connection conn){
		try {
			if(ps!=null){
				ps.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		try {
			if(conn!=null){
				conn.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	public static void close(Connection conn){
		try {
			if(conn!=null){
				conn.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}

}