基础servlet代码，连接数据库，显示在jsp页面

qq_43472248

已于 2023-07-07 22:19:21 修改

阅读量603

点赞数

分类专栏： # springboot 文章标签： mysql java servlet

于 2020-07-29 20:44:10 首次发布

本文链接：https://blog.csdn.net/qq_43472248/article/details/107674769

版权

springboot 专栏收录该内容

65 篇文章 1 订阅

订阅专栏

前提条件：有数据库，连接数据库jar包

servlet代码：

package com.itdu.servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

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

@WebServlet("/order")
public class OrderServlet extends HttpServlet {
	static int  id;
	static String name;
	static String addr;
	
	
	@Override
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		try {
			jdbcUtil();
		} catch (ClassNotFoundException | SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		request.setAttribute("id", id);
		request.setAttribute("name", name);
		request.setAttribute("addr", addr);
		
		request.getRequestDispatcher("WEB-INF/order.jsp").forward(request, response);
		
		
		
	}
	
	@Override
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}
	
	public static void jdbcUtil() throws ClassNotFoundException, SQLException{
		Class.forName("com.mysql.jdbc.Driver");
		Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb4","root" ,"123456");
		Statement stat = conn.createStatement();
		ResultSet rs = stat.executeQuery("select * from tb_order");
		while(rs.next()){
			id = rs.getInt(1);
			name = rs.getString(2);
			addr = rs.getString(3);
			break;
		}
		rs.close();
		stat.close();
		conn.close();
		
	}

}

jsp代码页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!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=UTF-8">
<title>Insert title here</title>
</head>
<body>
订单号：${id };
订单名字：${name };
订单地址${addr};



</body>
</html>

结果：

订单号：1; 订单名字：zhangsan; 订单地址fengcheng;

qq_43472248

关注

0
点赞
踩
5

收藏

觉得还不错? 一键收藏
打赏
0
评论
基础servlet代码，连接数据库，显示在jsp页面

前提条件：有数据库，连接数据库jar包servlet代码：package com.itdu.servlet;import java.io.IOException;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import javax.servlet.Servl
复制链接

扫一扫