KickJava   Java API By Example, From Geeks To Geeks.

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


1 package org.javabb.migration.phpbb;
2 import java.sql.Connection JavaDoc;
3 import java.sql.PreparedStatement JavaDoc;
4 import java.sql.ResultSet JavaDoc;
5 import java.sql.SQLException JavaDoc;
6 import java.sql.Statement JavaDoc;
7
8 /*$Id: JbbMerge.java,v 1.3.10.2 2006/04/17 17:46:44 daltoncamargo Exp $*/
9 public class JbbMerge extends Jbb_Convert {
10     
11     public void convert() throws ClassNotFoundException JavaDoc, SQLException JavaDoc {
12         sql = "SELECT * FROM jbb_posts ORDER BY id_post;";
13
14         Connection JavaDoc phpConn = this.getPhpBBConnection();
15         Statement JavaDoc stm = phpConn.createStatement();
16
17         ResultSet JavaDoc rs = stm.executeQuery(sql);
18
19         Connection JavaDoc javaConn = this.getJavaBBConnection();
20         PreparedStatement JavaDoc ps = javaConn.prepareStatement("INSERT INTO jbb_category (id_category, nm_category, cat_order) VALUES (?,?,?);");
21
22         System.out.print("\tInserting data ");
23         while (rs.next()) {
24             ps.setInt(1, rs.getInt("cat_id"));
25             ps.setString(2, rs.getString("cat_title"));
26             ps.setString(3, rs.getString("cat_order"));
27             
28             ps.executeUpdate();
29             System.out.print(".");
30         }
31         System.out.print("\n");
32         
33         ps.close();
34         stm.close();
35         rs.close();
36         phpConn.close();
37         javaConn.close();
38         System.out.print("Done!\n\n");
39     }
40 }
41
Popular Tags