oracletmobiledao.java

这是我在东方标准学习的时候做的一个项目

package dao.product.oracle;

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

import dao.product.DbUtil;
import dao.product.TMobileDAO;

import bean.TMobile;

public class OracleTMobileDAO implements TMobileDAO {
	
	public boolean add(TMobile mobile) {
		DbUtil db = new OracleDbUtil();
		Connection conn = db.getConnection();
		String sql = "insert into TMobile (mobile_number,mobile_type,card_number,is_available) values (?,?,?,?)";
		try {
			PreparedStatement prepStmt = conn.prepareStatement(sql);
			prepStmt.setString(1, mobile.getMobile_number());
			prepStmt.setString(2, mobile.getMobile_type());
			prepStmt.setString(3, mobile.getCard_number());
			prepStmt.setString(4, mobile.getIs_available());
			prepStmt.execute();
			return true;
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		} finally {
			db.close();
		}
	}

	public boolean update(TMobile mobile) {
		DbUtil db = new OracleDbUtil();
		Connection conn = db.getConnection();
		String sql = "update TMobile set mobile_type=?,card_number=?,is_available=? where mobile_number=?";
		try {
			PreparedStatement prepStmt = conn.prepareStatement(sql);
			prepStmt.setString(1, mobile.getMobile_type());
			prepStmt.setString(2, mobile.getCard_number());
			prepStmt.setString(3, mobile.getIs_available());
			prepStmt.setString(4, mobile.getMobile_number());
			prepStmt.execute();
			return true;
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		} finally {
			db.close();
		}
	}

	public boolean delete(String mobile_number) {
		DbUtil db = new OracleDbUtil();
		Connection conn = db.getConnection();
		String sql = "delete TMobile where mobile_number=?";
		try {
			PreparedStatement prepStmt = conn.prepareStatement(sql);
			prepStmt.setString(1, mobile_number);
			prepStmt.execute();
			return true;
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		} finally {
			db.close();
		}
	}

	public TMobile findById(String mobile_number) {
		TMobile mobile = null;
		DbUtil db = new OracleDbUtil();
		Connection conn = db.getConnection();
		String sql = "select * from TMobile where mobile_number=?";
		try {
			PreparedStatement prepStmt = conn.prepareStatement(sql);
			prepStmt.setString(1, mobile_number);
			ResultSet rs = prepStmt.executeQuery();
			if (rs.next()) {
				mobile = new TMobile();
				mobile.setMobile_number(rs.getString("mobile_number"));
				mobile.setMobile_type(rs.getString("mobile_type"));
				mobile.setCard_number(rs.getString("card_number"));
				mobile.setIs_available(rs.getString("is_available"));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			db.close();
		}
		return mobile;
	}

	public List findAll() {
		List<TMobile> list = new ArrayList<TMobile>();
		DbUtil db = new OracleDbUtil();
		Connection conn = db.getConnection();
		String sql = "select * from TMobile";
		try {
			PreparedStatement prepStmt = conn.prepareStatement(sql);
			ResultSet rs = prepStmt.executeQuery();
			while (rs.next()) {
				TMobile mobile = new TMobile();
				mobile.setMobile_number(rs.getString("mobile_number"));
				mobile.setMobile_type(rs.getString("mobile_type"));
				mobile.setCard_number(rs.getString("card_number"));
				mobile.setIs_available(rs.getString("is_available"));
				list.add(mobile);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			db.close();
		}
		return list;
	}
	
}