Re: Help: Java database manipulation using NetBeans
In article
<16ff99be-2330-4a45-9ccd-c2a1f20f9ddd@z11g2000prl.googlegroups.com>,
tobleron <budhik@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