Java__前端浏览器向服务器发送一个查询数据的请求, 服务器接收到请求后去查询数据库的emp表中所有数据, 并给表格的方式输出到前端浏览器页面

最新推荐文章于 2023-04-19 17:22:45 发布

God Zhang

最新推荐文章于 2023-04-19 17:22:45 发布

阅读量561

点赞数

分类专栏： Servlet 文章标签： Java Servlet JDBC MySQL 数据插入数据查询

本文链接：https://blog.csdn.net/m0_72254454/article/details/126677314

版权

Servlet 专栏收录该内容

9 篇文章 2 订阅

订阅专栏

模式思维构图

浏览器输入数据，往mysql数据库中添加数据

其中是用jdbc连接MySQL数据库，然后读取浏览器数据，根据MySQL插入方法写入数据库

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import jakarta.servlet.ServletException;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import jakarta.servlet.http.HttpSession;

public class AddEmpServlet extends HttpServlet {

	@Override
	protected void service(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		 request.setCharacterEncoding("UTF-8");
		 response.setContentType("text/html;charset=UTF-8");
		 PrintWriter out =response.getWriter();

		// 获取表单中提交的客户数据
		String name = request.getParameter("name");
		String salary = request.getParameter("salary");
		String age = request.getParameter("age");
		Connection conn=null;
		PreparedStatement pstmt=null;
		try {
			// 1、加载驱动
			Class.forName("com.mysql.cj.jdbc.Driver");
			// 2、创建连接
		 conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/dxw", "root", "1234");

			// 构造sql语句，插入用户注册数据至数据库中
			String sql = "insert into emp(name,salary,age) values(?,?,?)";
			 pstmt = conn.prepareStatement(sql);
			pstmt.setString(1,name);
			pstmt.setString(2, salary);
			pstmt.setString(3, age);
			int rows = pstmt.executeUpdate();
			if (rows != 0) {
				out.println("数据插入成功");
				out.println("<a href='listEmp'>点击查看员工列表</a>");
			} else {
				out.println("数据插入失败");
			}
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			try {
				if(out!=null)out.close();
				if(pstmt!=null)pstmt.close();
				if(conn!=null)conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}

	}

}

写入到数据库后，我们可以用一个链接来点击它，进行跳转下一个servlet界面

第二个servlet是查询数据库，将查到的数据打印到浏览器界面

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;

import com.zbj.web.entily.Emp;

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

public class LsitEmpServlet extends HttpServlet {
	@Override
	protected void service(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("UTF-8");
		response.setContentType("text/html;charset=UTF-8");
		PrintWriter out = response.getWriter();

		Connection conn = null;
		PreparedStatement pstmt = null;
		List<Emp> emps = new ArrayList<>();
		ResultSet rs = null;
		try {
			Class.forName("com.mysql.cj.jdbc.Driver");
			// 2、创建连接
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/dxw", "root", "1234");
			// 3、创建一个预编译sql语句的对象
			String sql = "select * from emp";
			pstmt = conn.prepareStatement(sql);

			// 4、将sql语句发送给数据库执行
			rs = pstmt.executeQuery();
			while (rs.next()) {
				Emp emp = new Emp();
				int id = rs.getInt("id");
				String name = rs.getString("name");
				String salary = rs.getString("salary");
				String age = rs.getString("age");
				emp.setId(id);
				emp.setName(name);
				emp.setSalary(salary);
				emp.setAge(age);
				emps.add(emp);
			}
			for (Emp emp : emps) {
				System.out.println(emp);
			}
			out.println("<script type='text/javascript'>alert('帐户密码格式错误!');</script>");
			out.println("<table align='center' width='400px' border-color='red' border='1' cellspacing='0' cellpadding='0'> ");
			out.println("<caption>员工列表清单</caption>");
			out.println("<tr>");
			out.println("<td>编号</td>");
			out.println("<td>姓名</td>");
			out.println("<td>薪水</td>");
			out.println("<td>年龄</td>");
			out.println("</tr>");

			for (int i = 0; i < emps.size(); i++) {
				Emp emp = emps.get(i);
				out.println("<tr>");
				out.println("<td>" + emp.getId() + "</td>");
				out.println("<td>" + emp.getName() + "</td>");
				out.println("<td>" + emp.getSalary() + "</td>");
				out.println("<td>" + emp.getAge() + "</td>");
				out.println("</tr>");
			}
			out.println("</table>");

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				if (out != null)
					out.close();
				if (pstmt != null)
					pstmt.close();
				if (conn != null)
					conn.close();
			} catch (SQLException e) {
					e.printStackTrace();
			}

		}

	}
}

