Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void test(String pCity) {
- String connURL = "jdbc:mysql://localhost:3306/test";
- String callQuery = "{CALL MyProcedure(?)}";
- try (Connection conn = DriverManager.getConnection(connURL,"***", "***");
- CallableStatement cstmt = conn.prepareCall(callQuery))
- {
- cstmt.setString(1,pCity);
- cstmt.execute();
- try(ResultSet rs = cstmt.getResultSet()) {
- while (rs.next()) {
- System.out.println(rs.getInt("id")+" "
- +rs.getString("name")+" "
- +rs.getString("city"));
- }
- }
- } catch (SQLException ex) {
- System.out.println(ex);
- }
- }
- // MySQL Stored Procedure:
- DELIMITER $$
- CREATE PROCEDURE MyProcedure(IN pCity CHAR(15))
- BEGIN
- SELECT * FROM person WHERE city=pCity;
- END$$
- DELIMITER ;
Add Comment
Please, Sign In to add comment