hi all,
please someone help me, i'm got stuck in a problem. i'm getting weird output. below is my code, and i'm getting output having blocks with data displayed in textboxes..
plz take a look and tell me what i'm doing wrong,
**db.java**
**gui.java**Code:import java.sql.*; class db { Statement st; Connection con; ResultSet rs; public db() { connect(); } public void connect() { try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url="jdbc:odbc:data1"; con=DriverManager.getConnection(url); st=con.createStatement(); String sql="select * from Table1"; rs=st.executeQuery(sql); /*while(rs.next()) { String name=rs.getString("fname"); String lname=rs.getString("lname"); System.out.println(name+" "+lname); }*/ //con.close(); } catch(Exception ex) { System.out.println(ex); } } public static void main(String args[]) { new db(); new GUI(); } }
Code:import javax.swing.*; import java.awt.*; import java.awt.event.*; class GUI extends db { JFrame f; JTextField t1; JTextField t2; JLabel l1; JLabel l2; public void inGUI() { f=new JFrame(); Container c=f.getContentPane(); c.setLayout(new FlowLayout()); l1=new JLabel("First name"); t1=new JTextField(10); l2=new JLabel("Second name"); t2=new JTextField(10); c.add(l1); c.add(t1); c.add(l2); c.add(t2); f.setSize(400,400); f.setVisible(true); f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); try{ rs.next(); t1.setText(rs.getString("fname")); t2.setText(rs.getString("lname")); } catch(Exception ex) { System.out.println(ex); } } public GUI() { inGUI(); } public static void main(String args[]) { new GUI(); } }




Reply With Quote