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
新闻发布系统（MVC模式，struts技术） （313个子文件） 
ManagerDaoImpl.class 6KB NewsDaoImpl.class 5KB VoteDaoImpl.class 3KB NewsStyleDaoImpl.class 3KB LinkDaoImpl.class 3KB NewsTypeDaoImpl.class 3KB JDBConnection.class 3KB ManagerFacadeImpl.class 2KB SelectOneStyleAction.class 2KB AdminUpdateAction.class 2KB NewContentNext.class 2KB ManagerCheckAction.class 2KB VoteUpdateAction.class 2KB UpdateNewsAction.class 2KB ManagerInsertAction.class 2KB ManagerActionForm.class 2KB AdminSelectOneAction.class 2KB ManagerCheckNameAction.class 2KB updateStyleAction.class 2KB TypeSelectOneAction.class 2KB ManagerSelectOneAction.class 2KB AdminCheckAction.class 2KB AdminCheckPasswordAction.class 2KB LinkUpdateAction.class 2KB VoteInsertAction.class 2KB KeyNewsWatch.class 2KB TypeUpdateAction.class 2KB SelectStyleAction.class 2KB ManagerUpdateAction.class 2KB VoteActionForm.class 2KB InsertNewsAction.class 2KB SelectMainAction.class 2KB SelectTypeContentAction.class 2KB KeyNewWatchContent.class 2KB NewsTypeWatch.class 2KB VoteSelectOneAction.class 2KB SelectOneNewsAction.class 2KB LinkSelectOneAction.class 2KB NewsContentAction.class 2KB InsertStyleAction.class 2KB DateNewsContent.class 2KB NewsContent.class 2KB ManagerSelectAction.class 2KB AdminUpdatePasswordAction.class 2KB AdminSelectAction.class 2KB NewsActionForm.class 2KB TypeInsertAction.class 2KB DeleteStyleAction.class 2KB LInkInsertAction.class 2KB TypeNewWatch.class 2KB TypeDeleteAction.class 2KB DeleteNewsAction.class 2KB LinkDeleteAction.class 2KB VoteDeleteAction.class 2KB LinkSelect.class 2KB AddVote.class 2KB AdminDeleteAction.class 2KB WatchStyleAction.class 2KB TypeWarchAction.class 2KB TypeAction.class 2KB LinkSelcetAction.class 2KB NewsFacadeImpl.class 2KB ManagerCheckPasswordAction.class 2KB DateNews.class 1KB AdminSelectPasswordAction.class 1KB SelectTypeAction.class 1KB VoteSelectNumber.class 1KB TypeTopAction.class 1KB VoteSelectAction.class 1KB NewsWatchAction.class 1KB VoteSelect.class 1KB NewsStyleActionForm.class 1KB NewsStyleFacadeImpl.class 1KB LinkActionForm.class 1KB VoteFacadeImpl.class 1KB NewsTypeFacadeImpl.class 1KB NewsTypeActionForm.class 1KB LinkFacadeImpl.class 1KB ManagerFacade.class 717B ManagerDao.class 707B Chinese.class 583B NewsFacade.class 477B NewsDao.class 467B NewsStyleFacade.class 384B SessionLib.class 378B NewsStyleDao.class 374B VoteFacade.class 362B NewsTypeFacade.class 359B VoteDao.class 352B NewsTypeDao.class 349B LinkFacade.class 344B LinkDao.class 334B .classpath 481B org.eclipse.wst.common.component 396B
a.gif 57KB managerCheckFail.gif 23KB managerCheck.gif 23KB diamonds.gif 773B blank.htm 0B blank.htm 0B共 313 条
- 1
- 2
- 3
- 4
资源评论
jiaowodan_ge2014-03-13还好吧，需要补充和改进的地方挺多
gyh_wust2014-02-27感觉你这个文件很逗啊！！！！！！
wangxin396
- 粉丝: 1
- 资源: 6
最新资源
- 搜索引擎lucen的相关介绍 从事搜索行业程序研发、人工智能、存储等技术人员和企业
- 基于opencv-dnn和一些超过330 FPS的npu
- 房屋租赁管理系统 java项目ssm框架开发,全套视频教程
- MATLAB代码：计及电转气协同的含碳捕集与垃圾焚烧电厂优化调度 关键词：碳捕集 电厂 需求响应 优化调度 电转气协同调度 参考文档：《计及电转气协同的含碳捕集与垃圾焚烧电厂优化调度》完全复现
- 关键词：微网 优化调度 深度强化学习 A3C 需求响应 编程语言：python平台 主题：基于改进A3C算法的微网优化调度与需求响应管理 内容简介： 代码主要做的是基于深度强化学习的微网
- web网页，三次平时作业+大作业+Acwing笔记
- cruise软件模型，混动仿真模型，IMMD架构混联混动仿真模型，Cruise混动仿真模型，混联混动汽车动力性经济性仿真 关于模型 1.本模型是基于IMMD架构搭载的混联混动仿真模型，关于IMMD架
- C#上位机开发源码 上位机项目源代码 采用基于RS485通讯总线的ModbusRtu协议，支持用户权限管理、sqlite数据库、实时曲线、历史曲线、历史报表、导出Excel、主界面布局可调带记忆等功能
- 基于plc的污水处理，组态王动画仿真，带PLC源代码,组态王源代码，图纸，IO地址分配
- Rhino(犀牛)插件ladybug-tools-1-8-0
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
