网页版增加信息---添加

实验要求：

要求判断任课教师为王建民、刘立嘉、刘丹、封筠、韩培花五位教师的其中一位。

要求上课地点开头为“一教”、“二教”、“三教”、“基教”中的一种

实现数据存储功能。

程序设计思想：

先创建类模型，user

再通过DBUtil和数据库连接

然后在UserDaoImple中实现添加功能

再addInput.jsp文件中实现页面的构建

在add.jsp文件中实现网页添加和判断的功能。

源代码：

 package com.jaovo.msg.model;
 2 
 3 public class User {
 4    private int id;
 5    private String lesson;
 6    private String teacher;
 7    private String status;
 8 public User(int int1, String string, String string2, String string3) {
 9     // TODO Auto-generated constructor stub
10 }
11 public User() {
12     // TODO Auto-generated constructor stub
13 }
14 public int getId() {
15     return id;
16 }
17 public void setId(int id) {
18     this.id = id;
19 }
20 public String getLesson() {
21     return lesson;
22 }
23 public void setLesson(String lesson) {
24     this.lesson = lesson;
25 }
26 public String getTeacher() {
27     return teacher;
28 }
29 public void setTeacher(String teacher) {
30     this.teacher = teacher;
31 }
32 public String getStatus() {
33     return status;
34 }
35 public void setStatus(String status) {
36     this.status =status;
37 }
38    
39 }

1 package com.jaovo.msg.dao;
2 import com.jaovo.msg.model.User;
3 import java.util.List;
4 public interface IUserDao {
5     public void add(User user);//添加用户
6 }

 1 package com.jaovo.msg.dao;
 2 
 3 import java.sql.Connection;
 4 import java.sql.PreparedStatement;
 5 import java.sql.ResultSet;
 6 import java.sql.SQLException;
 7 import java.util.ArrayList;
 8 import java.util.List;
 9 
10 
11 import com.jaovo.msg.Util.DBUtil;
12 import com.jaovo.msg.Util.UserException;
13 import com.jaovo.msg.model.User;
14 
15 import sun.net.www.content.text.plain;
16 
17 public class UserDaoImpl implements IUserDao {
18 
19     @Override
20     public void add(User user) {
21         //获得链接对象
22         Connection connection = DBUtil.getConnection();
23         //准备sql语句
24         String sql = "select count(*) from t_user where lesson = ?";
25         //创建语句传输对象
26         PreparedStatement preparedStatement = null;
27         ResultSet resultSet = null;
28         try {
29             preparedStatement = connection.prepareStatement(sql);
30             preparedStatement.setString(1, user.getLesson());
31             //接收结果集
32             resultSet = preparedStatement.executeQuery();
33             //遍历结果集
34             while(resultSet.next()) {
35                 if (resultSet.getInt(1) > 0) {
36                     throw new UserException("用户已存在") ;
37                 }
38             }
39             
40             sql = "insert into t_user(lesson,teacher,status) value (?,?,?)";
41             preparedStatement = connection.prepareStatement(sql);
42             preparedStatement.setString(1, user.getLesson());
43             preparedStatement.setString(2, user.getTeacher());
44             preparedStatement.setString(3, user.getStatus());
45             preparedStatement.executeUpdate();
46         } catch (SQLException e) {
47             // TODO Auto-generated catch block
48             e.printStackTrace();
49         }finally {
50             //关闭资源
51             DBUtil.close(resultSet);
52             DBUtil.close(preparedStatement);
53             DBUtil.close(connection);
54         }
55         
56     }
57 }

 1 package com.jaovo.msg.filter;
 2 import java.io.IOException;
 3 
 4 import javax.servlet.Filter;
 5 import javax.servlet.FilterChain;
 6 import javax.servlet.FilterConfig;
 7 import javax.servlet.ServletException;
 8 import javax.servlet.ServletRequest;
 9 import javax.servlet.ServletResponse;
10 public class CharFilter implements Filter{
11    String encoding=null;
12 @Override
13 public void destroy() {
14     // TODO Auto-generated method stub
15     
16 }
17 
18 @Override
19 public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException {
20     // TODO Auto-generated method stub
21     request.setCharacterEncoding("utf-8");    
22     request.setCharacterEncoding("encoding");
23     chain.doFilter(request, response);
24 }
25 
26 @Override
27 public void init(FilterConfig filterConfig) throws ServletException {
28     // TODO Auto-generated method stub
29     encoding = filterConfig.getInitParameter("encoding");
30 }
31    
32 }

