jdbc_dao

  src-com.itcast.jdbc   jdbcUtilsSing.java

    -com.itcast.jdbc.dao  DaoException.java

                                      DaoFactory.java

                                      UserDao.java  

                                      UserDaoTest.java

   -com.itcast.jdbc.dao.impl  : UserDaoImpl.java

   -com.itcast.jdbc.domain   : User.java

   -com.itcast.jdbc.service   : UserService.java

-------------------------------------------------------------

 

package com.itcast.jdbc; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class jdbcUtilsSing { /** * 单例模式 * @param args */ private String url = "jdbc:mysql://localhost:3306/jdbc?"; private String user = "root"; private String password = "root"; private static jdbcUtilsSing instance; private jdbcUtilsSing() { } public synchronized static jdbcUtilsSing getInstance() { if (instance == null) { synchronized (jdbcUtilsSing.class) {//是否实例化 if (instance == null) { instance = new jdbcUtilsSing(); } } } return instance; } static { // 静态代码块只执行一次，保证驱动只加载一次就行 try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { throw new ExceptionInInitializerError(e); //需要将异常抛出去,让别人知道，出错了 } } public Connection getConnection() throws SQLException { return DriverManager.getConnection(url, user, password); } public void free(Connection conn, Statement stmt, ResultSet rs) { try { if (rs != null) { rs.close(); } } catch (SQLException e) { e.printStackTrace(); } finally { try { if (stmt != null) { stmt.close(); } } catch (SQLException e) { e.printStackTrace(); } finally { if (conn != null) { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } } } }

---------------------------------------------------

package com.itcast.jdbc.dao; public class DaoException extends RuntimeException { public DaoException() { // TODO Auto-generated constructor stub } public DaoException(String message) { super(message); // TODO Auto-generated constructor stub } public DaoException(Throwable cause) { super(cause); // TODO Auto-generated constructor stub } public DaoException(String message, Throwable cause) { super(message, cause); // TODO Auto-generated constructor stub } }

-------------------------------------------------

package com.itcast.jdbc.dao; import java.io.File; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; import java.util.Properties; public class DaoFactory { public static UserDao userDao = null; public static DaoFactory instance = new DaoFactory(); // public static UserDao userDao = // null;如果把第一行注释，第二行不注释，这是一个致命错误，关于类的初始化的一些知识 private DaoFactory() { try { Properties prop = new Properties(); InputStream inStream = new FileInputStream(new File( "src/daoconfig.properties")); prop.load(inStream); String UserDaoClass = prop.getProperty("UserDaoClass");// 从properties里取出字符串，返回的是一个String类型 Class clazz = Class.forName(UserDaoClass); userDao = (UserDao) clazz.newInstance(); } catch (Exception e) { throw new ExceptionInInitializerError(e); } } public static DaoFactory getInstance() { return instance; } // 工厂生产产品，主要是生产UserDao这样的产品 public UserDao getUserDao() { return userDao; } }

-------------------------------------------------

package com.itcast.jdbc.dao; import com.itcast.jdbc.domain.User; public interface UserDao { public void addUser(User user); public User getUser(int userId); public void updateUser(User user); public void deleteUser(User user); public User findUser(String loginName ,String password); }

-------------------------------------------------

package com.itcast.jdbc.dao; import java.util.Date; import com.itcast.jdbc.dao.impl.UserDaoJdbcImpl; import com.itcast.jdbc.domain.User; public class UserDaoTest { public static void main(String[] args) { UserDao userDao = DaoFactory.getInstance().getUserDao();//dao 的接口回调 System.out.println(userDao); User user = new User(); // user.setBirthday(new Date()); user.setName("dao name1"); user.setMoney(1000.0f); //填加操作 // userDao.addUser(user); // User u=null; // u = userDao.findUser(user.getName(), null); // System.out.println(u.getId()); //更新操作 // User u =userDao.getUser(4); // u.setMoney(2001.01f); // userDao.updateUser(u); //删除操作 User u1 = userDao.getUser(3); System.out.println(u1); //userDao.deleteUser(u1); } }

-------------------------------------------------

package com.itcast.jdbc.dao.impl; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import com.itcast.jdbc.jdbcUtilsSing; import com.itcast.jdbc.dao.DaoException; import com.itcast.jdbc.dao.UserDao; import com.itcast.jdbc.domain.User; public class UserDaoJdbcImpl implements UserDao { public void addUser(User user) { String sql = "insert into user(name,birthday,money) values(?,?,?)"; Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; try { conn = jdbcUtilsSing.getInstance().getConnection(); 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 (SQLException e) { // 运行时异常 throw new DaoException(e.getMessage(), e); } finally { // 释放资源 jdbcUtilsSing.getInstance().free(conn, ps, rs); } } public void deleteUser(User user) { String sql = "delete from user where id = " + user.getId(); Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; try { conn = jdbcUtilsSing.getInstance().getConnection(); ps = conn.prepareStatement(sql); ps.executeUpdate(); } catch (SQLException e) { // 运行时异常 throw new DaoException(e.getMessage(), e); } finally { // 释放资源 jdbcUtilsSing.getInstance().free(conn, ps, rs); } } public User findUser(String loginName, String password) { String sql = "select id,name,birthday,money from user where name = ?"; Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; User user = null; try { conn = jdbcUtilsSing.getInstance().getConnection(); ps = conn.prepareStatement(sql); ps.setString(1, loginName); rs = ps.executeQuery(); // while (rs.next()) { // 通过rs映射一个user user = mappingUser(rs); } } catch (SQLException e) { // 运行时异常 throw new DaoException(e.getMessage(), e); } finally { // 释放资源 jdbcUtilsSing.getInstance().free(conn, ps, rs); } return user; } public User getUser(int userId) { String sql = "select id,name,birthday,money from user where id = ? "; Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; User user = null; try { conn = jdbcUtilsSing.getInstance().getConnection(); ps = conn.prepareStatement(sql); ps.setInt(1,userId); rs = ps.executeQuery(); // while (rs.next()) { user = mappingUser(rs); } } catch (SQLException e) { // 运行时异常 throw new DaoException(e.getMessage(), e); } finally { // 释放资源 jdbcUtilsSing.getInstance().free(conn, ps, rs); } return user; } private User mappingUser(ResultSet rs) throws SQLException { User user = new User(); user.setId(rs.getInt("id")); user.setName(rs.getString("name")); // birthday,日期类型不转换也可以，java.sql.Date是java.util.Date的子类 user.setBirthday(new java.util.Date(rs.getDate("birthday").getTime())); // user.setBirthday(rs.getDate("birthday")); user.setMoney(rs.getFloat("money")); return user; } public void updateUser(User user) { String sql = "update user set name=?,birthday=?,money=? where id=?"; Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; try { conn = jdbcUtilsSing.getInstance().getConnection(); 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.setInt(4, user.getId()); ps.executeUpdate(); } catch (SQLException e) { // 运行时异常 throw new DaoException(e.getMessage(), e); } finally { // 释放资源 jdbcUtilsSing.getInstance().free(conn, ps, rs); } } }

------------------------------------------------

package com.itcast.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; } }

-----------------------------------------------

package com.itcast.jdbc.service; import com.itcast.jdbc.dao.DaoException; import com.itcast.jdbc.dao.UserDao; import com.itcast.jdbc.domain.User; public class UserService { private UserDao userDao; public void regist(User user) { this.userDao.addUser(user); // 也可以在这里处理运行时异常，如果不处理，JVM会自动处理 // try { // this.userDao.addUser(user); // } catch (DaoException e) { // // 具体的处理异常 // } } }