官方网站做兼职,黑龙江省垦区建设协会网站,2022拉新推广平台,外贸网站开发 河南目录数据库创建数据库连接servlet创建,这里注意一下我的数据库我自己改了一下名字lhx网页html运行文件目录展示首先我们准备好开发使用的工具以及配置
idea2020 tomcat8.5 创建javaweb参考idea编译Tomcat详细步骤 IDEA通过JDBC连接数据库请参考jdbc连接数据库 需要登陆注册界面…
目录数据库创建数据库连接servlet创建,这里注意一下我的数据库我自己改了一下名字lhx网页html运行文件目录展示首先我们准备好开发使用的工具以及配置
idea2020 tomcat8.5 创建javaweb参考idea编译Tomcat详细步骤 IDEA通过JDBC连接数据库请参考jdbc连接数据库 需要登陆注册界面请参考web servlet jdbc mysql 实现简单的登陆注册界面
数据库创建
首先创建数据库temp 创建新的表单temperature
或者使用建表语句
CREATE TABLE temp.temperature (id INT NOT NULL AUTO_INCREMENT,name VARCHAR(30) NOT NULL,telephone CHAR(11) NOT NULL,isContacted TINYINT(1) NOT NULL,data DATE NOT NULL,temp DECIMAL(3) NOT NULL,PRIMARY KEY (id));插入数据
insert into temp.temperature value(null,李原浩,123456,0,2020-2-28,36.5);
insert into temp.temperature value(null,邢楚,123456,0,2020-2-28,36.2);
insert into temp.temperature value(null,江哥,123456,0,2020-2-28,36.8);
SELECT * FROM temp.temperature;数据库连接
连接mysql步骤请看IDEA通过JDBC连接数据库请参考jdbc连接数据库 创建一个测试类
import java.sql.*;
public class test {public static void main(String[] args) throws Exception {Class.forName(com.mysql.cj.jdbc.Driver);//注册驱动//连接数据库要处理对象我这里是lhx这个是个数据库大家可以在mysql创建Connection conn DriverManager.getConnection(jdbc:mysql://localhost:3306/temp, root, 123456);PreparedStatement prep conn.prepareStatement(SELECT * FROM temperature;);prep.execute();ResultSet rs prep.getResultSet();while (rs.next()) {System.out.println(rs.getString(id)rs.getString(name)rs.getString(telephone)rs.getString(isContacted)rs.getString(data)rs.getString(temp));}conn.close();}
}servlet创建,这里注意一下我的数据库我自己改了一下名字lhx
连接数据库传入网页数据代码如下
package Servlet;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 java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;WebServlet(/Servlet)
public class Servlet extends HttpServlet {protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {request.setCharacterEncoding(GBK);response.setCharacterEncoding(GBK);response.setHeader(content-tupe,test/html;GBK);PrintWriter p response.getWriter();Connection con null;Statement st null;ResultSet rs null;try {Class.forName(com.mysql.jdbc.Driver);//注册驱动Connection conn DriverManager.getConnection(jdbc:mysql://localhost:3306/lhx, root, 123456);PreparedStatement prep conn.prepareStatement(SELECT * FROM temperature;);prep.execute();rs prep.getResultSet();p.print(table border1px cellpadding10 cellspacing0);p.print(tr);p.print(th序号/th);p.print(th姓名/th);p.print(th电话/th);p.print(th14天内是否有湖北接触史/th);p.print(th日期/th);p.print(th体温/th);p.print(/tr);while (rs.next()) {//测试System.out.println(rs.getString(id) rs.getString(name) rs.getString(telephone) rs.getString(isContacted) rs.getString(data) rs.getString(temp));p.print(tr);p.print(tdrs.getInt(id)/td);p.print(tdrs.getString(name)/td);p.print(tdrs.getString(telephone)/td);if(rs.getInt(isContacted)0){ p.print(td styletext-align:center否/td);}else{ p.print(td styletext-align:center是/td);}p.print(tdrs.getString(data)/td);p.print(tdrs.getString(temp)/td);p.print(/tr);}p.print(/tablebr/);}catch(Exception e){e.printStackTrace();}finally {if (rs!null){try{rs.close();}catch (SQLException e) {}}if (st!null){try{rs.close();}catch (SQLException e) {}}if (con!null){try{rs.close();}catch (SQLException e) {}}}p.print(input typebutton value 添加新数据 οnclicklocation.href\index.html\ /);}protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doPost(request,response);}
}
配置xml servlet-mappingservlet-nameServlet/servlet-nameurl-pattern/servlet/Servlet/url-pattern/servlet-mappingservlet-mappingservlet-namelistServlet/servlet-nameurl-pattern/servlet/ListServlet/url-pattern/servlet-mappingAdd_Servlet
package temp;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 java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;WebServlet(/AddServlet)
public class AddServlet extends HttpServlet {protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {request.setCharacterEncoding(UTF-8);String name request.getParameter(name);String telephone request.getParameter(telephone);String isContacted request.getParameter(isContacted);String temperature request.getParameter(temperature);int isCon 0;if (isContacted ! null) {Integer.parseInt(isContacted);}double temp 0;if (temperature ! null) {temp Double.parseDouble(temperature);}Connection con null;PreparedStatement pst null;ResultSet rs null;
//
//try {Class.forName(com.mysql.jdbc.Driver);Connection connection DriverManager.getConnection(jdbc:mysql://localhost:3306/lhx, root, 123456);String sql insert into temperaturevalues(null,?,?,?,?,?);pst connection.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) {}}}response.sendRedirect(TempServlet);}protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doPost(request,response);}
}配置servletservlet-nameservlet/servlet-nameservlet-classServlet.Servlet/servlet-class
/servlet
servletservlet-nameAdd_Servlet/servlet-nameservlet-classServlet.Add_Servlet/servlet-class
/servletservlet-mappingservlet-nameservlet/servlet-nameurl-pattern/Servlet/Servlet/url-pattern
/servlet-mapping
servlet-mappingservlet-nameAdd_Servlet/servlet-nameurl-pattern/Servlet/Add_Servlet/url-pattern
/servlet-mapping网页html
!DOCTYPE html
html langen
headmeta charsetUTF-8title体温填报/title
/head
body
h3体温平安报/h3
form methodpost actionAdd_Servlet姓名input typetext namename /br/br/电话input typetext nametelephone /br/br/最近14天是否有湖北接触史br/没有input typeradio nameisContacted value0 checked/有input typeradio nameisContacted value1/br/br/体温input typetext nametemperature /br/br/input typesubmit value 上报 /
/form
/body
/html运行 文件目录展示
