tableadminconcert.java

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

package org.wuhang.cjsjk.OldDbToNewDb;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Vector;

import org.minjey.cjsjk.dao.Dao;
import org.minjey.cjsjk.model.Admin;

public class TableAdminConcert {
	public static void admin_concert(Connection old_con) {
		   try {
			    Statement st = old_con.createStatement();
				ResultSet rs = st.executeQuery("select * from admin");
				Vector<String> userName_vector = new Vector<String>();
				Vector<String> userPwd_vector = new Vector<String>();
				while (rs.next()) {
					userName_vector.addElement(rs.getString("userName"));
					userPwd_vector.addElement(rs.getString("userPwd"));
			    }
				rs.close();
				st.close();
				for(int i=0;i<userName_vector.size();i++){
				    Admin admin_one = new Admin();
				    admin_one.setUsername(userName_vector.elementAt(i));
				    admin_one.setPassword(userPwd_vector.elementAt(i));
				    Dao dao = Dao.getDao();
				    dao.save(admin_one);
				}
			} catch (Exception e) {
				System.out.println("some error");
				System.out.println(e.getMessage());
	        } 
		}
}