Re: Help: Java database manipulation using NetBeans
On Sep 20, 3:52 am, "John B. Matthews" <nos...@nospam.invalid> wrote:
In article
<16ff99be-2330-4a45-9ccd-c2a1f20f9...@z11g2000prl.googlegroups.com>,
tobleron <bud...@yahoo.com> wrote:
Hi, I'm using Netbeans IDE to create a form and want to insert data
from the swing component into the database. I'm using MySQL. I want to
insert the data by clicking the submit button. But I'm confusing how
to make the correct code. Here is my code. I know this still has a lot
of errors. Please give me advise. Thx before.
Among other things, your code never defines the name of the table and
columns to use. First, see if you can connect from java, then see if you
can insert a row in a table and view the result. Numerous examples may
be found here:
<http://java.sun.com/docs/books/tutorial/jdbc/basics/index.html>
<code>
import java.sql.*;
public class User {
public static void main(String args[]) {
String url = "jdbc:mysql://localhost:3306/mysql";
Connection con;
Statement stmt;
try {
Class.forName("com.mysql.jdbc.Driver");
} catch(java.lang.ClassNotFoundException e) {
System.err.println(e);
}
try {
con = DriverManager.getConnection(url, "name", "secret");
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(
"select user, host from user where user != ''");
while (rs.next()) {
String s1 = rs.getString(1);
String s2 = rs.getString(2);
System.out.println(s1 + "@" + s2);
}
stmt.close();
con.close();
} catch(SQLException e) {
System.err.println(e);
}
}}
</code>
--
John B. Matthews
trashgod at gmail dot com
home dot woh dot rr dot com slash jbmatthews
Hi, I already tried your sugestion, but I found result :
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
java.sql.SQLException: No suitable driver found for jdbc:mysql://
localhost:3306/dicom
But in the service window, I already run the connection to MySQL and
get no problem when executing SQL statement using "Execute
Command...". What happened ? FYI, I add an action into the
submitButton, so it should be send the data to MySQL server when the
button was clicked. Here is my code :
package ecgterminal;
import org.jdesktop.application.Action;
import java.sql.*;
public class ECGTerminalSetup extends javax.swing.JDialog {
public ECGTerminalSetup(java.awt.Frame parent) {
super(parent);
initComponents();
getRootPane().setDefaultButton(closeButton);
}
@Action public void closeAboutBox() {
setVisible(false);
}
@Action public void setup() {
String url = "jdbc:mysql://localhost:3306/dicom";
Connection con;
Statement stmt;
try {
Class.forName("com.mysql.jdbc.Driver");
} catch(java.lang.ClassNotFoundException e) {
System.err.println(e);
}
try {
con = DriverManager.getConnection(url, "dicom", "");
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(
"INSERT INTO ecgterminal
(terminalid,terminalname,insname,insaddr1,insaddr2) VALUES ('"+
terminalIdTxt +"','"+ terminalNameTxt +"','"+ insNameTxt +"','"+
insAddr1Txt +"','"+ insAddr2Txt +"')");
stmt.close();
con.close();
} catch(SQLException e) {
System.err.println(e);
}
}
// Variables declaration - do not modify
private javax.swing.JButton closeButton;
private javax.swing.JTextField insAddr1Txt;
private javax.swing.JTextField insAddr2Txt;
private javax.swing.JTextField insNameTxt;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JButton submitButton;
private javax.swing.JTextField terminalIdTxt;
private javax.swing.JTextField terminalNameTxt;
// End of variables declaration
}