Advertisement
BlueSight

error

Jan 20th, 2020
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.77 KB | None | 0 0
  1. try {
  2.     con = DriverManager.getConnection(URL, USER, PASS);
  3.     int answer = JOptionPane.showOptionDialog(this, "Database tidak ditemukan, ingin membuat baru?", "Database not found", JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE, null, null, null);
  4.     if (answer == JOptionPane.YES_OPTION) {
  5.         st = con.createStatement();
  6.         String sql = ("CREATE DATABASE afifdb;"
  7.                     + "CREATE TABLE barang ("
  8.                     + "id INT NOT NULL AUTO_INCREMENT,"
  9.                     + "nama VARCHAR(50) NOT NULL,"
  10.                     + "jumlah INT(11),"
  11.                     + "tanggal DATE,"
  12.                     + "kondisi VARCHAR(20),"
  13.                     + "keterangan VARCHAR(100),"
  14.                     + "PRIMARY KEY (id)"
  15.                     + ");");
  16.         st.executeUpdate(sql);
  17.     }
  18. } catch (HeadlessException | SQLException e3) {
  19.     JOptionPane.showMessageDialog(this, "Gagal. ERROR : " + e3);
  20. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement