tablestudentconcert.java

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

package org.wuhang.cjsjk.OldDbToNewDb;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.HashMap;

public class TableStudentConcert {
	
	static HashMap<Integer,Integer> id_num = new HashMap<Integer,Integer>();
	static HashMap<Integer,Integer> student_major = new HashMap<Integer,Integer>();
	public static HashMap<Integer,Integer> getID_Num(){
		return id_num;
	}
	public static HashMap<Integer,Integer> getStudentMajor_id(){
		return student_major;
	}
	public static void student_concert(Connection old_con,Connection new_con,HashMap<Integer,Integer> major_id_num) {
		
		try {
			Statement st = old_con.createStatement();
			ResultSet rs = st.executeQuery("select * from student order by id");
			int count = 0;
			int old_major_id = 0;
		    while (rs.next()) {
			    count++;
			 
				id_num.put(rs.getInt("id"), count);
				PreparedStatement statement = new_con
						.prepareStatement("insert into student (sorder,stuno,stuid," +
								"name,age,sex,bz,major_id,studentstatue_id) values(?,?,?," +
								"?,?,?,?,?,?)");
			    statement.setInt(1, count);
				statement.setString(2, rs.getString("stu_no"));
				statement.setString(3, rs.getString("id_code"));
				String xingming = rs.getString("name");
				statement.setString(4, xingming);
				statement.setInt(5, rs.getInt("age"));
				statement.setString(6, rs.getString("sex"));
				statement.setString(7, rs.getString("bz"));
				old_major_id = rs.getInt("major_id");
				statement.setInt(8, major_id_num.get(old_major_id));
		    	
				if(rs.getBoolean("is_graduated"))
					statement.setInt(9, 1);
				else
					statement.setInt(9, 2);
				student_major.put(count, major_id_num.get(old_major_id));
				
				statement.execute();
				   
				statement.close();
			}
		    new_con.commit();
			rs.close();
			st.close();
		} catch (Exception e) {
			System.out.println("some error");
			System.out.println(e.getMessage());

		} finally {
			
		}
	}
}