69 lines
2.3 KiB
Java
69 lines
2.3 KiB
Java
|
import java.sql.*;
|
|||
|
|
|
|||
|
|
public class Question11 {
|
|||
|
|
|
|||
|
|
// MySQL 8.0 以上版本 - JDBC 驱动名及数据库 URL
|
|||
|
|
static final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver";
|
|||
|
|
static final String DB_URL = "jdbc:mysql://公网IP:3306/user000db?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC";
|
|||
|
|
|
|||
|
|
|
|||
|
|
// 数据库的用户名与密码，需要根据自己的设置
|
|||
|
|
static final String USER = "DB_USER000";
|
|||
|
|
static final String PASS = "DB_USER000@123";
|
|||
|
|
|
|||
|
|
public static void main(String[] args) {
|
|||
|
|
Connection conn = null;
|
|||
|
|
Statement stmt = null;
|
|||
|
|
try{
|
|||
|
|
// 注册 JDBC 驱动
|
|||
|
|
Class.forName(JDBC_DRIVER);
|
|||
|
|
|
|||
|
|
// 打开链接
|
|||
|
|
System.out.println("连接数据库...");
|
|||
|
|
conn = DriverManager.getConnection(DB_URL,USER,PASS);
|
|||
|
|
|
|||
|
|
// 执行查询
|
|||
|
|
System.out.println("实例化Statement对象...");
|
|||
|
|
stmt = conn.createStatement();
|
|||
|
|
|
|||
|
|
Boolean rs = stmt.execute("drop procedure if exists demoSp;");
|
|||
|
|
rs = stmt.execute("create procedure demoSp(inout test int) begin set test = test + 1; end");
|
|||
|
|
|
|||
|
|
CallableStatement cs = conn.prepareCall("{call demoSp(?)}");
|
|||
|
|
System.out.println("调用存储过程，作用为将输入的变量+1：");
|
|||
|
|
int res = 0;
|
|||
|
|
System.out.println("输入变量：");
|
|||
|
|
System.out.println(res);
|
|||
|
|
cs.setInt(1, res);
|
|||
|
|
cs.registerOutParameter(1, Types.INTEGER);
|
|||
|
|
cs.execute();
|
|||
|
|
res = cs.getInt(1);
|
|||
|
|
System.out.println("调用结果：");
|
|||
|
|
System.out.println(res);
|
|||
|
|
|
|||
|
|
// 完成后关闭
|
|||
|
|
cs.close();
|
|||
|
|
stmt.close();
|
|||
|
|
conn.close();
|
|||
|
|
}catch(SQLException se){
|
|||
|
|
// 处理 JDBC 错误
|
|||
|
|
se.printStackTrace();
|
|||
|
|
}catch(Exception e){
|
|||
|
|
// 处理 Class.forName 错误
|
|||
|
|
e.printStackTrace();
|
|||
|
|
}finally{
|
|||
|
|
// 关闭资源
|
|||
|
|
try{
|
|||
|
|
if(stmt!=null) stmt.close();
|
|||
|
|
}catch(SQLException se2){
|
|||
|
|
}// 什么都不做
|
|||
|
|
try{
|
|||
|
|
if(conn!=null) conn.close();
|
|||
|
|
}catch(SQLException se){
|
|||
|
|
se.printStackTrace();
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
System.out.println("Goodbye!");
|
|||
|
|
}
|
|||
|
|
}
|