武汉纺织大学高级网站设计试验报告2.doc

武汉纺织大学高级网站设计实验报告班级： 姓名： 实验时间：2014年5月7日 指导教师：陈冈一、实验目的1.了解数据库连接池。2. 掌握Spring应用。3. 掌握Hibernate应用。二、实验内容1 创建一个基于Spring MVC的Web应用项目。2 实现项目的国际化处理。3 实现用户的登录、注册处理。4 编写一个小型留言板系统，利用Hibernate实现留言板处理。三、操作步骤1..wtu.cg.dao: Teacher类：package .wtu.cg.domain;public class Teacher private String jobTitle;private String eno;private String ename;private String password;public String getEno() return eno;public void setEno(String eno) this.eno = eno;public String getEname() return ename;public void setEname(String ename) this.ename = ename;public String getJobTitle() return jobTitle;public void setJobTitle(String jobTitle) this.jobTitle = jobTitle;public String getPassword() return password;public void setPassword(String password) this.password = password; Student类： package .wtu.cg.domain;public class Student private String eno;private String email;private String ename;private String password;private String address;public String getEname() return ename;public void setEname(String ename) this.ename = ename;public String getEno() return eno;public void setEno(String eno) this.eno = eno;public String getEmail() return email;public void setEmail(String email) this.email = email;public String getPassword() return password;public void setPassword(String password) this.password = password;public String getAddress() return address;public void setAddress(String address) this.address = address;Loginer类： package .wtu.cg.domain;public class Loginer private String eno;private String password;private String Category;public String getEno() return eno;public void setEno(String eno) this.eno = eno;public String getPassword() return password;public void setPassword(String password) this.password = password;public String getCategory() return Category;public void setCategory(String category) Category = category;BaseEnity类： package .wtu.cg.domain;public class BaseEntity private Integer id;private String eno;private String ename;private String password;public Integer getId() return id;public void setId(Integer id) this.id = id;public String getEno() return eno;public void setEno(String eno) this.eno = eno;public String getEname() return ename;public void setEname(String ename) this.ename = ename;public String getPassword() return password;public void setPassword(String password) this.password = password;.wtu.cg.dao: 接口IUserDao:package .wtu.cg.dao;import java.util.Collection;import org.springframework.dao.DataAccessException;import .wtu.cg.domain.Teacher;public interface IUserDao public T findEntityByProperties(String eno, String password, String category)throws DataAccessException;public T findEntityByEno(String eno, String category)throws DataAccessException;public void saveEntity(T entity) throws DataAccessException;public void deleteEntity(String eno) throws DataAccessException;public Collection findEntityByDepartCode(String departCode)throws DataAccessException;Ueserdao类：package .wtu.cg.dao;import java.util.Collection;import java.util.List;import javax.sql.DataSource;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.dao.DataAccessException;import org.springframework.jdbc.core.BeanPropertyRowMapper;import org.springframework.jdbc.core.JdbcTemplate;import dparam.BeanPropertySqlParameterSource;import org.springframework.jdbc.core.simple.SimpleJdbcInsert;import org.springframework.stereotype.Repository;import .wtu.cg.domain.BaseEntity;import .wtu.cg.domain.Student;import .wtu.cg.domain.Teacher;Repositorypublic class UserDao implements IUserDao private JdbcTemplate jdbcTemplate;private SimpleJdbcInsert insertEntity;Autowiredpublic void init(DataSource dataSource) jdbcTemplate = new JdbcTemplate(dataSource);insertEntity = new SimpleJdbcInsert(dataSource).usingGeneratedKeyColumns(id);SuppressWarnings(unchecked)Overridepublic T findEntityByProperties(String eno, String password, String category)throws DataAccessException try Class instance = null;String sql = null;if (category.equals(1) instance = Teacher.class;sql = select * from teacher where eno=? and password=?; else if (category.equals(2) instance = Student.class;sql = select * from student where eno=? and password=?;return (T) jdbcTemplate.queryForObject(sql, new Object eno,password , BeanPropertyRowMapper.newInstance(instance); catch (Exception e) return null;SuppressWarnings(unchecked)Overridepublic T findEntityByEno(String eno, String category)throws DataAccessException String sql;Class cls;if (category.equals(1) sql = select * from teacher where eno=?;cls = Teacher.class; else sql = select * from student where eno=?;cls = Student.class;List list = jdbcTemplate.query(sql,BeanPropertyRowMapper.newInstance(cls), eno);if (list.size() = 0)return null;return (T) list.get(0);Overridepublic void saveEntity(T register) throws DataAccessException String tableName = null;String sql = null;String eno;BaseEntity entity;if (register instanceof Student) eno = (Student) register).getEno();entity = (BaseEntity) findEntityByEno(eno, 2);tableName = student;sql = update student set password=?,ename=?,email=?,address=? where eno=?; else eno = (Teacher) register).getEno();entity = (BaseEntity) findEntityByEno(eno, 1);tableName = teacher;sql = update teacher set password=?,ename=?,jobtitle=? where eno=?;if (entity = null) if (insertEntity.getTableName() = null)insertEntity.setTableName(tableName);insertEntity.execute(new BeanPropertySqlParameterSource(register); else if (tableName.equals(teacher) Teacher teacher = (Teacher) register;jdbcTemplate.update(sql, teacher.getPassword(),teacher.getEname(), teacher.getJobTitle(),teacher.getEno(); else Student student = (Student) register;jdbcTemplate.update(sql, student.getPassword(),student.getEname(), student.getEmail(),student.getAddress(), student.getEno();Overridepublic void deleteEntity(String eno) throws DataAccessException / TODO Auto-generated method stubOverridepublic Collection findEntityByDepartCode(String departCode)throws DataAccessException / TODO Auto-generated method stubreturn null;.wtu.cg.service:userservice类：package .wtu.cg.service;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import .wtu.cg.dao.IUserDao;import .wtu.cg.domain.Loginer;Servicepublic class UserService implements IUserService private IUserDao userDao;Autowiredpublic void setUserDao(IUserDao userDao) this.userDao = userDao;Overridepublic T findUser(Loginer loginer) return userDao.findEntityByProperties(loginer.getEno(),loginer.getPassword(), loginer.getCategory();Overridepublic void saveUser(T instance) userDao.saveEntity(instance);实现Userservice的接口IUsersseivice类:package .wtu.cg.service;import .wtu.cg.domain.Loginer;public interface IUserService public T findUser(Loginer loginer);public void saveUser(T instance);.wtu.cg.web:homecontroll类：package .wtu.web;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RequestMethod;Controllerpublic class HomeController RequestMapping(value = /, method = RequestMethod.GET)public String homeHandler() return home;studentEditForm类：package .wtu.web;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.ui.Model;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RequestMethod;import org.springframework.web.bind.annotation.SessionAttributes;import .wtu.cg.domain.Student;import .wtu.cg.service.IUserService;ControllerSessionAttributes(regstudent)public class StudentEditForm private IUserService uszerSerice;Autowiredpublic void setUserService(IUserService userSerice) this.uszerSerice = userSerice;RequestMapping(value = /student.html, method = RequestMethod.GET)public String teacherHandler() return /student;RequestMapping(value = /students/register.html, method = RequestMethod.POST)public String processSubmit(Student student, Model model) uszerSerice.saveUser(student);model.addAttribute(regstudent, student);return redirect:/students/register.html;RequestMapping(value = /students/sucess.html, method = RequestMethod.GET)public String gotoSucess() return /students/sucess;TeacherEditForm类:package .wtu.web;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RequestMethod;Controllerpublic class TeacherEditForm RequestMapping(value = /teacher.html, method = RequestMethod.GET)public String teacherHandler() return /teacher;Userloginform类：package .wtu.web;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.ui.Model;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RequestMethod;import org.springframework.web.bind.annotation.SessionAttributes;import .wtu.cg.domain.Loginer;import .wtu.cg.domain.Student;import .wtu.cg.domain.Teacher;import .wtu.cg.service.IUserService;ControllerSessionAttributes(loginuser)public class UserLoginForm private IUserService userSerice;Autowiredpublic void setUserSerice(IUserService userSerice) this.userSerice = userSerice;RequestMapping(value = /login.html, method = RequestMethod.GET)public String setupForm() return /login;RequestMapping(value = /login.html, method = RequestMethod.POST)public String processSubmit(Loginer loginer, Model model) String url = redirect:/login.html;Object o = userS