會(huì)議室預(yù)定系統(tǒng)過濾器項(xiàng)目Java web服務(wù)器運(yùn)行錯(cuò)誤，JS正則表達(dá)式判斷非空【詩書畫唱】
個(gè)人的注釋：
create table huiyiInfo(
id int primary key auto_increment,
huiYiShiName varchar(100) ,
yuShiRenName varchar(100) ,
riQi? date);
insert into huiyiInfo(
huiYiShiName ,
yuShiRenName ,
riQi
) values ("第一會(huì)議室",'詩書畫唱1','2020-06-26'),
("第二會(huì)議室",'詩書畫唱2','2020-05-20'),("第三會(huì)議室",'詩書畫唱3','2020-09-09');
--drop table huiyiInfo
--select * from huiyiInfo
加個(gè)過濾器后：
package com.SSHC.Filter;
import java.io.IOException;
import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.annotation.WebFilter;
@WebFilter("/*")
public class CodeFilter implements Filter {
? ?
? ? public CodeFilter() {
? ? ? ? // TODO Auto-generated constructor stub
? ? }
public void destroy() {
// TODO Auto-generated method stub
}
public void doFilter(ServletRequest request,?
ServletResponse response, FilterChain chain)
throws IOException, ServletException {
// TODO Auto-generated method stub
// place your code here
request.setCharacterEncoding("utf-8");
chain.doFilter(request, response);
}
public void init(FilterConfig fConfig) throws ServletException {
// TODO Auto-generated method stub
}
}
package com.SSHC.bean;
import java.util.Date;
public class HuiyiInfo {
? ? private Integer id;
? ? private String huiYiShiName;
? ? private String yuShiRenName;
//? ??
//? ? 個(gè)人的注釋：因?yàn)閿?shù)據(jù)庫有時(shí)會(huì)默認(rèn)把日期字符串處理為Date類型
//? ? ，所以這里可以聲明為String類型
? ? private String riQi;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getHuiYiShiName() {
return huiYiShiName;
}
public void setHuiYiShiName(String huiYiShiName) {
this.huiYiShiName = huiYiShiName;
}
public String getYuShiRenName() {
return yuShiRenName;
}
public void setYuShiRenName(String yuShiRenName) {
this.yuShiRenName = yuShiRenName;
}
public String getRiQi() {
return riQi;
}
public void setRiQi(String riQi) {
this.riQi = riQi;
}
}
package com.SSHC.controller;
import java.io.IOException;
import java.util.Date;
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 com.SSHC.DAO.Dao;
import com.SSHC.bean.HuiyiInfo;
/**
?* Servlet implementation class addOKServlet
?*/
@WebServlet("/AddServlet")
public class AddServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
? ? /**
? ? ?* @see HttpServlet#HttpServlet()
? ? ?*/
? ? public AddServlet() {
? ? ? ? super();
? ? ? ? // TODO Auto-generated constructor stub
? ? }
/**
* @see HttpServlet#doGet(HttpServletRequest?
* request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request,?
HttpServletResponse response)?
throws ServletException, IOException {
// TODO Auto-generated method stub
this.doPost(request, response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest?
* request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest
request, HttpServletResponse response)
throws ServletException, IOException {
// TODO Auto-generated method stub
//亂碼處理:
// ? ? request.setCharacterEncoding("utf-8");
? ? //1、獲取表單中輸入的數(shù)據(jù):
? ? String? HuiYiShiName = request.getParameter("selectName");
? ? String YuShiRenName= request.getParameter("YuShiRenName");
String RiQi= request.getParameter("RiQi");
?
System.out.println(HuiYiShiName+"? ?"+YuShiRenName+"? "+RiQi);
// ? // Integer gyear2=Integer.valueOf(gyear);
// Integer gyearInteger=0;
// if(gyear != null && gyear.length() > 0) {
//
// RiQi=Date.valueOf(gyear);
//
// }
? ? HuiyiInfo u = new HuiyiInfo();
? ? u.setHuiYiShiName(HuiYiShiName);
? ? u.setYuShiRenName(YuShiRenName);
?
? ? u.setRiQi(RiQi);
? ?
? ?
? ? ??
Dao ud = new Dao();
? ud.add(u);
? ?
//Integer count = ud.add(u);
String S=null;
? ? if(ud.count>0) {
? S="會(huì)議室預(yù)定成功！";
? ? }else?
? ? {
? ? S="會(huì)議室預(yù)定失敗！";
? ? }??
? request.setAttribute("S", S);
?
? request.getRequestDispatcher("addOK.jsp")
? ? ? .forward(request, response);
}
}
package com.SSHC.controller;
import java.io.IOException;
import java.util.List;
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 com.SSHC.DAO.GameDao;
import com.SSHC.bean.HuiyiInfo;
@WebServlet("/FirstPageServletStart")
public class FirstPageServletStart extends HttpServlet {
private static final long serialVersionUID = 1L;
??
? ? public FirstPageServletStart() {
? ? ? ? super();
? ? ? ? // TODO Auto-generated constructor stub
? ? }
/**
* @see HttpServlet#doGet(HttpServletRequest request,
*? HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request,?
HttpServletResponse response)?
throws ServletException, IOException {
// TODO Auto-generated method stub
this.doPost(request, response);
}
protected void doPost(HttpServletRequest request,
HttpServletResponse response)?
throws ServletException, IOException {
// TODO Auto-generated method stub
//亂碼處理：
request.setCharacterEncoding("utf-8");
GameDao gd = new GameDao();
List<HuiyiInfo>list = gd.selectAll();
StringBuilder html = new StringBuilder();
for(HuiyiInfo g : list) {
Integer gI= g.getId();
String gH = g.getHuiYiShiName();
String gY = g.getYuShiRenName();
String gR = g.getRiQi();
System.out.println(gH+"? ?"+gY+"? ?"+gR);
html.append("<tr>");
? html.append("<td class='inp'>" + gI + "</td>");
? ? ? ? html.append("<td class='inp'>" + gH + "</td>");
? ? ? ? html.append("<td class='inp'>" + gY + "</td>");
? ? ? ? html.append("<td class='inp'>" + gR + "</td>");
? ? ? ? html.append("</tr>");
}
request.setAttribute("html", html);
request.getRequestDispatcher("firstPage.jsp")
? ? .forward(request, response);
}
}
package com.SSHC.DAO;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.SSHC.bean.HuiyiInfo;
import com.SSHC.utils.DBUtils;
//類名就是對(duì)應(yīng)的bean的名字后面加上Dao
//Dao就是數(shù)據(jù)訪問類的意思，就是對(duì)Game表進(jìn)行增刪改查的代碼都寫在這個(gè)類中
public class Dao {
public List<HuiyiInfo>selectAll(){
String sql = "select * from huiyiInfo";
Connection conn = null;
PreparedStatement pstm = null;
ResultSet rs = null;
List<HuiyiInfo>list = new ArrayList<HuiyiInfo>();
try {
conn = DBUtils.getConn();
pstm = conn.prepareStatement(sql);
rs = pstm.executeQuery();
while(rs.next()) {
Integer id = rs.getInt("id");
String huiYiShiName = rs.getString("huiYiShiName");
String yuShiRenName = rs.getString("yuShiRenName");
String riQi = rs.getString("riQi");
System.out.println(huiYiShiName);
//進(jìn)行打包：
HuiyiInfo g = new HuiyiInfo();
g.setId(id);
g.setHuiYiShiName(huiYiShiName);
g.setYuShiRenName(yuShiRenName);
g.setRiQi(riQi);
//繼續(xù)打包：
list.add(g);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
public? int count=0;
?public Integer add(HuiyiInfo? u) {
??
? ? String sql = "insert into huiyiInfo("
+ "huiYiShiName,yuShiRenName,riQi) values(?,?,?);";
? ? Connection conn = null;
? ? PreparedStatement pstm = null;
? ? ResultSet rs = null;
? ? try {
? ? ? ? conn = DBUtils.getConn();
pstm = conn.prepareStatement(sql);
//設(shè)置占位符
pstm.setObject(1,u.getHuiYiShiName());
pstm.setObject(2,u.getYuShiRenName() );
pstm.setObject(3,u.getRiQi());
// pstm.setObject(1,"三連會(huì)議室");
// pstm.setObject(2,"詩書畫唱");
// pstm.setObject(3,"2020-7-8");
//
count=pstm.executeUpdate();
? ? ? ? } catch (SQLException e) {
? ? ? ? ? ? // TODO Auto-generated catch block
? ? ? ? ? ? e.printStackTrace();
? ? ? ? }finally{
?
? ? ? ? ? ?
DBUtils.close(rs, pstm, conn);
}
? ? return 0;
? ? }
}
package com.SSHC.utils;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Properties;
public class DBUtils {
? ? private static String driverName;
? ? private static String url;
? ? private static String userName;
? ? private static String pwd;
? ? //靜態(tài)塊，隨著類加載而運(yùn)行的
? ? static{
? ? //讀取db.properties文件中的內(nèi)容
? ? Properties prop = new Properties();
? ? InputStream is = DBUtils.class.getClassLoader()
? ? .getResourceAsStream("db.properties");
? ? try {
prop.load(is);
driverName = prop.getProperty("dn");
url = prop.getProperty("url");
userName = prop.getProperty("un");
pwd = prop.getProperty("up");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
? ? }
? ??
? ? public static Connection getConn(){
? ? Connection conn = null;
? ? try {
Class.forName(driverName);
conn = DriverManager.getConnection(url,userName,pwd);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
? ? return conn;
? ? }
? ??
? ? public static void close(ResultSet rs,PreparedStatement pstm
? ? ,Connection conn){
? ? try {
? ? if(rs != null) {
? ? rs.close();
? ? }
? ? if(pstm != null) {
? ? pstm.close();
? ? }
? ? if(conn != null) {
? ? conn.close();
? ? }
? ? } catch(Exception e) {
? ? e.printStackTrace();
? ? }
? ? }
}
dn=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/firstjsp?useUnicode=true&characterEncoding=UTF-8
un=root
up=root
<%@ page language="java" contentType=
"text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%
? ? String path = request.getContextPath();
? ? String basePath = request.getScheme()
? ? +"://"+request.getServerName()
? ? +":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
? ? <head>
? ? ? ? <base hreff="<%=basePath%>">
? ? ? ? <title></title>
? ? ? ? <meta http-equiv="pragma" content="no-cache">
? ? ? ? <meta http-equiv="cache-control" content="no-cache">
? ? ? ? <meta http-equiv="expires" content="0">
?<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
? ? ? ? <meta http-equiv="description" content="This is my page">
? ? ? ? <style type="text/css">
? ? ? ? ? ? * {
? ? ? ? ? ? ? ? font-size: 23px;
? ? ? ? ? ? }
? ? ? ? ??
? ? ? ? .inp {
? ? ? ? ? ? ? ? box-shadow: 5px 5px 5px #888888;
? ? ? ? ? ? ? ? border: 0px;
? ? ? ? ? ? ? ? border-radius: 5px;
? ? ? ? ? ? }
? ? ? ? ? ? body{
background-image: url('img/1.png');
background-repeat: no-repeat;
background-size: 100%;
}
? ? ? ? </style>
? ? ? ? <script type="text/javascript">
? ? ? ? ? ? function cancel(){
? ? ? ? ? ? window.location.href = 'add.jsp';
? ? ? ? ? ? }
? ? ? ? ??
? ? ? ? ?
? ? ? ? ? ? //表單驗(yàn)證的方法
? ? ? ? ? ? function doCheck(){
<%--? ? 下面是JS獲取選中的下拉框的值的方法，我記得我以前嘗試過
下面兩句不可以合起來寫要分開寫，
?不然會(huì)沒效果，報(bào)錯(cuò)等：
? ? ? ? ? ? var myselect=document.getElementById("selectId");
? ? ? ? ? ?
? ? ? ? ? ? var myselectValue=myselect.options[index].value;
? ? ? ? ? ? --%>??
var yuShiRenName= document.getElementsByName('YuShiRenName')[0].value;
?var riQi= document.getElementsByName('RiQi')[0].value;
? ?
? ?<%-- 下面是我原創(chuàng)的自己想出來的用JS的正則表達(dá)式和test【
? ?test() 方法用于檢測(cè)一個(gè)字符串是否匹配某個(gè)模式.
如果字符串中有匹配的值返回 true ，否則返回 false。
個(gè)人理解：用于判斷兩個(gè)字符串等是否相等?！?/span>
? ?來判斷是否為非空的方法
? ?--%>??
? ?<%--? .可以替換任意的除了\n（換行符）以外的任意字符。
"{n,}"——匹配前一個(gè)字符n次或更多次。
--%>? ? var reg = /.{1,}/;
? ? ? ? ? ? ? ? ? ?<%-- 其實(shí)可以用正則表達(dá)式來判斷輸入格式的對(duì)出的
? ? ? ? ? ? ? ? 但是有些月的天數(shù)等隨平年和閏年等而改變等，所以
? ? ? ? ? ? ? ? 還是直接用網(wǎng)上找的js日期框方便?
?var reg2 = /^\d{4}-[1-12]{1-2}-[1-31]{1-2}/;
?
?因?yàn)槲以O(shè)置了默認(rèn)的選中的會(huì)議室，所以不必判斷會(huì)議室的部分是否為空 --%>
? ?//如果year是一個(gè)四位數(shù)字，那么r就為true，否則就為false
? ? ? ? ? ? ? ? var r = reg.test(riQi);
? ? ? ? ? ? ? ? var y = reg.test(yuShiRenName);
? ? ? ? ? ? ? ? if(!r) {
? ? ? ? ? ? ? ? alert('預(yù)定日期和預(yù)定者不能為空！');
? ? ? ? ? ? return r;
? ? ? ? ? ? ? ? }
? ? ? ? ? ? ? ?
? ? ? ? ? ? ? ? if(!y) {
? ? ? ? ? ? ? ? ? ? ? ? alert('預(yù)定日期和預(yù)定者不能為空！');
? ? ? ? ? ? ? ? ? ? return y;
? ? ? ? ? ? ? ? ? ? ? ? }
? ? ? ? ? ? ? ?
? ? ? ? ? ? }
? ? ? ? ? ?
? ? ? ? ??
? ??
? ? ? ? </script>
? ? </head>
? ? <body>
? ? ? ? <table style="width:100%;" >
? ? ? ? ? ? <tr>
?<td style="background-color:gray;text-align:center;">預(yù)定會(huì)議室</td>
? ? ? ? ? ? </tr>
? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? <td align="center">
? ? ? ? ? ? ? ? ? ?<%--<form action="addOK.jsp" method="post"> --%>?
?<form action="AddServlet" method="post" onsubmit="return doCheck();">
<table>
? ? <tr>
? ? ? ? <td>會(huì)議室名稱：</td>
<td>
<%-- <input class="inp" type="text" name="HuiYiShiName" />--%>
?<select id="selectId" name="selectName">
<option value='第一會(huì)議室' selected>第一會(huì)議室</option>
<option value='第二會(huì)議室' >第二會(huì)議室</option>
<option value='第三會(huì)議室' >第三會(huì)議室</option>
<%--${xiaLaKuangHtml }; --%>
</select>
? ? ? <span style="color:red;">*</span>
? ? ? ? </td>
? ? </tr>
? ? <tr>
? ? ? ? <td>預(yù)定日期：</td>
<td><input class="inp" type="text" name="RiQi" />
<span style="color:red;"> 如：yyyy-mm-dd</span></td>
? ? </tr>
? ? <tr>
? ? ? ? <td>預(yù)定者：</td>
?<td><input class="inp" type="text" name="YuShiRenName" /></td>
? ? </tr>
? ?
? ? <tr>
? ? ? ? <td colspan="2" align="center">
? <input type="submit" value="預(yù)定" onclick='doCheck();' />
?<input type="button" value="重置" onclick="cancel();" />
? ? ? ? </td>
? ? </tr>
</table>
</form>
? ? ? ? ? ? ? ? </td>
? ? ? ? ? ? </tr>
? ? ? ? </table>
? ? </body>
</html>
<%@ page language="java" contentType=
"text/html; charset=utf-8"
? ? pageEncoding="utf-8"%>
? ? ? <%@page import="com.SSHC.DAO.GameDao"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01
?Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<script type="text/javascript">
alert('${S }');
</script>
<body>
</body>
</html>
<%@ page language="java" contentType="text/html;
?charset=UTF-8" pageEncoding="UTF-8"%>
<%
? ? String path = request.getContextPath();
? ? String basePath = request.getScheme()
? ? +"://"+request.getServerName()
? ? +":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
? ? <head>
? ? ? ? <base hreff="<%=basePath%>">
? ? ? ? <title></title>
? ? ? ? <meta http-equiv="pragma" content="no-cache">
? ? ? ? <meta http-equiv="cache-control" content="no-cache">
? ? ? ? <meta http-equiv="expires" content="0">
? ? ? ? <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
? ? ? ? <meta http-equiv="description" content="This is my page">
? ? ? ? <style type="text/css">
? ? ? ? ? ? * {
? ? ? ? ? ? ? ? font-size: 23px;
? ? ? ? ? ? }
? ? ? ? ? ? td{text-align: center;vertical-align: middle;}
? ? ? ? ? ?
?.inp {
? ? ? ? ? ? ? ? box-shadow: 5px 5px 5px #888888;
? ? ? ? ? ? ? ? border: 0px;
? ? ? ? ? ? ? ? border-radius: 5px;
? ? ? ? ? ? }
body{
background-image: url('img/1.png');
background-repeat: no-repeat;
background-size: 100%;
}
? ? ? ? </style>
? ? ? ? <script type="text/javascript">
? ? ? ? ? ? function bk(){
? ? ? ? ? ? window.location.hreff = 'add.jsp';
? ? ? ? ? ? }
? ? ? ? </script>
? ? </head>
? ? <body>
? ? ? ? <table cellspacing="0px" border="0px"? style="width:100%;" >
? ? ? ? ? ?
? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? <td style="background-color:gray;
? ? ? ? ? ? ? ? text-align:center;" class='inp'>會(huì)議室信息</td>
? ? ? ? ? ? </tr>
? ? ? ? ? ? <tr>
? ? ? ? ? ? ? ? <td>
?<table cellspacing="0px" border="0px" style="width:100%;">
? ? ? ? ? ? ? ? ? ? ? ? <tr >
? ? ? ? ? ? ? ? ? ? ? ? ? ? <th class='inp'>編號(hào)</th>
? ? ? ? ? ? ? ? ? ? ? ? ? ? <th class='inp'>會(huì)議室名稱</th>
? ? ? ? ? ? ? ? ? ? ? ? ? ? <th class='inp'>預(yù)定人</th>
? ? ? ? ? ? ? ? ? ? ? ? ? ? <th class='inp'>日期</th>
? ? ? ? ? ? ? ? ? ? ? ? </tr>
? ? ? ? ? ? ? ? ? ? ? ? ${html }
? ? ? ? ? ? ? ? ? ? </table>
? ? ? ? ? ? ? ? ? ??
? ? ? ? ? ? ? ? </td>
? ? ? ? ? ? </tr>
? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? <td class='inp'><a hreff="javascript:bk()"?
? ? ? ? ? ? ? ? style="float:right;">預(yù)定</a></td>
? ? ? ? ? ? </tr>
? ? ? ? </table>
? ? </body>
</html>
