Monday, 17 March 2014

jdbc java program to access database using MSaccess

import java.sql.*;
import java.io.*;
class JdbcDemo1
{
Connection con;
Statement stmt;
ResultSet rs;
JdbcDemo1()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection( "Jdbc:Odbc:d1", "","");
stmt = con.createStatement();
String sql = "INSERT INTO mm " + "VALUES (97,'muthuma')";
 stmt.executeUpdate(sql);
 sql = "INSERT INTO mm " +  "VALUES (998,'leena')";
 stmt.executeUpdate(sql);
sql="DELETE FROM mm " + "WHERE ID=97";
 stmt.executeUpdate(sql);
sql="UPDATE  mm " + "SET  Nam= 'prem'  WHERE ID in (998)";
 stmt.executeUpdate(sql);
rs = stmt.executeQuery("SELECT * FROM mm");
while (rs.next()) {
int ID = rs.getInt("ID");
String Nam=rs.getString("Nam");
System.out.println("ID:"+ID+"\tNam:"+Nam);
}
}
catch(SQLException e)
{
System.out.println(e);
}
catch(ClassNotFoundException e)
{
System.out.println(e);

}
}
}
class JdbcDemo
{
public static void main(String args[])
{
new JdbcDemo1();
}
}

No comments:

Post a Comment