Looking for a JavaEE Architect or Potential Tech Co-Founder?
Please don't hesitate to contact me.

How to connect MySql or PostgreSql Server from Java using JDBC Driver

How to connect MySql or PostgreSql Server from Java using JDBC Driver

I think the best answer to this is through coding:

private static Connection getConnection() {
 Connection conn = null;
 try {
  Class.forName("com.mysql.jdbc.Driver");
  //conn = DriverManager.getConnection("jdbc:postgresql://127.0.0.1:5432/anime", "ipieluser", "ipielpassword"); //postgresql
  conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/anime", "ipieluser", "ipielpassword"); //mysql
 } catch(Exception e) {
  e.printStackTrace();
 } finally {
 try {
   if(!conn.isClosed())
    conn.close();
  } catch(SQLException e1) { }
 }
}

To use the method and execute an sql in the server:

try {
 Connection conn = getConnection();
 Statement st = conn.createStatement();
 
 st = conn.createStatement();
 ResultSet rs = st.executeQuery("SELECT * FROM localTable");
 ResultSetMetaData rsMetaData = rs.getMetaData();
 int colCount = rsMetaData.getColumnCount();
 
 //get and display the number of columns
 System.out.println("resultSet MetaData column Count=" + colCount); 
 
 //display the column names
 for(int i = 1; i < colCount; i++) {
  System.out.print(rsMetaData.getColumnName(i) + " ");
 }
 
 st.close();
 conn.close();
} catch(Exception e) {
 System.out.println(e.getMessage());
}

Things to remember:
-DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/anime", "ipieluser", "ipielpassword"); //mysql
=DriverManager.getConnection("jdbc:database://host:port/databasename", "username", "password");
How to connect MySql or PostgreSql Server from Java using JDBC Driver How to connect MySql or PostgreSql Server from Java using JDBC Driver Reviewed by czetsuya on Wednesday, January 20, 2010 Rating: 5

No comments:

Powered by Blogger.