用的是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"/>
<img alt="图片加载失败" src="${pageContext.request.contextPath}/image/malatang.jpg" width="150px" height="100px">
在head内添加如下
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
图片
<img src="<%=basePath%>image/malatang.jpg" alt="images"/>
即
while (rs.next()) {
$('img').attr('src','<%=basePath%>' + rs.getString("img"))
out.println('<%=basePath%>' + rs.getString("img")); //将查询结果输出
}
此处仅针对一张图片