Java PreparedStatement Operations Oracle database

Import java.sql.Connection;
Import Java.sql.ResultSet;
Import java.sql.SQLException;
Import java.sql.Statement;
Import java.sql.PreparedStatement;
public class lx02{

public static void Main (string[] args) throws SQLException, classnotfoundexception{
Load Driver
Class.forName ("Oracle.jdbc.driver.OracleDriver");
Java.sql.DriverManager.registerDriver (New Oracle.jdbc.driver.OracleDriver ());

Establish a connection
String url = "Jdbc:oracle:thin:@100.100.100.20:1521:dbsid2";
String user= "Scott";
String password= "Tiger";
Connection con=java.sql.drivermanager.getconnection (URL, user, password);

EXECUTE statement
/* String sql1= "SELECT * from User_tables";
Statement smt=con.createstatement ();
ResultSet rs1=smt.executequery (SQL1);
*/
PREPARESTATEMETN statement: Input
/* String sql2= "INSERT into a (Deptno,dname,loc) VALUES (?,?,?)";
PreparedStatement ps=con.preparestatement (SQL2);
Ps.setstring (1, "50");
Ps.setstring (2, "PMO");
Ps.setstring (3, "Beijing");
int rs2=ps.executeupdate ();
*/
Inquire
String sql= "Select Dname from a where to dname like?";
PreparedStatement ps=con.preparestatement (SQL);
Ps.setstring (1, "PMO");
ResultSet Rs=ps.executequery ();


Delete bytes
/* String sql= "Delete from a where deptno=50";
PreparedStatement ps=con.preparestatement (SQL);
Ps.executeupdate ();
*/

Show results
while (Rs.next ()) {
System.out.println (rs.getstring (1));
System.out.println (rs.getstring (1) + "" + rs.getstring (2) + "" + rs.getstring (3));
}

Release
Rs.close ();
Ps.close ();
Con.close ();

}

}