searchframe.java

本光盘包含了本书各章中出现的所有程序的源代码。 1. 如果是Java程序

package com.function;

import java.awt.Container;
import java.awt.Dimension;
import java.awt.Font;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JSplitPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.ListSelectionModel;
import javax.swing.UIManager;
import javax.swing.event.ListSelectionEvent;
import javax.swing.event.ListSelectionListener;

public class SearchFrame extends JFrame implements ActionListener,ListSelectionListener{
	//新建模块
	private JFrame createFrame;
	//删除模块
	private JFrame deleteFrame;
	//修改模块
	private JFrame changeFrame;
	private Student student;
	//用于保存查询结果
	private Vector students;
	//用于记录选中的是表格中的第几条记录
	private int selected=0;
	//数据库操作模块
	private DBUnit db;
	private JLabel id;
	private JTextField idText;
	private JLabel name;
	private JTextField nameText;
	private JLabel gander;
	private JTextField ganderText;
	private JLabel major;
	private JTextField majorText;
	private JLabel grade;
	private JTextField gradeText;
	private JLabel address;
	private JTextField addressText;
	private JLabel telephone;
	private JTextField telephoneText;
	private JButton searchButton;
	private JButton createButton;
	private JButton deleteButton;
	private JButton changeButton;
	private JButton clearButton;
	private JButton cancel;
	private Container contentPane;
	private JPanel jPanel1;
	private JSplitPane jSplitPane;
	private JTable jTable;
	private JScrollPane jScrollPane;
	private ListSelectionModel selectionMode;
	
