import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.io.*;
import java.sql.*;
public class addrecord extends JFrame implements ActionListener
{
public static void main(String[] args)
{
addrecord frame=new addrecord();
}
JLabel lb;
JLabel lb1[]=new JLabel[8];
JTextField tf1[]=new JTextField[8];
String fieldname[]={"房号","系别","专业","年级","班别","姓名","电话"};
String fieldvalue[]={"103","体社系","体保","03","","郑晓强、张昱、邓炳南、陈荣亮","5243472"};
JButton bu1;
JTextArea ta1;
Connection con1;
ResultSet rs1;
Statement st1;
String str1="";
String pp="2号楼住宿花名册";
private JComboBox jobsBox;
public addrecord()
{
setTitle("全校学生住宿花名册添加");
Container c=getContentPane();
JPanel p=new JPanel();
c.setLayout(null);
lb=new JLabel("添加数据操作");
lb.setSize(200,20);
lb.setLocation(10,20);
c.add(lb);
bu1=new JButton("添加记录");
bu1.setSize(100,20);
bu1.setLocation(260,20);
bu1.addActionListener(this);
c.add(bu1);
jobsBox=new JComboBox();
jobsBox.addItem("2号楼住宿花名册");
jobsBox.addItem("3号楼住宿花名册");
jobsBox.addItem("5号楼住宿花名册");
jobsBox.addItem("7号楼住宿花名册");
jobsBox.addItem("8号楼住宿花名册");
jobsBox.addItem("13号楼住宿花名册");
jobsBox.addItem("14号楼住宿花名册");
jobsBox.addItem("明煌楼学生住宿花名册");
jobsBox.addItem("学生公寓楼住宿花名册");
jobsBox.addActionListener(this);
p.add(jobsBox);
p.setSize(200,40);
p.setLocation(10,50);
c.add(p);
for(int i=0;i<7;i++)
{
lb1[i]=new JLabel(fieldname[i]);
lb1[i].setSize(80,20);
lb1[i].setLocation(10,120+i*30);
c.add(lb1[i]);
tf1[i]=new JTextField(fieldvalue[i]);
tf1[i].setSize(90,20);
tf1[i].setLocation(120,120+i*30);
c.add(tf1[i]);
}
setSize(500,400);
setVisible(true);
connect_db();
}
public void connect_db()
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e1)
{System.out.println("Driver not found!");}
try{
con1=DriverManager.getConnection("jdbc:odbc:student");
st1=con1.createStatement();
}
catch(SQLException e2)
{System.out.println("table not found!");}
}
public void actionPerformed(ActionEvent e)
{
String std_fanghao=tf1[0].getText();
String std_xibie=tf1[1].getText();
String std_zhuanye=tf1[2].getText();
String std_grade=tf1[3].getText();
String std_class=tf1[4].getText();
String std_name=tf1[5].getText();
String std_tel=tf1[6].getText();
pp=jobsBox.getSelectedItem().toString();
try
{
if(e.getSource()==bu1)
{
str1="INSERT INTO "+pp+" VALUES('"+std_fanghao+"','"+std_xibie+"','"+std_zhuanye+"','"+std_grade+"','"+std_class+"','"+std_name+"','"+std_tel+"')";
st1.executeUpdate(str1);
JOptionPane.showMessageDialog(null,"添加成功！");
}
else
{
}
}
catch(SQLException e2)
{JOptionPane.showMessageDialog(null,"添加失败！");}
}
}
