⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 0163.htm

📁 JspServlet教程专栏 对javaservlet讲述的非常详细
💻 HTM
字号:
🔍 
<html>

<head>
<title>新时代软件教程:操作系统 主页制作 服务器 设计软件 网络技术 编程语言 文字编辑</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style>
<!--
body, table {font-size: 9pt; font-family: 宋体}
a {text-decoration:none}
a:hover {color: red;text-decoration:underline}
.1  {background-color: rgb(245,245,245)}
-->
</style>
</head>
<p align="center"><script src="../../1.js"></script></a>
<p align="center"><big><strong>查询sqlserver</strong></big></p>
<div align="right">---&nbsp;（文/easyinfonet）</div>

<br>&lt;html><br>
&lt;head><br>
&lt;title>jdbc&nbsp; test&lt;/title><br>
&lt;/head><br>
&lt;body><br>
&lt;%@&nbsp; page&nbsp; contentType="text/html;charset=gb2312"%><br>
&lt;%@&nbsp; page&nbsp; import&nbsp; =&nbsp; "java.net.URL"&nbsp; %><br>
&lt;%@&nbsp; page&nbsp; import&nbsp; =&nbsp; "java.sql.*"&nbsp; %><br>
&lt;%<br>
String&nbsp; url&nbsp; =&nbsp; "jdbc:odbc:admin";<br>
Class.forName&nbsp; ("sun.jdbc.odbc.JdbcOdbcDriver");&nbsp; //&nbsp; 加载&nbsp; jdbc-odbc&nbsp; 桥驱动程序<br>
//DriverManager.setLogStream(System.out);<br>
Connection&nbsp; con&nbsp; =&nbsp; DriverManager.getConnection&nbsp; (url,&nbsp; "sa",&nbsp; "super");&nbsp; //&nbsp; 试图与某一驱动程序连接。&nbsp; 每个已注册驱动程序都将被加载，直到找到一个可以处理此&nbsp; URL&nbsp; 的驱动程序<br>
DatabaseMetaData&nbsp; dma&nbsp; =&nbsp; con.getMetaData&nbsp; ();&nbsp; //&nbsp; 获得&nbsp; DatabaseMetaData&nbsp; 对象并显示一些有关连接的信息<br>
<br>
out.print("\nConnected&nbsp; to&nbsp; "&nbsp; +&nbsp; dma.getURL());<br>
System.out.println("Driver&nbsp; "&nbsp; +dma.getDriverName());<br>
System.out.println("Version&nbsp; "&nbsp; +dma.getDriverVersion());<br>
System.out.println("\n");<br>
<br>
Statement&nbsp; stmt&nbsp; =&nbsp; con.createStatement&nbsp; ();&nbsp; //&nbsp; 创建一个&nbsp; Statement&nbsp; 对象，使我们可以向驱动程序提交&nbsp; SQL&nbsp; 语句<br>
String&nbsp; query&nbsp; =&nbsp; "SELECT&nbsp; *&nbsp; FROM&nbsp; Information";<br>
ResultSet&nbsp; rs&nbsp; =&nbsp; stmt.executeQuery&nbsp; (query);&nbsp; //&nbsp; 提交查询，创建&nbsp; ResultSet&nbsp; 对象<br>
int&nbsp; i;<br>
ResultSetMetaData&nbsp; rsmd&nbsp; =&nbsp; rs.getMetaData&nbsp; ();&nbsp; //&nbsp; 获得&nbsp; ResultSetMetaData。它将用于列标题<br>
int&nbsp; numCols&nbsp; =&nbsp; rsmd.getColumnCount&nbsp; ();&nbsp; //&nbsp; 获得结果集中的列数<br>
for&nbsp; (i=1;&nbsp; i&lt;=numCols;&nbsp; i++)&nbsp; {&nbsp; //&nbsp; 显示列标题<br>
if&nbsp; (i&nbsp; >&nbsp; 1)&nbsp; out.print(",");<br>
out.print(rsmd.getColumnLabel(i));<br>
}<br>
out.println("\n");<br>
boolean&nbsp; more&nbsp; =&nbsp; rs.next&nbsp; ();&nbsp; //&nbsp; 显示数据并获取它，直到结果集末尾<br>
while&nbsp; (more)&nbsp; {<br>
//&nbsp; for&nbsp; (i=1;&nbsp; i&lt;=numCols;&nbsp; i++)&nbsp; {&nbsp; //&nbsp; 在每列中循环获得并显示列数据<br>
//&nbsp; if&nbsp; (i&nbsp; >&nbsp; 1)&nbsp; out.print(",");<br>
//&nbsp; out.print(rs.getString(i));<br>
//&nbsp; }<br>
//out.println(rs.getString("Comname"));<br>
System.out.println(rs.getString("Comname"));<br>
<br>
//System.out.print(rs.getString("Comtypename"));<br>
out.print("\n");<br>
more&nbsp; =&nbsp; rs.next&nbsp; ();&nbsp; //&nbsp; 获取结果集的下一行<br>
}<br>
rs.close();&nbsp; //&nbsp; 关闭结果集<br>
stmt.close();&nbsp; //&nbsp; 关闭语句<br>
con.close();&nbsp; //&nbsp; 关闭连接<br>
%><br>
<br>
&lt;/body><br>
&lt;/html>

  </table>
<p align="center"><script src="../../2.js"></script></a>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -