try { con = DriverManager.getConnection(\ba\
sql = con.createStatement();
rs=sql.executeQuery(\* from gly where glname='\
while(rs.next()){
power=rs.getString(\ }
rs=null;
if(power.equals(\
rs=sql.executeQuery(\* from yg where no='\ if(rs.next()){
String updateStr = \ yg SET jt='\2.getText()+\ sql.executeUpdate(updateStr);
JOptionPane.showMessageDialog(this, \修改成功！\
tf1.setText(\Text(\
chaxun(); //chaxun(); con.close(); }
else{
JOptionPane.showMessageDialog(this, \查无此人\
tf1.setText(\Text(\
} }
else{
JOptionPane.showMessageDialog(this, \权限不足，不能操作！\
tf1.setText(\Text(\
}
con.close(); sql.close();
} catch (SQLException e1) {
JOptionPane.showMessageDialog(this, \信息不错
14
误或不完整！\ } }
if (b3.equals(e.getSource())) {// 删除 Connection con; Statement sql; ResultSet rs; try {
Class.forName(\ } catch (ClassNotFoundException e1) { System.out.println(\ }
try { con = DriverManager.getConnection(\ba\ sql = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.TYPE_SCROLL_SENSITIVE);
rs=sql.executeQuery(\* from gly where glname='\
System.out.println(\ while(rs.next()){
power=rs.getString(\ }
rs=null;
if(power.equals(\
rs=sql.executeQuery(\* from yg where no='\ if(rs.next()){
sql.executeUpdate(\ FROM yg where no='\
//sql.executeUpdate(\FROM yg where no='\
JOptionPane.showMessageDialog(this, \删除成功！\
tf6.setText(\ chaxun(); }
else{
JOptionPane.showMessageDialog(this,\查无此人\
tf6.setText(\ }
15
}
else{
JOptionPane.showMessageDialog(this, \权限不足，不能操作！\
tf6.setText(\ }
con.close(); sql.close();
} catch (SQLException e1) {
JOptionPane.showMessageDialog(this, \删除失败！\ } }
if (b4.equals(e.getSource())) {// 查询全部 chaxun=\ chaxun(); }
if(b6.equals(e.getSource())){//查询单条信息 Connection con; Statement sql; ResultSet rs;
//Vector vector = new Vector(); try {
Class.forName(\ } catch (ClassNotFoundException e1) {
JOptionPane.showMessageDialog(this, \连接数据库失败！\ }
try { con = DriverManager.getConnection(\ba\ sql = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.TYPE_SCROLL_SENSITIVE);
rs=sql.executeQuery(\* from yg where no='\ if(rs.next()){
for (int i = 0; i < 50; i++) for (int j = 0; j < 4; j++) table.setValueAt(\ rs = sql.executeQuery(\no,name,jbgz,jt from yg where
16
no='\ int k = 0;
while (rs.next()) {
String no = rs.getString(1); String name = rs.getString(2); String jbgz = rs.getString(3); String jt = rs.getString(4);
//int sum= rs.getInt(3)+rs.getInt(4); table.setValueAt(no, k, 0); table.setValueAt(name, k, 1); table.setValueAt(jbgz, k, 2); table.setValueAt(jt, k, 3); tf6.setText(\ } }
else{
JOptionPane.showMessageDialog(this,\查无此人\
tf6.setText(\ }
//table.setValueAt(sum,k,4); //}
con.close(); sql.close();
} catch (SQLException e1) {
JOptionPane.showMessageDialog(this, \查询失败！\ } }
if (b5.equals(e.getSource())) {// 返回 GZGLZJM gl=new GZGLZJM(name); gl.create(); this.dispose(); f.dispose();
} } }
public void actionPerformed(ActionEvent e) {
17
if (b1.equals(e.getSource())) {// 查询个人工资 Connection con; Statement sql; ResultSet rs; try {
Class.forName(\ } catch (ClassNotFoundException e1) { System.out.println(\ }
try { con = DriverManager.getConnection(\ba\ sql = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs = sql.executeQuery(\ no,name,jt,jbgz from yg where name='\ int k = 0;
for (int i = 0; i < 50; i++) for (int j = 0; j < 4; j++) table.setValueAt(\ //System.out.println(t1); while (rs.next()) {
String no = rs.getString(1); String name = rs.getString(2); String jbgz = rs.getString(4); String jt = rs.getString(3);
int sum= rs.getInt(3)+rs.getInt(4); table.setValueAt(no, k, 0); table.setValueAt(name, k, 1); table.setValueAt(jbgz, k, 3); table.setValueAt(jt, k, 2); table.setValueAt(sum,k,4); }
con.close(); sql.close();
} catch (SQLException e1) {
JOptionPane.showMessageDialog(this, \查询失败！\ } }
if (b2.equals(e.getSource())) {// 修改密码
18