java1概要1.doc

import?javax.swing.*;? import?java.awt.BorderLayout;?import?java.awt.Container;?import?java.awt.FlowLayout;?import?java.awt.event.ActionEvent;?import?java.awt.event.ActionListener;?import?java.sql.*;?? class?DataBase{????????//??DataBase类?? public?void?Add(String?xh,String?xm,String?xb,String?xy,String?bj,String?jg)?throws?SQLException?{????????? 牋?btry?{??? ? Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);? Connection?c=DriverManager.getConnection(jdbc:odbc:studentdatabase);??????????Statement?s=c.createStatement(???????????ResultSet.TYPE_SCROLL_SENSITIVE,? 牋?C ? ResultSet.CONCUR_UPDATABLE);? ?ResultSet?r=s.executeQuery(select?*?from?学籍管理系统where?学号=+xh+);? ?????????r.last();??? ?????????if(r.getRow()==1)?????????????????????????????????????????????????????? ???{??JOptionPane.showMessageDialog(?null?,该学号的学生信息已存在);}??????????????????else?if(xh.equals()){?????????? ??????JOptionPane.showMessageDialog(?null?,学号不能为空);}???????????????? ???????????? ????????else{?s.executeUpdate(?insert?into?学籍管理系统??values?(+xh+,+xm+,+xb+,+?xy+,+bj+,+jg+));????? ??????????????s.close();???????????????c.close();???JOptionPane.showMessageDialog(?null?,html+学号:+xh+br??????????? ? ? ? ?????????? ???+姓名:+xm+br? ??+性别:+xb+br +学院:+xy+br?+班级:+bj+br? +籍贯:+jg+br?学生记录添加成功！?)??}?????????}? catch(Exception?e)???????????????????????????????????????????????????????????{JOptionPane.showMessageDialog(?null?,?数据添加异常！?)?}?????????}?????Public??void??DisplayAll(ResultSet??r){???????? ????try{???????????r.last();? ??????System.out.println(数据库表共有+r.getRow()+行记录);?????????? ????????r.beforeFirst();? ??????while(r.next())???????{??????????System.out.print(第+r.getRow()+行记录:);???????System.out.print(?学号为：+r.getString(学号));???????System.out.print(?姓名为：+r.getString(姓名));???????System.out.print(?性别为：+r.getString(性别));???????System.out.print(?学院为：+r.getString(学院));???????System.out.print(?班级为：+r.getString(班级));????? ??System.out.println(?籍贯为：+r.getString(籍贯));? ??? ???}???? ?????????}? ????catch(Exception?e)??? ??{????}?