[SOLVED] database connection

[casid]

Hi people,

I have problem with getting value from textfield s text and use it in sql query ,and another problem is using data in textare field. could you pls tell me the problem here,

public void nameSearch(){
		
    name=jTextField1.getText();

	try {
		
		Class.forName(JDBC_DRIVER).newInstance();
	    con= DriverManager.getConnection(DATABASE_URL,USERNAME,PASSWORD);
	    stm=con.createStatement();
	    rs=stm.executeQuery("select * from guest where firstname="+name+"");
 
	    while(rs.next()){
	    	
	     	jTextArea1.setText(rs.getString("firstname"));
	    }
	stm.close();
	con.close();
	} catch (Exception e) {
		// TODO: handle exception
		e.getCause();
	}
		
	}

when I write sql code by manually, giving value by myself, program runs however that textarea gets only one data although there are more datas.



thank you for any support,

[hawaiian robots]

public void nameSearch(){
		
    name=jTextField1.getText();

	try {
		
		Class.forName(JDBC_DRIVER).newInstance();
	    con= DriverManager.getConnection(DATABASE_URL,USERNAME,PASSWORD);
	    stm=con.createStatement();
	    rs=stm.executeQuery("select * from guest where firstname="+name+"");
            // clear the text area.
            jTextArea1.setText("");
	    while(rs.next()){
	    	// add the data to the text area.
	     	jTextArea1.append(rs.getString("firstname") + "\n");
	    }
	stm.close();
	con.close();
	} catch (Exception e) {
		// TODO: handle exception
		e.getCause();
	}
		
	}

The problem that you where setting the text area text, which erases the text that was there before it, so what you needed to do is append the text to it.

[casid]

do you have any idea how to get textfield s value for my sql query,?

thank you hawaiin robots ,

Ok I handled it, '"+name+"' is the solution. thanks again

[RamyaSivakanth]

Hi,
One small suggestion here.Anyway, you are going to set the value dynamically for the query.In order to avoid query formation errors, you
can use PreparedStatement like this below.

Ex:

PreparedStatement ps = con.prepareStatement("select * from guest where firstname = ?");
ps.setString(1,name);

[casid]

thank you for your suggestion however that I havent used it, so how will I get the result data.?
which of method return query result ? you know with resultset

rs=stm.executeQuery("select * from guest where firstname="+name+"");
// clear the text area.
jTextArea1.setText("");
while(rs.next()){
// add the data to the text area.
jTextArea1.append(rs.getString("firstname") + "\n");
}

thank you for your help.

[RamyaSivakanth]

Hi,

Go thru this piece of code for returning the ResultSet.
PreparedStatement ps =
con.prepareStatement("select * from guest where firstname = ?");
ps.setString(1,name);
ResultSet rs = ps.executeQuery();

Also please go thru this link for better understanding of ResultSet.
Using Prepared Statements (The Java™ Tutorials > JDBC(TM) Database Access > JDBC Basics)

-Regards
Ramya

[casid]

thank you very much

[casid]

thank you RamyaSivakanth,

[RamyaSivakanth]

Please close the thread if it is solved.