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();              }                        }        }