JDBC_利用Java反射技术将查询结果封装为对象

将学习成果分享给大家。

import java.lang.reflect.Method;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;

import com.itcast.jdbc.domain.User;

//JDBC_利用Java反射技术将查询结果封装为对象
public class CRMTest
{

 public static void main(String[] args) throws Exception
 {

  //另外一种解决方法名为题为
  //sql = "select id as Id,name as Name,birthday as Birthday,money as Money from user where id = 3"
  String sql = "select * from user where id = 3";
  //类必须有空的构造函数
  User user = (User) getObject(sql,User.class);
  System.out.println(user);
 }

 public static Object getObject(String sql, Class clazz) throws Exception
 {
  {
   Connection conn = null;
   ResultSet rs = null;
   PreparedStatement ps = null;

   try