client.java

企业办公自动化管理系统

// Decompiled by Jad v1.5.7g. Copyright 2000 Pavel Kouznetsov.
// Jad home page: http://www.geocities.com/SiliconValley/Bridge/8617/jad.html
// Decompiler options: packimports(3) fieldsfirst ansi
// Source File Name:   Client.java

package com.zh.util;

import com.bwm.string.Str;
import com.zh.conpool.Condata;
import java.sql.Connection;

public class Client
{

    public String clientName;
    private String button;
    private String telephone;
    private String fax;
    private String email;
    private String net;
    private String calling;
    private String demand;
    private int money;
    private String explain;
    private String part;
    private String linkman;
    private String sex;
    private String duty;
    private String remark;
    private String tel;
    String sql;
    String id;
    Str str;
    Condata con;
    Connection conn;

    public Client()
    {
        clientName = "";
        button = "";
        telephone = "";
        fax = "";
        email = "";
        net = "";
        calling = "";
        demand = "";
        money = 0;
        part = "";
        linkman = "";
        sex = "";
        duty = "";
        remark = "";
        tel = "";
        sql = "";
        str = new Str();
        con = new Condata();
        conn = null;
    }

    public void setClientName(String newclient)
    {
        clientName =newclient;
    }

    public String getClientName()
    {
        return clientName;
    }

    public void setAdress(String newaddress)
    {
        button = newaddress;
    }

    public String getAdress()
    {
        return button;
    }

    public void setTelephone(String newtel)
    {
        telephone =newtel;
    }

    public String getTelephone()
    {
        return telephone;
    }

    public void setFax(String newfax)
    {
        fax =newfax;
    }

    public String getFax()
    {
        return fax;
    }

    public void setEmail(String newemail)
    {
        email =newemail;
    }

    public String getEmail()
    {
        return email;
    }

    public void setNet(String newnet)
    {
        net =newnet;
    }

    public String getNet()
    {
        return net;
    }

    public void setCalling(String newcall)
    {
        calling =newcall;
    }

    public String getCalling()
    {
        return calling;
    }

    public void setDemand(String newdem)
    {
        demand =newdem;
    }

    public String getDemand()
    {
        return demand;
    }

    public void setMoney(int i)
    {
        money = i;
    }

    public int getMoney()
    {
        return money;
    }

    public void setExplain(String newexplain)
    {
        explain =newexplain;
    }

    public String getExplain()
    {
        return explain;
    }

    public void setPart(String newpart)
    {
        part =newpart;
    }

    public String getPart()
    {
        return part;
    }

    public void setLinkman(String newlink)
    {
        linkman =newlink;
    }

    public String getLinkman()
    {
        return linkman;
    }

    public void setSex(String newsex)
    {
        sex =newsex;
    }

    public String getSex()
    {
        return sex;
    }

    public void setDuty(String newduty)
    {
        duty =newduty;
    }

    public String getDuty()
    {
        return duty;
    }

    public void setRemark(String newtrem)
    {
        remark =newtrem;
    }

    public String getRemark()
    {
        return remark;
    }

    public void setTel(String newte)
    {
        tel =newte;
    }

    public String getTel()
    {
        return tel;
    }

    public String getSql()
    {
        
        sql = "insert into tb_client(ClientName,Adress,Telephone,Fax,Email,Net,Calling,Demand,Money,Explain,Linkman,Sex,Duty,Tel,Remark)values('" + clientName + "','" + button + "','" + telephone + "','" + fax + "','" + email + "','" + net + "','" + calling + "','" + demand + "','" + money + "','" + part + "','" + linkman + "','" + sex + "','" + duty + "','" + tel + "','" + remark + "')";
        return sql;
    }
    public String UpdateSql(String id){
    	this.id=id;
             sql = "update tb_client set ClientName='" + clientName + "',Adress='" + button + "',Telephone='" + telephone + "',Fax='" + fax + "',Email='" + email + "',Net='" + net + "',Calling='" + calling + "',Demand='" + demand + "',Money='" + money + "',Explain='" + part + "',Linkman='" + linkman + "',Sex='" + sex + "',Duty='" + duty + "',Tel='" + tel + "',Remark='" + remark + "' where Id='"+ id+"'" ;
             return sql;
    }
    public boolean execu()
        throws Exception
    {
        boolean flag = false;
        try
        {
            Condata _tmp = con;
            Condata.getConnection();
        }
        catch(Exception exception)
        {
            exception.getMessage();
        }
        int i = con.executeUpdate(getSql());
        if(i > 0)
            flag = true;
        else
            flag = false;
        try
        {
            con = null;
            con.close();
        }
        catch(Exception exception1)
        {
            exception1.getMessage();
        }
        return flag;
    }
     public boolean execu1()
        throws Exception
    {
    
        boolean flag = false;
        try
        {
            Condata _tmp = con;
            Condata.getConnection();
        }
        catch(Exception exception)
        {
            exception.getMessage();
        }
        int i = con.executeUpdate(UpdateSql(id));
        if(i > 0)
            flag = true;
        else
            flag = false;
        try
        {
            con = null;
            con.close();
        }
        catch(Exception exception1)
        {
            exception1.getMessage();
        }
        return flag;
    }

}