JDBC连接SQL 2008R2
2012-03-04 23:08 cai-yigo 阅读(744) 评论(0) 编辑 收藏 举报驱动是：Microsoft SQL Server JDBC Driver 3.0
1.把sqljdbc4.jar放在WEB-INF/lib下
2.下面是测试代码：
<%@ page language="java" contentType="text/html; charset=GB2312"
import="java.util.*"%>
<%@ page import="java.text.*"%><%@ page import="java.sql.*"%>
<%--
<%@ taglib uri="/struts-tags" prefix="s"%>
--%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>set your title</title>
<!--
<link rel="stylesheet" type="text/css" href="CSS.css" />
<script language="JavaScript" type="text/javascript" src="jquery.js"></script>
-->
<script language="JavaScript" type="text/javascript"
src="Macrotea-CommonHelper.js"></script>
<style type="text/css">
</style>
<script type="text/javascript">
</script>
</head>
<body>
<%
String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url = "jdbc:sqlserver://localhost:1433;user=sa;password=123456";
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(url);
if (conn != null && !conn.isClosed()) {
out.println("数据库连接测试成功！");
conn.close();
}
} catch (ClassNotFoundException e) {
out.println("找不到驱动程序！");
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
%>
</body>
</html>
3.该代码没有采用windows集成身份验证。2008R2的TCP默认开启的，端口是1433
