ppackage musicdb; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.logging.Level; import java.util.logging.Logger; /** * * @author gustafsp */ public class DatabasServer { final static String server = "localhost"; final static int port = 3306; final static String login = "root"; final static String password = "mysql"; final static String databas = "music"; private static Connection con; public static Connection connect() { try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException ex) { System.out.println("MYSQL driver missing?"); } //Define URL of database server for // database named JunkDB on the localhost // with the default port number 3306. String url = "jdbc:mysql://" + DatabasServer.server + ":" + DatabasServer.port; try { //Get a connection to the database for a // user named auser with the password // drowssap, which is password spelled // backwards. con = DriverManager.getConnection( url, DatabasServer.login, DatabasServer.password); return con; } catch (SQLException ex) { System.out.println("Login Fail: password ok?"); } return null; } public static ResultSet query(String sql) { try { if (con == null) { con = DatabasServer.connect(); } Statement stmt = con.createStatement(); if (stmt.execute(sql)) { return stmt.getResultSet(); } } catch (SQLException ex) { Logger.getLogger(DatabasServer.class.getName()).log(Level.SEVERE, null, ex); } return null; } public static String[] fetchArray(ResultSet result) { try { String[] array = new String[result.getMetaData().getColumnCount()]; if (result.next()) { for (int i = 1; i <= result.getMetaData().getColumnCount(); i++) { array[i - 1] = result.getString(i); } return array; } } catch (SQLException ex) { Logger.getLogger(DatabasServer.class.getName()).log(Level.SEVERE, null, ex); } return null; //om fel eller inget värde } }
tisdag 30 mars 2010
DatabasServer- java - hur du komunicerar med DB
Prenumerera på:
Kommentarer till inlägget (Atom)
Inga kommentarer:
Skicka en kommentar