?? studentmarktableframe.java
字號:
package com.sccp.StudentMS.baseFrame;
import java.awt.BorderLayout;
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.JTable;
import javax.swing.table.AbstractTableModel;
import javax.swing.table.DefaultTableModel;
import com.swtdesigner.SwingResourceManager;
public class StudentMarkTableFrame extends JFrame {
private JTable table;
private Vector vector;
DefaultTableModel model;
private JLabel label ;
/**
* Launch the application
* @param args
*/
public static void main(String args[]) {
try {
StudentMarkTableFrame frame = new StudentMarkTableFrame();
frame.setVisible(true);
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* Create the frame
*/
public StudentMarkTableFrame() {
super();
setBounds(100, 100, 593, 413);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
final JPanel panel = new JPanel();
panel.setLayout(null);
getContentPane().add(panel, BorderLayout.CENTER);
model=new DefaultTableModel();
model.addColumn("學號");
model.addColumn("總分");
model.addColumn("政治");
model.addColumn("高數");
model.addColumn("英語");
model.addColumn("專業課");
final JScrollPane scrollPane = new JScrollPane();
panel.add(scrollPane);
scrollPane.setBounds(44, 68, 517, 242);
table = new JTable(model);
table.setColumnSelectionAllowed(true);
scrollPane.setViewportView(table);
final JButton button = new JButton();
button.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
StudentMarkTableFrame.this.dispose();
}
});
button.setText("退出");
button.setBounds(429, 343, 80, 23);
panel.add(button);
label= new JLabel();
label.setText("以下為查詢結果:");
label.setBounds(44, 32, 109, 15);
panel.add(label);
final JLabel label_1 = new JLabel();
label_1.setIcon(SwingResourceManager.getIcon(StudentMarkTableFrame.class, "/images/dd.JPG"));
label_1.setText(" ");
label_1.setBounds(0, 0, 585, 391);
panel.add(label_1);
//
}
public void resultShow(ResultSet rs)
{
try {
while(rs.next())
{
vector = new Vector(1,1);
vector.add(rs.getString("ID"));
vector.add(rs.getString("Total"));
vector.add(rs.getString("philosophy"));
vector.add(rs.getString("math"));
vector.add(rs.getString("english"));
vector.add(rs.getString("specialty"));
model.addRow(vector);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
JOptionPane.showMessageDialog(null,"成績查詢時出錯!");
e.printStackTrace();
}
}
public void sortFrame(StudentMarkTableFrame smtf)
{
smtf.label.setText("以下為排序結果:");
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -