|
1
5
6 package org.javabb.migration.betweendbs;
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 jbb_smiles ORDER BY id;";
17 System.out.println("TABLE JBB_EMOTICONS.");
18 Connection phpConn = this.getDbOrigin();
19 Statement stm = phpConn.createStatement();
20 System.out.println("\tReading data");
21 ResultSet rs = stm.executeQuery(sql);
22
23 Connection javaConn = this.getDbDest();
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("id"));
34 ps.setString(2, rs.getString("symbol"));
35 ps.setString(3, rs.getString("filename"));
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 |
Java API By Example, From Geeks To Geeks.