Code :
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package template1;
import java.sql.Connection;
import java.sql.DriverManager;
//import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
/**
*
* @author Manas9
*/
public class Template1 {
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
// TODO code application logic here
System.out.println("main block executing ");
Connection c = null; Statement st = null;
String dbURL = "jdbc:postgresql://localhost:5432/postgres";
String user = "postgres"; String pwd = "postgre_manas9";
Properties param = new Properties();
// connecting to db
try {
//replacing Class.forName("org.postgresql.Driver");
param.put("user",user); param.put("password",pwd);
c = DriverManager.getConnection(dbURL,param);
System.out.println("Connected to database successfully");
} catch (SQLException ex) { ex.getErrorCode();
String message = ex.getMessage();
System.out.println(message);
} finally {
System.out.println("going through final block");
try {
if (c != null && !c.isClosed()) {
c.close(); }
} catch (SQLException ex) { ex.getErrorCode();
ex.getMessage();
}
}
System.out.println("dis-Connected to database successfully");
// st.close(); con.commit();con.close();
}
// main block ends here
}
|