|
1
37
38 package com.sun.j2ee.blueprints.util.dao;
39
40 import java.sql.*;
41 import javax.sql.*;
42 import javax.naming.*;
43 import com.sun.j2ee.blueprints.servicelocator.web.ServiceLocator;
44
45 public class DAOUtils {
46
47 private DAOUtils() { }
48
49 private static DataSource getDataSource(String  dsName)
50 throws DAOSystemException {
51 String dataSourceName = ServiceLocator.getInstance().getString(dsName);
52 return (DataSource) ServiceLocator.getInstance().getDataSource(dataSourceName);
53 }
54
55 public static Connection getDBConnection(String source)
56 throws DAOSystemException {
57 try {
58 return getDataSource(source).getConnection();
59 } catch (SQLException se) {
60 throw new DAOSystemException("SQL Exception while getting "
61 + "DB connection : \n" + se);
62 }
63 }
64
65 public static void closeConnection(Connection dbConnection)
66 throws DAOSystemException {
67 try {
68 if (dbConnection != null && !dbConnection.isClosed()) {
69 dbConnection.close();
70 }
71 } catch (SQLException se) {
72 throw new DAOSystemException("SQL Exception while closing "
73 + "DB connection : \n" + se);
74 }
75 }
76
77 public static void closeResultSet(ResultSet result)
78 throws DAOSystemException {
79 try {
80 if (result != null) {
81 result.close();
82 result = null;
83 }
84 } catch (SQLException se) {
85 throw new DAOSystemException("SQL Exception while closing "
86 + "Result Set : \n" + se);
87 }
88 }
89
90 public static void closeStatement(PreparedStatement stmt)
91 throws DAOSystemException {
92 try {
93 if (stmt != null) {
94 stmt.close();
95 }
96 } catch (SQLException se) {
97 throw new DAOSystemException("SQL Exception while closing "
98 + "Statement : \n" + se);
99 }
100 }
101 }
102 |
Popular Tags |
Java API By Example, From Geeks To Geeks.