?? studentchaxun.java
字號:
package don;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.*;
import javax.swing.table.DefaultTableModel;
import java.awt.*;
import java.sql.ResultSet;
import java.sql.SQLException;
public class studentchaxun extends JFrame implements ActionListener
{
private static final long serialVersionUID = 1L;
DBSource db=new DBSource();
ResultSet rs;
String yonghuming;
JButton b1=new JButton("修改密碼");
JButton b2=new JButton("退出");
JButton b3=new JButton("查詢");
JButton b4=new JButton("查詢");
JRadioButton r1=new JRadioButton();
JRadioButton r2=new JRadioButton();
JRadioButton r3=new JRadioButton();
JComboBox departmentBox1=new JComboBox();
JComboBox departmentBox2=new JComboBox();
JTextField t1=new JTextField(10);
JTextField t2=new JTextField(10);
JTextField t3=new JTextField(10);
JFrame frame=new JFrame("學生個人查詢");
DefaultTableModel model = new DefaultTableModel();
public studentchaxun(String yonghuming0)
{
yonghuming=yonghuming0;
frame.getContentPane().add(createPanel1(),
BorderLayout.CENTER);
frame.setBounds(240,160,600,500);
// frame.setLayout(null);
frame.setResizable(false);//設置窗體大小是否可變
frame.setVisible(true);
}
protected Component createPanel1()
{
JPanel panel=new JPanel();
ImageIcon icon=new ImageIcon("new.gif");
JTabbedPane tabbedPane=new JTabbedPane();
Component panel1=createPanel(1);
tabbedPane.addTab("HELLO",icon,panel1,"Does nothing");
tabbedPane.setSelectedIndex(0);
Component panel2=createPanel(2);
tabbedPane.addTab("查詢信息",icon,panel2,"Does twice as much nothing");
Component panel3=createPanel(3);
tabbedPane.addTab("查詢成績",icon,panel3,"Dose nothing at all");
panel.setLayout(new GridLayout(1,1));
panel.add(tabbedPane);
return panel;
}
protected Component createPanel(int i)
{
JPanel panel4=new JPanel();
panel4.setLayout(new GridLayout(1,1));
JSplitPane splitpane;
JPanel panel5=new JPanel();
JPanel panel6=new JPanel();
panel5.setLayout(null);
panel6.setLayout(null);
Font[] fonts={new Font("隸書",Font.BOLD,28),new Font("宋體",Font.BOLD,20),new Font("隸書",Font.BOLD,25),new Font("宋體",Font.BOLD,13)};
String[] arg1={"查詢單科成績","數學:","英語:","語文:","學期:","查詢多科成績","選擇:"};
String[] arg2={"---------學員信息---------"};
String[] arg3={"學號: ","姓名:","性別:","班級:","年級:","政治面貌:","出生日期:","家庭住址:","專業:"};
if(i==1) //卡片1
{
String sql=("select sname from geren where sno='"+yonghuming+"'");
rs=db.executeQuery(sql);
String name = null;
try
{
if(rs.next())
{
name=rs.getString(1);
}
}
catch (SQLException e)
{
e.printStackTrace();
}
panel4.setLayout(null);
ImageIcon me=new ImageIcon("my.jpg");
JLabel L1=new JLabel(me);
JLabel L2=new JLabel(name+" 同學，你好! ");
b1.addActionListener(this);
b2.addActionListener(this);
panel4.add(L1);
panel4.add(L2);
panel4.add(b1);
panel4.add(b2);
L1.setBounds(0,26,600,475);
L2.setBounds(0,0,400,25);
b1.setBounds(401,0,100,25);
b2.setBounds(501,0,100,25);
}
if(i==2) //卡片2---顧云穎:查詢信息
{
panel4.setLayout(null);
JLabel studentLabel=new JLabel();
studentLabel.setFont(fonts[2]);
studentLabel.setText(arg2[0]);
panel4.add(studentLabel);
studentLabel.setBounds(100,0,500,100);
JLabel L1=new JLabel();
JLabel L2=new JLabel();
JLabel L3=new JLabel();
JLabel L4=new JLabel();
JLabel L5=new JLabel();
JLabel L6=new JLabel();
JLabel L7=new JLabel();
JLabel L8=new JLabel();
JLabel L9=new JLabel();
L1.setFont(fonts[3]);
L1.setText(arg3[0]);
L2.setFont(fonts[3]);
L2.setText(arg3[1]);
L3.setFont(fonts[3]);
L3.setText(arg3[2]);
L4.setFont(fonts[3]);
L4.setText(arg3[3]);
L5.setFont(fonts[3]);
L5.setText(arg3[4]);
L6.setFont(fonts[3]);
L6.setText(arg3[5]);
L7.setFont(fonts[3]);
L7.setText(arg3[6]);
L8.setFont(fonts[3]);
L8.setText(arg3[7]);
L9.setFont(fonts[3]);
L9.setText(arg3[8]);
JTextField t1=new JTextField(10);
JTextField t2=new JTextField(10);
JTextField t3=new JTextField(10);
JTextField t4=new JTextField(10);
JTextField t5=new JTextField(10);
JTextField t6=new JTextField(10);
JTextField t7=new JTextField(10);
JTextField t8=new JTextField(10);
JTextField t9=new JTextField(10);
panel4.add(L1);
panel4.add(L2);
panel4.add(L3);
panel4.add(L4);
panel4.add(L5);
panel4.add(L6);
panel4.add(L7);
panel4.add(L8);
panel4.add(L9);
panel4.add(t1);
panel4.add(t2);
panel4.add(t3);
panel4.add(t4);
panel4.add(t5);
panel4.add(t6);
panel4.add(t7);
panel4.add(t8);
panel4.add(t9);
L1.setBounds(50,100,100,25);
L2.setBounds(300,100,100,25);
L3.setBounds(50,150,100,25);
L4.setBounds(300,150,100,25);
L5.setBounds(50,200,100,25);
L6.setBounds(300,200,100,25);
L7.setBounds(50,250,100,25);
L8.setBounds(300,250,100,25);
L9.setBounds(50,300,100,25);
t1.setBounds(120,100,80,25);
t2.setBounds(400,100,80,25);
t3.setBounds(120,150,80,25);
t4.setBounds(400,150,80,25);
t5.setBounds(120,200,80,25);
t6.setBounds(400,200,80,25);
t7.setBounds(120,250,80,25);
t8.setBounds(400,250,80,25);
t9.setBounds(120,300,80,25);
try
{
String sql =( "select sno,sname,ssex,sclass,sgrade,szhenzhimianmao,sbirthday,shometown,szhuanye from geren where sno='"+yonghuming+"'");
rs=db.executeQuery(sql);
String sno,sname,ssex,sclass,sgrade,szhenzhimianmao,sbirthday,shometown,szhuanye;
while(rs.next())
{
sno=rs.getString(1);
sname=rs.getString(2);
ssex=rs.getString(3);
sclass=rs.getString(4);
sgrade=rs.getString(5);
szhenzhimianmao=rs.getString(6);
sbirthday=rs.getString(7);
shometown=rs.getString(8);
szhuanye=rs.getString(9);
t1.setText(sno);
t2.setText(sname);
t3.setText(ssex);
t4.setText(sclass);
t5.setText(sgrade);
t6.setText(szhenzhimianmao);
t7.setText(sbirthday);
t8.setText(shometown);
t9.setText(szhuanye);
}
}
catch(SQLException ex)
{
System.err.println("SQLException:"+ex.getMessage());
}
}
if(i==3) //卡片3---達曉娟:查詢成績
{
b4.addActionListener(this);
JLabel L1=new JLabel(); //設置panel6,查詢單科成績
JLabel L2=new JLabel();
JLabel L3=new JLabel();
JLabel L4=new JLabel();
JLabel L5=new JLabel();
L1.setFont(fonts[0]);
L1.setText(arg1[0]);
L2.setFont(fonts[1]);
L2.setText(arg1[1]);
L3.setFont(fonts[1]);
L3.setText(arg1[2]);
L4.setFont(fonts[1]);
L4.setText(arg1[3]);
L5.setFont(fonts[1]);
L5.setText(arg1[4]);
ButtonGroup group1=new ButtonGroup();
group1.add(r1);
group1.add(r2);
group1.add(r3);
r1.setSelected(true);
departmentBox1.addItem("07-1");
departmentBox1.addItem("07-2");
departmentBox1.setSelectedIndex(0);
panel6.add(L1);
panel6.add(L2);
panel6.add(L3);
panel6.add(L4);
panel6.add(L5);
panel6.add(b4);
panel6.add(t1);
panel6.add(t2);
panel6.add(t3);
panel6.add(r1);
panel6.add(r2);
panel6.add(r3);
panel6.add(departmentBox1);
L1.setBounds(180,30,200,25);
L5.setBounds(100,100,60,25);
departmentBox1.setBounds(200,100,100,25);
b4.setBounds(350,100,80,25);
r1.setBounds(150,200,20,25);
L2.setBounds(190,200,80,25);
t1.setBounds(290,200,100,25);
r2.setBounds(150,250,20,25);
L3.setBounds(190,250,80,25);
t2.setBounds(290,250,100,25);
r3.setBounds(150,300,20,25);
L4.setBounds(190,300,80,25);
t3.setBounds(290,300,100,25);
JLabel L6=new JLabel(); //設置panel5,查詢多科成績
JLabel L7=new JLabel();
L6.setFont(fonts[0]);
L6.setText(arg1[5]);
L7.setFont(fonts[1]);
L7.setText(arg1[6]);
b3.addActionListener(this);
departmentBox2.addItem("07-1");
departmentBox2.addItem("07-2");
departmentBox2.addItem("所有成績");
departmentBox2.setSelectedIndex(0);
String[] columnName={"學期","數學","英語","語文"};
JTable informationTable=new JTable(model);
JScrollPane tableScrollPane=new JScrollPane(informationTable,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
for(int j=0;j<columnName.length;j++)
model.addColumn(columnName[j]);
panel5.add(tableScrollPane);
panel5.add(L6);
panel5.add(L7);
panel5.add(departmentBox2);
panel5.add(tableScrollPane);
panel5.add(b3);
L6.setBounds(180,30,200,25);
L7.setBounds(130,120,60,25);
departmentBox2.setBounds(210,120,110,25);
b3.setBounds(350,120,80,25);
tableScrollPane.setBounds(100,220,400,100);
splitpane=new JSplitPane(JSplitPane.HORIZONTAL_SPLIT,panel5,panel6);
return splitpane;
}
return panel4;
}
public void actionPerformed(ActionEvent e1)
{
if(e1.getSource()==b2)
{
frame.setVisible(false);
}
if(e1.getSource()==b1)
{
new xueshenggaimi();
}
if(e1.getSource()==b4)
{
String sdepartment=(String)departmentBox1.getSelectedItem();
String name = null;
if(sdepartment.equals("07-1"))
{
if(r1.isSelected())
{
String sql=("select smath from term5 where sno='"+yonghuming+"'");
rs=db.executeQuery(sql);
try
{
if(rs.next())
{name=rs.getString(1);}
}
catch (SQLException e)
{
e.printStackTrace();
}
t1.setText(name);
}
if(r2.isSelected())
{
String sql=("select senglish from term5 where sno='"+yonghuming+"'");
rs=db.executeQuery(sql);
try
{
if(rs.next())
{name=rs.getString(1);}
}
catch (SQLException e)
{
e.printStackTrace();
}
t2.setText(name);
}
if(r3.isSelected())
{
String sql=("select schinese from term5 where sno='"+yonghuming+"'");
rs=db.executeQuery(sql);
try
{
if(rs.next())
{name=rs.getString(1);}
}
catch (SQLException e)
{
e.printStackTrace();
}
t3.setText(name);
}
}
else
{
if(r1.isSelected())
{
String sql=("select smath from term6 where sno='"+yonghuming+"'");
rs=db.executeQuery(sql);
try
{
if(rs.next())
{name=rs.getString(1);}
}
catch (SQLException e)
{
e.printStackTrace();
}
t1.setText(name);
}
if(r2.isSelected())
{
String sql=("select senglish from term6 where sno='"+yonghuming+"'");
rs=db.executeQuery(sql);
try
{
if(rs.next())
{name=rs.getString(1);}
}
catch (SQLException e)
{
e.printStackTrace();
}
t2.setText(name);
}
if(r3.isSelected())
{
String sql=("select schinese from term6 where sno='"+yonghuming+"'");
rs=db.executeQuery(sql);
try
{
if(rs.next())
{name=rs.getString(1);}
}
catch (SQLException e)
{
e.printStackTrace();
}
t3.setText(name);
}
}
}
if(e1.getSource()==b3)
{
String sdepartment=(String)departmentBox2.getSelectedItem();
String math = null;
String english = null;
String chinese = null;
int count=model.getRowCount();
for(int i=0;i<count;i++)
{
model.removeRow(0);
}
if(sdepartment.equals("07-1"))
{
String xueqi ="07-1";
String sql=("select smath,senglish,schinese from term5 where sno='"+yonghuming+"'");
rs=db.executeQuery(sql);
try
{
if(rs.next())
{
math=rs.getString(1);
english=rs.getString(2);
chinese=rs.getString(3);
}
}
catch (SQLException e)
{
e.printStackTrace();
}
String[] s={xueqi,math,english,chinese};
model.addRow(s);
}
if(sdepartment.equals("07-2"))
{
String xueqi ="07-2";
String sql=("select smath,senglish,schinese from term6 where sno='"+yonghuming+"'");
rs=db.executeQuery(sql);
try
{
if(rs.next())
{
math=rs.getString(1);
english=rs.getString(2);
chinese=rs.getString(3);
}
}
catch (SQLException e)
{
e.printStackTrace();
}
String[] s={xueqi,math,english,chinese};
model.addRow(s);
}
if(sdepartment.equals("所有成績"))
{
String xueqi1="07-1";
String sql1=("select smath,senglish,schinese from term5 where sno='"+yonghuming+"'");
rs=db.executeQuery(sql1);
try
{
if(rs.next())
{
math=rs.getString(1);
english=rs.getString(2);
chinese=rs.getString(3);
}
}
catch (SQLException e)
{
e.printStackTrace();
}
String[] s1={xueqi1,math,english,chinese};
model.addRow(s1);
String xueqi2 ="07-2";
String sql2=("select smath,senglish,schinese from term6 where sno='"+yonghuming+"'");
rs=db.executeQuery(sql2);
try
{
if(rs.next())
{
math=rs.getString(1);
english=rs.getString(2);
chinese=rs.getString(3);
}
}
catch (SQLException e)
{
e.printStackTrace();
}
String[] s2={xueqi2,math,english,chinese};
model.addRow(s2);
}
}
}
public static void main(String[] args)
{
new studentchaxun("010");
}
}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -