使用PreparedStatement实现针对不同的表的通用的查询操作，返回一条查询结果

代码中Customer类的构造查看：针对单个表进行通用的查询操作_qq_46053741的博客-CSDN博客

代码中Order类的构造查看：当表的字段名与类的属性名不相同时，怎么查询表的记录_qq_46053741的博客-CSDN博客

代码中jdbcConnection类的构造查看：封装数据库的连接关闭操作_qq_46053741的博客-CSDN博客

下面是使用PreparedStatement实现针对不同的表的通用的查询操作：

package com3preparedstatementQuery;

import java.lang.reflect.Field;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;

import org.junit.Test;

import com3preparedstatement.bean.Customer;
import com3preparedstatement.bean.Order;
import com3preparedstatement.jdbc.jdbcConnection;


public class PreparedStatementQueryTest {
	@Test
	public void testGetInstance(){
		String sql=null;
		sql="select order_id id,order_name name,order_date date from reorder where order_id=?";
		Order order=GetInstance(Order.class,sql,2);
		System.out.println(order.toString());
		sql="select id,name,email,birth from Customers where id=?";
		Customer customer=GetInstance(Customer.class,sql,8);
		System.out.println(customer.toString());
	}
	
	public <T>T GetInstance(Class<T> clazz,String sql, Object ...args){
		//1、获取连接
		Connection conn=null;
		//2、实例化PreparedStatement对象，
		PreparedStatement ps=null;
		//4、执行查询操作，返回结果集
		ResultSet rs=null;
		try {
			conn = jdbcConnection.connection();
			ps = conn.prepareStatement(sql);
			//3、填充占位符
			for(int i=0;i<args.length;i++){
				ps.setObject(i+1, args[i]);
			}
			rs = ps.executeQuery();
			//5、获取结果集中的元数据
			ResultSetMetaData rsmd=rs.getMetaData();
			//6、获取表的列数
			int columnCount=rsmd.getColumnCount();
			if(rs.next()){
				T t=clazz.newInstance();
				for(int i=0;i<columnCount;i++){
					//7、获取当前记录列的值
					Object value=rs.getObject(i+1);
					//8、获取当前记录列的字段名
					String columnName=rsmd.getColumnLabel(i+1);
					//9、反射
					Field field=clazz.getDeclaredField(columnName);
					field.setAccessible(true);
					field.set(t, value);
				}
				return t;
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		//10、关闭资源
		jdbcConnection.CloseResource(conn, ps, rs);
		return null;
	}
}