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

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

企业管理

开发平台：

Java

UserDaoImpl.java：源码内容
  1. package com.dao;
  3. import com.domain.UserForm;
  4. import com.tool.JDBConnection;
  5. import com.tool.SQLCode;
  6. import java.sql.ResultSet;
  7. import java.sql.*;
  8. import java.util.List;
  9. import java.util.ArrayList;
  11. /**
  12.  * <p>Title: </p>
  13.  *
  14.  * <p>Description: </p>
  15.  *
  16.  * <p>Copyright: Copyright (c) 2005</p>
  17.  *
  18.  * <p>Company: </p>
  19.  *
  20.  * @author not attributable
  21.  * @version 1.0
  22.  */
  23. //操作员
  24. public class UserDaoImpl
  25.     implements UserDao {
  26.   private JDBConnection connection = new JDBConnection();
  28. //登陆操作
  29.   public UserForm checkUser(UserForm form) {
  30.     UserForm user = null;
  31.     String sql = SQLCode.getSQLCode("sql.user.check");
  32.     sql = connection.editSqlCode(sql, form.getUser_name());
  33.     try {
  34.       ResultSet rs = connection.executeQuery(sql);
  35.       while (rs.next()) {
  36.         user = new UserForm();
  37.         user.setId(Integer.valueOf(rs.getString(1)));
  38.         user.setUser_id(rs.getString(2));
  39.         user.setUser_name(rs.getString(3));
  40.         user.setUser_mm(rs.getString(4));
  41.         user.setUser_bs(rs.getString(5));
  42.         user.setMenu_jcxx(rs.getString(6));
  43.         user.setMenu_khxx(rs.getString(7));
  44.         user.setMenu_khfw(rs.getString(8));
  45.         user.setMenu_xxcx(rs.getString(9));
  46.         user.setMenu_fzgj(rs.getString(10));
  47.         user.setMenu_xtgl(rs.getString(11));
  48.         user.setMenu_sjgl(rs.getString(12));
  49.       }
  50.     }
  51.     catch (SQLException ex) {
  52.     }
  53.     return user;
  54.   }
  56. //修改操作员密码
  57.   public void updateUserPassword(UserForm form) {
  58.     String sql = SQLCode.getSQLCode("sql.user.updatePassword");
  59.     sql = connection.editSqlCode(sql, form.getUser_mm());
  60.     sql = connection.editSqlCode(sql, form.getUser_id());
  61.     connection.executeUpdate(sql);
  62.     connection.close();
  63.   }
  65. //查询授权的操作
  66.   public List selectUserBs(UserForm form) {
  67.     List list = new ArrayList();
  68.     UserForm user = null;
  69.     String sql = SQLCode.getSQLCode("sql.user.selectUser_bs");
  70.     sql = connection.editSqlCode(sql, form.getUser_bs());
  71.     try {
  72.       ResultSet rs = connection.executeQuery(sql);
  73.       while (rs.next()) {
  74.         user = new UserForm();
  75.         user.setId(Integer.valueOf(rs.getString(1)));
  76.         user.setUser_id(rs.getString(2));
  77.         user.setUser_name(rs.getString(3));
  78.         user.setUser_mm(rs.getString(4));
  79.         user.setUser_bs(rs.getString(5));
  80.         user.setMenu_jcxx(rs.getString(6));
  81.         user.setMenu_khxx(rs.getString(7));
  82.         user.setMenu_khfw(rs.getString(8));
  83.         user.setMenu_xxcx(rs.getString(9));
  84.         user.setMenu_fzgj(rs.getString(10));
  85.         user.setMenu_xtgl(rs.getString(11));
  86.         user.setMenu_sjgl(rs.getString(12));
  87.         list.add(user);
  88.       }
  89.     }
  90.     catch (SQLException ex) {
  91.     }
  92.     return list;
  94.   }
  96. //修改权利
  97.   public void updateUserRight(UserForm form) {
  98.     String sql = SQLCode.getSQLCode("sql.user.updateSelectRight");
  99.     sql = connection.editSqlCode(sql, form.getMenu_jcxx());
  100.     sql = connection.editSqlCode(sql, form.getMenu_khxx());
  101.     sql = connection.editSqlCode(sql, form.getMenu_khfw());
  102.     sql = connection.editSqlCode(sql, form.getMenu_xxcx());
  103.     sql = connection.editSqlCode(sql, form.getMenu_fzgj());
  104.     sql = connection.editSqlCode(sql, form.getMenu_sjgl());
  105.     sql = connection.editSqlCode(sql, form.getUser_id());
  106.     connection.executeUpdate(sql);
  107.     connection.close();
  109.   }
  111. //帐号唯一性的操作
  112.   public int countID() {
  113.     int iCount = 0;
  114.     String sql = SQLCode.getSQLCode("sql.user.countID");
  115.     ResultSet rs = null;
  116.     try {
  117.       rs = connection.executeQuery(sql);
  118.       while (rs.next()) {
  120.         iCount = rs.getInt("t");
  121.       }
  122.     }
  123.     catch (SQLException ex) {
  124.     }
  125.     connection.close();
  126.     return iCount + 1;
  128.   }
  130.   public void insertUserRight(UserForm form) {
  131.     String sql = SQLCode.getSQLCode("sql.user.insert");
  132.     sql = connection.editSqlCode(sql, form.getUser_id());
  133.     sql = connection.editSqlCode(sql, form.getUser_name());
  134.     sql = connection.editSqlCode(sql, form.getUser_mm());
  136.     connection.executeUpdate(sql);
  137.     connection.close();
  139.   }
  141.   public void deleteUserRight(UserForm form) {
  142.     String sql = SQLCode.getSQLCode("sql.user.delete");
  143.     sql = connection.editSqlCode(sql, form.getUser_id());
  144.     connection.executeUpdate(sql);
  145.     connection.close();
  147.   }
  148. }