How to get input from user and search from database and display results in a table format?

[Ashwin Kumar Balasubramanian]

Hi Friends,
I want to look up the database for an input given by the user which is searched from the database. This then displays the information in the form of a table. Am a newbie to java and swing. can you all please help me with this please.
My Database looks like this:

FIRST | SECOND | RESULT
1 | 2 | 3
5 | 7 | 8
7 | 4 | 2

If the user types the number " 1 " it must display the whole data like

FIRST | SECOND | RESULT
1 | 2 | 3

I had written a code for this. How to incorporate this into the prepared statement? Am not getting the output but an error.

public class promo_new {

	/**
	 * @wbp.parser.entryPoint
	 */
	public static void main (String [] args)throws SQLException, Exception, Exception, Exception {
	
		String in = JOptionPane.showInputDialog(args);
		Connection connection;
		Class.forName("com.mysql.jdbc.Driver").newInstance();
		connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/testdb","root","root");
		
		String sql=("select * from addition where first = ? ");
		PreparedStatement pst = connection.prepareStatement(sql);
		pst.setString(1, "%" + in + "%");
	
		ResultSet rs = pst.executeQuery(sql);
		
		while (rs.next())
		{
			String output1= rs.getString("first");
			System.out.println(output1 );
                        String output2= rs.getString("second");
			System.out.println(output2 );
                        String output3= rs.getString("result");
			System.out.println(output3 );
			
		}
	
}
}

Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?' at line 1
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2713)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2663)
	at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1599)
	at com.tcs.promotion.promo_new.main(promo_new.java:32)

Please help me with this code..:'( :'(

[Rob Spoor]

Use executeQuery() instead of executeQuery(sql). With the latter you're asking the PreparedStatement to ignore the special meaning of the question mark and just execute the query as it is. With the former the PreparedStatement takes the query as you've used to create it with all the parameters you've set for it.

[Ashwin Kumar Balasubramanian]

Hi Rob Thank you so much.. Got it.. ya you were correct. THANK YOUUUUUU..

[Rob Spoor]

You're welcome.