tablemajortypeconcert.java

来自「一个可以存储和打印成绩单的系统」· Java 代码 · 共 40 行

package org.wuhang.cjsjk.OldDbToNewDb;
import java.sql.Connection;
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.MajorType;
public class TableMajortypeConcert {
	static HashMap<Integer,Integer> id_num = new HashMap<Integer,Integer>();
	public static HashMap<Integer,Integer> getID_Num(){
		return id_num;
	}
	public static void majortype_concert(Connection old_con) {
		try {
			Statement st = old_con.createStatement();
			ResultSet rs = st.executeQuery("select * from school_type");	
			int count =0;
			Vector<String> majortype_vector = new Vector<String>();
			while (rs.next()) {
				count++;
				id_num.put(rs.getInt("id"), count);
				majortype_vector.addElement(rs.getString("type"));
			}
		    rs.close();
		    st.close();
		    
		    for(int i=0;i<majortype_vector.size();i++){
		    	MajorType majortype_one = new MajorType();
		    	majortype_one.setName(majortype_vector.elementAt(i));
		    	Dao dao = Dao.getDao();
		    	dao.save(majortype_one);
		    }
		} catch (Exception e) {
			System.out.println("some error");
			System.out.println(e.getMessage());
        } 
	}
}