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_emoticon extends Jbb_Convert { 14 15 public void convert() throws ClassNotFoundException , SQLException { 16 sql = "SELECT * FROM "+phpbb_prefix+"smilies ORDER BY smilies_id;"; 17 System.out.println("TABLE JBB_EMOTICONS."); 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_smiles"); 27 System.out.println("delete from jbb_smiles is OK!"); 28 29 PreparedStatement ps = javaConn.prepareStatement("INSERT INTO jbb_smiles (id, symbol, filename, emoticon) VALUES (?,?,?,?);"); 30 31 System.out.println("\tInserting data "); 32 while (rs.next()) { 33 ps.setInt (1, rs.getInt("smilies_id")); 34 ps.setString(2, rs.getString("code")); 35 ps.setString(3, rs.getString("smile_url")); 36 ps.setString(4, rs.getString("emoticon")); 37 38 ps.executeUpdate(); 39 System.out.print("."); 40 } 41 System.out.print("\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 } 51 | Popular Tags |