JAVA三级机试综合体要点.docx

JAVA三级机试综合题1. 建数据库和表要点：素材，ID自增，ER图综合能力的数据库新建表共8个字段，7个目标字段和1个主键id int(10)fistname varchar(20)lastname varchar(30)jobtitle varchar(30)department varchar(40)phone varchar(20)mobile varchar(20)email varchar(50)PRIMARY KEY (id)2. 新建Web Project要点： Project Name要符合命名规范，选Java EE 5.03. 构筑Struts框架要点：选Struts 1.3，Package Name改为com.struts4. 配置Hibernate4.1. 数据池要点：依赖素材db文件夹下的”连接字符串.txt” 4.2. 构筑Hibernate框架要点：Java Package : New- com.dao ，JAVA 5.04.3. 建立addresstable表和Hibernate框架的映射要点：选工程，三个勾，identity4.4. 拷贝素材把pages文件夹下的images文件夹和style文件夹复制到工程中的WebRoot文件夹下5. 程序框架5.1. 建包com.web5.2. 建类3个5.2.1. ContactForm类package com.web;import org.apache.struts.action.ActionForm;public class ContactForm extends ActionForm private String firstName;private String lastName;private String jobTitle;private String department;private String phone;private String mobile;private String email;public String getFirstName() return firstName;public void setFirstName(String firstName) this.firstName = firstName;public String getLastName() return lastName;public void setLastName(String lastName) this.lastName = lastName;public String getJobTitle() return jobTitle;public void setJobTitle(String jobTitle) this.jobTitle = jobTitle;public String getDepartment() return department;public void setDepartment(String department) this.department = department;public String getPhone() return phone;public void setPhone(String phone) this.phone = phone;public String getMobile() return mobile;public void setMobile(String mobile) this.mobile = mobile;public String getEmail() return email;public void setEmail(String email) this.email = email;5.2.2. AddContactAction类package com.web;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.apache.struts.action.Action;import org.apache.struts.action.ActionForm;import org.apache.struts.action.ActionForward;import org.apache.struts.action.ActionMapping;import com.dao.Addresstable0;import com.dao.Addresstable0DAO;public class AddContactAction extends Action Overridepublic ActionForward execute(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response)throws Exception / call business classContactForm contactForm = (ContactForm) form;Addresstable0 addresstable = new Addresstable0(contactForm.getFirstName(), contactForm.getLastName(), contactForm.getJobTitle(), contactForm.getDepartment(), contactForm.getPhone(), contactForm.getMobile(), contactForm.getEmail();Addresstable0DAO adao = new Addresstable0DAO();adao.save(addresstable);return mapping.findForward(success);5.2.3. ListContactAction类package com.web;import java.util.List;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.apache.struts.action.Action;import org.apache.struts.action.ActionForm;import org.apache.struts.action.ActionForward;import org.apache.struts.action.ActionMapping;import com.dao.Addresstable0DAO;public class ListContactAction extends Action Overridepublic ActionForward execute(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response)throws Exception / TODO Auto-generated method stubAddresstable0DAO adao = new Addresstable0DAO();List list = adao.findAll();request.getSession().setAttribute(list, list);return mapping.findForward(success);5.3. 建jsp5.3.1. addContact.jsp  ADD NEW CONTACT DETAILSFIRST NAME：LAST NAME：JOB TITLE：DEPARTMENT：PHONE：MOBILE：E-MAIL：   2010 XXX Information Te