音乐管理系统（二）

最新推荐文章于 2024-07-13 13:55:40 发布

子飯七晚

最新推荐文章于 2024-07-13 13:55:40 发布

阅读量285

点赞数

文章标签： java

本文链接：https://blog.csdn.net/Rei_Kotori/article/details/102464790

版权

需要在web实现之前的的代码，连接起来：

LoginServlet
com.zhongruan.servlet.LoginServlet

LoginServlet
/login

<servlet>
    <servlet-name>DeleteServlet</servlet-name>
    <servlet-class>com.zhongruan.servlet.DeleteServlet</servlet-class>
</servlet>
<servlet-mapping>
    <servlet-name>DeleteServlet</servlet-name>
    <url-pattern>/delete</url-pattern>
</servlet-mapping>

<servlet>
    <servlet-name>AddServlet</servlet-name>
    <servlet-class>com.zhongruan.servlet.AddServlet</servlet-class>
</servlet>
<servlet-mapping>
    <servlet-name>AddServlet</servlet-name>
    <url-pattern>/add</url-pattern>
</servlet-mapping>

<servlet>
    <servlet-name>ToUpdateServlet</servlet-name>
    <servlet-class>com.zhongruan.servlet.ToUpdateServlet</servlet-class>
</servlet>
<servlet-mapping>
    <servlet-name>ToUpdateServlet</servlet-name>
    <url-pattern>/toUpdate</url-pattern>
</servlet-mapping>
<servlet>
    <servlet-name>UpdateServlet</servlet-name>
    <servlet-class>com.zhongruan.servlet.UpDateServlet</servlet-class>
</servlet>
<servlet-mapping>
    <servlet-name>UpdateServlet</servlet-name>
    <url-pattern>/update</url-pattern>
</servlet-mapping>


<servlet>
    <servlet-name>FindPage</servlet-name>
    <servlet-class>com.zhongruan.servlet.FindByPageServlet</servlet-class>
</servlet>
<servlet-mapping>
    <servlet-name>FindPage</servlet-name>
    <url-pattern>/findByPage</url-pattern>
</servlet-mapping>

之后要DBUil中连接数据库

public class DBUtil {
public static Connection getConnection() throws ClassNotFoundException, SQLException {
Class.forName(“com.mysql.jdbc.Driver”);
Connection connection = DriverManager.getConnection(“jdbc:mysql://127.0.0.1:3306/zjgm?characterEncoding=utf-8&user=root&password=123456”);

    return connection;
}

public static void closeAll(ResultSet resultSet, Statement statement,Connection connection){
    if(resultSet!=null){
        try {
            resultSet.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    if(statement!=null){
        try {
            statement.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    if(connection!=null){
        try {
            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

}