在java中调用mysql存储过程

最新推荐文章于 2021-12-04 10:32:44 发布

Intboy

最新推荐文章于 2021-12-04 10:32:44 发布

阅读量911

点赞数 1

文章标签： mysql java 存储 exception string sql

在java中调用mysql存储过程

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

        }

    }