loginbean.java

来自「java的一个验证码登陆系统 随机生成验证码图片 0-9 a-z 可以作为登」· Java 代码 · 共 57 行

package org.chenhao.login;

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

import org.chenhao.comm.DataSource;

public class LoginBean {

	public String verify(String username,String password){
		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 users where usename='"+username+"'");
			if(rs.next()){   
				if(password.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();
				//if(conn!=null) conn.close();
				
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return result;
	}

	   
	public static void main(String[] args) {
		// TODO Auto-generated method stub

	}

}