login.java

自己做的一个企业招标系统,B/S结构。开发工具Eclipse

/**
 * 
 */
package com.centralsoft.zhaobiao.admin;

import java.sql.*;

import com.centralsoft.zhaobiao.util.*;

/**
 * @author zw
 *
 */
public class login {
	public login() {
	}
	private String admin;
	private String password;
	public void setAdmin(String admin) {
		this.admin = admin;
	}
	public String getAdmin() {
		return admin;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public String getPassword() {
		return password;
	}
	public boolean excute() {
		boolean flag = false;
		dataBase db = new dataBase();
		ResultSet rs = null;
		String sql = "select * from administrator where adminName = '"+admin+"' and password = '"+password+"'";
		rs = db.getResultSet(sql);
		int count = 0;
		try {
			while (rs.next()) {
				count ++;
			}
			if (count > 0) {
				flag = true;
			} else {
				flag = false;
			}
		} catch (Exception e) {
			System.out.println(e.getMessage());
		} finally {
			try {
				if (rs != null) {
					rs.close();
				}
				db.closeConn();
			} catch (Exception e) {
				System.out.println(e.getMessage());
			}
		}
		return flag;
	}
}