我们写的是员工信息表，将员工当成一个类，所注册的数据当成属性

import java.io.Serializable;
import java.util.Objects;

public class Emp implements Serializable {
	private int id;
	private String name;
	private String salary;
	private String age;
	public Emp() {
		super();
	}
	public Emp(int id, String name, String salary, String age) {
		super();
		this.id = id;
		this.name = name;
		this.salary = salary;
		this.age = age;
	}
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getSalary() {
		return salary;
	}
	public void setSalary(String salary) {
		this.salary = salary;
	}
	public String getAge() {
		return age;
	}
	public void setAge(String age) {
		this.age = age;
	}
	@Override
	public int hashCode() {
		return Objects.hash(age, id, name, salary);
	}
	@Override
	public boolean equals(Object obj) {
		if (this == obj)
			return true;
		if (obj == null)
			return false;
		if (getClass() != obj.getClass())
			return false;
		Emp other = (Emp) obj;
		return Objects.equals(age, other.age) && id == other.id && Objects.equals(name, other.name)
				&& Objects.equals(salary, other.salary);
	}
	@Override
	public String toString() {
		return "Emp [id=" + id + ", name=" + name + ", salary=" + salary + ", age=" + age + "]";
	}

}

xml项目

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="https://jakarta.ee/xml/ns/jakartaee" xmlns:web="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="https://jakarta.ee/xml/ns/jakartaee https://jakarta.ee/xml/ns/jakartaee/web-app_5_0.xsd http://xmlns.jcp.org/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="5.0">
 
 <servlet>
 			<servlet-name>addEmp</servlet-name>
			<servlet-class>com.zbj.web.AddEmpServlet</servlet-class>
		 </servlet>
		 <servlet-mapping>
		 	<servlet-name>addEmp</servlet-name>
		 	<url-pattern>/addEmp</url-pattern>
		 </servlet-mapping>
 
  <servlet>
 			<servlet-name>listEmp</servlet-name>
			<servlet-class>com.zbj.web.LsitEmpServlet</servlet-class>
		 </servlet>
		 <servlet-mapping>
		 	<servlet-name>listEmp</servlet-name>
		 	<url-pattern>/listEmp</url-pattern>
		 </servlet-mapping>
		 
		
</web-app>

前端浏览器界面所呈现的HTML

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<style type="text/css">
		.f1{
		text-align: center;
		color:red;
		}
</style>
</head>
<body>
<form  class="f1" action="addEmp"  method="post">
			姓名：<input type="text" name="name"/>
			<br/>
			<br/>
			薪水：<input type="text" name="salary"/>
			<br/>
			<br/>
			年龄：<input type="text" name="age"/>
			<br/>
			<br/>
			<input style='width:100px;height:30px;background-color:green' type="submit" value="注册"/>
		</form>
</body>
</html>

God Zhang

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
打赏
0
评论
Java__前端浏览器向服务器发送一个查询数据的请求, 服务器接收到请求后去查询数据库的emp表中所有数据, 并给表格的方式输出到前端浏览器页面

【Java__前端浏览器向服务器发送一个查询数据的请求, 服务器接收到请求后去查询数据库的emp表中所有数据, 并给表格的方式输出到前端浏览器页面】
复制链接

扫一扫