java调用存储过程

package com.shop.test;

import java.sql.DriverManager;
import java.sql.SQLException;

import com.mysql.jdbc.CallableStatement;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.ResultSet;

public class TestProcedure {

private Connection con;
public static void main(String[] args) {
TestProcedure tp = new TestProcedure();
CallableStatement cs = null;
ResultSet rs;
try {
cs = (CallableStatement)tp.getCon().prepareCall("{call pricepro(?)}");
cs.setInt(1, 1);
rs = (ResultSet)cs.executeQuery();
while(rs.next()){
System.out.println(rs.getInt(1));
System.out.println(rs.getInt(2));
}
tp.getCon().close();
} catch (SQLException e) {
e.printStackTrace();
}
}

public Connection getCon(){
try {  
            Class.forName("com.mysql.jdbc.Driver");  
            con = (Connection)DriverManager.getConnection("jdbc:mysql://localhost/shop?user=root&password=123456");
      }catch (ClassNotFoundException e) {  
      e.printStackTrace();  
      } catch (SQLException e) {  
            e.printStackTrace(); 
            }
return con;
}



}