这是java文件
public class CreateDBServlet extends HttpServlet {
private String url;
    private String user;
    private String password; public void init(){
String driverClass = getInitParameter("driverClass");
url = getInitParameter("url");
user = getInitParameter("user");
password = getInitParameter("password");
try {
Class.forName(driverClass);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}

public void doGet(HttpServletRequest req,HttpServletResponse resp){
Connection conn = null;
Statement stmt = null;

try {

conn = DriverManager.getConnection(url,user,password);
stmt = conn.createStatement();
//stmt.executeUpdate("use database netstore");
//stmt.executeUpdate("create table info");
/*PrintWriter out=resp.getWriter();
            out.println("success!");
            out.close();*/ } catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
            if(stmt!=null){
                try{
                    stmt.close();
                }catch(SQLException se){
                    se.printStackTrace();
                }
                stmt=null;
            }if(conn!=null){
                try{
                    conn.close();
                }catch(SQLException se){
                    se.printStackTrace();
                }
                conn=null;
            }
        }
    }}

解决方案 »

  1.   

    这是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">
        
        <servlet>
            <servlet-name>CreateDBServlet</servlet-name>
            <servlet-class>org.CreateDBServlet</servlet-class>
                    <init-param>
                     <param-name>driverClass</param-name>
                        <param-value>com.mysql.jdbc.Driver</param-value>
      </init-param>
                                <init-param>
                                        <param-name>url</param-name>
                                        <param-value>jdbc:mysql://localhost:3306/netstore</param-value>
                                </init-param>
                                <init-param>
                                        <param-name>user</param-name>
                                        <param-value>root</param-value>
                                </init-param>
                                <init-param>
                                        <param-name>password</param-name>
                                        <param-value>password</param-value>
                                </init-param>
        </servlet>
        
        <servlet-mapping>
            <servlet-name>CreateDBServlet</servlet-name>
            <url-pattern>/createdb</url-pattern>
        </servlet-mapping>
        
    </web-app>
    mysql运行正常,就是连不上,驱动我已经换了好几个了,mysql-connector-java-3.1.7-bin.jar,mysql-connector-java-3.1.13-bin.jar,mysql-connector-java-5.0.0-beta.jar我都试过了,还是不行,帮帮忙吧,郁闷了一天了