getConnection_Properties2 |
mysql driver :
|
Error Resolution : Meaning that NetBean Library did not have any information of MySQL connector |
How to add jar |
![]() |
Now MySQL library is added : |
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:mysql://localhost/test?"; String user = "Manas9"; String pwd = "Manas9237"; 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("jdbc:mysql://localhost/test?" + // "user=Manas9&password=Manas9237"); c = DriverManager.getConnection(dbURL, param); st= c.createStatement(); 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 (st== null || st.isClosed()) { } else { st.close(); } 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 } |
Runtime Views:
|