62,612
社区成员
发帖
与我相关
我的任务
分享
button.addActionListener(new ActionListener(){
//private Object textArea;
public void actionPerformed(ActionEvent e) {
try {
String name = textField.getText(); //从文本框里面得到名字
String sql="select * from yhinfo where id="+name+""; //以名字为检索条件去数据库检索
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //加载驱动
Connection con = DriverManager.getConnection("jdbc:odbc:yhinfo", "", ""); //连接数据库
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(sql); //执行sql
ResultSetMetaData rmeta = rs.getMetaData();
int numCols = rmeta.getColumnCount(); //取得列数
while (rs.next()) {
String temp="属性介绍\n";
for (int i = 1; i <= numCols; i++) {
String sTemp = rs.getString(i);
循环打印取出得值。
System.out.println(sTemp);
temp=temp+":"+sTemp;
}
textArea.setText(temp); //设定到输出的文本域中
}
} catch (Exception e1) {
System.out.println(e1.getMessage());
}
// TODO Auto-generated method stub
}
});
//利用了匿名类添加按钮的点击事件
button.addActionListener(new ActionListener() {
// private Object textArea;
public void actionPerformed(ActionEvent e) {
try {
String name = textField.getText();
String sql = "select * from yhinfo where id=" + name + "";
//利用ODBC桥连接。
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载驱动
Connection con = DriverManager.getConnection(
"jdbc:odbc:yhinfo", "", "");//获取连接
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(sql);
ResultSetMetaData rmeta = rs.getMetaData();//执行SQL返回结果集
int numCols = rmeta.getColumnCount();//获取列数
while (rs.next()) {
String temp = "属性介绍\n";
//循环打印出每一列的值
for (int i = 1; i <= numCols; i++) {
String sTemp = rs.getString(i);
System.out.println(sTemp);
temp = temp + ":" + sTemp;
}
textArea.setText(temp);
}
} catch (Exception e1) {
System.out.println(e1.getMessage());
}
// TODO Auto-generated method stub
}
});