开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 企业管理 > 查看源码
KhxxDaoImpl.java
资源名称：clientManager.rar　[点击查看]
上传用户：quasar007
上传日期：2022-08-11
资源大小：4067k
文件大小：8k
源码类别：

企业管理

开发平台：

Java

KhxxDaoImpl.java：源码内容
  1. package com.dao;
  3. import com.tool.SQLCode;
  4. import java.util.List;
  5. import java.util.ArrayList;
  6. import com.domain.KhxxForm;
  7. import com.tool.JDBConnection;
  8. import java.sql.ResultSet;
  9. import java.sql.*;
  11. //对客户信息表的操作
  12. public class KhxxDaoImpl
  13.     implements KhxxDao {
  14.   private JDBConnection connection = new JDBConnection();
  16. //查询操作
  17.   public List khxxSelect() {
  18.     List list = new ArrayList();
  19.     KhxxForm form = null;
  20.     String sql = SQLCode.getSQLCode("sql.khxx.select");
  21.     try {
  22.       ResultSet rs = connection.executeQuery(sql);
  23.       while (rs.next()) {
  24.         form = new KhxxForm();
  25.         form.setKhxx_id(rs.getString(1));
  26.         form.setKhxx_mc(rs.getString(2));
  27.         form.setKhxx_qyxz(rs.getString(3));
  28.         form.setKhxx_qylx(rs.getString(4));
  29.         form.setKhxx_qyzx(rs.getString(5));
  30.         form.setKhxx_qydz(rs.getString(6));
  31.         form.setKhxx_szsf(rs.getString(7));
  32.         form.setKhxx_szcs(rs.getString(8));
  33.         form.setKhxx_gsyb(rs.getString(9));
  34.         form.setKhxx_frdb(rs.getString(10));
  35.         form.setKhxx_khyh(rs.getString(11));
  36.         form.setKhxx_yhzh(rs.getString(12));
  37.         form.setKhxx_nsh(rs.getString(13));
  38.         form.setKhxx_ICcard(rs.getString(14));
  39.         form.setKhxx_gswz(rs.getString(15));
  40.         form.setKhxx_gsdh(rs.getString(16));
  41.         form.setKhxx_gscz(rs.getString(17));
  42.         form.setKhxx_lxr(rs.getString(18));
  43.         form.setKhxx_lxrdh(rs.getString(19));
  44.         form.setKhxx_khjb(rs.getString(20));
  45.         form.setKhxx_bz(rs.getString(21));
  46.         list.add(form);
  47.       }
  48.     }
  49.     catch (SQLException ex) {
  50.     }
  51.     connection.close();
  52.     return list;
  53.   }
  55. //以客户编号去单独查询
  56.   public KhxxForm khxxSelectOne(KhxxForm khxx) {
  57.     KhxxForm form = null;
  58.     String sql = SQLCode.getSQLCode("sql.khxx.selectOne");
  59.     sql = connection.editSqlCode(sql, khxx.getKhxx_id());
  60.     try {
  61.       ResultSet rs = connection.executeQuery(sql);
  62.       while (rs.next()) {
  63.         form = new KhxxForm();
  64.         form.setKhxx_id(rs.getString(1));
  65.         form.setKhxx_mc(rs.getString(2));
  66.         form.setKhxx_qyxz(rs.getString(3));
  67.         form.setKhxx_qylx(rs.getString(4));
  68.         form.setKhxx_qyzx(rs.getString(5));
  69.         form.setKhxx_qydz(rs.getString(6));
  70.         form.setKhxx_szsf(rs.getString(7));
  71.         form.setKhxx_szcs(rs.getString(8));
  72.         form.setKhxx_gsyb(rs.getString(9));
  73.         form.setKhxx_frdb(rs.getString(10));
  74.         form.setKhxx_khyh(rs.getString(11));
  75.         form.setKhxx_yhzh(rs.getString(12));
  76.         form.setKhxx_nsh(rs.getString(13));
  77.         form.setKhxx_ICcard(rs.getString(14));
  78.         form.setKhxx_gswz(rs.getString(15));
  79.         form.setKhxx_gsdh(rs.getString(16));
  80.         form.setKhxx_gscz(rs.getString(17));
  81.         form.setKhxx_lxr(rs.getString(18));
  82.         form.setKhxx_lxrdh(rs.getString(19));
  83.         form.setKhxx_khjb(rs.getString(20));
  84.         form.setKhxx_bz(rs.getString(21));
  85.       }
  86.     }
  87.     catch (SQLException ex) {
  88.     }
  89.     connection.close();
  90.     return form;
  91.   }
  93. //#--以数据库中的记录数，查找出多少记录计算,以便做帐号存贮--
  94.   public int khxxCount() {
  95.     int iCount = 0;
  96.     String sql = SQLCode.getSQLCode("sql.khxx.count");
  97.     ResultSet rs = null;
  98.     try {
  99.       rs = connection.executeQuery(sql);
  100.       while (rs.next()) {
  101.         KhxxForm form = new KhxxForm();
  102.         iCount = rs.getInt("t");
  103.       }
  104.     }
  105.     catch (SQLException ex) {
  106.     }
  107.     connection.close();
  108.     return iCount + 1;
  109.   }
  111. //插入操作
  112.   public void khxxInsert(KhxxForm khxx) {
  113.     String sql = SQLCode.getSQLCode("sql.khxx.insert");
  114.     sql = connection.editSqlCode(sql, khxx.getKhxx_id());
  115.     sql = connection.editSqlCode(sql, khxx.getKhxx_mc());
  116.     sql = connection.editSqlCode(sql, khxx.getKhxx_qyxz());
  117.     sql = connection.editSqlCode(sql, khxx.getKhxx_qylx());
  118.     sql = connection.editSqlCode(sql, khxx.getKhxx_qyzx());
  119.     sql = connection.editSqlCode(sql, khxx.getKhxx_qydz());
  120.     sql = connection.editSqlCode(sql, khxx.getKhxx_szsf());
  121.     sql = connection.editSqlCode(sql, khxx.getKhxx_szcs());
  122.     sql = connection.editSqlCode(sql, khxx.getKhxx_gsyb());
  123.     sql = connection.editSqlCode(sql, khxx.getKhxx_frdb());
  124.     sql = connection.editSqlCode(sql, khxx.getKhxx_khyh());
  125.     sql = connection.editSqlCode(sql, khxx.getKhxx_yhzh());
  126.     sql = connection.editSqlCode(sql, khxx.getKhxx_nsh());
  127.     sql = connection.editSqlCode(sql, khxx.getKhxx_ICcard());
  128.     sql = connection.editSqlCode(sql, khxx.getKhxx_gswz());
  129.     sql = connection.editSqlCode(sql, khxx.getKhxx_gsdh());
  130.     sql = connection.editSqlCode(sql, khxx.getKhxx_gscz());
  131.     sql = connection.editSqlCode(sql, khxx.getKhxx_lxr());
  132.     sql = connection.editSqlCode(sql, khxx.getKhxx_lxrdh());
  133.     sql = connection.editSqlCode(sql, khxx.getKhxx_khjb());
  134.     sql = connection.editSqlCode(sql, khxx.getKhxx_bz());
  135.     connection.executeUpdate(sql);
  136.     connection.close();
  137.   }
  139. //删除操作
  140.   public void khxxDelete(KhxxForm khxx) {
  141.     String sql = SQLCode.getSQLCode("sql.khxx.delete");
  142.     sql = connection.editSqlCode(sql, khxx.getKhxx_id());
  143.     connection.executeUpdate(sql);
  144.     connection.close();
  145.   }
  147. //修改操作
  148.   public void khxxUpdate(KhxxForm khxx) {
  149.     String sql = SQLCode.getSQLCode("sql.khxx.update");
  150.     sql = connection.editSqlCode(sql, khxx.getKhxx_mc());
  151.     sql = connection.editSqlCode(sql, khxx.getKhxx_qyxz());
  152.     sql = connection.editSqlCode(sql, khxx.getKhxx_qylx());
  153.     sql = connection.editSqlCode(sql, khxx.getKhxx_qyzx());
  154.     sql = connection.editSqlCode(sql, khxx.getKhxx_qydz());
  155.     sql = connection.editSqlCode(sql, khxx.getKhxx_szsf());
  156.     sql = connection.editSqlCode(sql, khxx.getKhxx_szcs());
  157.     sql = connection.editSqlCode(sql, khxx.getKhxx_gsyb());
  158.     sql = connection.editSqlCode(sql, khxx.getKhxx_frdb());
  159.     sql = connection.editSqlCode(sql, khxx.getKhxx_khyh());
  160.     sql = connection.editSqlCode(sql, khxx.getKhxx_yhzh());
  161.     sql = connection.editSqlCode(sql, khxx.getKhxx_nsh());
  162.     sql = connection.editSqlCode(sql, khxx.getKhxx_ICcard());
  163.     sql = connection.editSqlCode(sql, khxx.getKhxx_gswz());
  164.     sql = connection.editSqlCode(sql, khxx.getKhxx_gsdh());
  165.     sql = connection.editSqlCode(sql, khxx.getKhxx_gscz());
  166.     sql = connection.editSqlCode(sql, khxx.getKhxx_lxr());
  167.     sql = connection.editSqlCode(sql, khxx.getKhxx_lxrdh());
  168.     sql = connection.editSqlCode(sql, khxx.getKhxx_khjb());
  169.     sql = connection.editSqlCode(sql, khxx.getKhxx_bz());
  170.      sql = connection.editSqlCode(sql, khxx.getKhxx_id());
  171.     connection.executeUpdate(sql);
  172.     connection.close();
  173.   }
  174. //根据客户名称去查询
  175.   public KhxxForm khxxMc(KhxxForm khxx) {
  177.     KhxxForm form = null;
  178.      String sql = SQLCode.getSQLCode("sql.khxx.mc");
  179.      sql = connection.editSqlCode(sql, khxx.getKhxx_mc());
  180.      try {
  181.        ResultSet rs = connection.executeQuery(sql);
  182.        while (rs.next()) {
  183.          form = new KhxxForm();
  184.          form.setKhxx_id(rs.getString(1));
  185.          form.setKhxx_mc(rs.getString(2));
  186.          form.setKhxx_qyxz(rs.getString(3));
  187.          form.setKhxx_qylx(rs.getString(4));
  188.          form.setKhxx_qyzx(rs.getString(5));
  189.          form.setKhxx_qydz(rs.getString(6));
  190.          form.setKhxx_szsf(rs.getString(7));
  191.          form.setKhxx_szcs(rs.getString(8));
  192.          form.setKhxx_gsyb(rs.getString(9));
  193.          form.setKhxx_frdb(rs.getString(10));
  194.          form.setKhxx_khyh(rs.getString(11));
  195.          form.setKhxx_yhzh(rs.getString(12));
  196.          form.setKhxx_nsh(rs.getString(13));
  197.          form.setKhxx_ICcard(rs.getString(14));
  198.          form.setKhxx_gswz(rs.getString(15));
  199.          form.setKhxx_gsdh(rs.getString(16));
  200.          form.setKhxx_gscz(rs.getString(17));
  201.          form.setKhxx_lxr(rs.getString(18));
  202.          form.setKhxx_lxrdh(rs.getString(19));
  203.          form.setKhxx_khjb(rs.getString(20));
  204.          form.setKhxx_bz(rs.getString(21));
  206.        }
  207.      }
  208.      catch (SQLException ex) {
  209.      }
  210.      connection.close();
  211.      return form;
  213.   }
  214. }