index1bean.java~65~

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

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


public class Index1Bean extends dbconnBean {
    private String sample = "Start value";
    bookmanager.dbconnBean dbconn=new bookmanager.dbconnBean();
            ResultSet rs1,rs2,rs3;
            int i;
            int m;
            String[] a = {"", "", "", "", ""};
            String[] b = {"", "", "", "", ""};
            String[] c = {"", "", "", "", ""};
            String[] d = {"", "", "", "", ""};


            String sql1;
            String sql2;
            String sql3;
            String ret="";
            public String trans(String chi) {
                String result = null;
                byte temp[];
                try {
                    temp = chi.getBytes("gbk");
                    result = new String(temp);
                } catch (Exception e) {}
                return result;
            }


    //Access sample property
    public String getSample() {
        return sample;
    }

    //Access sample property
    public void setSample(String newValue) {
        if (newValue != null) {
            sample = newValue;
        }
    }
    public String printHtml(String sql1,String sql2){
        try {
            if (sql1.equals("all")) {
                rs1 = dbconn.executeQuery(sql2);
                sql1 = "SELECT top 3 info from info order by infoid desc ";

                ret = "";
                rs2 = dbconn.executeQuery(sql1);
                i = 0;
                while (rs2.next()) {
                    d[i] = rs2.getString("info");
                    i++;
                }
                dbconn.closeStmt();

                i = 0;
                ret = "";
                while (rs1.next()) {
                    b[i] = rs1.getString("bkname");
                    //System.out.println(b[i]);
                    i++;
                }
               dbconn.closeStmt();dbconn.closeConn();
                for(i=0;i<5;i++){
                    if ((!b[i].equals("") )&& (!d[i].equals(""))) {
                        ret += "<tr>"
                              +
                              "<td>........"+this.trans(d[i])+""
                              + " </td>"
                              +
                               "<td>........"+"<a href=detail.jsp?bkname="+b[i]+">"+this.trans(b[i])+"</a>"+""
                              + "</td>"
                              + "</tr>";

                    }
                    else {
                        if (b[i].equals("")) ret += " <tr>"
                                +

                                this.trans(d[i])
                                + "</td>"
                                +
                                "...................................."
                                + "</td>"
                                + "</tr>";
                        if (d[i].equals("")) ret += " <tr>"
                                +
                                "....................................."
                                + "</td>"

                                +
                                "<td>........" +
                                "<td>........"+"<a href=detail.jsp?bkname="+b[i]+">"+this.trans(b[i])+"</a>"+""
                                + "</td>"

                                + "</tr>";
                    }


                }
               return ret;
             }
            else {
                ret="";
                rs2 = dbconn.executeQuery(sql1);
                i = 0;
                while (rs2.next()) {
                    a[i] = rs2.getString("bkname");
                    i++;
                }
                dbconn.closeStmt();
                rs3 = dbconn.executeQuery(sql2);
                i = 0;
                while (rs3.next()) {
                    c[i] = rs3.getString("bkname");
                    i++;
                }
                dbconn.closeStmt();
                 dbconn.closeConn();


                for (i = 0; i < 5; ) {

                    if ((!a[i].equals("")) && (!c[i].equals("")))
                        ret += " <tr>"
                                +
                                "<td>>........" +
                                "<td>........"+"<a href=detail.jsp?bkname="+a[i]+">"+this.trans(a[i])+"</a>"+""
                                + "</td>"
                                +
                                "<td>........" +
                                 "<td>........"+"<a href=detail.jsp?bkname="+c[i]+">"+this.trans(c[i])+"</a>"+""
                                + "</td>"
                                + "</tr>";

                    else {
                        if (c[i].equals("")) ret += " <tr>"
                                +
                                "<td>........" +
                                 "<td>........"+"<a href=detail.jsp?bkname="+a[i]+">"+this.trans(a[i])+"</a>"+""
                                + "</td>"
                                +
                                "<td>....................................."
                                + "</td>"
                                + "</tr>";
                        if (a[i].equals("")) ret += " <tr>"
                                +
                                "<td>....................................."
                                + "</td>"

                                +
                                "<td>........" +
                                 "<td>........"+"<a href=detail.jsp?bkname="+c[i]+">"+this.trans(c[i])+"</a>"+""
                                + "</td>"

                                + "</tr>";
                    if ((a[i].equals("")) && (c[i].equals("")))
                        ret += " <tr>"
                                +
                                "<td>....................................."
                                + "</td>"
                                +
                                "<td>...................................."
                                + "</td>"
                                + "</tr>";
                    }
                        i++;

                    }

                return ret;
            }
        } catch (Exception e) {
            e.printStackTrace();
                return "error";
        }
    }

   public void Index1Bean()
    {
        sql1=null;
        sql2=null;
        sql3=null;
    }

   /*public static void main (String [] args){
       String aa;
       aa=new Index1Bean().printHtml("SELECT TOP 5 bkname FROM book WHERE (bkcid <> 315003) ORDER BY regdate DESC","SELECT TOP 5 bkname FROM book WHERE (bkcid = 315003) ORDER BY regdate DESC");
        System.out.println(aa);
   }*/




}