Einfaches Beispiel für die Implementierung von Studentenbuchmanagement in Java GUI

Die Beispiele in diesem Artikel teilen den spezifischen Code des Java -GUI -Studentenbuchmanagements für Ihre Referenz. Der spezifische Inhalt ist wie folgt

- Erstellung von MySQL -Datenbanktisch:

1.Book -Tabelle

2.B -Buchkredite Rekordformular

3.Std Student Tabelle

4.DL Login -Benutzer -Tabelle

.

- Inhalt auflisten

1.Databd.java // Programmportal und Anmeldeverifizierung

 Java.awt.*; import Java.awt.event.*; import Java.sql. String GetUser = ""; String getPd = ""; String SQL = "SELECT * aus dl wobei id = '"; String SQL1 = "Kennwort aus dl wobei password = '"; Jbutton btnnewbutton = new Jbutton ("Login"); Jbutton btnnewbutton_1 = new Jbutton ("Register"); JTextField show = new JTextField ("/t bitte auswählen", 10); Private Jpanel ContentPane; Private JTextField Userfield; Private JPasswordfield Pwdfield; private Erklärung Erklärung = NULL; // Abfrage Konto private Anweisung Anweisung 2 = NULL; // Konto für private statische Datenbank registrieren; // resultSet rst2 = null; public static void main (string [] args) {eventQueue.invokelater (new Runnable () {public void run () {try {Frame = new DataBd (); } public databd () {String driver = "com.mysql.jdbc.driver"; String url = "jdbc: mysql: // localhost: 8088/bibliothek? UseUnicode = true & charakterencodierung = utf-8 & uSessl = false"; String user = "root"; String password = "11111"; try {class.Forname (Treiber); Verbindung conn = driverManager.getConnection (URL, Benutzer, Passwort); Verbindung conn2 = driverManager.getConnection (URL, Benutzer, Passwort); Anweisung = conn.CreateStatement (); Anweisung2 = conn2.CreateStatement (resultSet.type_scroll_sensitive, resultset.concur_updatable); rst2 = Anweisung2.ExecuteQuery ("aus Select * aus dl"); show.SeetedEditable (falsch); setDefaultCloseOperation (jframe.exit_on_close); SetSize (250, 200); setLocationRelativeto (null); contentPane = new jpanel (); ContentPane.SetBorder (neuer leererBorder (5, 5, 5, 5)); contentPane.setLayout (null); add (contentPane); JLabel lbluername = new JLabel ("Account"); lbluername.setbounds (12, 13, 54, 15); contentPane.add (lbluername); JLabel LBLPassword = new JLabel ("Passwort"); 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 = new jpasswordfield (); pwdfield.setechochar ('*'); // Passwort Echo Zeichen PWDField.Setbounds (76, 35, 144, 21); contentPane.add (pwdfield); pwdfield.setColumns (10); add (show, borderLayout.South); btnnewbutton.addactionListener (this); // Login btnnewbutton.setBounds (10, 92, 93, 23); contentPane.add (btnnewbutton); btnnewbutton_1.addactionListener (this); // Register btnnewbutton_1.setBounds (127, 92, 93, 23); contentPane.add (btnnewbutton_1); show.addactionListener (this); } catch (classNotFoundException e) {System.out.print ("Antrieb nicht gefunden"); } catch (Ausnahme e) {System.out.print ("Fehler aufgetreten"); e.printStackTrace ();}} public void actionPerformed (actionEvent e) {getUser = userfield.getText (). Trim ()+"'"; String pd = string.ValueOf (pwdfield.getPassword ()); try {resultSet rs = Anweisung.executeQuery (SQL+GetUser); if (e.getSource () == btnNewbutton) {// login if (rs.Next ()) {if (rs.getString (2) .Equals (pd)) {Fram.setVisible (false); Joptionpane.showmessagedialog (null, "erfolgreich anmelden"); Uimanager.setlookandfeel (uimanager.getSystemLookandFeelClassName ()); a = framedemo.a; // ein statisches Objekt generieren} else show.setText ("/t Kennwortfehler"); } else show.setText ("/T -Konto existiert nicht"); } else if (e.getSource () == btnNewbutton_1) {// Register if (userField.getText (). Equals ("") {show.setText ("/t -Konto kann nicht leer sein");} else {if (String.ValueOf (pwdfield.GetPassword). leer"); else {register ();}}}}} catch (Ausnahme c) {c.printstacktrace ();}} private void Register () {String name = userField.GetText (), passwd = string.valueof (pwdfield.getPassword ()); try {rst2.movetoinsertrow (); rst2.updatestring (1, Name); rst2.updatestring (2, Passwd); rst2.insertrow (); rst2.Movetocurrentrow (); show.setText ("/t Registrierung erfolgreich"); } catch (Ausnahme e) {show.setText ("/t Registrierung fehlgeschlagen");}}}

