mylife.respository.userDAO.java Source code

Introduction

Here is the source code for mylife.respository.userDAO.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package mylife.respository;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import java.util.logging.Logger;
import mylife.objects.user;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.support.rowset.SqlRowSet;

/**
 *
 * @author johna
 */
public class userDAO {

    JdbcTemplate template;

    private static final Logger logger = Logger.getLogger(userDAO.class.getName());

    /**
     *
     * @param template
     */
    public void setTemplate(JdbcTemplate template) {
        this.template = template;
    }

    /**
     *
     * @param user
     * @return
     */
    public int save(user user) {
        String sql = "INSERT INTO users (username, password, enabled) values(?,md5(?),?)";

        Object[] values = { user.getUsername(), user.getPassword(), user.getEnabled() };

        logger.info("User DAO save values: " + values);

        int u = template.update(sql, values);

        sql = "INSERT INTO user_roles (username,role) VALUES (?, ?)";

        for (String role : user.getRoles()) {
            Object[] role_values = { user.getUsername(), role };

            logger.info("User DAO add role: " + values);

            template.update(sql, role_values);
        }

        return u;

    }

    /**
     *
     * @param user
     * @return
     */
    public int update(user user) {
        String sql = "UPDATE users SET  password= md5(?), enabled= ? WHERE username= ?";

        Object[] values = { user.getPassword(), user.getEnabled(), user.getUsername() };
        return template.update(sql, values);
    }

    /**
     *
     * @param username
     * @return
     */
    public int delete(String username) {
        String sql = "DELETE FROM users WHERE username=?";

        Object[] values = { username };
        return template.update(sql, values);
    }

    /**
     *
     * @return
     */
    public List<user> getuserList() {
        return template.query("SELECT * FROM users", new RowMapper<user>() {
            public user mapRow(ResultSet rs, int row) throws SQLException {
                user u = new user();
                u.setUsername(rs.getString("username"));
                u.setPassword(rs.getString(" Password"));
                u.setEnabled(rs.getBoolean("enabled"));

                return u;
            }
        });
    }

    /**
     *
     * @param id
     * @return
     */
    public user getuserById(int id) {
        String sql = "SELECT username, (username, password, enabled ) FROM users WHERE username = ?";
        return template.queryForObject(sql, new Object[] { id }, new BeanPropertyRowMapper<user>(user.class));
    }

    /**
     *
     * @param start
     * @param total
     * @return
     */
    public List<user> getuserByPage(int start, int total) {
        String sql = "SELECT * FROM users LIMIT " + (start - 1) + "," + total;

        return template.query(sql, new RowMapper<user>() {
            public user mapRow(ResultSet rs, int row) throws SQLException {
                user u = new user();
                u.setUsername(rs.getString(1));
                u.setPassword(rs.getString(2));
                u.setEnabled(rs.getBoolean(3));

                return u;
            }
        });
    }

    /**
     *
     * @return
     */
    public int getuserCount() {
        String sql = "SELECT COUNT(username) AS rowcount FROM users";
        SqlRowSet rs = template.queryForRowSet(sql);

        if (rs.next()) {
            return rs.getInt("rowcount");
        }

        return 1;
    }

    /**
     *
     * @param username
     * @return
     */
    public user getUsersbyUsername(String username) {
        String sql = "SELECT * FROM users WHERE username = ?";
        return template.queryForObject(sql, new Object[] { username }, new BeanPropertyRowMapper<user>(user.class));
    }
}