package xhs; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class MyStringClass { /** * @param args */ public static void main(String[] args) { // TODO 自动生成的方法package xhs;import java.sql.connection;import java.sql.drivermanager;import java.sql.resultset;import java.sql.statement;public class mystringclass {/*** @param args*/ public static void main(String[] args) {// TODO 自动生成的方法存根String connectionUrl = "jdbc:sqlserver://localhost:1433;"+ "databaseName=AdventureWorks;integratedSecurity=true;";String url = "jdbc:sqlserver://127.0.0.1:1433;databaseName=QQhrlgzysyWeb;user=sa;password=123";//sa身份连接//String url2 = "jdbc:sqlserver://127.0.0.1:1368;databaseName=mydbdemo;integratedSecurity=true;";//windows集成模式连接// Declare the JDBC objects.
Connection con = null;Statement stmt = null;ResultSet rs = null;try {// Establish the connection.
System.out.println("begin.");Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");con = DriverManager.getConnection(url);System.out.println("end.");// Create and execute an SQL statement that returns some data.
String SQL = "SELECT TOP 10 * FROM NewsInfo";stmt = con.createStatement();rs = stmt.executeQuery(SQL);// Iterate through the data in the result set and display it.
while (rs.next()) {System.out.println(rs.getString(4) + " " + rs.getString(6));}}// Handle any errors that may have occurred.
catch (Exception e) {e.printStackTrace();}finally {if (rs != null) try {rs.close();} catch (Exception e) {}if (stmt != null) try {stmt.close();} catch (Exception e) {}if (con != null) try {con.close();} catch (Exception e) {}}}}sa身份验证模式sqlserver2008用的是动态端口，需要你配置一下：SQLServer 数据库批量查找替换工具1.2 SQL木马清除助手SQLServer 数据库批量查找替换工具1.2 SQL木马清除助手下载打开配置工具->SQLServer配置管理器->SQLServer网络配置->MSSQLSERVER的协议->TCP/IP启用,把TCP动态端口中的0都删掉，留空；然后把列表拉到最下边(IPALL)，配置一个固定端口，以后你连接数据库就用这个端口就可以了：如下图