userdaoimpl.java

来自「这是一个用JSP技术做的论坛短消息」· Java 代码 · 共 32 行

package impl;

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

import dao.BaseDao;
import dao.UserDao;

public class UserDaoImpl implements UserDao{

	public boolean findUser(String name,String pass){
		boolean b=false;
		Connection con=BaseDao.getConnection();
		try {
			Statement st=con.createStatement();
			ResultSet rs=st.executeQuery("select * from TBL_USER where name='"+name+"' and pass='"+pass+"'");
			if(rs.next()){
				b=true;
			}
			rs.close();
			st.close();
			con.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return b;
	}

}