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();
}
}
import java.io.*;
class JdbcDemo1
{
Connection con;
Statement stmt;
ResultSet rs;
JdbcDemo1()
{
try
{
Class.forName("sun.jdbc.odbc.
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+"\
}
}
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