Java中调用存储过程

最新推荐文章于 2021-03-02 03:58:11 发布

yuxiaoping225170

最新推荐文章于 2021-03-02 03:58:11 发布

阅读量313

点赞数

文章标签： java 存储 sqlserver null user string

本文链接：https://blog.csdn.net/yuxiaoping225170/article/details/5569147

版权

Java 中调用存储过程

import java.sql.*;

/**
* Java 中调用存储过程
*
*/
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