Tuesday, May 4, 2010

Program to implement Prepared Statement in JDBC

import java.sql.*;
import java.lang.*;
public class pst
{public static void main(String args[])
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String query="select *from employee where salary>20000";
Connection con=DriverManager.getConnection("jdbc:odbc:name","","");
PreparedStatement pst = con.prepareStatement(query);
ResultSet rs1 = pst.executeQuery();

while(rs1.next())
{
System.out.println(rs1.getString(1)+ "\t" +rs1.getString(2)+ "\t" +rs1.getString(3)+ "\t" +rs1.getString(4)+
"\t" +rs1.getString(5));
}
}
catch(Exception e)
{System.out.println("error " +e);
}
}
}

No comments:

Post a Comment