Monday, August 24, 2009

DB

=====DB1========
import java.io.*;
import java.sql.*;
import java.net.*;
public class DB1
{
static Connection con;
static Statement st1,st2;
static ResultSet rs1;
//static ResultSetMetaData rsmd;
static PreparedStatement pstmt;
public static void main(String args[])
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:irk");
pstmt = con.prepareStatement("update emp set name = ? where eno = ?");
pstmt.setString(1,"krishna");
pstmt.setString(2,"e1");
pstmt.executeUpdate();

st1=con.createStatement();
System.out.println("Done");
rs1=st1.executeQuery("select * from emp");
while(rs1.next())
{
System.out.println(" "+rs1.getString(1)+" "+rs1.getString(2));
}
st2=con.createStatement();

}
catch(Exception e)
{
e.printStackTrace();
}

}
}

=========DB--------
import java.io.*;
import java.sql.*;
import java.net.*;
public class DB
{
static Connection con;
static Statement st1,st2;
static ResultSet rs1;
public static void main(String args[])
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:tri");
st1=con.createStatement();
System.out.println("Done");
rs1=st1.executeQuery("select * from emp");
while(rs1.next())
{
System.out.println(" "+rs1.getString(1)+" "+rs1.getString(2));
}
}
catch(Exception e)
{
e.printStackTrace();
}

}
}

No comments:

Post a Comment