• 用SQL Server查询所有数据并显示


    利用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="500px;height:200px;text-align:center;margin: 0 auto;margin-top:0px">
          
              <div style="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>
  • 相关阅读:
    C++学习笔记1——const
    反转二叉树
    pywinauto 使用
    pywinauto 的使用
    爬虫基础知识
    mongdb安装配置
    pyinstaller
    Python3.6+pyinstaller+Django
    py2exe安装使用
    cx_freeze的安装使用
  • 原文地址:https://www.cnblogs.com/wlx520/p/4501654.html
Copyright © 2020-2023  润新知