数据库查询并使用别名:
String sql = "select order_id orderId, order_name orderName, order_data orderData from order where id=1";
数据库查询后数据的处理方式:
方式1.
public Customer queryForCustomers(String sql,Object...args) throws Exception{
ResultSet rs = null;
try{
Connection conn = JDBCUtils.getConnection();
PreparedStatement ps = conn.prepareStatement(sql);
for(int i=0;i<args.length;i++){
ps.setObject(i+1, args[i]);
}
ResultSet rs = ps.executeQuery();
//获取结果集的元数据:ResultSetMetaData()
ResultSetMetaData rsmd = rs.getMetaData();
//通过ResultSetMetaData获取结果集中的列数
int columnCount = rsmd.getColumnCount();
if(rs.next()){
Customer cust = new Customer();
//处理结果