@@ -0,0 +1,1903 @@
+package seu.dao;%0A%0Aimport seu.domain.Admin;%0A%0Aimport org.springframework.beans.factory.annotation.Autowired;%0Aimport org.springframework.jdbc.core.JdbcTemplate;%0Aimport org.springframework.jdbc.core.RowMapper;%0Aimport org.springframework.stereotype.Repository;%0A%0Aimport java.sql.ResultSet;%0Aimport java.sql.SQLException;%0Aimport java.util.List;%0A%0A@Repository%0Apublic class AdminDao %7B%0A%0A    private JdbcTemplate jdbcTemplate;%0A%0A    @Autowired%0A    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) %7B%0A        this.jdbcTemplate = jdbcTemplate;%0A    %7D%0A%0A    public int insertAdmin(final Admin admin)%7B%0A        final String sql = %22INSERT INTO Admin(AdminID,Password) VALUES(?,?)%22;%0A        Object%5B%5D params = new Object%5B%5D%7Badmin.getAdminId(),admin.getPassword()%7D;%0A        return jdbcTemplate.update(sql, params );%0A    %7D%0A%0A    public int insertAdmin(final int id, final String password)%7B%0A        final String sql = %22INSERT INTO Admin(AdminID,Password) VALUES(?,?)%22;%0A        Object%5B%5D params = new Object%5B%5D %7Bid,password%7D;%0A        return jdbcTemplate.update(sql, params);%0A    %7D%0A%0A    public int deleteAdminById(final int id)%7B%0A        final String sql = %22DELETE FROM Admin WHERE AdminID = ?%22;%0A        Object%5B%5D params = new Object%5B%5D %7Bid%7D;%0A        return jdbcTemplate.update(sql, params);%0A    %7D%0A%0A    public int updateAdminPasswordById(final int id, final String password)%7B%0A        final String sql = %22UPDATE Admin SET Password = ? WHERE AdminID = ?%22;%0A        Object%5B%5D params = new Object%5B%5D %7Bid, password%7D;%0A        return jdbcTemplate.update(sql, params);%0A    %7D%0A%0A    public List%3CAdmin%3E queryAll()%7B%0A        final String sql = %22SELECT * FROM Admin%22 ;%0A        return (List%3CAdmin%3E)jdbcTemplate.query(sql, new RowMapper() %7B%0A            public Admin mapRow(ResultSet rs, int rowNum) throws SQLException %7B%0A                return new Admin(rs.getInt(%22AdminID%22), rs.getString(%22Password%22)%0A                );%0A            %7D%0A        %7D);%0A    %7D%0A%7D%0A

Add AdminDao.java