jsp显示数据库中的信息并进行一系列操作
- 代码如下:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ 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 style="background:url(image/2.jpg)">
<head>
<base href="<%=basePath%>">
<title>商品管理</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" href="css/app.css" type="text/css" >
</head>
<body>
<% request.setCharacterEncoding("UTF-8");
String Sid=request.getParameter("Sid");
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:53156;DatabaseName=Store","sa","sa");
String sql = "select * from shangpin";
PreparedStatement pstm=conn.prepareStatement(sql);
ResultSet rs=pstm.executeQuery(); %>
<H1 style="text-align: center;">这是商品管理页面</H1>
<table border="1px" width="450px" align=center>
<tr align=center><td colspan=3>提供商品如下</td></tr>
<tr align=center>
<td>商品编号</td>
<td>商品名称</td>
<td>商品价格</td>
</tr>
<%while(rs.next()){%>
<tr align=center>
<td><%=rs.getString("Sid")%></td>
<td><%=rs.getString("Sname")%></td>
<td><%=rs.getString("Sprice")%></td>
</tr>
<% }%></table>
<br>
<center>
<div>
<a href="http://localhost:8080/Store/test_insert.jsp">添加商品</a>
<a href="http://localhost:8080/Store/test_delete.jsp">删除商品</a>
<a href="http://localhost:8080/Store/test_modify.jsp">修改商品</a><br/>
<a href="http://localhost:8080/Store/store.jsp">返回管理页面</a>
</div>
</center>
<%
rs.close();
pstm.close();
conn.close();
%>
</body>
</html>
// An highlighted block
var foo = 'bar';
2.其页面效果如下:
3.分析:
- 数据库连接并进行select语句将数据库信息储存在结果集中。
<% request.setCharacterEncoding("UTF-8");
String Sid=request.getParameter("Sid");
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:53156;DatabaseName=Store","sa","sa");
String sql = "select * from shangpin";
PreparedStatement pstm=conn.prepareStatement(sql);
ResultSet rs=pstm.executeQuery(); %>
// An highlighted block
var foo = 'bar';
- rs.next()光标移到下一条数据,所以以下语句是将Sid,Sname,Sprice分别赋值在表格中Sid,Sname,Sprice列中。
<%while(rs.next()){%>
<tr align=center>
<td><%=rs.getString("Sid")%></td>
<td><%=rs.getString("Sname")%></td>
<td><%=rs.getString("Sprice")%></td>
</tr>
<% }%>
// An highlighted block
var foo = 'bar';
- 点击相应的操作字体进入不同的页面,如点击添加商品就会跳转到test_insert.jsp
<div>
<a href="http://localhost:8080/Store/test_insert.jsp">添加商品</a>
<a href="http://localhost:8080/Store/test_delete.jsp">删除商品</a>
<a href="http://localhost:8080/Store/test_modify.jsp">修改商品</a><br/>
<a href="http://localhost:8080/Store/store.jsp">返回管理页面</a>
</div
// An highlighted block
var foo = 'bar';
- 关闭数据库语句。
<%
rs.close();
pstm.close();
conn.close();
%>
// An highlighted block
var foo = 'bar';