一、创建数据库存储过程如下:
一、创建存储过程
在命令行下输入
create procedure insert_user(in un varchar(20), in pw varchar(20))
insert into stutbl(name,passwd)values(un, pw);
二、调用存储过程
call insert_user('151', '5456')
二、Java代码如下
package com.zhaofei.jdbc.study;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.SQLException;
public class CallableStatementTest {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
CallableStatementTest ss = new CallableStatementTest();
ss.testCallableStatement();
}
public void testCallableStatement()
{
DButil util = new DButil();
Connection conn = util.openConnection();
String sql = "{call insert_user(?,?)}";
try {
//?是占位符,使用set方法设置相应的值
CallableStatement cstmt = conn.prepareCall(sql);
cstmt.setString(1, "my");
cstmt.setString(2, "zhangs");
cstmt.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}