java web 连接数据库 http 错误 500总结

最新推荐文章于 2026-03-31 02:40:50 发布

原创最新推荐文章于 2026-03-31 02:40:50 发布 · 3.4k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#数据库 #java #web #servlet #encoding

其他专栏收录该内容

7 篇文章

订阅专栏

本文总结了在Java Web应用中遇到HTTP错误500，特别是与数据库连接相关的问题。错误根源在于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>
        <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/mysql</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>12345678</param-value>
		</init-param>
    </servlet>
    
    <servlet-mapping>
        <servlet-name>CreateDBServlet</servlet-name>
        <url-pattern>/createdb</url-pattern>
    </servlet-mapping>
    
    <servlet>
        <servlet-name>ListServlet</servlet-name>
        <servlet-class>org.sunxin.lesson.jsp.bookstore.ListServlet</servlet-class>
    </servlet>
    
    <servlet-mapping>
        <servlet-name>ListServlet</servlet-name>
        <url-pattern>/list</url-pattern>
    </servlet-mapping>
    
    <servlet>
        <servlet-name>CreateAccountServlet</servlet-name>
        <servlet-class>org.sunxin.lesson.jsp.bookstore.CreateAccountServlet</servlet-class>
    </servlet>
    
    <servlet-mapping>
        <servlet-name>CreateAccountServlet</servlet-name>
        <url-pattern>/account</url-pattern>
    </servlet-mapping>
    
    <servlet>
        <servlet-name>GetDBInfoServlet</servlet-name>
        <servlet-class>org.sunxin.lesson.jsp.bookstore.GetDBInfoServlet</servlet-class>
    </servlet>
    
    <servlet-mapping>
        <servlet-name>GetDBInfoServlet</servlet-name>
        <url-pattern>/getdbinfo</url-pattern>
    </servlet-mapping>
    
    <servlet>
        <servlet-name>TradeServlet</servlet-name>
        <servlet-class>org.sunxin.lesson.jsp.bookstore.TradeServlet</servlet-class>
    </servlet>
    
    <servlet-mapping>
        <servlet-name>TradeServlet</servlet-name>
        <url-pattern>/trade</url-pattern>
    </servlet-mapping>
    
    <servlet>
        <servlet-name>GetDBInfoServlet2</servlet-name>
        <servlet-class>org.sunxin.lesson.jsp.bookstore.GetDBInfoServlet2</servlet-class>
    </servlet>
    
    <servlet-mapping>
        <servlet-name>GetDBInfoServlet2</servlet-name>
        <url-pattern>/getdbinfo2</url-pattern>
    </servlet-mapping>

</web-app>

纠结了很长时间的错误，终于在一遍遍的尝试中成功了~

附上一总结贴，写得不错，点击打开链接

我的错误就是web.xml没有配置好，导致的，刚开始还纠结于环境的版本，后来发现跟版本没关系，现在承上web.xml