jsp投票系统源码

<%@ page import="java.sql.*" %>
<html>
<head>
    <title>投票系统</title>
</head>
<body>
    <h1>请选择你的选项</h1>
    <form action="vote.jsp" method="post">
        <input type="radio" name="vote" value="option1"> 选项1<br>
        <input type="radio" name="vote" value="option2"> 选项2<br>
        <input type="submit" value="投票">
    </form>

    <%
        String vote = request.getParameter("vote");
        if (vote != null) {
            Connection conn = null;
            PreparedStatement pstmt = null;
            try {
                Class.forName("com.mysql.jdbc.Driver");
                conn = DriverManager.getConnection("jdbc:mysql://localhost/votingdb", "username", "password");
                pstmt = conn.prepareStatement("UPDATE votes SET count = count + 1 WHERE option = ?");
                pstmt.setString(1, vote);
                pstmt.executeUpdate();
            } catch (Exception e) {
                e.printStackTrace();
            } finally {
                if (pstmt != null) pstmt.close();
                if (conn != null) conn.close();
            }
        }
    %>
</body>
</html>