tablemajorconcert.java

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

package org.wuhang.transfer;
import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Vector;
public class TableMajorConcert {
	static HashMap<Integer,Integer> id_num = new HashMap<Integer,Integer>();
	public HashMap<Integer,Integer> getID_Num(){
		return id_num;
	}
	public void daoMajor(Connection import_con,Connection export_con,
			HashMap<Integer,Integer> station_id_num,HashMap<Integer,Integer> enrolltime_id_num,
			HashMap<Integer,Integer> majorrecord_id_num,HashMap<Integer,Integer> majortype_id_num,
			HashMap<Integer,Integer> majorlength_id_num) {
		try {
    		PreparedStatement import_st = null;
			PreparedStatement export_st = null;
			Vector<String> name = new Vector<String>();
			Vector<String> code = new Vector<String>();
			Vector<Date> intime = new Vector<Date>();
			Vector<Date> outtime = new Vector<Date>();
			Vector<String> bz = new Vector<String>();
			Vector<Integer> station_id = new Vector<Integer>();
			Vector<Integer> enrolltime_id = new Vector<Integer>();
			Vector<Integer> majorrecord_id = new Vector<Integer>();
			Vector<Integer> majortype_id = new Vector<Integer>();
			Vector<Integer> majorlength_id = new Vector<Integer>();
			String export_sql = "select * from major";
			export_st = export_con.prepareStatement(export_sql);
			ResultSet rs = export_st.executeQuery();
			
			String import_sql = "insert into major (name,code,intime,outtime,bz," +
					"station_id,enrolltime_id,majorrecord_id,majortype_id," +
					"majorlength_id) values (?,?,?,?,?,?,?,?,?,?)";
			import_st = import_con.prepareStatement(import_sql);
			int count = 0;
			while(rs.next()){
				count ++;
				id_num.put(rs.getInt("id"), count);
				name.addElement(rs.getString("name"));
				code.addElement(rs.getString("code"));
				intime.addElement(rs.getDate("intime"));
				outtime.addElement(rs.getDate("outtime"));
				bz.addElement(rs.getString("bz"));
				station_id.addElement(rs.getInt("station_id"));
				enrolltime_id.addElement(rs.getInt("enrolltime_id"));
				majorrecord_id.addElement(rs.getInt("majorrecord_id"));
				majortype_id.addElement(rs.getInt("majortype_id"));
				majorlength_id.addElement(rs.getInt("majorlength_id"));
			}
			rs.close();
			export_st.close();
			for (int i = 0; i < count; i++) {
				import_st.setString(1, name.elementAt(i));
				import_st.setString(2, code.elementAt(i));
				import_st.setDate(3, intime.elementAt(i));
				import_st.setDate(4, outtime.elementAt(i));
				import_st.setString(5, bz.elementAt(i));
				import_st.setInt(6, station_id_num.get(station_id.elementAt(i)));
				import_st.setInt(7, enrolltime_id_num.get(enrolltime_id.elementAt(i)));
				import_st.setInt(8, majorrecord_id_num.get(majorrecord_id.elementAt(i)));
				import_st.setInt(9, majortype_id_num.get(majortype_id.elementAt(i)));
				import_st.setInt(10, majorlength_id_num.get(majorlength_id.elementAt(i)));
				import_st.execute();
			}
			
			import_st.close();
			import_con.commit();
			export_con.commit();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}