Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- con = DriverManager.getConnection(URL, USER, PASS);
- int answer = JOptionPane.showOptionDialog(this, "Database tidak ditemukan, ingin membuat baru?", "Database not found", JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE, null, null, null);
- if (answer == JOptionPane.YES_OPTION) {
- st = con.createStatement();
- String sql = ("CREATE DATABASE afifdb;"
- + "CREATE TABLE barang ("
- + "id INT NOT NULL AUTO_INCREMENT,"
- + "nama VARCHAR(50) NOT NULL,"
- + "jumlah INT(11),"
- + "tanggal DATE,"
- + "kondisi VARCHAR(20),"
- + "keterangan VARCHAR(100),"
- + "PRIMARY KEY (id)"
- + ");");
- st.executeUpdate(sql);
- }
- } catch (HeadlessException | SQLException e3) {
- JOptionPane.showMessageDialog(this, "Gagal. ERROR : " + e3);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement