odbc « mysql « Java Database Q&A

  1. Java Database Q&A
  2. mysql
  3. odbc




1. Java not giving Error!    stackoverflow.com

Here is my code - i am simply checking my MySQL database connection.
But first i have compiled and run the program successfully. but then i have commented the line Class.forName .
Still ...

2. ODBC - mysql connectivity    coderanch.com

import java.io.*; import java.sql.*; import java.util.*; class Testmin { Statement stmt=null; Connection cn=null; private String query; String s; public Testmin() { System.out.println("Enter a date:\n"); Scanner sc= new Scanner(System.in); s=sc.next(); java.sql.Date d1=java.sql.Date.valueOf(s); System.out.println(d1); try { Class.forName("com.mysql.jdbc.Driver"); cn=DriverManager.getConnection("jdbc:mysql://jeyasri-desktop:3306/prog","root","123456"); if(cn!=null) { stmt=cn.createStatement(); query="insert into Date values("+d1+");"; stmt.executeUpdate(query); } else System.out.println("Not connected"); } catch(SQLException sqle) { System.out.println(sqle); } catch(ClassNotFoundException cnfe) { System.out.println(cnfe); } } } ...