wildcard search using jdbc

[krishna moorthyv]

i need to extract similarty keyword in my mysql database, so i am using wildcard search ,i try to print but it always print hash code value.... please any one help me
i'm using mysql 5.1 my schema name is search and my table name is totall

package container;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class JavaSearchDB {
	String url="jdbc:mysql://localhost:3306/search";
	
	
	Connection con=null;
	Statement st=null;
	ResultSet rs=null;
	
	
public void search(String s1) //string s1 is the input string given by the user 
{
	try
	{
		Class.forName("com.mysql.jdbc.Driver");
		 con=DriverManager.getConnection(url,"root","root");
		 st=con.createStatement();
		 rs=st.executeQuery("SELECT record FROM search.totall where record LIKE  "+"'s1%'");
		 System.out.println(rs);
	   
	catch(Exception e)
	{
		System.out.println("error" +"  "+e.getMessage());
	}
		
	}
}

[chris webster]

Use a PreparedStatement with bind variables instead of a dumb string for your SQL, then you can supply a wildcard value as the search-value in the bind variable. Also, you would normally loop through the rows returned in your ResultSet to extract the selected values. Here's an example.

[Jeanne Boyarsky]

Welcome to CodeRanch! I edited your post to add code tags to make it easier to read.

The problem is this:

 System.out.println(rs);  

rs is a Java object. To output the results, you need to loop through them as:

while (rs.next()) {
  System.out.println(rs.getString("record"))
}

[krishna moorthyv]

thanks to javaRanch i got an output.My mistake is i directly print the result set value instead of using
while(rs.next)
{
System.out.println(rs.getstring("record"));
}

[chris webster]

krish javabeginner wrote:thanks to javaRanch i got an output.

Well done! Now go and read about SQL injection and then try writing your program using a PreparedStatement instead to prevent this.