高级网站设计试验报告2.docx

1、高级网站设计试验报告2武汉纺织大学高级网站设计实验报告班级： 管工1202 姓名： 梁星团 实验时间：2014年6月17日 指导教师：陈冈一、实验目的 1.了解数据库连接池。2.掌握Spring应用。3.掌握Hibernate应用。二、实验内容1 创建一个基于Spring MVC的Web应用项目。2 实现项目的国际化处理。3 实现用户的登录、注册处理。4 编写一个小型留言板系统，利用Hibernate实现留言板处理。三、操作步骤User.javapackage counts;public class User private int id; private String username; p

2、rivate String password; public User() public User(int id, String username, String password) super(); this.id = id; this.username = username; this.password = password; public int getId() return id; public void setId(int id) this.id = id; public String getUsername() return username; public void setUse

3、rname(String username) this.username = username; public String getPassword() return password; public void setPassword(String password) this.password = password; UserDao.javapackage counts;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.Resul

4、tSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List; import javax.sql.DataSource;import org.springframework.jdbc.core.JdbcTemplate;import org.springframework.jdbc.core.PreparedStatementCreator; public class UserDao private DataSource dataSource; public void setDataSour

5、ce(DataSource dataSource) this.dataSource = dataSource; public void insert(final User user) JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource); jdbcTemplate.update(new PreparedStatementCreator() Override public PreparedStatement createPreparedStatement(Connection conn) throws SQLException Stri

6、ng sql = insert into user(username,password) values(?,?); PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, user.getUsername(); ps.setString(2, user.getPassword(); return ps; ); public List getUsers(String username, String password) throws ClassNotFoundException List list = new Arra

7、yList(); try Class.forName(com.mysql.jdbc.Driver); String sql = select * from user where username=? and password=?; Connection conn = DriverManager.getConnection( jdbc:mysql:/localhost/db_wen, root, 520); PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, username); ps.setString(2, p

8、assword); ResultSet rs = ps.executeQuery(); if (rs.next() User user = new User(rs.getInt(1), rs.getString(2), rs.getString(3); list.add(user); ps.close(); conn.close(); catch (SQLException e) e.printStackTrace(); return list; 控制层代码：Login.javapackage controllers;import java.io.IOException;import java

9、.util.List;import javax.servlet.RequestDispatcher;import javax.servlet.ServletException;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import counts.User;import counts.UserDao

10、;WebServlet(/login.do)public class Login extends HttpServlet private static final long serialVersionUID = 1L; public Login() protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException doPost(request, response); protected void doPost(HttpServle

11、tRequest request, HttpServletResponse response) throws ServletException, IOException String username = request.getParameter(username); String password = request.getParameter(password); UserDao userDao = new UserDao(); List users = null; try users = userDao.getUsers(username, password); RequestDispat

12、cher rd; if (users.size() 0) rd = request.getRequestDispatcher(WEB-INF/admin.jsp); else rd = request.getRequestDispatcher(login.jsp); request.setAttribute(users, users); rd.forward(request, response); catch (Exception e) e.printStackTrace(); Register.javapackage controllers;import java.io.IOExceptio

13、n;import javax.servlet.ServletException;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.springframework.context.ApplicationContext;import org.springframework.context

14、.support.ClassPathXmlApplicationContext;import counts.User;import counts.UserDao;WebServlet(/register.do)public class Register extends HttpServlet private static final long serialVersionUID = 1L; public Register() protected void doGet(HttpServletRequest request, HttpServletResponse response) throws

15、ServletException, IOException doPost(request,response); protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException request.setCharacterEncoding(utf-8); ApplicationContext context = new ClassPathXmlApplicationContext( beans.xml); UserDao regis

16、ter = (UserDao) context.getBean(userDao); User user = new User(); user.setUsername(request.getParameter(username); System.out.print(user.getUsername(); user.setPassword(request.getParameter(password); register.insert(user); response.setContentType(text/html;charset=utf-8); response.getWriter().print

17、ln(恭喜你，注册成功！); 视图层代码：Login.jsp%taglib prefix=c uri=Insert title here.login_table border: medium groove #009999;             用户名     密 码         登录失败！ Register.jsp%taglib prefix=c uri=Insert title here.login_table border: medium groove #009999;             用户名     密 码         注册失败！ Admin.jspInsert title here.login_table border: medium groove #006699;.STYLE1 color: #FF0000; font-weight: bold;登录成功！配置文件beanBeans.xml /be