loginlogicbean.java

新闻发布系统 传统的MVC编程架构

package org.langsin.news.logic;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


import org.langsin.news.comm.DataSource;

public class LoginLogicBean {
	/**
	 * 验证登陆的方法,如果用户名和密码全部正确返加OK
	 * 如果用户名正确密码不正确返回PWD
	 * 如果用户名不存在,就没有必要判断密码返加NOUSER
	 * @param userName
	 * @param userPwd
	 * @return
	 */
	public String verify(String userName, String userPwd) {
		String result = null;
		Connection conn = null;
		Statement st = null;
		ResultSet rs = null;
		conn = DataSource.getConnection();
		try {
			st = conn.createStatement();
			rs = st.executeQuery("select password from user where username='"
					+ userName + "'");
			if (rs.next()) {
				if (userPwd.equals(rs.getString(1))) {
					result = "OK";
				} else {
					result = "PWD";
				}
			} else {
				result = "NOUSER";
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				if(rs!=null)rs.close();
				if(st!=null)st.close();
			
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}

		return result;

	}

}