The Following code will help u..............
PHP Code:
import java.sql.*;
import javax.naming.*;
import javax.sql.DataSource;
public class Main
{
/** Creates a new instance of Main */
public Main()
{
}
/**
* @param args the command line arguments
*/
public static void main(String[] args)
{
Connection con = null;
Statement st = null;
PreparedStatement pt = null;
CallableStatement ct = null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:orajava", "scott","tiger");
//Statement
st = con.createStatement();
st.executeUpdate("insert into sample values(1,'abcd')");
//CallableStatement(pname->procedure name , parameter)
// ct = con.prepareCall("{call pname(1)}");
// ct.execute();
//
//PreparedStatement
pt = con.prepareStatement("select * from sample");
ResultSet rs = pt.executeQuery();
System.out.println("Number\tName");
System.out.println("------------");
while(rs.next())
{
System.out.print(rs.getInt("num"));
System.out.print("\t"+rs.getString("nam")+"\n");
}
System.out.println("------------");
}
catch(SQLException e)
{
System.out.println(e.getMessage());
}
catch(Exception e)
{
System.out.println(e.getMessage());
}
}
}