开发人员手册.docx

开发人员手册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的驱动，可以从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.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) / TODO 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() return ;public void setUserName(String username) = 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 setIdentityNum(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) 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 failpublic 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.ArrayList;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();Overridepublic 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.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) / TODO 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 ps = oacon.getConnection().prepareStatement(sql);ps.setLong(1, userID);ResultSet rs = ps.executeQuery();while (rs.next()user.setUserId(rs.getLong(1);user.setUserName(rs.getString(2);user.setUserSex(rs.getString(3);user.setIdentityNum(rs.getString(4);user.setIsValid(rs.getInt(5);user.setTelephone(rs.getString(6);user.setMail(rs.getString(7);rs.close(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();oacon.closeConnection();return user;Overridepublic ArrayList getUserList() / TODO Auto-generated method stubArrayList users = new ArrayList();String sql = select * from user;PreparedStatement ps;try ps = oacon.getConnection().prepareStatement(sql);ResultSet rs = ps.executeQuery();while (rs.next() User user = new User();user.setUserName(rs.getString(name);user.setUserSex(rs.getString(sex);user.setUserId(rs.getLong(id);user.setTelephone(rs.getString(telphone);user.setMail(rs.getString(mail);user.setIdentityNum(rs.getString(identityNum);user.setIsValid(rs.getInt(isvalid);users.add(user); catch (SQLException e) / TODO Auto-generated catch blockreturn null;oacon.closeConnection();return users;Overridepublic int updateUser(User user) / TODO Auto-generated method stubString sql = update user set name=?,sex=?,identityNum=?,isvalid=?,telphone=?,mail=? where id=?;PreparedStatement ps;try ps = oacon.getConnection().prepareStatement(sql);ps.setString(1, user.getName();ps.setString(2, user.getUserSex();ps.setStri