该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
请问各位大神我想通过选中不同的班级后单击查询按钮，在下面显示出不同班级的信息
下面是我目前的代码，现在的问题是无法获取选中的班级，请问该如何解决，谢谢
package biyesheji;
import java.sql.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.*;
import java.util.Vector;
import javax.swing.*;
import javax.swing.table.DefaultTableModel;
public class frame2 extends JFrame implements ActionListener
{ public static void main(String[] args)
{
// TODO Auto-generated method stub
frame2 frame=new frame2();
}
private JButton btn;
private String cs;
private Dao da;
private DefaultTableModel tablemodel;
private Vector colsv;
public frame2()
{
Vector colsv = new Vector();
JTable table;
JFrame frame2=new JFrame("实验管理程序");
frame2.setSize(500, 500);
String str="SELECT DISTINCT SClass FROM Student";
Dao da=new Dao();
ResultSet rs=da.query(str);
JPanel pane = new JPanel();
pane.setSize(500, 500);
frame2.add(pane, "North");
try
{
rs.last();
int i = rs.getRow();
rs.beforeFirst();
String sclass[] = new String[i];
int m = 0;
while(rs.next())
{
sclass[m] = rs.getString(1);
m++;
}
JComboBox combol = new JComboBox(sclass);
pane.add(combol);
String cs =(String) combol.getSelectedItem();
}
catch (SQLException e)
{
e.printStackTrace();
}
JLabel inputLabel = new JLabel("选择班级");
pane.add(inputLabel); JButton btn = new JButton("查询");
pane.add(btn);
btn.addActionListener(this);
colsv.add("学号");
colsv.add("实验编号");
colsv.add("上机时间");
DefaultTableModel tablemodel = new DefaultTableModel(new Vector(), colsv);
table = new JTable(tablemodel);
pane.add(new JScrollPane(table), "Center"); frame2.setVisible(true);
}
public void actionPerformed(ActionEvent e)
{
// TODO Auto-generated method stub
if(cs.equals("通信一班"))
{
String str2 = "SELECT * FROM Time WHERE SNUM LIKE'1514061%'";
ResultSet rs2 = da.query(str2);
Vector value = new Vector();
try{
while(rs2.next()){
Vector vc = new Vector();
vc.add(rs2.getString(1));
vc.add(rs2.getString(2));
vc.add(rs2.getString(3));
value.add(vc);
}
tablemodel.setDataVector(value, colsv);
}catch (SQLException ee)
{
ee.printStackTrace();
}
}
else if(cs.equals("通信二班"))
{
String str2 = "SELECT * FROM Time WHERE SNUM LIKE'1514062%'";
ResultSet rs2 = da.query(str2);
Vector value = new Vector();
try{
while(rs2.next()){
Vector vc = new Vector();
vc.add(rs2.getString(1));
vc.add(rs2.getString(2));
vc.add(rs2.getString(3));
value.add(vc);
}
tablemodel.setDataVector(value, colsv);
}catch (SQLException ee)
{
ee.printStackTrace();
}
}
else if(cs.equals("电信一班"))
{
String str2 = "SELECT * FROM Time WHERE SNUM LIKE'1514051%'";
ResultSet rs2 = da.query(str2);
Vector value = new Vector();
try{
while(rs2.next()){
Vector vc = new Vector();
vc.add(rs2.getString(1));
vc.add(rs2.getString(2));
vc.add(rs2.getString(3));
value.add(vc);
}
tablemodel.setDataVector(value, colsv);
}catch (SQLException ee)
{
ee.printStackTrace();
}
}
else if(cs.equals("电信二班"))
{
String str2 = "SELECT * FROM Time WHERE SNUM LIKE'1514052%'";
ResultSet rs2 = da.query(str2);
Vector value = new Vector();
try{
while(rs2.next()){
Vector vc = new Vector();
vc.add(rs2.getString(1));
vc.add(rs2.getString(2));
vc.add(rs2.getString(3));
value.add(vc);
}
tablemodel.setDataVector(value, colsv);
}catch (SQLException ee)
{
ee.printStackTrace();
}
}
}
}
977
