userdao.java

C语言小型分析器实验报告1） 待分析的简化C语言的词法说明； 2） 单词符号的种别编码方案； 3） 所识别的各类单词符号的正规式或状态转换图； 4） 待分析的简化C语言的语法规则说明； 5）

package dao;

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

public class UserDao {
	private String account;
	private String password;
	private String name;
	private int id;
	private BasicDao dao;
	public UserDao(String account,String password){
		this.account = account;
		this.password = password;
		dao = new BasicDao();
	}
	
	public boolean login(){
		String sql = "select id,account,name,password from user where name='" + account + "' and password='" + password + "'";
		ResultSet rs = null;
		try {
			rs = dao.queryString(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		try {
			if(rs.next()){
				name = rs.getString("name");
				id = rs.getInt("id");
				dao.closeAll();
				return true;
			}else{
				dao.closeAll();
				return false;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		dao.closeAll();
		return false;
	}

	public String getAccount() {
		return account;
	}

	public void setAccount(String account) {
		this.account = account;
	}

	public String getPassword() {
		return password;
	}

	public void setPassword(String password) {
		this.password = password;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}
	
}