package com.westsec.service.impl;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import com.westsec.exception.DataSourceException;
import com.westsec.service.OfficeDocumentDAO;
import com.westsec.temp.entity.OfficeDocument;
import com.westsec.temp.entity.UserInfo;
import com.westsec.util.ConnectionPool;
import com.westsec.util.DBConnection;
public class OfficeDocumentDAOImpl implements OfficeDocumentDAO {
DBConnection cpool = null;
Connection conn = null;
@SuppressWarnings("unchecked")
@Override
public ArrayList getAllUserInfoExceptMe(String sql) {
ArrayList list = new ArrayList();
try {
cpool = new ConnectionPool();
conn = cpool.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
UserInfo userinfo = new UserInfo();
userinfo.setId(rs.getString("iId"));
userinfo.setUsername(rs.getString("vUsername"));
list.add(userinfo);
}
return list;
} catch (SQLException e) {
System.err
.println("Error at OfficeDocumentDAOImpl.getAllUserInfoExceptMe(String sql).........");
e.printStackTrace();
} catch (DataSourceException e) {
System.err.println("DataSource error!...............");
e.printStackTrace();
} finally {
closeConn();
}
return list;
}
public OfficeDocument getOfficeDocument(String sql) {
OfficeDocument officeDocument = new OfficeDocument();
try {
cpool = new ConnectionPool();
conn = cpool.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
officeDocument.setId(rs.getString("iId"));
officeDocument.setOfficeDocumentId(rs
.getString("iOfficeDocumentId"));
officeDocument.setTitle(rs.getString("vTitle"));
officeDocument.setUsername(rs.getString("vUsername"));
officeDocument.setContent(rs.getString("vContent"));
officeDocument.setStartTime(rs.getString("vStartTime"));
officeDocument.setPriority(rs.getString("cPriority"));
}
return officeDocument;
} catch (SQLException e) {
System.err
.println("Error at OfficeDocumentDAOImpl.getOfficeDocument(String sql).........");
e.printStackTrace();
} catch (DataSourceException e) {
System.err.println("DataSource error!...............");
e.printStackTrace();
} finally {
closeConn();
}
return officeDocument;
}
@Override
public OfficeDocument getBackOfficeDocument(String sql) {
OfficeDocument officeDocument = new OfficeDocument();
try {
cpool = new ConnectionPool();
conn = cpool.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
officeDocument.setId(rs.getString("iId"));
officeDocument.setTitle(rs.getString("vTitle"));
officeDocument.setContent(rs.getString("vContent"));
officeDocument.setPriority(rs.getString("cPriority"));
}
return officeDocument;
} catch (SQLException e) {
System.err
.println("Error at OfficeDocumentDAOImpl.getBackOfficeDocument(String sql).........");
e.printStackTrace();
} catch (DataSourceException e) {
System.err.println("DataSource error!...............");
e.printStackTrace();
} finally {
closeConn();
}
return officeDocument;
}
@Override
public String updateApply(String sql) {
try {
cpool = new ConnectionPool();
conn = cpool.getConnection();
Statement stmt = conn.createStatement();
int result = stmt.executeUpdate(sql);
if (result > 0) {
return "审批成功！";
} else {
return "审批失败！";
}
} catch (SQLException e) {
System.err
.println("Error at OfficeDocumentDAOImpl.save().........");
e.printStackTrace();
} catch (DataSourceException e) {
System.err.println("DataSource error!...............");
e.printStackTrace();
} finally {
closeConn();
}
return "审批失败！";
}
public String saveApply(String sql) {
try {
cpool = new ConnectionPool();
conn = cpool.getConnection();
Statement stmt = conn.createStatement();
int result = stmt.executeUpdate(sql);
if (result > 0) {
return "审批成功！";
} else {
return "审批失败！";
}
} catch (SQLException e) {
System.err
.println("Error at OfficeDocumentDAOImpl.saveApply(String sql).........");
e.printStackTrace();
} catch (DataSourceException e) {
System.err.println("DataSource error!...............");
e.printStackTrace();
} finally {
closeConn();
}
return "审批失败！";
}
@Override
public String saveDocument(String sql) {
try {
cpool = new ConnectionPool();
conn = cpool.getConnection();
Statement stmt = conn.createStatement();
int result = stmt.executeUpdate(sql);
if (result > 0) {
return "申请成功！";
} else {
return "申请失败！";
}
} catch (SQLException e) {
System.err
.println("Error at OfficeDocumentDAOImpl.saveDocument(String sql)........");
e.printStackTrace();
} catch (DataSourceException e) {
System.err.println("DataSource error!...............");
e.printStackTrace();
} finally {
closeConn();
}
return "申请失败！";
}
@Override
public String updateDocument(String sql) {
try {
cpool = new ConnectionPool();
conn = cpool.getConnection();
Statement stmt = conn.createStatement();
int result = stmt.executeUpdate(sql);
if (result > 0) {
return "修改成功！";
} else {
return "修改失败！";
}
} catch (SQLException e) {
System.err
.println("Error at OfficeDocumentDAOImpl.updateDocument(String sql).......");
e.printStackTrace();
} catch (DataSourceException e) {
System.err.println("DataSource error!...............");
e.printStackTrace();
} finally {
closeConn();
}
return "修改失败！";
}
@SuppressWarnings("unchecked")
@Override
public ArrayList getAllMyApply(String sql) {
ArrayList list = new ArrayList();
try {
cpool = new ConnectionPool();
conn = cpool.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
OfficeDocument office = new OfficeDocument();
office.setId(rs.getString("iId"));
office.setNextApply(rs.getString("vNextApply"));
office.setTitle(rs.getString("vTitle"));
office.setContent("vContent");
office.setStartTime(rs.getString("vStartTime"));
office.setEndTime(rs.getString("vEndTime"));
office.setPriority(rs.getString("cPriority"));
office.setState(rs.getString("cState"));
list.add(office);
}
return list;
} catch (SQLException e) {
System.err
.println("Error at OfficeDocumentDAOImpl.getAllMyApply(String sql).........");
e.printStackTrace();
} catch (DataSourceException e) {
System.err.println("DataSource error!...............");
e.printStackTrace();
} finally {
closeConn();
}
return list;
}
@SuppressWarnings("unchecked")
@Override
public ArrayList getAllToMyApply(String sql) {
ArrayList list = new ArrayList();
try {
cpool = new ConnectionPool();
conn = cpool.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
OfficeDocument office = new OfficeDocument();
office.setId(rs.getString("iId"));
office.setUsername(rs.getString("vUsername"));
office.setTitle(rs.getString("vTitle"));
office.setPriority(rs.getString("cPriority"));
list.add(office);
}
return list;
} catch (SQLException e) {
System.err
.println("Error at OfficeDocumentDAOImpl.getAllToMyApply(String sql).........");
e.printStackTrace();
} catch (DataSourceException
eclipse做的WestsecOA1.0系统
需积分: 0 61 浏览量
更新于2008-12-04
收藏 7.15MB ZIP 举报
WestsecOA1.0系统是基于Eclipse开发的一款企业级办公自动化系统，它集成了多种功能，旨在提高工作效率，简化日常办公流程。Eclipse作为一款强大的集成开发环境（IDE），在Java开发领域有着广泛的应用，因此WestsecOA1.0系统很可能是用Java语言编写的。以下是关于这个系统的详细知识点：
1. **Eclipse IDE**：Eclipse是一个开放源代码的、基于Java的可扩展开发平台。它的核心是一套插件，用于支持各种软件开发项目。Eclipse的灵活性和丰富的插件生态系统使得开发者能够轻松创建和管理复杂的项目。
2. **Java编程**：由于Eclipse主要用于Java开发，WestsecOA1.0系统很可能采用Java语言编写，这使得系统具备跨平台性，可以在任何支持Java的环境中运行。Java的面向对象特性、稳定性和安全性使得它成为开发企业级应用的理想选择。
3. **企业办公自动化（OA）**：OA系统是企业信息化建设的重要组成部分，用于自动化办公流程，如文档管理、审批流程、会议安排等。WestsecOA1.0系统可能包含这些核心功能，以提高工作效率，减少纸质文档的使用，并实现远程协作。
4. **模块化设计**：为了适应不同部门和角色的需求，WestsecOA1.0系统可能采用了模块化设计，每个模块对应特定的办公功能，如人事管理、财务管理、项目管理等，这样可以根据组织结构灵活配置和扩展。
5. **数据库管理**：OA系统通常需要存储大量数据，如用户信息、文档内容、流程状态等，因此WestsecOA1.0系统可能连接到一个关系型数据库（如MySQL、Oracle或SQL Server），以高效、安全地存储和检索数据。
6. **用户界面**：系统应提供直观且友好的用户界面，便于员工操作。这可能包括自定义工作台、菜单、表单和图表，以呈现关键信息。
7. **权限管理**：为了保护敏感信息，系统需要有完善的权限控制机制，允许管理员根据员工角色分配不同的访问和操作权限。
8. **安全性**：WestsecOA1.0系统应遵循最佳安全实践，如数据加密、身份验证、授权和审计日志，以防止未授权访问和数据泄露。
9. **整合能力**：企业级系统往往需要与其他业务系统集成，例如ERP、CRM等。WestsecOA1.0可能提供了API接口或Web服务，以便与其他应用进行数据交换。
10. **持续集成与部署**：作为现代开发实践的一部分，系统可能采用了持续集成/持续部署（CI/CD）流程，利用工具如Jenkins或GitLab CI/CD自动化构建、测试和发布过程。
以上是关于"Eclipse做的WestsecOA1.0系统"的一些关键知识点。由于压缩包子文件的文件名称列表仅给出"WestsecOA"，具体的实现细节和内部结构无法进一步分析。实际的系统可能包含了上述提到的多个组件和功能，以满足企业办公自动化的需求。
eclipse做的WestsecOA1.0系统 （844个子文件） 
spellchecker.cfm 5KB OfficeDocumentDAOImpl.class 9KB UserInfoDAOImpl.class 6KB ContactDAOImpl.class 5KB DepartmentDAOImpl.class 5KB FileUploadDAOImpl.class 5KB OfficeDocumentApplyController.class 5KB PopedomDAOImpl.class 4KB CompanyDAOImpl.class 4KB ContactEditController.class 4KB UserInfoEditController.class 4KB VDEHandle.class 4KB UploadFileController.class 4KB OfficeDocumentAddController.class 4KB DepartmentEditController.class 4KB LoginController.class 4KB ChooseFileReadUserController.class 4KB PopedomListController.class 3KB CompanyListController.class 3KB DepartmentListController.class 3KB PersonalAssistantController.class 3KB ContactListForUserController.class 3KB ContactAddController.class 3KB ContactListController.class 3KB UserInfoAddController.class 3KB OfficeDocument.class 3KB DepartmentAddController.class 3KB UserInfoListController.class 3KB PopedomEditController.class 3KB CompanyEditController.class 3KB OfficeDocumentBackEditCotroller.class 3KB OfficeDocumentApplyOverController.class 3KB OfficeDocumentEditController.class 3KB PopedomAddController.class 3KB CompanyAddController.class 3KB DepartmentDeleteController.class 3KB AdminPopedomFilter.class 3KB UserInfoDeleteController.class 3KB CompanyDeleteController.class 3KB PopedomDeleteController.class 3KB ContactDeleteController.class 3KB UsernameCheck.class 3KB CompanyListForUserController.class 3KB OfficeDocumentTrashController.class 3KB UserPopedomFilter.class 2KB OfficeDocumentToMyApplyForIndexController.class 2KB LogoutTimeFilter.class 2KB LoginTimeFilter.class 2KB OtherMedthodDownFileController.class 2KB OfficeDocumentToMyApplyController.class 2KB FileParticular.class 2KB LoginDAOImpl.class 2KB UserDownLoadFileListController.class 2KB OfficeDocumentMyApplyController.class 2KB OfficeDocumentMyApplyInvalidationController.class 2KB UserInfo.class 2KB OfficeDocumentBackController.class 2KB ConnectionPool.class 2KB AllUserController.class 2KB Contact.class 2KB FileUpadload.class 2KB CharacterEncondingFilter.class 2KB StringUtil.class 1KB Department.class 1KB Popedom.class 953B Company.class 950B SessionCounter.class 881B DataSourceException.class 825B OfficeDocumentDAO.class 603B UserInfoDAO.class 406B FileUploadDAO.class 402B DepartmentDAO.class 397B ContactDAO.class 380B PopedomDAO.class 358B CompanyDAO.class 358B LoginDAO.class 196B DBConnection.class 194B .classpath 2KB fck_editor.css 8KB fck_editor.css 8KB fck_editor.css 8KB fck_dialog.css 6KB fck_dialog.css 6KB fck_dialog.css 6KB site.css 4KB fck_internal.css 4KB fav2.css 2KB fav2.css 2KB displaytag.css 2KB maven-theme.css 2KB maven-base.css 2KB admin.css 2KB fck_editorarea.css 2KB screen.css 2KB dirstlye.css 2KB fck_dialog_common.css 2KB fck_showtableborders_gecko.css 2KB browser.css 2KB alternative.css 1KB spellerStyle.css 890B共 844 条
- 1
- 2
- 3
- 4
- 5
- 6
- 9
2018-04-19 上传
5星 · 资源好评率100%167 浏览量
5星 · 资源好评率100%126 浏览量
180 浏览量
5星 · 资源好评率100% 5星 · 资源好评率100%120 浏览量
5星 · 资源好评率100%103 浏览量
200 浏览量
2007-06-03 上传
5星 · 资源好评率100%142 浏览量
5星 · 资源好评率100%资源评论
tangwei5233
- 粉丝: 19
- 资源: 28
