WEB.XML配置数据库

 

<?xml version="1.0" encoding="gb2312"?>

<web-app xmlns="http://java.sun.com/xml/ns/j2ee"

      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

      xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"

      version="2.4">

      <context-param>

             <param-name>driverClass</param-name>

             <param-value>com.mysql.jdbc.Driver</param-value>

      </context-param>

      <context-param>

             <param-name>url</param-name>

             <param-value>jdbc:mysql://localhost:3306/bookstore</param-value>

      </context-param>

      <context-param>

             <param-name>user</param-name>

             <param-value>root</param-value>

      </context-param>

      <context-param>

             <param-name>password</param-name>

             <param-value>12345678</param-value>

      </context-param>

      <servlet>

          <servlet-name>CreateDBServlet</servlet-name>

          <servlet-class>org.sunxin.lesson.jsp.bookstore.CreateDBServlet</servlet-class>

      </servlet>

    

      <servlet-mapping>

          <servlet-name>CreateDBServlet</servlet-name>

          <url-pattern>/createdb</url-pattern>

     </servlet-mapping>

 

public class CreateDBServlet extends HttpServlet { private String url; private String user; private String password; public void init() throws ServletException { String driverClass=getInitParameter("driverClass"); url=getInitParameter("url"); user=getInitParameter("user"); password=getInitParameter("password"); Class.forName(driverClass); } public void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException,IOException { Connection conn=null; Statement stmt=null; conn=DriverManager.getConnection(url,user,password); stmt=conn.createStatement(); } }