java与存储过程

这是存储过程

sql:

create procedure checkpass1(

@UserName varchar(20),

@PassWord varchar(20),

@return1 varchar(20) output)

as

if exists(select  * from  userTabel where  UserName=@UserName and PassWord=@PassWord)

select  @return1='pass'

else

select  @return1='error'

GO

java:

Connection conn = null;

Statement pstm = null;

try {

    conn = ConnectionManager.getConnection(Globals.                       DATASOURCE_GZYCW_ADMIN);

    conn.setAutoCommit(false);

    pstm = conn.createStatement();

            

//Call a procedure with one OUT parameter

    CallableStatement sqlStmt=conn.prepareCall("{call personInfoIntegrity(?)}");

//Register the type of the OUT parameter

   sqlStmt.registerOutParameter(1, java.sql.Types.VARCHAR);

//Execute the stored procedure and retrieve the OUT value

  sqlStmt.execute();

  String outParam = sqlStmt.getString(1); // OUT parameter

  System.out.println("Return Of The Result="+outParam);

}catch(Exception ex){

    ex.printStackTrace();

}