JDBC连接SQL 2008R2-CSDN博客

驱动是：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>