php sqlserver jdbc,JDBC连接SQLSERVER

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配置管理器->SQLServer网络配置->MSSQLSERVER的协议->TCP/IP启用,把TCP动态端口中的0都删掉，留空；然后把列表拉到最下边(IPALL)，配置一个固定端口，以后你连接数据库就用这个端口就可以了：如下图

本文原创发布php中文网，转载请注明出处，感谢您的尊重！