JavaEE期末考查报告_昆明理工大学.doc

考查课程报告

课程名称： Java EE技术

学院：信息工程与自动化学院

专业年级： 2010级计算机系101班

学号：

学生姓名：

指导教师：

日期： 2012-12-30

期末考查结果评定

目录

1.课程目的 (4)

2.要求与内容 (4)

3．运行环境 (4)

4.设计及实现 (4)

4.1项目部署结构： (4)

4.2业务抽象类： (5)

4.3业务实现类： (6)

4.4 Dao抽象类： (11)

4.5 Dao实现类： (12)

4.6 工厂类： (23)

4.7数据表结构 (25)

4.8值类设计 (26)

5.程序运行截图 (29)

6．总结和体会 (33)

7.参考文献 (33)

1.课程目的

学生通过学习该课程后，着重应掌握跨平台WEB编程技术的知识和技能，主要掌握jsp、Servlet、JavaBean、JDBC、数据库连接池、MyEclipse环境、EL、JSTL 核心标签库、TOMCAT 容器、MVC架构等基本知识和基本技能，在知识、能力和素质等方面达到能够独立的从事WEB 服务器架构和服务器端软件开发的目标，本课程在人才培养过程中占有重要的不可替代的地位及作用，它把各专业基础知识综合在一起，形成一个培养提高学生专业能力的好课程，为同学走向社会、就业等奠定了坚实的自信心和牢固专业知识，极大地提高同学在社会就业竞争中的竞争力。

2.要求与内容

按照MVC设计模式，以5层的分层结构设计实现……管理。数据表需自行设计建立，数据库连接采用连接池的方式；view层主要以JSP页面方式实现，在页面中采用EL、JSTL标签库，并采用页面组装的方式合成top、left、bottom区域的内容；Control层用Servlet实现；Model 层用分层方式实现，分为VALUE类、DAO的接口、接口实现类和工厂、Business的接口、接口实现类和工厂，数据库连接工厂。

3．运行环境

Windows 7系统PC机一台，My Eclipse 10 IDE，SQL Server 2008数据库。

4.设计及实现

4.1项目部署结构：

4.2业务抽象类：

package com.city.oa.business;

import java.util.List;

import com.city.oa.value.*;

public interface IEmployee {

//增加员工

public void add(String userid,String name,String password, int age)throws Exception;

//修改员工

public void modify(String userid,String name,String password, int age)throws Exception;

//删除员工

public void delete(String userid)throws Exception;

//取得所有员工列表

public List getlist()throws Exception;

//取得一个员工

public EmployeeValue getEmployee(String userid)throws Exception;

//验证密码

public boolean check(String userid,String password) throws Exception;

//修改密码

public void changePassword(String userid,String password) throws Exception;

}

package com.city.oa.business;

import java.util.List;

import com.city.oa.value.*;

public interface INews {

public void add(String newsid,String newstitle,String newscontent,String newsdate) throws Exception;

public void modify(String newsid,String newstitle,String newscontent,String newsdate) throws Exception;

public void delete(String newsid) throws Exception;

public List getList() throws Exception;

public NewsValue getNews(String newsid)throws Exception;

}

4.3业务实现类：

package com.city.oa.business.impl;

import java.util.List;

import com.city.oa.business.IEmployee;

import com.city.oa.value.EmployeeValue;

import com.city.oa.dao.*;

import com.city.oa.factory.*;

public class EmployeeImpl implements IEmployee {

public void add(String userid, String name, String password, int age)

throws Exception {

// TODO Auto-generated method stub

EmployeeValue ev=new EmployeeValue();

ev.setUserid(userid);

ev.setName(name);

ev.setPassword(password);

ev.setAge(age);

IEmployeeDao edo=DaoFactory.getEmployeeDao();

edo.create(ev);

}

public void modify(String userid, String name, String password, int age) throws Exception {

// TODO Auto-generated method stub

EmployeeValue ev=new EmployeeValue();

ev.setUserid(userid);

ev.setName(name);

ev.setPassword(password);

ev.setAge(age);

IEmployeeDao edo=DaoFactory.getEmployeeDao();

edo.update(ev);

}

public void delete(String userid)

throws Exception {

// TODO Auto-generated method stub

EmployeeValue ev=new EmployeeValue();

ev.setUserid(userid);

IEmployeeDao edo=DaoFactory.getEmployeeDao();

edo.delete(ev);

}

public List getlist() throws Exception {

// TODO Auto-generated method stub

IEmployeeDao edo=DaoFactory.getEmployeeDao();

return edo.getList();

}

public EmployeeValue getEmployee(String userid) throws Exception { // TODO Auto-generated method stub

IEmployeeDao edo=DaoFactory.getEmployeeDao();

return edo.get(userid);

}

public boolean check(String userid, String password) throws Exception { // TODO Auto-generated method stub

boolean check1=false;

IEmployeeDao edo=DaoFactory.getEmployeeDao();

EmployeeValue ev=edo.get(userid);

if (ev!=null){

if(ev.getPassword().equals(password)){

check1=true;

}

}

return check1;

}

public void changePassword(String userid, String password) throws Exception { // TODO Auto-generated method stub

IEmployeeDao edo=DaoFactory.getEmployeeDao();

EmployeeValue ev=edo.get(userid);

if(ev!=null){

ev.setPassword(password);

edo.update(ev);

}

}

public void delete(String userid, String name, String password, int age) throws Exception {

// TODO Auto-generated method stub

}

}

