cn.itcast.bbs.dao.UserDao.java Source code

Introduction

Here is the source code for cn.itcast.bbs.dao.UserDao.java

Source

/**
 * @(#)UserDao.java, 2015108. 
 * 
 * Copyright 2015 Yodao, Inc. All rights reserved.
 * YODAO PROPRIETARY/CONFIDENTIAL. Use is subject to license terms.
 */
package cn.itcast.bbs.dao;

import java.sql.SQLException;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;

import cn.itcast.bbs.domain.User;
import cn.itcast.bbs.util.JdbcUtil;

/**
 *
 * @author Administrator
 *
 */
public class UserDao {
    /*
     * ?
     */
    public User findUser(String username) throws SQLException {
        QueryRunner runner = new QueryRunner(JdbcUtil.getDataSource());
        String sql = "select *from user where username = ?";
        User userFromDB = runner.query(sql, new BeanHandler(User.class), new Object[] { username });
        return userFromDB;
    }

    /*
     * ??
     */
    public void saveUser(User user) throws SQLException {
        QueryRunner runner = new QueryRunner(JdbcUtil.getDataSource());
        String sql = "insert into user(username,password,gender,email) values(?,?,?,?);";
        runner.update(sql,
                new Object[] { user.getUsername(), user.getPassword(), user.getGender(), user.getEmail() });
    }
}