How to develop a simple online voting system using MySQL and Python

How to use MySQL and Python to develop a simple online voting system, specific code examples are needed

In recent years, with the popularity and development of the Internet, online voting has become a popular choice for people An important way to participate in decision-making and express your opinion. By using MySQL and Python to develop a simple online voting system, a large amount of voting data can be easily collected and counted. This article will introduce in detail how to implement a simple online voting system using MySQL and Python, while providing specific code examples.

First, we need to create a database to store voting-related data. Open the MySQL console or use visual tools to create a database named "voting_system":

CREATE DATABASE voting_system;

Next, create a table named "candidates" to store candidate information:

USE voting_system;

CREATE TABLE candidates (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    votes INT DEFAULT 0
);

The candidate table contains the candidate's ID, name and number of votes.

Now, we can use Python to connect to the database and write specific voting system code. First, we need to install the MySQL driver for Python. Execute the following command in the command line:

pip install mysql-connector-python

Next, create a Python file named "voting_system.py" and import the necessary libraries:

import mysql.connector
from mysql.connector import Error

Then, write the method to connect to the database Code:

def create_connection():
    conn = None;
    try:
        conn = mysql.connector.connect(
            host='localhost',
            database='voting_system',
            user='root',
            password='your_password'
        )
        if conn.is_connected():
            print('连接到数据库成功！')
            return conn
    except Error as e:
        print(e)

    return conn

In the above code, you need to replace "your_password" with your MySQL password.

Next, write the code to add the candidate:

def add_candidate(conn):
    name = input('请输入要添加的候选人姓名：')
    try:
        cursor = conn.cursor()
        cursor.execute('INSERT INTO candidates(name) VALUES(%s)', (name,))
        conn.commit()
        print('候选人添加成功！')
    except Error as e:
        print(e)

By running the above code, the candidate name can be entered in the console and added to the database.

Then, write the code to vote:

def vote(conn):
    candidate_id = input('请输入要投票的候选人ID：')
    try:
        cursor = conn.cursor()
        cursor.execute('SELECT votes FROM candidates WHERE id = %s', (candidate_id,))
        result = cursor.fetchone()
        if result:
            votes = result[0]
            votes += 1
            cursor.execute('UPDATE candidates SET votes = %s WHERE id = %s', (votes, candidate_id))
            conn.commit()
            print('投票成功！')
        else:
            print('候选人不存在！')
    except Error as e:
        print(e)

The above code will add one to the number of votes received by the candidate based on the entered candidate ID.

Finally, write a main function to implement the complete voting system by calling the above function:

def main():
    conn = create_connection()
    while True:
        print('1. 添加候选人')
        print('2. 进行投票')
        print('3. 退出')
        choice = input('请选择操作：')
        if choice == '1':
            add_candidate(conn)
        elif choice == '2':
            vote(conn)
        elif choice == '3':
            break
        else:
            print('无效的选择！')

    conn.close()

By running the above code, the user can choose to add candidates, vote or exit in the console system. All voting data will be saved in a MySQL database.

To sum up, we can use MySQL and Python to develop a simple online voting system. By using MySQL to store data and using Python to write relevant logic, we can easily implement the voting function. The code introduced above is only an example, and readers can expand and optimize it according to actual needs. I hope this article helps you when developing an online voting system!

The above is the detailed content of How to develop a simple online voting system using MySQL and Python. For more information, please follow other related articles on the PHP Chinese website!