黑猴子的家：Stock(十 二) 创建 UserServiceImpl 接口实现类

1、serviceimpl包下 –> New -> Class

2、Name -> UserServiceImpl -> Finish

3、UserServiceImpl 类的内容

package com.yg.serviceimpl;

import java.util.List;
import com.yg.dao.UserDao;
import com.yg.entity.User;
import com.yg.service.UserService;

public class UserServiceImpl implements UserService {

      UserDao userDao = new UserDao();

      /**
       * 用户登录 查询一个对象
       * @param user
       * @param pwd
       * @return
       */
      public User login(String user, String pwd) {
            String sql = "select * from k_user where userno=? And pwd=?";
            // Object[] params = { user, pwd };
            User usersingle = null;
            try {
                  usersingle = userDao.querySingle(sql, user, pwd);
            } catch (Exception e) {
                  e.printStackTrace();
            }
            return usersingle;
      }

      /**
       * 获取所有用户 查询一个集合
       * @return
       */
      public List<User> get_All_Users() {
            String sql = "select * from k_user order by id asc";
            List<User> userList = null;
            try {
                  userList = userDao.queryList(sql);
            } catch (Exception e) {
                  e.printStackTrace();
            }
            return userList;
      }

      /**
       * 插入数据
       * 
       * @param user
       * @return
       */
      public Boolean add_User(User user) {
            String sql = "insert into k_user(username,userno,pwd) values(?,?,?)";
            int update = 0;
            try {
                  update = userDao.update(sql,
                                                      user.getUsername(),
                                                      user.getUserno(),
                                                      user.getPwd());
            } catch (Exception e) {
                  // TODO Auto-generated catch block
                  e.printStackTrace();
            }
            return update > 0;
      }

      /**
       * 删除数据
       * 
       * @param id
       * @return
       */
      public Boolean delete_User(String id) {
            String sql = "delete from k_user where id=?";
            int update = 0;
            try {
                  update = userDao.update(sql, id);
            } catch (Exception e) {
                  e.printStackTrace();
            }
            return update > 0;
      }

      /**
       * 修改
       * 
       * @param user
       * @return
       */
      public Boolean edit_User(User user) {
            String sql = "update k_user set username=?,userno=?,pwd=? where id=?";
            int update = 0;
            try {
                  update = userDao.update(sql, 
                                                      user.getUsername(),
                                                      user.getUserno(),
                                                      user.getPwd(),
                                                      user.getId());
            } catch (Exception e) {
                  // TODO Auto-generated catch block
                  e.printStackTrace();
            }
            return update > 0;
      }
}