《Web应用技术》第二次作业

1、form表单值的获取

index2.jsp运行页面:

 index2_2.jsp运行页面：

 运行结果:

2、安装mysql数据库以及navicat

mysql,navicat安装成功截图:

3、mysql数据库及表的建立

创建数据库

创建数据表

4、maven项目的建立

运行代码：

package com.wust;

import java.sql.*;

public class JDBC {
    public static void main(String[] args) {

        try {
            Class.forName("com.mysql.cj.jdbc.Driver");

            Connection c = DriverManager
                    .getConnection(
                            "jdbc:mysql://127.0.0.1:3306/mydatadase?characterEncoding=UTF-8&useSSL=false",
                            "root", "123456");

            Statement s = c.createStatement();

            // 准备sql语句
            // 注意： 字符串要用单引号'
            String sql = "select * from category_";
            ResultSet rs =s.executeQuery(sql);

            while (rs.next()) {
                System.out.println( rs.getString(2));
            }

        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
}

运行结果：

5、使用jdbc进行数据库的增删改查操作。

对数据库mydatadase的category_增加一行数据category6:

代码如下：

package com.wust;

import java.sql.*;

public class JDBC2_add {
    public static void main(String[] args) {
        Connection c = null;
        PreparedStatement pstmt = null;
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");

            c = DriverManager.getConnection(
                    "jdbc:mysql://127.0.0.1:3306/mydatadase?characterEncoding=UTF-8&useSSL=false",
                    "root", "123456");

            Statement s = c.createStatement();
            // 准备SQL插入语句
            String sql = "INSERT INTO category_ (name) VALUES ('category6')";

            // 执行插入操作
             s.executeUpdate(sql);

            sql = "Select* from category_";
            ResultSet rs=s.executeQuery(sql);

            while (rs.next()) { System.out.print( rs.getString(1));
                System.out.print(" "); System.out.print(rs.getString(2));
                System.out.println(" ");
            }
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
           e.printStackTrace();
        }
    }
}

运行结果如下；

对数据库中的category_删除category3：

代码如下：

package com.wust;

import java.sql.*;

public class JDBC_delete {
    public static void main(String[] args) {
        Connection c = null;
        PreparedStatement pstmt = null;
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");

            c = DriverManager.getConnection(
                    "jdbc:mysql://127.0.0.1:3306/mydatadase?characterEncoding=UTF-8&useSSL=false",
                    "root", "123456");

            // 准备SQL删除语句
            String sql = "DELETE FROM category_ WHERE name = ?";

            // 使用PreparedStatement以防止SQL注入攻击
            pstmt = c.prepareStatement(sql);
            pstmt.setString(1, "category3"); // 设置占位符?的值

            // 执行删除操作
            int affectedRows = pstmt.executeUpdate();
            System.out.println("Rows deleted: " + affectedRows);

        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            // 关闭资源
            try {
                if (pstmt != null) pstmt.close();
                if (c != null) c.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

运行结果：