?? chengjicaxun.java
字號:
package don;
import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Dimension;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import javax.swing.ButtonGroup;
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.JPanel;
import javax.swing.JRadioButton;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;
//數(shù)據(jù)庫引入
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Chengjicaxun extends JFrame implements ActionListener
{
JLabel l0,l1,l2,l4;
JButton b1,b2;
ButtonGroup bg;
JRadioButton jrb1,jrb2,jrb4;//jrb3;//;
JPanel jp1; //創(chuàng)建面板
JLabel l5,l6,l7,l8,l10; //輸入和選擇框提示
JTextField t1,t2;
JComboBox jcb,jcb1;
JLabel l9; //顯示圖片
JTable jt;
Font f1;
DefaultTableModel md;
Chengjicaxun()
{
super("學(xué)生信息管理系統(tǒng)");
f1=new Font("SansSerif",Font.PLAIN,20);//設(shè)置字體大小式樣
l0=new JLabel("－－－－－－－－－－－－學(xué)生成績查詢－－－－－－－－－－－－－");
l0.setFont(f1);
l0.setForeground(Color.CYAN);
b1=new JButton("確定");
b2=new JButton("退出");
bg=new ButtonGroup();
jrb1=new JRadioButton();
jrb2=new JRadioButton();
//jrb3=new JRadioButton();
jrb4=new JRadioButton();
l1=new JLabel("按學(xué)號查詢");
l2=new JLabel("按姓名查詢");
//l3=new JLabel("按專業(yè)查詢");
l4=new JLabel("按課程查詢");
l5=new JLabel("請輸入學(xué)號");
l6=new JLabel("請輸入姓名");
l7=new JLabel("請選擇學(xué)期");
l8=new JLabel("查詢成績顯示");
l10=new JLabel("請選擇課程");
t1=new JTextField("",10);
t2=new JTextField("",10);
md = new DefaultTableModel();
String[] columnName={"學(xué)號","姓名","數(shù)學(xué)","英語","語文"};
jp1=new JPanel();
//jp1.setBackground(Color.blue);//測試時加的顏色
jt=new JTable(md);//顯示窗體
//jt.setBackground(Color.white);//測試時加的顏色
JScrollPane jsp=new JScrollPane(jt,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
Dimension dim=new Dimension(300,350);
jt.setPreferredScrollableViewportSize(dim);
for(int i=0;i<columnName.length;i++)
{
md.addColumn(columnName[i]);
}
jp1.add(jsp);
// JScrollPane jsp=new JScrollPane(jt,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
ImageIcon ii=new ImageIcon("ligong.jpg");
l9=new JLabel(ii);
jcb=new JComboBox();
jcb.addItem("第一學(xué)期");
jcb.addItem("第二學(xué)期");
jcb.setBackground(Color.white);
jcb.setSelectedIndex(0);
jcb1=new JComboBox();
jcb1.addItem("數(shù)學(xué)");
jcb1.addItem("英語");
jcb1.addItem("語文");
jcb1.setBackground(Color.white);
jcb1.setSelectedIndex(0);
setBounds(100,100,650,600);
setLayout(null);
setResizable(false);//設(shè)置窗體大小是否可變
jrb1.setSelected(false);//單選按鈕初始化為未被選中
add(l0);
bg.add(jrb1);
bg.add(jrb2);
bg.add(jrb4);
add(jrb1);
add(jrb2);
add(jrb4);
add(jcb);
add(jcb1);
add(b1);
add(b2);
add(l1);
add(l2);
add(l4);
add(l5);
add(l6);
add(l7);
add(t1);
add(t2);
add(l8);
add(l9);
add(l10);
add(jp1);
l0.setBounds(0,60,700,25);
jrb1.setBounds(40,170,16,16);
l1.setBounds(58,170,80,20);
jrb2.setBounds(40,240,16,16);
l2.setBounds(58,240,80,20);
jrb4.setBounds(40,310,16,16);
l4.setBounds(58,310,80,20);
b1.setBounds(40,420,60,30);
b2.setBounds(110,420,60,30);
l5.setBounds(40,200,70, 25);
t1.setBounds(112,200,70, 25);
l6.setBounds(40,270,70, 25);
t2.setBounds(112,270,70, 25);
l7.setBounds(58,100,80,20);
jcb.setBounds(58,130,80,25);
l10.setBounds(40,340,70,25);
jcb1.setBounds(112,340,80,25);
l8.setBounds(240,100,120,25);
l9.setBounds(0,0,650,60);
jp1.setBounds(240,135,320,380);
jrb1.addActionListener(this);
jrb2.addActionListener(this);
jrb4.addActionListener(this);
b1.addActionListener(new button1());
b2.addActionListener
(
new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
setVisible(false);
}
}
);
//退出并且釋放內(nèi)存
// addWindowListener(new WindowAdapter()
// {
// public void windowClosing(WindowEvent e)
// {
// System.exit(0);
// }
//
// });
//
}
public void actionPerformed(final ActionEvent e)
{
if(e.getSource()==jrb1)
{
t1.setEditable(true);
t2.setEditable(false);
jcb1.setEnabled(false);
}
else if(e.getSource()==jrb2)
{
t1.setEditable(false);
t2.setEditable(true);
jcb1.setEnabled(false);
}
else if(e.getSource()==jrb4)
{
t1.setEditable(false);
t2.setEditable(false);
jcb1.setEnabled(true);
}
}
public class button1 implements ActionListener
{
String[][] row=null;
public void actionPerformed(ActionEvent ee)
{
final String a;
final String b;
final String d;
a=t1.getText();
b=t2.getText();
d=(String)jcb1.getSelectedItem();
DBSource db=new DBSource();
String sno=null;
String sname=null;
String smath=null;
String senglish=null;
String schinese=null;
int count=md.getRowCount();////////////////////
for(int i=0;i<count;i++)
{
md.removeRow(0);
} ////
if(ee.getSource()==b1)
{
if(jrb1.isSelected()||jrb2.isSelected()||jrb4.isSelected())
{
if(jrb1.isSelected())
{
if((t1==null||t1.getText().equals("")))
{
JOptionPane.showMessageDialog(null,"對不起，您沒有沒有輸入學(xué)號，無法完成查詢！","不合法",JOptionPane.ERROR_MESSAGE);
}
else
{
if(jcb.getSelectedItem().equals("第一學(xué)期"))
{
String sql1="select * from term1 where sno='" + a + "'";
ResultSet rs1=db.executeQuery(sql1);
try {
while(rs1.next())
{
sno=rs1.getString(1);
sname=rs1.getString(2);
smath=rs1.getString(3);
senglish=rs1.getString(4);
schinese=rs1.getString(5);
String[] row={sno,sname,smath,senglish,schinese};
md.addRow(row);
return;
}
if(!rs1.next())
{
JOptionPane.showMessageDialog(null,"對不起，您輸入的學(xué)號沒有記錄，無法完成查詢！","不合法",JOptionPane.ERROR_MESSAGE);
}
}
catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
else if(jcb.getSelectedItem().equals("第二學(xué)期"))
{
String sql1="select * from term2 where sno='" + a + "'";
ResultSet rs1=db.executeQuery(sql1);
try {
while(rs1.next())
{
sno=rs1.getString(1);
sname=rs1.getString(2);
smath=rs1.getString(3);
senglish=rs1.getString(4);
schinese=rs1.getString(5);
String[] row={sno,sname,smath,senglish,schinese};
md.addRow(row);
return;
}
if(!rs1.next())
{
JOptionPane.showMessageDialog(null,"對不起，您輸入的學(xué)號沒有記錄，無法完成查詢！","不合法",JOptionPane.ERROR_MESSAGE);
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -