📄 gms.java
字号:
}
});
JPanel q7=new JPanel();
JPanel q8=new JPanel();
JButton b6=new JButton("重置");//////设置事件处理.
b6.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
t2.setText("");
pa2.setText("");
te7.setText("");
te8.setText("");
te9.setText("");
te10.setText("");
te11.setText("");
te12.setText("");
te13.setText("");
bool=0;
}
}
);
q7.add(b5);
q8.add(b6);
p311.add(new JLabel(" Name:"));
p311.add(t2);
p311.add(new JLabel(" Password:"));
p311.add(pa2);
p311.add(new JLabel(" "));
p311.add(new JLabel(" "));
p311.add(q7);
p311.add(q8);
//设置边框
JTextArea text2=new JTextArea ("注意事项!!!\n\r(1)在查询时，请输入正确的用户名及密码.\n\r(2)此项功能只对管理员开放．\n\");
text2.setEditable(false);
text2.setForeground(Color.red);
Border bor5=BorderFactory.createLineBorder(Color.DARK_GRAY);
text1.setBorder(bor5);
JScrollPane textScrollPane1=new JScrollPane(text2);
Border bor6=BorderFactory.createLineBorder(Color.darkGray);
//p211.setBorder(bor1);
p31.add(p311);
p31.add(textScrollPane1);
//右边
JPanel p32=new JPanel(new GridLayout(8,2));
JPanel p321=new JPanel();
JPanel p322=new JPanel();
JLabel la5=new JLabel("你的信息:");
la5.setForeground(Color.red);
p32.add(la5);
p32.add(new JLabel(""));
p32.add(new JLabel("排骨泡饭 "));
p32.add(te7);
p32.add(new JLabel("排骨泡饭"));
p32.add(te8);
p32.add(new JLabel("咖喱牛肉饭"));
p32.add(te9);
p32.add(new JLabel("皮蛋瘦肉粥"));
p32.add(te10);
p32.add(new JLabel("三鲜面（米线)"));
p32.add(te11);
JLabel la3=new JLabel("其他:");
la3.setForeground(Color.red);
//JLabel la4=new JLabel("总的学分:");
p32.add(la3);
JButton kin=new JButton("更多查询..");//////////////////添加事件.//////////////////////////////////////
kin.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
}
});
kin.setForeground(Color.red);
la4.setForeground(Color.red);
//p32.add(la4);
p32.add(te13);
p32.add(la3);
p32.add(kin);
Border bor8=BorderFactory.createLineBorder(Color.darkGray);
p32.setBorder(bor8);
//创建面板p4，用于查询个人信息。
JPanel p41=new JPanel(new GridLayout(2,1));
JPanel p42=new JPanel(new GridLayout(2,1));
JPanel p411=new JPanel(new GridLayout(4,2));
JPanel p412=new JPanel(new GridLayout(1,1));
//面板左边的布局。
JButton b7=new JButton("确定");////添加事件。
b7.addActionListener(new ActionListener ()
{
public void actionPerformed(ActionEvent e)
{
int sign=2;
Login wangqingbo=new Login(sign,t3.getText(),pa3.getText());
if(wangqingbo.returns()==1)
{
SelectMessage wangqing=new SelectMessage(t3.getText());
te14.setText(wangqing.return1());
te15.setText(wangqing.return2());
te16.setText(wangqing.return3());
te17.setText(wangqing.return4());
text4.setText(wangqing.return7());
}
}
}
);
JPanel q9=new JPanel();
q9.add(b7);
JPanel q10=new JPanel();
JButton b8=new JButton("重置");/////添加事件。
b8.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
t3.setText("");
pa3.setText("");
te14.setText("");
te15.setText("");
te16.setText("");
te17.setText("");
text4.setText("");
}
}
);
q10.add(b8);
p411.add(new JLabel(" Name:"));
p411.add(t3);
p411.add(new JLabel(" Password:"));
p411.add(pa3);
p411.add(new JLabel(""));
p411.add(new JLabel(""));
p411.add(q9);
p411.add(q10);
//添加注意事项。
JTextArea text3=new JTextArea ("注意事项!!!\n\r(1)在查询个人信息时，请输入正确的用户名及密码.\n\r");
text3.setEditable(false);
text3.setForeground(Color.red);
JScrollPane textScrollPane2=new JScrollPane(text3);
p412.add(textScrollPane2);
p41.add(p411);
p41.add(p412);
//面板右边的布局。
JPanel p421=new JPanel(new GridLayout(6,2));
JLabel la8=new JLabel("基本信息：");
la8.setForeground(Color.red);
p421.add(la8);
p421.add(new JLabel(""));
p421.add(new JLabel("姓名:"));
p421.add(te14);
p421.add(new JLabel("ID:"));
p421.add(te15);
p421.add(new JLabel("住址:"));
p421.add(te16);
//p421.add(new JLabel("学院:"));
//p421.add(te17);
//JLabel la9=new JLabel("个人所受奖励情况：");
//la9.setForeground(Color.red);
//p421.add(la9);
//p421.add(new JLabel(""));
JPanel p422=new JPanel(new GridLayout(1,1));
JScrollPane textScrollPane3=new JScrollPane(text4);
p422.add(textScrollPane3);
Border bor10=BorderFactory.createLineBorder(Color.darkGray);
p41.setBorder(bor10);
p42.add(p421);
p42.add(p422);
//用于创建"P5信息修改"模块
//面板左边的布局．
JPanel p51=new JPanel(new GridLayout(2,1));
JPanel p52=new JPanel(new GridLayout(2,1));
JPanel p511=new JPanel(new GridLayout(5,2));
JPanel p512=new JPanel(new GridLayout(1,1));
JPanel p521=new JPanel(new GridLayout(5,2));
JPanel p522=new JPanel(new GridLayout(1,1));
p511.add(new JLabel(" Name:"));
p511.add(t4);
p511.add(new JLabel(" Password:"));
p511.add(pa4);
p511.add(new JLabel());
p511.add(new JLabel());
JButton b9=new JButton("OK");//////添加事件。
b9.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
int sign=2;
Login wangqing=new Login( sign,t4.getText(),pa4.getText());
bool=wangqing.returns();
if(bool==1)
{
text6.setEditable(true);
te18.setEditable(true);
te19.setEditable(true);
te20.setEditable(true);
}
}
}
);
JButton b10=new JButton("CANCEL:");///////添加事件。
b10.addActionListener(new ActionListener ()
{
public void actionPerformed(ActionEvent e)
{
t4.setText("");
pa4.setText("");
te18.setText("");
te19.setText("");
te20.setText("");
te18.setEditable(false);
te19.setEditable(false);
te20.setEditable(false);
text6.setEditable(false);
bool=0;
}
}
);
JPanel q11=new JPanel();
JPanel q12=new JPanel();
q11.add(b9);
q12.add(b10);
p511.add(q11);
p511.add(q12);
p511.add(new JLabel());
p511.add(new JLabel());
JTextArea text5=new JTextArea ("注意事项!!!\n\r(1)在修改个人信息时，请输入正确的用户名及密码.\n\r(2)输入的新密码要与确认密码一致\n\r(3)修改密码后请记住自己的新密码，否则下次无法登陆．");
text5.setEditable(false);
text5.setForeground(Color.red);
JScrollPane textScrollPane4=new JScrollPane(text5);
p512.add(textScrollPane4);
p51.add(p511);
p51.add(p512);
JLabel la7=new JLabel("信息修改");
la7.setForeground(Color.red);
p521.add(la7);
JButton b11=new JButton("输入信息");
b11.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
if(bool==1)
{
if(te19.getText().equals(te20.getText()))
{
Reset wangqingbo=new Reset(t4.getText(),te18.getText(),te19.getText(),text6.getText());
}
else
{
JOptionPane.showMessageDialog(null,"请验证输入的密码是否一致！！");
}
}
else
{
JOptionPane.showMessageDialog(null,"你没有成功登陆,因此无权实现该操作");
}
}
}
);
b11.setForeground(Color.red);
p521.add(b11);
p521.add(new JLabel("新用户名："));
//////////////////////
p521.add(te18);
p521.add(new JLabel("新的密码："));
p521.add(te19);
p521.add(new JLabel("确认密码："));
p521.add(te20);
JLabel la11=new JLabel("个人简介：");
la11.setForeground(Color.red);
p521.add(la11);
JScrollPane textScrollPane5=new JScrollPane(text6);
p522.add(textScrollPane5);
p52.add(p521);
p52.add(p522);
p2.add(p21);
p2.add(p22);
p2.setBorder( bor3);
p3.add(p31);
p3.add(p32);
p3.setBorder( bor8);
p4.add(p41);
Border bor11=BorderFactory.createLineBorder(Color.darkGray);
p4.setBorder(bor11);
p4.add(p42);
Border bor12=BorderFactory.createLineBorder(Color.darkGray);
p51.setBorder(bor12);
p5.add(p51);
p5.add(p52);
Border bor13=BorderFactory.createLineBorder(Color.darkGray);
p5.setBorder(bor13);
}
public static void main(String []args)
{
GMS wang=new GMS();
}
}
//连接数据库的类, 主要用于用户的登陆
/*class Login
{
int bool=0;
String name;
public Login(int sign,String logname,String password)
{
Connection con;
Statement sql;
ResultSet rs;
int rowcount=0;
String ps="";
name=logname;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}*/
//确定是管理员登陆还是用户登陆。
if(sign==1)
{
try
{
con=DriverManager.getConnection("jdbc:odbc:wangqingbo","","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT *FROM teacher WHERE name="+"'"+logname+"'");
while(rs.next())
{
rowcount++;
ps=rs.getString(3);
}
if((rowcount==1)&&(password.equals(ps)))
{
JOptionPane.showMessageDialog(null,"恭喜你成功登陆。");
bool=1;
}
else
{
JOptionPane.showMessageDialog(null,"请检查你输入的用户名名或密码是否正确！！");
bool=0;
}
rs.close();
}
catch( SQLException e){}
}
if(sign==2)
{
try
{
con=DriverManager.getConnection("jdbc:odbc:wangqingbo","","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT *FROM message WHERE name="+"'"+logname+"'");
while(rs.next())
{
rowcount++;
ps=rs.getString(5);
}
if((rowcount==1)&&(password.equals(ps)))
{
JOptionPane.showMessageDialog(null,"恭喜你成功登陆。");
bool=1;
}
else
{
JOptionPane.showMessageDialog(null,"请检查你输入的用户名或密码是否正确！！");
bool=0;
}
con.close();
}
catch( SQLException e){}
}
}
public int returns()
{
return bool;
}
public String returns1()
{
return name;
}
}
//连接数据库的类, 用于管理人员输入学生的成绩.
class Insert
{
int bool;
public Insert(String cord,String course1,String course2,String course3,String course4,String course5)
{
Connection con1;
Statement sql1;
ResultSet rs1;
//////////用于查看所输入的用户是否存在
int count=0;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try
{
con1=DriverManager.getConnection("jdbc:odbc:wangqingbo","","");
sql1=con1.createStatement();
rs1=sql1.executeQuery("SELECT *FROM grade WHERE cord="+"'"+cord+"'");
while(rs1.next())
{
count++;
}
}
catch( SQLException e){}
///////////如果存在修改原来的记录
if(count==1)
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -