bhagyashree devji
Junior Member

sir, i create a application with database but this is showing an error.
import java.sql.*;
public class MYSQLDEMO {


public static void main(String[] args) throws SQLException,ClassNotFoundException{
String driverClass="sun.jdbc.odbc.JdbcOdbcDriver";
String url="jdbcdbc:msqldsn";
String user="root";
String password="test";
Class.forName(driverClass);
Connection con=DriverManager.getConnection(url,user,password) ;
Statement st=con.createStatement();
String sql="insert into student values(23,nit,45)";
st.executeUpdate(sql);
System.out.println("query executed");
con.close();

}

}
please can u see the program and tell me if i did any mistake.
after running of the program it shows like this


at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknow n Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at MYSQLDEMO.main(MYSQLDEMO.java:11)