attila66

JDBC Statement Call Function from SELECT

May 4th, 2020
156
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.99 KB | None | 0 0
  1.         Statement stmt = null;
  2.         try {
  3.             String URL = "jdbc:mysql://localhost:3306/test";
  4.             Connection conn = DriverManager.getConnection(URL, "myusername", "mypassw");
  5.             stmt = conn.createStatement();
  6.             String query = "SELECT name, salary, SalaryLevel(salary) AS level FROM mytable;";
  7.             ResultSet res = stmt.executeQuery(query);
  8.             while (res.next()) {
  9.                 String name = res.getString("name");
  10.                 int salary = res.getInt("salary");
  11.                 String level = res.getString("level");
  12.                 System.out.println(name + " " + salary+" "+level);
  13.             }
  14.         } catch (SQLException ex) {
  15.             System.out.println(ex);
  16.         } finally {
  17.             if (stmt != null) {
  18.                 try {
  19.                     stmt.close();
  20.                 } catch (SQLException ex) {
  21.                 }
  22.             }
  23.         }
  24.  
  25. // MySQL Stored Function Example: https://pastebin.com/bb2UPNsY
Add Comment
Please, Sign In to add comment