modifypassengermodel.java

eclipse java/jsp 航空管理系统

/*
 * @(#)AddPassenger.java 1.0 2005/04/24  
 * <p>copyright:    Copyright 东软 国际合作事业部版权所有</p>
 * <p>company:      neusoft</p>
 * <p>time:         2005.04.24</p>
 */
package jiasir.model;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.naming.NamingException;
import javax.servlet.jsp.jstl.sql.Result;
import javax.sql.DataSource;
import jiasir.ConnDataBaseBean;
import jiasir.SQLCommandBean;
import jiasir.form.Passenger;
import org.apache.log4j.Logger;

import zhangchunliang.model.AppMode;
import jiasir.FormatString;

/**
 * 处理修改违禁品信息的Model
 * @author    王嘉   
 * @version   1.0， 2005/04/24 
 */
public class ModifyPassengerModel {
    /** 用户操作日志记录器 */
    static Logger userOperation = Logger.getLogger("userOperation");
    /** 用户异常日志记录器 */
    static Logger userError = Logger.getLogger("userError");
    /** 系统调试日志记录器 */
    static Logger systemDebug = Logger.getLogger(QueryPassengerModel.class);
    /**
     * 一览页面中查询出的结果的锁定的信息内容
     * 查询出一览页面中锁定的结果信息,用来在修改的时候调用
     */
    public String[] ModifyView(Passenger mp) throws 
                                             NamingException, SQLException {
    	
    	AppMode.registerUser();
        
        /**获得FORM里的参数*/
        Passenger passenger = mp;
        
        /**飞机票号（主键）*/
        String flightTicket = null;
        
        /**从passenger中获得主键值*/
        flightTicket = passenger.getFlightTicket();
        
        /** SQL语句操作的结果集 */
        Result rs = null;
        
        /** SQL语句字符串缓冲 */
        StringBuffer sqlStrBuffer;
        
        /** SQL语句字符串 */
        String sqlStr;
        
        /** Values实例化 */
        List values = new ArrayList();
        
        /** ConnDataBaseBean实例化 */
        ConnDataBaseBean connDataBaseBean = new ConnDataBaseBean();
        
        /** 从连接池中取得一个连接 */
        DataSource dataSource = connDataBaseBean.getDataSource();
        
        /** SQLCommandBean实例化 */
        SQLCommandBean sqlCommandBean = new SQLCommandBean();
        
        /** 设置Connection */
        sqlCommandBean.setConnection(dataSource.getConnection());
  
        /**初始化数组用于存放结果集*/
        String str[] = new String[12];
        
        /** SQL语句字符串缓冲实例化 */
        sqlStrBuffer = new StringBuffer(200);
        sqlStrBuffer.append("select * from passenger where flightTicket=?");
        
                
        /** SQL语句字符串实例化 */
        sqlStr = sqlStrBuffer.toString();
        
        /** 设置sqlValues 查询指定违禁品*/
        sqlCommandBean.setSqlValue(sqlStr);
        
        /** 设置values */
        values.add(flightTicket);
        sqlCommandBean.setValues(values);


        
        
       
        /** 查询权限组信息 */
        try{
            rs = sqlCommandBean.executeQuery();
            
            /**回到结果集的第一个值并逐个存放在数组中*/
            

            String flightTicekt = rs.getRowsByIndex()[0][0].toString();
            str[0] = flightTicket;
            String passengerName = rs.getRowsByIndex()[0][1].toString();
            str[1] = passengerName;
            String passengerIdKind = rs.getRowsByIndex()[0][2].toString();
            str[2] = passengerIdKind;
            String passengerId = rs.getRowsByIndex()[0][3].toString();
            str[3] = passengerId;
            String passengerNat = rs.getRowsByIndex()[0][4].toString();
            str[4] = passengerNat;
            String thingsNum = rs.getRowsByIndex()[0][5].toString();
            str[5] = thingsNum;
            String things = rs.getRowsByIndex()[0][6].toString();
            str[6] = things;
            String thingsQuantity = rs.getRowsByIndex()[0][7].toString();
            str[7] = thingsQuantity;
            String hold = rs.getRowsByIndex()[0][8].toString();
            str[8] = hold;
            String cori = rs.getRowsByIndex()[0][9].toString();
            str[9] = cori;
            String flightNo = rs.getRowsByIndex()[0][10].toString();
            str[10] = flightNo;
            String flightDate = rs.getRowsByIndex()[0][11].toString();
            str[11] = flightDate;
            /** 释放Connection */
            sqlCommandBean.releaseConn();
            
            AppMode.loginoutUser();
            
            /**返回结果集*/
            return str;
        }catch (SQLException e) {
        	
        	AppMode.loginoutUser();
        	
            System.out.print("操作失败");
            return str;
        }        
    }
        
