这是存储过程
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();
}