java数据库连接通过XML

<%
       String driverClass=application.getInitParameter("Driver");
       String url=application.getInitParameter("url");
       String user=application.getInitParameter("username");
       String pwd=application.getInitParameter("password");
       Class.forName(driverClass).newInstance();
       Connection conn=DriverManager.getConnection(url,user,pwd);
       Statement stmt=conn.createStatement();
       ResultSet rs=stmt.executeQuery("select * from blog_info");
       while(rs.next())
       {
        out.print(rs.getString("title")+"<br/>");
       }
       conn.close();
    %>

　　

在WEB.xml中配置信息如下：

<context-param>
        <param-name>url</param-name>
        <param-value>jdbc:sqlserver://localhost:1433;databaseName=shdb</param-value>
  </context-param>
  <context-param>
       <param-name>Driver</param-name>
       <param-value>com.microsoft.sqlserver.jdbc.SQLServerDriver</param-value>
  </context-param>
  <context-param>
      <param-name>username</param-name>
      <param-value>du</param-value>
  </context-param>
  <context-param>
     <param-name>password</param-name>
     <param-value>123</param-value>
  </context-param>

　　

在web页面中读取配置信息可以通过Application的getInitParameter("Driver")进行读取

 

这样就可以轻松访问数据库了。

sqlserver 数据库驱动程序要放置在WEBContent/web-info/lib目录下要不会提示出错信息。