📄 0220.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>不需ODBC可由IP地址与端口号建立与SQLSERVER的连接</strong></big></p>
<div align="right">---摘自互联网</div>

<br>package&nbsp; jsp;<br>
import&nbsp; java.sql.*;&nbsp; //&nbsp; JDBC&nbsp; package<br>
<br>
public&nbsp; class&nbsp; sql_data&nbsp; {<br>
<br>
String&nbsp; url&nbsp; =&nbsp; "jdbc:inetdae:192.168.2.70?sql7=true";&nbsp; //&nbsp; use&nbsp; your&nbsp; hostname&nbsp; and&nbsp; port&nbsp; number&nbsp; here<br>
String&nbsp; login&nbsp; =&nbsp; "sa";&nbsp; //&nbsp; use&nbsp; your&nbsp; login&nbsp; here<br>
String&nbsp; password&nbsp; ="";&nbsp; //&nbsp; use&nbsp; your&nbsp; password&nbsp; here<br>
public&nbsp; Connection&nbsp; connection&nbsp; =&nbsp; null;<br>
public&nbsp; Statement&nbsp; st&nbsp; =&nbsp; null;<br>
public&nbsp; ResultSet&nbsp; rs&nbsp; =&nbsp; null;<br>
<br>
public&nbsp; sql_data(){<br>
try&nbsp; {<br>
Class.forName("com.inet.tds.TdsDriver").newInstance();&nbsp; <br>
<br>
DriverManager.setLoginTimeout(10);<br>
<br>
//&nbsp; connection&nbsp; =&nbsp; DriverManager.getConnection(url,login,password);<br>
<br>
//&nbsp; DatabaseMetaData&nbsp; conMD&nbsp; =&nbsp; connection.getMetaData();<br>
<br>
//&nbsp; connection.setCatalog(&nbsp; "register");<br>
<br>
}&nbsp; catch(Exception&nbsp; e)&nbsp; {<br>
e.printStackTrace();<br>
}<br>
}<br>
<br>
public&nbsp; void&nbsp; sqlclose()&nbsp; {<br>
<br>
try&nbsp; {&nbsp; <br>
<br>
st.close();<br>
<br>
connection.close();<br>
<br>
}catch(SQLException&nbsp; ex)&nbsp; {&nbsp; <br>
System.err.println("sqlclose:&nbsp; "&nbsp; +&nbsp; ex.getMessage());<br>
}<br>
}<br>
public&nbsp; ResultSet&nbsp; executeQuery(String&nbsp; sql)&nbsp; {&nbsp; <br>
<br>
try&nbsp; {<br>
<br>
<br>
connection&nbsp; =&nbsp; DriverManager.getConnection(url,login,password);<br>
<br>
connection.setCatalog(&nbsp; "register");<br>
<br>
st&nbsp; =&nbsp; connection.createStatement();<br>
<br>
rs&nbsp; =&nbsp; st.executeQuery(sql);<br>
<br>
}&nbsp; <br>
catch(SQLException&nbsp; ex)&nbsp; {&nbsp; <br>
System.err.println("aq.executeQuery:&nbsp; "&nbsp; +&nbsp; ex.getMessage());<br>
}<br>
return&nbsp; rs;<br>
}<br>
}

  </table>
<p align="center"><script src="../../2.js"></script></a>
</body>
</html>
⌨️ 快捷键说明

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