java程序简单调用存储过程_JAVA_编程开发_程序员俱乐部

一个类似登陆的存储过程
mysql存储过程：
drop PROCEDURE if EXISTS login;
CREATE PROCEDURE login(IN username int,in password VARCHAR,out count INT)
begin
SELECT count(1) into  count from t_user where uname=username and upwd=password;
end;
java程序调用：
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;

public class Test  
{ 
public static void main(String args[]) throws Exception 
{ 
//加载驱动 
DriverManager.registerDriver(new com.mysql.jdbc.Driver()); 
//获得连接 
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/数据库名","用户名","密码"); 

//创建存储过程的对象 
CallableStatement c=conn.prepareCall("{call login(?,?)}"); 

//给存储过程的参数设置值 
c.setString(1,"张三");
c.setString(2, "123");
//注册存储过程的第三个参数
c.registerOutParameter(3,java.sql.Types.INTEGER);
c.executeQuery();
int count = Integer.parseInt(c.getString(3));
if(count>0){
System.out.println("登陆成功");
}
conn.close(); 
} 
}