java JDBC连接MySQL数据库调用存储过程进行查询
主程序代码
package Mysql;
import util.JDBCUtils;
import java.sql.*;
import java.util.Scanner;
public class SaveProcess {
public static void main(String[] args) {
Scanner sc = new Scanner(System.in);
System.out.println("请输入需要查询的名字,或姓名当中的一个字。");
String nm = sc.next();
search(nm);
}
public static void search(String name) {
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
conn = JDBCUtils.getConnection();
String sql ="CALL reader_namelist(?)";
pstmt = conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
pstmt.setString(1,name);
rs = pstmt.executeQuery();
if(rs.next()){