java sql server 存储过程_Java调用SQL Server存储过程

1.建立SQL Server存储过程

CREATE PROCEDURE prepareStatement

@USR_CODE varchar(128)

AS

BEGIN

select * from [user] u where u.[USR_CODE]=@USR_CODEEND

2.在SQL Server中测试存储过程

EXEC prepareStatement 'test'

3.Java代码

public List getRoleByUserCode(String userCode){

Connection conn = null;

PreparedStatement ps = null;

ResultSet rs = null;

List list = new ArrayList();

try {

conn = dataSource.getConnection();

//ps = conn.prepareStatement("select * from [user] u where u.[USR_CODE]=?");

ps = conn.prepareStatement("{call dbo.prepareStatement(?)}");

ps.setString(1, userCode);

rs = ps.executeQuery();

以上

但愿诸兄看明白了..

参考文章：

1.存储过程入门与提高

2.SqlServer中存储过程中将Exec的执行结果赋值给变量输出

3.Java调用SQL Server的存储过程详解