KickJava   Java API By Example, From Geeks To Geeks.

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


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

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