customerdaoimpl.java

简易的网上书城主要用于初学者理解

package org.netbook.dao.impl;

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

import org.netbook.dao.CustomerDao;
import org.netbook.model.Book;
import org.netbook.model.Customer;
import org.netbook.utils.DBUtils;

public class CustomerDaoImpl implements CustomerDao {

	public Customer login(String name, String passwd) {
		Connection conn = DBUtils.getConnection();
		PreparedStatement pStmt = null;
		ResultSet rs = null;
		Customer result = null;
		final String SQL = "SELECT * FROM CUSTOMER WHERE NAME = ? AND PASSWD = ?";
		try {
			pStmt = conn.prepareStatement(SQL);
			pStmt.setString(1, name);
			pStmt.setString(2, passwd);
			rs = pStmt.executeQuery();
			while (rs.next()) {
				result = new Customer();
				result.setId(rs.getLong("ID"));
				result.setName(rs.getString("NAME"));
				result.setPasswd(rs.getString("PASSWD"));
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				if (rs != null) {
					rs.close();
				}
				if (pStmt != null) {
					pStmt.close();
				}
				if (conn != null) {
					conn.close();
				}
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return result;
	}
	

}