首页 > 代码库 > java PreparedStatement操作oracle数据库

java PreparedStatement操作oracle数据库


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{
  // 加载驱动
  Class.forName("oracle.jdbc.driver.OracleDriver");
  java.sql.DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
  
  //建立连接
  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);
  
  //执行语句
/*  String sql1="select * from user_tables";
  Statement smt=con.createStatement();
        ResultSet rs1=smt.executeQuery(sql1);
*/     
     //preparestatemetn语句: 输入
 /*    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();
*/      
        //查询
  String sql="select dname from a where dname like ?";
  PreparedStatement ps=con.prepareStatement(sql);
     ps.setString(1, "pmo");
     ResultSet rs=ps.executeQuery();
 
  
  //删除字节
/*  String sql="delete from a where deptno=50";
  PreparedStatement ps=con.prepareStatement(sql);
  ps.executeUpdate();
*/
  
  //显示结果
        while(rs.next()){
         System.out.println(rs.getString(1)); 
//      System.out.println(rs.getString(1) + "  " + rs.getString(2)+"   "+ rs.getString(3));
    }


       //释放
       rs.close();
       ps.close();
       con.close();
  
 }

}