使用ajax将Null插入数据库

let data = {
    name: document.getElementById('name').value,
    age: document.getElementById('age').value
};

$.ajax({
    url: 'your_server_endpoint',
    type: 'POST',
    data: JSON.stringify(data),
    contentType: 'application/json',
    success: function(response) {
        console.log('Data inserted successfully:', response);
    },
    error: function(xhr, status, error) {
        console.error('Error inserting data:', error);
    }
});

# 示例使用Python Flask框架
from flask import Flask, request, jsonify

app = Flask(__name__)

@app.route('/insert_data', methods=['POST'])
def insert_data():
    data = request.get_json()
    name = data.get('name')
    age = data.get('age')

    # 检查并处理Null值
    if name is None:
        name = 'Unknown'
    if age is None:
        age = 0

    # 插入数据库的逻辑
    # ...

    return jsonify({'status': 'success', 'message': 'Data inserted successfully'})

if __name__ == '__main__':
    app.run(debug=True)

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NULL,
    age INT NULL
);