jdbc调用无参数输出的存储过程

最新推荐文章于 2023-06-27 11:48:34 发布

confirmAname

最新推荐文章于 2023-06-27 11:48:34 发布

阅读量1k

点赞数

分类专栏： JDBC 文章标签： CallableStatement

本文链接：https://blog.csdn.net/confirmAname/article/details/9962365

版权

JDBC 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

CallableStmtDemo.java :

public class CallableStmtDemo {

	public static void main(String[] args) {
		callSpWithoutOutParam();
	}
	
	public static void callSpWithoutOutParam(){
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			Connection conn=DriverManager.
					getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott","tiger");
			CallableStatement callStmt=conn.prepareCall("{call insert_stu(?,?,?,?)}");
			callStmt.setInt(1,2);
			callStmt.setString(2,"tom");
			callStmt.setInt(3,20);
			callStmt.setString(4,"M");
			callStmt.execute();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
	}
}