@Test
public void testResetMetData() throws Exception{
Connection conn=null;
PreparedStatement preparedStatement=null;
ResultSet rs=null;
try {
String sql="select id stu_id,idCard stu_idcard,examCard stu_examcard,score stu_score "
+"from examstudent where id=?";
conn=JDBCTools.getConnection();
preparedStatement=conn.prepareStatement(sql);
preparedStatement.setInt(1,4);
rs=preparedStatement.executeQuery();
Map<String,Object> values=new HashMap<String,Object>();
ResultSetMetaData rsmd=rs.getMetaData();
while(rs.next()){
for(int i=0;i<rsmd.getColumnCount();i++){
String columnLabel=rsmd.getColumnLabel(i+1);
System.out.println(columnLabel);
}
}
//打印列名
//System.out.println(values);
Class clazz=Student.class;
Object object=clazz.newInstance();
for(Map.Entry<String, Object> entry:values.entrySet()){
String fieldName=entry.getKey();
Object fieldValue=entry.getValue();
System.out.println(fieldName+":"+fieldValue);
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
JDBCTools.releaseDB(rs, preparedStatement, conn);
}
}