Advertisement
Guest User

Akses/Modif Database SQL via Java

a guest
Dec 14th, 2016
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 2.09 KB | None | 0 0
  1. package tesdoang;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.ResultSet;
  6. import java.sql.SQLException;
  7. import java.sql.Statement;
  8. import java.util.Arrays;
  9.  
  10. public class NewClass {
  11.    
  12.     private static final String DB_DRIVER = "com.mysql.jdbc.Driver";
  13.     private static final String DB_CONNECTION = "jdbc:mysql://localhost:3306/mhs";
  14.     private static final String DB_USER = "root";
  15.     private static final String DB_PASSWORD = "";
  16.     static Connection con;
  17.  
  18.     public static Connection getDatabaseConnection() {
  19.         Connection con = null;
  20.  
  21.         try {
  22.             Class.forName(DB_DRIVER);
  23.         } catch (ClassNotFoundException e) {
  24.             System.out.println(e.getMessage());
  25.         }
  26.  
  27.         try {
  28.             con = DriverManager.getConnection(DB_CONNECTION, DB_USER, DB_PASSWORD);
  29.             return con;
  30.         } catch (SQLException e) {
  31.             System.out.println(e.getMessage());
  32.         }
  33.         return con;
  34.     }
  35.    
  36.     public static void main (String[] args) throws ClassNotFoundException, SQLException {
  37.             Connection con = null;
  38.         Statement stmt = null;
  39.        
  40.         try {
  41.             // dapatkan database connection
  42.             con = getDatabaseConnection();
  43.  
  44.             // membuat object connection
  45.             stmt = con.createStatement();
  46.             // eksekusi insert SQL stetement
  47.  
  48.             String queryTemp = "Select * from menu;";
  49.             ResultSet r1 = stmt.executeQuery(queryTemp);
  50.             String[] temp = new String[3];
  51.             while (r1.next()) {
  52.                 temp[0] = r1.getString("id");
  53.                 temp[1] = r1.getString("nama");
  54.                 temp[2] = r1.getString("harga");
  55.                 System.out.println(Arrays.toString(temp));
  56.             }
  57.            
  58.         } catch (SQLException e) {
  59.             System.out.println(e.getMessage());
  60.         } finally {
  61.             if (stmt != null) {
  62.                 stmt.close();
  63.             }
  64.             if (con != null) {
  65.                 con.close();
  66.             }
  67.         }
  68.     }
  69. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement