\u4eca\u7b46\u8005\u304c\u4f5c\u3063\u3066\u3044\u308bWEB\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306eDB\u5468\u308a\u5b9f\u88c5\u3067\u3059\u3002
\n\u30a4\u30f3\u30d5\u30e9\u7684\u306b\u306f\u3001\u4e3b\u306bWLS12\uff0bOracleDB\u3068\u306a\u3063\u3066\u3044\u307e\u3059\u304c\u3001\u793e\u5185\u7279\u5b9a\u90e8\u7f72\u306b\u5229\u7528\u304c\u9650\u5b9a\u3055\u308c\u305f\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306a\u306e\u3067\u3001DB\u30bb\u30c3\u30b7\u30e7\u30f3\u306f\u300c\u7bc0\u7d04\u3057\u305f\u3044\u300d\u3068\u3044\u3046\u5fae\u5999\u306a\u8981\u4ef6\u3067\u3059\u3002\u3055\u3089\u306b\u3001WLS\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u8a2d\u5b9a\u306f\u3057\u305f\u304f\u306a\u3044\u3068\u306e\u5e0c\u671b\u3067\u3059\u3002
\n\u305b\u3063\u304b\u304fEE\u4f7f\u3046\u3093\u3067\u3001JPA\u524d\u63d0\u3067\u3084\u308b\u4e8b\u306b\u3057\u307e\u3059\u304c\u3001WEB\u306b\u51fa\u3066\u308b\u6b86\u3069\u306e\u30cd\u30bf\u304cWLS\u306e\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u4f7f\u3063\u3066\u3044\u308b\u3093\u3067\u3059\u3088\u306d\u3002
\n\u30bb\u30c3\u30b7\u30e7\u30f3\u30d7\u30fc\u30eb\u306f\u5225\u9014OracleUCP\u306e\u72ec\u81ea\u5b9f\u88c5\u304c\u3042\u308b\u306e\u3067\u3001persistance.xml\u3067\u6307\u5b9a\u305b\u305a\u306b\u3001UCP\u306e\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u30d7\u30ed\u30b0\u30e9\u30e0\u4e0a\u304b\u3089\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u30de\u30cd\u30fc\u30b8\u30e3\u306b\u6307\u5b9a\u3059\u308b\u3068\u3044\u3046\u30a4\u30e1\u30fc\u30b8\u306a\u3093\u3067\u3059\u304c\u3001WEB\u3067\u8abf\u3079\u306a\u304c\u3089\u5b9f\u969b\u306b\u52d5\u304f\u307e\u3067\u7d50\u69cb\u6642\u9593\u639b\u304b\u308a\u307e\u3057\u305f\u3002\u3002<\/p>\n
\u307e\u305a\u3001Eclipse\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u30d5\u30a1\u30bb\u30c3\u30c8\u306bJPA\u3092\u8ffd\u52a0\u3059\u308b\u3068persistence.xml\u304c\u51fa\u6765\u307e\u3059\u304c\u3001\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u3053\u3053\u3067\u306f\u8a2d\u5b9a\u3057\u306a\u3044\u306e\u3067\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u30af\u30e9\u30b9\u5b9a\u7fa9\u306e\u307f\u66f8\u304d\u307e\u3059\u3002<\/p>\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<persistence version=\"2.0\" xmlns=\"http:\/\/java.sun.com\/xml\/ns\/persistence\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\" xsi:schemaLocation=\"http:\/\/java.sun.com\/xml\/ns\/persistence http:\/\/java.sun.com\/xml\/ns\/persistence\/persistence_2_0.xsd\">\r\n\t<persistence-unit name=\"DBresource\" transaction-type=\"RESOURCE_LOCAL\">\r\n\t\t<class>jp.xxx.zzz.model.user.LoginUser<\/class>\r\n\u4ed6\u30af\u30e9\u30b9\u5b9a\u7fa9\u7701\u7565\r\n \t<exclude-unlisted-classes>true<\/exclude-unlisted-classes>\r\n\t<\/persistence-unit> \r\n<\/persistence><\/pre>\n\u6b21\u306b\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u30af\u30e9\u30b9\uff08\u30c6\u30fc\u30d6\u30eb\u5b9a\u7fa9\u307f\u305f\u3044\u306a\u3082\u306e\uff09<\/p>\n
@Table(name=\"USER_MST\")\r\n@Entity\r\npublic class LoginUser implements Serializable{\r\n\t\r\n\tprivate static final long serialVersionUID = 1L;\r\n\t\r\n\t\/** \u30e6\u30fc\u30b6\u30fc\uff29\uff24*\/ @Id @NotNull @Size(max=20,min=7) \r\n\tprivate String USER_ID;\r\n\t\/** \u30e6\u30fc\u30b6\u30fc\u30d1\u30b9\u30ef\u30fc\u30c9*\/\r\n\tprivate String USER_PASS;\r\n\t\/** \u30e6\u30fc\u30b6\u30fc\u7a2e\u5225*\/ @NotNull\r\n\tprivate String USER_TYPE;\r\n\u4ee5\u4e0b\u3001\u9805\u76ee\u3068\u30b2\u30c3\u30bf\u30bb\u30c3\u30bf\u306f\u7701\u7565\r\n<\/pre>\n\u305d\u306e\u6b21\u304c\u3001\u30c7\u30fc\u30bf\u30a2\u30af\u30bb\u30b9\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\uff08\u30c7\u30fc\u30bf\u64cd\u4f5c\u5b9a\u7fa9\uff09<\/p>\n
\/**\r\n * \u30ed\u30b0\u30a4\u30f3\u30e6\u30fc\u30b6\u30fc\u30de\u30b9\u30bf \r\n * Data access object interface\r\n * *\/\r\npublic interface LoginUserDao {\r\n\r\n \/***\r\n * \u30c7\u30fc\u30bf1\u4ef6\u53d6\u5f97\r\n * @return \u30ad\u30fc\r\n * *\/\r\n public LoginUser find(Object id);\r\n \r\n \/***\r\n * \u30c7\u30fc\u30bf\u65b0\u898f\u4f5c\u6210\r\n * *\/\r\n\tpublic void create(LoginUser entitiy);\r\n\r\n \/**\r\n * \u30c7\u30fc\u30bf\u66f4\u65b0\r\n * *\/\r\n public void update(LoginUser entitiy);\r\n\r\n \/**\r\n * \u30c7\u30fc\u30bf\u5168\u4ef6\u53d6\u5f97\r\n * *\/\r\n public List<LoginUser> getAll();\r\n \r\n \/**\r\n * \u30c7\u30fc\u30bf\u4ef6\u6570\u53d6\u5f97\r\n * *\/\r\n public long getAllCnt();\r\n}\r\n<\/pre>\n\u3055\u3089\u306b\u4e0a\u8a18\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u3092JPA\u5b9f\u88c5\u3057\u305f\u30c7\u30fc\u30bf\u30a2\u30af\u30bb\u30b9\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\uff08DAO)<\/p>\n
\/**\r\n * \u30ed\u30b0\u30a4\u30f3\u30e6\u30fc\u30b6\u30fc\u30de\u30b9\u30bf\r\n * Data access object (JPA)\r\n * *\/\r\n@Stateless\r\n\/\/@TransactionAttribute(TransactionAttributeType.REQUIRED)\r\npublic class LoginUserDaoJpa implements LoginUserDao{\r\n\tprotected static Logger logger = LogManager.getLogger();\r\n\tpublic EntityManager em = null;\r\n\r\n\t\/**\r\n\t * \u30b3\u30f3\u30b9\u30c8\u30e9\u30af\u30bf\r\n\t * *\/\r\n\tpublic LoginUserDaoJpa() {\r\n\t\tsuper();\r\n\t\tem = DBEntityManager.getEntityManager();\r\n\t}\r\n\t\/**\r\n\t * \u30c7\u30fc\u30bf\u691c\u7d22\r\n\t * @param id (key)\r\n\t * @return LoginUser\r\n\t * *\/\r\n\t@Override\r\n\tpublic LoginUser find(Object id) {\r\n\t\treturn em.find(LoginUser.class, id);\r\n\t}\r\n\t\/**\r\n\t * \u30c7\u30fc\u30bf\u65b0\u898f\u767b\u9332\r\n\t * @param ServerConf \r\n\t * *\/\r\n\t@Override\r\n\tpublic void create(LoginUser entity) {\r\n \t\tEntityTransaction txn = em.getTransaction();\r\n \t\ttxn.begin();\r\n\r\n \tif ( ! em.getTransaction().isActive() ){\r\n \t\tem.getTransaction().begin();\r\n \t}\r\n\t\tem.persist(entity);\r\n txn.commit();\r\n\t}\r\n\r\n\t\/**\r\n\t * \u30e6\u30fc\u30b6\u30fc\u30de\u30b9\u30bf\u306e\u5168\u53d6\u5f97\r\n\t * @return \u30ed\u30b0\u30a4\u30f3\u30e6\u30fc\u30b6\u30fc\u30de\u30b9\u30bf\u306e\u30ea\u30b9\u30c8\r\n\t * *\/\r\n\t@SuppressWarnings(\"unchecked\")\r\n\t@Override\r\n\tpublic List<LoginUser> getAll() {\r\n\t\t\/\/\u5f8c\u65e5\u8ffd\u52a0\r\n\t\tem.clear();\r\n\t\tList<LoginUser> result = em.createQuery(\"SELECT c FROM LoginUser c WHERE c.STATUS_FLG < :SFLG ORDER BY c.USER_ID\")\r\n\t\t\t\t\t.setParameter(\"SFLG\", \"9\")\r\n\t\t\t\t\t.getResultList();\r\n \treturn result;\r\n } \t\r\n\t\/**\r\n\t * \u30e6\u30fc\u30b6\u30fc\u30de\u30b9\u30bf\u3088\u308a\u696d\u52d9\u30e1\u30f3\u30d0\u30fc\u306e\u53d6\u5f97\r\n\t * @return \u30ed\u30b0\u30a4\u30f3\u30e6\u30fc\u30b6\u30fc\u30de\u30b9\u30bf\u306e\u30ea\u30b9\u30c8\r\n\t * *\/\r\n\t@SuppressWarnings(\"unchecked\")\r\n\tpublic List<LoginUser> getBizMember() {\r\n\t\t\/\/\u5f8c\u65e5\u8ffd\u52a0\r\n\t\tem.clear();\r\n\t\tList<LoginUser> result = em.createQuery(\"SELECT c FROM LoginUser c WHERE c.USER_TYPE < '5' AND c.STATUS_FLG < :SFLG ORDER BY c.USER_ID\")\r\n\t\t\t\t\t.setParameter(\"SFLG\", \"9\")\r\n\t\t\t\t\t.getResultList();\r\n \treturn result;\r\n }\r\n \/**\r\n * \u30c7\u30fc\u30bf\u66f4\u65b0\r\n * @param ServerConf\r\n * *\/\r\n\t@Override\r\n \tpublic void update(LoginUser entity) {\r\n \t\tEntityTransaction txn = em.getTransaction();\r\n \t\ttxn.begin();\r\n\r\n \tif ( ! em.getTransaction().isActive() ){\r\n \t\tem.getTransaction().begin();\r\n \t}\r\n em.merge(entity);\r\n txn.commit();\r\n }\r\n \t\/**\r\n \t * \u4ef6\u6570\u53d6\u5f97\r\n \t * *\/\r\n\tpublic long getAllCnt() {\r\n \treturn em.createQuery(\"SELECT c FROM UserMaster c\").getMaxResults();\r\n }\r\n}\r\n<\/pre>\n\u4e0a\u8a18DAO\u306e\u30b3\u30f3\u30b9\u30c8\u30e9\u30af\u30bf\u3067\u8aad\u3093\u3067\u3044\u308bEntityManager\u3092\u53d6\u5f97\u3059\u308b\u30b7\u30f3\u30b0\u30eb\u30c8\u30f3\u30af\u30e9\u30b9 <\/p>\n
public class DBEntityManager {\r\n\tprotected static Logger logger = LogManager.getLogger();\r\n\tprivate static Map<String, Object> configOverrides;\r\n\t\r\n\tstatic {\r\n\t\tMap<String, Object> map = new HashMap<String, Object>();\t\t\r\n\t\ttry {\r\n\t\t\t\/\/\u3053\u3053\u306eDBConnectionMgr\u3068\u306f\u3001UCP\u3092\u4f7f\u7528\u3057\u3066\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u623b\u3059\u72ec\u81ea\u5b9f\u88c5\u3067\u3059\u30fb\u30fb\r\n\t\t\t\/\/\u72ec\u81ea\u5b9f\u88c5\u5185\u3067\u5404\u7a2eJDBC\u8a2d\u5b9a\u304c\u3055\u308c\u3066\u3044\u307e\u3059\u30fb\u30fb\r\n\t\t\tmap.put(\"javax.persistence.nonJtaDataSource\", DBConnectionMgr.getDataSource());\r\n\t\t} catch (SQLException e) {\r\n\t\t\tlogger.error(\"DBConnectionPool JpaEntityManager put Error!\", e);\r\n\t\t}\r\n\t\tconfigOverrides = Collections.unmodifiableMap(map);\r\n\t}\r\n\t\/**\r\n\t * EntityManager\u3092\u8fd4\u3057\u307e\u3059\r\n\t * *\/\r\n\tpublic static EntityManager getEntityManager(){\r\n\t\treturn Persistence.createEntityManagerFactory(\"DBresource\", configOverrides).createEntityManager();\r\n\t}\r\n}\r\n<\/pre>\n\u4e0a\u8a18\u3092\u547c\u3073\u51fa\u3057\u3066\u3044\u308bJava\u753b\u9762\u30bd\u30fc\u30b9<\/p>\n
\/**\r\n * \u30e6\u30fc\u30b6\u30fc\u30de\u30b9\u30bf\u7ba1\u7406\u753b\u9762\u51e6\u7406\uff08\u30e6\u30fc\u30b6\u30fc\u4f5c\u6210\u30fb\u66f4\u65b0\u30fb\u524a\u9664\u30fb\u30d1\u30b9\u30ef\u30fc\u30c9\u5909\u66f4\u5171\u901a\uff09\r\n * \r\n * *\/\r\n@ManagedBean(name=\"UserManager\")\r\n@ViewScoped\r\npublic class UserManager implements Serializable {\r\n\tprivate static final long serialVersionUID = 1L;\r\n\r\n @EJB\r\n private LoginUserDao dao;\r\n\t\r\n\tList<LoginUser> List;\r\n\t\r\n\t@ManagedProperty(\"#{userDto}\")\r\n\tLoginUserDto user;\r\n\r\n\tpublic LoginUserDto getUser() {\r\n\t\treturn user;\r\n\t}\r\n\r\n\tpublic void setUser(LoginUserDto user) {\r\n\t\tthis.user = user;\r\n\t}\r\n\r\n\t\/** \u4ee5\u4e0b\u753b\u9762\u9805\u76ee *\/\r\n\tpublic List<LoginUser> getList() {\r\n \tList = dao.getAll();\r\n\t\treturn List;\r\n\t}\r\n\r\n\tpublic void setList(List<LoginUser> list) {\r\n\t\tList = list;\r\n\t}\r\n\u4ee5\u4e0b\u7701\u7565\r\n<\/pre>\n\u6700\u5f8c\u306b\u4e0a\u8a18\u547c\u3073\u51fa\u3057\u7b87\u6240\u306eXHML\u306e\u629c\u7c8b <\/p>\n
<h:dataTable var=\"item\" value=\"#{UserManager.list}\" columnClasses=\"userid,username\" >\r\n <h:column>\r\n <f:facet name=\"header\">#{words.Label_UserID}<\/f:facet>\r\n <h:outputText value=\"#{item.USER_ID}\" \/>\r\n <\/h:column>\r\n <\/h:dataTable>\r\n<\/pre>\n\u5f8c\u3067\u3001\u30c6\u30b9\u30c8\u3057\u305f\u3068\u3053\u308d\u3001DB\u66f4\u65b0\u306f\u51fa\u6765\u3066\u3044\u3066\u3082\u30af\u30a8\u30ea\u30fc\u3067\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b\u3068\u53cd\u6620\u3057\u3066\u3044\u307e\u305b\u3093\u3067\u3057\u305f\u3002\u6c38\u7d9a\u5316\u30b3\u30f3\u30c6\u30ad\u30b9\u30c8\u304b\u3089\u307f\u306e\u4e8b\u8c61\u3068\u601d\u308f\u308c\u307e\u3059\u304c\u3001\u7d30\u304b\u3044\u4ed5\u69d8\u3092\u8abf\u67fb\u3059\u308b\u306e\u306f\u9aa8\u304c\u6298\u308c\u308b\u306e\u3067\u3001\u3001\u3001\u30af\u30a8\u30ea\u30fc\u53d6\u5f97\u524d\u306bEntityManager\u3092clear\u3059\u308b\u4e8b\u3067\u5bfe\u51e6\u3068\u3057\u307e\u3057\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u4eca\u7b46\u8005\u304c\u4f5c\u3063\u3066\u3044\u308bWEB\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306eDB\u5468\u308a\u5b9f\u88c5\u3067\u3059\u3002 \u30a4\u30f3\u30d5\u30e9\u7684\u306b\u306f\u3001\u4e3b … \u7d9a\u304d\u3092\u8aad\u3080