2.Framedemo // Hauptframework, übergeben Sie das Ereignis an die AddInformationsklasse

 Paketdatenbank; import Javax.swing. Framedemo a = neuer framedemo (); Jpanel panel = new jpanel (), panel1 = new jpanel (), panel2 = new jpanel (), panel3 = new jpanel (), panel4 = new jpanel (), panel5 = new jpanel (); String [] fügt = {"Bitte auswählen Operation", "Sammlungsprotokoll hinzufügen", "Buchauslehnungsrekord hinzufügen", "Student Record hinzufügen"}; String [] Deletes = {"Bitte auswählen Operation", "Sammlungsdatensatz löschen", "Buchauslehre löschen", "Student Record"}; String [] ändert = {"Bitte auswählen Operation", "Inventarrekord ändern", "Datum der Rückgabe"}; String [] querys = {"Bitte auswählen Operation", "Abfragebuchnummer", "Abfrageberlierungsdatensatz", "Abfragen von Studentinformationen"}; String [] shows = {"Bitte auswählen Operation", "Alle Sammlungsdatensätze anzeigen", "Kreditaufzeichnungen anzeigen", "Student Records"}; String [] record = new String [4]; JTextArea ta = new JTextArea ("-> Willkommen, System/n", 11,60); JScrollPane -Schweiß = new Jscrollpane (TA); Verbindung conn = null; Aussage STMT = NULL; Anweisung STMT1 = NULL; Aussage STMT2 = NULL; ResultSet rst = null; ResultSet rst1 = null; ResultSet rst2 = null; statischer Boolescher Schlüssel; Private JFrame Big = New JFrame ("Bitte wählen Sie die Operation aus"); private jcombobox add = new JcomBobox (fügte); private jcombobox delete = new JcomBobox (Delets); private jcombobox change = new jcombobox (Änderungen); private jcombobox query = new JcomBobox (querys); private jcombobox show = new JcomBobox (Shows); public Framedemo () {Super ("Bibliotheksverwaltungssystem"); try {class.forname ("com.mysql.jdbc.driver"); String url = "jdbc: mysql: // localhost: 8088/bibliothek? UseUnicode = true & charakterencodierung = utf-8 & uSessl = false"; String user = "root"; String password = "111111"; conn = driverManager.getConnection (URL, Benutzer, Passwort); Panel4.SetLayout (neuer GridLayout (3,1,30,10)); panel4.setBorder (neuer Titelborder ("Select Management:")); panel1.add (neuer jLabel ("Rekord hinzufügen:")); panel1.add (add); Panel1.Add (New JLabel ("Datensatz löschen:")); panel1.add (löschen); panel2.Add (New JLabel ("Record:")); panel2.Add (Änderung); panel2.Add (New JLabel ("Query Record:")); Panel2.Add (Abfrage); Panel3.Add (New JLabel ("Show); Panel4.Add (Panel1); Panel4.Add (Panel2); Panel4.Add (Panel3); Panel5.Add (Bereich); Panel.Add (Panel5, BorderLayout.South); Panel.Add (Panel4, BorderLayout.Center); STMT = Conn.CreateStatement (resultset.type_scroll_sensitive, resultset.concur_updatable); STMT2 = CONN.CREATELTATIONS (ERGEBNISSETZUNGEN). // setResible (false); if (add.getSelectedIndex () == 1) {ta.Append ("-> Collection Record/n"); Nummer "," Schülernummer ", 2);} else if (add.getSelectedIndex () == 3) {ta.Append ("-> add Student Record/n "); Ta.Append ("-> Sammlungsprotokoll/n"); if (delete.getSelectedIndex () == 3) {Ta.Append ("-> Student Record/n"); A1 = Neue AddInformation ("Buchnummer", "Inventarnummer", 7); if (query.getSelectedIndex () == 1) {ta.Append ("-> Abfrage nach Buchtitel/N"); } else if (query.getSelectedIndex () == 3) {Ta.Append ("-> Abfrage-Student-Rekorde/n"); Nummer ", 12);} query.setSelectedItem (" Bitte wählen Sie die Operation aus "); if (show.getSelectedIndex () == 1) {Ta.Append ("-> Alle Sammlungsdatensätze/n "); try {rst = stmt.executeQuery (" ausgewählt *); rst.first (); ta.append("------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ta.Append ("/t"+id+"/t"+name+"/t"+num+"/n"); Ausführung verweist der Cursor auf die letzte Position der letzten Zeile, rst.First (); ta.Append ("------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ rst1 = stmt1.executeQuery ("aus BS"); ta.Append ("---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Utildate = (java.util.date) calendar.getTime (); ta.Append ("/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.Append ("------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Ta.SetCaretPosition (ta.GetText (). Länge ()); Ta.Append ("---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Ta.Append (id+""+"name+" "marke+" "preis+" "+"/n "); "+brand+" "+preis+" "+stock+"/n ");} // Nach der Ausführung verweist der Cursor auf die letzte Position der letzten Zeile rst.absolute (a); Ta.Append ("---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------/

3.Addinformation.java // Ereignisse behandeln

 Paketdatenbank; import Javax.swing. quxiao = new Jbutton ("Cancel"); JTextField jtf1 = new JTextField (10), jtf2 = new JTextField (10), jtf3 = new JTextField (10); Verbindung conn = null; static {try {class.forname ("com.mysql.jdbc.driver"); } catch (Ausnahme e) {e.printstacktrace ();}} int x = 0; public Connection getConnection () löscht sqlexception {if (conn == null) {conn = driverManager.getConnection ("jdbc: mysql: // localhost: 8088/bibliothek? useUnicode = true & charakteristisches und charakteristisch = utf-8 & uSessl = false", "Wurzel", "11111"); } return conn; } addinformation (String S1, String S2, String S3, int m) {jpanel p = new jpanel (); P.SetLayout (neuer FlowLayout ()); 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 (sicher); P.Add (Quxiao); add (p); if (m == 8) {joptionpane.showMessagedialog (NULL, "Das Buchdatum sollte im XXXX-XX-XX-Format sein!", "Warnung", joptionpane.warning_message); } setSize (500, 100); setvisible (wahr); setDefaultCloseOperation (jframe.dispens_on_close); setLocationRelativeto (null); Sure.AddactionListener (this); quxiao.addactionListener (this); x = m; } addinformation (String S1, String S2, int m) {jpanel p = new jpanel (); P.SetLayout (neuer FlowLayout ()); P.Add (New Jlabel (S1)); P.Add (jtf1); P.Add (New Jlabel (S2)); P.Add (jtf2); P.Add (sicher); P.Add (Quxiao); add (quxiao); add (p); SetSize (500, 100); setvisible (wahr); setDefaultCloseOperation (jframe.dispens_on_close); setLocationRelativeto (null); Sure.AddactionListener (this); quxiao.addactionListener (this); x = m; } addinformation (String S1, int m) {jpanel p = new jpanel (); P.SetLayout (neuer FlowLayout ()); P.Add (New Jlabel (S1)); P.Add (jtf1); if (m == 4) {joptionpane.showMessagedialog (null, "Wenn es einen Kreditaufzeichnung gibt, können die Buchinformationen nicht gelöscht werden!", "Warnung", joptionpane.warning_message); } if (m == 6) {joptionpane.showMessagedialog (null, "Wenn es einen Kreditaufzeichnung gibt, können die Schülerinformationen nicht gelöscht werden!", "Warnung", joptionpane.warning_message); } P.Add (sicher); P.Add (Quxiao); add (p); setSize (500, 80); setvisible (wahr); setDefaultCloseOperation (jframe.dispens_on_close); setLocationRelativeto (null); Sure.AddactionListener (this); quxiao.addactionListener (this); x = m; } public void actionPerformed (actionEvent ae) {if (ae.getSource () == sicher) {if (x == 1) {// Fügen Sie die Sammelrekordstring sql = "In Buchwerte einfügen (?,?,?)"; try (connection conn = getConnection (); preparedStatement stmt = conn.preparestatement (SQL)) {int id = integer.parseInt (jtf1.getText ()); String name = jtf2.getText (); int num = integer.parseInt (jtf3.getText ()); stmt.setint (1, id); stmt.setstring (2, name); stmt.setint (3, num); stmt.executeUpdate (); Framedemo.a.ta.Append ("-> Erfolg/n"); } catch (Ausnahme x) {Framedemo.a.ta.Append ("-> Fehler/n"); X.printStackTrace ();} addinformation.this.disponse (); } if (x == 2) {// Fügen Sie eine Ausleihrekordstring SQL = "In BS (bookId, stDid, Datum) Werte (?,?,?)" hinzu; String SQL1 = "ID, Num aus Buch Where id =?"; String sql2 = "Wählen Sie ID aus STD WHERE ID =?"; try {Connection conn1 = getConnection (); PreparedStatement stmt1 = conn1.preparestatement (SQL1, resultset.type_scroll_sensitive, resultset.concur_updatable); STMT1.Setint (1, Integer.ParseInt (jtf1.Getext ())); ResultSet rst1 = stmt1.executeQuery (); // Siehe, ob es dieses Buch gibt und ob das Inventar 0 ist, wenn (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 (); Verbindung conn2 = getConnection (); PreparedStatement stmt2 = conn2.Parestatement (SQL2); STMT2.Setint (1, Integer.ParseInt (jtf2.Getext ())); ResultSet rst2 = stmt2.executeQuery (); // jemand if (rst2.Next ()) {Connection conn = getConnection (); PreparedStatement stmt = conn.preparestatement (SQL); int bookId = integer.parseInt (jtf1.getText ()); int stdid = integer.parseInt (jtf2.GIETTEXT ()); stmt.setint (1, bookId); stmt.setint (2, stDid); stmt.setDate (3, neues Datum (System.currentTimemillis ())); stmt.executeUpdate (); Framedemo.a.ta.Append ("-> Erfolg/n"); } else{frameDemo.a.ta.append("-->No student record, no borrowing record/n");} }else{frameDemo.a.ta.append("-->No this book or has been borrowed all/n");} } }catch(Exception x){frameDemo.a.ta.append("-->Insert error/n"); X.printStackTrace ();} addinformation.this.disponse (); } if (x == 3) {// Fügen Sie die Schülerrekordstring sql = "in STD -Werte einfügen (?,?)"; try (connection conn = getConnection (); preparedStatement stmt = conn.preparestatement (SQL)) {int id = integer.parseInt (jtf1.getText ()); String name = jtf2.getText (); stmt.setint (1, id); stmt.setstring (2, name); stmt.executeUpdate (); Framedemo.a.ta.Append ("-> Erfolg/n"); } catch (Ausnahme x) {Framedemo.a.ta.Append ("-> Fehler/n"); X.printStackTrace ();} addinformation.this.disponse (); } if (x == 4) {// Die Buchrekordstring sql = "Aus Buch löschen Where id =?"; String SQL1 = "SELECT * aus BS WHERE BOOKID =?"; try {Connection conn1 = getConnection (); PreparedStatement stmt1 = conn1.Parestatement (SQL1); STMT1.Setint (1, Integer.ParseInt (jtf1.Getext ())); ResultSet rst1 = stmt1.executeQuery (); if (rst1.next ()) {// Es gibt ein Buch im Kreditaufzeichnung, joptionpane.showMessagedialog (NULL, "Es gibt ein Ausleihendatensatz für das Buch in der Kreditaufzeichnung!", "Warnung", joptionpane.warning_message); } else {// Es gibt kein Buch im Kreditaufzeichnung, Verbindung conn = getConnection (); PreparedStatement 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 ("-> Fehler/n"); Joptionpane.showmessagedialog (null, "Die Buchinformationen existieren nicht!", "Warnung", joptionpane.warning_message); } else framedemo.a.ta.append ("-> erfolgreich löschen/n"); }} catch (Ausnahme x) {Framedemo.a.ta.Append ("-> Deletion fehlgeschlagen/n"); x.printstacktrace ();} addinformation.this.dispose (); } if (x == 5) {// Löschen Sie das Buch Ausleihenrekord Zeichenfolge SQL = "Aus BS, wo bookId =? und stdid =?"; String SQL1 = "ID, Num aus Buch Where id =?"; try {Connection conn = getConnection (); PreparedStatement stmt = conn.preparestatement (SQL); int bookId = integer.parseInt (jtf1.getText ()); int stdid = integer.parseInt (jtf2.GIETTEXT ()); stmt.setint (1, bookId); stmt.setint (2, stDid); int t = stmt.executeUpdate (); if (t! = 0) {Verbindung conn1 = getConnection (); PreparedStatement stmt1 = conn1.preparestatement (SQL1, resultset.type_scroll_sensitive, resultset.concur_updatable); STMT1.Setint (1, Integer.ParseInt (jtf1.Getext ())); ResultSet 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 ("-> den Kreditaufzeichnung erfolgreich/n"); } else {Framedemo.a.ta.append ("-> Fehler/n"); Joptionpane.showmessagedialog (null, "Dieser Kreditaufzeichnung existiert nicht!", "Warnung", joptionpane.warning_message); }} catch (Ausnahme x) {Framedemo.a.ta.Append ("-> Fehler/n"); X.printstacktrace ();} addinformation.this.disponse (); } if (x == 6) {// Student Record String SQL = "Aus STD löschen wobei id =?"; String SQL1 = "SELECT * aus BS WO STDID =?"; try {Connection conn1 = getConnection (); PreparedStatement stmt1 = conn1.Parestatement (SQL1); STMT1.Setint (1, Integer.ParseInt (jtf1.Getext ())); ResultSet rst1 = stmt1.executeQuery (); if (rst1.next ()) {// Die Person befindet sich in der Kreditaufzeichnung, joptionpane.showmessagedialog (null, "Die Person ist in der Kreditaufzeichnung!", "Warnung", joptionpane.warning_message); } else {Connection conn = getConnection (); PreparedStatement 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 ("-> Fehler/n"); Joptionpane.showMessagedialog (null, "Die Student -Aufzeichnung existiert nicht!", "Warnung", joptionpane.warning_message); } else framedemo.a.ta.append ("-> erfolgreich löschen/n"); }} catch (Ausnahme x) {Framedemo.a.ta.Append ("-> Fehler/n"); X.printstacktrace ();} addinformation.this.disponse (); } if (x == 7) {// Buchinventarrekord Zeichenfolge SQL = "Buch -set num =? Wo id =?"; try (connection conn = getConnection (); preparedStatement 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 ("-> Modifikationsfehler/n"); JOPTIONPANE.SHOWMESSAGEDIALOG (NULL, "Das Buchaufzeichnung existiert nicht!", "Warnung", joptionpane.WARNING_MESSAGE); } else framedemo.a.ta.append ("-> Modifikationsdatensatz ist erfolgreich/n"); } catch (Ausnahme x) {Framedemo.a.ta.Append ("-> Modifikationsfehler/n"); X.printStackTrace ();} addinformation.this.disponse (); } if (x == 8) {// Ändern Sie das zu zurückgegebene Datum SQL = "BS SET DATUM =? WO BOOKID =? und STDID =?"; try (connection conn = getConnection (); preparedStatement stmt = conn.preparestatement (SQL)) {Datum Date = Date.ValueOf (jtf3.GetText ()); Kalenderkalender = neuer Gregoriancalendar (); Kalender.Settime (Datum); Calendar.add (Calendar.date, -30); java.util.date utildate = (java.util.date) calendar.getTime (); Utildate = (java.util.date) calendar.getTime (); Datum newdate = new Datum (Utildate.getTime ()); int stdid = integer.parseInt (jtf2.GIETTEXT ()); 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 ("-> Modifikationsfehler/n"); Joptionpane.showmessagedialog (null, "Die Kreditaufzeichnung existiert nicht!", "Warnung", joptionpane.warning_message); } else framedemo.a.ta.append ("-> Modifikationsdatensatz ist erfolgreich/n"); } catch (Ausnahme x) {Framedemo.a.ta.Append ("-> Modifikationsfehler/n"); X.printStackTrace ();} addinformation.this.disponse (); } if (x == 9) {// Abfrage string sql = "SELECT * aus Buch Where name =?"; ResultSet rst = null; try (connection conn = getConnection (); preparedStatement stmt = conn.preparestatement (SQL)) {String name = jtf1.getText (); stmt.setString (1, Name); 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 ("-> Abfrageberechnung/n"); x.printstacktrace ();} addinformation STMT = Conn.Preparestatement ( framedemo.a.ta.append ("-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ JOPTIONPANE.SHOWMESSADEILOG (NULL, "Das Buch existiert nicht!", "WARNUNG", JOPTIONPANE.WARNING_MESSAGE); // Abfrage string rst = stmt.executeQuery (); frameDemo.a.ta.append("------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Kalender.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 = "SELECT * aus STD, wobei 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-Fehler/n"); x.printstacktrace ();} addinformation }}

Das obige ist der gesamte Inhalt dieses Artikels. Ich hoffe, es wird für das Lernen aller hilfreich sein und ich hoffe, jeder wird Wulin.com mehr unterstützen.