用的是MySQL8和elipse,
想在连接数据库的基础上,
把数据库里img这个里面存的图片路径运用到JSP的标签上,
目前img里存的是image/malatang.jpg ,
image是当前项目的图片夹,
完全小白自学中,希望大家能给出详细的修改的代码,谢谢大家!
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="com.mysql.jdbc.Driver" %>
<%@ page import="java.sql.*" %>
<html>
<head>
<title>通过JSP打开数据表</title>
</head>
<body>
<%
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("驱动程序加载成功...");
String url = "jdbc:mysql://localhost:3306/test1?useSSL=false&serverTimezone=Asia/Shanghai";
String user = "root";
String password = "1122";
String tableName="test1";
Connection conn = DriverManager.getConnection(url, user, password);
out.print("数据库连接成功!");
out.print("<br />");
String imgpath = "SELECT img FROM foodstest;";
request.getContextPath();
Statement stmt = null;
stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(imgpath);
out.print("查询结果:");
while (rs.next()) {
out.println(rs.getString("img")); //将查询结果输出
}
%>
<br/>
<img src="<%=?>" alt="images"/>