java调用mysql的存储过程脚本解决方法

drop procedure if exists sp_update_table_field;delimiter //create procedure sp_update_table_field()beginif not exists(select 1 from information_schema.columns where table_name='WB_Sys_Role' and column_name='Is_Export') then      ALTER TABLE WB_Sys_Role ADD Is_Export TINYINT NOT  NULL default '0';  end if;end //

package com.css.wbo.server.tool.initial;import java.sql.CallableStatement;  import java.sql.Connection;  import java.sql.DriverManager;  import java.sql.SQLException;  import java.sql.Types;  public class test {      String url = "jdbc:mysql://127.0.0.1:3306/userInfo";       String userName = "root";      String password = "root";      public Connection getConnection() {          Connection con=null;          try{              DriverManager.registerDriver(new com.mysql.jdbc.Driver());              con = DriverManager.getConnection(url, this.userName, this.password);          }catch(SQLException sw){            }          return con;      }      public void testProc(){          Connection conn = getConnection();          CallableStatement stmt = null;          try{              stmt = conn.prepareCall("{call sp_update_table_field}");            stmt.execute();          }catch(Exception e){              System.out.println("hahad = "+e.toString());          }finally{              try {                  stmt.close();                  conn.close();              }catch (Exception ex) {                  System.out.println("ex : "+ ex.getMessage());              }          }      }      public static void main(String[] args) {          new test().testProc();      }  }  

 java.sql.Statement ps = conn.createStatement(); String sql = sqlSB.toString(); ToolLog.getLog().debug(sql);  ps.execute(sql);