usermanager.java

基于MVC体系架构编写的login功能模块

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package Manager;
import Com.JDBConnection;

import java.sql.ResultSet;
import java.sql.SQLException;

/**
 *
 * @author XuLiYuan~11
 */
public class UserManager {

        ResultSet rest = null;
        
    public UserManager() {
    }

    public boolean islogin(String username, String password) {
//        throw new UnsupportedOperationException("Not yet implemented");
        
        boolean islogin = false;   

        JDBConnection jdbconnection = new JDBConnection();
        jdbconnection.creatConnection();
        try {

//           String sql="select * from [user] where username like 'username' and password like 'password'";
  String sql = "SELECT * FROM [user] WHERE username='";
  sql = sql + username;
  sql = sql + "'AND password='";
  sql = sql + password;
  sql = sql + "'";
  
            rest=jdbconnection.executeQuery(sql);
            if(rest.next()){
                islogin=true;
            }else{
                islogin=false;
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        } finally{
            jdbconnection.closeConnection();
        }
        return islogin;
    }
}