@author：Mr.Gu
@date:2021/5/31
文章目录
- Java项目开发：学生社团管理系统
- 项目需求
- 开发环境
- 项目效果
- 二、项目源码
- 1.创建登录Jframe
- 2.创建普通用户接口类
- 3.创建查看社团信息类Jframe
- 4.创建其他功能Jframe与上述方法同，因代码过于多，不一一展示
项目需求
要求制作一个社团管理系统，要求链接数据库，实现普通用户注册社团，正确登录社团，实现用户可以浏览社团信息，创建社团，且只能创建一个社团，可以申请加入社团，团长
可以进入社团管理系统，对社团进行管理，发布活动等等。
eclipse2018版
mysql5.7
jdk1.8
windowsbuilder
示例：pandas 是基于NumPy 的一种工具，该工具是为了解决数据分析任务而创建的。
二、项目源码 1.创建登录Jframe
public class LogFrm extends Jframe implements ActionListener {
boolean flag;
private JPanel contentPane;
private JTextField nametf;
private JPasswordField passwordField;
User user = new User();
/**
* Launch the application.
*/
public static void main(String[] args) {
EventQueue.invokeLater(new Runnable() {
public void run() {
try {
LogFrm frame = new LogFrm();
frame.setVisible(true);
} catch (Exception e) {
e.printStackTrace();
}
}
});
}
/**
* Create the frame.
*/
public LogFrm() {
setDefaultCloseOperation(Jframe.EXIT_ON_CLOSE);
setBounds(100, 100, 596, 771);
JMenuBar menuBar = new JMenuBar();
setJMenuBar(menuBar);
JMenu menu = new JMenu("编辑注册");
menuBar.add(menu);
JMenuItem menuItem = new JMenuItem("注册账号");
menuItem.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
Regist1 r = new Regist1();
r.setVisible(true);
}
});
menu.add(menuItem);
contentPane = new JPanel();
contentPane.setBackground(Color.WHITE);
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
setContentPane(contentPane);
contentPane.setLayout(null);
JLabel lblNewLabel = new JLabel("社团管理系统");
lblNewLabel.setFont(new Font("微软雅黑", Font.BOLD, 37));
lblNewLabel.setBounds(162, 154, 368, 122);
contentPane.add(lblNewLabel);
nametf = new JTextField();
nametf.setBounds(162, 331, 223, 27);
contentPane.add(nametf);
nametf.setColumns(10);
JLabel lblNewLabel_1 = new JLabel(" 学号 ：");
lblNewLabel_1.setBounds(40, 334, 81, 21);
contentPane.add(lblNewLabel_1);
JLabel lblNewLabel_2 = new JLabel("密码 ：");
lblNewLabel_2.setBounds(50, 411, 81, 21);
contentPane.add(lblNewLabel_2);
JButton button = new JButton("重置");
button.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
rest();
}
});
button.setBounds(88, 539, 123, 29);
contentPane.add(button);
JButton btnNewButton = new JButton("登录");
btnNewButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
try {
login();
} catch (HeadlessException | SQLException e1) {
e1.printStackTrace();
}
}
});
btnNewButton.setBounds(340, 539, 123, 29);
contentPane.add(btnNewButton);
passwordField = new JPasswordField();
passwordField.setBounds(162, 408, 223, 27);
contentPane.add(passwordField);
this.setLocationRelativeTo(null);
}
protected void login() throws HeadlessException, SQLException {
boolean xyz = false;
Mysql1 mysql = new Mysql1();
mysql.connectSQL();
String nameText = nametf.getText();
String pwdText = new String(passwordField.getText());
User user = new User(nameText, pwdText);
/**
* 用于数据库连接
*/
Connection connection = null;
if (StringUtil.isEmpty(nameText)) {
JOptionPane.showMessageDialog(null, "用户名为空");
} else {
if (StringUtil.isEmpty(pwdText)) {
JOptionPane.showMessageDialog(null, "密码不能为空");
} else {
try {
this.flag = mysql.loginMatch(nameText, pwdText);
} catch (SQLException e2) {
e2.printStackTrace();
} catch (Exception e2) {
e2.printStackTrace();
} // 清空输入栏
rest();
// 如果用户名判断成功则关闭login窗口并打开Spider窗口，否则状态栏显示loadfail;
if (flag) {
this.dispose();
setall(nametf.getText());
MainFrm mainFrm = new MainFrm(setall(nameText));
mainFrm.setVisible(true);
} else {
JOptionPane.showMessageDialog(null, "账号或密码错误");
}
}
}
}
private User setall(String id) throws SQLException {
String url = "jdbc:mysql://localhost:3306/student?useSSL=false";// url是固定的
// jdbc:mysql://localhost:3036/数据库名
String user3 = "root";// 这里一般是root
String password = "root";// 这是登陆数据库的密码，我的密码为空
String word3 = "select * from userinfo";
ResultSet resultSet = null;
boolean x = false;
String anameString = new String();
Connection con = (Connection) DriverManager.getConnection(url, user3, password);// 创建连接对象，来连接数据库
PreparedStatement ps0 = con.prepareStatement(word3);// 创建执行对象
resultSet = ps0.executeQuery(word3);
while (resultSet.next()) {
if (resultSet.getString("Id").equals(id)) {
user.setSex(resultSet.getString("sex"));
user.setName(resultSet.getString("name"));
user.setId(resultSet.getString("Id"));
user.setActivityID(resultSet.getString("activityID"));
user.setManage(resultSet.getString("isManage"));
}
}
return user;
}
/**
* 选择shift tab 整体往前捻 重置事件
*/
protected void rest() {
nametf.setText("");
passwordField.setText("");
}
@Override
public void actionPerformed(ActionEvent e) {
}
}
2.创建普通用户接口类
public class MainFrm extends Jframe {
private JPanel contentPane;
private JDesktopPane desktopPane;
public static User user;
/**
* Launch the application.[[
*/
/**
* Create the frame.
*/
MainFrm() {
super();
}
public MainFrm(User user1) throws SQLException {
this.user = user1;
applyhave();
setDefaultCloseOperation(Jframe.EXIT_ON_CLOSE);
setBounds(100, 100, 750, 580);
JMenuBar menuBar = new JMenuBar();
setJMenuBar(menuBar);
JMenu menu = new JMenu("u7F16u8F91");
menuBar.add(menu);
JMenuItem menuItem = new JMenuItem("退出");
menuItem.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
// setDefaultCloseOperation(3); //直接关闭程序
System.exit(0);
}
});
menu.add(menuItem);
contentPane = new JPanel();
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
contentPane.setLayout(new BorderLayout(0, 0));
setContentPane(contentPane);
desktopPane = new JDesktopPane();
desktopPane.setBackground(Color.WHITE);
contentPane.add(desktopPane, BorderLayout.CENTER);
JLabel label = new JLabel("用户界面");
label.setFont(new Font("宋体", Font.BOLD, 24));
label.setBounds(268, 103, 200, 118);
desktopPane.add(label);
JButton button = new JButton("查看社团信息");
button.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
Show show = new Show(user);
show.setVisible(true);
}
});
button.setBounds(15, 311, 178, 76);
desktopPane.add(button);
JButton button_1 = new JButton("创建社团");
button_1.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
boolean s = false;
CreatAct act = new CreatAct();
act.setVisible(true);
}
});
button_1.setBounds(243, 311, 178, 76);
desktopPane.add(button_1);
JButton button_2 = new JButton("进入管理员界面");
button_2.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
if (user.getManage().equals("1")) {
Manager manager;
try {
manager = new Manager(user);
manager.setVisible(true);
dispose();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
JOptionPane.showMessageDialog(null, "登录成功");
} else {
JOptionPane.showMessageDialog(null, "您没有权限");
}
}
});
button_2.setBounds(483, 311, 178, 76);
desktopPane.add(button_2);
this.setLocationRelativeTo(null);
}
private void applyhave() throws SQLException {
String url = "jdbc:mysql://localhost:3306/student?useSSL=false&useUnicode=true&characterEncoding=utf8";// url是固定的
String user3 = "root";// 这里一般是root
String password = "root";// 这是登陆数据库的密码，我的密码为空
String word3 = "select * from applyhave";
ResultSet resultSet = null;
String anameString = new String();
Connection con = (Connection) DriverManager.getConnection(url, user3, password);// 创建连接对象，来连接数据库
PreparedStatement ps0 = con.prepareStatement(word3);// 创建执行对象
resultSet = ps0.executeQuery(word3);
while (resultSet.next()) {
if (resultSet.getString("Stuname").equals(user.getName())) {
if (resultSet.getString("result").equals("1")) {
JOptionPane.showMessageDialog(null, "您申请加入的社团申请成功");
String word5 = "DELETe FROM applyhave WHERe Stuname = '" + user.getName() + "'";
PreparedStatement ps4 = con.prepareStatement(word5);// 创建执行对象
ps4.executeUpdate();
ps4.close();
}
}
}
}
}
}
3.创建查看社团信息类Jframe
public class Show extends Jframe {
private JTable table;
private User user;
public Show(User user) {
this.user=user;
setFocusable(true);
setBounds(100, 100, 1002, 697);
JScrollPane scrollPane = new JScrollPane();
JButton btnNewButton = new JButton("申请加入社团");
btnNewButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
ApplyAct applyAct =new ApplyAct(user);
applyAct.setVisible(true);
}
});
GroupLayout groupLayout = new GroupLayout(getContentPane());
groupLayout.setHorizontalGroup(
groupLayout.createParallelGroup(Alignment.LEADING)
.addGroup(groupLayout.createSequentialGroup()
.addGap(180)
.addComponent(scrollPane, GroupLayout.PREFERRED_SIZE, 612, GroupLayout.PREFERRED_SIZE)
.addContainerGap(188, Short.MAX_VALUE))
.addGroup(Alignment.TRAILING, groupLayout.createSequentialGroup()
.addContainerGap(771, Short.MAX_VALUE)
.addComponent(btnNewButton)
.addGap(86))
);
groupLayout.setVerticalGroup(
groupLayout.createParallelGroup(Alignment.LEADING)
.addGroup(groupLayout.createSequentialGroup()
.addGap(125)
.addComponent(scrollPane, GroupLayout.PREFERRED_SIZE, 348, GroupLayout.PREFERRED_SIZE)
.addGap(57)
.addComponent(btnNewButton)
.addContainerGap(82, Short.MAX_VALUE))
);
table = new JTable();
table.setModel(new DefaultTableModel(
new Object[][] {
},
new String[] {
"u793Eu56E2u540D", "u793Eu56E2u4FE1u606F", "u793Eu56E2ID", "u56E2u957F", "u662Fu5426u6EE1u5458"
}
));
scrollPane.setViewportView(table);
getContentPane().setLayout(groupLayout);
loadData();//传入数据
this.setLocationRelativeTo(null);
}
// 将数据库中数据传入中可以发挥
private void loadData() {
// 获取表格数据
DefaultTableModel model = (DefaultTableModel) table.getModel();
// 每次添加的时候清空表格的原始数据
model.setRowCount(0);
// 模拟数据
// model.addRow("社团名称，社团人数，团长，是否满员");
model.setRowCount(0);
String url="jdbc:mysql://localhost:3306/student?useSSL=false&useUnicode=true&characterEncoding=utf8";//url是固定的 jdbc:mysql://localhost:3036/数据库名
String user3="root";//这里一般是root
String password="root";//这是登陆数据库的密码，我的密码为空
String word="select * from activity";
try {
Class.forName("com.mysql.jdbc.Driver");//加载驱动类
Connection con= DriverManager.getConnection(url, user3, password);//创建连接对象，来连接数据库
ResultSet resultSet =null;
PreparedStatement ps=con.prepareStatement(word);//创建执行对象
resultSet=ps.executeQuery();
while (resultSet.next()) {
Object[] objs1 = {resultSet.getString("ActInfo"),resultSet.getString("ActId"),resultSet.getString("ManagerId"),resultSet.getString("Adtname"),"否"};
model.addRow(objs1);
}
ps.close();
con.close();
} catch (ClassNotFoundException e2) { //这里是错误捕捉，如果出错，计算机就会执行这段代码，下面的也是
e2.printStackTrace();
} catch (SQLException e1) {
e1.printStackTrace();
}
dispose();
}
}
4.创建其他功能Jframe与上述方法同，因代码过于多，不一一展示
