java 如何调用存储过程_Java中调用存储过程

import java.sql.*;

/**

* Java中调用存储过程

*

* @author JRunner

*

* 2009-10-31

*

* Email:jrunner@sina.com

*/

public class TestProc {

/**

* @param 入口

* @throws ClassNotFoundException

* @throws SQLException

*/

public static void main(String[] args) throws ClassNotFoundException,

SQLException {

String msg = "";

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

Connection conn = DriverManager.getConnection(

"jdbc:sqlserver://localhost:1433;DatabaseName=JRun", "sa", "");

CallableStatement cs = conn

.prepareCall("{call UpdateUserById(?,?,?,?,?,?)}");

cs.registerOutParameter(6, Types.VARCHAR);

cs.setString(1, "1");

cs.setString(2, "JRunner");

cs.setString(3, "JRunner");

cs.setString(4, "3");

cs.setString(5, "3");

cs.execute();

msg = cs.getString(6);

cs.close();

conn.close();

System.out.println(msg);

}

}

//---------------------------------SQL------------------------------------------------

/*

create database JRun

go

use JRun

go

create table t_user

(

u_id int identity(1,1) not null,

u_name varchar(20) not null,

u_password varchar(20) not null,

u_sex int not null,

u_age int not null

)

go

create proc UpdateUserById

@u_id int,

@u_name varchar(20),

@u_password varchar(20),

@u_sex int,

@u_age int,

@msg varchar(50) output

as

update t_user set u_name=@u_name, u_password=@u_password, u_sex=@u_sex, u_age=@u_age

where u_id=@u_id

if(@@rowcount > 0)

set @msg = '成功的修改了一条数据'

else

set @msg = '修改失败'

go

insert into t_user(u_name,u_password,u_sex,u_age) values('JRunner','JRunner',1,1)

declare @msg varchar(50)

exec UpdateUserById 1,'Java','Java', 2, 2, @msg output

select @msg

select * from t_user

*/