tablestudentconcert.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 TableStudentConcert {
	static HashMap<Integer,Integer> id_num = new HashMap<Integer,Integer>();
	public HashMap<Integer,Integer> getID_Num(){
		return id_num;
	}

	public void daoStudent(Connection import_con,Connection export_con,
			HashMap<Integer,Integer> major_id_num,HashMap<Integer,Integer> studentstatue_id_num) {
		
		try {
    		PreparedStatement import_st = null;
			PreparedStatement export_st = null;
			Vector<Integer> sorder = new Vector<Integer>();
			Vector<String> stuno = new Vector<String>();
			Vector<String> stuid = new Vector<String>();
			Vector<String> name = new Vector<String>();
			Vector<Integer> age = new Vector<Integer>();
			Vector<String> sex = new Vector<String>();
			Vector<String> bz = new Vector<String>();
			Vector<Integer> major_id = new Vector<Integer>();
			Vector<Integer> studentstatue_id = new Vector<Integer>();
			String export_sql = "select * from student";
			export_st = export_con.prepareStatement(export_sql);
			ResultSet rs = export_st.executeQuery();
			
			String import_sql = "insert into student (sorder,stuno,stuid,name," +
					"age,sex,bz,major_id,studentstatue_id) values (?,?,?,?,?,?,?,?,?)";
			import_st = import_con.prepareStatement(import_sql);
			int count = 0;
			while(rs.next()){
				count ++;
				id_num.put(rs.getInt("id"), count);
				sorder.addElement(rs.getInt("sorder"));
				stuno.addElement(rs.getString("stuno"));
				stuid.addElement(rs.getString("stuid"));
				name.addElement(rs.getString("name"));
				age.addElement(rs.getInt("age"));
				sex.addElement(rs.getString("sex"));
				bz.addElement(rs.getString("bz"));
				major_id.addElement(rs.getInt("major_id"));
				studentstatue_id.addElement(rs.getInt("studentstatue_id"));
			}
			rs.close();
			export_st.close();
			for(int i=0;i<count;i++){
				import_st.setInt(1, sorder.elementAt(i));
			    import_st.setString(2, stuno.elementAt(i));
			    import_st.setString(3,stuid.elementAt(i));
			    import_st.setString(4, name.elementAt(i));
			    import_st.setInt(5, age.elementAt(i));
			    import_st.setString(6, sex.elementAt(i));
			    import_st.setString(7, bz.elementAt(i));
			    import_st.setInt(8, major_id_num.get(major_id.elementAt(i)));
			    import_st.setInt(9,studentstatue_id_num.get(studentstatue_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();
		}
	}
}