import java.sql.*;
/*** Java中调用存储过程* * @author JRunner* * 2009-10-31* * Email:JRunner@126*/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 JRungo
use JRungo
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) outputasupdate t_user set u_name=@u_name, u_password=@u_password, u_sex=@u_sex, u_age=@u_age where u_id=@u_idif(@@rowcount 0)set @msg = '成功的修改了一条数据'elseset @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 outputselect @msg
select * from t_user*/