1 package com.jaovo.msg.Util;
2 
3 import com.jaovo.msg.dao.UserDaoImpl;
4 
5 public class DaoFactory {
6    public static UserDaoImpl getDaoImpl() {
7        return new UserDaoImpl();
8    }
9 }

 1 package com.jaovo.msg.Util;
 2 
 3 import java.sql.Connection;
 4 import java.sql.DriverManager;
 5 import java.sql.PreparedStatement;
 6 import java.sql.ResultSet;
 7 import java.sql.SQLException;
 8 
 9 public class DBUtil {
10     
11     public  static  Connection getConnection() {
12         try {
13             //1 加载驱动
14             Class.forName("com.mysql.jdbc.Driver").newInstance();
15         } catch (InstantiationException | IllegalAccessException | ClassNotFoundException e) {
16             // TODO Auto-generated catch block
17             e.printStackTrace();
18         }
19         String user = "root";
20         String password = "root";
21         String url = "jdbc:mysql://localhost:3306/jaovo_msg";
22         Connection connection = null;
23         try {
24             //2 创建链接对象connection
25              connection = DriverManager.getConnection(url,user,password);
26         } catch (SQLException e) {
27             // TODO Auto-generated catch block
28             e.printStackTrace();
29         }
30         return connection;
31     }
32     
33     //关闭资源的方法
34     public static void close(Connection connection ) {
35         try {
36             if (connection != null) {
37                 connection.close();
38             }
39             
40         } catch (SQLException e) {
41             // TODO Auto-generated catch block
42             e.printStackTrace();
43         }
44     }
45     public static void close(PreparedStatement preparedStatement ) {
46         try {
47             if (preparedStatement != null) {
48                 preparedStatement.close();
49             }
50             
51         } catch (SQLException e) {
52             // TODO Auto-generated catch block
53             e.printStackTrace();
54         }                                                 
55     }
56     public static void close(ResultSet resultSet ) {
57         try {
58             if (resultSet != null) {
59                 resultSet.close();
60             }
61             
62         } catch (SQLException e) {
63             // TODO Auto-generated catch block
64             e.printStackTrace();
65         }
66     }
67     
68 }

 1 package com.jaovo.msg.Util;
 2 
 3 public class UserException extends RuntimeException{
 4 
 5     public UserException() {
 6         super();
 7         // TODO Auto-generated constructor stub
 8     }
 9     public UserException(String message, Throwable cause, boolean enableSuppression, boolean writableStackTrace) {
10         super(message, cause, enableSuppression, writableStackTrace);
11         // TODO Auto-generated constructor stub
12     }
13     public UserException(String message, Throwable cause) {
14         super(message, cause);
15         // TODO Auto-generated constructor stub
16     }
17 
18     public UserException(String message) {
19         super(message);
20         // TODO Auto-generated constructor stub
21     }
22 
23     public UserException(Throwable cause) {
24         super(cause);
25         // TODO Auto-generated constructor stub
26     }
27     
28 }

ValidateUtil
 1 package com.jaovo.msg.Util;
 2 import java.util.HashMap;
 3 import java.util.Map;
 4 import javax.servlet.http.HttpServletRequest;
 5 public class ValidateUtil {
 6    public static boolean validateNull(HttpServletRequest request,String[] fileds)
 7    {
 8        boolean validate=true;
 9        //map对象用来装载不同的错误信息
10        Map<String,String> errorMsg=new HashMap();
11        for(String filed:fileds)
12        {
13            String value=request.getParameter(filed);
14            if(value==null||"".equals(value.trim()))
15            {
16                validate=false;
17                errorMsg.put(filed,filed+"不能为空");
18            }
19        }
20        return validate;
21    }
22    public static String showError(HttpServletRequest request,String filed)
23    {
24      Map<String,String> errorMsg=(Map<String,String>)request.getAttribute("errormsg");
25      if(errorMsg==null)
26      {
27          return "";
28      }
29      String msg=errorMsg.get(filed);
30      if(msg==null)
31      {
32          return "";
33      }
34      return msg;
35    }
36 }

