java学生管理系统（包括SQL数据库）(6)

苏州大学本科生课程设计

JButton denglu2=(JButton)e.getSource(); if(b.isSelected()) {

zh=t2.getText(); String mima=t4.getText(); try {

Class.forName(\);

Connection c=DriverManager.getConnection(\学生信息系统\);

ResultSet.TYPE_SCROLL_SENSITIVE,

ResultSet.CONCUR_UPDATABLE);

ResultSet r=s.executeQuery(\教师信息表 where 教师 r.last();

Statement s=c.createStatement(

ID='\+zh+\登录密码='\+mima+\);

if(r.getRow()==1) { mm.setVisible(false); r.beforeFirst(); while(r.next()){

JOptionPane.showMessageDialog( null ,r.getString(\教师姓名\)+\老师！您好！欢迎登JFrame mmm=new JFrame(); mmm.setSize(400,420); mmm.setVisible(true); mmm.setLocation(200,300);

mmm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

JLabel aaa=new JLabel(\学生信息管理:\);JLabel aaa1=new JLabel(\学生成绩管理:\); JButton b1=new JButton(\显示学生信息\);b1.setBounds(40,45,140,30); JButton b2=new JButton(\添加学生信息\);b2.setBounds(200,45,140,30); JButton b3=new JButton(\修改学生信息\);b3.setBounds(40,90,140,30); JButton b4=new JButton(\删除学生信息\);b4.setBounds(200,90,140,30); JButton b5=new JButton(\录入学生成绩\);b5.setBounds(40,170,140,30); JButton b6=new JButton(\修改学生成绩\);b6.setBounds(200,170,140,30); JButton b7=new JButton(\删除学生成绩\);b7.setBounds(40,215,140,30); JButton b8=new JButton(\查询学生成绩\);b8.setBounds(200,215,140,30); JButton b9=new JButton(\所有成绩排名\);b9.setBounds(40,260,140,30); JButton b12=new JButton(\单科成绩排名\);b12.setBounds(200,260,140,30); JButton b10=new JButton(\退出系统\);b10.setBounds(60,325,100,30); JButton b11=new JButton(\修改密码\);b11.setBounds(220,325,100,30); aaa.setBounds(15,15,90,30); aaa1.setBounds(15,140,90,30); Container n=mmm.getContentPane();

n.setLayout(null);

J_ActionListener1 a1=new J_ActionListener1(); J_ActionListener2 a2=new J_ActionListener2(); J_ActionListener3 a3=new J_ActionListener3(); J_ActionListener4 a4=new J_ActionListener4(); J_ActionListener5 a5=new J_ActionListener5(); J_ActionListener8 a8=new J_ActionListener8(); J_ActionListener10 a10=new J_ActionListener10();

录教师管理系统！\ ) ; }

J_ActionListener7 a7=new J_ActionListener7(); J_ActionListener9 a9=new J_ActionListener9();

J_ActionListener12 a12=new J_ActionListener12();

２４

苏州大学本科生课程设计

}}

public static void main(String args[]){ } }

向数据库添加新的学生信息：

Sql app=new Sql(); app.jiemian();

J_ActionListener11 a11=new J_ActionListener11();

n.add(b1);n.add(b2);n.add(b3);n.add(b4);n.add(b5);n.add(b6); n.add(b7);n.add(b8);n.add(b9);n.add(b10);n.add(aaa);n.add(aaa1);

n.add(b11);n.add(b12);b1.addActionListener(a1);b2.addActionListener(a2); b3.addActionListener(a3);b4.addActionListener(a4);b5.addActionListener(a5);

b6.addActionListener(a7);b7.addActionListener(a8);b8.addActionListener(a9);

b9.addActionListener(a10); b11.addActionListener(a1)b12.addActionListener(a12);

b10.addActionListener(new ActionListener() { public void actionPerformed(final ActionEvent e) }

else{ JOptionPane.showMessageDialog( null ,\教师ID或密码有误！请重新输入！\) ; } }

catch(Exception e1)

{ e1.printStackTrace(); }

{ System.exit(0); }

});

((JComponent) mmm.getContentPane()).setOpaque(false); ImageIcon img = new ImageIcon(url); JLabel background = new JLabel(img);

mmm.getLayeredPane().add(background, new Integer(Integer.MIN_VALUE)); background.setBounds(0, 0, img.getIconWidth(), img.getIconHeight());

java.net.URL url = Sql.class.getResource(\未命名.jpg\);

