callpro.java~2~

梅花雪树的经典制作

package com.test;
import java.sql.*;
class CallStmt{
        public static void main(String[] args){
                Connection con = null;
                CallableStatement cst = null;
                try{
                        Class.forName("oracle.jdbc.driver.OracleDriver");
                        String url = "jdbc:oracle:thin:@localhost:1521:lanhai";
                        con = DriverManager.getConnection(url,"wygb","wygb");
                        cst = con.prepareCall("{call mytest(?,?,?)}");
                        cst.setInt(1,56);
                        cst.setString(2,"hahatest");
                        cst.setInt(3,"hahaha");
                        cst.execute();
                        cst.close();
                }catch(Exception e){
                        System.err.println(e);
                }finally{
                        try{
                                if(con != null){
                                        con.close();
                                }
                        }catch(Exception e){
                        e.printStackTrace();
                        }
                }
        }
}