userdao.java

这是我刚刚学STRUTS的时候做的一点东西

package org.lc.dao;

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

import org.lc.common.ConnectionFactory;
import org.lc.common.DBUtils;
import org.lc.pojo.User;

public class UserDao {
	public User getUser(String username, String password) {
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		User user = null;
		try {
			conn = ConnectionFactory.getFactory().getConnection();
			String sql = "select username,password from UserDao_tbl where username=? and password=?";
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, username);
			pstmt.setString(2, password);
			rs = pstmt.executeQuery();
			if (rs.next()) {
				user = new User();
				user.setUsername(rs.getString(1));
				user.setPassword(rs.getString(2));
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		finally{
			DBUtils.close(rs,pstmt,conn);
		}
		return user;

	}

}