    /*
     * name:         违禁品信息修改
     * describing:   修改passenger表中的信息
     * @param        Passenger mp
     * @return       info 根据info值的不同实现不同页面的跳转
     */
    public int modifyPassengerModel(Passenger mp) throws 
                                                 NamingException, SQLException{
    	
    	AppMode.registerUser();

        /*获得FORM里的参数*/
        Passenger modifyPassenger = mp;
        /*根据forward的返回值做不同页的跳转*/
        int forward;
        
        /**
         *飞机票号
         */
        String flightTicket;
        /**
         *旅客姓名
         */
        String passengerName;
        /**
         *旅客证件种类
         */
        String passengerIdKind;
        /**
         *证件号码
         */
        String passengerId;
        /**
         *旅客国籍
         */
        String passengerNat;
        /**
         *违禁品号
         */
        String thingsNum;
        /**
         *违禁品名
         */
        String things;
        /**
         *违禁品数量
         */
        String thingsQuantity;
        /**
         *对违禁品的操作
         */
        String hold;
        /**
         *出境或入境，c为出，i为入
         */
        String cori;
        /**
         *航班号
         */
        String flightNo;
        /**
         *航班起飞时间
         */
        String flightDate;
        /**
         *执行插入的日期
         */
        String insertDate;
        /**
         *执行插入的用户Id
         */
        String insertUserId;
        /**
         *执行修改的日期
         */
        String updateDate;
        /**
         *执行修改的用户Id
         */
        String updateUserId;
        /**
         *初始化Passenger中的各项 
         */
        flightTicket = 
                    FormatString.convert(modifyPassenger.getFlightTicket());
        passengerName = 
                    FormatString.convert(modifyPassenger.getPassengerName());
        passengerIdKind = 
                    FormatString.convert(modifyPassenger.getPassengerIdKind());
        passengerId = 
                    modifyPassenger.getPassengerId();
        passengerNat = 
                    FormatString.convert(modifyPassenger.getPassengerNat());
        thingsNum = 
                    modifyPassenger.getThingsNum();
        things = 
                    FormatString.convert(modifyPassenger.getThings());
        thingsQuantity = 
                    modifyPassenger.getThingsQuantity();
        hold = 
                    FormatString.convert(modifyPassenger.getHold());
        cori = 
                    FormatString.convert(modifyPassenger.getCori());
        flightNo = 
                    FormatString.convert(modifyPassenger.getFlightNo());
        flightDate = 
                    FormatString.convert(modifyPassenger.getFlightDate());
        updateDate =
                    FormatString.convert(modifyPassenger.getUpdateDate());
        /** SQL语句字符串缓冲 */
        StringBuffer sqlStrBuffer;
      
        /** SQL语句字符串 */
        String sqlStr;
        
        /** Values实例化 */
        List values = new ArrayList();
        
        /** ConnDataBaseBean实例化 */
        ConnDataBaseBean connDataBaseBean = new ConnDataBaseBean();
        
        /** 从连接池中取得一个连接 */
        DataSource dataSource = connDataBaseBean.getDataSource();
        
        /** SQLCommandBean实例化 */
        SQLCommandBean sqlCommandBean = new SQLCommandBean();
        
        /** 设置Connection */
        sqlCommandBean.setConnection(dataSource.getConnection());
  
        
        /** SQL语句字符串缓冲实例化 */
        sqlStrBuffer = new StringBuffer(200);
        sqlStrBuffer.append("UPDATE passenger SET ");
        sqlStrBuffer.append("passengerName = ?");
        sqlStrBuffer.append(",passengerIdKind = ?");
        sqlStrBuffer.append(",passengerId = ?");
        sqlStrBuffer.append(",passengerNat = ?");
        sqlStrBuffer.append(",thingsNum = ?");
        sqlStrBuffer.append(",things = ?");
        sqlStrBuffer.append(",thingsQuantity = ?");
        sqlStrBuffer.append(",hold = ?");
        sqlStrBuffer.append(",cori = ?");
        sqlStrBuffer.append(",flightNo = ?");
        sqlStrBuffer.append(",flightDate = ?");
        sqlStrBuffer.append(", update_date = ?");
        sqlStrBuffer.append(" WHERE flightTicket = ?");
        
        /** SQL语句字符串实例化 */
        sqlStr = sqlStrBuffer.toString();
        
        /** 设置SqlValues 更新指定违禁品信息*/
        sqlCommandBean.setSqlValue(sqlStr);
        
        /** 设置Values */
        values.add(passengerName);
        values.add(passengerIdKind);
        values.add(passengerId);
        values.add(passengerNat);
        values.add(thingsNum);
        values.add(things);
        values.add(thingsQuantity);
        values.add(hold);
        values.add(cori);
        values.add(flightNo);
        values.add(flightDate);
        values.add(updateDate);
        values.add(flightTicket);
        sqlCommandBean.setValues(values);

        
        /** 执行修改权限组操作 */
        try {
            return sqlCommandBean.executeUpdate();
        } catch (SQLException e) { 
            return 9;
        } finally {
        	
        	AppMode.loginoutUser();
        	
            /** 释放Connection */
            sqlCommandBean.releaseConn();
        }
    }
}