clientstyledao.java~5~

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

package com.dao;

import com.tool.JDBConnection;
import java.util.*;
import com.domain.ClientStyleVO;
import java.sql.*;
//对单位类型的操作
public class ClientStyleDao {
  private JDBConnection connection = null;
  public ClientStyleDao() {
    connection = new JDBConnection();
    this.connection.creatConnection(); //利用构造方法调用类中的对象对数据库创建连接
  }

  //查询所有单位类型的信息
  public List bankSelect() {
    List list = new ArrayList();
    ClientStyleVO clientStyle = null;
    String sql = "select * from tb_clientStyle order by id";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
        clientStyle = new ClientStyleVO();
        clientStyle.setId(Integer.valueOf(rs.getString(1)));
        clientStyle.setClientStyle_number(rs.getString(2));
        clientStyle.setClientStyle_name(rs.getString(3));
        clientStyle.setClientStyle_remark(rs.getString(4));
        list.add(clientStyle);
      }
    }
    catch (SQLException ex) {
    }
    connection.closeConnection();
    return list;
  }

  //以数据库流水号为条件查询银行信息
  public ClientStyleVO clientStyleSelectOne(String number) {
    ClientStyleVO clientStyle = null;
    String sql = "select * from tb_clientStyle where clientStyle_number='" + number + "'";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
        clientStyle = new ClientStyleVO();
        clientStyle.setId(Integer.valueOf(rs.getString(1)));
        clientStyle.setClientStyle_name(rs.getString(2));
        clientStyle.setClientStyle_number(rs.getString(3));
        clientStyle.setClientStyle_remark(rs.getString(4));
      }
    }
    catch (SQLException ex) {
    }
    connection.closeConnection();
    return clientStyle;
  }
  //单位类型为条件查询银行信息
  public ClientStyleVO clientStyleSelectName(String name) {
    ClientStyleVO clientStyle = null;
    String sql = "select * from tb_clientStyle where clientStyle_name='" + name + "'";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
        clientStyle = new ClientStyleVO();
        clientStyle.setId(Integer.valueOf(rs.getString(1)));
        clientStyle.setClientStyle_number(rs.getString(2));
        clientStyle.setClientStyle_name(rs.getString(3));
        clientStyle.setClientStyle_remark(rs.getString(4));
      }
    }
    catch (SQLException ex) {
    }
    connection.closeConnection();
    return clientStyle;
  }

  //删除单位类型信息
  public void clientStyleDelete(Integer id) {
    String sql = "delete from tb_clientStyle where id='" + id + "'";
    connection.executeUpdate(sql);
    connection.closeConnection();
  }

//添加单位类型信息
  public void clientStyleInsert(ClientStyleVO vo) {
    String sql = "insert into tb_clientStyle values ('" + vo.getClientStyle_number() + "','" +
        vo.getClientStyle_name() + "','" + vo.getClientStyle_remark() + "')";
    connection.executeUpdate(sql);
    connection.closeConnection();
  }

//修改单位类型信息
  public void clientStyleUpdate(ClientStyleVO vo) {
    String sql =
        "update tb_clientStyle set clientStyle_name='" + vo.getClientStyle_name() +
        "',clientStyle_remark='" +
        vo.getClientStyle_remark() + "' where id=" + vo.getId() + "";
    connection.executeUpdate(sql);
    connection.closeConnection();
  }

//修改单位类型编号
  public void clientStyleUpdateNumber(String number, Integer id) {
    String sql =
        "update tb_clientStyle set clientStyle_number='" + number +
        "' where id=" + id + "";
    connection.executeUpdate(sql);
    connection.closeConnection();
  }

}