Search requires entire field contents, but I want to search by only a few letters

Question

I am using Sqlite, and this is the code I have written for my database and a picture of my program running showing the dilemma.

I have to input the full text of table field to get search result. BUT I want to enter only a few letters to bring up results.

private void txt_SearchKeyReleased(java.awt.event.KeyEvent evt) {                                       
    // TODO add your handling code here:


    try {

        String sql ="select * from GameList1 where Name =?";
        pst=conn.prepareStatement(sql);
        pst.setString(1, txt_Search.getText());

        rs=pst.executeQuery();
        if(rs.next()) {

            String add1=rs.getString("GameID");
            txt_GameID.setText(add1);
            String add2=rs.getString("Name");
            txt_Name.setText(add2);
            String add3=rs.getString("Company");
            txt_Company.setText(add3);
            String add4=rs.getString("Format");
            txt_Format.setText(add4);
            String add5=rs.getString("YearMade");
            txt_Year.setText(add5);
            String add6=rs.getString("YearReleased");
            txt_Release.setText(add6);


        }
    }
}

drgPP · Accepted Answer · 2014-11-25T11:48:59.757

0

I assume that you want to retrieve data from database by typing only few letters and not searching by full row value. If this is the problem than the solution would be LIKE operator.

Example:

try {
    String sql ="select * from GameList1 where Name LIKE ?";
    String PERCENTAGE_SIGN="%";
    pst=conn.prepareStatement(sql);
    pst.setString(1, PERCENTAGE_SIGN+txt_Search.getText()+PERCENTAGE_SIGN);

    rs=pst.executeQuery();
    if(rs.next()) {

        String add1=rs.getString("GameID");
        txt_GameID.setText(add1);
        String add2=rs.getString("Name");
        txt_Name.setText(add2);
        String add3=rs.getString("Company");
        txt_Company.setText(add3);
        String add4=rs.getString("Format");
        txt_Format.setText(add4);
        String add5=rs.getString("YearMade");
        txt_Year.setText(add5);
        String add6=rs.getString("YearReleased");
        txt_Release.setText(add6);


                     }
    }

edited Nov 25 '14 at 11:48

answered Nov 25 '14 at 11:34

drgPP

926
2
7
22

private void txt_SearchKeyReleased(java.awt.event.KeyEvent evt) { is above the try, catch statements. – clifford cooper Nov 25 '14 at 11:36
i will try these steps give me bout 3 mins – clifford cooper Nov 25 '14 at 11:40
i get "java.sql.SQLException: near "%". syntax error – clifford cooper Nov 25 '14 at 11:43
Try using PERCENTAGE_SIGN as arun xavy suggested and make sure you close correctly all opened bracers of try and if block. – drgPP Nov 25 '14 at 11:45
"java.lang.RuntimeException: Uncompatible source code - Erroneous tree type: – clifford cooper Nov 25 '14 at 11:49
Can you please provide the full stacktrace? I assume you are using netbeans, if so, check this post http://stackoverflow.com/questions/2333285/java-lang-runtimeexception-uncompilable-source-code-what-can-cause-this to display properly compile errors. – drgPP Nov 25 '14 at 11:53
FOUND IT thank you yes you are right it is LIKE ? and the "%" + txt_Search.getText() + "%"); – clifford cooper Nov 25 '14 at 11:57

Search requires entire field contents, but I want to search by only a few letters

1 Answers1