not able to put values
i m using ms access as back end language .
i hav made this program its been compiled and the table is been made but i ma not able to put values through java in it....
import java.sql.*;
class databconnection
{
public static void main(String args[])
{
try
{
String n;
int sal;
String url="Jdbc:odbc:SS";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con1=DriverManager.getConnection(url);
Statement smt=con1.createStatement();
String sel="CREATE TABLE Teacher(Name Text(20),Salary Number)";
smt.executeUpdate(sel);
smt.executeUpdate("insert into Teacher values 'Namrata',9000");
ResultSet rs=smt.executeQuery("SELECT Name,Salary FROM Teacher WHERE Salary>5000");
while(rs.next())
{
n=rs.getString("Name");
sal=rs.getInt("Salary");
System.out.println("Name:"+n);
System.out.println("Salary:"+sal);
}
}
catch(Exception e)
{
}
}
}
