用户查找信息代码片断

package newuser; //包名
import java.awt.BorderLayout;
import java.awt.BorderLayout;
import javax.swing.*;
import java.awt.CardLayout;
import javax.swing.JTextField;
import java.awt.*;
import javax.swing.JButton;
import java.awt.event.*;
import java.sql.ResultSet; //导入结果集包
public class frmuser extends JFrame
{
public frmuser() {
try {
jbInit();
} catch (Exception exception) {
exception.printStackTrace();
}
}
private void jbInit() throws Exception
{
btnselect.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
if(txtname.getText().length() == 0) {
JOptionPane.showMessageDialog(null,"请输入你的登录名！");
return;
}
String strsql = "select * from userinfo where loginname = '"+ txtname.getText() +"'";
try {
ResultSet rs = runmain.stmt.executeQuery(strsql);
if(rs.next() == true)
{
txtuser.setText(rs.getString(2));
txtage.setText(rs.getInt(3) + "");
}else{
JOptionPane.showMessageDialog(null,"此登录名不存在，请重新登录！");
} rs.close(); //关闭rs
} catch (Exception ex) {
ex.printStackTrace();
}
}
});
txtuser.setEnabled(false); //禁用txtuser，txtage框
txtage.setEnabled(false);
getContentPane().setLayout(null);
this.setDefaultCloseOperation(DISPOSE_ON_CLOSE);
this.setTitle("客户信息");
lblnew.setFont(new java.awt.Font("Dialog", Font.BOLD, 20));
lblnew.setForeground(Color.red);
lblnew.setText("用户信息查找");
lblnew.setBounds(new Rectangle(86, 21, 164, 37));
lblname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
lblname.setText("用户登录名");
lblname.setBounds(new Rectangle(43, 103, 112, 31));
lbluser.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
lblage.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
txtuser.setText("");
txtuser.setBounds(new Rectangle(159, 140, 111, 27));
txtage.setText("");
txtage.setBounds(new Rectangle(158, 183, 111, 27));
txtname.setText("");
txtname.setBounds(new Rectangle(159, 99, 111, 27));
btnselect.setBounds(new Rectangle(115, 237, 96, 38));
btnselect.setFont(new java.awt.Font("Dialog", Font.BOLD, 15));
btnselect.setText("查找");
lbluser.setText("用户姓名");
lbluser.setBounds(new Rectangle(45, 142, 112, 31));
this.getContentPane().add(lblname);
this.getContentPane().add(lbluser);
this.getContentPane().add(lblage);
this.getContentPane().add(txtname);
this.getContentPane().add(txtuser);
this.getContentPane().add(txtage);
this.getContentPane().add(lblnew);
this.getContentPane().add(btnselect);
lblage.setText("用户年龄");
lblage.setBounds(new Rectangle(43, 186, 112, 31));
}
JLabel lblnew = new JLabel();
JLabel lblage = new JLabel();
JLabel lbluser = new JLabel();
JLabel lblname = new JLabel();
JTextField txtuser = new JTextField();
JTextField txtage = new JTextField();
JTextField txtname = new JTextField();
JButton btnselect = new JButton();
}
[b][color=blue][/color]