Contoh -contoh dalam artikel ini berbagi kode spesifik manajemen buku siswa Java GUI untuk referensi Anda. Konten spesifiknya adalah sebagai berikut
- Bangunan Tabel Database MySQL:
1. Tabel Buku
2.B Formulir Catatan Pinjaman Buku
3. Tabel Siswa St.
4.DL Tabel Pengguna Login
.
- Daftar konten
1.databd.java // Program Portal dan Verifikasi Login
impor java.awt.*; impor java.awt.event.*; impor java.sql.*; impor javax.swing.border.emptyborder; databd kelas publik memperluas jFrame mengimplementasikan ActionListener {static framedemo a = null; String getUser = ""; String getPd = ""; String sql = "pilih * dari dl di mana id = '"; String sql1 = "Pilih Kata Sandi dari DL WHERE KOWASTER = '"; Jbutton btnnewbutton = jbutton baru ("login"); Jbutton btnnewbutton_1 = jbutton baru ("register"); JTextField show = JTextField baru ("/t Harap pilih tombol", 10); ContentPane Jpanel Pribadi; Private JTextField Userfield; Private JPasswordfield Pwdfield; Pernyataan Pernyataan Pribadi = NULL; // akun kueri Pernyataan Pribadi2 = NULL; // Daftarkan Akun Private Static Databd Frame; // hasil rst2 = null; public static void main (string [] args) {eventqueue.invokelater (runnable baru () {public void run () {try {frame = new DataBd (); frame.setVisible (true);} catch (Exception e) {e.printStackTrace ();}}}}}}}; } public dataBD () {string driver = "com.mysql.jdbc.driver"; String url = "jdbc: mysql: // localhost: 8088/library? UseUnicode = true & characterencoding = utf-8 & usessl = false"; String user = "root"; String password = "11111"; coba {class.forname (driver); Koneksi conn = driverManager.getConnection (url, pengguna, kata sandi); Koneksi conn2 = driverManager.getConnection (url, pengguna, kata sandi); pernyataan = conn.createStatement (); Pernyataan2 = conn2.createStatement (resultet.type_scroll_sensitive, resultet.concur_updatable); RST2 = Pernyataan2.ExecuteQuery ("SELECT * DARI DL"); show.setedable (false); setDefaultCloseOperation (jframe.exit_on_close); setsize (250, 200); setLocationRelativeto (null); ContentPane = jpanel baru (); contentpane.setborder (baru kosong (5, 5, 5, 5)); contentpane.setLayout (null); Tambahkan (ContentPane); Jlabel lblusername = jlabel baru ("akun"); lblusername.setbounds (12, 13, 54, 15); contentpane.add (lblusername); Jlabel lblpassword = jlabel baru ("kata sandi"); lblpassword.setbounds (12, 38, 54, 15); contentpane.add (lblpassword); userfield = new jTextField (); userfield.setbounds (76, 10, 144, 21); ContentPane.Add (UserField); userfield.setColumns (10); pwdfield = jpasswordfield baru (); pwdfield.setechochar ('*'); // Kata sandi Gema Karakter Pwdfield.setbounds (76, 35, 144, 21); ContentPane.Add (PWDField); pwdfield.setColumns (10); Tambahkan (show, borderlayout.south); btnnewbutton.addactionlistener (ini); // Masuk btnnewbutton.setbounds (10, 92, 93, 23); contentpane.add (btnnewbutton); btnnewbutton_1.addactionlistener (ini); // Daftarkan btnnewbutton_1.setbounds (127, 92, 93, 23); contentpane.add (btnnewbutton_1); show.addactionListener (ini); } catch (ClassNotFoundException e) {System.out.print ("Drive Not Found"); } catch (Exception e) {System.out.print ("Kesalahan terjadi"); e.printstacktrace ();}} public void actionPerformed (actionEvent e) {getUser = userfield.getText (). trim ()+"'"; String pd = string.valueof (pwdfield.getPassword ()); coba {hasil rs = pernyataan.executeQuery (sql+getUser); if (e.getSource () == btnnewbutton) {// login if (rs.next ()) {if (rs.getString (2) .equals (pd)) {frame.setVisible (false); JOPTIONPANE.SHOWMESSADEIALOG (NULL, "LOGIN SUSTIFT"); Uimanager.setLookandFeel (uimanager.getsystemLookandFeelClassName ()); a = framedemo.a; // menghasilkan objek statis} else show.setText ("/t Kata sandi kesalahan"); } else show.setText ("/T akun tidak ada"); } lain if (e.getSource () == btnnewbutton_1) {// daftarkan if (userfield.getText (). Equals ("")) {show.setText ("/t akun yang terdaftar tidak dapat dikosongkan");} else {if (string.valueof (pwdfield.getpassword ()) () (if string. kosong"); else {register ();}}}}} catch (Exception c) {c.printstacktrace ();}} private void register () {string name = userfield.getText (), passwd = string.valueof (pwdfield.getPassword ()); coba {rst2.movetoinsertrow (); rst2.updateString (1, nama); rst2.updateString (2, passwd); RST2.InserTrow (); rst2.movetocurrentrow (); show.setText ("/t berhasil pendaftaran"); } catch (Exception e) {show.setText ("/t registrasi gagal");}}}2.Framedemo // Kerangka kerja utama, serahkan acara ke kelas AddInformation
Paket database; impor javax.swing.*; impor javax.swing.border.titledborder; impor java.awt.*; impor java.awt.event.*; impor java.sql. framedemo a = broamedemo baru (); Panel JPanel = jpanel baru (), panel1 = jpanel baru (), panel2 = jpanel baru (), panel3 = jpanel baru (), panel4 = jpanel baru (), panel5 = jpanel baru (); String [] adds = {"Silakan pilih operasi", "Tambahkan catatan koleksi", "Tambahkan Buku Pinjaman Catatan", "Tambahkan Rekaman Siswa"}; String [] deletes = {"Silakan pilih operasi", "Hapus Catatan Koleksi", "Hapus Buku Pinjaman Catatan", "Hapus Catatan Siswa"}; String [] perubahan = {"Silakan pilih operasi", "Modifikasi catatan inventaris", "tanggal untuk mengembalikan"}; String [] query = {"Silakan pilih operasi", "nomor buku kueri", "Rekaman Pinjaman Mahasiswa Permintaan", "Informasi Siswa Permintaan"}; String [] show = {"Silakan pilih operasi", "Tunjukkan semua catatan koleksi", "Tampilkan catatan pinjaman", "Tampilkan catatan siswa"}; String [] Record = New String [4]; JTextArea ta = JTextArea baru ("-> Selamat datang untuk menggunakan System/N", 11,60); Jscrollpane panel = jscrollpane baru (ta); Koneksi conn = null; Pernyataan stmt = null; Pernyataan stmt1 = null; Pernyataan stmt2 = null; Hasil RST = NULL; Hasil rst1 = null; Hasil rst2 = null; kunci boolean statis; Private JFrame Big = New JFrame ("Silakan pilih Operasi"); private jcomboBox add = new jcomboBox (adds); private jcomboBox delete = new jcomboBox (deletes); Private JComboBox Change = new jcomboBox (perubahan); Private JComboBox Query = new jcomboBox (kueri); Private JComboBox Show = new jcomboBox (show); public framedemo () {super ("Sistem Manajemen Perpustakaan"); coba {class.forname ("com.mysql.jdbc.driver"); String url = "jdbc: mysql: // localhost: 8088/library? UseUnicode = true & characterencoding = utf-8 & usessl = false"; String user = "root"; String password = "111111"; conn = driverManager.getConnection (url, pengguna, kata sandi); panel4.setLayout (GridLayout baru (3,1,30,10)); panel4.setborder (judul baru ("Pilih Manajemen:")); panel1.add (jlabel baru ("Tambahkan catatan:")); panel1.add (add); panel1.add (jlabel baru ("hapus catatan:")); panel1.add (hapus); panel2.add (jlabel baru ("Modifikasi catatan:")); panel2.add (ubah); panel2.add (jlabel baru ("catatan kueri:")); panel2.add (kueri); panel3.add (jlabel baru ("show); panel4.add (panel1); panel4.add (panel2); panel4.add (panel3); panel5.add (panel); panel.add (panel5, borderlayout.south); panel.add (panel4, borderlayout.cening); Panel); Panel.add (Panel4, Borderlayout.center); Panel); Panel. stmt = conn.createTatement (resultet.type_scroll_sensitive, resultet.concur_updatable); stmt2 = Conn.createstatement (hasilnya. // setResizable (false); if (add.getSelectedIndex () == 1) {ta.append ("-> Tambahkan koleksi catatan/n"); Nomor "," Nomor Siswa ", 2);} selain itu jika (add.getSelectedIndex () == 3) {ta.applappend ("-> Tambahkan Rekaman Siswa/N "); AddInformation A1 = AddInformation baru (" Nomor Siswa "," Nama Siswa ", 3);} Add.setselectedItem (" silakan Pilih Operasi "); Ta.Ppert. "-> Catatan Koleksi/N"); if (delete.getSelectedIndex () == 3) {ta.append ("-> Hapus Siswa Record/N"); A1 = Tambahan baru ("Nomor Buku", "Nomor Inventaris", 7); if (query.getSelectedIndex () == 1) {ta.append ("-> query by book title/n"); } if if (query.getSelectedIndex () == 3) {ta.append ("-> Query Student meminjam catatan/n")); Nomor ", 12);} query.setselectedItem (" Silakan pilih operasi "); if (show.getSelectedIndex () == 1) {ta.append ("-> tunjukkan semua catatan koleksi/n "); coba {rst = stmt.executeQuery (" pilih * dari buku "); rst.first (); ta.append("------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Ta.Pen, "/t"+id+"/t"+nama+"/t"+num+"/n"); eksekusi, kursor menunjuk ke posisi terakhir dari baris terakhir, rst.first (); ta.append("---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ta.append("-->Show book borrowing record/n"); RST1 = STMT1.ExecuteQuery ("Pilih * dari BS"); ta.append("------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Urildate = (java.util.date) calendar.getTime (); Ta.Pen ("/t"+bookId+"/t"+stdid+"/t"+x+"/t"+newDate+"/n")); Calendar.Add (Calendar.Date, 30); Ta.Append ("/t"+bookId+"/t"+stdid+"/t"+x+"/t"+newDate+"/n"); TA.Append ("--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- name = rst2.getString (2); ta.append ("/t"+id+"/t"+name+"/t"+"/n"); ta. lappend ("----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ta.setcaretposition (ta.getText (). length ()); TA.Append ("-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. Ta.Pen, ""+""+""+Harga+""+"/n")); "+Brand+" "+Price+" "+Stock+"/n ");} // Setelah eksekusi, kursor menunjuk ke posisi terakhir dari baris terakhir RST.Absolute (a); TA.Append ("--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------3.Addinformation.java // menangani acara
Paket database; impor javax.swing.*; impor java.util.calendar; impor java.util.gregoriancalendar; impor java.awt.*; impor java.awt.event.*; impor java.sql.*; informasi kelas publik memperluas jFFame melibatkan tindakan java.sql.*; quxiao = jbutton baru ("batal"); JTextField JTF1 = JTextField baru (10), JTF2 = JTextField baru (10), JTF3 = JTextField baru (10); Koneksi conn = null; static {try {class.forname ("com.mysql.jdbc.driver"); } catch (exception e) {e.printstacktrace ();}} int x = 0; Koneksi publik getConnection () melempar sqlexception {if (conn == null) {conn = driverManager.getConnection ("jdbc: mysql: // localhost: 8088/library? UseUnicode = true & characterencoding = UTF-8 & usessl = false", "root," root, "11111 (" 11111); } return conn; } addInformation (String S1, String S2, String S3, Int M) {jpanel p = new jpanel (); p.setLayout (flowlayout baru ()); P.Add (New Jlabel (S1)); P.Add (JTF1); P.Add (New Jlabel (S2)); P.Add (jtf2); P.Add (New Jlabel (S3)); P.Add (JTF3); p.add (tentu saja); P.Add (Quxiao); tambahkan (p); if (m == 8) {jOptionPane.showmessagedialog (null, "Tanggal buku harus dalam format xxxx-xx-xx!", "Peringatan", joptionpane.warning_message); } setSize (500, 100); setVisible (true); setDefaultCloseOperation (jframe.dispose_on_close); setLocationRelativeto (null); Sure.addactionListener (ini); quxiao.addactionListener (ini); x = m; } addInformation (string s1, string s2, int m) {jpanel p = new jpanel (); p.setLayout (flowlayout baru ()); P.Add (New Jlabel (S1)); P.Add (JTF1); P.Add (New Jlabel (S2)); P.Add (jtf2); p.add (tentu saja); P.Add (Quxiao); Tambahkan (QUXIAO); tambahkan (p); setsize (500, 100); setVisible (true); setDefaultCloseOperation (jframe.dispose_on_close); setLocationRelativeto (null); Sure.addactionListener (ini); quxiao.addactionListener (ini); x = m; } addInformation (string s1, int m) {jpanel p = new jpanel (); p.setLayout (flowlayout baru ()); P.Add (New Jlabel (S1)); P.Add (JTF1); if (m == 4) {joptionpane.showmessagealog (null, "jika ada catatan pinjaman, informasi buku tidak dapat dihapus!", "Peringatan", joptionpane.warning_message); } if (m == 6) {jOptionPane.showmessagealog (null, "jika ada catatan pinjaman, informasi siswa tidak dapat dihapus!", "Peringatan", joptionpane.warning_message); } p.add (tentu saja); P.Add (Quxiao); tambahkan (p); setsize (500, 80); setVisible (true); setDefaultCloseOperation (jframe.dispose_on_close); setLocationRelativeto (null); Sure.addactionListener (ini); quxiao.addactionListener (ini); x = m; } public void actionPerformed (actionEvent ae) {if (ae.getSource () == tentu saja) {if (x == 1) {// Tambahkan string rekaman koleksi sql = "masukkan ke dalam nilai buku (?,?,?)"; coba (koneksi conn = getConnection (); disiapkan stmt = conn.preparestatement (sql)) {int id = integer.parseint (jtf1.getText ()); Name string = jtf2.getText (); int num = integer.parseint (jtf3.getText ()); stmt.setint (1, id); stmt.setstring (2, nama); stmt.setint (3, num); stmt.executeUpdate (); framedemo.a.ta.append ("-> tambahkan sukses/n"); } catch (Exception x) {framedemo.a.ta.append ("-> masukkan kesalahan/n"); x.printstacktrace ();} addinformation.this.dispose (); } if (x == 2) {// Tambahkan string rekaman pinjaman sql = "masukkan ke dalam bs (bookId, stdid, date) values (?,?,?)"; String sql1 = "Pilih id, num dari buku di mana id =?"; String sql2 = "Pilih ID dari std di mana id =?"; coba {koneksi conn1 = getConnection (); Disiapkan stmt1 = conn1.prepareStatement (sql1, resultset.type_scroll_sensitive, resultet.concur_updatable); stmt1.setint (1, integer.parseint (jtf1.getText ()))); Hasil rst1 = stmt1.executeQuery (); // Lihat apakah ada buku ini dan apakah inventarisnya adalah 0 if (rst1.next () && (rst1.getint (2)> 0)) {int n = rst1.getint (2); n- = 1; int m = rst1.getint (1); rst1.updateint (1, m); rst1.updateint (2, n); rst1.updaterow (); Koneksi conn2 = getConnection (); Disiapkan stmt2 = conn2.preparestatement (sql2); stmt2.setint (1, integer.parseint (jtf2.gettext ())); Hasil rst2 = stmt2.executeQuery (); // seseorang jika (rst2.next ()) {koneksi conn = getConnection (); PreparyStatement stmt = conn.preparestatement (sql); int bookId = integer.parseint (jtf1.getText ()); int stdid = integer.parseint (jtf2.getText ()); stmt.setint (1, bookId); stmt.setint (2, stdid); stmt.setDate (3, tanggal baru (System.CurrentTimeMillis ())); stmt.executeUpdate (); framedemo.a.ta.append ("-> tambahkan sukses/n"); } else {framedemo.a.ta.append ("-> tidak ada catatan siswa, tidak ada catatan pinjaman/n");}} else {framedemo.a.ta.append ("-> tidak buku ini atau telah meminjam semua/n");}}} catch (pengecualian x) {framedemo.a.a.a.a.a.a.aPend x.printstacktrace ();} addinformation.this.dispose (); } if (x == 3) {// Tambahkan string catatan siswa sql = "masukkan ke dalam nilai std (?,?)"; coba (koneksi conn = getConnection (); disiapkan stmt = conn.preparestatement (sql)) {int id = integer.parseint (jtf1.getText ()); Name string = jtf2.getText (); stmt.setint (1, id); stmt.setstring (2, nama); stmt.executeUpdate (); framedemo.a.ta.append ("-> tambahkan sukses/n"); } catch (Exception x) {framedemo.a.ta.append ("-> masukkan kesalahan/n"); x.printstacktrace ();} addinformation.this.dispose (); } if (x == 4) {// hapus string rekaman buku sql = "hapus dari buku di mana id =?"; String sql1 = "pilih * dari bs where bookId =?"; coba {koneksi conn1 = getConnection (); Disiapkan stmt1 = conn1.preparestatement (sql1); stmt1.setint (1, integer.parseint (jtf1.getText ()))); Hasil rst1 = stmt1.executeQuery (); if (rst1.next ()) {// Ada buku dalam catatan pinjaman, joptionpane.showmessagealog (null, "Ada catatan pinjaman untuk buku dalam catatan pinjaman!", "Peringatan", joptionpane.warning_message); " } else {// tidak ada buku dalam catatan pinjaman, koneksi conn = getConnection (); PreparyStatement stmt = conn.preparestatement (sql); int id = integer.parseint (jtf1.getText ()); stmt.setint (1, id); int t = stmt.executeUpdate (); if (t == 0) {framedemo.a.ta.append ("-> hapus kesalahan/n"); JOPTIONPANE.SHOWMESSADEIALOG (NULL, "INFORMASI BUKU TIDAK ADA!", "PERINGATAN", JOPTIONPANE.WARNING_MESSAGE); } else framedemo.a.ta.append ("-> hapus catatan berhasil/n"); }} catch (Exception x) {framedemo.a.ta.append ("-> penghapusan gagal/n"); x.printstacktrace ();} addinformation.this.dispose (); } if (x == 5) {// hapus buku pinjaman string string sql = "hapus dari bs di mana bookId =? dan stdid =?"; String sql1 = "Pilih id, num dari buku di mana id =?"; coba {koneksi conn = getConnection (); PreparyStatement stmt = conn.preparestatement (sql); int bookId = integer.parseint (jtf1.getText ()); int stdid = integer.parseint (jtf2.getText ()); stmt.setint (1, bookId); stmt.setint (2, stdid); int t = stmt.executeUpdate (); if (t! = 0) {koneksi conn1 = getConnection (); Disiapkan stmt1 = conn1.prepareStatement (sql1, resultset.type_scroll_sensitive, resultet.concur_updatable); stmt1.setint (1, integer.parseint (jtf1.getText ()))); Hasil rst1 = stmt1.executeQuery (); rst1.next (); int m = rst1.getint (1); int n = rst1.getint (2); n+= 1; rst1.updateint (1, m); rst1.updateint (2, n); rst1.updaterow (); framedemo.a.ta.append ("-> hapus catatan pinjaman berhasil/n"); } else {framedemo.a.ta.append ("-> hapus kesalahan/n"); JOPTIONPANE.SHOWMESSADEIALOG (NULL, "Catatan pinjaman ini tidak ada!", "Peringatan", JOPTIONPANE.WARNING_MESSAGE); }} catch (Exception x) {framedemo.a.ta.append ("-> hapus kesalahan/n"); x.printstacktrace ();} addinformation.this.dispose (); } if (x == 6) {// hapus string rekaman siswa sql = "hapus dari std where id =?"; String sql1 = "pilih * dari bs di mana stdid =?"; coba {koneksi conn1 = getConnection (); Disiapkan stmt1 = conn1.preparestatement (sql1); stmt1.setint (1, integer.parseint (jtf1.getText ()))); Hasil rst1 = stmt1.executeQuery (); if (rst1.next ()) {// Orang tersebut ada dalam catatan pinjaman, joptionpane.showmessagealog (null, "orang tersebut ada dalam catatan pinjaman!", "Peringatan", joptionpane.warning_message); } else {connection conn = getConnection (); PreparyStatement stmt = conn.preparestatement (sql); int stdid = integer.parseint (jtf1.getText ()); stmt.setint (1, stdid); int t = stmt.executeUpdate (); if (t == 0) {framedemo.a.ta.append ("-> hapus kesalahan/n"); JOPTIONPANE.SHOWMESSADEIALOG (NULL, "Catatan Siswa tidak ada!", "Peringatan", JOPTIONPANE.WARNING_MESSAGE); } else framedemo.a.ta.append ("-> hapus catatan berhasil/n"); }} catch (Exception x) {framedemo.a.ta.append ("-> hapus kesalahan/n"); x.printstacktrace ();} addinformation.this.dispose (); } if (x == 7) {// Modifikasi Buku Inventory Record String SQL = "Perbarui Buku Set Num =? Di mana id =?"; coba (koneksi conn = getConnection (); disiapkan stmt = conn.preparestatement (sql)) {int num = integer.parseint (jtf2.getText ()); int bookId = integer.parseint (jtf1.getText ()); stmt.setint (1, num); stmt.setint (2, bookId); int t = stmt.executeUpdate (); if (t == 0) {framedemo.a.ta.append ("-> kesalahan modifikasi/n"); JOPTIONPANE.SHOWMESSADEIALOG (NULL, "Catatan Buku tidak ada!", "PERINGATAN", JOPTIONPANE.WARNING_MESSAGE); } else framedemo.a.ta.append ("-> catatan modifikasi berhasil/n"); } catch (Exception x) {framedemo.a.ta.append ("-> kesalahan modifikasi/n"); x.printstacktrace ();} addinformation.this.dispose (); } if (x == 8) {// Ubah tanggal yang akan dikembalikan string sql = "Perbarui bs set tanggal =? di mana bookId =? dan stdid =?"; coba (koneksi conn = getConnection (); disiapkan stmt = conn.preparestatement (sql)) {date date = date.valueof (jtf3.getText ()); Kalender kalender = gregoriancalendar baru (); Calendar.Settime (tanggal); calendar.add (calendar.date, -30); java.util.date utildate = (java.util.date) calendar.getTime (); utildate = (java.util.date) calendar.getTime (); Tanggal newDate = tanggal baru (utildate.getTime ()); int stdid = integer.parseint (jtf2.getText ()); int bookId = integer.parseint (jtf1.getText ()); stmt.setDate (1, newDate); stmt.setint (2, bookId); stmt.setint (3, stdid); int t = stmt.executeUpdate (); if (t == 0) {framedemo.a.ta.append ("-> kesalahan modifikasi/n"); JOPTIONPANE.SHOWMESSADEIALOG (NULL, "Catatan pinjaman tidak ada!", "Peringatan", JOPTIONPANE.WARNING_MESSAGE); } else framedemo.a.ta.append ("-> catatan modifikasi berhasil/n"); } catch (Exception x) {framedemo.a.ta.append ("-> kesalahan modifikasi/n"); x.printstacktrace ();} addinformation.this.dispose (); } if (x == 9) {// kueri string sql = "pilih * dari buku where name =?"; Hasil RST = NULL; coba (koneksi conn = getConnection (); disiapkan stmt = conn.preparestatement (sql)) {string name = jtf1.getText (); stmt.setstring (1, nama); rst = stmt.executeQuery (); if (rst.next ()) { frameDemo.a.ta.append("----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- framedemo.a.ta.append ("/t"+rst.getint (1)+"/t"+rst.getString (2)+"/t"+rst.getint (3)+"/n"); framedemo.a.ta.append ("--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- x) {framedemo.a.ta.append ("-> query error/n"); x.printstacktrace ();} addInformation.bis.dispose (); stmt = conn.prepareStatement (sql)) {stmt.setint (1, integer.parseint (jtf1.getText ())); frameDemo.a.ta.append("---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- JOPTIONPANE.ShowMessagedialog (NULL, "Buku ini tidak ada!", "Peringatan", joptionpane.warning_message); if (x == 11) {// Query String sql = "SELECT BOOKID, STDID, Tanggal dari BS di mana stdid =?" rst = stmt.executeQuery (); frameDemo.a.ta.append("------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Calendar.Settime (x); Framedemo.a.ta.append ("/t"+rst.getint (1)+"/t"+rst.getint (2)+"/t"+x+"/t"+newDate+"/n"); (java.util.date) calendar.getTime (); framedemo.a.ta.append ("/t"+rst.getint (1)+"/t"+rst.getint (2)+"/t"+x+"/t"+newDate+"/n"); framedemo.a.ta.append ("---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- sql = "Pilih * dari std di mana id =?"; frameDemo.a.ta.append("----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- framedemo.a.ta.append ("/t"+rst.getint (1)+"/t"+rst.getString (2)+"/n"); Framedemo.a.ta.Append ("----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- x) {framedemo.a.ta.append ("-> query error/n"); x.printstacktrace ();} addInformation.pose.dispose (); }}Di atas adalah semua konten artikel ini. Saya berharap ini akan membantu untuk pembelajaran semua orang dan saya harap semua orang akan lebih mendukung wulin.com.