	public SearchFrame() {
		try {
    //设置显示外观为本地系统外观，注意此句需放在初始化所有控件之前
		UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());
		} catch (Exception e) {
			e.printStackTrace();
		}
		initComponents();
	}
	
	private void initComponents() {
		contentPane=getContentPane();
		jPanel1=new JPanel();
		jPanel1.setLayout(null);
		
		
		id=new JLabel();
		id.setText("学号");
		id.setFont(new Font("",Font.BOLD,15));
		id.setBounds(100, 20, 100, 30);
		jPanel1.add(id);
		
		idText=new JTextField();
		idText.setBounds(200, 20, 100, 30);
		jPanel1.add(idText);
		
		name=new JLabel();
		name.setText("姓名");
		name.setFont(new Font("",Font.BOLD,15));
		name.setBounds(100, 70, 100, 30);
		jPanel1.add(name);
		
		nameText=new JTextField();
		nameText.setBounds(200, 70, 100, 30);
		jPanel1.add(nameText);
		
		gander=new JLabel();
		gander.setText("性别");
		gander.setFont(new Font("",Font.BOLD,15));
		gander.setBounds(100, 120, 100, 30);
		jPanel1.add(gander);
		
		ganderText=new JTextField();
		ganderText.setBounds(200, 120, 100, 30);
		jPanel1.add(ganderText);
		
		major=new JLabel();
		major.setText("专业");
		major.setFont(new Font("",Font.BOLD,15));
		major.setBounds(100, 170, 100, 30);
		jPanel1.add(major);
		
		majorText=new JTextField();
		majorText.setBounds(200, 170, 100, 30);
		jPanel1.add(majorText);
		
		grade=new JLabel();
		grade.setText("班级");
		grade.setFont(new Font("",Font.BOLD,15));
		grade.setBounds(100, 220, 100, 30);
		jPanel1.add(grade);
		
		gradeText=new JTextField();
		gradeText.setBounds(200, 220, 100, 30);
		jPanel1.add(gradeText);
		
		telephone=new JLabel();
		telephone.setText("联系电话");
		telephone.setFont(new Font("",Font.BOLD,15));
		telephone.setBounds(100, 270, 100, 30);
		jPanel1.add(telephone);
		
		telephoneText=new JTextField();
		telephoneText.setBounds(200, 270, 100, 30);
		jPanel1.add(telephoneText);
		
		address=new JLabel();
		address.setText("家庭住址");
		address.setFont(new Font("",Font.BOLD,15));
		address.setBounds(100, 320, 100, 30);
		jPanel1.add(address);
		
		addressText=new JTextField();
		addressText.setBounds(200, 320, 200, 30);
		jPanel1.add(addressText);
		
		searchButton=new JButton("查询");
		searchButton.setFont(new Font("",Font.BOLD,15));
		searchButton.setBounds(550, 20, 100, 30);
		searchButton.addActionListener(this);
		jPanel1.add(searchButton);
		
		createButton=new JButton("新建");
		createButton.setFont(new Font("",Font.BOLD,15));
		createButton.setBounds(550, 80, 100, 30);
		createButton.addActionListener(this);
		jPanel1.add(createButton);
		
		changeButton=new JButton("修改");
		changeButton.setFont(new Font("",Font.BOLD,15));
		changeButton.setBounds(550, 140, 100, 30);
		changeButton.setEnabled(false);
		changeButton.addActionListener(this);
		jPanel1.add(changeButton);
		
		deleteButton=new JButton("删除");
		deleteButton.setFont(new Font("",Font.BOLD,15));
		deleteButton.setBounds(550, 200, 100, 30);
		deleteButton.setEnabled(false);
		deleteButton.addActionListener(this);
		jPanel1.add(deleteButton);
		
		clearButton=new JButton("清空");
		clearButton.setFont(new Font("",Font.BOLD,15));
		clearButton.setBounds(550, 260, 100, 30);
		clearButton.addActionListener(this);
		jPanel1.add(clearButton);
		
		cancel=new JButton("退出");
		cancel.setFont(new Font("",Font.BOLD,15));
		cancel.setBounds(550, 320, 100, 30);
		cancel.addActionListener(this);
		jPanel1.add(cancel);
		
		jTable=new JTable(new DefaultTable(15,7));
		jScrollPane=new JScrollPane(jTable);
		
		jSplitPane=new JSplitPane(JSplitPane.VERTICAL_SPLIT,false,jPanel1,jScrollPane);
		jSplitPane.setDividerLocation(400);
		jSplitPane.setOneTouchExpandable(true);
		jSplitPane.setDividerSize(5);
		
		contentPane.add(jSplitPane);
		
		Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
		this.setPreferredSize(screenSize);
		//this.setBounds(screenSize.width/2-250,screenSize.height/2-250,500,500);
		this.setVisible(true);
		this.setTitle("查询界面");
		setResizable(false);
		pack();
	}

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO 自动生成方法存根
		java.awt.EventQueue.invokeLater(new Runnable() {
			public void run() {
				new SearchFrame().setVisible(true);
			}
		});

	}
	
	//清空输入的查询条件
	private void clear(){
		idText.setText("");
		nameText.setText("");
		ganderText.setText("");
		majorText.setText("");
		gradeText.setText("");
		addressText.setText("");
		telephoneText.setText("");
	}
	
	//将学生信息保存为一个Student对象
	private void setStudent(Student student,ResultSet rs)throws SQLException{
		student.setID(rs.getString("id"));
		student.setName(rs.getString("name"));
		student.setGander(rs.getString("gander"));
		student.setMajor(rs.getString("major"));
		student.setGrade(rs.getString("grade"));
		student.setAddress(rs.getString("address"));
		student.setTelephone(rs.getString("telephone"));
	}

	//捕捉到JButton点击事件后的实现的逻辑
	public void actionPerformed(ActionEvent e) {
		// 点击"退出"按钮
		if(e.getActionCommand().equals("退出")){
			//退出系统
			System.exit(0);
		}
		//点击"清空"按钮
		if(e.getActionCommand().equals("清空")){
			//清空输入的查询条件
			clear();
		}
		//点击"新建"按钮
		if(e.getActionCommand().equals("新建")){
			//若有已打开的新建界面，关闭该界面
			if(createFrame!=null){