CODEWITHSUNDEEP
javadatabaseinput
Afnan Humdan
Afnan Humdan

Reputation: 195

I want to get data from user and compare it with my database in java

as shown on the title, I have tried so hard to compare the user input with my database, it works with a true input, but when the input is not exist on my database I don't know what is the wrong on my below code, please help

 private class da implements ActionListener{
     public void actionPerformed(ActionEvent e){
               Connection con = null;
          Statement state = null;
          Statement state2 = null;
          ResultSet rs = null;
          ResultSet rs2 = null;
          String url = "jdbc:mysql://localhost:3306/المكتبة";
          String unicode = "?useUnicode=yes&characterEncoding=UTF-8";
      try{
    con = DriverManager.getConnection(url+unicode,"root","");
    state = con.createStatement();
    state2 = con.createStatement();
    rs = state.executeQuery("SELECT * FROM library WHERE author ='"+name.getText()+"'")
            ;
   rs2=state2.executeQuery("SELECT * FROM library WHERE bookname ='"+title.getText()+"'");




    while(rs.next()){
        String authorname = rs.getString("author");
        String bookname = rs.getString("bookname");
        String categort = rs.getString("category");
        int isbn = Integer.parseInt(rs.getString("ISBN"));
        String data = "اسم المؤلف: "+authorname+"\n"+"اسم الكتاب: "+bookname+"\n"+"التصنيف: "+categort+"\n"+"ISBN: "+isbn;



            if(name.getText().trim().equals(authorname))
                txt.setText(data);
            else
                txt.setText("dosen't exist");










    }

    while(rs2.next()){
        String authorname = rs.getString("author");
        String bookname = rs.getString("bookname");
        String categort = rs.getString("category");
        int isbn = Integer.parseInt(rs2.getString("ISBN"));
        String data2 = "اسم المؤلف: "+authorname+"\n"+"اسم الكتاب: "+bookname+"\n"+"التصنيف: "+categort+"\n"+"ISBN: "+isbn;
       txt.setText(data2);

    }
      }
      catch(Exception t){

      }

} }

}

Upvotes: 3

Views: 133

Answers (1)

Vivian Maya
Vivian Maya

Reputation: 518

First of all do not use string combining on sql queries, use PreparedStatement.

and try like this : 

PreparedStatement upd = connect.prepareStatement("select * from library where author=?");
upd.setString(1,VariableToholdAuthor);

ResultSet rs = upd.executeQuery();
while(rs.next())
{
  CompareVariable = rs.getString("name");
}

This will help you.

Upvotes: 1

Related Questions