??SQL Server???????????????
???????????? ???????[ 2015/5/18 13:35:30 ] ?????????????
????????SQL Server???????????????????????????????
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@page import="jdbc.sqlServer"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.ResultSet"%>
<%
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 'LinDao.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>
<!-- ??????????? -->
<div>
<table border=1px style="width:500px;height:200px;text-align:center;margin: 0 auto;margin-top:0px">
<div style="width:500px;height:40px;border:1px solid red;margin:0 auto;text-align:center;margin-top:60px;background:#fff;margin-top:-2px">
<font color="red" font-weight="bold">????????</font>
</div>
<tr style="background:red">
<td>???</td>
<td>????</td>
<td>?????</td>
<td>???</td>
</tr>
<%
//?????????????????
sqlServer sq1=new sqlServer();
//????????????
Connection con1 = sq1.getConnection();
//??дsql???
String sql1="select * from Admin";
//??????????????
Statement st1=con1.createStatement();
// ??????????
ResultSet rs1 = st1.executeQuery(sql1);
while(rs1.next()){
%> <tr>
<td> <%out.print(rs1.getInt(1) + " "); %></td>
<td> <%out.print(rs1.getString(2) + " "); %></td>
<td> <%out.println(rs1.getInt(3)+ " "); %></td>
<td> <a href="time.jsp?id=<%out.print(rs1.getInt(1) + " "); %>">???</a></td>
</tr><%
}
//??????
sq1.ShiFang(rs1??st1??con1);
%>
</table>
</div>
</body>
</html>
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11