11月26日

任务三：

因为JFinal主要的功能作用还是体现在网站的后端搭建上以及对数据库的CRUD操作上面，所以因为个人编写web网页的习惯，选择了vue+element-ui+JFinal+mysql的技术架构去完成这个任务。

首先一个简单的学生信息管理系统，我们主要涉及到两个表，一个是登录表，一个是学生信息表，所以在JFinal架构中创建Model文件夹创建两个java文件，分别是login和student对应mysql中的login和student表（mysql建表这块这里不再详细赘述）。

代码如下：

package models;

import com.jfinal.plugin.activerecord.Model;

public class login extends Model<login> {
    public static final login dao = new login().dao();
    public login getUserById(String username) {
        return login.dao.findFirst("select * from login where username = ?", username);
    }
    public String getPassword(login login)
    {
        return login.getStr("password");
    }
}

package models;

import com.jfinal.plugin.activerecord.Model;
import com.jfinal.plugin.activerecord.Page;

public class student extends Model<student> {
    public static final student dao = new student().dao();
    public Page<student> paginate(int pageNumber, int pageSize) {
        return super.paginate(pageNumber, pageSize, "select *", "from student");
    }
}

然后在DemoConfig中完成JFinal所需要的一些基本约定配置。代码如下：

package config;

import com.jfinal.aop.Interceptor;
import com.jfinal.aop.Invocation;
import com.jfinal.config.Constants;
import com.jfinal.config.Handlers;
import com.jfinal.config.Interceptors;
import com.jfinal.config.JFinalConfig;
import com.jfinal.config.Plugins;
import com.jfinal.config.Routes;
import com.jfinal.core.Controller;
import com.jfinal.kit.PropKit;
import com.jfinal.plugin.activerecord.ActiveRecordPlugin;
import com.jfinal.plugin.druid.DruidPlugin;
import com.jfinal.template.Engine;
import controller.HelloController;
import controller.LoginController;
import controller.StudentController;
import controller.TranslateController;
import models.login;
import models.student;

public class DemoConfig extends JFinalConfig {

    @Override
    public void configConstant(Constants constants) {
        //开启开发模式
        constants.setDevMode(true);
        PropKit.use("config.properties");
    }

    @Override
    public void configRoute(Routes routes) {
        routes.add("/hello", HelloController.class);
        routes.add("/login", LoginController.class);
        routes.add("/student", StudentController.class);
        routes.add("/add", StudentController.class,"/student");
        routes.add("/query", StudentController.class,"/student");
        routes.add("/list", StudentController.class, "/student");
        routes.add("/drop", StudentController.class, "/student");
        routes.add("/update", StudentController.class, "/student");
        routes.add("/translate", TranslateController.class);
    }

    @Override
    public void configEngine(Engine engine) {

    }

    @Override
    public void configPlugin(Plugins plugins) {
        // 使用配置文件中的属性来配置DruidPlugin
        DruidPlugin dp = new DruidPlugin(PropKit.get("jdbcUrl"), PropKit.get("user"), PropKit.get("password").trim());
        plugins.add(dp);
        // 配置ActiveRecordPlugin
        ActiveRecordPlugin arp = new ActiveRecordPlugin(dp);
        plugins.add(arp);
        // 映射数据库表到Model
        arp.addMapping("login", login.class);
        arp.addMapping("student", student.class);
    }

    @Override
    public void configInterceptor(Interceptors interceptors) {
        interceptors.add(new Interceptor() {
            @Override
            public void intercept(Invocation inv) {
                Controller controller = inv.getController();
                controller.getResponse().addHeader("Access-Control-Allow-Origin", "http://localhost:8080");
                controller.getResponse().addHeader("Access-Control-Allow-Methods", "GET, POST, PUT, DELETE, OPTIONS");
                controller.getResponse().addHeader("Access-Control-Allow-Headers", "Content-Type, x-requested-with");
                controller.getResponse().addHeader("Access-Control-Allow-Credentials", "true");

                if ("OPTIONS".equals(controller.getRequest().getMethod())) {
                    controller.renderNull(); // 对于OPTIONS请求，直接返回null
                } else {
                    inv.invoke();
                }
            }
        });
    }

    @Override
    public void configHandler(Handlers handlers) {

    }
}

然后编写两个控制类，分别是loginController和studentController,在其中编写相关的后端处理逻辑。代码如下：

package controller;

import com.alibaba.fastjson.JSON;
import com.jfinal.core.Controller;
import models.login;
import com.alibaba.fastjson.JSONObject;

import javax.servlet.http.HttpServletRequest;
import java.io.BufferedReader;
import java.io.IOException;

