Vote打分界面完结

最新推荐文章于 2021-11-22 08:49:35 发布

伊斯塔战嘤

最新推荐文章于 2021-11-22 08:49:35 发布

阅读量854

点赞数

文章标签： mysql java 数据库

本文链接：https://blog.csdn.net/qq_45361493/article/details/107026213

版权

博客介绍了使用Java和MySQL数据库实现的Vote打分界面，包括Database的addMark更新、SqlServlet处理和Vote界面展示。系统能进行多用户打分求平均分，自动剔除0分并实时显示当前得分。这是作者首次记录编程过程，尽管略显粗糙，但已达到预期效果。

摘要由CSDN通过智能技术生成

首先是Database的addMark更新

public void addMark(int mark,String name,String uname) {
   
        Connection con = null;
        Statement sta;

        Connection con1 = null;
        Statement sta1;
        int count = 0;
        int n = 2;//这是我数据库目前只有两个用户
        Connection con2 = null;
        Statement sta2;

        ResultSet res = null;
        
        try {
   
            con = OpenConnection.getCon();
            con1 = OpenConnection.getCon();
            con2 = OpenConnection.getCon();
          
            String sql = "update user set "+name+" = "+mark+" where username = '"+uname+"'";
            String sql1 = "select "+name+" from user";
            sta = con.createStatement();
            sta.executeUpdate(sql);

            sta1 = con1.createStatement();
            res = sta1.executeQuery(sql1);
            while(res.next()){
   
                if(res.getInt(name)!=0)
                    count += res.getInt(name);
                else
                    n -= 1;
            }

            if(n==0)
                count = 0;
            else
                count = count/n;

            String sql2 = "update player set mark = "+count+" where name = '"+name+"'";


            sta2 = con2.createStatement();
            sta2.executeUpdate(sql2);

        } catch (SQLException e) {
   
            e.printStackTrace();
        }
    }

SqlServlet

package com.demo.service;

import com.demo.Database.Database;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;