add.jsp 
1 <%@page import="com.jaovo.msg.Util.UserException"%>
 2 <%@page import="com.jaovo.msg.dao.UserDaoImpl"%>
 3 <%@page import="com.jaovo.msg.model.User"%>
 4 <%@ page language="java" contentType="text/html; charset=UTF-8"
 5     pageEncoding="UTF-8"%>
 6 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 7 <html>
 8 <%
 9     //接收客户端传递过来的参数
10     String lesson = request.getParameter("lesson");
11     String teacher = request.getParameter("teacher");
12     String status = request.getParameter("status");
13     if(lesson == null || "".equals(lesson.trim())){
14         request.setAttribute("error", "用户名不能为空");
15     //}
16 %>
17     <jsp:forward page="addInput.jsp"></jsp:forward>
18 <%
19     }
20 if(lesson!=null&&(lesson.equals("软件工程概论")||lesson.equals("统一建模")||lesson.equals("数据结构")||lesson.equals("离散数学")||lesson.equals("马克思原理")))
21 {
22     
23 }
24 else
25 {
26     request.setAttribute("error", "课程信息不在范围里");
27     //}
28 %>
29     <jsp:forward page="addInput.jsp"></jsp:forward>
30 <%        
31 }
32 if(teacher!=null&&(teacher.equals("刘丹")||teacher.equals("王建民")||teacher.equals("封筠")||teacher.equals("韩培花")||teacher.equals("刘力嘉")))
33 {
34     
35 }
36 else
37 {
38     request.setAttribute("error", "教师姓名不在范围里");
39     //}
40 %>
41     <jsp:forward page="addInput.jsp"></jsp:forward>
42 <%        
43 }
44 if(status!=null&&(status.equals("基教")||status.equals("二教")||status.equals("三教")||status.equals("九教")||status.equals("学院楼")))
45 {
46     
47 }
48 else
49 {
50     request.setAttribute("error", "任课地点不在范围里");
51     //}
52 %>
53     <jsp:forward page="addInput.jsp"></jsp:forward>
54 <%        
55 }
56     User user = new User();
57     user.setLesson(lesson);
58     user.setTeacher(teacher);
59     user.setStatus(status);
60     
61     UserDaoImpl userDao = new UserDaoImpl();
62     try{
63     userDao.add(user);
64 %>
65     用户保存成功!!<br>
66     <a href="addInput.jsp">继续添加</a><br>
67     <a href="#">用户列表</a>
68 <%
69     }catch(UserException e){
70 %>
71     <h2 style="color:red ; font-size:50px">发生错误 : <%=e.getMessage() %></h2>
72     <%
73     }
74     %>
75 </html>

addInput.jsp
 1 <%@ page language="java" contentType="text/html; charset=UTF-8"
 2     pageEncoding="UTF-8"%>
 3 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 4 <html>
 5 <head>
 6     <title>用户添加页面</title>
 7 </head>
 8 <body>
 9     <%=request.getAttribute("error") %>
10     <form action="add.jsp" method="get">
11         <table align="center" border="1" width="500">
12             <tr>
13                 <td>课程名称 : </td>
14                 <td>
15                     <input type="text" name="lesson" />
16                 </td>
17             </tr>
18                 <tr>
19                 <td>任课教师:</td>
20                 <td>
21                     <input type="text" name="teacher" />
22                 </td>
23             </tr>
24             <tr>
25                 <td>任课地点:</td>
26                 <td>
27                     <input type="text" name="status" />
28                 </td>
29             </tr>
30             <tr align="center">
31                 <td colspan="2">
32                     <input type="submit" value="提交" />
33                     <input type="reset" value="重置" />
34                 </td>
35             </tr>
36         </table>
37     </form>
38 </body>
39 </html>

运行结果截图：

出现的错误分析：

出错的最基本点还是在特别容易连不上数据库，因为一些小的问题系统就出错误，而且在添加判断的时候，由于对html语言不太熟悉，因为一个花括号加错了一个位置，而出现了整个程序就出了问题，直接网页出现404的错误，当时确实特别懵逼，但是通过李志强及时看出了这个错误，让完成的时间减少了不少。

没完成的地方

就是关于地点的判断还达不到后缀有几零几。

心得：

希望完成这次博客园之后，找一些解决方案，对系统做进一步的分析。