JSP的ADO方式连SQLserver

 一：普通连接
<%

String sql=new String();
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); //加载驱动程序
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
Connection conn = DriverManager.getConnection(url,"sa","");  //连接数据库
if (conn == null)
{
 out.print("DriverManager.getConnection error.");
}
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);  //创建Statement
if (stmt == null)
{
 out.print("conn.createStatement error.");
}
sql="select * from ad_all";
ResultSet rs = stmt.executeQuery(sql);
/*while(rs.next())
{

 if(rs.getString("type").compareTo("1")==0)
 {
  out.print("<marquee behavior="+"alternate"+">"+rs.getString("content")+"</marquee>");
  
 }
 else
 {
  if(rs.getString("type").compareTo("0")==0)
  {
   out.print("<center>");
   out.print("<img src="+rs.getString("content")+"><p>");
   out.print("</center>");
  }
 }
}
*/
stmt.close();
conn.close();

%>
 二：struts连接池连接
<%

  <data-sources>
  <data-source key="sqlDB" type="org.apache.commons.dbcp.BasicDataSource">
   <set-property property="driverClassName" 
    value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
   <set-property property="url"
    value="jdbc:microsoft:sqlserver://localhost:1433;databaseName=sqlDB" />
   <set-property property="maxActive"
    value="5"/>
   <set-property property="username"
    value="sa"/>
   <set-property property="password"
    value=""/>
   <set-property property="autoCommit"
    value="true"/>
  </data-source>
 </data-sources>
%>