users.java

检化验管理系统

package com.snsoft.site.jspbean;

import com.jl.zys.dbaccess.*;
import java.io.*;
import java.lang.reflect.Field;
import java.math.BigDecimal;
import java.sql.*;
import java.text.*;
import java.util.*;


public class users {
  String oldpwd = "";
  String newpwd = "";
  String userid = "";//工号
  String password = "";
  String userids = "";//jl+工号
  String level = "";
  String user  = "";//
//-------------------set-----------------------
  public void setOldpwd(String oldpwd){
    this.oldpwd = oldpwd;
  }
  public void setNewpwd(String newpwd){
    this.newpwd = newpwd;
  }
  public void setUserid(String userid){
    this.userid = userid;
  }
  public void setPassword(String password){
    this.password = password;
  }
  public void setUserids(String userids){
    this.userids = userids;
  }
  public void setLevel(String level){
    this.level = level;
  }
  public void setUser(String user){
    this.user = user;
  }

//-------------------get------------------------
  public String getOldpwd(){
    return oldpwd;
  }
  public String getNewpwd(){
    return newpwd;
  }
  public String getUserid(){
    return userid;
  }
  public String getPassword(){
    return password;
  }
  public String getUserids(){
    return userids;
  }
  public String getLevel(){
    return level;
  }
  public String getUser(){
    return user;
  }
//修改密码----------------------------------------
  public int chanagePwd(){
    int flags = 0;
    int flag = 0;
    MyResultSet rs = null;
    try{
      String sql = "select * from userName where 工号 = '"+userid+"' and 密码 = '"+oldpwd+"'";
      rs = DbAccess.querySqlOption(sql);
      while(rs.next()){
        flag = 1;
      }
      if(flag==1){
        String sql2 = "update userName set 密码 = '" + newpwd + "' where 工号 = '" +
            userid + "'";
        flags = DbAccess.updateOption(sql2);
      }
    }catch(Exception e){
      e.printStackTrace();
    }
    finally {
      try {
        if (rs != null) rs.close();
      }
      catch (SQLException ex) {}
    }
    return flags;
  }
//登录-----------------------------------------
  public String login(){
    String level = "";
    String sql = "";
    String userids = "jl"+userid;
    MyResultSet rs = null;
    MyResultSet rs0 = null;

    try {

        if(userid.equals("123456")){
            level = "common@@";
        }else{
            String sqlexist = "select * from sysobjects where name = '"+userids+"'";
            //System.out.print(userid);
            //rs = super.executeQuery(sqlexist);
            rs = DbAccess.querySqlOption(sqlexist);
            if(rs.next()){
                sql = "select * from userName where 工号 = '" + userid +
                    "' and 密码 = '" + password + "'";
                //rs = super.executeQuery (sql);
                rs0 = DbAccess.querySqlOption(sql);
                while (rs0.next ()) {
                    level = rs0.getString ("姓名") + "@@";
                    level += rs0.getString ("权限");
                }
                try {
                  if (rs0!= null) {rs0.close();}
                }catch (SQLException ex) {}
            }else{
                level = "nexist@@";
            }
        }
    }
    catch (Exception e) {
      e.printStackTrace();
    }
    finally {
      try {
        if (rs!= null) {rs.close();}
      }catch (SQLException ex) {}
    }
    return level;
  }
//是否有审核--------------------------------
//  public String isCheck(){//是否有审核任务
//    MyResultSet rsuj = null;
//    MyResultSet rsg = null;
//
//
//    String signu = "";
//    String gname = "";
//    //String levelu = "";
//    String mystr = "";
//    String judge = "";
//    int sign = 0;
//    int signun = 0;
//    try {
//      if(level.indexOf("2")!=-1){
//        String sqluju = "select * from " + userids + " where 审核级别!=0";
//        //rsuj = super.executeQuery(sqluju);
//        rsuj = DbAccess.querySqlOption(sqluju);
//        while (rsuj.next()) {
//          gname = rsuj.getString("物品名称");
//          signu = rsuj.getString("审核级别");
//          judge = rsuj.getString("合格");
//          signun = Integer.parseInt(signu.trim());
//          String sqlg = "select 审核,流水号 from " + gname +
//              " where 审核结束 = 'n' and 作废 = 'n' ";
//          //rsg = super.executeQuery(sqlg);
//          rsg = DbAccess.querySqlOption(sqlg);
//          while (rsg.next()) {
//            String signhav = rsg.getString("审核");
//            String numid = rsg.getString("流水号");
//            int havSignn = signhav.length() -
//                (signhav.replaceAll("@", "")).length();
//            sign = signun - havSignn;
//            if (sign == 1) {
//              mystr += numid.trim() + judge.trim() + gname.trim() + "@@";
//            }          //流水号
//          }
//        }
//      }else{
//        mystr = "";
//      }
//    }
//    catch (Exception e) {
//      e.printStackTrace();
//    }
//    finally {
//      try {
//        if (rsuj != null) rsuj.close();
//        if (rsg != null) rsg.close();
//      }
//      catch (SQLException ex) {}
//    }
//    return mystr;
//  }
//是否有审核-------------------------------------------
  public String isCheckNew(){//是否有审核任务
    MyResultSet rsuj = null;
    MyResultSet rsg = null;

    String signu = "";
    String gname = "";
    String mystr = "";
    int sign = 0;
    int signun = 0;
    try {
      if(level.indexOf("2")!=-1){
        String sqluju = "select * from " + userids + " where 审核级别!=0";//具体人名表
        rsuj = DbAccess.querySqlOption(sqluju);
        while (rsuj.next()) {
          gname = rsuj.getString("物品名称");
          signu = rsuj.getString("审核级别");
          signun = Integer.parseInt(signu.trim());
          String sqlg = "select 审核,流水号 from " + gname +
              " where 审核结束 = 'n' and 作废 = 'n' ";//具体物品表
          //rsg = super.executeQuery(sqlg);
          rsg = DbAccess.querySqlOptionp(sqlg);
          while (rsg.next()) {
            String signhav = rsg.getString("审核");
            int havSignn = signhav.length() -
                (signhav.replaceAll("@", "")).length();
            sign = signun - havSignn;
            if (sign == 1) {
              mystr += gname.trim() + "@@";
              break;
            }
          }
          try {
            if (rsg != null) rsg.close();
          }catch (SQLException ex) {}
        }
      }else{
        mystr = "";
      }
    }
    catch (Exception e) {
      e.printStackTrace();
    }
    finally {
      try {
        if (rsg != null) rsg.close();
      }catch (SQLException ex) {}
    }
    return mystr;
  }

}