📄 noodbc.htm
字号:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv="KEYWORDS" content="小龙亭工作室之JSP实践之旅">
<title>小龙亭工作室之JSP实践之旅</title>
<link rel="stylesheet" href="../jsp.css" type="text/css">
</head>
<body topmargin="0" leftmargin="0" rightmargin="0">
<div align="center"><!--以下开始小龙亭标题 -->
<script language="javascript" src="../gaptitle.js"></script>
<!--以下开始主题索引td和文章区td -->
<div align="center"><center>
<table width="100%">
<tr>
<td colspan="2" height="10"></td>
</tr>
<tr>
<td width="20%" style="border-right: 1px solid red" valign="top" height="227"><script
language="javascript" src="manualindex.js"></script> </td>
<td width="80%" valign="top" height="227">
<p align="center"><font color="#FF00FF" size="2"><b>不需ODBC可由IP地址与端口号建立与SQLSERVER的连接 </b></font>
<p>
<p>转摘自 http://www.netqu.com <br>
<br>
<br>
package jsp;<br>
import java.sql.*; // JDBC package<br>
<br>
public class sql_data {<br>
<br>
String url = "jdbc:inetdae:192.168.2.70?sql7=true"; // use your hostname and port number here<br>
String login = "sa"; // use your login here<br>
String password =""; // use your password here<br>
public Connection connection = null;<br>
public Statement st = null;<br>
public ResultSet rs = null;<br>
<br>
public sql_data(){<br>
try {<br>
Class.forName("com.inet.tds.TdsDriver").newInstance(); <br>
<br>
DriverManager.setLoginTimeout(10);<br>
<br>
// connection = DriverManager.getConnection(url,login,password);<br>
<br>
// DatabaseMetaData conMD = connection.getMetaData();<br>
<br>
// connection.setCatalog( "register");<br>
<br>
} catch(Exception e) {<br>
e.printStackTrace();<br>
}<br>
}<br>
<br>
public void sqlclose() {<br>
<br>
try { <br>
<br>
st.close();<br>
<br>
connection.close();<br>
<br>
}catch(SQLException ex) { <br>
System.err.println("sqlclose: " + ex.getMessage());<br>
}<br>
}<br>
public ResultSet executeQuery(String sql) { <br>
<br>
try {<br>
<br>
<br>
connection = DriverManager.getConnection(url,login,password);<br>
<br>
connection.setCatalog( "register");<br>
<br>
st = connection.createStatement();<br>
<br>
rs = st.executeQuery(sql);<br>
<br>
} <br>
catch(SQLException ex) { <br>
System.err.println("aq.executeQuery: " + ex.getMessage());<br>
}<br>
return rs;<br>
}<br>
} <br>
<br>
</td>
</tr>
<!-- 以下是底边-->
<script language="javascript" src="../gapbottom.js"></script>
</center>
</body>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -