jdbc program not working
I am trying to make a table in ms access through java and im able to compile this program also but i am not able to get its output.........................
import java.sql.*;
class databconnection1
{
public static void main(String args[])
{
try
{
String n;
int sal;
String url="Jdbc:odbc:SS";
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(url);
Statement stmt=con.createStatement();
String sel="CREATE TABLE Teach (Name Text(20),Salary Number)";
stmt.executeUpdate(sel);
stmt.executeUpdate("INSERT INTO Teach VALUES ('namrata',900)");
ResultSet rs=stmt.executeQuery("SELECT Name,Salary FROM Teach WHERE Salary>100");
//System.out.println("NameRollMarks");
while(rs.next())
{
n=rs.getString("Name");
sal=rs.getInt("Salary");
System.out.println(n+""+sal);
System.out.println("Name:"+n);
System.out.println("Salary:"+sal);
}
}
catch(Exception e)
{
}
}
}
