超级课程表
1程序设计思想
首先在addInput.jsp 界面中完成网页界面的设计，进行网页测试，看是否完成设计，然后在数据库中建立表，在daoimpi 类文件中进行数据的链接，进行测试，在add.jsp文件中进行判断输入的字符是否合法，建立一个自定义异常类ClassException，在try 中进行输入字符的判断，然后进行抛出异常，最后catch异常，用标签将错误原因显示在网页上
2源程序代码
IUserDao.java
package com.jaovo.msg.dao; import com.jaovo.msg.mobeI.User; public interface IUserDao { public void add(User user);//添加 }
UserdaoImpI.java 数据库的链接
package com.jaovo.msg.dao;//实现方法的类 import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Connection; import com.jaovo.msg.Util.DBUtil; import com.jaovo.msg.Util.UserException; import com.jaovo.msg.mobeI.User; public class UserdaoImpI implements IUserDao {//实现接口中的所有方法 6步 @SuppressWarnings("resource") @Override public void add(User user) {//增加的方法 // TODO Auto-generated method stub Connection connection=DBUtil.getConnection();//获得连接对象 //准备sql语句 String sql = "select count(*) from t_user where username = ?";//count 数据的条数 //创建语句传输对象 PreparedStatement preparedStatement = null; ResultSet resultSet = null;// try { preparedStatement = connection.prepareStatement(sql); preparedStatement.setString(1, user.getKecheng()); resultSet = preparedStatement.executeQuery();//接受一下结果集 //遍历结果集 while(resultSet.next()) { if(resultSet.getInt(1) > 0) { throw new UserException("用户已存在") ; }; } sql = "insert into t_user(username,password,nickname) values (?,?,?)"; preparedStatement = connection.prepareStatement(sql); preparedStatement.setString(1, user.getKecheng()); preparedStatement.setString(2, user.getTeacher()); preparedStatement.setString(3, user.getAdress()); preparedStatement.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { DBUtil.close(resultSet); DBUtil.close(preparedStatement); DBUtil.close(connection); } } }
User。Java
package com.jaovo.msg.mobeI; public class User { private int id; private String kecheng; private String teacher; private String adress; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getKecheng() { return kecheng; } public void setKecheng(String kecheng) { this.kecheng = kecheng; } public String getAdress() { return adress; } public void setAdress(String adress) { this.adress = adress; } public String getTeacher() { return teacher; } public void setTeacher(String teacher) { this.teacher = teacher; } }
ClassException.java
package com.jaovo.msg.Util; public class ClassException extends Exception{ /** * */ private static final long serialVersionUID = 1L; public ClassException() { super(); // TODO Auto-generated constructor stub } public ClassException(String message, Throwable cause, boolean enableSuppression, boolean writableStackTrace) { super(message, cause, enableSuppression, writableStackTrace); // TODO Auto-generated constructor stub } public ClassException(String message, Throwable cause) { super(message, cause); // TODO Auto-generated constructor stub } public ClassException(String message) { super(message); // TODO Auto-generated constructor stub } public ClassException(Throwable cause) { super(cause); // TODO Auto-generated constructor stub } }
DBUtil.java
package com.jaovo.msg.Util;//链接数据库的方法 /* 1加载驱动 2创建连接对象 3创建语句传输对象 4接受结果集对象 5遍历 6关闭资源 */ import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import org.apache.tomcat.dbcp.dbcp2.DriverManagerConnectionFactory; public class DBUtil { public static Connection getConnection() { //1.加载驱动 try { 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?useUnicode=true&characterEncoding=UTF-8";//连接数据库的代码 Connection connection = null;//提升定域 try { //2创建连接对象 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(); } } }
ValidateUtil.java
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; } }
add.jsp
<%@page import="com.jaovo.msg.Util.ClassException"%> <%@page import="com.jaovo.msg.Util.UserException"%> <%@page import="com.jaovo.msg.dao.UserdaoImpI"%> <%@page import="com.jaovo.msg.mobeI.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> <% //接受客户端传递过来的参数 request.setCharacterEncoding("UTF-8"); String kecheng = request.getParameter("kecheng"); String teacher = request.getParameter("teacher"); String adress = request.getParameter("adress"); try{ if(!teacher.trim().equals("王建民")&&!teacher.trim().equals("刘立嘉")&&!teacher.trim().equals("刘丹")&&!teacher.trim().equals("杨子光")&&!teacher.trim().equals("王辉")) { throw new ClassException("不能输入"); } else if (!adress.trim().startsWith("基教")&&!adress.trim().startsWith("一教")&&!adress.trim().startsWith("二教")&&!adress.trim().startsWith("三教")) { throw new ClassException("不能输入"); } else { User user = new User(); user.setKecheng(kecheng); user.setTeacher(teacher); user.setAdress(adress); UserdaoImpI userDao = new UserdaoImpI(); userDao.add(user); %> <body> 用户保存成功!!<br> <a href="addInput.jsp">继续添加</a><br> <a href="#">用户列表</a> <% } } catch(ClassException e){ %> <h2 style="color:red ; font-size:50px">发生错误 : <%=e.getMessage() %></h2> <% } %> </html>
addInput.jsp
<%@ 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>
<form action = "add.jsp" method = "post">
<table align = "center" border="1" width="500" >
<tr>
<td>课程名称：</td>
<td>
<input type ="text" name = "kecheng"/>
</td>
</tr>
<tr>
<td>任课教师：</td>
<td>
<input type = "text" name = "teacher"/>
</td>
<tr>
<td>上课地点：</td>
<td>
<input type = "text" name = "adress" />
</td>
</tr>
<tr align="center">
<td colspan = "2">
<input type = "submit" value = "保存"/>
</td>
</table>
</form>
</body>
</html>
程序执行结果截图
psp日志
|
日期 |
开始时间 |
结束时间 |
中断时间 |
净时间 |
活动 |
备注 |
C |
U |
|
2017.11.28 |
13.00 |
15.00 |
2.30 |
110分钟 |
休息 |
|
|
|
|
|
15.00 |
15.40 |
|
40 |
开班会 |
进行学习十九大 |
|
|
|
|
16.00 |
17.30 |
|
90 |
编程 |
|
|
|
|
|
17.30 |
17.50 |
|
30 |
吃饭 |
|
|
|
|
|
18.00 |
18.40 |
|
|
休息，聊天 |
|
|
|
|
|
18.40 |
21.00 |
20.00 |
110 |
编程 |
准备考试
|
|
|
任务 |
听课 |
编程 |
准备考试 |
总计时间（分钟） |
|
11.21 |
80 |
50 |
30 |
160 |
|
11.22 |
N |
60 |
40 |
100 |
|
11.23 |
N |
30 |
40 |
70 |
|
11.24 |
160 |
50 |
40 |
250 |
|
11.25 |
N |
180 |
40 |
220 |
|
11.26 |
N |
30 |
0 |
30 |
|
11.27 |
N |
60 |
30 |
90 |
|
11.28 |
80 |
90 |
40 |
210 |
|
日期 |
编号 |
类型 |
引入阶段 |
修复阶段 |
缺陷描述 |
类型 |
|
11.28 |
1 |
20 |
编码 |
测试阶段 |
在进行传入的参数判断是否为空的时候，误写入一个死循环，导致程序运行出错 |
编写错误 |
|
|
2 |
20 |
编码 |
测试 |
异常运行出错，在进行抛出异常的时候，自定义的异常编写错误 |
编写出错 |
|
|
|
|
|
|
|
总结：在进行有关项目的编码是，需要注意编程上的规范，在写完每一个部分之后都需要进行测试，防止程序出现不可逆转的错误，加大程序完成的效率，将时间更多的用来学习只是和巩固住已经学习的知识。
