preparestatementutil.java

一个可以存储和打印成绩单的系统

package org.minjey.cjsjk.dao;

import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Queue;

import org.minjey.cjsjk.util.Reflector;
import org.minjey.cjsjk.util.TypeConverter;

public class PrepareStatementUtil {
	
	private Reflector reflector;
	
	public PrepareStatementUtil() {
		reflector = new Reflector();
	}
	
	public void prepareStatement(Queue<String> cnames, Object obj, PreparedStatement pst) {
		int i = 1;
		while(!cnames.isEmpty()) {
			String cname = cnames.poll();	//列名
			Object vobj = reflector.getValue(obj, cname);	//取值
			if(vobj != null) {
			
				Class[] clas = new Class[2];
				clas[0] = int.class;
				clas[1] = TypeConverter.objecttosimple(vobj.getClass());
				
				//System.out.println(clas[1]);
				
				Object[] objs = new Object[2];
				objs[0] = i;
				objs[1] = vobj;
			
				String tname = reflector.getClassName(clas[1]);	//类型名
				reflector.setValue(pst, tname, objs, clas);
			} else {
				try {
					pst.setObject(i, null);
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			i++;
		}
	}
}