java与存储过程

summernight

这是存储过程
sql:
create procedure checkpass1(
@UserName varchar(20),
@PassWord varchar(20),
@return1 varchar(20) output)
as
if exists(select  * from  userTabel where  [email=UserName=@UserName]UserName=@UserName[/email] and [email=PassWord=@PassWord]PassWord=@PassWord[/email])
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();
}