tablemajorconcert.java

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

package org.wuhang.cjsjk.OldDbToNewDb;
import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.HashMap;
public class TableMajorConcert {
	static HashMap<Integer,Integer> id_num = new HashMap<Integer,Integer>();
	public static HashMap<Integer,Integer> getID_Num(){
		return id_num;
	}
	public static void major_concert(Connection old_con,Connection new_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,HashMap<Integer,Date> intime_id_num) {
		try {
			 Statement st = old_con.createStatement();
		     ResultSet rs = st.executeQuery("select * from major"); 
		
			int count =0;
			int spaceid,enrolltimeid,new_enrolltimeid,recordofschoolid,schooltypeid,schoollengthid;
			while (rs.next()) {
				count++;
				id_num.put(rs.getInt("id"), count);
				PreparedStatement statement = new_con
						.prepareStatement("insert into major (name,code,intime,outtime," +
								"bz,station_id,enrolltime_id,majorrecord_id," +
								"majortype_id,majorlength_id) values(?,?,?,?,?," +
								"?,?,?,?,?)");
				
				statement.setString(1, rs.getString("name"));
				statement.setString(2, rs.getString("code"));
				
				enrolltimeid = rs.getInt("enrollment_time_id");
				new_enrolltimeid = enrolltime_id_num.get(enrolltimeid);
				statement.setDate(3, intime_id_num.get(new_enrolltimeid));
				
				statement.setDate(4,rs.getDate("out_time"));
				statement.setString(5,"");
				spaceid = rs.getInt("space_id");
				statement.setInt(6,station_id_num.get(spaceid));
				statement.setInt(7, new_enrolltimeid);
				
				recordofschoolid = rs.getInt("record_of_school_id");
				statement.setInt(8, majorrecord_id_num.get(recordofschoolid));
				
				schooltypeid = rs.getInt("school_type_id");
				statement.setInt(9, majortype_id_num.get(schooltypeid));
				
				schoollengthid = rs.getInt("school_length_id");
				statement.setInt(10, majorlength_id_num.get(schoollengthid));
				
				statement.execute();
				statement.close();
			}
			new_con.commit();
			rs.close();
			st.close();
		} catch (Exception e) {
			System.out.println("some error");
			System.out.println(e.getMessage());
        } 
	}
}