package com.city.oa.business.impl;

import java.util.List;

import com.city.oa.business.*;

import com.city.oa.dao.*;

import com.city.oa.value.*;

import com.city.oa.factory.*;

public class NewsImpl implements INews{

public void add(String newsid, String newstitle, String newscontent, String newsdate) throws Exception {

// TODO Auto-generated method stub

NewsValue nv=new NewsValue();

nv.setNewsid(newsid);

nv.setNewstitle(newstitle);

nv.setNewscontent(newscontent);

nv.setNewsdate(newsdate);

INewsDao ndo=DaoFactory.getNewsDao();

ndo.create(nv);

}

public void modify(String newsid, String newstitle, String newscontent, String newsdate) throws Exception {

// TODO Auto-generated method stub

NewsValue nv=new NewsValue();

nv.setNewsid(newsid);

nv.setNewstitle(newstitle);

nv.setNewscontent(newscontent);

nv.setNewsdate(newsdate);

INewsDao ndo=DaoFactory.getNewsDao();

ndo.update(nv);

}

public void delete(String newsid) throws Exception { // TODO Auto-generated method stub

NewsValue nv=new NewsValue();

nv.setNewsid(newsid);

INewsDao ndo=DaoFactory.getNewsDao();

ndo.delete(nv);

}

public List getList() throws Exception { // TODO Auto-generated method stub

INewsDao ndo=DaoFactory.getNewsDao();

return ndo.getList();

}

public NewsValue getNews(String newsid) throws Exception { // TODO Auto-generated method stub

INewsDao ndo=DaoFactory.getNewsDao();

return ndo.get(newsid);

}

}

4.4 DAO抽象类：

package com.city.oa.dao;

import java.util.List;

import com.city.oa.value.*;

public interface IEmployeeDao {

public void create(EmployeeValue ev) throws Exception;

public void update(EmployeeValue ev) throws Exception;

public void delete(EmployeeValue ev) throws Exception;

public List getList() throws Exception;

public EmployeeValue get(String userid) throws Exception; }

package com.city.oa.dao;

import java.util.List;

import com.city.oa.value.*;

public interface INewsDao {

public void create(NewsValue nv) throws Exception;

public void update(NewsValue nv) throws Exception;

public void delete(NewsValue nv) throws Exception;

public List getList() throws Exception;

public NewsValue get(String id) throws Exception;

}

4.5 DAO实现类：

package com.city.oa.dao.impl;

import java.util.ArrayList;

import java.util.List;

import java.sql.*;

import com.city.oa.dao.IEmployeeDao;

import com.city.oa.value.EmployeeValue;

import com.city.oa.factory.*;

