drawoption.java

eclipse java/jsp 航空管理系统

/** 
 * @(#)DrawOption.java 1.0 2005/04/19 
 * <p>copyright:    Copyright 东软 国际合作事业部版权所有</p>
 * <p>company:      neusoft</p>
 * <p>time:         2005.04.19</p>
 */

package jiasir;

import java.sql.Connection; 
import java.sql.DriverManager; 
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import jiasir.form.Passenger;

/**
 * 绘画表单中各个元素的类
 * @author    王嘉    
 * @version   1.0， 2005/04/23
 */
public class DrawOption {
    /**
     * 产生一个权限组名的select标签
     * @return drawStringBuffer 输出到jsp文件中的html文本块
     */
    public static StringBuffer selectDrawing(){
        Connection con;
        Statement sql;
        ResultSet rs;
        
        /** 返回StringBuffer变量实例化 */
        StringBuffer drawStringBuffer = new StringBuffer(1000);
        try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
        } catch(Exception e) {
        }
        try {
            con = DriverManager.getConnection("jdbc:mysql://192.168.219.148/"
                    + "ciqms?user=jiasir&password=jiasir&useUnicode"
                    + "=true&characterEncoding=GBK");
            sql = con.createStatement();
            rs = sql.executeQuery("SELECT countryname FROM country");
            while(rs.next()) {  
        drawStringBuffer.append("<option value=\"" + rs.getString(1));
            }
            con.close();
            return drawStringBuffer;
        } catch(SQLException e1) {
            return null;
        }
    }
    
    /**
     * 产生一个html的文本框标签
     * @param name              表单bean对应的属性名
     * @param value             文本框初值
     * @param isReadOnly        是否只读
     * @return drawStringBuffer 输出到jsp文件中的html文本块
     */
    public static StringBuffer drawText(String name, String value, 
                                          boolean isReadOnly) {
        /** 返回StringBuffer变量实例化 */
        StringBuffer drawStringBuffer = new StringBuffer(200);
        
        /** 绘制文本框 */
        drawStringBuffer.append("<input type=\"text\" ");
        drawStringBuffer.append("name=\"" + name + "\" ");
        drawStringBuffer.append("value=\"" + value +"\" ");
        drawStringBuffer.append("style=\"width:40px\" ");
        
        /** 判断是否只读 */
        if(isReadOnly) {
            drawStringBuffer.append("readonly=\"readonly\" ");
        }        
        drawStringBuffer.append(">");
        
        return drawStringBuffer;
    }
    
    /**
     * 产生表的一个单元格
     * @param text              单元格内容
     * @param isCenter          是否居中对齐
     * @return drawStringBuffer 输出到jsp文件中的html文本块
     */
    public static StringBuffer drawTd(StringBuffer text, boolean isCenter) {
        /** 返回StringBuffer变量实例化 */
        StringBuffer drawStringBuffer = new StringBuffer(200);
        
        /** 绘制单元格 */
        drawStringBuffer.append("<td");
        
        /** 判断是否居中 */
        if(isCenter) {
            drawStringBuffer.append(" align=\"center\"");
        }
        
        drawStringBuffer.append(">");
        drawStringBuffer.append(text);
        drawStringBuffer.append("</div></td>");
        
        return drawStringBuffer;
    }
    
    /**
     * 绘制一个表单Table，并能够实现分页显示
     * @param rs         数据库查询后的结果集
     * @param rowNum     开始显示的行数
     * @param pageRowNum 每页显示的行数
     * @return
     */
    public static StringBuffer drawTable(Passenger passenger[], 
                int numOfPassenger) {
        StringBuffer drawStringBuffer = new StringBuffer(200);
        drawStringBuffer.append("<tr>");
        drawStringBuffer.append("<table width=\"603\" border=\"1\" " +
                "cellspacing=\"0\" cellpadding=\"0\">");
        drawStringBuffer.append("<tr>");
        drawStringBuffer.append("<td>选择</td>");
        //drawStringBuffer.append("<td>机票号</td>");
        drawStringBuffer.append("<td nowrap>姓名</td>");
        drawStringBuffer.append("<td>证件类型</td>");
        drawStringBuffer.append("<td>证件号码</td>");
        drawStringBuffer.append("<td nowrap>国籍</td>");
        drawStringBuffer.append("<td>违禁品号</td>");
        drawStringBuffer.append("<td>违禁品名</td>");
        drawStringBuffer.append("<td>数量</td>");
        drawStringBuffer.append("<td nowrap>扣留</td>");
        drawStringBuffer.append("<td nowrap>进出口</td>");
        drawStringBuffer.append("<td>航班号</td>");
        drawStringBuffer.append("<td nowrap>航班日期</td>");
        drawStringBuffer.append("</tr>");
        int m=passenger.length;
        for(int i=0;i<numOfPassenger;i++){
        drawStringBuffer.append("<tr>");        
        drawStringBuffer.append("<td><input type=\"radio\" ");
        drawStringBuffer.append("name=\"flightTicket\"");        
        drawStringBuffer.append
                         ("value=\""+passenger[i].getFlightTicket()+"\"></td>");
        //drawStringBuffer.append
        //               (drawTd(drawText
        //       ("flightTicket", passenger[i].getFlightTicket(), true), true));
        drawStringBuffer.append("<td>"+passenger[i].getPassengerName()+"</td>");
        drawStringBuffer.append
                         ("<td>"+passenger[i].getPassengerIdKind()+"</td>");
        drawStringBuffer.append("<td>"+passenger[i].getPassengerId()+"</td>");
        drawStringBuffer.append("<td>"+passenger[i].getPassengerNat()+"</td>");
        drawStringBuffer.append("<td>"+passenger[i].getThingsNum()+"</td>");
        drawStringBuffer.append("<td>"+passenger[i].getThings()+"</td>");
        drawStringBuffer.append
                         ("<td>"+passenger[i].getThingsQuantity()+"</td>");
        drawStringBuffer.append("<td>"+passenger[i].getHold()+"</td>");
        drawStringBuffer.append("<td>"+passenger[i].getCori()+"</td>");
        drawStringBuffer.append("<td>"+passenger[i].getFlightNo()+"</td>");
        drawStringBuffer.append("<td>"+passenger[i].getFlightDate()+"</td>");
        drawStringBuffer.append("</tr>");
        }
        drawStringBuffer.append("</table>");
        return drawStringBuffer;
    }
}