KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > javabb > migration > phpbb > Jbb_badwords


1 /**
2  * Script de migração phpBB -> JavaBB
3  * @author Lucas Teixeira - lucas@javabb.org
4  */

5
6 package org.javabb.migration.phpbb;
7
8 import java.sql.Connection JavaDoc;
9 import java.sql.PreparedStatement JavaDoc;
10 import java.sql.ResultSet JavaDoc;
11 import java.sql.SQLException JavaDoc;
12 import java.sql.Statement JavaDoc;
13
14 public class Jbb_badwords extends Jbb_Convert {
15
16     public void convert() throws ClassNotFoundException JavaDoc, SQLException JavaDoc {
17         sql = "SELECT * FROM " + phpbb_prefix + "words ORDER BY word_id;";
18         System.out.println("TABLE JBB_BADWORDS.");
19         Connection JavaDoc phpConn = this.getPhpBBConnection();
20         Statement JavaDoc stm = phpConn.createStatement();
21         System.out.println("\tReading data");
22         ResultSet JavaDoc rs = stm.executeQuery(sql);
23
24         Connection JavaDoc javaConn = this.getJavaBBConnection();
25         //Limpando a tabela
26
javaConn.createStatement().executeUpdate("delete from jbb_badwords");
27         System.out.println("delete from jbb_badwords is OK!");
28         
29         
30         PreparedStatement JavaDoc 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