Swing0528笔记

1：table表单清空：

  DefaultTableModel dtm = (DefaultTableModel) this.bookType.getModel();
  dtm.setRowCount(0);

2:combox

　　注意有时候默认选中的话最好前面加个判断.getItemCount()>0

2：多表查询

public ResultSet bookList(Connection con,Book book) throws Exception{
        StringBuffer sb = new StringBuffer("select * from t_book b ,t_booktype t where b.bookTypeId = t.id");
        if(StringUtil.isNotNull(book.getBookName())){
            sb.append(" and b.bookName like '%" + book.getBookName()+ "%'");
        }
        if(StringUtil.isNotNull(book.getAuthor())){
            sb.append(" and b.author like '%" + book.getAuthor()+ "%'");
        }
        if(book.getPrice()!=-1){
            sb.append(" and b.price = "+ book.getPrice());
        }
        if(StringUtil.isNotNull(book.getSex())){
            sb.append(" and b.sex ='" + book.getSex()+"'");
        }
        if(book.getBookTypeId()!=-1){
            sb.append(" and b.bookTypeId =" + book.getBookTypeId() );
        }
        
        PreparedStatement pstmt=con.prepareStatement(sb.toString());
        return pstmt.executeQuery();