JSP中MySQL数据添加/修改/删除

最新推荐文章于 2022-01-11 11:56:33 发布

zc2274460

最新推荐文章于 2022-01-11 11:56:33 发布

阅读量1.2w

点赞数 5

分类专栏： jsp技术代码文章标签： mysql 数据 jsp

本文链接：https://blog.csdn.net/zc2274460/article/details/51819787

版权

jsp技术代码专栏收录该内容

4 篇文章 1 订阅

订阅专栏

添加

<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.SQLException"%>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>

<html>
<head>

<title>向数据库添加信息</title>

</head>

<body>
    <%
        String url="jdbc:mysql://localhost:3306/test";
        String user="root";
        String password="123456";
        Connection conn=null;
        try {
            Class.forName("com.mysql.jdbc.Driver");     //加载JDBC驱动
            out.println("加载驱动类成功");
            conn=DriverManager.getConnection(url,user,password);        //连接MySQL数据库
            out.println("连接MySQL成功");
        } catch (ClassNotFoundException e) {
            out.println("找不到驱动类");      //处理ClassNotFoundException异常
        }catch(SQLException e){
            out.println("连接MySQL失败");       //处理SQLException异常
        }

        try{
            //创建语句对象Statement
            Statement stmt=conn.createStatement();
            //添加一条用户信息
            String addUser="insert into user(id,username,password)values(null,'黄敏聪','123456')";
            //添加用户
            stmt.executeUpdate(addUser);
            out.println("添加用户信息成功");
        }catch(SQLException e){
            out.println("添加用户信息失败");
        }

    %>
</body>
</html>

修改

<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.SQLException"%>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>

<html>
<head>

<title>更新用户信息</title>

</head>

<body>
    <%
        String url="jdbc:mysql://localhost:3306/test";
        String user="root";
        String password="123456";
        Connection conn=null;
        try {
            Class.forName("com.mysql.jdbc.Driver");     //加载JDBC驱动
            out.println("加载驱动类成功");
            conn=DriverManager.getConnection(url,user,password);        //连接MySQL数据库
            out.println("连接MySQL成功");
        } catch (ClassNotFoundException e) {
            out.println("找不到驱动类");      //处理ClassNotFoundException异常
        }catch(SQLException e){
            out.println("连接MySQL失败");       //处理SQLException异常
        }

        try{

            Statement stmt=conn.createStatement();      //创建语句对象Statement
            //更新id为1的用户信息，更改密码为000000
            String updateUser="update user set password='000000' where id=1";
            stmt.executeUpdate(updateUser);     //执行更新
            out.println("修改用户信息成功");
        }catch(SQLException e){
            out.println("修改用户信息失败");        //处理SQLException异常
        }

    %>
</body>
</html>

删除

<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.SQLException"%>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>

<html>
<head>

<title>更新用户信息</title>

</head>

<body>
    <%
        String url="jdbc:mysql://localhost:3306/test";
        String user="root";
        String password="123456";
        Connection conn=null;
        try {
            Class.forName("com.mysql.jdbc.Driver");     //加载JDBC驱动
            out.println("加载驱动类成功");
            conn=DriverManager.getConnection(url,user,password);        //连接MySQL数据库
            out.println("连接MySQL成功");
        } catch (ClassNotFoundException e) {
            out.println("找不到驱动类");      //处理ClassNotFoundException异常
        }catch(SQLException e){
            out.println("连接MySQL失败");       //处理SQLException异常
        }

        try{

            Statement stmt=conn.createStatement();      //创建语句对象Statement
            //删除id为1的用户信息
            String deletUser="delete from user where id='2'";
            stmt.executeUpdate(deletUser);      //执行删除
            out.println("删除用户信息成功");
        }catch(SQLException e){
            out.println("删除用户信息失败");        //处理SQLException异常
        }

    %>
</body>
</html>