package Jdbcday02;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Types;
public class TestCallableStmt {
static Connection conn=null;
static {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
String url=null;
url="jdbc:oracle:thin:@10.12.36.201:1521:xxxxxx";
conn=DriverManager.getConnection(url,"scott","tiger");
} catch (Exception e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
callSpWithoutOutParam1();
}
public static void callSpWithoutOutParam(){
String sql="{call insert_sun(?,?,?,?)}";
try {
CallableStatement callStmt=
conn.prepareCall(sql);
callStmt.setInt(1, 28);
callStmt.setString(2,"sunzongbao");
callStmt.setInt(3, 22);
callStmt.setString(4, "M");
System.out.println(callStmt.execute());//callStmt.execute()返回false的时候是对表数据修改,返回结果集合的时候
//返回true,,,和statement的execute的方法是相同的
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void callSpWithoutOutParam1(){
String sql="{call insert_sun1(?,?)}";
try {
CallableStatement callStmt=conn.prepareCall(sql);
callStmt.setInt(1, 20);
callStmt.registerOutParameter(2, Types.INTEGER);
System.out.println(callStmt.execute());//callStmt.execute()返回false的时候是对表数据修改,返回结果集合的时候
//返回true,,,和statement的execute的方法是相同的
int n=callStmt.getInt(2);
System.out.println("部门20有"+n+"个员工");
} catch (SQLException e) {
e.printStackTrace();
}
}
}
jdbc存储过程
最新推荐文章于 2022-10-09 14:56:18 发布