例子1：建立连接数据库及查询（JSP)

最新推荐文章于 2023-03-31 15:55:11 发布

HaanLen

最新推荐文章于 2023-03-31 15:55:11 发布

阅读量304

点赞数

分类专栏： JSP

JSP 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

index.jsp

<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ page import="java.sql.*" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'index.jsp' starting page</title>
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
  </head>
  
  <body>
    <% 
    Connection con;
    Statement sql;
    ResultSet rs;
    try{
    Class.forName("com.mysql.jdbc.Driver");
    }
    catch(Exception e){}
    try{
    String uri="jdbc:mysql://127.0.0.1/warehouse?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true";
    String user="root";
    String password="";
    con=DriverManager.getConnection(uri,user,password);
    sql=con.createStatement();
    rs=sql.executeQuery("select * from product");
    out.print("<table border=2>");
    
    out.print("<tr>");
    out.print("<th width=100>"+"产品号");
    out.print("<th width=100>"+"名称");
     out.print("<th width=200>"+"生产日期");
      out.print("<th width=100>"+"价格");
      out.print("</tr>");
      while(rs.next()){
      out.print("<tr>");
      out.print("<td>"+rs.getString(1)+"</td>");
      out.print("<td>"+rs.getString(2)+"</td>");
      out.print("<td>"+rs.getDate("madeTime")+"</td>");
      out.print("<td>"+rs.getFloat("price")+"</td>");
      out.print("</tr>");
      }
    out.print("</table>");
    con.close();
    }
    catch(SQLException e){out.print(e);}
     %>
  </body>
</html>

效果显示
在这里插入图片描述
说明：利用myeclipse工具编写
（1）需要将jdbc复制到WEB-INF下的lib目录中及jdk/jre/lib/ext目录中
（2）前提下载安装mysql及建立warehouse数据库

HaanLen

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
例子1：建立连接数据库及查询（JSP)

index.jsp<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%><%@ page import="java.sql.*" %><%String path = request.getContextPath();String basePath = request.getS...
复制链接

扫一扫

专栏目录