jdbc连接数据库

最新推荐文章于 2025-04-27 19:40:02 发布

marty_zhu

最新推荐文章于 2025-04-27 19:40:02 发布

阅读量527

点赞数

文章标签： jdbc string div class sql import

本文链接：https://blog.youkuaiyun.com/marty_zhu/article/details/2003107

版权

本文介绍了一种使用JSP和Oracle数据库实现的随机产品推荐系统。通过计算总产品数量并随机选择一部分进行展示，实现了个性化的产品推荐功能。涉及的技术包括JSP页面处理、Java后端逻辑以及SQL查询。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page isELIgnored="false" %>
<%@ page import="java.sql.*" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>

<div class="trychuan">
<div class="title">我可能感兴趣的</div>

     <%
      Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
                     String url="jdbc:oracle:thin:@192.168.1.50:1521:orcl";

                     Connection conn= DriverManager.getConnection(url,"test","test");

                     Statement stmt=conn.createStatement();

                    String countsql="select count(*)   from TBL_PRODUCTS";
                    ResultSet countRes =stmt.executeQuery(countsql);
                    countRes.next();
                    int count = countRes.getInt(1);
                    int r=(int)(Math.random()*(count/6));
                    //int r = 0;
                    System.out.println(r);
                   String sql= "select * from (select ROWNUM as rn,id,small_picture,category from TBL_PRODUCTS where category=1)where rn>"+r+" and rn<"+(r+7);

                   ResultSet rs=stmt.executeQuery(sql);

                      while(rs.next()) {%>

           <a href="viewProducts.action?id=<%=rs.getString("id")%>" target="_blank">


  <img οnerrοr="this.src='${pageContext.request.contextPath }/img/none.gif';" src="${pageContext.request.contextPath }<%=rs.getString("small_picture") %> "    height="100px" /></a>

<%}%>

<%
rs.close();
stmt.close();
conn.close();
%>