java实现通用管理信息系统框架代码

由于通用管理信息系统框架的实现需要的代码量较大，此处无法提供完整代码。但是，我可以提供一个通用管理信息系统框架的基本结构，供你参考：

1. 数据库连接类

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DatabaseConnection {
    private static String url = "jdbc:mysql://localhost:3306/test";
    private static String user = "root";
    private static String password = "123456";
    private static Connection connection = null;

    public static Connection getConnection() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            connection = DriverManager.getConnection(url, user, password);
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
        return connection;
    }
}

2. 数据库操作类

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DatabaseUtil {
    private static Connection connection = null;
    private static PreparedStatement preparedStatement = null;
    private static ResultSet resultSet = null;

    public static ResultSet query(String sql) {
        try {
            connection = DatabaseConnection.getConnection();
            preparedStatement = connection.prepareStatement(sql);
            resultSet = preparedStatement.executeQuery();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return resultSet;
    }

    public static boolean update(String sql) {
        boolean flag = false;
        try {
            connection = DatabaseConnection.getConnection();
            preparedStatement = connection.prepareStatement(sql);
            int i = preparedStatement.executeUpdate();
            if (i > 0) {
                flag = true;
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return flag;
    }
}

3. 实体类

public class User {
    private int id;
    private String name;
    private String password;
    private int age;

    public User() {
    }

    public User(int id, String name, String password, int age) {
        this.id = id;
        this.name = name;
        this.password = password;
        this.age = age;
    }

    // getter/setter方法省略
}

4. DAO层

public class UserDao {
    public List<User> queryAll() {
        List<User> userList = new ArrayList<>();
        String sql = "SELECT * FROM user";
        ResultSet resultSet = DatabaseUtil.query(sql);
        try {
            while (resultSet.next()) {
                int id = resultSet.getInt("id");
                String name = resultSet.getString("name");
                String password = resultSet.getString("password");
                int age = resultSet.getInt("age");
                User user = new User(id, name, password, age);
                userList.add(user);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return userList;
    }

    public boolean addUser(User user) {
        boolean flag = false;
        String sql = "INSERT INTO user(name, password, age) VALUES (?, ?, ?)";
        try {
            connection = DatabaseConnection.getConnection();
            preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setString(1, user.getName());
            preparedStatement.setString(2, user.getPassword());
            preparedStatement.setInt(3, user.getAge());
            int i = preparedStatement.executeUpdate();
            if (i > 0) {
                flag = true;
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return flag;
    }
}

5. Service层

public class UserService {
    private UserDao userDao = new UserDao();

    public List<User> queryAll() {
        return userDao.queryAll();
    }

    public boolean addUser(User user) {
        return userDao.addUser(user);
    }
}

6. 控制器

public class UserController {
    private UserService userService = new UserService();

    public void addUser(User user) {
        boolean flag = userService.addUser(user);
        if (flag) {
            System.out.println("添加用户成功");
        } else {
            System.out.println("添加用户失败");
        }
    }

    public void queryAll() {
        List<User> userList = userService.queryAll();
        for (User user : userList) {
            System.out.println(user.getId() + "\t" + user.getName() + "\t" + user.getPassword() + "\t" + user.getAge());
        }
    }
}

这是一个简单的通用管理信息系统框架结构，你可以根据实际需求进行扩展和优化。