java.sql.SQLException Parameter index out of range

Question

While am using this code it shows java.sql.SQLException Parameter index out of range (1 > number of parameters, which is 0):

private void cmd_searchActionPerformed(java.awt.event.ActionEvent evt) {                                           
try{

 String sql = "select * from STD where Name like '%?%' ";
      pst=conn.prepareStatement(sql);
      pst.setString(1,TXT_STUDENTNAME.getText());
      String value=TXT_STUDENTNAME.getText();
      rs=pst.executeQuery();
       jTable1.setModel(DbUtils.resultSetToTableModel(rs));

             }catch(Exception e){
       JOptionPane.showMessageDialog(null,e);
   }        
}

How can i recover from this exception?

Community · Accepted Answer · 2017-05-23 12:15:13Z

2

Try to remove the wildcard from the sql and add it to the value:

String sql = "select * from STD where Name like ? ";
pst=conn.prepareStatement(sql);
pst.setString(1,"%"+TXT_STUDENTNAME.getText()+"%");

Comments

sarath · Accepted Answer · 2012-11-10 06:27:41Z

0

private void cmd_searchActionPerformed(java.awt.event.ActionEvent evt) {                                           
try{

 String sql = "select * from STD where Name like '%?%' ";
      String strStudentName = TXT_STUDENTNAME.getText();
      pst=conn.prepareStatement(sql);
      pst.setString(1,strStudentName );
      rs=pst.executeQuery();
       jTable1.setModel(DbUtils.resultSetToTableModel(rs));

             }catch(Exception e){
       JOptionPane.showMessageDialog(null,e);
   }        
}

I think this will help you..

String strStudentName = TXT_STUDENTNAME.getText(); pst.setString(1,strStudentName );

answered Nov 10, 2012 at 6:27

sarath

90313 silver badges20 bronze badges

Collectives™ on Stack Overflow

java.sql.SQLException Parameter index out of range

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related