1 package org.javabb.migration.phpbb; 2 import java.sql.Connection ; 3 import java.sql.PreparedStatement ; 4 import java.sql.ResultSet ; 5 import java.sql.SQLException ; 6 import java.sql.Statement ; 7 8 9 public class JbbMerge extends Jbb_Convert { 10 11 public void convert() throws ClassNotFoundException , SQLException { 12 sql = "SELECT * FROM jbb_posts ORDER BY id_post;"; 13 14 Connection phpConn = this.getPhpBBConnection(); 15 Statement stm = phpConn.createStatement(); 16 17 ResultSet rs = stm.executeQuery(sql); 18 19 Connection javaConn = this.getJavaBBConnection(); 20 PreparedStatement 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 |