There is no error while compiling, but I'm getting this error on running my program:
java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver
Here is my code for inserting values in table in SQL Server.
import javax. swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
class login implements ActionListener
{
JFrame loginframe;
JPanel loginpanel, loginpanel1;
JLabel name, password, loginhead, loginstatus;
JTextField nametxt;
JPasswordField passwordtxt;
JButton loginsubmit, loginreset;
public login()
{
loginframe=new JFrame();
loginframe.setSize(300,300);
loginframe.setDefaultCloseOperation(loginframe.EXIT_ON_CLOSE);
loginframe.setVisible(true);
loginpanel=new JPanel();
loginpanel1=new JPanel(new GridLayout(4,2));
loginhead=new JLabel("Login");
loginstatus=new JLabel("");
name=new JLabel("Name");
password=new JLabel("Password");
nametxt=new JTextField(10);
passwordtxt=new JPasswordField(10);
loginsubmit=new JButton("submit");
loginsubmit.addActionListener(this);
loginreset=new JButton("Reset");
loginreset.addActionListener(this);
loginpanel1.add(loginhead);
loginpanel1.add(loginstatus);
loginpanel1.add(name);
loginpanel1.add(nametxt);
loginpanel1.add(password);
loginpanel1.add(passwordtxt);
loginpanel1.add(loginsubmit);
loginpanel1.add(loginreset);
loginpanel.add(loginpanel1);
loginframe.add(loginpanel);
}
public void actionPerformed(ActionEvent ae)
{
String name=nametxt.getText();
String pass=passwordtxt.getText();
if(ae.getSource()==loginsubmit)
{
String url1="jdbc:odbc:"+"login";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c=DriverManager.getConnection(url1);
Statement s=c.createStatement();
PreparedStatement ps=c.prepareStatement("insert into signup values(?,?)");
s.executeUpdate("create table signup(First_name varchar(20), Password varchar(20))");
System.out.println("Basic information table created");
ps.setString(1,name);
ps.setString(2,pass);
ps.execute();
System.out.println("Values inserted");
s.close();
c.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
}
public static void main(String args[])
{
login l=new login();
}
}