public class EmployeeDaoImpl implements IEmployeeDao {

public void create(EmployeeValue ev) throws Exception {

String sql="insert into emp(empid,password,name,age) values(?,?,?,?)";

Connection cn=null;

try{

cn=ConnectionFactory.getConnection();

PreparedStatement ps=cn.prepareStatement(sql);

ps.setString(1,ev.getUserid());

ps.setString(3,ev.getName());

ps.setString(2,ev.getPassword());

ps.setInt(4,ev.getAge());

ps.executeUpdate();

ps.close();

}catch(Exception e){

throw new Exception("员工DAO增加错误："+e.getMessage());

}finally{

cn.close();

}

}

public void update(EmployeeValue ev) throws Exception {

String sql="update emp set name=?,password=?,age=? where empid=?)";

Connection cn=null;

try{

cn=ConnectionFactory.getConnection();

PreparedStatement ps=cn.prepareStatement(sql);

ps.setString(4,ev.getUserid());

ps.setString(1,ev.getName());

ps.setString(2,ev.getPassword());

ps.setInt(3,ev.getAge());

ps.executeUpdate();

ps.close();

}catch(Exception e){

throw new Exception("员工DAO更新错误："+e.getMessage());

}finally{

cn.close();

}

}

public void delete(EmployeeValue ev) throws Exception {

String sql="delete from emp where empid=?";

Connection cn=null;

try{

cn=ConnectionFactory.getConnection();

PreparedStatement ps=cn.prepareStatement(sql);

ps.setString(1,ev.getUserid());

ps.executeUpdate();

ps.close();

}catch(Exception e){

throw new Exception("员工DAO删除错误："+e.getMessage());

}finally{

cn.close();

}

}

public List getList() throws Exception

{

List empList=new ArrayList();

String sql="select * from emp";

Connection cn=null;

try{

cn=ConnectionFactory.getConnection();

ResultSet rs=ps.executeQuery();

while (rs.next()){

EmployeeValue ev=new EmployeeValue();

ev.setUserid(rs.getString("empid"));

ev.setName(rs.getString("name"));

ev.setPassword(rs.getString("password"));

ev.setAge(rs.getInt("age"));

empList.add(ev);

}

rs.close();

ps.close();

}catch(Exception e){

throw new Exception("员工DAO取得列表错误："+e.getMessage());

}finally{

cn.close();

}

return empList;

}

public EmployeeValue get(String userid) throws Exception {

EmployeeValue ev=null;

String sql="select * from emp where empid=?";

Connection cn=null;

try{

cn=ConnectionFactory.getConnection();

ps.setString(1,userid);

ResultSet rs=ps.executeQuery();

if (rs.next()){

ev=new EmployeeValue();

ev.setUserid(rs.getString("empid"));

ev.setName(rs.getString("name"));

ev.setPassword(rs.getString("password"));

ev.setAge(rs.getInt("age"));

}

rs.close();

ps.close();

}catch(Exception e){

throw new Exception("员工DAO取得指定值错误："+e.getMessage());

}finally{

cn.close();

}

return ev;

}

}

package com.city.oa.dao.impl;

import java.util.*;

import java.sql.*;

import com.city.oa.dao.INewsDao;

import com.city.oa.value.*;

import com.city.oa.factory.*;

public class NewsDaoImpl implements INewsDao {

public void create(NewsValue nv) throws Exception {

// TODO Auto-generated method stub 1

String sql="insert into NEWS (newsid,newstitle,newscontent,newsdate) values(?,?,?,?)";

Connection cn=null;

try

{

cn=ConnectionFactory.getConnection();

PreparedStatement ps=cn.prepareStatement(sql);

ps.setString(1, nv.getNewsid());

ps.setString(2, nv.getNewstitle());

ps.setString(3, nv.getNewscontent());

ps.setString(4,nv.getNewsdate());

ps.executeUpdate();

ps.close();

}catch(Exception e)

{

throw new Exception("新闻增加错误："+e.getMessage());

}

finally

{

cn.close();

}

}

public void update(NewsValue nv) throws Exception {

// TODO Auto-generated method stub 2

String sql="update NEWS set newstitle=?,newscontent=?,newsdate=? where newsid=?";

Connection cn=null;

try

{

cn=ConnectionFactory.getConnection();

PreparedStatement ps=cn.prepareStatement(sql);

ps.setString(1, nv.getNewstitle());

ps.setString(2, nv.getNewscontent());

ps.setString(3,nv.getNewsdate());

ps.executeUpdate();

ps.close();

}

catch(Exception e)

{

System.out.println("新闻更新错误："+e.getMessage());

}

finally

{

cn.close();

}

}

public void delete(NewsValue nv) throws Exception { // TODO Auto-generated method stub 3

String sql="delete from NEWS where newsid=?";

Connection cn=null;

try

{

cn=ConnectionFactory.getConnection();

PreparedStatement ps=cn.prepareStatement(sql);

ps.setString(1, nv.getNewsid());

ps.executeUpdate();

ps.close();

}

catch(Exception e)

{

System.out.println("新闻删除错误："+e.getMessage());

}

finally

{

cn.close();

}

}

public List getList() throws Exception { // TODO Auto-generated method stub 4

List newsList=new ArrayList();

String sql="select * from NEWS";

Connection cn=null;