user.java

来自「一个很有用的电子刊物发布系统」· Java 代码 · 共 221 行

package com.am;

import java.util.*;
import java.sql.*;
import java.text.*;
public class user
{

    public long ID;
    public String userName;
    public String userPassword;
    public String name;    
    public String company;   
    public String depart;
    public String email;  
    public String myfields;
    public String systemRole;
    public String createDatetime;   
    public int tag;
    private String strSql;
    private Connection dbConn;
    private int errNum;
    private String errDesc;
    private SimpleDateFormat dateFormatter;
    public user()
    {
        dateFormatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        ID=0;
        userName="";
        userPassword="";        
        name="";        
        company="";        
        depart="";
        email="";       
        myfields="";       
        systemRole="";
     	createDatetime=dateFormatter.format(new java.util.Date());    
		tag=0;
   		strSql="";
        dbConn=null;
        errNum=0;
        errDesc="";
   }
  
   public void add()
   {
        String tmpcreateDatetime;
        createDatetime=dateFormatter.format(new java.util.Date());
        strSql="insert into users ";
        strSql=strSql + "(";
        strSql=strSql + "userName,";
        strSql=strSql + "userPassword,";        
        strSql=strSql + "name,";    
        strSql=strSql + "company,";     
        strSql=strSql + "depart,";
        strSql=strSql + "email,";       
        strSql=strSql + "myfields,";
        strSql=strSql + "systemRole,";
        strSql=strSql + "createDatetime,";     
        strSql=strSql + "tag";        
        strSql=strSql + ") ";
		strSql=strSql + "values(";
		strSql=strSql + "'" + userName + "',";
		strSql=strSql + "'" + userPassword + "',";		
		strSql=strSql + "'" + name + "',";	
		strSql=strSql + "'" + company + "',";		
		strSql=strSql + "'" + depart + "',";
		strSql=strSql + "'" + email + "',";		
		strSql=strSql + "'" + myfields + "',";
		strSql=strSql + "'" + systemRole + "',";
		strSql=strSql + "'" + createDatetime + "',";	
		strSql=strSql + "'" + tag + "'";           
		strSql=strSql + ")";
		exeSql(strSql);
   }

 
   public void update()
   {
   		strSql="update users set ";
		strSql=strSql + "userName=" + "'" + userName + "',";
		strSql=strSql + "userPassword=" + "'" + userPassword + "',";
		strSql=strSql + "name=" + "'" + name + "',";
		strSql=strSql + "company=" + "'" + company + "',";	
		strSql=strSql + "depart=" + "'" + depart + "',";
		strSql=strSql + "email=" + "'" + email + "',";		
		strSql=strSql + "myfields=" + "'" + myfields + "',";
		strSql=strSql + "systemRole=" + "'" + systemRole + "',";
		strSql=strSql + "createDatetime=" + "'" + createDatetime + "',";	
		strSql=strSql + "tag=" + "'" + tag + "'";
		strSql=strSql + " where ID='" + ID + "'";
		exeSql(strSql);

   }
   
      public void updatekey()
      {
	       strSql="update users set ";
	       strSql=strSql + "userPassword=" + "'" + userPassword + "'";
	       strSql=strSql + " where ID='" + ID + "'";
	       exeSql(strSql);

      }

  
   public void delete()
   {
        strSql="delete from `users` where ID='";
        strSql=strSql + this.ID + "'";
        exeSql(strSql);

   }

 
   public void enable()
   {
        strSql="update users set tag=0 where ID='";
        strSql=strSql  + this.ID + "'";
        exeSql(strSql);

   }

   
   public void  disable()
   {
        strSql="update users set tag=-1 where ID='";
        strSql=strSql + this.ID + "'";
        exeSql(strSql);

   }

  
   public boolean  init()
   {
    	strSql="select * from `users` where ID=";
        strSql=strSql + "'" + this.ID + "'";
        Statement stmt=null;
        ResultSet rs=null;
        try
		{
   			stmt=dbConn.createStatement();
			rs =stmt.executeQuery(strSql);
            if (rs.next())
            {
                ID=rs.getLong("ID");
                userName=rs.getString("userName");
                userPassword=rs.getString("userPassword");               
                name=rs.getString("name");               
                company=rs.getString("company");               
                depart=rs.getString("depart");
                email=rs.getString("email");                
                myfields=rs.getString("myfields");
                systemRole=rs.getString("systemRole");
                createDatetime=rs.getString("createDatetime");                
                tag=rs.getInt("tag");               
                this.errNum=0;
                this.errDesc="";
                return true;
            }
            else
            {
                this.errNum=-1;
                this.errDesc="init faild!";
                return false;

            }

		}
		catch(Exception ex)
		{
            this.errNum=-1;
            this.errDesc=ex.toString();
            return false;

		}
        finally
        {
            stmt=null;
            rs=null;
        }


   }


   public void  setConnection(Connection dbConn)
   {
   		this.dbConn=dbConn;
   }
  
   private void exeSql(String strSql)
   {
   		try
		{
   			Statement stmt=dbConn.createStatement();
			stmt.executeUpdate(strSql);
            this.errNum=0;
            this.errDesc="";
		}
		catch(Exception ex)
		{

            this.errNum=-1;
            this.errDesc=ex.toString();

		}
   }

  
    public int getErrNum()
    {
        return errNum;

    }
   
    public String getErrDesc()
    {
        return errDesc;
    }
}