realcorrectbean.java

eclipse java/jsp 航空管理系统

/*
 * Copyright Neusoft Dalian Center,All Rights Reserved
 *
 * WEB Application Apply Struts Platform
 * 
 * PackageName shengjb.form
 * ClassName RealCorrectBean.java
 *
 * @author shengjb  | [e-mail]
 *
 * Created on 2005-4-17
 *
 */
package shengjb.model;

import java.sql.Connection; 
//import java.sql.DriverManager; 
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.StringTokenizer;

import org.apache.log4j.Logger;

import shengjb.form.RealCorrectForm;
import zhangchunliang.model.AppMode;
import kangyi.ConnectionPool.DbConnection;

/**
 * RealCorrectBean BeanClass
 * 
 * @author shengjb ver.0.7
 */
public class RealCorrectBean {
	
	/** 用户操作日志记录器 */
    static Logger userOperation = Logger.getLogger("userOperation");
    
    /** 用户异常日志记录器 */
    static Logger userError = Logger.getLogger("userError");

    /** 系统调试日志记录器 */
    static Logger systemDebug = Logger.getLogger(RealCorrectBean.class);
	
	/**
	 * load MySQL database driver
	 */
	//public RealCorrectBean(){
	//	  try{
    //        Class.forName("com.mysql.jdbc.Driver");   
    //    }
    //    catch(ClassNotFoundException e){
    //        e.getMessage();
    //        userError.error("数据库驱动没有配置");
    //    }
	//}

	/**
     * name:         转换字符串方法
     * Description:  把屏幕上获取的中文字符串正确的传入MODEL中
     * @return       Str 转换完的字符串 
     */
    public String convert(String s){
        String str=s;
        try{
            byte b[]=str.getBytes("ISO-8859-1");
            str=new String(b);
            return str;
        }
        catch(Exception e){
            return str;
        }
    }
    
    /**
     * name:         转换字符数组方法
     * Description:  把接受到的组号的字符数组中的各字符中间追加一个分号并转换成字符串
     * @return       s 转换完的字符串 
     */
    public String convertGroupNo(String[]sss){
    	String s;
    	StringBuffer ss = new StringBuffer(200);
    	for(int i=0 ; i < sss.length ; i++){
    		ss.append(sss[i]);
    		ss.append(";");
    	}
    	s = ss.toString();
    	System.out.println(s);
    	return s;
    }
   
	/**
	 * update database record with
	 * userName,password,departmentNo,groupNo.
	 */
	public String update(RealCorrectForm realCorrectForm){
		
		AppMode.registerUser();
		
		/*connect database*/
		//StringBuffer conSql = new StringBuffer(500);
        //conSql.append("jdbc:mysql://192.168.219.148/ciqms?user=");
        //conSql.append("shengjb");
        //conSql.append("&password=");
        //conSql.append("sunny");
        //conSql.append("&useUnicode=true&characterEncoding=GBK");
        //String conmysql=conSql.toString();
        DbConnection db = null;
        Connection con = null;
        Statement sql = null;
        ResultSet rs = null;
        
        /*在RealCorrectAction中根据此变量进行跳转*/
        String info = null;
        
        /*获得RealCorrectForm里的userID并转换成字符串*/
        //String userID = realCorrectForm.getSid();
		//userID = convert(userID);
		
		/*获得RealCorrectForm里的userName并转换成字符串*/
		String userName = realCorrectForm.getUserName();
		userName = convert(userName);
		
		/*获得RealCorrectForm里的password并转换成字符串*/
		String password = realCorrectForm.getPassword();
		password = convert(password);
		
		/*获得RealCorrectForm里的groupNo并转换成字符串*/
		String[] groupNo = realCorrectForm.getGroupNo();
		String convertGroupNo = convertGroupNo(groupNo);
		
		/*获得RealCorrectForm里的departmentNo并转换成字符串*/
		String departmentNo = realCorrectForm.getDepartmentNo();
		departmentNo = convert(departmentNo);	
		//MiddleCorrectForm middleCorrectForm = new MiddleCorrectForm();
		try{
			/*获取数据库连接*/
            db = new DbConnection();
            con = db.getCon();
            sql=con.createStatement();
            
            /* 用StringTokenizer方法来将字符串区分开，存入feixi对象中 */
			StringTokenizer fenxi = new StringTokenizer(convertGroupNo, ";");
			while (fenxi.hasMoreTokens()){
				String s = fenxi.nextToken();
				if ((s.equals("1")||s.equals("2"))&& convertGroupNo.length()>2){
					return info = "adminothererror";
				   }
			}
            String update1 = 
            	"UPDATE stuff SET sname = '"+ userName +"' WHERE sid = "+"'"+ realCorrectForm.getSid()+ "'";
            String update2 =
            	"UPDATE stuff SET password = '"+ password +"' WHERE sid = "+"'"+ realCorrectForm.getSid()+ "'";
            String update3 =
            	"UPDATE stuff SET groupstring = '"+ convertGroupNo +"' WHERE sid = "+"'"+ realCorrectForm.getSid()+ "'";
            String update4 = 
            	"UPDATE stuff SET depno = "+ departmentNo +" WHERE sid = "+"'"+ realCorrectForm.getSid()+ "'";
            System.out.println(update3);
            sql.executeUpdate(update1);
            /* 记录用户操作日志：修改用户姓名*/
    		userOperation.info("userID:"+ realCorrectForm.getSid()+",操作：修改用户ID为：" + realCorrectForm.getSid() 
            			+ "的姓名，结果:成功");
            sql.executeUpdate(update2);
            /* 记录用户操作日志：修改用户密码*/
    		userOperation.info("userID:"+ realCorrectForm.getSid()+",操作：修改用户ID为：" + realCorrectForm.getSid() 
            			+ "的密码，结果:成功");
            sql.executeUpdate(update3);
            /* 记录用户操作日志：修改用户组号*/
    		userOperation.info("userID:"+ realCorrectForm.getSid()+",操作：修改用户ID为：" + realCorrectForm.getSid() 
            			+ "的组号，结果:成功");
            sql.executeUpdate(update4);
            /* 记录用户操作日志：修改用户部门号*/
    		userOperation.info("userID:"+ realCorrectForm.getSid()+",操作：修改用户ID为：" + realCorrectForm.getSid() 
            			+ "的部门号，结果:成功");
            return info = "updatesuccess";
        }catch(SQLException se){
             System.out.print(se.getMessage());
             userError.error("修改此用户错误：SQL语句执行错误");
             info = "updatefaile";
             return info;
        }finally{
        	
        	AppMode.loginoutUser();
        	
        	try{
        		sql.close();
        		con.close();
        		rs.close();
        	}catch(Exception e){
        	}
        }
	}
}