useroradao.java

JAVA连接数据库的几个版本,由数据源到连接池,适合初学JDBC的

/*
 * Created on Oct 3, 2005
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package com.softeem.jdbc.dao.af.oracle;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.PreparedStatement;
import java.util.List;


import com.softeem.jdbc.dao.af.*;
import com.softeem.jdbc.dao.af.dto.*;

/**
 * @author gelly
 * 
 * TODO To change the template for this generated type comment go to Window -
 * Preferences - Java - Code Style - Code Templates
 */
public class UserOraDAO  implements UserDAO{
	private Connection conn;
	
	private final String SQL_SELECT_USER = "SELCET * FROM JDBC_USER WHERE USERID=?";

	private final String SQL_UPDATE_USER = "UPDATE JDBC_USER SET USERNAME=?, ADDRESS=?, WHERE USERID=?";

	private final String SQL_ADD_USER = "INSERT INTO JDBC_USER VALUES(?,?,?)";

	public UserOraDAO(Connection conn){
		this.conn = conn ;
	}
	/**
	 * 
	 * @param user
	 * @return
	 */
	public boolean add(UserDTO user) {	
		boolean flag = true ;
		try {
			PreparedStatement pstmt = conn.prepareStatement(SQL_SELECT_USER);
			pstmt.setString(0, user.getId());
			pstmt.setString(1, user.getUserName());
			pstmt.setString(2, user.getPassword());
			
			flag = pstmt.execute();
			pstmt.close();
			conn.close();
		} catch (SQLException e) {
			flag = false ;
		}
		return flag;
	}
	
	/**
	 * 
	 * @param userId
	 * @return
	 */
	public UserDTO find(String userId) {
		UserDTO user = null;
		try {
			PreparedStatement pstmt = conn.prepareStatement(SQL_SELECT_USER);
			ResultSet rset = pstmt.executeQuery();
			if (rset.next()) {
				user = new UserDTO();
				user.setId(rset.getString(0));
				user.setUserName(rset.getString(1));
				user.setPassword(rset.getString(2));
			}
			rset.close();
			pstmt.close();
			conn.close();
		} catch (SQLException e) {
			//;
		}
		return user;
	}
	
	public boolean edit(UserDTO user){
		return false;
	}
	
	public boolean delete(String id){
		return false;
	}

	public List findAll(){
		return null;
	}
}