|
1
5
6 package org.javabb.migration.phpbb;
7 import java.sql.Connection  ;
8 import java.sql.PreparedStatement ;
9 import java.sql.ResultSet ;
10 import java.sql.SQLException ;
11 import java.sql.Statement ;
12
13 public class Jbb_forum extends Jbb_Convert {
14
15 public void convert() throws ClassNotFoundException , SQLException {
16 sql = "SELECT * FROM "+phpbb_prefix+"forums ORDER BY forum_id;";
17 System.out.println("TABLE JBB_FORUM.");
18 Connection phpConn = this.getPhpBBConnection();
19 Statement stm = phpConn.createStatement();
20 System.out.println("\tReading data");
21 ResultSet rs = stm.executeQuery(sql);
22
23 Connection javaConn = this.getJavaBBConnection();
24
25 javaConn.createStatement().executeUpdate("delete from jbb_forum");
27 System.out.println("delete from jbb_forum is OK!");
28
29 PreparedStatement ps = javaConn.prepareStatement("INSERT INTO jbb_forum (id_forum, nome, descricao, " +
30 "forum_status, forum_order, id_category, topic_count, post_count, last_post_id, last_page_post) " +
31 "VALUES (?,?,?,?,?,?,?,?,?,?);");
32
33 System.out.println("\tInserting data ");
34 while (rs.next()) {
35 ps.setInt ( 1, rs.getInt("forum_id"));
36 ps.setString ( 2, rs.getString("forum_name"));
37 ps.setString ( 3, rs.getString("forum_desc"));
38 ps.setInt ( 4, rs.getInt("forum_status"));
39 ps.setInt ( 5, rs.getInt("forum_order"));
40 ps.setInt ( 6, rs.getInt("cat_id"));
41 ps.setInt ( 7, rs.getInt("forum_topics"));
42 ps.setInt ( 8, rs.getInt("forum_posts"));
43 ps.setInt ( 9, rs.getInt("forum_last_post_id"));
44 ps.setInt (10, 1);
46 ps.executeUpdate();
47 System.out.print(".");
48 }
49 System.out.println("\n");
50
51 ps.close();
52 stm.close();
53 rs.close();
54 phpConn.close();
55 javaConn.close();
56 System.out.print("Done!\n\n");
57 }
58 }
59 |
Popular Tags |
Java API By Example, From Geeks To Geeks.