在java中调用mysql存储过程

来源：互联网发布：淘宝店铺标题优化编辑：程序博客网时间：2024/05/16 10:19

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

        }

    }