storeprocedure.java

uliu liuoulo p hp pi ij jp

package conn;
import java.sql.*;
import javax.sql.*;
public class storeProcedure
{
	ResultSet rs=null;
	Connection connection=null;
	CallableStatement cs=null;
	Statement stmt=null;
	
	public storeProcedure() 
	{
		
		
		//cs.setString(1,1);
	}//,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY
	public void exeProcedure() 
	{
		
		//callstat = connnection.prepareCall("{call chk_zero(?,?)}",ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
		try{
			 connection=ConnectPool.getConnection1();
			 cs=connection.prepareCall("{call countRow(?)}");
			 //cs.setString(1,2);//设置参数值
			 cs.registerOutParameter(1,java.sql.Types.INTEGER);//设置参数类型
			cs.execute();
			int paraValue = cs.getInt(2);//得到out参数值

			 
			// stmt = connection.createStatement();
			 //String proc="exec countR";
			// rs = stmt.executeQuery(proc);

			// rs =cs.executeQuery();
			//rs.next();
			// System.out.print(rs.getInt(1));
			
		 }
		 catch(SQLException e){
                System.out.println(e.getMessage());
          }

//recordSet=callstat.executeQuery();

		
		//rs=cs.executeQuery();
	}
	public static void main(String args[])
	{
		storeProcedure app=new storeProcedure();
		app.exeProcedure();
	}

}