漂亮的管理员界面显示用户信息,并且提供相应的查找和管理功能的html界面,并且和flask框架实现分页功能
时间: 2024-06-05 14:11:11 浏览: 140
要实现这样的管理员界面,你可以使用HTML和Flask框架相结合的方式。以下是一个简要的实现步骤:
1. 创建一个HTML文件,用于显示用户信息和提供相应的查找和管理功能。可以使用Bootstrap等前端框架来美化界面。
2. 在Flask框架中创建一个路由,用于响应管理员界面的请求。
3. 在路由函数中,使用Flask的模板渲染功能将HTML文件渲染出来,并将需要的用户信息传递给HTML文件。
4. 在HTML文件中,使用JavaScript等前端技术实现分页功能,可以使用jQuery等库来简化开发。
在实现过程中,你需要对Flask框架和HTML、JavaScript等前端技术有一定的了解。同时,你需要从后端到前端,从数据库到界面设计,多方面考虑,才能实现一个完整的管理员界面。
相关问题
漂亮的管理员界面显示用户信息,并且提供相应的查找和管理功能的html界面,并且和flask框架实现分页功能,详细代码
以下是一个基于 Flask 框架和 Bootstrap 的管理员界面示例,包括用户信息的显示、查找和管理功能以及分页功能。代码如下:
```python
from flask import Flask, render_template, request
from flask_sqlalchemy import SQLAlchemy
from sqlalchemy import func
from math import ceil
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///users.db'
db = SQLAlchemy(app)
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(50), nullable=False)
email = db.Column(db.String(50), nullable=False)
age = db.Column(db.Integer, nullable=False)
@app.route('/', methods=['GET', 'POST'])
def index():
page = request.args.get('page', 1, type=int)
name = request.args.get('name', '')
email = request.args.get('email', '')
age = request.args.get('age', '')
query = User.query.filter(User.name.like(f'%{name}%'), User.email.like(f'%{email}%'), User.age.like(f'%{age}%'))
total_count = query.count()
page_size = 5
total_page = ceil(total_count / page_size)
pagination = query.paginate(page=page, per_page=page_size)
users = pagination.items
return render_template('index.html', users=users, pagination=pagination, total_page=total_page, name=name, email=email, age=age)
@app.route('/add_user', methods=['POST'])
def add_user():
name = request.form.get('name')
email = request.form.get('email')
age = request.form.get('age')
user = User(name=name, email=email, age=age)
db.session.add(user)
db.session.commit()
return 'success'
@app.route('/delete_user', methods=['POST'])
def delete_user():
user_id = request.form.get('user_id')
user = User.query.filter_by(id=user_id).first()
db.session.delete(user)
db.session.commit()
return 'success'
if __name__ == '__main__':
app.run()
```
在 templates 目录下创建一个名为 `index.html` 的模板文件,代码如下:
```html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Admin</title>
<link rel="stylesheet" href="https://cdn.bootcss.com/bootstrap/4.1.0/css/bootstrap.min.css">
</head>
<body>
<nav class="navbar navbar-expand-lg navbar-light bg-light">
<div class="collapse navbar-collapse" id="navbarNav">
<ul class="navbar-nav">
<li class="nav-item">
<a class="nav-link" href="/">Home</a>
</li>
</ul>
</div>
</nav>
<div class="container mt-3">
<h1>Admin</h1>
<div class="row">
<div class="col-md-4">
<form>
<div class="form-group">
<label>Name</label>
<input type="text" class="form-control" name="name" value="{{ name }}">
</div>
<div class="form-group">
<label>Email</label>
<input type="text" class="form-control" name="email" value="{{ email }}">
</div>
<div class="form-group">
<label>Age</label>
<input type="text" class="form-control" name="age" value="{{ age }}">
</div>
<button type="submit" class="btn btn-primary">Search</button>
</form>
</div>
<div class="col-md-8">
<table class="table table-striped">
<thead>
<tr>
<th>ID</th>
<th>Name</th>
<th>Email</th>
<th>Age</th>
<th>Action</th>
</tr>
</thead>
<tbody>
{% for user in users %}
<tr>
<td>{{ user.id }}</td>
<td>{{ user.name }}</td>
<td>{{ user.email }}</td>
<td>{{ user.age }}</td>
<td>
<form class="delete-form">
<input type="hidden" name="user_id" value="{{ user.id }}">
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
{% endfor %}
</tbody>
</table>
<nav>
<ul class="pagination">
<li class="page-item{% if pagination.page == 1 %} disabled{% endif %}">
<a class="page-link" href="{{ url_for('index', page=1, name=name, email=email, age=age) }}">First</a>
</li>
{% if pagination.has_prev %}
<li class="page-item">
<a class="page-link" href="{{ url_for('index', page=pagination.prev_num, name=name, email=email, age=age) }}">Previous</a>
</li>
{% endif %}
{% for num in pagination.iter_pages(left_edge=1, left_current=1, right_current=2, right_edge=1) %}
{% if num %}
<li class="page-item{% if pagination.page == num %} active{% endif %}">
<a class="page-link" href="{{ url_for('index', page=num, name=name, email=email, age=age) }}">{{ num }}</a>
</li>
{% else %}
<li class="page-item disabled"><a class="page-link" href="#">…</a></li>
{% endif %}
{% endfor %}
{% if pagination.has_next %}
<li class="page-item">
<a class="page-link" href="{{ url_for('index', page=pagination.next_num, name=name, email=email, age=age) }}">Next</a>
</li>
{% endif %}
<li class="page-item{% if pagination.page == pagination.pages %} disabled{% endif %}">
<a class="page-link" href="{{ url_for('index', page=pagination.pages, name=name, email=email, age=age) }}">Last</a>
</li>
</ul>
</nav>
</div>
</div>
</div>
<script src="https://cdn.bootcss.com/jquery/3.3.1/jquery.min.js"></script>
<script src="https://cdn.bootcss.com/bootstrap/4.1.0/js/bootstrap.min.js"></script>
<script>
$('.delete-form').submit(function(e) {
e.preventDefault();
var form = $(this);
$.ajax({
url: '/delete_user',
type: 'POST',
data: form.serialize(),
success: function(response) {
if (response === 'success') {
form.closest('tr').remove();
}
}
});
});
</script>
</body>
</html>
```
在 static 目录下创建一个名为 `script.js` 的 JavaScript 文件,代码如下:
```javascript
$(function() {
$('form').submit(function(e) {
e.preventDefault();
var form = $(this);
$.ajax({
url: '/add_user',
type: 'POST',
data: form.serialize(),
success: function(response) {
if (response === 'success') {
alert('User added successfully!');
form.trigger('reset');
}
}
});
});
});
```
在 static 目录下创建一个名为 `style.css` 的 CSS 文件,代码如下:
```css
body {
padding-top: 70px;
}
.btn-danger {
margin-right: 5px;
}
```
这个例子中使用 SQLite 数据库存储用户信息。你可以根据需要修改数据库连接字符串。此外,还需要在终端中安装以下依赖项:
```bash
pip install Flask Flask-SQLAlchemy
```
最后,在终端中运行以下命令启动应用程序:
```bash
export FLASK_APP=app.py
export FLASK_ENV=development
flask run
```
打开浏览器并访问 `http://localhost:5000`,即可看到管理员界面。
漂亮的管理员界面显示用户信息,并且提供相应的查找和管理功能的html界面,并且和flask框架实现分页功能。前后端代码
前端代码(使用Bootstrap框架):
```html
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="description" content="">
<meta name="author" content="">
<title>User Management</title>
<!-- Bootstrap core CSS -->
<link href="https://cdn.bootcss.com/bootstrap/4.1.1/css/bootstrap.min.css" rel="stylesheet" />
</head>
<body>
<div class="container-fluid">
<h1 class="text-center my-5">User Management</h1>
<div class="row">
<div class="col-md-6">
<form class="form-inline mb-4">
<input type="text" class="form-control mr-2" placeholder="Search">
<button type="submit" class="btn btn-primary">Search</button>
</form>
</div>
<div class="col-md-6 text-right">
<button type="button" class="btn btn-success" data-toggle="modal" data-target="#add-user-modal">Add User</button>
</div>
</div>
<table class="table table-striped">
<thead>
<tr>
<th>ID</th>
<th>Name</th>
<th>Email</th>
<th>Phone</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
{% for user in users %}
<tr>
<td>{{ user.id }}</td>
<td>{{ user.name }}</td>
<td>{{ user.email }}</td>
<td>{{ user.phone }}</td>
<td>
<button type="button" class="btn btn-primary" data-toggle="modal" data-target="#edit-user-modal" data-id="{{ user.id }}" data-name="{{ user.name }}" data-email="{{ user.email }}" data-phone="{{ user.phone }}">Edit</button>
<button type="button" class="btn btn-danger" data-toggle="modal" data-target="#delete-user-modal" data-id="{{ user.id }}">Delete</button>
</td>
</tr>
{% endfor %}
</tbody>
</table>
<nav aria-label="Page navigation">
<ul class="pagination justify-content-center">
{% if page > 1 %}
<li class="page-item"><a class="page-link" href="?page={{ page-1 }}">Previous</a></li>
{% endif %}
{% for i in range(max_page) %}
{% if i+1 == page %}
<li class="page-item active"><a class="page-link" href="?page={{ i+1 }}">{{ i+1 }}</a></li>
{% else %}
<li class="page-item"><a class="page-link" href="?page={{ i+1 }}">{{ i+1 }}</a></li>
{% endif %}
{% endfor %}
{% if page < max_page %}
<li class="page-item"><a class="page-link" href="?page={{ page+1 }}">Next</a></li>
{% endif %}
</ul>
</nav>
</div>
<!-- Add user modal -->
<div class="modal fade" id="add-user-modal" tabindex="-1" role="dialog" aria-labelledby="add-user-modal-label" aria-hidden="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<form action="{{ url_for('add_user') }}" method="post">
<div class="modal-header">
<h5 class="modal-title" id="add-user-modal-label">Add User</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<div class="form-group">
<label>Name</label>
<input type="text" class="form-control" name="name" required>
</div>
<div class="form-group">
<label>Email</label>
<input type="email" class="form-control" name="email" required>
</div>
<div class="form-group">
<label>Phone</label>
<input type="tel" class="form-control" name="phone" required>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>
<button type="submit" class="btn btn-primary">Add</button>
</div>
</form>
</div>
</div>
</div>
<!-- Edit user modal -->
<div class="modal fade" id="edit-user-modal" tabindex="-1" role="dialog" aria-labelledby="edit-user-modal-label" aria-hidden="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<form action="{{ url_for('edit_user') }}" method="post">
<div class="modal-header">
<h5 class="modal-title" id="edit-user-modal-label">Edit User</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<div class="form-group">
<label>Name</label>
<input type="text" class="form-control" name="name" required>
</div>
<div class="form-group">
<label>Email</label>
<input type="email" class="form-control" name="email" required>
</div>
<div class="form-group">
<label>Phone</label>
<input type="tel" class="form-control" name="phone" required>
</div>
<input type="hidden" name="id">
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>
<button type="submit" class="btn btn-primary">Save</button>
</div>
</form>
</div>
</div>
</div>
<!-- Delete user modal -->
<div class="modal fade" id="delete-user-modal" tabindex="-1" role="dialog" aria-labelledby="delete-user-modal-label" aria-hidden="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<form action="{{ url_for('delete_user') }}" method="post">
<div class="modal-header">
<h5 class="modal-title" id="delete-user-modal-label">Delete User</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
Are you sure you want to delete this user?
<input type="hidden" name="id">
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>
<button type="submit" class="btn btn-danger">Delete</button>
</div>
</form>
</div>
</div>
</div>
<!-- Bootstrap core JavaScript -->
<script src="https://cdn.bootcss.com/jquery/3.3.1/jquery.min.js"></script>
<script src="https://cdn.bootcss.com/popper.js/1.14.3/umd/popper.min.js"></script>
<script src="https://cdn.bootcss.com/bootstrap/4.1.1/js/bootstrap.min.js"></script>
<script>
$('#edit-user-modal').on('show.bs.modal', function (event) {
var button = $(event.relatedTarget)
var id = button.data('id')
var name = button.data('name')
var email = button.data('email')
var phone = button.data('phone')
var modal = $(this)
modal.find('input[name="id"]').val(id)
modal.find('input[name="name"]').val(name)
modal.find('input[name="email"]').val(email)
modal.find('input[name="phone"]').val(phone)
})
$('#delete-user-modal').on('show.bs.modal', function (event) {
var button = $(event.relatedTarget)
var id = button.data('id')
var modal = $(this)
modal.find('input[name="id"]').val(id)
})
</script>
</body>
</html>
```
后端代码(使用Flask框架):
```python
from flask import Flask, render_template, request, redirect, url_for
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///users.db'
db = SQLAlchemy(app)
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(50), nullable=False)
email = db.Column(db.String(120), nullable=False, unique=True)
phone = db.Column(db.String(20), nullable=False)
@app.route('/')
def index():
page = int(request.args.get('page', 1))
per_page = 10
users = User.query.order_by(User.id).paginate(page, per_page=per_page)
max_page = users.pages
return render_template('index.html', users=users.items, page=page, max_page=max_page)
@app.route('/add_user', methods=['POST'])
def add_user():
name = request.form['name']
email = request.form['email']
phone = request.form['phone']
user = User(name=name, email=email, phone=phone)
db.session.add(user)
db.session.commit()
return redirect(url_for('index'))
@app.route('/edit_user', methods=['POST'])
def edit_user():
id = request.form['id']
name = request.form['name']
email = request.form['email']
phone = request.form['phone']
user = User.query.get(id)
user.name = name
user.email = email
user.phone = phone
db.session.commit()
return redirect(url_for('index'))
@app.route('/delete_user', methods=['POST'])
def delete_user():
id = request.form['id']
user = User.query.get(id)
db.session.delete(user)
db.session.commit()
return redirect(url_for('index'))
if __name__ == '__main__':
app.run(debug=True)
```