《（员工管理）开发人员手册》由会员分享，可在线阅读，更多相关《（员工管理）开发人员手册（38页珍藏版）》请在金锄头文库上搜索。
1、开发人员手册1.0 软件的下载与安装必备的安装软件： JDK 1.6直接安装，全部选择确定。 Eclipse Mysql 5.6. Navicat 11.1.9 Tomcat 7.0 2.Eclipse+Tomcat配置3 Eclipse项目搭建与开发 1.打开Eclipse-file-New-project选择项目按Alt+Enter把mysql-connector-java-5.1.33-bin 框架包放入OA项目WEB-Info/lib 目录下创建项目WebContent/WEB-INF 目录下创建web.xml3.1 Mysql数据库创建项目后端开发。1. 数据库的连接封装引入JDBC
2、的驱动，可以从mysql的安装目录中找到。创建一个数据库连接类package org.bn.oa.conn;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class OAConn private Connection conn;public OAConn()try Class.forName(com.mysql.jdbc.Driver); catch (ClassNotFoundException e) / TODO: handle exceptione.
3、printStackTrace();public Connection getConnection()try conn=DriverManager.getConnection(jdbc:mysql:/localhost:3306/oa, root, root); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return this.conn;public void closeConnection()try conn.close(); catch (SQLException e) / TOD
4、O Auto-generated catch blocke.printStackTrace();2. 实体层创建一个包，用来存放实体，每一个实体与数据库中的一张表进行对应。 创建一个新的实体类User对User类的属性定义package org.bn.oa.beans;public class User private int id;public int getUserId() return this.id;public void setUserId(int userid) this.id = userid;private String name;public String getName()
5、 return this.name;public void setUserName(String username) this.name = username;private String sex;public String getUserSex() return this.sex;public void setUserSex(String usersex) this.sex = usersex;private String identityNum;public String getIdentityNum() return this.identityNum;public void setIde
6、ntityNum(String identitynum) this.identityNum = identitynum;private int isvalid;public int getIsValid() return this.isvalid;public void setIsValid(int isvalid) this.isvalid = isvalid;private String telephone;public String getTelephone() return this.telephone;public void setTelephone(String telephone
7、) this.telephone = telephone;private String mail;public String getMail()return this.mail;public void setMain(String mail)this.mail=mail;3. Dao层创建一个新的包，用来存放用户操作的接口4. 在该包下创建接口userDaopackage org.bn.oa.dao;import java.util.ArrayList;import org.bn.oa.beans.User;public interface UserDao /1 success,0 failp
8、ublic int insertUser(User user);/1 success,0 failpublic int updateUser(User user);/1 success,0 failpublic int deleteUser(long userId);public User getSingleUserById(long userID);public ArrayList getUserList();创建DaoImpl包以存放Dao接口的实现类编写实现userDao的实现类UserDaoImplpackage org.bn.oa.daoImpl;import java.util.A
9、rrayList;import org.bn.oa.beans.User;import org.bn.oa.conn.OAConn;import org.bn.oa.dao.UserDao;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class UserDaoImpl implements UserDao private OAConn oacon;public UserDaoImpl() oacon = new OAConn();Overridep
10、ublic int insertUser(User user) / TODO Auto-generated method stubString sql = insert into user(name,sex,identityNum,isvalid,telphone,mail) values(?,?,?,?,?,?);PreparedStatement ps;try ps = oacon.getConnection().prepareStatement(sql);ps.setString(1, user.getName();ps.setString(2, user.getUserSex();ps
11、.setString(3, user.getIdentityNum();ps.setInt(4, user.getIsValid();ps.setString(5, user.getTelephone();ps.setString(6, user.getMail();ps.executeUpdate(); catch (SQLException e) / TODO Auto-generated catch blockreturn 0;oacon.closeConnection();return 1;Overridepublic int deleteUser(long userId) / TOD
12、O Auto-generated method stubString sql = delete from user where id=?;PreparedStatement ps;try ps = oacon.getConnection().prepareStatement(sql);ps.setLong(1, userId);ps.execute(); catch (SQLException e) / TODO Auto-generated catch blockreturn 0;oacon.closeConnection();return 1;Overridepublic User getSingleUserById(long userID) / TODO Auto-generated method stub/ TODO Auto-generated method stubString sql = select * from user where id=?;User user = new User();PreparedStatement ps;try
