userdaoimpl.java~6~

来自「JSP+SQL实现了一个拥有添加、删除、查询基本功能的CRM系统」· JAVA~6~ 代码 · 共 63 行

package com.dao;

import com.domain.UserForm;
import com.tool.JDBConnection;
import com.tool.SQLCode;
import java.sql.ResultSet;
import java.sql.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
//操作员
public class UserDaoImpl
    implements UserDao {
  private JDBConnection connection = new JDBConnection();

//登陆操作
  public UserForm checkUser(UserForm form) {
    UserForm user = null;
    String sql = SQLCode.getSQLCode("sql.user.check");
    sql = connection.editSqlCode(sql, form.getUser_name());
    try {
      ResultSet rs = connection.executeQuery(sql);
      while (rs.next()) {
        user = new UserForm();
        user.setId(Integer.valueOf(rs.getString(1)));
        user.setUser_id(rs.getString(2));
        user.setUser_name(rs.getString(3));
        user.setUser_mm(rs.getString(4));
        user.setUser_bs(rs.getString(5));
        user.setMenu_jcxx(rs.getString(6));
        user.setMenu_khxx(rs.getString(7));
        user.setMenu_khfw(rs.getString(8));
        user.setMenu_xxcx(rs.getString(9));
        user.setMenu_fzgj(rs.getString(10));
        user.setMenu_xtgl(rs.getString(11));
        user.setMenu_sjgl(rs.getString(12));
      }
    }
    catch (SQLException ex) {
    }
    return user;
  }

//修改操作员密码
  public void updateUserPassword(UserForm form) {
    String sql = SQLCode.getSQLCode("sql.user.updatePassword");
     sql = connection.editSqlCode(sql, form.getUser_mm());
      sql = connection.editSqlCode(sql, form.getUser_id());
      connection.executeUpdate(sql);
      connection.close();
  }
}