clientdao.java~12~

销售管理系统 随着我国国民经济的持续发展

package com.dao;

import com.tool.JDBConnection;
import java.util.*;
import com.domain.ClientVO;
import java.sql.*;

public class ClientDao {
  private JDBConnection connection = null;
  private List list = null;
  public ClientDao() {
    connection = new JDBConnection();
    this.connection.creatConnection(); //利用构造方法调用类中的对象对数据库创建连接
  }

  //通过公司名称获得公司信息
  public ClientVO clientContext(String name) {

    ClientVO client = null;
    String sql = "select * from tb_client where client_name='"+name+"'";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
        client = new ClientVO();
        client.setId(Integer.valueOf(rs.getString(1)));
        client.setClient_number(rs.getString(2));
        client.setClient_name(rs.getString(3));
        client.setClient_ptype(rs.getString(4));
        client.setClient_type(rs.getString(5));
        client.setClient_credit(rs.getString(6));
        client.setClient_content(rs.getString(7));
        client.setClient_provicne(rs.getString(8));
        client.setClient_city(rs.getString(9));
        client.setClient_bank(rs.getString(10));
        client.setClient_bankNumber(rs.getString(11));
        client.setClient_tel(rs.getString(12));
        client.setClient_contact(rs.getString(13));
        client.setClient_email(rs.getString(14));
        client.setClient_address(rs.getString(15));
        client.setClient_remark(rs.getString(16));
        client.setCreatTime(rs.getString(17));

      }
    }
    catch (SQLException ex) {
    }
    connection.closeConnection();
    return client;
  }



//获得客户名称
  public String getclientName(String number) {
    String name = null;
    String sql = "select * from tb_client where client_number='" + number + "'";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
       name=rs.getString("client_name");
      }
    }
    catch (SQLException ex) {
    }
    connection.closeConnection();
    return name;
  }

  public List clientStyleList(String name) {
    list = new ArrayList();
    ClientVO client = null;
    String sql = "select * from tb_client where client_ptype='"+name+"'";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
        client = new ClientVO();
        client.setId(Integer.valueOf(rs.getString(1)));
        client.setClient_number(rs.getString(2));
        client.setClient_name(rs.getString(3));
        client.setClient_ptype(rs.getString(4));
        client.setClient_type(rs.getString(5));
        client.setClient_credit(rs.getString(6));
        client.setClient_content(rs.getString(7));
        client.setClient_provicne(rs.getString(8));
        client.setClient_city(rs.getString(9));
        client.setClient_bank(rs.getString(10));
        client.setClient_bankNumber(rs.getString(11));
        client.setClient_tel(rs.getString(12));
        client.setClient_contact(rs.getString(13));
        client.setClient_email(rs.getString(14));
        client.setClient_address(rs.getString(15));
        client.setClient_remark(rs.getString(16));
        client.setCreatTime(rs.getString(17));
        list.add(client);
      }
    }
    catch (SQLException ex) {
    }
    connection.closeConnection();
    return list;
  }

  public ClientVO clientSelectNumber(String number) {
    ClientVO client = null;
    String sql = "select * from tb_client where client_number='" + number + "'";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
        client = new ClientVO();
        client.setId(Integer.valueOf(rs.getString(1)));
        client.setClient_number(rs.getString(2));
        client.setClient_name(rs.getString(3));
        client.setClient_ptype(rs.getString(4));
        client.setClient_type(rs.getString(5));
        client.setClient_credit(rs.getString(6));
        client.setClient_content(rs.getString(7));
        client.setClient_provicne(rs.getString(8));
        client.setClient_city(rs.getString(9));
        client.setClient_bank(rs.getString(10));
        client.setClient_bankNumber(rs.getString(11));
        client.setClient_tel(rs.getString(12));
        client.setClient_contact(rs.getString(13));
        client.setClient_email(rs.getString(14));
        client.setClient_address(rs.getString(15));
        client.setClient_remark(rs.getString(16));
        client.setCreatTime(rs.getString(17));
      }
    }
    catch (SQLException ex) {
    }
    connection.closeConnection();
    return client;
  }

//插入操作
  public void clientInsert(ClientVO vo) {
    String sql = "insert into tb_client values ('" + vo.getClient_number() +
        "','" + vo.getClient_name() +
        "','" + vo.getClient_ptype() + "','" + vo.getClient_type() +
        "','" + vo.getClient_credit() + "','" + vo.getClient_content() +
        "','" + vo.getClient_provicne() + "','" + vo.getClient_city() +
        "','" + vo.getClient_bank() + "','" + vo.getClient_bankNumber() + "','" +
        vo.getClient_tel() + "','" + vo.getClient_contact() + "','" +
        vo.getClient_email() + "','" + vo.getClient_address() + "','" +
        vo.getClient_remark() + "','" + vo.getCreatTime() + "')";
    connection.executeUpdate(sql);
    connection.closeConnection();
  }

//全部查询
  public List clientList() {
    list = new ArrayList();
    ClientVO client = null;
    String sql = "select * from tb_client order by id";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
        client = new ClientVO();
        client.setId(Integer.valueOf(rs.getString(1)));
        client.setClient_number(rs.getString(2));
        client.setClient_name(rs.getString(3));
        client.setClient_ptype(rs.getString(4));
        client.setClient_type(rs.getString(5));
        client.setClient_credit(rs.getString(6));
        client.setClient_content(rs.getString(7));
        client.setClient_provicne(rs.getString(8));
        client.setClient_city(rs.getString(9));
        client.setClient_bank(rs.getString(10));
        client.setClient_bankNumber(rs.getString(11));
        client.setClient_tel(rs.getString(12));
        client.setClient_contact(rs.getString(13));
        client.setClient_email(rs.getString(14));
        client.setClient_address(rs.getString(15));
        client.setClient_remark(rs.getString(16));
        client.setCreatTime(rs.getString(17));
        list.add(client);
      }
    }
    catch (SQLException ex) {
    }
    connection.closeConnection();
    return list;
  }

  //修改编号的操作
  public void clientUpdateNumber(Integer id, String number) {
    String unNumber = "client-" + String.valueOf(id);
    String sql = "update tb_client set client_number='" + unNumber +
        "'  where client_number='" + number + "'";
    connection.executeUpdate(sql);
    connection.closeConnection();
  }

  public void clientUpdate(ClientVO client) {
    String sql = "update tb_client set client_name='" + client.getClient_name() +
        "',client_ptype='" + client.getClient_ptype() + "',client_type='" +
        client.getClient_type() + "',client_credit='" + client.getClient_credit() +
        "',client_content='" + client.getClient_content() + "',client_bank='" +
        client.getClient_bank() + "',client_bankNumber='" +
        client.getClient_bankNumber() + "',client_tel='" + client.getClient_tel() +
        "',client_contact='" + client.getClient_contact() + "',client_email='" +
        client.getClient_email() + "',client_address='" +
        client.getClient_address() + "',client_remark='" +
        client.getClient_remark() + "' where id='" + client.getId() + "'";
    connection.executeUpdate(sql);
    connection.closeConnection();
  }

  //删除信息
  public void clientDelete(Integer id) {
    String sql = "delete from tb_client where id='" + id + "'";
    connection.executeUpdate(sql);
    connection.closeConnection();
  }

}