使用 CallableStatement 接口调用存储过程

CallableStatement 接口的引入

CallableStatement 主要是调用数据库中的存储过程，CallableStatement 也是 Statement 接口的子接口。在使用 CallableStatement 时可以接收存储过程的返回值。

使用 CallableStatement 接口调用存储过程

void registerOutParameter(int parameterIndex, int sqlType)

按顺序位置 parameterIndex 将 OUT 参数注册为 JDBC 类型 sqlType。
数据库

import java.sql.CallableStatement; import java.sql.Connection; import java.sql.Types;import com.cn.zj.JDBCUtil.DbUtil;public class demo {private static DbUtil dbUtil=new DbUtil();/*** 调用存储过程，通过id查询bookName* @param id* @return* @throws Exception*/private static String getBookNameById(int id)throws Exception{Connection con=dbUtil.getCon(); //获取数据库连接String sql="{CALL pro_getBookNameById(?,?)}";CallableStatement cstmt=con.prepareCall(sql);cstmt.setInt(1, id); //设置第一个参数cstmt.registerOutParameter(2, Types.VARCHAR); //设置返回类型cstmt.executeQuery();String bookName=cstmt.getString("bN"); //获取返回值dbUtil.close(cstmt, con);return bookName;}public static void main(String[] args)throws Exception {System.out.println("图书名称是："+getBookNameById(1));} }

========================================
工具类DbUtil.java

import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; /*** 通用方法* @author Administrator**/ public class DbUtil {//驱动名称private static String jdbcName="com.mysql.jdbc.Driver";//mysql数据库地址private static String dbUrl="jdbc:mysql://localhost:3306/db_book?useUnicode=true&characterEncoding=UTF-8";//用户名private static String dbUserName="root";//密码private static String dbPassword="root";//获取数据库连接的方法public Connection getCon() throws Exception{Class.forName(jdbcName); //加载驱动Connection con=DriverManager.getConnection(dbUrl, dbUserName, dbPassword);return con;}//关闭数据库连接public void close(Statement stmt,Connection con)throws Exception{if(stmt!=null){stmt.close();if(con!=null){con.close();}}} }

Book.java

import java.io.File;/*** 图书模型* @author Administrator**/ public class Book { private int id; private String bookName; private float price; private String author; private int bookTypeId; private File context; //使用流 private File pic; //图片 //构造方法 Source+fields public Book(String bookName, float price, String author, int bookTypeId) {super();this.bookName = bookName;this.price = price;this.author = author;this.bookTypeId = bookTypeId; }//更新数据要包括ID，重载构造方法 public Book(int id, String bookName, float price, String author, int bookTypeId) {super();this.id = id;this.bookName = bookName;this.price = price;this.author = author;this.bookTypeId = bookTypeId; }public Book(String bookName, float price, String author, int bookTypeId, File context) {super();this.bookName = bookName;this.price = price;this.author = author;this.bookTypeId = bookTypeId;this.context = context; }public Book(String bookName, float price, String author, int bookTypeId, File context, File pic) {super();this.bookName = bookName;this.price = price;this.author = author;this.bookTypeId = bookTypeId;this.context = context;this.pic = pic; }public int getId() {return id; }public void setId(int id) {this.id = id; } public String getBookName() {return bookName; } public void setBookName(String bookName) {this.bookName = bookName; } public float getPrice() {return price; } public void setPrice(float price) {this.price = price; } public String getAuthor() {return author; } public void setAuthor(String author) {this.author = author; } public int getBookTypeId() {return bookTypeId; } public void setBookTypeId(int bookTypeId) {this.bookTypeId = bookTypeId; }public File getContext() {return context; }public void setContext(File context) {this.context = context; }public File getPic() {return pic; }public void setPic(File pic) {this.pic = pic; }@Override public String toString() {return "Book [id=" + id + ", bookName=" + bookName + ", price=" + price + ", author=" + author + ", bookTypeId="+ bookTypeId + "]"; }}

总结

以上是生活随笔为你收集整理的使用 CallableStatement 接口调用存储过程的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。