tableenrolltimeconcert.java

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

package org.wuhang.cjsjk.OldDbToNewDb;
import java.sql.Connection;
import java.sql.Date;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.HashMap;
import java.util.Vector;
import org.minjey.cjsjk.dao.Dao;
import org.minjey.cjsjk.model.EnrollTime;
public class TableEnrolltimeConcert {
	static HashMap<Integer,Integer> id_num = new HashMap<Integer,Integer>();
	static HashMap<Integer,Date> intime = new HashMap<Integer,Date>();
	public static HashMap<Integer,Integer> getID_Num(){
		return id_num;
	}
	public static HashMap<Integer,Date> getIntime(){
		return intime;
	}
	public static void enrolltime_concert(Connection old_con) {
		try {
			Statement st = old_con.createStatement();
			ResultSet rs = st.executeQuery("select * from enrollment_time");			
			int count = 0;
			Vector<Date> enrolltime_v = new Vector<Date>();
			while (rs.next()) {
				count++;
				id_num.put(rs.getInt("id"), count);
				Date in_time = rs.getDate("time");
				enrolltime_v.addElement(in_time);
				intime.put(count, in_time);
			}
            rs.close();
			st.close();
			for(int i=0;i<enrolltime_v.size();i++){
				EnrollTime enrolltime_o = new EnrollTime();
				enrolltime_o.setEtime(enrolltime_v.elementAt(i));
				Dao dao = Dao.getDao();
				dao.save(enrolltime_o);
			}
			
		} catch (Exception e) {
			System.out.println("some error");
			System.out.println(e.getMessage());
        } 
	}
}