数据库课程设计宿舍信息管理系统 - 图文(4)

}

}

}

vc.add(s1);

String s2=rs.getString(\); vc.add(s2);

String s3=rs.getString(\); vc.add(s3);

String s4=rs.getString(\); vc.add(s4);

String s5=rs.getString(\); vc.add(s5);

String s6=rs.getString(\); vc.add(s6);

String s7=rs.getString(\); vc.add(s7);

String s8=rs.getString(\); vc.add(s8);

}catch(SQLException e){

System.out.print(e);

return vc;

/*## 修改宿舍楼信息*/

Vector update_Dor(String a) { }

/*删除学生信息*/

Vector delete_Student(String s) {

Vector vc=new Vector(); try{

sql12=con.prepareStatement(\Vector vc=new Vector(); try{

sql7=con.prepareStatement(\); }catch(SQLException e){System.out.print(e);} return vc;

StuNo=\+\+s+\);

package fc; import java.io.*; import java.sql.*; import java.util.Vector; import javax.swing.*;

import javax.swing.border.MatteBorder; import java.awt.*; import java.awt.event.*;

public class Insert_W_D extends Dialog implements WindowListener,ActionListener {

private TextField t1,t2,t3,t4,t5,t6,t7,t8; private Button b1,b2;

public Insert_W_D (Frame owner) {

super(owner);

this.setTitle(\增加新楼管\this.setBounds(100,100,800,300); setLayout(new BorderLayout()); Panel p=new Panel();

//p.setLayout (new FlowLayout(FlowLayout.CENTER)); p.setLayout (new FlowLayout(FlowLayout.CENTER,20,20)); Label m1=new Label(\楼管编号：\p.add(m1);

t1=new TextField(15); p.add(t1);

m1=new Label(\楼管姓名：\p.add(m1);

t2=new TextField(15); p.add(t2);

m1=new Label(\工作类型：\p.add(m1);

t3=new TextField(15); p.add(t3);

m1=new Label(\月工资：\ }

sql12.executeUpdate();

}catch(SQLException e){System.out.print(e);} return vc;

}

p.add(m1);

t4=new TextField(15); p.add(t4);

m1=new Label(\性别:\p.add(m1);

t5=new TextField(15); p.add(t5);

m1=new Label(\电话：\p.add(m1);

t6=new TextField(15); p.add(t6);

m1=new Label(\工作时间：\p.add(m1);

t7=new TextField(15); p.add(t7);

m1=new Label(\楼栋：\p.add(m1);

t8=new TextField(15); p.add(t8);

add(p,BorderLayout.CENTER);

Panel p2=new Panel();

p2.setLayout(new FlowLayout(FlowLayout.RIGHT)); this.b1=new Button(\确定\this.b1.addActionListener(this); this.b2=new Button(\取消\this.b2.addActionListener(this); p2.add(b1);

p2.add(Box.createHorizontalStrut(20)); p2.add(b2);

p2.add(Box.createHorizontalStrut(20)); add(p2,BorderLayout.SOUTH);

this.addWindowListener(new WindowAdapter() {

public void windowClosing(WindowEvent e) { } });

dispose();

public void actionPerformed(ActionEvent e) { }

public void windowActivated(WindowEvent e) { }

public void windowClosed(WindowEvent e) { }

public void windowClosing(WindowEvent e) { }

public void windowDeactivated(WindowEvent e) { }

public void windowDeiconified(WindowEvent e) { }

public void windowIconified(WindowEvent e) {

// TODO Auto-generated method stub // TODO Auto-generated method stub

// TODO Auto-generated method stub

// TODO Auto-generated method stub dispose();

// TODO Auto-generated method stub dispose();

// TODO Auto-generated method stub

if(b1==e.getSource()){ } dispose();

String f1=t1.getText(); String f2=t2.getText(); String f3=t3.getText(); String f4=t4.getText(); String f5=t5.getText(); String f6=t6.getText(); String f7=t7.getText(); String f8=t8.getText();

DBconnect1 b11=new DBconnect1();

Vector vc=b11.insert_Worker(f1, f2, f3, f4, f5, f6, f7, f8);

}

}

public void windowOpened(WindowEvent e) { }

// TODO Auto-generated method stub