API tools faq
paste
Advertisement
Guest User

aplikasitoko

a guest
Feb 1st, 2017
185
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.74 KB | None | 0 0
raw download clone embed print report
  1. package aplikasitoko;
  2.  
  3. import javax.swing.*;
  4. import java.awt.*;
  5. import java.awt.event.*;
  6. import javax.swing.table.DefaultTableModel;
  7. import javax.swing.table.TableColumn;
  8. import java.sql.*;
  9.  
  10. public class AplikasiToko extends JFrame{
  11. /*Untuk koneksi ke MySQL*/
  12. final static String StringDriver="com.mysql.jdbc.Driver";
  13. final static String
  14.  
  15. StringConnection="jdbc:mysql://localhost:3306/dbtokoabc?user=root&password=";
  16.  
  17. private JDesktopPane frmMDI;
  18. private JInternalFrame frmBarang;
  19. private JInternalFrame frmCustomer;
  20. private JPanel pnlBarang;
  21. private JPanel pnlCustomer;
  22. private JPanel pnlUserAccount;
  23.  
  24. private JMenuBar MenuBar = new JMenuBar();
  25.  
  26. private JMenu MenuMaster = new JMenu("Master Data");
  27. private JMenuItem MenuBarang = new JMenuItem("Barang"),
  28. MenuCustomer = new JMenuItem("Customer");
  29.  
  30. private JMenu MenuTransaksi = new JMenu("Transaksi");
  31. private JMenuItem MenuPenjualan = new JMenuItem("Penjualan"),
  32. MenuPembelian = new JMenuItem("Pembelian");
  33.  
  34. private JMenuItem MenuExit = new JMenuItem("Exit");
  35.  
  36. /*Komponen untuk Form Barang*/
  37. private static JLabel LblKodeBarang = new JLabel("Kode Barang");
  38. private static JTextField TxtKodeBarang = new JTextField();
  39. private static JLabel LblNamaBarang = new JLabel("Nama Barang");
  40. private static JTextField TxtNamaBarang = new JTextField();
  41. private static JLabel LblSatuanBarang = new JLabel("Satuan");
  42. private static JTextField TxtSatuanBarang = new JTextField();
  43. private static JLabel LblHargaBarang = new JLabel("Harga Barang");
  44. private static JTextField TxtHargaBarang = new JTextField();
  45. private static JLabel LblStockBarang = new JLabel("Stock Barang");
  46. private static JTextField TxtStockBarang = new JTextField();
  47.  
  48. private static JButton TblBarangDelete = new JButton("Delete");
  49. private static JButton TblBarangSave = new JButton("Save");
  50. private static JButton TblBarangCancel = new JButton("Cancel");
  51.  
  52. /*Komponen untuk Form Customer*/
  53. private static JLabel LblKodeCustomer = new JLabel("Kode Customer");
  54. private static JTextField TxtKodeCustomer = new JTextField();
  55. private static JLabel LblNamaCustomer = new JLabel("Nama Customer");
  56. private static JTextField TxtNamaCustomer = new JTextField();
  57. private static JLabel LblAlamatCustomer = new JLabel("Alamat Customer"
  58. );
  59. private static JTextField TxtAlamatCustomer = new JTextField();
  60. private static JLabel LblNoTeleponCustomer = new JLabel("No. Telepon"
  61. );
  62.  
  63. private static JTextField TxtNoTeleponCustomer = new JTextField();
  64. private static JLabel LblEmailCustomer = new JLabel("Email");
  65. private static JTextField TxtEmailCustomer = new JTextField();
  66.  
  67. private static JButton TblCustomerDelete = new JButton("Delete");
  68. private static JButton TblCustomerSave = new JButton("Save");
  69. private static JButton TblCustomerCancel = new JButton("Cancel");
  70.  
  71. Dimension dimensi = Toolkit.getDefaultToolkit().getScreenSize();
  72.  
  73. AplikasiToko(){
  74. super("Aplikasi Toko");
  75. setSize((int)(0.7*dimensi.width),(int)(0.7*dimensi.height));
  76. setLocation(dimensi.width/2-getWidth()/2,dimensi.height/2-
  77. getHeight()/2);
  78. setDefaultCloseOperation(EXIT_ON_CLOSE);
  79. frmMDI = new JDesktopPane ();
  80. frmMDI.setLayout(null);
  81. //insets = frmMDI.getInsets();
  82. this.add(frmMDI);
  83.  
  84. /*Menambahkan menu MDI*/
  85. MenuMaster.add(MenuBarang);
  86. MenuMaster.add(MenuCustomer);
  87. MenuBar.add(MenuMaster);
  88.  
  89. MenuTransaksi.add(MenuPenjualan);
  90. MenuTransaksi.add(MenuPembelian);
  91. MenuBar.add(MenuTransaksi);
  92. MenuBar.add(MenuExit);
  93.  
  94. /*Mendeteksi event pada menu*/
  95. MenuBarang.addActionListener(new MenuHandler());
  96. MenuCustomer.addActionListener(new MenuHandler());
  97. MenuExit.addActionListener(new MenuHandler());
  98.  
  99. /*Mendeteksi event pada Button di Form Barang*/
  100. TblBarangDelete.addActionListener(new TombolBarangHandler());
  101. TblBarangSave.addActionListener(new TombolBarangHandler());
  102. TblBarangCancel.addActionListener(new TombolBarangHandler());
  103.  
  104. /*Mendeteksi event pada Button di Form Customer*/
  105. TblCustomerDelete.addActionListener(new TombolCustomerHandler());
  106. TblCustomerSave.addActionListener(new TombolCustomerHandler());
  107. TblCustomerCancel.addActionListener(new TombolCustomerHandler());
  108.  
  109. /*Mendeteksi event pada TxtKodeBarang di Form Barang*/
  110. TxtKodeBarang.addKeyListener(new KeyAdapter() {
  111. public void keyPressed(KeyEvent e) {
  112. int keyCode = e.getKeyCode();
  113. if (keyCode==KeyEvent.VK_ENTER) {
  114. /*Mulai mencari data barang*/
  115. Boolean JDBC_Err=false;
  116. Connection cn = null;
  117.  
  118. try {
  119. cn = DriverManager.getConnection(StringConnection);
  120. } catch (Exception ex) {
  121. JDBC_Err=true;
  122. JOptionPane.showMessageDialog(null,"Koneksi ke database DbTokoABC gagal\n"+ex,"Kesalahan",JOptionPane.ERROR_MESSAGE);
  123. }
  124.  
  125. if (!JDBC_Err){
  126. try {
  127. cn = DriverManager.getConnection(StringConnection);
  128. String SQLStatemen = "Select * from TbBarang where KodeBarang='"+TxtKodeBarang.getText()+"'";
  129. Statement sta = cn.createStatement();
  130. ResultSet rset = sta.executeQuery(SQLStatemen);
  131.  
  132. rset.first();
  133. if (rset.getRow()>0){
  134. TxtNamaBarang.setText(rset.getString("NamaBarang"));
  135. TxtSatuanBarang.setText(rset.getString("SatuanBarang"));
  136. TxtHargaBarang.setText(rset.getString("HargaBarang"));
  137. TxtStockBarang.setText(rset.getString("StockBarang"));
  138. sta.close();
  139. rset.close();
  140. } else {
  141. sta.close();
  142. rset.close();
  143. ClearFormBarang();
  144. JOptionPane.showMessageDialog(null,"Kode barang tidak ada");
  145. }
  146. } catch (Exception ex){
  147. JOptionPane.showMessageDialog(null,"Tidak dapat membuka tabel TbBarang\n"+ex,"Kesalahan",JOptionPane.ERROR_MESSAGE);
  148. }
  149. }
  150. /*selesai mencari data barang*/
  151. }
  152. }
  153. });
  154.  
  155. /*Mendeteksi event pada TxtKodeCustomer di Form Customer*/
  156. TxtKodeCustomer.addKeyListener(new KeyAdapter() {
  157. public void keyPressed(KeyEvent e) {
  158. int keyCode = e.getKeyCode();
  159. if (keyCode==KeyEvent.VK_ENTER) {
  160. /*Mulai mencari data Customer*/
  161. Boolean JDBC_Err=false;
  162. Connection cn = null;
  163.  
  164. try {
  165. cn = DriverManager.getConnection(StringConnection);
  166. } catch (Exception ex) {
  167. JDBC_Err=true;
  168. JOptionPane.showMessageDialog(null,"Koneksi ke database DbTokoABC gagal\n"+ex,"Kesalahan",JOptionPane.ERROR_MESSAGE);
  169. }
  170.  
  171. if (!JDBC_Err){
  172. try {
  173. cn = DriverManager.getConnection(StringConnection);
  174. String SQLStatemen = "Select * from TbCustomer where KodeCustomer='"+TxtKodeCustomer.getText()+"'";
  175. Statement sta = cn.createStatement();
  176. ResultSet rset = sta.executeQuery(SQLStatemen);
  177.  
  178. rset.first();
  179.  
  180. if (rset.getRow()>0){
  181. TxtNamaCustomer.setText(rset.getString("NamaCustomer"));
  182.  
  183. TxtAlamatCustomer.setText(rset.getString("AlamatCustomer"));
  184.  
  185. TxtNoTeleponCustomer.setText(rset.getString("NoTelepon"));
  186. TxtEmailCustomer.setText(rset.getString("Email"));
  187. sta.close();
  188. rset.close();
  189. } else {
  190. sta.close();
  191. rset.close();
  192. ClearFormCustomer();
  193. JOptionPane.showMessageDialog(null,"Kode customer tidak ada");
  194. }
  195. } catch (Exception ex){
  196. JOptionPane.showMessageDialog(null,"Tidak dapat membuka tabel TbCustomer\n"+ex,"Kesalahan",JOptionPane.ERROR_MESSAGE);
  197. }
  198. }
  199. /*selesai mencari data customer*/
  200. }
  201. }
  202. });
  203.  
  204. setContentPane(frmMDI);
  205.  
  206. frmBarang = new JInternalFrame();
  207. frmBarang.setTitle("Master Data Barang");
  208. frmCustomer = new JInternalFrame("Master Data Customer");
  209.  
  210. /*Pengaturan tampilan Form Barang*/
  211. pnlBarang = new JPanel ();
  212. LblKodeBarang.setBounds(30,20,160,20);
  213. pnlBarang.add(LblKodeBarang);
  214. TxtKodeBarang.setBounds(120,20,100,20);
  215. pnlBarang.add(TxtKodeBarang);
  216. LblNamaBarang.setBounds(30,45,160,20);
  217. pnlBarang.add(LblNamaBarang);
  218. TxtNamaBarang.setBounds(120,45,200,20);
  219. pnlBarang.add(TxtNamaBarang);
  220. LblSatuanBarang.setBounds(30,70,160,20);
  221. pnlBarang.add(LblSatuanBarang);
  222. TxtSatuanBarang.setBounds(120,70,100,20);
  223. pnlBarang.add(TxtSatuanBarang);
  224. LblHargaBarang.setBounds(30,95,160,20);
  225. pnlBarang.add(LblHargaBarang);
  226. TxtHargaBarang.setBounds(120,95,100,20);
  227. pnlBarang.add(TxtHargaBarang);
  228. LblStockBarang.setBounds(30,120,160,20);
  229. pnlBarang.add(LblStockBarang);
  230. TxtStockBarang.setBounds(120,120,100,20);
  231. pnlBarang.add(TxtStockBarang);
  232. /*Menampilkan tombol di form Barang*/
  233. TblBarangDelete.setBounds(50,180,80,30);
  234. pnlBarang.add(TblBarangDelete);
  235. TblBarangSave.setBounds(140,180,80,30);
  236. pnlBarang.add(TblBarangSave);
  237. TblBarangCancel.setBounds(230,180,80,30);
  238. pnlBarang.add(TblBarangCancel);
  239. pnlBarang.setLayout(null);
  240. frmBarang.add(pnlBarang);
  241.  
  242. /*Pengaturan tampilan Form Customer*/
  243. pnlCustomer = new JPanel ();
  244. LblKodeCustomer.setBounds(30,20,160,20);
  245. pnlCustomer.add(LblKodeCustomer);
  246. TxtKodeCustomer.setBounds(135,20,100,20);
  247. pnlCustomer.add(TxtKodeCustomer);
  248. LblNamaCustomer.setBounds(30,45,160,20);
  249. pnlCustomer.add(LblNamaCustomer);
  250. TxtNamaCustomer.setBounds(135,45,200,20);
  251. pnlCustomer.add(TxtNamaCustomer);
  252. LblAlamatCustomer.setBounds(30,70,160,20);
  253. pnlCustomer.add(LblAlamatCustomer);
  254. TxtAlamatCustomer.setBounds(135,70,320,20);
  255. pnlCustomer.add(TxtAlamatCustomer);
  256. LblNoTeleponCustomer.setBounds(30,95,160,20);
  257. pnlCustomer.add(LblNoTeleponCustomer);
  258. TxtNoTeleponCustomer.setBounds(135,95,200,20);
  259. pnlCustomer.add(TxtNoTeleponCustomer);
  260. LblEmailCustomer.setBounds(30,120,160,20);
  261. pnlCustomer.add(LblEmailCustomer);
  262. TxtEmailCustomer.setBounds(135,120,160,20);
  263. pnlCustomer.add(TxtEmailCustomer);
  264. /*Menampilkan tombol di form Customer*/
  265. TblCustomerDelete.setBounds(80,180,80,30);
  266. pnlCustomer.add(TblCustomerDelete);
  267. TblCustomerSave.setBounds(170,180,80,30);
  268. pnlCustomer.add(TblCustomerSave);
  269. TblCustomerCancel.setBounds(260,180,80,30);
  270. pnlCustomer.add(TblCustomerCancel);
  271. pnlCustomer.setLayout(null);
  272. frmCustomer.add(pnlCustomer);
  273.  
  274. frmMDI.add(frmBarang);
  275. frmMDI.add(frmCustomer);
  276.  
  277. frmBarang.setBounds(10,10,367,270);
  278. frmCustomer.setBounds(30,30,500,270);
  279.  
  280. setJMenuBar(MenuBar);
  281. setVisible(true);
  282. }
  283.  
  284. private class MenuHandler implements ActionListener {
  285. public void actionPerformed(ActionEvent e){
  286. JMenuItem M = (JMenuItem)e.getSource();
  287.  
  288. if (M.getText().equals("Barang")) {
  289. frmBarang.setVisible(true);
  290. } else if (M.getText().equals("Customer")) {
  291. frmCustomer.setVisible(true);
  292. } else if (M.getText().equals("Exit")) {
  293. dispose();
  294. }
  295. }
  296. }
  297.  
  298. private void ClearFormBarang(){
  299. TxtNamaBarang.setText("");
  300. TxtSatuanBarang.setText("");
  301. TxtHargaBarang.setText("");
  302. TxtStockBarang.setText("");
  303. }
  304.  
  305. private void ClearFormCustomer(){
  306. TxtNamaCustomer.setText("");
  307. TxtAlamatCustomer.setText("");
  308. TxtNoTeleponCustomer.setText("");
  309. TxtEmailCustomer.setText("");
  310. }
  311.  
  312. private class TombolBarangHandler implements ActionListener {
  313. public void actionPerformed(ActionEvent e){
  314. JButton TblPilih = (JButton)e.getSource();
  315. Boolean JDBC_Err = false;
  316.  
  317. if (TblPilih.getText().equals("Delete")) {
  318. /*Mulai menghapus data barang*/
  319. Connection cn = null;
  320.  
  321. try {
  322. cn = DriverManager.getConnection(StringConnection);
  323. } catch (Exception ex) {
  324. JDBC_Err=true;
  325. JOptionPane.showMessageDialog(null,"Koneksi ke database DbTokoABC gagal\n"+ex,"Kesalahan",JOptionPane.ERROR_MESSAGE);
  326. }
  327.  
  328. if (!JDBC_Err){
  329. try {
  330. cn = DriverManager.getConnection(StringConnection);
  331. String SQLStatemen = "Select * from TbBarang where KodeBarang='"+TxtKodeBarang.getText()+"'";
  332. Statement sta = cn.createStatement();
  333. ResultSet rset = sta.executeQuery(SQLStatemen);
  334.  
  335. rset.first();
  336. if (rset.getRow()>0){
  337. sta.close();
  338. rset.close();
  339.  
  340. SQLStatemen = "delete from TbBarang where KodeBarang='"+
  341. TxtKodeBarang.getText()+"'";
  342. sta = cn.createStatement();
  343. int simpan = sta.executeUpdate(SQLStatemen);
  344.  
  345. if (simpan==1){
  346. TxtKodeBarang.setText("");
  347. ClearFormBarang();
  348. JOptionPane.showMessageDialog(null,"Sudah dihapus");
  349. } else {
  350. JOptionPane.showMessageDialog(null,"Gagal menghapus data barang","Kesalahan",JOptionPane.ERROR_MESSAGE);
  351. }
  352. } else {
  353. sta.close();
  354. rset.close();
  355.  
  356. JOptionPane.showMessageDialog(null,"Kode barang tidak ada");
  357. }
  358. } catch (Exception ex){
  359. JOptionPane.showMessageDialog(null,"Tidak dapat membuka tabel TbBarang\n"+ex,"Kesalahan",JOptionPane.ERROR_MESSAGE);
  360. }
  361. }
  362. /*Selesai menghapus data barang*/
  363. } else if (TblPilih.getText().equals("Save")) {
  364. /*Mulai menyimpan data barang*/
  365. Connection cn = null;
  366.  
  367. try {
  368. cn = DriverManager.getConnection(StringConnection);
  369. } catch (Exception ex) {
  370. JDBC_Err=true;
  371. JOptionPane.showMessageDialog(null,"Koneksi ke database DbTokoABC gagal\n"+ex,"Kesalahan",JOptionPane.ERROR_MESSAGE);
  372. }
  373.  
  374. if (!JDBC_Err){
  375. try {
  376. cn = DriverManager.getConnection(StringConnection);
  377. String SQLStatemen = "Select * from TbBarang where KodeBarang='"+TxtKodeBarang.getText()+"'";
  378. Statement sta = cn.createStatement();
  379. ResultSet rset = sta.executeQuery(SQLStatemen);
  380.  
  381. rset.first();
  382. if (rset.getRow()>0){
  383. sta.close();
  384. rset.close();
  385. Object[] arrOpsi = {"Ya","Tidak"};
  386. int pilih=JOptionPane.showOptionDialog(null,"Kode Barang sudah ada\nApakah data diupdate?","Konfirmasi",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE,null,arrOpsi,arrOpsi[0]);
  387. if (pilih==0){
  388. SQLStatemen = "update TbBarang set NamaBarang='"+
  389. TxtNamaBarang.getText()+
  390. "', SatuanBarang='"+TxtSatuanBarang.getText()+
  391. "',HargaBarang='"+TxtHargaBarang.getText()+
  392. "', StockBarang='"+TxtStockBarang.getText()+
  393. "' where KodeBarang='"+TxtKodeBarang.getText()+"'";
  394. sta = cn.createStatement();
  395. int simpan = sta.executeUpdate(SQLStatemen);
  396.  
  397. if (simpan==1){
  398. TxtKodeBarang.setText("");
  399. ClearFormBarang();
  400. JOptionPane.showMessageDialog(null,"Sudah tersimpan");
  401. } else {
  402. JOptionPane.showMessageDialog(null,"Gagal menyimpan data barang","Kesalahan",JOptionPane.ERROR_MESSAGE);
  403. }
  404. }
  405. } else {
  406. sta.close();
  407. rset.close();
  408.  
  409. SQLStatemen = "insert into TbBarang values('"+TxtKodeBarang.getText()+"','"+TxtNamaBarang.getText()+"','"+TxtSatuanBarang.getText()+"','"+TxtHargaBarang.getText()+"','"+TxtStockBarang.getText()+"')";
  410. sta = cn.createStatement();
  411. int simpan = sta.executeUpdate(SQLStatemen);
  412.  
  413. if (simpan==1){
  414. TxtKodeBarang.setText("");
  415. ClearFormBarang();
  416. JOptionPane.showMessageDialog(null,"Sudah tersimpan");
  417. } else {
  418. JOptionPane.showMessageDialog(null,"Gagal menyimpandata barang","Kesalahan",JOptionPane.ERROR_MESSAGE);
  419. }
  420. }
  421. } catch (Exception ex){
  422. JOptionPane.showMessageDialog(null,"Tidak dapat membukatabel TbBarang\n"+ex,"Kesalahan",JOptionPane.ERROR_MESSAGE);
  423. }
  424. }
  425. /*selesai menyimpan data barang*/
  426. } else if (TblPilih.getText().equals("Cancel")) {
  427. frmBarang.setVisible(false);
  428. }
  429. }
  430. }
  431.  
  432. private class TombolCustomerHandler implements ActionListener {
  433. public void actionPerformed(ActionEvent e){
  434. JButton TblPilih = (JButton)e.getSource();
  435. Boolean JDBC_Err = false;
  436.  
  437. if (TblPilih.getText().equals("Delete")) {
  438. /*Mulai menghapus data Customer*/
  439. Connection cn = null;
  440.  
  441. try {
  442. cn = DriverManager.getConnection(StringConnection);
  443. } catch (Exception ex) {
  444. JDBC_Err=true;
  445. JOptionPane.showMessageDialog(null,"Koneksi ke database DbTokoABC gagal\n"+ex,"Kesalahan",JOptionPane.ERROR_MESSAGE);
  446. }
  447.  
  448. if (!JDBC_Err){
  449. try {
  450. cn = DriverManager.getConnection(StringConnection);
  451. String SQLStatemen = "Select * from TbCustomer where KodeCustomer='"+TxtKodeCustomer.getText()+"'";
  452. Statement sta = cn.createStatement();
  453. ResultSet rset = sta.executeQuery(SQLStatemen);
  454.  
  455. rset.first();
  456. if (rset.getRow()>0){
  457. sta.close();
  458. rset.close();
  459.  
  460. SQLStatemen = "delete from TbCustomer where KodeCustomer='"+TxtKodeCustomer.getText()+"'";
  461.  
  462. sta = cn.createStatement();
  463. int simpan = sta.executeUpdate(SQLStatemen);
  464.  
  465. if (simpan==1){
  466. TxtKodeCustomer.setText("");
  467. ClearFormCustomer();
  468. JOptionPane.showMessageDialog(null,"Sudah dihapus");
  469. } else {
  470. JOptionPane.showMessageDialog(null,"Gagal menghapus data customer","Kesalahan",JOptionPane.ERROR_MESSAGE);
  471. }
  472. } else {
  473. sta.close();
  474. rset.close();
  475.  
  476. JOptionPane.showMessageDialog(null,"Kode customer tidak ada");
  477. }
  478. } catch (Exception ex){
  479. JOptionPane.showMessageDialog(null,"Tidak dapat membuka tabel TbCustomer\n"+ex,"Kesalahan",JOptionPane.ERROR_MESSAGE);
  480. }
  481. }
  482. /*Selesai menghapus data Customer*/
  483. } else if (TblPilih.getText().equals("Save")) {
  484. /*Mulai menyimpan data Customer*/
  485. Connection cn = null;
  486.  
  487. try {
  488. cn = DriverManager.getConnection(StringConnection);
  489. } catch (Exception ex) {
  490. JDBC_Err=true;
  491. JOptionPane.showMessageDialog(null,"Koneksi ke database DbTokoABC gagal\n"+ex,"Kesalahan",JOptionPane.ERROR_MESSAGE);
  492. }
  493.  
  494. if (!JDBC_Err){
  495. try {
  496. cn = DriverManager.getConnection(StringConnection);
  497. String SQLStatemen = "Select * from TbCustomer where KodeCustomer='"+TxtKodeCustomer.getText()+"'";
  498. Statement sta = cn.createStatement();
  499. ResultSet rset = sta.executeQuery(SQLStatemen);
  500.  
  501. rset.first();
  502. if (rset.getRow()>0){
  503. sta.close();
  504. rset.close();
  505. Object[] arrOpsi = {"Ya","Tidak"};
  506. int pilih=JOptionPane.showOptionDialog(null,"Kode customer sudah ada\nApakah data diupdate?","Konfirmasi",
  507. JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE,null,arrOpsi,arrOpsi[0]);
  508. if (pilih==0){
  509. SQLStatemen = "update TbCustomer set NamaCustomer='"+
  510. TxtNamaCustomer.getText()+
  511. "', AlamatCustomer='"+TxtAlamatCustomer.getText()+
  512. "', NoTelepon='"+TxtNoTeleponCustomer.getText()+
  513. "', Email='"+TxtEmailCustomer.getText()+
  514. "' where KodeCustomer='"+TxtKodeCustomer.getText()+
  515. "'";
  516.  
  517. sta = cn.createStatement();
  518. int simpan = sta.executeUpdate(SQLStatemen);
  519.  
  520. if (simpan==1){
  521. TxtKodeCustomer.setText("");
  522. ClearFormCustomer();
  523. JOptionPane.showMessageDialog(null,"Sudah tersimpan");
  524. } else {
  525. JOptionPane.showMessageDialog(null,"Gagal menyimpan data customer","Kesalahan",JOptionPane.ERROR_MESSAGE);
  526. }
  527. }
  528. } else {
  529. sta.close();
  530. rset.close();
  531.  
  532. SQLStatemen = "insert into TbCustomer values ('"+
  533. TxtKodeCustomer.getText()+"','"+TxtNamaCustomer.getText()+"','"+
  534. TxtAlamatCustomer.getText()+"','"+TxtNoTeleponCustomer.getText()+
  535. "','"+TxtEmailCustomer.getText()+"')";
  536. sta = cn.createStatement();
  537. int simpan = sta.executeUpdate(SQLStatemen);
  538.  
  539. if (simpan==1){
  540. TxtKodeCustomer.setText("");
  541. ClearFormCustomer();
  542. JOptionPane.showMessageDialog(null,"Sudah tersimpan");
  543. } else {
  544. JOptionPane.showMessageDialog(null,"Gagal menyimpan data customer","Kesalahan",JOptionPane.ERROR_MESSAGE);
  545. }
  546. }
  547. } catch (Exception ex){
  548. JOptionPane.showMessageDialog(null,"Tidak dapat membuka tabel TbCustomer\n"+ex,"Kesalahan",JOptionPane.ERROR_MESSAGE);
  549. }
  550. }
  551. /*selesai menyimpan data Customer*/
  552. } else if (TblPilih.getText().equals("Cancel")) {
  553. frmCustomer.setVisible(false);
  554. }
  555. }
  556. }
  557.  
  558. public static void main(String args[]){
  559. AplikasiToko frameku = new AplikasiToko();
  560. Boolean JDBC_Err = false;
  561.  
  562. try{
  563. Class.forName(StringDriver);
  564. } catch (Exception ex){
  565. JDBC_Err=true;
  566. JOptionPane.showMessageDialog(null,"JDBC Driver tidak ditemukan atau rusak\n"+ex,"Kesalahan",JOptionPane.ERROR_MESSAGE);
  567. }
  568.  
  569. if (!JDBC_Err){
  570. try {
  571. Connection cn = DriverManager.getConnection(StringConnection);
  572. } catch (Exception ex) {
  573.  
  574. JOptionPane.showMessageDialog(null,"Koneksi ke database DbTokoABC gagal\n"+ex,"Kesalahan",JOptionPane.ERROR_MESSAGE);
  575. }
  576. }
  577. }
  578. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!