[RESOLVED] database with GUI

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**

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();
}

}

---

**gui.java**

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();
       
        }




}

---

Looks like a problem with the character set. Is the data saved in the database in unicode format? Also check the language settings of the database and of the computer which is running the app.

.

Quote:

---

Originally Posted by honeybee

Looks like a problem with the character set. Is the data saved in the database in unicode format? Also check the language settings of the database and of the computer which is running the app.

.

---

thanks for replying :)

i'm using MS Access 2010 and then i saved the table with 2003 format. I've set the datatype as text for all field, can you tell me if i'm wrong?:)
any help would be appreciated.

Can you try saving the table in 2010 format? Does 2003 support unicode?

.

Can you post the contents of that table ?

Is it like this:

Code:

---


First Name  |  Last Name
------------------------
Ali | Khan
aash | Vbforums
....


---

Does it contain anything else after the name ? Any spaces ?

Also, try these:

Code:

---

t1.setText(rs.getString("fname").trim());
t2.setText(rs.getString("lname").trim());

---

I don't have Java installed in my PC right now. So, what I am posting is all just my assumptions.

:wave:

Quote:

---

Originally Posted by akhileshbc

Can you post the contents of that table ?

Is it like this:

Code:

---


First Name  |  Last Name
------------------------
Ali | Khan
aash | Vbforums
....


---

Does it contain anything else after the name ? Any spaces ?

Also, try these:

Code:

---

t1.setText(rs.getString("fname").trim());
t2.setText(rs.getString("lname").trim());

---

I don't have Java installed in my PC right now. So, what I am posting is all just my assumptions.

:wave:

---

wow, you're awesome. The trim() has solved my problem,
thanks. :)