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)，配置一个固定端口，以后你连接数据库就用这个端口就可以了：如下图