📄 show_student_inf.java
字号:
package stu.view;
import java.awt.Dimension;
import java.awt.Font;
import java.awt.Image;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.io.File;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.DefaultComboBoxModel;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.border.BevelBorder;
import javax.swing.border.TitledBorder;
public class show_student_inf extends JFrame {
private static final long serialVersionUID = -721482400894302963L;
private JTextField textField;
private String choose = "";
public show_student_inf() {
super();
getContentPane().setLayout(null);
setBounds(100, 100, 511, 436);
setDefaultCloseOperation(JFrame.HIDE_ON_CLOSE);
setResizable(false);
final Dimension screen = Toolkit.getDefaultToolkit().getScreenSize();
final Dimension my = this.getSize();
setLocationByPlatform(true);
setLocation((screen.width - my.width) / 2,
(screen.height - my.height) / 2);
setVisible(true);
textField = new JTextField();
textField.setFont(new Font("", Font.PLAIN, 14));
textField.setBounds(267, 67, 203, 29);
getContentPane().add(textField);
final JComboBox comboBox = new JComboBox();
comboBox.setFont(new Font("", Font.PLAIN, 14));
comboBox.setModel(new DefaultComboBoxModel(new String[] { "按学号查询",
"按姓名查询" }));
comboBox.setSelectedItem(textField);
comboBox.setBorder(new TitledBorder(null, "",
TitledBorder.DEFAULT_JUSTIFICATION,
TitledBorder.DEFAULT_POSITION, null, null));
comboBox.setBounds(57, 56, 153, 29);
getContentPane().add(comboBox);
final TitledBorder titledBorder = new TitledBorder(new BevelBorder(
BevelBorder.LOWERED), "查询条件", TitledBorder.CENTER,
TitledBorder.DEFAULT_POSITION, null, null);
titledBorder.setTitleFont(new Font("宋体", Font.PLAIN, 14));
final JLabel label_1 = new JLabel();
label_1.setFont(new Font("宋体", Font.PLAIN, 16));
label_1.setText("请输入要查询信息:");
label_1.setBounds(267, 34, 147, 27);
getContentPane().add(label_1);
final JLabel label_2 = new JLabel();
label_2.setFont(new Font("", Font.PLAIN, 15));
label_2.setText("学 号:");
label_2.setBounds(36, 129, 50, 18);
getContentPane().add(label_2);
final JLabel label_2_1 = new JLabel();
label_2_1.setFont(new Font("", Font.PLAIN, 15));
label_2_1.setText("姓 名:");
label_2_1.setBounds(35, 155, 50, 18);
getContentPane().add(label_2_1);
final JLabel label_2_2 = new JLabel();
label_2_2.setFont(new Font("", Font.PLAIN, 15));
label_2_2.setText("性 别:");
label_2_2.setBounds(35, 185, 50, 18);
getContentPane().add(label_2_2);
final JLabel label_2_3 = new JLabel();
label_2_3.setFont(new Font("", Font.PLAIN, 15));
label_2_3.setText("年 龄:");
label_2_3.setBounds(35, 215, 50, 18);
getContentPane().add(label_2_3);
final JLabel label_2_4 = new JLabel();
label_2_4.setFont(new Font("", Font.PLAIN, 15));
label_2_4.setText("班 级:");
label_2_4.setBounds(36, 243, 50, 18);
getContentPane().add(label_2_4);
final JLabel label_2_5 = new JLabel();
label_2_5.setFont(new Font("", Font.PLAIN, 15));
label_2_5.setText("专 业:");
label_2_5.setBounds(36, 267, 50, 18);
getContentPane().add(label_2_5);
final JLabel label_2_5_1 = new JLabel();
label_2_5_1.setFont(new Font("", Font.PLAIN, 15));
label_2_5_1.setText("院 系:");
label_2_5_1.setBounds(36, 291, 50, 18);
getContentPane().add(label_2_5_1);
final JLabel show_number = new JLabel();
show_number.setFont(new Font("", Font.PLAIN, 14));
show_number.setBounds(92, 129, 138, 18);
getContentPane().add(show_number);
final JLabel show_name = new JLabel();
show_name.setFont(new Font("", Font.PLAIN, 14));
show_name.setBounds(91, 155, 138, 18);
getContentPane().add(show_name);
final JLabel show_sex = new JLabel();
show_sex.setFont(new Font("", Font.PLAIN, 14));
show_sex.setBounds(91, 185, 138, 18);
getContentPane().add(show_sex);
final JLabel show_age = new JLabel();
show_age.setFont(new Font("", Font.PLAIN, 14));
show_age.setBounds(91, 215, 138, 18);
getContentPane().add(show_age);
final JLabel show_class = new JLabel();
show_class.setFont(new Font("", Font.PLAIN, 14));
show_class.setBounds(92, 243, 138, 18);
getContentPane().add(show_class);
final JLabel show_zhuanye = new JLabel();
show_zhuanye.setFont(new Font("", Font.PLAIN, 14));
show_zhuanye.setBounds(92, 267, 138, 18);
getContentPane().add(show_zhuanye);
final JLabel show_yuanxi = new JLabel();
show_yuanxi.setFont(new Font("", Font.PLAIN, 14));
show_yuanxi.setBounds(92, 291, 140, 18);
getContentPane().add(show_yuanxi);
final JLabel label_3 = new JLabel();
final TitledBorder titledBorder_1 = new TitledBorder(new BevelBorder(
BevelBorder.LOWERED), "照片", TitledBorder.CENTER,
TitledBorder.DEFAULT_POSITION, null, null);
titledBorder_1.setTitleFont(new Font("宋体", Font.PLAIN, 14));
label_3.setBorder(titledBorder_1);
label_3.setBounds(267, 105, 203, 260);
getContentPane().add(label_3);
final JLabel label_4 = new JLabel();
label_4.setBounds(280, 129, 180, 226);
getContentPane().add(label_4);
final JButton button = new JButton();
button.setFont(new Font("", Font.PLAIN, 14));
button.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
choose = (String) comboBox.getSelectedItem();
String str = "";
if (choose.equals("按学号查询"))
str = "select * from 学生表,班级表 where 学号='"
+ textField.getText() + "' and 学生表.班级名=班级表.班级名";
if (choose.equals("按姓名查询"))
str = "select * from 学生表,班级表 where 姓名='"
+ textField.getText() + "' and 学生表.班级名=班级表.班级名";
String url = "jdbc:odbc:DB_Student";
try {
Connection con1 = DriverManager.getConnection(url);
Statement st = con1.createStatement();
ResultSet rs = st.executeQuery(str);
if (rs.next() == false)
JOptionPane.showMessageDialog(null, "没有该学生信息！", "系统提示",
JOptionPane.WARNING_MESSAGE);
else
rs = st.executeQuery(str);
while (rs.next()) {
show_number.setText(rs.getString(1));
show_name.setText(rs.getString(2));
show_sex.setText(rs.getString(3));
show_age.setText(String.valueOf(rs.getLong(4)));
show_class.setText(rs.getString(8));
show_zhuanye.setText(rs.getString(9));
show_yuanxi.setText(rs.getString(10));
InputStream is = rs.getBinaryStream(6);
FileOutputStream out = new FileOutputStream(
"copycopy.gif");
File file = new File("copycopy.gif");
int data;
while ((data = is.read()) != -1)
out.write(data);
is.close();
Image image = Toolkit.getDefaultToolkit().getImage(
"copycopy.gif");
image = image.getScaledInstance(label_4.getWidth(),
label_4.getHeight(), Image.SCALE_DEFAULT);
ImageIcon img = new ImageIcon(image);
img.setImage(image);
label_4.setIcon(img);
file.delete();
}
rs.close();
st.close();
con1.close();
} catch (Exception e1) {
}
}
});
button.setText("开始查询");
button.setBounds(36, 337, 99, 28);
getContentPane().add(button);
setTitle("查看学生信息");
setVisible(true);
final JButton button_1 = new JButton();
button_1.setFont(new Font("", Font.PLAIN, 14));
button_1.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
dispose();
}
});
button_1.setText("退出");
button_1.setBounds(160, 337, 72, 28);
getContentPane().add(button_1);
final JLabel label_5 = new JLabel();
final TitledBorder titledBorder_2 = new TitledBorder(null, "查看学生基本信息",
TitledBorder.DEFAULT_JUSTIFICATION,
TitledBorder.DEFAULT_POSITION, null, null);
titledBorder_2.setTitleFont(new Font("", Font.PLAIN, 14));
final TitledBorder titledBorder_3 = new TitledBorder(null, "查看学生基本信息",
TitledBorder.DEFAULT_JUSTIFICATION,
TitledBorder.DEFAULT_POSITION, null, null);
titledBorder_3.setTitleFont(new Font("", Font.PLAIN, 14));
final TitledBorder titledBorder_4 = new TitledBorder(null, "查看学生基本信息",
TitledBorder.DEFAULT_JUSTIFICATION,
TitledBorder.DEFAULT_POSITION, null, null);
titledBorder_4.setTitleFont(new Font("宋体", Font.PLAIN, 15));
final TitledBorder titledBorder_5 = new TitledBorder(null, "查看学生基本信息",
TitledBorder.DEFAULT_JUSTIFICATION,
TitledBorder.DEFAULT_POSITION, null, null);
titledBorder_5.setTitleFont(new Font("宋体", Font.PLAIN, 15));
final TitledBorder titledBorder_7 = new TitledBorder(null, "查看学生基本信息", TitledBorder.DEFAULT_JUSTIFICATION, TitledBorder.DEFAULT_POSITION, null, null);
titledBorder_7.setTitleFont(new Font("宋体", Font.PLAIN, 15));
label_5.setBorder(titledBorder_7);
label_5.setBounds(15, 10, 474, 377);
getContentPane().add(label_5);
final JLabel label = new JLabel();
final TitledBorder titledBorder_6 = new TitledBorder(null, "查询条件", TitledBorder.DEFAULT_JUSTIFICATION, TitledBorder.DEFAULT_POSITION, null, null);
titledBorder_6.setTitleFont(new Font("宋体", Font.PLAIN, 14));
label.setBorder(titledBorder_6);
label.setBounds(30, 32, 200, 73);
getContentPane().add(label);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -