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

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,updSql
		p2.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) as
pp varchar2(50);
begin
  select t.tname into pp from tt t where t.tid=nn;
  mm:=pp;
  end pro_test;

tt表