Oracle数据库入门

BaseDao

package brooker.waterboss.dao;
/**
 * 基本数据访问类（获取数据库连接 关闭资源）
 * @author 45度炸
 *
 */
import java.sql.DriverManager;
import java.sql.SQLException;

	/**
	 * 加载驱动
	 * @author 45度炸
	 *
	 */
	public class BaseDao {
		static {
			try {
				Class.forName("oracle.jdbc.driver.OracleDriver");
			} catch (ClassNotFoundException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
	/**
	 * 获取数据库连接
	 * @return
	 * @throws SQLException
	 */
	public static java.sql.Connection getConnection() throws SQLException {
		return DriverManager.getConnection("jdbc:oracle:thin:@192.168.80.10:1521:orcl", "wateruser", "itcast");
	}
	
	/**
	 * 关闭资源
	 * @param rs
	 * @param stmt
	 * @param conn
	 */
	public static void closeAll(java.sql.ResultSet rs,java.sql.Statement stmt,java.sql.Connection conn) {
		if(rs != null) {
			try {
				rs.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
		if(stmt != null) {
			try {
				stmt.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
		if(conn != null) {
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	
	
	
	

}

实体类

package brooker.waterboss.entity;
/**
 * 业主实体
 * @author 45度炸
 *
 */
public class Owners {
	private Long id;//编号
	private String name;//业主名称
	private Long addressid;//地址ID
	private String housemenber;//门牌号
	private String watermenber;//水表编号
	private java.util.Date adddate;//增加日期
	private Long ownertypeid;//业主类型
	
	public Long getId() {
		return id;
	}
	public void setId(Long id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public Long getAddressid() {
		return addressid;
	}
	public void setAddressid(Long addressid) {
		this.addressid = addressid;
	}
	public String getHousemenber() {
		return housemenber;
	}
	public void setHousemenber(String housemenber) {
		this.housemenber = housemenber;
	}
	public String getWatermenber() {
		return watermenber;
	}
	public void setWatermenber(String watermenber) {
		this.watermenber = watermenber;
	}
	public java.util.Date getAdddate() {
		return adddate;
	}
	public void setAdddate(java.util.Date adddate) {
		this.adddate = adddate;
	}
	public Long getOwnertypeid() {
		return ownertypeid;
	}
	public void setOwnertypeid(Long ownertypeid) {
		this.ownertypeid = ownertypeid;
	}
	
	
	
}

OwnersDao(增删改查)

package brooker.waterboss.dao;

import java.sql.SQLException;

import brooker.waterboss.entity.Owners;

/**
 * 业主信息数据访问类
 * @author 45度炸
 *
 */
public class OwnersDao {
	/**
	 * 增加业主
	 * @param owner
	 */
	public static void add(Owners owner) {
		java.sql.Connection conn = null;
		java.sql.PreparedStatement stmt = null;
		
		try {
			conn = BaseDao.getConnection();
			stmt = conn.prepareStatement("insert into t_owners values(?,?,?,?,?,?,?)");
			//设置字段值
			stmt.setLong(1, owner.getId());
			stmt.setString(2, owner.getName());
			stmt.setLong(3, owner.getAddressid());
			stmt.setString(4, owner.getHousemenber());
			stmt.setString(5, owner.getWatermenber());
			stmt.setDate(6, new java.sql.Date(owner.getAdddate().getTime()));//增加日期
			stmt.setLong(7, owner.getOwnertypeid());
			
			stmt.execute();//执行
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			BaseDao.closeAll(null, stmt, conn);
		}
	}
	
	/**
	 * 修改信息
	 * @param owner
	 */
	public static void update(Owners owner) {
		java.sql.Connection conn = null;
		java.sql.PreparedStatement stmt = null;
		
		try {
			conn = BaseDao.getConnection();
			stmt = conn.prepareStatement("update t_owners set name=?,addressid=?,housenumber=?,"
				+ "watermeter=?,adddate=?,ownertypeid=? where id=?");
			//设置字段值
			stmt.setString(1, owner.getName());
			stmt.setLong(2, owner.getAddressid());
			stmt.setString(3, owner.getHousemenber());
			stmt.setString(4, owner.getWatermenber());
			stmt.setDate(5, new java.sql.Date(owner.getAdddate().getTime()));//增加日期
			stmt.setLong(6, owner.getOwnertypeid());
			stmt.setLong(7, owner.getId());
			stmt.execute();//执行
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			BaseDao.closeAll(null, stmt, conn);
		}
	}
	
	/**
	 * 删除信息
	 * @param owner
	 */
	public static void delete(Owners owner) {
		java.sql.Connection conn = null;
		java.sql.PreparedStatement stmt = null;
		
		try {
			conn = BaseDao.getConnection();
			stmt = conn.prepareStatement("delete from t_owners where id = ?");
			//设置字段值
			stmt.setLong(1, owner.getId());
			stmt.execute();//执行
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			BaseDao.closeAll(null, stmt, conn);
		}
	}

}

Test(增删改查测试)

public class InsertTest {
	public static void main(String[] args) {
		Owners owner = new Owners();
		owner.setId(2L);
		owner.setName("刘强");
		owner.setAddressid(2L);
		owner.setHousemenber("1-2-1");
		owner.setWatermenber("34345");
		owner.setAdddate(new Date());
		owner.setOwnertypeid(2L);
		
		OwnersDao.add(owner);
	}

public class UpdateTest {
	public static void main(String[] args) {
		Owners owner = new Owners();
		owner.setId(3L);
		owner.setName("郑庄");
		owner.setAddressid(3L);
		owner.setHousemenber("1-2-1-1");
		owner.setWatermenber("123");
		owner.setAdddate(new Date());
		owner.setOwnertypeid(3L);
		
		OwnersDao.update(owner);
	}

public class DeleteTest {
	public static void main(String[] args) {
		Owners owner = new Owners();
		owner.setId(3L);
		OwnersDao.delete(owner);
	}