class DataBase{ // DataBase类

public void Add(String xh,String xm,String xb,String bj,String jg,String mm) throws SQLException { //为学籍管理系统添加新记录 try {

Class.forName(\);

Connection c=DriverManager.getConnection(\学生信息系统\); Statement s=c.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,

ResultSet.CONCUR_UPDATABLE);

ResultSet r=s.executeQuery(\学籍信息表 where 学号='\+xh+\); r.last();

if(r.getRow()==1) { JOptionPane.showMessageDialog( null ,\该学号的学生信息已存在\);} Else if(xh.equals(\)){ //判断新输入的学号是否为空

JOptionPane.showMessageDialog( null ,\学号不能为空\);}

else{ s.executeUpdate(\学籍信息表 values ('\+xh+\+xm+\+xb+\+ bj+\+jg+\+mm+\);

s.close();c.close();

２５

苏州大学本科生课程设计

JOptionPane.showMessageDialog( null ,\+\学号:\+xh+\+\姓名:\+xm+\ +\性别:\+xb+\+\班级号:\+bj+\ +\籍贯:\+jg+\

+\登录密码:\+mm+\学生记录添加成功！\ ) ; } }

{JOptionPane.showMessageDialog( null , \数据添加异常！\ ) ;} }

public void DisplayAll(ResultSet r){ JFrame m=new JFrame(\显示所有学生信息\); m.setBounds(60,70,700,600);

m.setVisible(true);

JTextArea aa=new JTextArea(); aa.setBounds(0,0,700,600); Container c1=m.getContentPane(); c1.setLayout(null); c1.add(aa);

catch (ClassNotFoundException e)

try{ r.last();

aa.append(\学号\+\+\姓名\+\+\性别\+\+\班级\+\+\籍贯\+\); r.beforeFirst();

public void DisplayOne(String str22) throws Exception { try

{ Connection c=DriverManager.getConnection(\学生信息系统\); Statement s=c.createStatement(

ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);

while(r.next())

{ aa.append(\第\+r.getRow()+\行记录: \);

aa.append(r.getString(\学号\)); aa.append(\+r.getString(\姓名\)); aa.append(\+r.getString(\性别\)); aa.append(\+r.getString(\班级\));

aa.append(\+r.getString(\籍贯\)+\); } }

catch(Exception e)

{ e.printStackTrace();} }

ResultSet r=s.executeQuery(\学号 ,姓名,性别, 班级名称 as 班

级,籍贯 from 学籍信息表 join 班级信息表 on 班级信息表.班级号=学籍信息表.班级号 where 学号='\+str22+\); //执行查询的SQL语句

r.last();

int cc=r.getRow();

if(cc==0)

{ JOptionPane.showMessageDialog( null ,\未查询到相关信息！\ ) ; } else{r.beforeFirst();

while(r.next())

２６

苏州大学本科生课程设计

public void DeleteXh(String str11) //执行按学号删除学生记录的操作 { try

{ Class.forName(\);

Connection c=DriverManager.getConnection(\学生信息系统\); Statement s=c.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE,

ResultSet.CONCUR_UPDATABLE);

{ JOptionPane.showMessageDialog( null ,\+\学

号:\+r.getString(\学号\)+\+\姓名:\+r.getString(\姓名\)+\

+\性别:\+r.getString(\性别\)+\ +\班级:\+r.getString(\班级\)+\ +\籍贯:\+r.getString(\籍贯\)+\已查询到相关记录！\ ) ; } } } catch(Exception e)

{ e.printStackTrace();}}

ResultSet r=s.executeQuery(\* from 学籍信息表 where 学号='\+str11+\); r.last();

if(r.getRow()==1){

s.executeUpdate(\学籍信息表 where 学号='\+str11+\); JOptionPane.showMessageDialog( null , \学生记录删除成功！\ ) ;

} else { JOptionPane.showMessageDialog( null ,\学籍系统中并无相关记录！\ ); } }

catch(Exception e) { } }

public void DeleteXm(String str13) //执行按姓名删除学生记录的操作 { try

{Class.forName(\);

Connection c=DriverManager.getConnection(\学生信息系统\); Statement s=c.createStatement(

ResultSet.TYPE_SCROLL_SENSITIVE,

ResultSet.CONCUR_UPDATABLE);

ResultSet r=s.executeQuery(\学籍信息表 where 姓名='\+str13+\); r.last();

if(r.getRow()==1) {s.executeUpdate(\学籍信息表 where 姓名='\+str13+\);

JOptionPane.showMessageDialog( null , \学生记录删除成功！\ ) ;}

else{ JOptionPane.showMessageDialog( null ,\学籍系统中并无相关记录！\ ) ; } }

catch(Exception e) { } }

public void UpdateXh(String xg,String str15,String str16) {

try {

Class.forName(\);

２７

苏州大学本科生课程设计

Connection c=DriverManager.getConnection(\学生信息系统\); Statement s=c.createStatement(

ResultSet.TYPE_SCROLL_SENSITIVE,

ResultSet.CONCUR_UPDATABLE);

ResultSet r=s.executeQuery(\学籍信息表 where 学号='\+xg+\); r.last();

if(r.getRow()==1)

{ s.executeUpdate(\学籍信息表 set

\+str15+\+str16+\学号='\+xg+\); //直接执行SQL语句修改

JOptionPane.showMessageDialog( null , \学生记录修改成功！\ ) ; } else{

JOptionPane.showMessageDialog( null ,\学籍系统中并无相关记录！\ ) ; }; }

catch(Exception e)

{ JOptionPane.showMessageDialog( null ,\学籍系统中并无相关记录！\ ) ; } } try {

Class.forName(\);

Connection c=DriverManager.getConnection(\学生信息系统\); Statement s=c.createStatement(

ResultSet.TYPE_SCROLL_SENSITIVE,

ResultSet.CONCUR_UPDATABLE);

ResultSet r=s.executeQuery(\学籍信息表 where

public void UpdateXm(String str18,String str19,String str20) {

姓名='\+str18+\); r.last();

if(r.getRow()==1)

{ s.executeUpdate(\学籍信息表 set

\+str19+\+str20+\姓名='\+str18+\); //直接执行SQL语句修改

JOptionPane.showMessageDialog( null , \学生记录修改成功！\ ) ; } else{

JOptionPane.showMessageDialog( null ,\学籍系统中并无相关记录！\ ) ;

}; }

catch(Exception e)

{JOptionPane.showMessageDialog( null ,\学籍系统中并无相关记录！\ ) ; }}

public void AddScore(String xh,String kch, String cj){ try {

Class.forName(\);

Connection c=DriverManager.getConnection(\学生信息系统\); Statement s=c.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE,

ResultSet.CONCUR_UPDATABLE);

２８