title: mysql float type
body: <p>I have a database <code>order</code> with <code>price</code> and <code>deposit</code> fields set to float type. I am also implemeting a java gui to search the order, the problem is when I try to search for the orders in the database I dont find anything because it saves price=55.0 when I convert from string to float and in the database it saves as 55. What is the problem?
  what type should I use to represent currency from the two sides, java side and mysql side?</p>
  
  <pre><code>private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {        
      try{
          //collect arguments
          String category = this.jTextField8.getText();
          String pattern=this.jTextArea1.getText();
          String color=this.jTextArea2.getText();
          float price = Float.valueOf(this.jTextField14.getText()).floatValue();
          float deposit = Float.valueOf(this.jTextField15.getText()).floatValue();
  
          //create new order
          int row=this.customerSelectedRow;
          Order newOrder=new order(this.customerModel.dataVector.get(row),category,pattern,color,price,deposit);
          newOrder.search();           
          //refresh
          this.jDialogNewOrder.setVisible(false);
  
      }catch(Exception e){
           System.err.println (" Error message: " + e.getMessage ());
      }
  
  }                     
  </code></pre>
  
  <p>here is the code for the search method</p>
  
  <pre><code>try {
                  s = c.conn.prepareStatement("SELECT id FROM `"+this.table+
                          "` WHERE customerId=? AND category=? and pattern=? and color=? and deposit=? and price=?");
                  s.setInt(1,this.customer.getId());
                  s.setString (2, this.category);
                  s.setString (3, this.pattern);
                  s.setString (4, this.color);
                  s.setFloat(5,this.deposit);
                  s.setFloat(6,this.price);
                  System.err.println(s.toString());
                  ResultSet res = s.executeQuery();
  
                  System.out.println("printing ids :");
                  while (res.next()) {
                    int i = res.getInt(1);
                    //assigning the correct id to the inserted customer
                    this.id=i;
                    System.out.println("id" + "=" + i);
                  }
              } catch (SQLException e) {
                  System.err.println ("find id Error message: " + e.getMessage ());
                  System.err.println ("find id Error number: " + e.getErrorCode ());
  </code></pre>