javaweb实战，疫情防控数据上报至数据库 html+mysql+servlet

1.前端HTML代码

	
	


	上报体温
	

		  姓名：


		  电话：


		  高风险地区接触史：

		  无
		  有


		  体温：

`在这里插入代码片`
		
	

2.后端逻辑处理，添加数据到数据库。

package test;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
//import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@SuppressWarnings("serial")
public class AddTempServlet extends HttpServlet {

	@Override
	protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// TODO Auto-generated method stub
		//super.service(req, resp);
		req.setCharacterEncoding("UTF-8");
		String name= req.getParameter("name");
		String telephone= req.getParameter("telephone");
		String isContacted= req.getParameter("isContacted");
		String temperature= req.getParameter("temperature");
		int isCon=0;
		
		if(isContacted!=null) {
			isCon=Integer.parseInt(isContacted);	
		}
		float temp=0;
		if(temperature!=null) {
			temp=Float.parseFloat(temperature);
		}
			
		Connection con = null;
		PreparedStatement pst = null;
		ResultSet rs = null;	
		try {
			Class.forName("com.mysql.jdbc.Driver");
			con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/temp?characterEncoding=utf8", "root",
					"123456");
			
			String sql = "insert into temperature(name,telephone,isContacted,DATE,temp) values(?,?,?,?,?);";
			pst = con.prepareStatement(sql)	;
			pst.setString(1, name);
			pst.setString(2, telephone);
			pst.setInt(3, isCon);
			pst.setDate(4, new java.sql.Date(new java.util.Date().getTime()));
			pst.setDouble(5, temp);
			
			pst.executeUpdate();
		

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if (rs != null) {
				try {
					rs.close();
				} catch (Exception e) {
				}
			}
			if (pst != null) {
				try {
					pst.close();
				} catch (Exception e) {
				}
			}
			if (con != null) {
				try {
					con.close();
				} catch (Exception e) {
				}
			}
		}
		
		
		resp.sendRedirect("list");
	}

}

**3.后端逻辑处理，上报数据之后，返回信息给客户端。**
package test;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;

import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.http.HttpServlet;

import java.sql.Statement;

@SuppressWarnings("serial")
public class ListTempServlet extends HttpServlet {

	
	@Override
	public void service(ServletRequest request, ServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		// super.service(arg0, arg1);

	Connection con = null;
	Statement st = null;
	ResultSet rs = null;

		response.setContentType("text/html;charset=UTF-8");
		PrintWriter out = response.getWriter();
	//	out.print("");
		out.print("");
		out.print(" 序号");
		out.print(" 姓名");
		out.print(" 电话");
		out.print(" 是否去过高风险地区");
		out.print(" 日期");
		out.print(" 体温");
		out.print("");
		
		

		try {
			Class.forName("com.mysql.jdbc.Driver");
			con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/temp?characterEncoding=utf8", "root",
					"123456");
			st = con.createStatement();
			//String sql = "select *from temperature";
			//rs = st.executeQuery(sql);
			
			String sql = "select *from temperature;";
			rs = st.executeQuery(sql);
			//String sql1 = "update temperature set name='王五'  where id='1' ;" ;
			//rs = st.executeQuery(sql1);
			
			while(rs.next()) {
				out.print("");
				out.print(""+rs.getInt("id")+"");
				out.print(""+rs.getString("name")+"");
				out.print(""+rs.getString("telephone")+"");
				if(rs.getInt("isContacted")==0) {
					out.print("否");
				}else {
					out.print("是");			
				}
				out.print(""+rs.getDate("date")+"");
				out.print(""+rs.getFloat("temp")+"");
				out.print("");		
				
				//out.print()
			}
			
			
			
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if (rs != null) {
				try {
					rs.close();
				} catch (Exception e) {
				}
			}
			if (st != null) {
				try {
					st.close();
				} catch (Exception e) {
				}
			}
			if (con != null) {
				try {
					con.close();
				} catch (Exception e) {
				}
			}
		}
		//out.print("百度");
	
		//out.print("");
		out.print("
");	
		//out.print("");
		//out.print("");	
		
	//	out.print("");
		
		out.print("");
	}
}

4.运行效果