java删除学生成绩记录_chengjicaxun.java 源代码在线查看 - 学生成绩管理系统可以查询修改成绩 修改密码 删除填加成绩 资源下载 虫虫电子下载站...

}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}//System.out.println(x);}}else if(jrb2.isSelected()){if((t2==null||t2.getText().equals(""))){JOptionPane.showMessageDialog(null,"对不起，您没有没有输入姓名，无法完成查询！","不合法",JOptionPane.ERROR_MESSAGE);}else{if(jcb.getSelectedItem().equals("第一学期")){String sql1="select * from term1 where sname='" + b + "'";ResultSet rs1=db.executeQuery(sql1);try {while(rs1.next()){sno=rs1.getString(1);sname=rs1.getString(2);smath=rs1.getString(3);senglish=rs1.getString(4);schinese=rs1.getString(5);String[] row={sno,sname,smath,senglish,schinese};md.addRow(row);return;}if(!rs1.next()){JOptionPane.showMessageDialog(null,"对不起，您输入的姓名没有记录，无法完成查询！","不合法",JOptionPane.ERROR_MESSAGE);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}else if(jcb.getSelectedItem().equals("第二学期")){String sql1="select * from term2 where sname='" + b + "'";ResultSet rs1=db.executeQuery(sql1);try {while(rs1.next()){sno=rs1.getString(1);sname=rs1.getString(2);smath=rs1.getString(3);senglish=rs1.getString(4);schinese=rs1.getString(5);String[] row={sno,sname,smath,senglish,schinese};md.addRow(row);return;}if(!rs1.next()){JOptionPane.showMessageDialog(null,"对不起，您输入的姓名没有记录，无法完成查询！","不合法",JOptionPane.ERROR_MESSAGE);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}}else if(jrb4.isSelected()) //下拉列表项的选择，置第一项为已选{if(jcb.getSelectedItem().equals("第一学期")){if(jcb1.getSelectedItem().equals("数学")){String sql4="select * from term1";ResultSet rs4=db.executeQuery(sql4);try {while(rs4.next()){sno=rs4.getString(1);sname=rs4.getString(2);smath=rs4.getString(3);//senglish=rs4.getString(4);//schinese=rs4.getString(5);String[] row={sno,sname,smath,null,null};md.addRow(row);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}else if(jcb1.getSelectedItem().equals("英语")){String sql７="select * from term1";ResultSet rs７=db.executeQuery(sql７);try {while(rs７.next()){sno=rs７.getString(1);sname=rs７.getString(2);smath=rs７.getString(3);senglish=rs７.getString(4);schinese=rs７.getString(5);String[] row={sno,sname,null,senglish,null};md.addRow(row);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}else if(jcb1.getSelectedItem().equals("语文")){String sql8="select * from term1";ResultSet rs8=db.executeQuery(sql8);try {while(rs8.next()){sno=rs8.getString(1);sname=rs8.getString(2);smath=rs8.getString(3);senglish=rs8.getString(4);schinese=rs8.getString(5);String[] row={sno,sname,null,null,schinese};md.addRow(row);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}if(jcb.getSelectedItem().equals("第二学期")){if(jcb1.getSelectedItem().equals("数学")){String sql9="select * from term2";ResultSet rs9=db.executeQuery(sql9);try {while(rs9.next()){sno=rs9.getString(1);sname=rs9.getString(2);smath=rs9.getString(3);senglish=rs9.getString(4);schinese=rs9.getString(5);String[] row={sno,sname,smath,null,null};md.addRow(row);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}else if(jcb1.getSelectedItem().equals("英语")){String sql10="select * from term2";ResultSet rs10=db.executeQuery(sql10);try {while(rs10.next()){sno=rs10.getString(1);sname=rs10.getString(2);smath=rs10.getString(3);senglish=rs10.getString(4);schinese=rs10.getString(5);String[] row={sno,sname,null,senglish,null};md.addRow(row);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}else if(jcb1.getSelectedItem().equals("语文")){String sql11="select * from term2";ResultSet rs11=db.executeQuery(sql11);try {while(rs11.next()){sno=rs11.getString(1);sname=rs11.getString(2);smath=rs11.getString(3);senglish=rs11.getString(4);schinese=rs11.getString(5);String[] row={sno,sname,null,null,schinese};md.addRow(row);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}}}else{//JOptionPane.showMessageDialog(null,"对不起，您没有选择查询方式，无法完成查询！","不合法",JOptionPane.ERROR_MESSAGE);if(jcb.getSelectedItem().equals("第一学期")){String sql5="select * from term1";ResultSet rs5=db.executeQuery(sql5);try {while(rs5.next()){sno=rs5.getString(1);sname=rs5.getString(2);smath=rs5.getString(3);senglish=rs5.getString(4);schinese=rs5.getString(5);String[] row={sno,sname,smath,senglish,schinese};md.addRow(row);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}else if(jcb.getSelectedItem().equals("第二学期")){String sql6="select * from term2";ResultSet rs6=db.executeQuery(sql6);try {while(rs6.next()){sno=rs6.getString(1);sname=rs6.getString(2);smath=rs6.getString(3);senglish=rs6.getString(4);schinese=rs6.getString(5);String[] row={sno,sname,smath,senglish,schinese};md.addRow(row);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}}}}public static void main(final String[] args){new Chengjicaxun().setVisible(true);}}