Database

[tech]

Hi I have created a class as below

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;

import java.util.logging.Logger;


public class NewClass1 {
{

try {
Class.forName("sun.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/ant", "root", "")
try {
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("SELECT*FROM SF");
String jTextField1 = rs.getString("");



} catch (SQLException ex) {
Logger.getLogger(NewClass1.class.getName()).log(Le vel.SEVERE, null, ex);
}
} catch (SQLException ex) {
Logger.getLogger(NewClass1.class.getName()).log(Le vel.SEVERE, null, ex);
} catch (ClassNotFoundException ex) {
Logger.getLogger(NewClass1.class.getName()).log(Le vel.SEVERE, null, ex);
}

}



}




And created a form with a jTextField, a jbutton and a jtable. The scope is that when I type a name in the textfieldand press the button, the rest of the information that matches the data in the field will populate the table. I the data is stored in a database.

I don't know how to continue from here, any help please.

[JosAH]

I don't see a JTable anywhere, nor any other component. All I see is this:

String jTextField1 = rs.getString("");

Do you really have a database column labeled ""? First check if you can fetch your data from your database.

kind regards,

Jos

[Norm]

You need to work on the GUI part of your program. Use the JFrame class and then add the components to it that you need.
Read the Tutorial at The Java™ Tutorials about how to write GUI.
Also use Search on this forum for many samples of code for GUI.