package com.victor.dao;
import java.util.List;
import java.util.ArrayList;
import com.victor.tool.JDBConnection;
import java.sql.ResultSet;
import java.sql.*;
import com.victor.domain.ManagerActionForm;
public class ManagerDaoImpl
implements ManagerDao {
//查出所有的管理员
public List managerSelect(ManagerActionForm managerActionForm) {
JDBConnection connection = new JDBConnection();
List list = new ArrayList();
String sql = "select * from tb_manager where mark='" +
managerActionForm.getManagerMark() + "'";
try {
ResultSet rs = connection.executeQuery(sql);
while (rs.next()) {
ManagerActionForm manager = new ManagerActionForm();
manager.setManagerID(Integer.valueOf(rs.getString(1)));
manager.setManagerName(rs.getString(2));
manager.setManagerPassword(rs.getString(3));
manager.setManagerRealName(rs.getString(4));
manager.setManagerIssueDate(rs.getString(5));
manager.setManagerMark(rs.getString(6));
list.add(manager);
}
connection.close();
}
catch (SQLException ex) {
}
return list;
}
//核对普通管理员帐号和密码
public ManagerActionForm managerCheck(ManagerActionForm managerActionForm) {
ManagerActionForm manager = null;
JDBConnection connection = new JDBConnection();
String sql = "select * from tb_manager where Name='" +
managerActionForm.getManagerName() + "'";
try {
ResultSet rs = connection.executeQuery(sql);
while (rs.next()) {
manager = new ManagerActionForm();
manager.setManagerPassword(rs.getString(3));
}
}
catch (SQLException ex) {
}
connection.close();
return manager;
}
//普通管理员修改密码
public void managerUpdate(ManagerActionForm managerActionForm) {
JDBConnection connection = new JDBConnection();
String sql = "update tb_manager set Password='" +
managerActionForm.getManagerPassword() + "' where ID='" +
managerActionForm.getManagerID() + "'";
connection.executeUpdate(sql);
connection.close();
}
//普通管理员的单独查找之后，查找的数据在下一页显示
public List managerSelectOne(ManagerActionForm managerActionForm) {
List list = new ArrayList();
JDBConnection connection = new JDBConnection();
String sql = "select * from tb_manager where ID='" +
managerActionForm.getManagerID() + "'";
try {
ResultSet rs = connection.executeQuery(sql);
while (rs.next()) {
ManagerActionForm manager = new ManagerActionForm();
manager.setManagerID(Integer.valueOf(rs.getString(1)));
manager.setManagerPassword(rs.getString(3));
list.add(manager);
}
}
catch (SQLException ex) {
}
connection.close();
return list;
}
//核对总管理员帐号和密码
public ManagerActionForm adminCheck(ManagerActionForm managerActionForm) {
ManagerActionForm manager = null;
JDBConnection connection = new JDBConnection();
String sql = "select * from tb_manager where Name='" +
managerActionForm.getManagerName() + "' and mark='" +
managerActionForm.getManagerMark() + "'";
try {
ResultSet rs = connection.executeQuery(sql);
while (rs.next()) {
manager = new ManagerActionForm();
manager.setManagerPassword(rs.getString(3));
}
}
catch (SQLException ex) {
}
connection.close();
return manager;
}
//普通管理员注册
public void managerInsert(ManagerActionForm managerActionForm) {
JDBConnection connection = new JDBConnection();
String sql = "insert into tb_manager values('" +
managerActionForm.getManagerName() + "','" +
managerActionForm.getManagerPassword() +
"','" +
managerActionForm.getManagerRealName() + "',getDate(),'" +
managerActionForm.getManagerMark() + "')";
connection.executeUpdate(sql);
connection.close();
}
//普通管理员注册之前，核对是否有这个帐户名称
public String managerCheckName(ManagerActionForm managerActionForm) {
ManagerActionForm manager = null;
String name = "";
JDBConnection connection = new JDBConnection();
String sql = "select * from tb_manager where Name='" +
managerActionForm.getManagerName() + "'";
ResultSet rs = connection.executeQuery(sql);
try {
while (rs.next()) {
manager = new ManagerActionForm();
manager.setManagerName(rs.getString(2));
name = rs.getString(2);
}
}
catch (SQLException ex) {
}
connection.close();
return name;
}
//总管理员删除任何一个普通管理员
public void adminDelete(ManagerActionForm managerActionForm) {
JDBConnection connection = new JDBConnection();
String sql = "delete from tb_manager where ID='" +
managerActionForm.getManagerID() + "'";
connection.executeUpdate(sql);
connection.close();
}
//总管理员的单独查找，查找的内容在下一页中显示
public List adminSelectOne(ManagerActionForm managerActionForm) {
ManagerActionForm manager = null;
List list = new ArrayList();
JDBConnection connection = new JDBConnection();
String sql = "select * from tb_manager where ID='" +
managerActionForm.getManagerID() + "'";
ResultSet rs = connection.executeQuery(sql);
try {
while (rs.next()) {
manager = new ManagerActionForm();
manager.setManagerID(Integer.valueOf(rs.getString(1)));
manager.setManagerName(rs.getString(2));
manager.setManagerPassword(rs.getString(3));
manager.setManagerRealName(rs.getString(4));
manager.setManagerIssueDate(rs.getString(5));
manager.setManagerMark(rs.getString(6));
list.add(manager);
}
}
catch (SQLException ex) {
}
connection.close();
return list;
}
//总管理员修改普通管理员
public void adminUpdate(ManagerActionForm managerActionForm) {
JDBConnection connection = new JDBConnection();
String sql = "update tb_manager set Name='" +
managerActionForm.getManagerName() + "',Password='" +
managerActionForm.getManagerPassword() + "',RealName='" +
managerActionForm.getManagerRealName() + "',mark='" +
managerActionForm.getManagerMark() + "' where ID='" +
managerActionForm.getManagerID() + "'";
connection.executeUpdate(sql);
connection.close();
}
//修改总管理员的密码之前核对
public String adminCheckPassword(ManagerActionForm managerActionForm) {
JDBConnection connection = new JDBConnection();
String sql = "select * from tb_manager where password = '" +
managerActionForm.getManagerPassword() + "'";
String password = "";
ResultSet rs = connection.executeQuery(sql);
try {
while (rs.next()) {
password = rs.getString(3);
}
}
catch (SQLException ex) {
}
connection.close();
return password;
}
//修改总管理员的密码之前查出总管理员密码
public String adminSelectPassword() {
ManagerActionForm manager = null;
JDBConnection connection = new JDBConnection();
String sql = "select * from tb_manager where Name='mr' and mark='总管理员'";
String password = "";
ResultSet rs = connection.executeQuery(sql);
try {
while (rs.next()) {
manager = new ManagerActionForm();
manager.setManagerPassword(rs.getString(3));
password = rs.getString(3);
}
}
catch (SQLException ex) {
}
connection.close();
return password;
}
//修改管理员的密码
public void adminUpdatePassword(ManagerActionForm managerActionForm) {
JDBConnection connection = new JDBConnection();
String sql = "update tb_manager set Password='" +
managerActionForm.getManagerPassword() + "' where mark='总管理员'";
connecti
Struts+MSSQL新闻系统
需积分: 0 33 浏览量
2008-09-04
16:48:39
上传
评论
收藏 2.34MB RAR 举报
Struts+MSSQL新闻系统 （299个子文件） 
ManagerDaoImpl.class 6KB NewsDaoImpl.class 5KB NewsTypeDaoImpl.class 4KB NewsStyleDaoImpl.class 4KB VoteDaoImpl.class 4KB LinkDaoImpl.class 3KB JDBConnection.class 2KB ManagerFacadeImpl.class 2KB SelectStyleAction.class 2KB SelectOneStyleAction.class 2KB NewContentNext.class 2KB VoteUpdateAction.class 2KB AdminUpdateAction.class 2KB ManagerActionForm.class 2KB UpdateNewsAction.class 2KB ManagerCheckAction.class 2KB ManagerCheckNameAction.class 2KB AdminCheckAction.class 2KB updateStyleAction.class 2KB AdminCheckPasswordAction.class 2KB TypeSelectOneAction.class 2KB ManagerInsertAction.class 2KB VoteActionForm.class 2KB AdminSelectOneAction.class 2KB LinkUpdateAction.class 2KB VoteInsertAction.class 2KB TypeUpdateAction.class 2KB InsertNewsAction.class 2KB ManagerSelectOneAction.class 2KB KeyNewsWatch.class 2KB SelectMainAction.class 2KB SelectTypeContentAction.class 2KB LinkSelectOneAction.class 2KB NewsContentAction.class 2KB SelectOneNewsAction.class 2KB DateNewsContent.class 2KB VoteSelectOneAction.class 2KB KeyNewWatchContent.class 2KB SelectTypeAction.class 2KB NewsTypeWatch.class 2KB InsertStyleAction.class 2KB ManagerUpdateAction.class 2KB NewsContent.class 2KB AdminUpdatePasswordAction.class 2KB NewsActionForm.class 2KB TypeInsertAction.class 2KB LinkInsertAction.class 2KB DeleteStyleAction.class 2KB ManagerSelectAction.class 2KB TypeDeleteAction.class 2KB AdminSelectAction.class 2KB DeleteNewsAction.class 2KB LinkDeleteAction.class 2KB VoteDeleteAction.class 2KB ManagerCheckPasswordAction.class 2KB AdminSelectPasswordAction.class 2KB AddVote.class 2KB LinkSelect.class 2KB WatchStyleAction.class 2KB TypeAction.class 2KB TypeWarchAction.class 2KB TypeNewWatch.class 2KB LinkSelectAction.class 2KB NewsFacadeImpl.class 2KB AdminDeleteAction.class 1KB VoteSelect.class 1KB VoteSelectNumber.class 1KB TypeTopAction.class 1KB VoteSelectAction.class 1KB NewsWatchAction.class 1KB NewsTypeFacadeImpl.class 1KB NewsStyleActionForm.class 1KB DateNews.class 1KB NewsStyleFacadeImpl.class 1KB LinkActionForm.class 1KB VoteFacadeImpl.class 1KB NewsTypeActionForm.class 1KB LinkFacadeImpl.class 1KB ManagerFacade.class 717B ManagerDao.class 707B Chinese.class 612B NewsFacade.class 477B NewsDao.class 467B NewsTypeFacade.class 409B NewsTypeDao.class 399B NewsStyleFacade.class 384B SessionLib.class 378B NewsStyleDao.class 374B VoteFacade.class 362B VoteDao.class 352B LinkFacade.class 344B LinkDao.class 334B .classpath 1KB
a.gif 57KB managerCheckFail.gif 23KB managerCheck.gif 23KB diamonds.gif 773B blank.htm 0B blank.htm 0B
struts.jar 323KB共 299 条
- 1
- 2
- 3
评论0