简单java连接oracle，Statement，PreparedStatement，CallableStatement操作

来源：互联网发布：游戏耳机知乎编辑：程序博客网时间：2024/05/07 10:26

java

package test;import java.sql.CallableStatement;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.sql.Types;public class c {public static void main(String[] args) throws Exception{    Class.forName("oracle.jdbc.driver.OracleDriver");    Connection c=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "llccdd", "llccdd");    /** Statement **/    /*String sql="select t.tid,t.tname from tt t";    String addSql="insert into tt(tid,tname) values (5,'衡水')";    String delSql="delete from tt where tid=1";    String updSql="update tt set tname='赵六' where tid=4";Statement s=c.createStatement();ResultSet r=s.executeQuery(sql);while(r.next()){int a=r.getInt(1);String b=r.getString(2);System.out.println(a+"="+b);}        int i=s.executeUpdate(addSql);//delSql,updSql    System.out.println(i);*/        /** PreparedStatement **/   /* String sql="select t.tid,t.tname from tt t where t.tid=?";    String addSql="insert into tt(tid,tname) values (?,?)";    String delSql="delete from tt where tid=?";    String updSql="update tt set tname=? where tid=?";    PreparedStatement p1=c.prepareStatement(sql);p1.setObject(1, 2);ResultSet r=p1.executeQuery();while(r.next()){int a=r.getInt(1);String b=r.getString(2);System.out.println(a+"="+b);}PreparedStatement p2=c.prepareStatement(addSql);//delSql,updSqlp2.setObject(1, 5);p2.setObject(2, "衡水");int i=p2.executeUpdate();System.out.println(i);*/    /** CallableStatement **/CallableStatement  ca=c.prepareCall("{call pro_test(?,?)}");ca.setObject(1, 2);ca.registerOutParameter(2, Types.VARCHAR);ca.execute();String s=ca.getString(2);System.out.println(s);}}

procedure

create or replace procedure pro_test(nn in number,mm out varchar2) aspp varchar2(50);begin  select t.tname into pp from tt t where t.tid=nn;  mm:=pp;  end pro_test;

tt表

0 0