基于jsp的在线投稿课程

<form action="submitArticle.jsp" method="post">
    <label for="title">标题:</label>
    <input type="text" id="title" name="title" required><br>
    
    <label for="content">内容:</label>
    <textarea id="content" name="content" rows="10" cols="50" required></textarea><br>
    
    <input type="submit" value="提交">
</form>

<%@ page import="java.sql.*" %>
<%
    String title = request.getParameter("title");
    String content = request.getParameter("content");
    
    // 数据库连接信息
    String url = "jdbc:mysql://localhost:3306/mydb";
    String username = "root";
    String password = "password";
    
    try (Connection conn = DriverManager.getConnection(url, username, password)) {
        String sql = "INSERT INTO articles (title, content) VALUES (?, ?)";
        PreparedStatement pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, title);
        pstmt.setString(2, content);
        pstmt.executeUpdate();
        out.println("投稿成功！");
    } catch (SQLException e) {
        out.println("数据库错误：" + e.getMessage());
    }
%>