tablecourseconcert.java

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

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 TableCourseConcert {
	static HashMap<Integer,Integer> id_num = new HashMap<Integer,Integer>();
	public HashMap<Integer,Integer> getID_Num(){
		return id_num;
	}
    public void daoCourse(Connection import_con,Connection export_con,
    		HashMap<Integer,Integer> major_id_num,HashMap<Integer,Integer> examtype_id_num) {
    	try {
    		PreparedStatement import_st = null;
			PreparedStatement export_st = null;
			Vector<Integer> corder = new Vector<Integer>();
			Vector<String> name = new Vector<String>();
			Vector<Integer> length = new Vector<Integer>();
			Vector<Float> point = new Vector<Float>();
			Vector<Integer> semester = new Vector<Integer>();
			Vector<String> teacher = new Vector<String>();
			Vector<String> book = new Vector<String>();
			Vector<Float> price = new Vector<Float>();
			Vector<String> publiser = new Vector<String>();
			Vector<String> bz = new Vector<String>();
			Vector<Integer> major_id = new Vector<Integer>();
			Vector<Integer> examtype_id = new Vector<Integer>();
			String export_sql = "select * from course";
			export_st = export_con.prepareStatement(export_sql);
			ResultSet rs = export_st.executeQuery();
			
			String import_sql = "insert into course (corder,name,length,point," +
					"semester,teacher,book,price,publisher,bz,major_id," +
					"examtype_id) values (?,?,?,?,?,?,?,?,?,?,?,?)";
			import_st = import_con.prepareStatement(import_sql);
			int count = 0;
			while(rs.next()){
				count++;
				id_num.put(rs.getInt("id"), count);
				corder.addElement(rs.getInt("corder"));
				name.addElement(rs.getString("name"));
				length.addElement(rs.getInt("length"));
				point.addElement(rs.getFloat("point"));
				semester.addElement(rs.getInt("semester"));
				teacher.addElement(rs.getString("teacher"));
				book.addElement(rs.getString("book"));
				price.addElement(rs.getFloat("price"));
				publiser.addElement(rs.getString("publisher"));
				bz.addElement(rs.getString("bz"));
				major_id.addElement(rs.getInt("major_id"));
				examtype_id.addElement(rs.getInt("examtype_id"));
			}
			rs.close();
			export_st.close();
			for(int i=0;i<count;i++){
				import_st.setInt(1, corder.elementAt(i));
			    import_st.setString(2, name.elementAt(i));
			    import_st.setInt(3,length.elementAt(i));
			    import_st.setFloat(4, point.elementAt(i));
			    import_st.setInt(5, semester.elementAt(i));
			    import_st.setString(6, teacher.elementAt(i));
			    import_st.setString(7, book.elementAt(i));
			    import_st.setFloat(8, price.elementAt(i));
			    import_st.setString(9,publiser.elementAt(i));
			    import_st.setString(10, bz.elementAt(i));
			    import_st.setInt(11, major_id_num.get(major_id.elementAt(i)));
			    import_st.setInt(12,examtype_id_num.get(examtype_id.elementAt(i)));
				import_st.execute();
			}
			
			import_st.close();
			import_con.commit();
			export_con.commit();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}