数据访问层异常处理

业务逻辑层、数据访问层通过接口进行隔离，通过实现接口进行访问。

为了方便统一处理异常，可以建立单独的异常来接收、处理异常。

如果在定义接口的同时就抛出异常，那么耦合度将增加。

 

下面来看一个示例：

由Domain、DAO、implements、RuntimeException组成。

 

Domain:User.java

package org.jdbc.domain; import java.util.Date; public class User { private int id; private String name; private Date birthday; private float money; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public Date getBirthday() { return birthday; } public void setBirthday(Date birthday) { this.birthday = birthday; } public float getMoney() { return money; } public void setMoney(float money) { this.money = money; } }  

 

DAO:UserDao.java

package org.jdbc.dao; import org.jdbc.domain.User; public interface UserDao { public void addUser(User user); public User getUser(int userId); public void update(User user); public void delete(User user); public User findUser(String loginName, String password); }  

 

Implements:UserDaoImpl.java

package org.jdbc.dao.impl; import java.sql.Connection; import java.sql.PreparedStatement; import org.jdbc.dao.UserDao; import org.jdbc.dao.exception.DaoRuntimeException; import org.jdbc.domain.User; import org.local.jdbc.JdbcUtilSingle; public class UserDaoJdbcImpl implements UserDao { @Override public void addUser(User user) { // TODO Auto-generated method stub Connection conn = null; PreparedStatement ps = null; try{ conn = JdbcUtilSingle.getInstance().getConnection(); String sql = "Insert into user values(id,?,?,?)"; ps = conn.prepareStatement(sql); ps.setString(1, user.getName()); ps.setDate(2, new java.sql.Date(user.getBirthday().getTime())); ps.setFloat(3, user.getMoney()); ps.executeUpdate(); }catch (Exception e) { // TODO: handle exception throw new DaoRuntimeException(e.getMessage(), e); } } @Override public User getUser(int userId) { // TODO Auto-generated method stub return null; } @Override public void update(User user) { // TODO Auto-generated method stub } @Override public void delete(User user) { // TODO Auto-generated method stub } @Override public User findUser(String loginName, String password) { // TODO Auto-generated method stub return null; } }  

 

RuntimeException:DaoRuntimeException.java

package org.jdbc.dao.exception; public class DaoRuntimeException extends RuntimeException { public DaoRuntimeException() { // TODO Auto-generated constructor stub } public DaoRuntimeException(String arg0) { super(arg0); // TODO Auto-generated constructor stub } public DaoRuntimeException(Throwable arg0) { super(arg0); // TODO Auto-generated constructor stub } public DaoRuntimeException(String arg0, Throwable arg1) { super(arg0, arg1); // TODO Auto-generated constructor stub } }