23.5.1总结

创建课程：

通过socket将对应的班级，课程名，邀请码加入到数据库中，添加成功将成功的信息返回给客户端，通过listview添加到页面中

    public static boolean add(String className, String courseName, String code) throws SQLException {
        Connection conn = null;
        PreparedStatement stmt = null;
        {
            try {
                System.out.println("班级：" + className + "正在添加" + courseName + "\n其邀请码为：" + code);
                conn = getConnection();
                String sql = "INSERT INTO course (class,couesr_name,code) VALUES ( ?, ?, ?, ?)";
                stmt = conn.prepareStatement(sql);
                stmt.setString(1, className);
                stmt.setString(2, courseName);
                stmt.setString(3, code);
                int resultCount = stmt.executeUpdate();
                return resultCount == 1;
            } catch (SQLException e) {
                e.printStackTrace();
                throw new SQLException("插入数据时发生 SQL 异常！", e);
            } finally {
                try {
                    if (stmt != null) {
                        stmt.close();
                    }
                    if (conn != null) {
                        conn.close();
                    }
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }

学生端：

通过判断是否与创建的课程一致，如果一致就返回给客户端表示可以添加，客户端再执行用listView打印出对应的课程

        public static boolean attendCourse(String className, String courseName,String code) {
            Connection conn = null;
            ResultSet rs = null;
            PreparedStatement stmt = null;

            try {
                conn = getConnection();
                String sql = "select * from account where class = ? and course_name = ? and code = ?;";
                stmt = conn.prepareStatement(sql);
                stmt.setString(1, className);
                stmt.setString(2, courseName);
                stmt.setString(3, code);

                rs = stmt.executeQuery();
                return rs.next();
            } catch (Exception e) {
                e.printStackTrace();
                e.getCause();
            } finally {
                try {
                    if (rs != null) rs.close();
                    if (stmt != null) stmt.close();
                    if (conn != null) conn.close();
                } catch (Exception e) {
                    e.getCause();
                }
            }
            return false;
        }
    }

 listview添加方法：