1 package org.mvnforum.util; 2 3 import java.io.File ; 4 import java.io.FileInputStream ; 5 import java.io.FileNotFoundException ; 6 import java.io.FileOutputStream ; 7 import java.io.IOException ; 8 import java.sql.Connection ; 9 import java.sql.DriverManager ; 10 import java.sql.ResultSet ; 11 import java.sql.SQLException ; 12 import java.sql.Statement ; 13 14 import javax.xml.parsers.DocumentBuilder ; 15 import javax.xml.parsers.DocumentBuilderFactory ; 16 import javax.xml.parsers.ParserConfigurationException ; 17 import javax.xml.transform.Result ; 18 import javax.xml.transform.Source ; 19 import javax.xml.transform.Transformer ; 20 import javax.xml.transform.TransformerConfigurationException ; 21 import javax.xml.transform.TransformerException ; 22 import javax.xml.transform.TransformerFactory ; 23 import javax.xml.transform.dom.DOMSource ; 24 import javax.xml.transform.stream.StreamResult ; 25 26 import org.w3c.dom.Document ; 27 28 public class DBUtils { 29 30 private static Document doc = null; 31 static { 32 try { 33 DocumentBuilder builder = DocumentBuilderFactory.newInstance().newDocumentBuilder(); 34 doc = builder.newDocument(); 35 doc.appendChild(doc.createElement("MvnForum")); 36 } catch (ParserConfigurationException e) { 37 e.printStackTrace(); 38 } 39 } 40 41 49 public static Connection getPhpbbConnection() 50 throws SQLException { 51 52 Connection conection = null; 53 String phpurl = "jdbc:mysql://" + Phpbb2MvnforumConfig.PHP_HOST + "/" + Phpbb2MvnforumConfig.PHP_DB; 54 55 try { 56 Class.forName("com.mysql.jdbc.Driver").newInstance(); 57 } catch (Exception E) { 58 System.err.println("Unable to load driver."); 59 E.printStackTrace(); 60 } 61 62 conection = DriverManager.getConnection(phpurl, Phpbb2MvnforumConfig.PHP_USER, Phpbb2MvnforumConfig.PHP_PASS); 63 64 return conection; 65 } 66 67 75 76 public static Connection getMvnConnection() 77 throws SQLException { 78 79 Connection conection = null; 80 String phpurl = "jdbc:mysql://" + Phpbb2MvnforumConfig.MVN_HOST + "/" + Phpbb2MvnforumConfig.MVN_DB; 81 82 try { 83 Class.forName("com.mysql.jdbc.Driver").newInstance(); 84 } catch (Exception E) { 85 System.err.println("Unable to load driver."); 86 E.printStackTrace(); 87 } 88 89 conection = DriverManager.getConnection(phpurl, Phpbb2MvnforumConfig.MVN_USER, Phpbb2MvnforumConfig.MVN_PASS); 90 91 return conection; 92 } 93 94 98 public static void closeResultSet(ResultSet rs) { 99 try { 100 if (rs != null) 101 rs.close(); 102 } catch (SQLException e) { 103 e.printStackTrace(); 104 } 105 } 106 107 111 public static void closeStatement(Statement statement) { 112 try { 113 if (statement != null) 114 statement.close(); 115 } catch (SQLException e) { 116 e.printStackTrace(); 117 } 118 } 119 120 126 public static void closeConnection(Connection connection) { 127 if (connection == null) 128 return; 129 try { 130 connection.close(); 131 } catch (SQLException e) { 132 e.printStackTrace(); 133 } 134 } 135 136 public static Document getDomDocument(){ 137 return doc; 138 } 139 140 public static void writeXmlFile(Document doc, String filename) { 141 try { 142 Source source = new DOMSource (doc); 144 145 File file = new File (filename); 147 Result result = new StreamResult (file); 148 149 Transformer xformer = TransformerFactory.newInstance().newTransformer(); 151 xformer.transform(source, result); 152 } catch (TransformerConfigurationException e) { 153 e.printStackTrace(); 154 } catch (TransformerException e) { 155 e.printStackTrace(); 156 } 157 } 158 159 public static FileInputStream getInput() { 160 try { 161 FileInputStream file = new FileInputStream (Phpbb2MvnforumConfig.EXPORT_XML); 162 return file; 163 } catch (FileNotFoundException e) { 164 e.printStackTrace(); 166 } 167 return null; 168 } 169 170 public static FileOutputStream getOutput() { 171 FileOutputStream file; 173 try { 174 file = new FileOutputStream (Phpbb2MvnforumConfig.EXPORT_XML); 175 return file; 176 } catch (FileNotFoundException e) { 177 e.printStackTrace(); 179 } 180 return null; 181 182 } 183 184 } 185 | Popular Tags |