public List getBooksByCost(String cost) {
   List al = new ArrayList();
   try {
     con = JdbcUtil.getMysqlConnection();
     ps = con.prepareStatement("select *from jlcbooks where cost=?");
     ps.setString(1, cost);
     rs = ps.executeQuery();
     while (rs.next()) {
       Book bo = new Book();
       bo.setBid(rs.getString(1));
       bo.setBname(rs.getString(2));
       bo.setAuthor(rs.getString(3));
       bo.setPub(rs.getString(4));
       bo.setCost(rs.getString(5));
       bo.setEdi(rs.getString(6));
       bo.setIsbn(rs.getString(7));
       al.add(bo);
     }
   } catch (Exception e) {
     e.printStackTrace();
   } finally {
     JdbcUtil.cleanup(ps, con);
   }
   return al;
 }
 @Override
 public void processAfterCopy(
     MaintenanceDocument document, Map<String, String[]> requestParameters) {
   Book book = ((Book) document.getNewMaintainableObject().getDataObject());
   book.setIsbn(null);
   super.processAfterCopy(document, requestParameters);
 }
Esempio n. 3
0
  @Override
  public boolean onOptionsItemSelected(MenuItem item) {
    // Handle action bar item clicks here. The action bar will
    // automatically handle clicks on the Home/Up button, so long
    // as you specify a parent activity in AndroidManifest.xml.
    int id = item.getItemId();

    //noinspection SimplifiableIfStatement
    if (id == R.id.action_save) {

      if (title.getText().toString().isEmpty()) title.setError("This field can't be empty.");
      else if (!price.getText().toString().matches("^\\d+$"))
        price.setError("It must be an integer.");
      else {
        currentBook.setTitle(title.getText().toString());
        currentBook.setAuthor(author.getText().toString());
        currentBook.setCourse(course.getText().toString());
        currentBook.setPrice(Integer.valueOf(price.getText().toString()));
        currentBook.setIsbn(isbn.getText().toString());
        SimpleBookManager.getInstance().saveChanges(this);
        setResult(RESULT_OK);
        finish();
        return true;
      }
    } else if (id == android.R.id.home) {
      onBackPressed();
      return true;
    }

    return super.onOptionsItemSelected(item);
  }
  @Override
  public void onQueryComplete(ResultSetFuture rsf) {
    log.info("QueryCompleted");
    Row row;
    try {
      row = rsf.get().one();
    } catch (Exception e) {
      throw new RuntimeException("Failed to get ResultSet from ResultSetFuture", e);
    }
    book = new Book();
    book.setIsbn(row.getString("isbn"));
    book.setTitle(row.getString("title"));
    book.setAuthor(row.getString("author"));
    book.setPages(row.getInt("pages"));

    done = true;
    log.info("DONE");
  }
 public Book getBookByBid(String bid) {
   Book bo = null;
   try {
     con = JdbcUtil.getMysqlConnection();
     ps = con.prepareStatement("select *from jlcbooks where bid=?");
     ps.setString(1, bid);
     rs = ps.executeQuery();
     if (rs.next()) {
       bo = new Book();
       bo.setBid(rs.getString(1));
       bo.setBname(rs.getString(2));
       bo.setAuthor(rs.getString(3));
       bo.setPub(rs.getString(4));
       bo.setCost(rs.getString(5));
       bo.setEdi(rs.getString(6));
       bo.setIsbn(rs.getString(7));
     }
   } catch (Exception e) {
     e.printStackTrace();
   } finally {
     JdbcUtil.cleanup(ps, con);
   }
   return bo;
 }