instu.java~33~

java语言写的

package scoremis;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
import java.util.Date;
import java.io.File;
import javax.swing.border.*;

public class Instu extends JPanel{
  public Instu() {
    try {
      jbInit();
}catch (Exception exception) {exception.printStackTrace() ;}
}
private void jbInit() throws Exception {
    titledBorder1 = new TitledBorder("");
    titledBorder2 = new TitledBorder("");
    this.setLayout(null);
    jLabel1.setFont(new java.awt.Font("Dialog", 1, 22));
    jLabel1.setBounds(new Rectangle(117, 7, 189, 32));//设置各组件的位置
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel2.setBounds(new Rectangle(59, 52, 104, 37));
    sid.setFont(new java.awt.Font("Dialog", 0, 12));
    sid.setBounds(new Rectangle(123, 56, 109, 28));
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel3.setBounds(new Rectangle(59, 97, 102, 28));
    sname.setFont(new java.awt.Font("Dialog", 0, 12));
    sname.setBounds(new Rectangle(123, 99, 109, 27));
    sex1.setFont(new java.awt.Font("Dialog", 0, 12));
    sex1.setBounds(new Rectangle(130, 140, 49, 29));
    sex2.setFont(new java.awt.Font("Dialog", 0, 12));
    sex2.setBounds(new Rectangle(198, 140, 59, 25));
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel4.setBounds(new Rectangle(59, 167, 76, 37));
    syear.setFont(new java.awt.Font("Dialog", 0, 12));
    syear.setBounds(new Rectangle(123, 174, 57, 25));
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel5.setBounds(new Rectangle(184, 172, 31, 27));
    smonth.setFont(new java.awt.Font("Dialog", 0, 12));
    smonth.setBounds(new Rectangle(205, 174, 59, 25));
    jLabel6.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel6.setBounds(new Rectangle(271, 172, 39, 26));
    sdate.setFont(new java.awt.Font("Dialog", 0, 12));
    sdate.setBounds(new Rectangle(302, 176, 57, 25));
    jLabel7.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel7.setBounds(new Rectangle(365, 172, 46, 27));
    jLabel8.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel8.setBounds(new Rectangle(58, 213, 65, 30));
    sgreade.setFont(new java.awt.Font("Dialog", 0, 12));
    sgreade.setBounds(new Rectangle(122, 215, 162, 26));
    jLabel9.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel9.setBounds(new Rectangle(59, 253, 67, 33));
    photo.setFont(new java.awt.Font("Dialog", 0, 12));
    photo.setBorder(BorderFactory.createLoweredBevelBorder());
    photo.setBounds(new Rectangle(123, 258, 160, 26));
    scan.setBounds(new Rectangle(300, 258, 68, 26));
    scan.setFont(new java.awt.Font("Dialog", 0, 12));
    con.setBounds(new Rectangle(251, 299, 82, 29));
    con.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel10.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel10.setBounds(new Rectangle(59, 139, 66, 29));
    sure.setBounds(new Rectangle(102, 299, 82, 29));
    sure.setFont(new java.awt.Font("Dialog", 0, 12));
    photoshow.setFont(new java.awt.Font("Dialog", 0, 12));
    photoshow.setBorder(titledBorder2);
    photoshow.setDisabledIcon(null);
    photoshow.setIcon(null);
    photoshow.setText("照片");
    photoshow.setBounds(new Rectangle(265, 49, 95, 113));//添加各组件
    sex.add(sex1);sex.add(sex2);
    this.add(jLabel3);this.add(sname);
    this.add(jLabel2);this.add(sid);
    this.add(jLabel10);this.add(sex1);this.add(sex2);
    this.add(jLabel4);this.add(syear);this.add(jLabel5);this.add(smonth);
    this.add(sdate);this.add(jLabel6);
    this.add(jLabel7);this.add(jLabel8);
    dbconn db= new dbconn();
    ResultSet rs=db.Query("select distinct Cgreade from T_C");
    sgreade.addItem("" );
    while (rs.next()){
      sgreade.addItem(rs.getString(1) );
    }
    this.add(sgreade);
    this.add(jLabel9);this.add(photo);this.add(scan);
    this.add(con);this.add(sure);
    this.add(photoshow);
    this.add(jLabel1);
    sure.addActionListener(new Handel());//给各按钮添加事件监视器
    con.addActionListener(new Handel());
    scan.addActionListener(new Handel());
    }
    class Handel implements ActionListener{//事件处理类
    public void actionPerformed(ActionEvent e) {
    dbconn db=new dbconn();
    if(e.getSource()==sure){//处理"添加"按钮
      String xh=sid.getText();
      String xm=sname.getText();
      String year=syear.getText();
      String month=smonth.getText();
      String day=sdate.getText();
      String bj=(String)sgreade.getSelectedItem();
      Date brith = java.sql.Date.valueOf(year + "-" + month + "-" + day);
      String xb = "女";
      if(sex1.isSelected())
        xb = "男";
      String zp = photo.getText();
      String sql = "insert into student(ID,name,sex,birthday,greade,photo) values('"+xh+"','"+xm+"','"+xb+"',#"+brith+"#,'"+bj+"','"+zp+"')";
      int i=db.Update(sql);
      if(i>0)
      JOptionPane.showMessageDialog(null,"添加成功!!");
      else
      JOptionPane.showMessageDialog(null,"添加失败!!");
      }else if(e.getSource()==con){//处理"继续"按钮
        sid.setText("");
        sname.setText("");
        syear.setText("");
        smonth.setText("");
        sdate.setText("");
        photo.setText("");
      }else if(e.getSource()==scan){//处理"浏览"按钮
        JFileChooser cfile= new JFileChooser();
        cfile.showDialog(null,"打开");
        File f=cfile.getSelectedFile();
        String lj=f.getAbsolutePath();
        photo.setText(lj);
        photoshow.setIcon(new ImageIcon(f.toString()));
        }
     db.close();
    }
    }
  JLabel jLabel1= new JLabel("学 生 信 息 录 入");
  JLabel jLabel2=new JLabel("学号:");
  JTextField sid=new JTextField();
  JLabel jLabel3=new JLabel("姓名:");
  JTextField sname=new JTextField();
  ButtonGroup sex=new ButtonGroup();
  JRadioButton sex1=new JRadioButton("男");
  JRadioButton sex2=new JRadioButton("女");
  JLabel jLabel4=new JLabel("出生日期:");
  JTextField syear=new  JTextField();
  JLabel jLabel5=new JLabel("年");
  JTextField smonth= new JTextField();
  JLabel jLabel6= new JLabel("月");
  JTextField sdate= new JTextField();
  JLabel jLabel7= new JLabel("日");
  JLabel jLabel8= new JLabel("班级");
  JComboBox sgreade= new JComboBox();
  JLabel jLabel9= new JLabel("照片:");
  JTextField photo=new JTextField();
  JButton scan= new JButton("浏览");
  JButton sure= new JButton("添加");
  JButton con= new JButton("继续");
  JLabel jLabel10= new JLabel("性别:");
  JLabel photoshow= new JLabel(new ImageIcon());
  TitledBorder titledBorder1;
  TitledBorder titledBorder2;
  }