??为什么不能实现??
有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());
}
}
}
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());
}
}
}
...全文
相关推荐
Java-----抽象类为什么不能实例化?抽象方法为什么不能被static修饰?set和get方法的使用方法
抽象类不能实例化的原因;抽象方法不能被static修饰的原因;set和get方法的使用方法
正交拉丁超立方(OLHC)分组与实验设计(DOE)评估的优化Python实现.rar
正交拉丁超立方(OLHC)分组与实验设计(DOE)评估的优化Python实现.rar
Java微服务如何拆解审计日志查询服务
标题:Java微服务如何拆解审计日志查询服务 内容概要:围绕缓存策略、任务调度、回压控制和审计追踪,拆解Java微服务如何拆解审计日志查询服务的实现细节。 xdronline.com xdrea.com 9g.xinmei6.com xinghaohuanbao.com m.xiker66.com
港股十档行情tick数据涵盖逐笔成交与委托,记录每笔买卖价格、成交量及挂单明细 逐笔数据包含成交时间、价格、股数、成交方向,委托数据展示买一至买十、卖一至卖十的价格与数量
港股十档行情tick数据涵盖逐笔成交与委托,记录每笔买卖价格、成交量及挂单明细。逐笔数据包含成交时间、价格、股数、成交方向,委托数据展示买一至买十、卖一至卖十的价格与数量。分钟数据汇总每分钟开盘价、最高价、最低价、收盘价、成交量及成交额。历史行情覆盖近十五年,字段清晰完整,便于回溯分析。 数据源:CMES金融数据库
MO-372A_PQFP-F6_I1p27-R3p8x4p48Z1p1-N5p5C1p24.stp
MO-372A_PQFP-F6_I1p27-R3p8x4p48Z1p1-N5p5C1p24.stp


Java SE
