第1页 / 共18页
第2页 / 共18页
第3页 / 共18页
第4页 / 共18页
第5页 / 共18页
第6页 / 共18页
第7页 / 共18页
第8页 / 共18页
学生社团管理系统源代码.docx
package 学生社团管理系统 ;
import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseEvent;
import java.awt.event.MouseListener;
import java.awt.event.MouseMotionListener;
import java.sql.*;
public class League extends JFrame implements ActionListener {
FPanel fp;
JLabel jlb, jlb2, jlb_alter, jlb_background,jlb_X;
JTextField jtf;
JPasswordField jpf;
JButton jb_in, jb_register, fp_close;
Font f1 = new Font(" 宋体 ", Font.PLAIN, 20);
static String s1;
static String s2;
public static void main(String[] args) {
League le = new League();
}
public League() {
fp = new FPanel();
fp.setLayout(null);
jlb_background = new JLabel(new ImageIcon("background.jpg"));
jlb_background.setBounds(0, 0, 300, 400);
jlb_X=new JLabel(new ImageIcon("X.gif"));
jlb_X.setBounds(280,0,20,20);
jlb = new JLabel(" 账号 ");
jlb.setBounds(10, 200, 50, 40);
jlb.setFont(f1);
jlb2 = new JLabel(" 密码 ");
jlb2.setFont(f1);
jlb2.setBounds(10, 260, 50, 40);
// 用户输入区
jtf = new JTextField(15);
jtf.setFont(f1);
jtf.setBounds(70, 200, 200, 40);
jpf = new JPasswordField(8);
jpf.setFont(f1);
jpf.setBounds(70, 260, 200, 40);
// 按钮区
jb_in = new JButton(" 登录 ");
jb_in.setContentAreaFilled(false);
jb_in.setBounds(30, 340, 100, 40);
// jb_in.setBackground(Color.white);
jb_in.addActionListener(this);
jb_register = new JButton(" 注册用户 ");
jb_register.setContentAreaFilled(false);
jb_register.setBounds(170, 340, 100, 40);
// jb_register.setBackground(Color.blue);
jb_register.addActionListener(this);
// 关闭按钮
fp_close = new JButton();
fp_close.setBounds(280, 0, 20, 20);
fp_close.setContentAreaFilled(false);
// fp_close.setIcon();
// fp_close.setOpaque(false);
fp_close.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
System.exit(0);
}
});
fp.add(jlb);
fp.add(jlb2);
fp.add(jb_register);
fp.add(jtf);
fp.add(jpf);
fp.add(jb_in);
fp.add(fp_close);
fp.add(jlb_X);
fp.add(jlb_background);
this.add(fp);
this.setTitle("LLL 学生社团管理系统 ");
this.setSize(300, 400);
this.setLocationRelativeTo(null);
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setUndecorated(true);
this.setVisible(true);
}
@Override
public void actionPerformed(ActionEvent arg0) {
Connection con = null;
Statement statement = null;
ResultSet rs = null;
s1=jtf.getText();
s2=jpf.getText();
if (arg0.getSource() == jb_register) {
new registerpage();
this.dispose();
} else if (arg0.getSource() == jb_in) {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
} catch (ClassNotFoundException eee)
{ System.out.println(eee);
}
try {
con = DriverManager.getConnection( "jdbc:sqlserver://localhost:1433;DatabaseName=League",
"sa", "qsq1117");
statement = con.createStatement();
rs = statement.executeQuery("SELECT m_id,m_password FROM members
where m_id='s1' and m_password='s2'");
if (rs!=null) {
new mainpage();
this.dispose();
}
} catch (SQLException eee) {
System.out.println(eee);
}
} else {
JOptionPane.showMessageDialog(this, " 账户密码错误，请重新输入！ ");
}
}
}
class FPanel extends JPanel implements MouseListener, MouseMotionListener
{ private int offsetX, offsetY;
public FPanel() {
addMouseListener(this);
addMouseMotionListener(this);
}
public void mouseDragged(MouseEvent e)
{ SwingUtilities.getRoot((Component) e.getSource()).setLocation(
e.getXOnScreen() - offsetX, e.getYOnScreen() - offsetY);
}
@Override
public void mouseMoved(MouseEvent arg0) {
}
@Override
public void mouseClicked(MouseEvent arg0) {
}
@Override
public void mouseEntered(MouseEvent arg0) {
}
@Override
public void mouseExited(MouseEvent arg0) {
}
@Override
public void mousePressed(MouseEvent arg0) {
offsetX = arg0.getX();
offsetY = arg0.getY();
}
@Override
public void mouseReleased(MouseEvent arg0) {
}
}
public class alterpage extends JFrame implements ActionListener
{ FPanel fp;
JLabel jl_id, jl_name, jl5, jl_age, jl_department, jl_class, jl_number, jl_mail,
jlb_background,jlb_X;
JTextField jt_id, jt_name, jt_age, jt_department, jt_class, jt_number,
jt_mail;
JPasswordField jpf_password, jpf_password2;
JButton jb1, jb2, fp_close,jb_back;
String s0, s1, s2, s3, s4, s5, s6;
public alterpage() {
// Font f1 = new Font(" 宋体 ", Font.PLAIN, 20);
fp = new FPanel();
fp.setLayout(null);
jlb_background = new JLabel(new ImageIcon("background.jpg"));
jlb_background.setBounds(0, 0, 300, 400);
jlb_X=new JLabel(new ImageIcon("X.gif"));
jlb_X.setBounds(280,0,20,20);
jl_id = new JLabel(" 账户： ");
jl_id.setBounds(10, 140, 70, 20);
jl_name = new JLabel(" 姓名： ");
jl_name.setBounds(10, 170, 70, 20);
jl_age = new JLabel(" 年龄： ");
jl_age.setBounds(10, 200, 70, 20);
jl_department = new JLabel(" 院系： ");
jl_department.setBounds(10, 230, 70, 20);
jl_class = new JLabel(" 班级： ");
jl_class.setBounds(10, 260, 70, 20);
jl_number = new JLabel(" 手机号： ");
jl_number.setBounds(10, 290, 70, 20);
jl_mail = new JLabel(" 邮箱： ");
jl_mail.setBounds(10, 320, 70, 20);
jt_id = new JTextField(10);
jt_id.setBounds(80, 140, 200, 20);
jt_name = new JTextField(15);
jt_name.setBounds(80, 170, 200, 20);
jt_age = new JTextField(11);
jt_age.setBounds(80, 200, 200, 20);
jt_department = new JTextField();
jt_department.setBounds(80, 230, 200, 20);
jt_class = new JTextField(15);
jt_class.setBounds(80, 260, 200, 20);
jt_number = new JTextField();
jt_number.setBounds(80, 290, 200, 20);
jt_mail = new JTextField();
jt_mail.setBounds(80, 320, 200, 20);
// 关闭按钮
fp_close = new JButton();
fp_close.setBounds(280, 0, 20, 20);
fp_close.setContentAreaFilled(false);
// fp_close.setIcon();
// fp_close.setOpaque(false);
fp_close.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
System.exit(0);
}
});
jb1 = new JButton(" 提交 ");
jb1.setContentAreaFilled(false);
jb1.setBounds(20, 360, 80, 30);
jb1.addActionListener(this);
jb2 = new JButton(" 重置 ");
jb2.setContentAreaFilled(false);
jb2.setBounds(110, 360, 80, 30);
jb2.addActionListener(this);
jb_back=new JButton(" 返回 ");
jb_back.setContentAreaFilled(false);
jb_back.setBounds(200, 360, 80, 30);
jb_back.addActionListener(this);
// 添加组件
fp.add(jb1);
fp.add(jb2);
fp.add(jb_back);
fp.add(jl_id);
fp.add(jl_name);
fp.add(jl_age);
fp.add(jl_department);
fp.add(jl_class);
fp.add(jl_number);
fp.add(jl_mail);
// fp.add(jpf_password);
// fp.add(jpf_password2);
fp.add(jt_id);
fp.add(jt_name);
fp.add(jt_age);
fp.add(jt_department);
fp.add(jt_class);
fp.add(jt_number);
fp.add(jt_mail);
fp.add(fp_close);
fp.add(jlb_X);
fp.add(jlb_background);
this.add(fp);
this.setSize(300, 400);
this.setLocationRelativeTo(null);
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setUndecorated(true);
this.setVisible(true);
}
@Override
public void actionPerformed(ActionEvent e) {
Connection con = null;
Statement statement = null;
ResultSet rs = null;
s0 = jt_id.getText().trim();
s1 = jt_name.getText().trim();
s2 = jt_department.getText().trim();
s3 = jt_class.getText().trim();
s4 = jt_age.getText().trim();
s5 = jt_number.getText().trim();
s6 = jt_mail.getText().trim();
if (e.getSource() == jb1) {
if (jt_name != null && jt_department != null && jt_class != null)
{ if (s0.equals(League.s1)) {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); }
catch (ClassNotFoundException eee) {
System.out.println(eee);
}
try {
con = DriverManager
.getConnection(
"jdbc:sqlserver://localhost:1433;DatabaseName=League", "sa",
"qsq1117");
statement = con.createStatement();
statement.executeUpdate("Update members set m_name='"
+ s1 + "',m_department='" + s2 + "',m_class='"
+ s3 + "',m_age='" + s4 + "',m_number='" + s5
+ "',m_mail='" + s6 + "' where LTRIM(m_id)='"
+ s0 + "'");
} catch (SQLException eee) {
System.out.println(eee);
}
try {
statement.close();
con.close();
} catch (SQLException e1) {
// TODO 自动生成的 catch 块
e1.printStackTrace();
}
new League();
this.dispose();
} else {
JOptionPane.showMessageDialog(this, " 账号不能为空或者被改变 ");
}
} else {
JOptionPane.showMessageDialog(this, " 名字，学院，班级不能为空 ");
}
} else if (e.getSource() == jb2) {
new alterpage();
this.dispose();
}else if (e.getSource() == jb_back)
{
new mainpage();
this.dispose();
}
}
}
public class mainpage extends JFrame implements ActionListener
{ FPanel fp;
JLabel jlb1, jlb2, jlb3, jlb_background, jlb_X;
JTextField jt1, jt2, jt3;
JPasswordField jpf;
JButton jb_search, fp_close, jb_alter,jb_delete;
JTextField jtf_input;
相关推荐
2023年江西萍乡中考道德与法治真题及答案.doc
2012年重庆南川中考生物真题及答案.doc
2013年江西师范大学地理学综合及文艺理论基础考研真题.doc
2020年四川甘孜小升初语文真题及答案I卷.doc
2020年注册岩土工程师专业基础考试真题及答案.doc
2023-2024学年福建省厦门市九年级上学期数学月考试题及答案.doc
2021-2022学年辽宁省沈阳市大东区九年级上学期语文期末试题及答案.doc
2022-2023学年北京东城区初三第一学期物理期末试卷及答案.doc
2018上半年江西教师资格初中地理学科知识与教学能力真题及答案.doc
2012年河北国家公务员申论考试真题及答案-省级.doc
2020-2021学年江苏省扬州市江都区邵樊片九年级上学期数学第一次质量检测试题及答案.doc
2022下半年黑龙江教师资格证中学综合素质真题及答案.doc
