jbb_users.java

来自「javaBB,一套很不錯的JSP源碼,特共享給大家」· Java 代码 · 共 47 行

/**
 * Script de migra玢o phpBB -> JavaBB
 * @author Lucas Teixeira - [e-mail]
 */

package org.javabb.migration.phpbb;
import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Jbb_users extends Jbb_Convert {
    
    public void convert() throws ClassNotFoundException, SQLException {
        sql = "select * from phpbb_users order by user_id;";
        System.out.println("TABLE JBB_USERS.");
        Connection phpConn = this.getPhpBBConnection();
        Statement stm = phpConn.createStatement();
        System.out.println("\tReading data");
        ResultSet rs = stm.executeQuery(sql);
        long i = 0;
       
        Connection javaConn = this.getJavaBBConnection();
        
        //javaConn.createStatement().executeUpdate("ALTER TABLE jbb_users MODIFY COLUMN id_user BIGINT(20) NOT NULL DEFAULT '0'");
        //System.out.println("ALTER TABLE jbb_users MODIFY COLUMN id_user BIGINT(20) NOT NULL DEFAULT '0' is OK!");
        //"Opera玢o  : ALTER TABLE jbb_users MODIFY COLUMN id_user BIGINT(20) NOT NULL DEFAULT '0' AUTO_INCREMENT"
        
        javaConn.createStatement().executeUpdate("delete from jbb_users");
        System.out.println("delete from jbb_users is OK!");
        
        PreparedStatement ps = javaConn.prepareStatement("insert into jbb_users (id_user, user_name, pws, name, email, posts, admin, " +
                "data_registro, localizacao, website, occupation, user_sig, user_msnm, user_lastvisit, user_dateformat, " +
                "user_allow_viewonline, user_avatar, user_icq, user_interests, user_aim, user_yim, show_mail, show_signature, " +
                "user_code) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");

        System.out.println("\tInserting data ");
        while (rs.next()) {
            ps.setInt       ( 1, rs.getInt("user_id")); 
            ps.setString    ( 2, rs.getString("username"));
            ps.setString    ( 3, rs.getString("user_password"));
            ps.setString    ( 4, ""); //TODO Porque todos os usu醨ios tem que se chamar 'JavaBB User!' ? (;
            ps.setString    ( 5, rs.getString("user_email"));
            ps.setInt       ( 6, rs.getInt("user_posts"));
            ps.setInt       ( 7, 0); //TODO ninguem