📄 student.txt
字号:
{
idT.setText(id);
nameT.setText(name);
sexT.setText(sex);
majorT.setText(major);
scoreT.setText(score);
Pic.setIcon(new ImageIcon(pic));
Pic.setLocation(100,190);
Pic.setSize(200,220);
c.add(Pic);
}
}
catch(Exception ex)
{
JOptionPane.showMessageDialog(null,"抱歉，程序出现异常了！(*^__^*) 嘻嘻……！");
}
}
}
////////////////////////////////////////////////////////////////////////////////////
if(e.getSource()==subMenu1[4])
{
closeDB();
System.exit(0);
}
/////////////////////////////////////////////////////////////////////////////////////
if(e.getSource()==subMenu2[1] || e.getSource()==toolBarButton[1])
{
JOptionPane.showMessageDialog(null,"请输入要添加的学生信息");
idT.setEnabled(true);
idT.setText("");
nameT.setText("");
sexT.setText("");
majorT.setText("");
scoreT.setText("");
}
//////////////////////////////////////////////////////////////////////////////////////
if(e.getSource()==toolBarButton[5] || e.getSource()==subMenu2[5])
{
if((idT.getText().trim()).equals("") || (nameT.getText().trim()).equals("") || (sexT.getText().trim()).equals("") || (majorT.getText().trim()).equals("") ||(scoreT.getText().trim()).equals("") )
JOptionPane.showMessageDialog(null,"请输入信息再点击提交添加！");
else
{
id = idT.getText();
name = nameT.getText();
sex = sexT.getText();
major = majorT.getText();
score = scoreT.getText();
String strSQL ="insert into xuesheng(id,name,sex,major,score) values('" + id + "','" + name + "','" + sex + "','" + major + "','" + score + "')";
try
{
st.executeUpdate(strSQL);
}
catch(Exception exx)
{
JOptionPane.showMessageDialog(null,"数据库中已经存在您要添加的学生的学号！");
return;
}
JOptionPane.showMessageDialog(null,"恭喜您，添加成功了！");
}
}
////////////////////////////////////////////////////////////////////////////////////////////
if(e.getSource()==subMenu2[4] || e.getSource()==toolBarButton[4])
{
if((idT.getText().trim()).equals("") || (nameT.getText().trim()).equals("") || (sexT.getText().trim()).equals("") || (majorT.getText().trim()).equals("") ||(scoreT.getText().trim()).equals("") )
{
JOptionPane.showMessageDialog(null,"请输入信息再点击修改！");
return;
}
else
{
id = idT.getText();
name = nameT.getText();
sex = sexT.getText();
major = majorT.getText();
score = scoreT.getText();
String strSQL ="update xuesheng set name='"+name+"',sex='"+sex+"',major='"+major+"',score='"+score+"'"+"where id='"+id+"'";
try
{
st.executeUpdate(strSQL);
}
catch(Exception exx)
{
JOptionPane.showMessageDialog(null,"数据库中已经存在您要修改的学生记录！");
return;
}
JOptionPane.showMessageDialog(null,"恭喜您，修改成功了！");
}
}
//////////////////////////////////////////////////////////////////////////////////////////
if(e.getSource()==subMenu2[3]||e.getSource()==toolBarButton[3])
{
String idid = JOptionPane.showInputDialog("请输入要修改的学生学号");
if(!(idid.trim()).equals(""))
{
String strSQL = "select * from xuesheng where id ='" + idid + "'";
try
{
rs = st.executeQuery(strSQL);
int count = 0;
while(rs.next())
{
id = rs.getString("id");
name = rs.getString("name");
major = rs.getString("major");
sex = rs.getString("sex");
score = rs.getString("score");
++count;
}
if(count==0)
JOptionPane.showMessageDialog(null,"对不起，没有您要修改的学生信息！");
else
{
idT.setText(id);
nameT.setText(name);
sexT.setText(sex);
majorT.setText(major);
scoreT.setText(score);
idT.setEnabled(false);
}
}
catch(Exception ex)
{
JOptionPane.showMessageDialog(null,"抱歉，程序出现异常！");
}
}
}
//////////////////////////////////////////////////////////////////////////////////////////////
if(e.getSource()==subMenu2[2]||e.getSource()==toolBarButton[2])
{
String idDel = JOptionPane.showInputDialog("请输入要删除的学生学号");
if(!((idDel.trim()).equals("")))
{
String strSQL = "select * from xuesheng where id ='" + idDel + "'";
try
{
rs = st.executeQuery(strSQL);
int count = 0;
while(rs.next())
{
id = rs.getString("id");
name = rs.getString("name");
score= rs.getString("score");
sex = rs.getString("sex");
major = rs.getString("major");
++count;
}
if(count==0)
JOptionPane.showMessageDialog(null,"对不起，没有您要删除的学生信息！");
else
{
idT.setText(id);
nameT.setText(name);
sexT.setText(sex);
majorT.setText(major);
scoreT.setText(score);
idT.setEnabled(false);
}
}
catch(Exception ex)
{
JOptionPane.showMessageDialog(null,"抱歉，程序出现异常！");
}
}
}
//////////////////////////////////////////////////////////////////////////////////////////////
if(e.getSource()==toolBarButton[6] || e.getSource()==subMenu2[6])
{
if((idT.getText().trim()).equals("") || (nameT.getText().trim()).equals("") || (sexT.getText().trim()).equals("") || (majorT.getText().trim()).equals("") ||(scoreT.getText().trim()).equals("") )
{
JOptionPane.showMessageDialog(null,"请点击删除记录按钮！");
return;
}
else
{
id = idT.getText();
String strSQL ="delete from xuesheng where id='"+id+"'";
try
{
st.executeUpdate(strSQL);
}
catch(Exception exx)
{
JOptionPane.showMessageDialog(null,"通知您：出错了！");
return;
}
JOptionPane.showMessageDialog(null,"删除成功！");
}
}
}
}
class DrawMap
{
public DrawMap(int a,int b,int c)
{
MyFrame my=new MyFrame(a,b,c);
my.setVisible(true);
}
}
class MyFrame extends JFrame
{
int a,b,c;
MyFrame(int a,int b,int c)
{
this.a=a;
this.b=b;
this.c=c;
this.setTitle("学生成绩饼状图");
this.setSize(500,500);
mp = new Mypanel(a,b,c);
this.add(mp);
this.setDefaultCloseOperation(this.HIDE_ON_CLOSE);
}
private Mypanel mp;
}
class Mypanel extends JPanel
{
private int a,b,c;
public Mypanel(int a,int b,int c)
{
this.a=a;
this.b=b;
this.c=c;
}
public void paintComponent(Graphics g)
{
int sum;
sum=a+b+c;
//画饼状图
g.setColor(Color.red);
g.fillArc(150, 50, 200, 200, 0,(int)(a*1.0/sum*360));
g.setColor(Color.GREEN);
g.fillArc(150, 50, 200, 200, (int)(a*1.0/sum*360),(int)(b*1.0/sum*360));
g.setColor(Color.BLUE);
g.fillArc(150, 50, 200, 200, (int)(b*1.0/sum*360)+(int)(a*1.0/sum*360), 360-(int)(a*1.0/sum*360)-(int)(b*1.0/sum*360));
//打印出各个的比例
g.drawString("goodest："+(int)(a*1.0/sum*100)+"%",200,350);
g.drawString("good："+(int)(b*1.0/sum*100)+"%",200,370);
g.drawString("bad："+(100-(int)(a*1.0/sum*100)-(int)(b*1.0/sum*100))+"%",200,390);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -