welcomebean.java~27~

Name: Book shop manager. 开发语言: Java

package bookmanager;
import java.sql.ResultSet;
import java.sql.SQLException;
import bookmanager.*;

/**
 * <p>Title: 图书管理</p>
 *
 * <p>Description: 大型软件实习项目</p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: 武汉大学计算机学院</p>
 *
 * @author 王佳
 * @version 1.0
 */


public class WelcomeBean {
    private String bkcname="";
    private String bkname="";
    private String bkauthor="";
    private String bkpublish="";

    private ResultSet rs1=null;
    private ResultSet rs2=null;
    private String outTable="";
    private String sql="";

    public WelcomeBean() {

    }


 public   ResultSet findbkclass ()
           {
                 dbconnBean dbconn=new dbconnBean();
                //System.out.println(bkcname+"     "+bkname);
               rs1=dbconn.executeQuery("select bkcname from bookclass");
               return rs1;
           }

   public String printInfo(){
        dbconnBean dbconn=new dbconnBean();
       //System.out.println(bkcname+"     "+bkname);
       if (bkname.equals("") && bkauthor.equals("") && bkpublish.equals(""))
           sql = "SELECT bkname, edition, bkpublish, bkauthor, bkcname, COUNT(*) AS account FROM bk_bkclass WHERE (bkcname LIKE '" +
                 bkcname +
                 "') GROUP BY bkname, edition, bkpublish, bkauthor, bkcname ";

       if (!bkname.equals("") && bkauthor.equals("") && bkpublish.equals(""))
           sql = "SELECT bkname, edition, bkpublish, bkauthor, bkcname, COUNT(*) AS account FROM bk_bkclass WHERE (bkcname LIKE '" +
                 bkcname + "') AND (bkname LIKE '" + bkname +
                 "')  GROUP BY bkname, edition, bkpublish, bkauthor, bkcname ";
       if (!bkname.equals("") && !bkauthor.equals("") && bkpublish.equals(""))
           sql = "SELECT bkname, edition, bkpublish, bkauthor, bkcname, COUNT(*) AS account FROM bk_bkclass WHERE (bkcname LIKE '" +
                 bkcname + "') AND (bkname LIKE '" + bkname +
                 "') AND (bkauthor LIKE '" + bkauthor +
                 "') GROUP BY bkname, edition, bkpublish, bkauthor, bkcname ";
       if (!bkname.equals("") && !bkauthor.equals("") && !bkpublish.equals(""))
          sql = "SELECT bkname, edition, bkpublish, bkauthor, bkcname, COUNT(*) AS account FROM bk_bkclass WHERE (bkcname LIKE '" +
                bkcname + "') AND (bkname LIKE '" + bkname +
                "') AND (bkauthor LIKE '" + bkauthor +
                "') AND (bkpublish LIKE '" + bkpublish +
                "') GROUP BY bkname, edition, bkpublish, bkauthor, bkcname ";
      if (bkname.equals("") && !bkauthor.equals("") && bkpublish.equals(""))
           sql = "SELECT bkname, edition, bkpublish, bkauthor, bkcname, COUNT(*) AS account FROM bk_bkclass WHERE (bkcname LIKE '" +
                 bkcname + "') AND (bkauthor LIKE '" + bkauthor +
                 "')  GROUP BY bkname, edition, bkpublish, bkauthor, bkcname ";
       if (bkname.equals("") && !bkauthor.equals("") &&! bkpublish.equals(""))
           sql = "SELECT bkname, edition, bkpublish, bkauthor, bkcname, COUNT(*) AS account FROM bk_bkclass WHERE (bkcname LIKE '" +
                 bkcname + "') AND (bkauthor LIKE '" + bkauthor +
                 "') AND ( bkpublish LIKE '" +  bkpublish+
                 "')  GROUP BY bkname, edition, bkpublish, bkauthor, bkcname ";
       if (!bkname.equals("") && bkauthor.equals("") && !bkpublish.equals(""))
           sql = "SELECT bkname, edition, bkpublish, bkauthor, bkcname, COUNT(*) AS account FROM bk_bkclass WHERE (bkcname LIKE '" +
                 bkcname + "') AND (bkpublish LIKE '" + bkpublish +
                 "')  GROUP BY bkname, edition, bkpublish, bkauthor, bkcname ";
       rs2=dbconn.executeQuery(sql);
       try {
           while (rs2.next()) {
               String bn=rs2.getString("bkname");
               outTable = " <tr>"
                          + "<td>"+bn+"</td>"
                          + "<td>"+rs2.getString("edition")+"</td>"
                          + "<td>"+rs2.getString("bkcname")+"</td>"
                          + "<td>"+rs2.getString("bkauthor")+"</td>"
                          + "<td>"+rs2.getString("bkpublish")+"</td>"
                          + "<td>"+rs2.getString("account")+"</td>"
                          + "<td><a href=detail.jsp&bkname="+bn+">详细信息</a>|<a href=booking.jsp&bkname="+bn+">预借</a></td>"
                          + "</tr>";
           }
       } catch (SQLException ex) {
              System.out.println("异常在printinfo()zhong");
       }


       return outTable;
   }








    public void setBkcname(String bkcname) {
        this.bkcname = bkcname;
    }

    public void setBkname(String bkname) {
        this.bkname = bkname;
    }

    public void setBkauthor(String bkauthor) {
        this.bkauthor = bkauthor;
    }

    public void setBkpublish(String bkpublish) {
        this.bkpublish = bkpublish;
    }

    public String getBkcname() {
        return bkcname;
    }

    public String getBkname() {
        return bkname;
    }

    public String getBkauthor() {
        return bkauthor;
    }

    public String getBkpublish() {
        return bkpublish;
    }
    public static void main(String [] args){
        WelcomeBean a=new WelcomeBean();
        //a.setBkcname("asfdasdf");
        System.out.println(a.bkcname+"     "+a.bkname);
    }

}