CallableStatement(存储过程)
jdbc执行SQL语句,可以通过Statement,PreparedStatement,CallableStatement
CallableStatement负责调用存储过程
了解一下过程SQL语句
结构化查询语言(Structured Query Language)简称SQL
PL/SQL是一种程序语言,叫做过程化SQL语言(Procedural Language/SQL)。
PL/SQL是Oracle数据库对SQL语句的扩展。
try {
Class.forName("oracle.jdbc.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "system", "sa");
//不带有返回值
CallableStatement cs = con.prepareCall("{call addUser(?, ?)}");
cs.setString(1, UUID.randomUUID().toString().replace("-", ""));
cs.setString(2, "yyx");
cs.execute();
//带有返回值
CallableStatement cs = con.prepareCall("{call uLogin(?,?,?)}");
cs.setString(1, "ceee92d3bdbd48ff9a682971025c8020");
cs.setString(2, getMD5String("123456"));
cs.registerOutParameter(3, Types.INTEGER);
cs.execute();
int x = cs.getInt(3);
System.out.println(x);
} catch (Exception e) {
e.printStackTrace();
}
}