user.java~6~

只是一网站项目不错的可以看看的不看会后悔啊

package com.hugj.sunqi.mybank.model;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */
import com.hugj.sunqi.mybank.model.DBLink;
public class User {
  private String userName;
  private String passWord;
  private java.sql.Statement stmt;
  private java.sql.ResultSet rs;
  private boolean quarySucc=false;
  public User() {
  }

  public void setUserName(String parUserName){
    userName = parUserName;
  }
  public void setPassWord(String parPassWord){
    passWord = parPassWord;
  }
  public boolean isQuarySucc(){
    //quary();
    return quarySucc;
  }
  public void quary(String shuName){
    DBLink dblink = new DBLink();
    stmt = dblink.conn();
    String sql1="select username from [user] where username like"+"'%"+shuName+"%'";
    System.out.println(sql1);
    try{
      rs=stmt.executeQuery("select username from [user] where username like"+"'"+shuName+"'");
      System.out.println("你查询到的用户名为下列所列：");
      while(rs.next()){
        String user = rs.getString(1);
        System.out.println(user);
      }
      rs.close();
      stmt.close();
    }catch(Exception e){
      System.out.println(e.getMessage());
    }
  }
}