tableadminconcert.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.Vector;

public class TableAdminConcert {
	public void daoAdmin(Connection import_con,Connection export_con){
		try {
		    PreparedStatement import_st = null;
			PreparedStatement export_st = null;
			Vector<String> username = new Vector<String>();
			Vector<String> password = new Vector<String>();
			String export_sql = "select * from admin";
			export_st = export_con.prepareStatement(export_sql);
			ResultSet rs = export_st.executeQuery();
			
			String import_sql = "insert into admin (username,password) values (?,?)";
			import_st = import_con.prepareStatement(import_sql);
			int count = 0;
			while(rs.next()){
				count ++;
		        username.addElement(rs.getString("username"));
				password.addElement(rs.getString("password"));
			}
			rs.close();
			export_st.close();
			for(int i=0;i<count;i++){
				import_st.setString(1, username.elementAt(i));
				import_st.setString(2, password.elementAt(i));
				import_st.execute();
			}
			if (!username.isEmpty()) {
				username.clear();
				password.clear();
			}
			import_st.close();
			import_con.commit();
			export_con.commit();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}