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);
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
}
});
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);
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
}
});
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 } });
从yhinfo中找到id和textField.getText(); //从文本框里面得到名字相同的记录,并在textArea和后台打印