关于java的开发文档

				
				
				
				新时代软件教程:操作系统 主页制作 服务器 设计软件 网络技术 编程语言 文字编辑
				
				
								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)}
				-->
				
				
				
				    不需ODBC可由IP地址与端口号建立与SQLSERVER的连接
				
				---摘自互联网
				
				
				package jsp;
				import java.sql.*; // JDBC package
				
				public class sql_data {
				
				String url = "jdbc:inetdae:192.168.2.70?sql7=true"; // use your hostname and port number here
				String login = "sa"; // use your login here
				String password =""; // use your password here
				public Connection connection = null;
				public Statement st = null;
				public ResultSet rs = null;
				
				public sql_data(){
				try {
				Class.forName("com.inet.tds.TdsDriver").newInstance(); 
				
				DriverManager.setLoginTimeout(10);
				
				// connection = DriverManager.getConnection(url,login,password);
				
				// DatabaseMetaData conMD = connection.getMetaData();
				
				// connection.setCatalog( "register");
				
				} catch(Exception e) {
				e.printStackTrace();
				}
				}
				
				public void sqlclose() {
				
				try { 
				
				st.close();
				
				connection.close();
				
				}catch(SQLException ex) { 
				System.err.println("sqlclose: " + ex.getMessage());
				}
				}
				public ResultSet executeQuery(String sql) { 
				
				try {
				
				
				connection = DriverManager.getConnection(url,login,password);
				
				connection.setCatalog( "register");
				
				st = connection.createStatement();
				
				rs = st.executeQuery(sql);
				
				} 
				catch(SQLException ex) { 
				System.err.println("aq.executeQuery: " + ex.getMessage());
				}
				return rs;
				}
				}