JDBC对数据库进行简单操作

import javax.swing.*;
import java.sql.*;
import java.util.*;
import java.awt.*;

public class Swingtest{
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Class.forName("com.mysql.cj.jdbc.Driver");


        String url = "jdbc:mysql://localhost:3306/family";
        String user = "root";
        String pwd = "123456";
        Connection connection = DriverManager.getConnection(url, user, pwd);
        if(connection==null)
        {
            System.out.println("连接失败");
        }
        else
        {
            System.out.println("连接成功");
        }
        Statement statement = connection.createStatement();
        //String sql = "INSERT INTO family.课程表 VALUES('C6','Go',64,4)";   //增加
        //String sql = "DELETE FROM family.课程表 WHERE 课号 = 'C6'";     //删除
        String sql = "SELECT * FROM family.选课表 WHERE 学号 = 'S1'";    //查询
        String sql2 = "UPDATE family.学生表 SET 姓名 = '妲己' WHERE 学号 = 'S1'";
        ResultSet rs = statement.executeQuery(sql);
        while(rs.next())
        {
            System.out.println(rs.getString("课号"));
            System.out.println(rs.getInt("成绩"));
        }
        int result = statement.executeUpdate(sql2);
        if(result>0)
        {
            System.out.println("修改成功");
        }
        else
        {
            System.out.println("修改失败");
        }
        connection.close();
    }
}