？？为什么不能实现？？

[hooligan31000]

有JcomboBox（学号）控件连接数据库，单击它，显示相应的记录，“姓名”“年龄”,为什么不能实现？？谢谢！！！

import java.sql.*;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;

public class choice extends JFrame implements ActionListener,ItemListener
{
private Connection conn;
private Statement stmt;
private ResultSet rs;
private String url="jdbc:odbc:star";
JComboBox j;
JTextField t1,t2;
Container content;
public choice()
{
content=getContentPane();
content.setLayout(new FlowLayout());
j=new JComboBox();
t1=new JTextField(10);
t2=new JTextField(10);
content.add(j);
content.add(t1);
content.add(t2);
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection(url);
stmt=conn.createStatementResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String query;
query="select * from card";
rs=stmt.executeQuery(query);
rs.beforeFirst();
while(rs.next()) //显示JComboBox的内容(卡号)
{
String CardId=rs.getString(1);
j.addItem(CardId);


}
rs.close(); //关闭
stmt.close();

}catch(Exception ex)
{
System.out.println(ex.getMessage());
}


}

public static void main(String args[])
{
JFrame.setDefaultLookAndFeelDecorated(true);
choice cc=new choice();
cc.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
cc.setTitle("choice");
cc.setSize(500,500);
cc.show();

}

public void actionPerformed(ActionEvent ae)
{
}

public void itemStateChanged(ItemEvent ie)
{
try{
conn=DriverManager.getConnection(url);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

String query1,strstr;
strstr=(String)(j.getSelectedItem());
query1="select * from card where 卡号='"+strstr+"'";


rs=stmt.executeQuery(query1);

t1.setText(rs.getString(2));
t2.setText(rs.getString(8));

rs.close(); //关闭
stmt.close();

}catch(Exception ex)
{
System.out.println(ex.getMessage());
}

}

}

[hooligan31000]

up

[yongfans]

你没有在Jcombox中加入事件啊
你加入 j.addItemListener(this);

[hooligan31000]

我加上了，还是没反应?

[yongfans]

那你在actionPerformed中测试一下看它是否执行到那里，在有你和数据库连接，有没有用户名，密码。

[hooligan31000]

怎么测试？JComboBox的事件不是itemStateChanged(ItemEvent ie),与actionPerformed有关系吗？

[hooligan31000]

我加了个BUTTON，还是不行？？
public void actionPerformed(ActionEvent ae)
{
String str,query1;
str=(String)j.getSelectedItem();
System.out.println(str);
try{
conn=DriverManager.getConnection(url);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);


query1="select 姓名,现有金额 from card where 卡号="+str;

rs=stmt.executeQuery(query1);

System.out.println("name"+rs.getString("姓名"));

String str1,str2;

str1=rs.getString("姓名");
str2=rs.getString("现有金额");
t1.setText(str1);
t2.setText(str2);
//t1.setText(rs.getString("姓名"));
//t2.setText(rs.getString("现有金额"));

System.out.println(rs.getString(2));
System.out.println(rs.getString(8));


rs.close(); //关闭
stmt.close();
}catch(Exception eee)
{}
}