public class LoginController extends Controller {
    public void index() {
        boolean result = false;
        // 获取HttpServletRequest对象
        HttpServletRequest request = getRequest();
        // 从请求中获取JSON字符串
        StringBuilder jsonStringBuilder = new StringBuilder();
        String line;
        try {
            BufferedReader reader = request.getReader();
            while ((line = reader.readLine()) != null) {
                jsonStringBuilder.append(line);
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
        String json = jsonStringBuilder.toString();
        // 使用Fastjson解析JSON字符串
        JSONObject jsonObject = JSON.parseObject(json);
        // 从JSONObject对象中获取username和password
        String username = jsonObject.getString("username");
        String password = jsonObject.getString("password");
        login login = new login().getUserById(username);
        if(login!=null){
            if (password.equals(login.getPassword(login))){
                result = true;
            }
        }
        renderJson(result);
    }
}

package controller;

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
import com.jfinal.core.Controller;
import com.jfinal.plugin.activerecord.Db;
import models.student;

import javax.servlet.http.HttpServletRequest;
import java.io.BufferedReader;
import java.io.IOException;
import java.util.List;

public class StudentController extends Controller {

    public JSONObject getPara1() {
        // 获取HttpServletRequest对象
        HttpServletRequest request = getRequest();
        // 从请求中获取JSON字符串
        StringBuilder jsonStringBuilder = new StringBuilder();
        String line;
        try {
            BufferedReader reader = request.getReader();
            while ((line = reader.readLine()) != null) {
                jsonStringBuilder.append(line);
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
        String json = jsonStringBuilder.toString();
        // 使用Fastjson解析JSON字符串
        JSONObject jsonObject = JSON.parseObject(json);
        return jsonObject;
    }

    public void add()
    {
        boolean result=false;
        JSONObject jsonObject= getPara1();
        // 从JSONObject对象中获取username和password
        String stuid = jsonObject.getString("stuid");
        String stuname = jsonObject.getString("stuname");
        String stusex = jsonObject.getString("stusex");
        String stuclass = jsonObject.getString("stuclass");
        String stuage = jsonObject.getString("stuage");
        // 查询条件
        String sql = "SELECT * FROM student WHERE stuid = ?";
        // 执行查询
        student existingStudent = student.dao.findFirst(sql, stuid);

        if (existingStudent == null) {
            student student=new student();
            student.set("stuid",stuid);
            student.set("stuname",stuname);
            student.set("stusex",stusex);
            student.set("stuclass",stuclass);
            student.set("stuage",stuage);
            // 如果学生不存在，则保存新的学生信息
            result = student.save();
        }
        renderJson(result);
   }
    public void query()
    {
        StringBuilder sql = new StringBuilder("SELECT * FROM student");
        List<student> students = null;
        JSONObject jsonObject= getPara1();
        // 从JSONObject对象中获取username和password
        String stuid = jsonObject.getString("stuid");
        String stuname = jsonObject.getString("stuname");
        String stuclass = jsonObject.getString("stuclass");
        if (stuid != null && !stuid.isEmpty()) {
            sql.append(" WHERE stuid LIKE '%").append(stuid).append("%'");
        }
        if (stuname != null && !stuname.isEmpty()) {
            if (sql.indexOf("WHERE") != -1) {
                sql.append(" AND stuname LIKE '%").append(stuname).append("%'");
            } else {
                sql.append(" WHERE stuname LIKE '%").append(stuname).append("%'");
            }
        }
        if (stuclass != null && !stuclass.isEmpty()) {
            if (sql.indexOf("WHERE") != -1) {
                sql.append(" AND stuclass LIKE '%").append(stuclass).append("%'");
            } else {
                sql.append(" WHERE stuclass LIKE '%").append(stuclass).append("%'");
            }
        }
        students = student.dao.find(sql.toString());
        renderJson(students);
    }

    public void list()
    {
        JSONObject jsonObject= getPara1();
        Integer pageNumber = jsonObject.getInteger("page");
        Integer pageSize = jsonObject.getInteger("size");
        System.out.println(pageNumber);
        System.out.println(pageSize);
        student student = new student();
        System.out.println(student.paginate(pageNumber, pageSize));
        renderJson(student.paginate(pageNumber, pageSize));
    }

    public void drop()
    {
        boolean result=false;
        JSONObject jsonObject= getPara1();
        String stuid = jsonObject.getString("stuid");
        if (stuid != null && !stuid.isEmpty()) {
            // 构建删除条件
            String sql = "DELETE FROM student WHERE stuid = ?";
            // 执行删除操作
            int rowsAffected = Db.update(sql, stuid);
            if (rowsAffected > 0) {
                result=true;
                renderJson(result);
            } else {
                renderJson(result);
            }
        } else {
            renderJson(result);
        }
    }
    public void update()
    {
        JSONObject jsonObject= getPara1();
        String stuid = jsonObject.getString("stuid");
        String stuname = jsonObject.getString("stuname");
        String stusex = jsonObject.getString("stusex");
        String stuclass = jsonObject.getString("stuclass");
        String stuage = jsonObject.getString("stuage");
        String updateSql = "UPDATE student SET stuname = ?, stusex = ?, stuclass = ?, stuage = ? WHERE stuid = ?";
        int updated1 = Db.update(updateSql, stuname, stusex, stuclass, stuage, stuid);
        boolean updated = updated1 > 0;
        renderJson(updated);
    }
}

到这一步所有有关后端的工作结束。接下来是前端代码有关vue的部分。

Vue部分相关编写就是两个页面，一个登录页面，一个是信息管理页面。代码如下：

系统运行截图：

posted @ 2024-11-26 20:07 序章0 阅读(4) 评论(0) 编辑收藏举报

刷新页面返回顶部

czf

11月26日

任务三：

公告