软件工程概论课堂测试一
设计思想：创建一个User类，具有三个String类型变量，用来存放需要的属性值。创建一个UserDaoimpl类，用来写向数据库添加数据的函数，添加数据时只需调用此函数即可。创建一个UserException类，用来抛出异常信息。ValidateUtil用来对输入时未输入的数据进行提示。addInput用来显示首界面，add界面用来接收客户端传递过来的参数，并对参数值进行判断，符合条件调用添加函数将数据添加到数据库，不符合条件报出添加错误信息。
源代码：
User
package com.jaovo.msg.model; public class User { private String coursename; private String teacher; private String address; public String getCoursename() { return coursename; } public void setCoursename(String coursename) { this.coursename = coursename; } public String getTeacher() { return teacher; } public void setTeacher(String teacher) { this.teacher = teacher; } public String getAddress() { return address; } public void setAddress(String address) { this.address = address; } }
IUserDao
package com.jaovo.msg.dao; import com.jaovo.msg.model.User; public interface IUserDao { public void add(User user); }
UserDaoimpl
package com.jaovo.msg.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import com.jaovo.msg.Util.DBUtil; import com.jaovo.msg.Util.UserException; import com.jaovo.msg.model.User; public class UserDaoimpl implements IUserDao{ @Override public void add(User user) { //获得链接对象 Connection connection = DBUtil.getConnection(); //准备sql语句 String sql = "select count(*) from t_user2 where coursename = ?"; //创建语句传输对象 PreparedStatement preparedStatement = null; ResultSet resultSet = null; try { preparedStatement = connection.prepareStatement(sql); preparedStatement.setString(1, user.getCoursename()); //接收结果集 resultSet = preparedStatement.executeQuery(); //遍历结果集 /*while(resultSet.next()) { if (resultSet.getInt(1) > 0) { throw new UserException("用户已存在") ; } }*/ sql = "insert into t_user2(coursename,teacher,address) value (?,?,?)"; preparedStatement = connection.prepareStatement(sql); preparedStatement.setString(1, user.getCoursename()); preparedStatement.setString(2, user.getTeacher()); preparedStatement.setString(3, user.getAddress()); preparedStatement.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { //关闭资源 DBUtil.close(resultSet); DBUtil.close(preparedStatement); DBUtil.close(connection); } } }
DBUtil
package com.jaovo.msg.Util; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class DBUtil { public static Connection getConnection() { try { //1 加载驱动 Class.forName("com.mysql.jdbc.Driver").newInstance(); } catch (InstantiationException | IllegalAccessException | ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } String user = "root"; String password = "root"; String url = "jdbc:mysql://localhost:3306/jaovo_msg"; Connection connection = null; try { //2 创建链接对象connection connection = DriverManager.getConnection(url,user,password); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return connection; } //关闭资源的方法 public static void close(Connection connection ) { try { if (connection != null) { connection.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static void close(PreparedStatement preparedStatement ) { try { if (preparedStatement != null) { preparedStatement.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static void close(ResultSet resultSet ) { try { if (resultSet != null) { resultSet.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }
UserException
package com.jaovo.msg.Util; public class UserException extends RuntimeException{ public UserException() { super(); // TODO Auto-generated constructor stub } public UserException(String message, Throwable cause, boolean enableSuppression, boolean writableStackTrace) { super(message, cause, enableSuppression, writableStackTrace); // TODO Auto-generated constructor stub } public UserException(String message, Throwable cause) { super(message, cause); // TODO Auto-generated constructor stub } public UserException(String message) { super(message); // TODO Auto-generated constructor stub } public UserException(Throwable cause) { super(cause); // TODO Auto-generated constructor stub } }
ValidateUtil
package com.jaovo.msg.Util; import java.util.HashMap; import java.util.Map; import javax.servlet.http.HttpServletRequest; public class ValidateUtil { public static boolean validateNull(HttpServletRequest request,String[] fileds) { boolean validate = true; //map对象用来装载不同的错误信息 Map<String,String> errorMsg = new HashMap(); for(String filed :fileds) { String value = request.getParameter(filed); if (value == null || "".equals(value.trim())) { validate = false; errorMsg.put(filed, filed+"不能为空"); } if (!validate) { request.setAttribute("errormsg", errorMsg); } } return validate; } public static String showError(HttpServletRequest request , String filed) { Map<String, String> errorMsg = (Map<String,String>)request.getAttribute("errormsg"); if (errorMsg == null) { return ""; } String msg = errorMsg.get(filed); if (msg == null) { return ""; } return msg; } }
add.jsp
<%@page import="com.jaovo.msg.Util.ValidateUtil"%> <%@page import="com.jaovo.msg.Util.UserException"%> <%@page import="com.jaovo.msg.dao.UserDaoimpl"%> <%@page import="com.jaovo.msg.model.User"%> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <% //接收客户端传递过来的参数 String coursename= request.getParameter("coursename"); String teacher= request.getParameter("teacher"); String address= request.getParameter("address"); boolean validate = ValidateUtil.validateNull(request, new String[]{"coursename","teacher","address"}); if(!validate){ %> <jsp:forward page="addInput.jsp"></jsp:forward> <% } if(teacher.equals("王建民")||teacher.equals("刘立嘉")||teacher.equals("刘丹")||teacher.equals("王辉")||teacher.equals("杨子光")) { if(address.startsWith("一教")||address.startsWith("二教")||address.startsWith("基教")||address.startsWith("三教")) { User user = new User(); user.setCoursename(coursename); user.setTeacher(teacher); user.setAddress(address); UserDaoimpl userDao = new UserDaoimpl(); try{ userDao.add(user); out.println("添加成功"); }catch(UserException e){ %> <h2 style="color:red ; font-size:50px">发生错误 : <%=e.getMessage() %></h2> <% } } else { out.println("添加失败,没有该教学楼"); } } else { out.println("添加失败,没有该教师"); } %> </html>
addInput.jsp
<%@page import="com.jaovo.msg.Util.ValidateUtil"%> <%@page import="java.util.Map"%> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>增加课程信息页面</title> </head> <body> <%-- <%Map<String,String> errorMsg = (Map<String,String>)request.getAttribute("errormsg"); --%> <%-- %> --%> <form action="add.jsp" method="get"> <table align="center" > <tr> <td>课程名称 : </td> <td> <input type="text" name="coursename" /> <%=ValidateUtil.showError(request, "coursename")%> </td> </tr> <tr> <td>任课教师:</td> <td> <input type="text" name="teacher" /> <%=ValidateUtil.showError(request, "teacher")%> </td> </tr> <tr> <td>上课地点:</td> <td> <input type="text" name="address" /> <%=ValidateUtil.showError(request, "address")%> </td> </tr> <tr align="center"> <td > <input type="submit" value="保存" /> </td> </tr> </table> </form> </body> </html>
运行成果截图：
缺陷记录日志
学生：孟庆淋
日期：2017.11.28
教员：王建民
程序号：1
| 日期 | 编号 | 类型 | 引入阶段 | 排除阶段 | 修复时间 | 修复缺陷 |
| 2017.11.28 | 1 | 20 | 编码 | 编译 | 1min | 书写问题 |
| 描述：在进行判断时候将teacher变量写成了coursename变量 | ||||||
时间记录日志
学生：孟庆淋 教师：王建民
日期：2017.11.28
| 日期 | 开始时间 | 结束时间 | 中断时间 | 净时间 | 活动 | 备注 |
| 11.28 |
8：00 |
8：50 | 50 | 听课 | 软件工程概论 | |
| 9：00 | 9：45 | 45 | 编写程序 | 课堂测试一 | ||
| 17：00 | 17：35 | 5 | 30 | 编写博客园 |
项目计划总结
学生：孟庆淋
日期：2017.11.28
教员：王建民
程序号：1
| PSP2.1 | Personal Software Process Stages | Time(%)（/minute） |
| Planning | 计划 | 2 |
| Estimate | 估计这个任务需呀多少时间 | 50 |
| Analysis | 需求分析 | 2 |
| Coding Standrd | 代码规范 | 4 |
| Design | 具体设计 | 5 |
| Coding | 具体编码 | 40 |
| Test | 测试 | 1 |
| Resporting | 报告 | 50 |
