************************************************************************* * * * Original:blog.csdn.net/clark_xu Xu Changliang's Column************************************************************************
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 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);
//Run statement
/* string sql1= "select * from User_tables";
statement smt=con.createstatement ();
ResultSet rs1=smt.executequery (SQL1);
*/
//preparestatemetn statement: Enter
/* 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 ();
*/
//query
String sql= "Select Dname from a where 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 ();
*/
//display 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 ();
}
}
Copyright notice: This article Bo Master original articles, blogs, without consent may not be reproduced.
"JDBC" Java PreparedStatement operations Oracle database