综合案例-黑马旅游网_Dao代码实现和Serlvet实现和测试

综合案例-黑马旅游网_Dao代码实现

dao接口

package com.bai.dao;

import com.bai.domain.User;

public interface UserDao {
    /**
     * 根据用户名查询用户信息
     * @param username
     * @return
     */
    public User findByUsername(String username);

    /**
     * 用户保存
     * @param user
     */
    public void save(User user);
}

dao实现类

package com.bai.dao.impl;

import com.bai.dao.UserDao;
import com.bai.domain.User;
import com.bai.util.JDBCUtils;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;

public class UserDaoImpl implements UserDao {
    private JdbcTemplate template = new JdbcTemplate(JDBCUtils.getDataSource());

    @Override
    public User findByUsername(String username) {
        User user = null;
        try {
            //定义sql
            String sql="select  * from tab_user where username=?";
            //执行sql
            user = template.queryForObject(sql, new BeanPropertyRowMapper<User>(User.class), username);
        } catch (Exception e) {

        }
        return user;
    }

    @Override
    public void save(User user) {
        //定义sql
        String sql="insert into user(username,password,name,birthday,sex,telephone,email) values (?,?,?,?,?,?,?)";
        //执行sql
        template.update(sql,user.getUsername(),
                user.getPassword(),
                user.getName(),
                user.getBirthday(),
                user.getSex(),
                user.getTelephone(),
                user.getEmail());
    }
}

综合案例-黑马旅游网_Serlvet实现和测试

java代码

package com.bai.service.impl;

import com.bai.dao.UserDao;
import com.bai.dao.impl.UserDaoImpl;
import com.bai.domain.User;
import com.bai.service.UserService;

public class UserServiceImpl implements UserService {
    private UserDao userDao = new UserDaoImpl();

    /**
     *注册用户
     * @param user
     * @return
     */
    @Override
    public boolean regist(User user) {
        //根据用户名查询用户对象
        User u = userDao.findByUsername(user.getUsername());
        //判断u是否为null
        if (u !=null){
            //用户名存在 注册失败
            return false;
        }
        //保存用户数据
        userDao.save(user);
        return true;
    }
}

运行结果