tablecourseconcert.java

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

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;
import java.util.Vector;
public class TableCourseConcert {
	static Vector<Integer> course_id = new Vector<Integer>();
	static HashMap<Integer,Integer> majorcourse_id_num = null;
	static HashMap<Integer,HashMap<Integer,Integer>> coursemajor_id_num = new HashMap<Integer,HashMap<Integer,Integer>>();
	public static HashMap<Integer,HashMap<Integer,Integer>> getCourseMajor_id(){
		return coursemajor_id_num;
	}
	public static Vector<Integer> getCourse_id(){
		return course_id;
	}
    public static void course_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 course order by id");
			int order=0;
			int old_id = 0;
			String course_name,course_teacher,course_book,course_book_c;
			int course_time;
			float course_point,course_book_p;
			boolean course_type;
			Vector<Integer> major_id_vector = new Vector<Integer>();
			Vector<Integer> semester_vector = new Vector<Integer>();
			
			while (rs.next()) {
				old_id = rs.getInt("id");
				course_id.addElement(old_id);
				PreparedStatement sstt = old_con.prepareStatement("select major_id,semester from major_course where course_id = ?");
				sstt.setInt(1, old_id);
				ResultSet rrss = sstt.executeQuery();
				int old_major_id = 0;
				while(rrss.next()){
					old_major_id = rrss.getInt("major_id");
					major_id_vector.addElement(major_id_num.get(old_major_id));
					semester_vector.addElement(rrss.getInt("semester"));
				}
				rrss.close();
				sstt.close();
				course_name = rs.getString("name");
				course_teacher = rs.getString("teacher");
				course_book = rs.getString("book");
				course_book_c = rs.getString("book_concern");
				course_time = rs.getInt("class_time");
				course_point = rs.getFloat("class_point");
				course_book_p = rs.getFloat("book_price");
				course_type = rs.getBoolean("exam_type");
				majorcourse_id_num= new HashMap<Integer,Integer>();
				for (int i = 0; i < major_id_vector.size(); i++) {
					order ++;
					PreparedStatement statement = new_con
							.prepareStatement("insert into course (corder,name,length,point,"
									+ "semester,teacher,book,price,publisher,bz,major_id,examtype_id) values (?,"
									+ "?,?,?,?,?,?,?,?,?,?,?)");
					statement.setInt(1, order);
				    majorcourse_id_num.put(major_id_vector.elementAt(i), order);
					statement.setString(2, course_name);
					statement.setInt(3, course_time);
					statement.setFloat(4, course_point);
					statement.setInt(5, semester_vector.elementAt(i));
					statement.setString(6, course_teacher);
					statement.setString(7, course_book);
					statement.setFloat(8, course_book_p);
					statement.setString(9, course_book_c);
					statement.setString(10, "");
					statement.setInt(11, major_id_vector.elementAt(i));
				    if(course_type){
                    	statement.setInt(12, 1);
                    }
                    else
                    	statement.setInt(12, 2);
					statement.execute();
					statement.close();
				}
				
				major_id_vector.clear();
				semester_vector.clear();
				coursemajor_id_num.put(old_id, majorcourse_id_num);
			}
			new_con.commit();
			rs.close();
			st.close();
		} catch (Exception e) {
			System.out.println("some error");
			System.out.println(e.getMessage());
        }
	}
}