kehu.java

来自「用java实现的一个bbs的portal」· Java 代码 · 共 196 行

package DBConnection;

import java.util.*;
import java.io.*;
import java.util.Date;
import java.sql.*;
import java.text.*;

public class Kehu{

    private String sqlStatements=null;
    private ResultSet rs=null;

    private String kehubianhao=" ";
    private String kehumingcheng=" ";
    private String bieming_1=" ";
    private String bieming_2=" ";
    private String dizhi=" ";
    private String dianhua=" ";
    private String chuanzhen=" ";
    private String lianxiren=" ";
    private String jine=" ";

    private SQLBridge sqlBridge;

    public void setSqlBridge( SQLBridge theBridge ){
        this.sqlBridge = theBridge;
    }


    public String getKehubianhao(){
        return this.kehubianhao;
    }
    public void setKehubianhao(String kehubianhao){
        this.kehubianhao=kehubianhao;
    }

    public String getKehumingcheng(){
        return this.kehumingcheng;
    }
    public void setKehumingcheng(String kehumingcheng){
        this.kehumingcheng=kehumingcheng;
    }

    public String getBieming_1(){
        if (bieming_1.equals("null"))
            return " ";
        else return this.bieming_1;
    }
    public void setBieming_1(String bieming_1){
        this.bieming_1=bieming_1;
    }

    public String getBieming_2(){
        if (bieming_2.equals("null"))
            return " ";
        else return this.bieming_2;
    }
    public void setBieming_2(String bieming_2){
        this.bieming_2=bieming_2;
    }

    public String getDizhi(){
        if (dizhi.equals("null"))
            return " ";
        else return this.dizhi;
    }
    public void set(String dizhi){
        this.dizhi=dizhi;
    }

    public String getDianhua(){
        if (dianhua.equals("null"))
            return " ";
        else return this.dianhua;
    }
    public void setDianhua(String dianhua){
        this.dianhua=dianhua;
    }

    public String getChuanzhen(){
        if (chuanzhen.equals("null"))
            return " ";
        else return this.chuanzhen;
    }
    public void setChuanzhen(String chuanzhen){
        this.chuanzhen=chuanzhen;
    }

    public String getLianxiren(){
        if (lianxiren.equals("null"))
            return " ";
        else return this.lianxiren;
    }
    public void setLianxiren(String lianxiren){
        this.lianxiren=lianxiren;
    }

    public String getJine(){
        if (jine.equals("null"))
            return " ";
        else return this.jine;
    }
    public void setJine(String jine){
        this.jine=jine;
    }

    //////////////////////////////////
    public boolean DelData(String xiangmubianhao){
        try{
            sqlStatements="delete from kehu where kehubianhao='"+kehubianhao+"'";
            sqlBridge.execSQL(sqlStatements);
            return true;
        }catch (Exception e){
            e.printStackTrace();
        }
        return false;
    }

    public boolean InsertData(){
        sqlStatements="insert into kehu values ('"+kehubianhao+"','"+kehumingcheng+"','"+bieming_1+
                "','"+bieming_2+"','"+dizhi+"','"+dianhua+"','"+chuanzhen+"','"+lianxiren+"','"+jine+"')";
        try{
            sqlBridge.execSQL(sqlStatements);
        }catch (Exception e){
            e.printStackTrace();
            return false;
        };
        return true;
    }


    public boolean GainData(String sqlstmt){
        try{
            sqlStatements=sqlstmt;
            sqlBridge.execSQL(sqlStatements);
        }catch (Exception e){
            e.printStackTrace();
            return false;
        };
        return true;
    }

    public boolean GainNext(){
        try{
            if (!sqlBridge.nextRow())
                return false;
            DataItems();
            return true;
        }catch (Exception e){
            e.printStackTrace();
        }
        return false;
    }
    public void DataItems(){
        try{
            kehubianhao=sqlBridge.getFieldString("kehubianhao");
            kehumingcheng=sqlBridge.getFieldString("kehumingcheng");
            bieming_1=sqlBridge.getFieldString("bieming_1");
            bieming_2=sqlBridge.getFieldString("bieming_2");
            dizhi=sqlBridge.getFieldString("dizhi");
            dianhua=sqlBridge.getFieldString("dianhua");
            chuanzhen=sqlBridge.getFieldString("chuanzhen");
            lianxiren=sqlBridge.getFieldString("lianxiren");
            jine=sqlBridge.getFieldString("jine");
        }catch (Exception e){
            e.printStackTrace();
        };
    }

    public boolean DelItem(String id){
        try{
            sqlStatements="delete from kehu where kehubianhao='"+id+"'";
            sqlBridge.execSQL(sqlStatements);
            return true;
        }catch (Exception e){
            e.printStackTrace();
        }
        return false;
    }

    public String getClientName(String clientid){
        String outstr="无对应客户名称";
        try{
            sqlStatements="select kehumingcheng from kehu where kehubianhao='"+clientid+"'";;
            sqlBridge.execSQL(sqlStatements);
            if (sqlBridge.nextRow())
                outstr=sqlBridge.getFieldString("kehumingcheng");
            return outstr;
        }catch (Exception e){
            e.printStackTrace();
        }
        return outstr;
    }
}