connectivity of MySQL with java
-
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection cn=DriverManager.getConnection("jdbc:odbc:gaurav","",""); String sql="SELECT * FROM optrdata WHERE name=? ANd password=?"; PreparedStatement pst=cn.prepareStatement(sql); pst.setString(1,t2.getText().trim()); pst.setString(2,t3.getText().trim()); THE ABOVE LINE OF CODE CONNECTS JAVA WITH FORXPRO NOW I WANT TO USE THE SAME CODE CONNECTED TO MY SQL PLEASE GIVE ME THE CODE FOR THE CONNECTIVITY OF MYSQL WITH JAVA....
-
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection cn=DriverManager.getConnection("jdbc:odbc:gaurav","",""); String sql="SELECT * FROM optrdata WHERE name=? ANd password=?"; PreparedStatement pst=cn.prepareStatement(sql); pst.setString(1,t2.getText().trim()); pst.setString(2,t3.getText().trim()); THE ABOVE LINE OF CODE CONNECTS JAVA WITH FORXPRO NOW I WANT TO USE THE SAME CODE CONNECTED TO MY SQL PLEASE GIVE ME THE CODE FOR THE CONNECTIVITY OF MYSQL WITH JAVA....
-
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection cn=DriverManager.getConnection("jdbc:odbc:gaurav","",""); String sql="SELECT * FROM optrdata WHERE name=? ANd password=?"; PreparedStatement pst=cn.prepareStatement(sql); pst.setString(1,t2.getText().trim()); pst.setString(2,t3.getText().trim()); THE ABOVE LINE OF CODE CONNECTS JAVA WITH FORXPRO NOW I WANT TO USE THE SAME CODE CONNECTED TO MY SQL PLEASE GIVE ME THE CODE FOR THE CONNECTIVITY OF MYSQL WITH JAVA....
Since you're using the JDBC-ODBC bridge, the same code will work to connect to almost any database. You just need to change your ODBC datasource connection.