- public class GenerateSampleData {
- public void select() {
- String sql="";
- Connection con = null;
- CallableStatement callAble=null;
- try{
- Class.forName("com.mysql.jdbc.Driver");
- String url="jdbc:mysql://localhost:3306/test";
- con = DriverManager.getConnection(url, "abc", "abc");
- sql="{call test2(?)}";
- callAble=con.prepareCall(sql);
- callAble.registerOutParameter(1, Types.VARCHAR);
- callAble.execute();
- System.out.println(callAble.getString(1));
- }catch (Exception e) {
- // TODO: handle exception
- e.printStackTrace();
- }finally{
- try {
- callAble.close();
- con.close();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
- }
来源: http://www.phpxs.com/code/1002585/