1 5 6 package org.javabb.migration.phpbb; 7 8 import java.sql.Connection ; 9 import java.sql.PreparedStatement ; 10 import java.sql.ResultSet ; 11 import java.sql.SQLException ; 12 import java.sql.Statement ; 13 14 public class Jbb_badwords extends Jbb_Convert { 15 16 public void convert() throws ClassNotFoundException , SQLException { 17 sql = "SELECT * FROM " + phpbb_prefix + "words ORDER BY word_id;"; 18 System.out.println("TABLE JBB_BADWORDS."); 19 Connection phpConn = this.getPhpBBConnection(); 20 Statement stm = phpConn.createStatement(); 21 System.out.println("\tReading data"); 22 ResultSet rs = stm.executeQuery(sql); 23 24 Connection javaConn = this.getJavaBBConnection(); 25 javaConn.createStatement().executeUpdate("delete from jbb_badwords"); 27 System.out.println("delete from jbb_badwords is OK!"); 28 29 30 PreparedStatement ps = javaConn.prepareStatement("INSERT INTO jbb_badwords (id_badword, word, replacement) VALUES (?,?,?);"); 31 32 System.out.println("\tInserting data "); 33 while (rs.next()) { 34 ps.setInt(1, rs.getInt("word_id")); 35 ps.setString(2, rs.getString("word")); 36 ps.setString(3, rs.getString("replacement")); 37 38 ps.executeUpdate(); 39 System.out.print("."); 40 } 41 System.out.println("\n"); 42 43 ps.close(); 44 stm.close(); 45 rs.close(); 46 phpConn.close(); 47 javaConn.close(); 48 System.out.print("Done!\n\n"); 49 } 50 } | Popular Tags |