tablemajorrecordconcert.java

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

package org.wuhang.transfer;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Vector;
public class TableMajorrecordConcert {
	static HashMap<Integer,Integer> id_num = new HashMap<Integer,Integer>();
	public HashMap<Integer,Integer> getID_Num(){
		return id_num;
	}
	public void daoMajorrecord(Connection import_con,Connection export_con){
	    	try {
	    		PreparedStatement import_st = null;
				PreparedStatement export_st = null;
				Vector<String> name = new Vector<String>();
				String export_sql = "select * from majorrecord";
				export_st = export_con.prepareStatement(export_sql);
				ResultSet rs = export_st.executeQuery();
				
				String import_sql = "insert into majorrecord (name) 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"));
				}
				rs.close();
				export_st.close();
				for(int i=0;i<count;i++){
				    import_st.setString(1, name.elementAt(i));
				    import_st.execute();
				}
				if(!name.isEmpty()){
					name.clear();
				}
				import_st.close();
				import_con.commit();
				export_con.commit();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
	    }
}