jdbc调用存储过程

最新推荐文章于 2021-03-17 04:09:08 发布

落叶翩翩

最新推荐文章于 2021-03-17 04:09:08 发布

阅读量612

点赞数

本文链接：https://blog.csdn.net/bolg_hero/article/details/8292367

版权

package cn.zkjc.sp.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Test {


   static final String DRIVER="com.mysql.jdbc.Driver";
   static final String URL="jdbc:mysql://localhost:3306/test";
   static final String USERNAME="root";
   static final String PWD="root";
   public static Connection getConnection() throws ClassNotFoundException, SQLException{
       Class.forName(DRIVER);
       return DriverManager.getConnection(URL, USERNAME, PWD);
   }
   /**
   * @param args
   * @throws SQLException
   * @throws ClassNotFoundException
   */
   public static void main(String[] args) throws ClassNotFoundException, SQLException {
       Connection con = getConnection();
       Statement st = con.createStatement();
       ResultSet rs = st.executeQuery("{call getUserCount()}");
//       ResultSet rs = st.executeQuery("{call getAllUser()}");
       while(rs.next()){
           System.out.println(rs.getInt("count(*)"));
       }

   }

}