How to input SQL query to find the partial match from a string in SQLite Netbeans?

Question

I am trying to get the string from textfield and search it even if the string is partial.

  public void jTable1(){
            String a1=jTextField1.getText();
            try{
                String sql="select Instrument_ID, Name,Type,Version,Company,Status from Issue where Name like'"+a1+"'";
                String Sql;
                pst=conn.prepareStatement(sql);
                rs=pst.executeQuery();
                jTable1.setModel(DbUtils.resultSetToTableModel(rs));
            }catch(Exception e){
                JOptionPane.showMessageDialog(null, e);


            }
        }

Gurwinder Singh · Accepted Answer · 2017-01-22 04:51:18Z

1

Try this:

public void jTable1() {
    String a1 = jTextField1.getText();
    try {
        String sql = "select Instrument_ID, Name,Type,Version,Company,Status from Issue where Name like ? ";
        pst = conn.prepareStatement(sql);
        pst.setString(1, "%" + a1 + "%");
        rs = pst.executeQuery();
        jTable1.setModel(DbUtils.resultSetToTableModel(rs));
    } catch (Exception e) {
        JOptionPane.showMessageDialog(null, e);
    }
}

Use the parameterized SQL and set the string after suffixing and prefixing the % to it.

edited Jan 22, 2017 at 4:51

answered Jan 22, 2017 at 4:28

Gurwinder Singh

39.7k6 gold badges62 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Gurwinder Singh Over a year ago

@Raju Didnt work how? Does it give you wrong result? no result? error?

user6838104 Over a year ago

error:: method setString in Interface Prepred Statement cannot be applied to given types. required: int, string found: string

user6838104 Over a year ago

well i'm still confused

Collectives™ on Stack Overflow

How to input SQL query to find the partial match from a string in SQLite Netbeans?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related