\u6b22\u8fce\u6765\u5230\u300aSpring DataSource JNDI\u4e0eTomcat\u96c6\u6210\u793a\u4f8b\u300b\u6559\u7a0b\u3002\u4e4b\u524d\u6211\u4eec\u5b66\u4e60\u4e86\u5982\u4f55\u4f7f\u7528Spring JDBC\u8fdb\u884c\u6570\u636e\u5e93\u64cd\u4f5c\u3002\u7136\u800c\uff0c\u5927\u591a\u6570\u4f01\u4e1a\u7ea7\u5e94\u7528\u7a0b\u5e8f\u90fd\u90e8\u7f72\u5728\u8bf8\u5982Tomcat\u3001JBoss\u7b49Servlet\u5bb9\u5668\u4e2d\u3002<\/p>\n
\u6211\u4eec\u6df1\u77e5\uff0c\u901a\u8fc7JNDI\u914d\u7f6e\u6570\u636e\u6e90\u662f\u5b9e\u73b0\u8fde\u63a5\u6c60\u5e76\u5145\u5206\u5229\u7528\u5bb9\u5668\u4f18\u52bf\u7684\u9996\u9009\u65b9\u5f0f\u3002\u4eca\u5929\uff0c\u6211\u4eec\u5c06\u63a2\u8ba8\u5982\u4f55\u914d\u7f6e\u4e00\u4e2aSpring Web\u5e94\u7528\u7a0b\u5e8f\uff0c\u4f7f\u5176\u80fd\u591f\u4f7f\u7528Tomcat\u63d0\u4f9b\u7684JNDI\u8fde\u63a5\u3002\u5728\u672c\u793a\u4f8b\u4e2d\uff0c\u6211\u5c06\u4f7f\u7528MySQL\u6570\u636e\u5e93\u670d\u52a1\u5668\uff0c\u5e76\u521b\u5efa\u4e00\u4e2a\u5305\u542b\u4e00\u4e9b\u7b80\u5355\u6570\u636e\u7684\u8868\u3002\u6211\u4eec\u5c06\u6784\u5efa\u4e00\u4e2aSpring RESTful Web\u670d\u52a1\uff0c\u8be5\u670d\u52a1\u5c06\u8fd4\u56de\u5305\u542b\u8be5\u8868\u4e2d\u6240\u6709\u6570\u636e\u5217\u8868\u7684JSON\u54cd\u5e94\u3002<\/p>\n
CREATE TABLE `Employee` (\r\n `id` int(11) unsigned NOT NULL,\r\n `name` varchar(20) DEFAULT NULL,\r\n `role` varchar(20) DEFAULT NULL,\r\n PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n\r\nINSERT INTO `Employee` (`id`, `name`, `role`)\r\nVALUES\r\n\t(1, 'Pankaj', 'CEO'),\r\n\t(2, 'David', 'Manager');\r\nCOMMIT;\r\n<\/code><\/pre>\nSpring MVC\u9879\u76ee\u521b\u5efa<\/h3>\n
\u5728Spring Tool Suite\u4e2d\u521b\u5efa\u4e00\u4e2aSpring MVC\u9879\u76ee\uff0c\u8fd9\u6837\u6211\u4eec\u7684Spring\u5e94\u7528\u7a0b\u5e8f\u9aa8\u67b6\u4ee3\u7801\u5c31\u51c6\u5907\u597d\u4e86\u3002\u5b8c\u6210\u5b9e\u73b0\u540e\uff0c\u6211\u4eec\u7684\u9879\u76ee\u7ed3\u6784\u5c06\u5982\u4e0b\u56fe\u6240\u793a\u3002<\/p>\n
Spring JDBC\u548cJackson\u4f9d\u8d56<\/h3>\n
\u6211\u4eec\u9700\u8981\u5728pom.xml\u6587\u4ef6\u4e2d\u6dfb\u52a0Spring JDBC\u3001Jackson\u548cMySQL\u6570\u636e\u5e93\u9a71\u52a8\u7684\u4f9d\u8d56\u3002\u6700\u7ec8\u7684pom.xml\u6587\u4ef6\u5982\u4e0b\u6240\u793a\u3002<\/p>\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<project xmlns=\"https:\/\/maven.apache.org\/POM\/4.0.0\" xmlns:xsi=\"https:\/\/www.w3.org\/2001\/XMLSchema-instance\"\r\n\txsi:schemaLocation=\"https:\/\/maven.apache.org\/POM\/4.0.0 https:\/\/maven.apache.org\/maven-v4_0_0.xsd\">\r\n\t<modelVersion>4.0.0<\/modelVersion>\r\n\t<groupId>com.Olivia.spring<\/groupId>\r\n\t<artifactId>SpringDataSource<\/artifactId>\r\n\t<name>SpringDataSource<\/name>\r\n\t<packaging>war<\/packaging>\r\n\t<version>1.0.0-BUILD-SNAPSHOT<\/version>\r\n\t<properties>\r\n\t\t<java-version>1.6<\/java-version>\r\n\t\t<org.springframework-version>4.0.2.RELEASE<\/org.springframework-version>\r\n\t\t<org.aspectj-version>1.7.4<\/org.aspectj-version>\r\n\t\t<org.slf4j-version>1.7.5<\/org.slf4j-version>\r\n\t\t<jackson.databind-version>2.2.3<\/jackson.databind-version>\r\n\t<\/properties>\r\n\t<dependencies>\r\n\t\t<!-- Spring JDBC \u652f\u6301 -->\r\n\t\t<dependency>\r\n\t\t\t<groupId>org.springframework<\/groupId>\r\n\t\t\t<artifactId>spring-jdbc<\/artifactId>\r\n\t\t\t<version>${org.springframework-version}<\/version>\r\n\t\t<\/dependency>\r\n\t\t\r\n\t\t<!-- MySQL \u9a71\u52a8 -->\r\n\t\t<dependency>\r\n\t\t\t<groupId>mysql<\/groupId>\r\n\t\t\t<artifactId>mysql-connector-java<\/artifactId>\r\n\t\t\t<version>5.0.5<\/version>\r\n\t\t<\/dependency>\r\n\t\t<!-- Jackson -->\r\n\t\t<dependency>\r\n\t\t\t<groupId>com.fasterxml.jackson.core<\/groupId>\r\n\t\t\t<artifactId>jackson-databind<\/artifactId>\r\n\t\t\t<version>${jackson.databind-version}<\/version>\r\n\t\t<\/dependency>\r\n\t\t<!-- Spring \u6838\u5fc3 -->\r\n\t\t<dependency>\r\n\t\t\t<groupId>org.springframework<\/groupId>\r\n\t\t\t<artifactId>spring-context<\/artifactId>\r\n\t\t\t<version>${org.springframework-version}<\/version>\r\n\t\t\t<exclusions>\r\n\t\t\t\t<!-- \u6392\u9664 Commons Logging\uff0c\u8f6c\u800c\u4f7f\u7528 SLF4j -->\r\n\t\t\t\t<exclusion>\r\n\t\t\t\t\t<groupId>commons-logging<\/groupId>\r\n\t\t\t\t\t<artifactId>commons-logging<\/artifactId>\r\n\t\t\t\t <\/exclusion>\r\n\t\t\t<\/exclusions>\r\n\t\t<\/dependency>\r\n\t\t<dependency>\r\n\t\t\t<groupId>org.springframework<\/groupId>\r\n\t\t\t<artifactId>spring-webmvc<\/artifactId>\r\n\t\t\t<version>${org.springframework-version}<\/version>\r\n\t\t<\/dependency>\r\n\t\t\t\t\r\n\t\t<!-- AspectJ -->\r\n\t\t<dependency>\r\n\t\t\t<groupId>org.aspectj<\/groupId>\r\n\t\t\t<artifactId>aspectjrt<\/artifactId>\r\n\t\t\t<version>${org.aspectj-version}<\/version>\r\n\t\t<\/dependency>\t\r\n\t\t\r\n\t\t<!-- \u65e5\u5fd7 -->\r\n\t\t<dependency>\r\n\t\t\t<groupId>org.slf4j<\/groupId>\r\n\t\t\t<artifactId>slf4j-api<\/artifactId>\r\n\t\t\t<version>${org.slf4j-version}<\/version>\r\n\t\t<\/dependency>\r\n\t\t<dependency>\r\n\t\t\t<groupId>org.slf4j<\/groupId>\r\n\t\t\t<artifactId>jcl-over-slf4j<\/artifactId>\r\n\t\t\t<version>${org.slf4j-version}<\/version>\r\n\t\t\t<scope>runtime<\/scope>\r\n\t\t<\/dependency>\r\n\t\t<dependency>\r\n\t\t\t<groupId>org.slf4j<\/groupId>\r\n\t\t\t<artifactId>slf4j-log4j12<\/artifactId>\r\n\t\t\t<version>${org.slf4j-version}<\/version>\r\n\t\t\t<scope>runtime<\/scope>\r\n\t\t<\/dependency>\r\n\t\t<dependency>\r\n\t\t\t<groupId>log4j<\/groupId>\r\n\t\t\t<artifactId>log4j<\/artifactId>\r\n\t\t\t<version>1.2.15<\/version>\r\n\t\t\t<exclusions>\r\n\t\t\t\t<exclusion>\r\n\t\t\t\t\t<groupId>javax.mail<\/groupId>\r\n\t\t\t\t\t<artifactId>mail<\/artifactId>\r\n\t\t\t\t <\/exclusion>\r\n\t\t\t\t<exclusion>\r\n\t\t\t\t\t<groupId>javax.jms<\/groupId>\r\n\t\t\t\t\t<artifactId>jms<\/artifactId>\r\n\t\t\t\t <\/exclusion>\r\n\t\t\t\t<exclusion>\r\n\t\t\t\t\t<groupId>com.sun.jdmk<\/groupId>\r\n\t\t\t\t\t<artifactId>jmxtools<\/artifactId>\r\n\t\t\t\t <\/exclusion>\r\n\t\t\t\t<exclusion>\r\n\t\t\t\t\t<groupId>com.sun.jmx<\/groupId>\r\n\t\t\t\t\t<artifactId>jmxri<\/artifactId>\r\n\t\t\t\t <\/exclusion>\r\n\t\t\t<\/exclusions>\r\n\t\t\t<scope>runtime<\/scope>\r\n\t\t<\/dependency>\r\n\r\n\t\t<!-- @Inject -->\r\n\t\t<dependency>\r\n\t\t\t<groupId>javax.inject<\/groupId>\r\n\t\t\t<artifactId>javax.inject<\/artifactId>\r\n\t\t\t<version>1<\/version>\r\n\t\t<\/dependency>\r\n\t\t\t\t\r\n\t\t<!-- Servlet -->\r\n\t\t<dependency>\r\n\t\t\t<groupId>javax.servlet<\/groupId>\r\n\t\t\t<artifactId>servlet-api<\/artifactId>\r\n\t\t\t<version>2.5<\/version>\r\n\t\t\t<scope>provided<\/scope>\r\n\t\t<\/dependency>\r\n\t\t<dependency>\r\n\t\t\t<groupId>javax.servlet.jsp<\/groupId>\r\n\t\t\t<artifactId>jsp-api<\/artifactId>\r\n\t\t\t<version>2.1<\/version>\r\n\t\t\t<scope>provided<\/scope>\r\n\t\t<\/dependency>\r\n\t\t<dependency>\r\n\t\t\t<groupId>javax.servlet<\/groupId>\r\n\t\t\t<artifactId>jstl<\/artifactId>\r\n\t\t\t<version>1.2<\/version>\r\n\t\t<\/dependency>\r\n\t\r\n\t\t<!-- \u6d4b\u8bd5 -->\r\n\t\t<dependency>\r\n\t\t\t<groupId>junit<\/groupId>\r\n\t\t\t<artifactId>junit<\/artifactId>\r\n\t\t\t<version>4.7<\/version>\r\n\t\t\t<scope>test<\/scope>\r\n\t\t<\/dependency> \r\n\t<\/dependencies>\r\n <build>\r\n <plugins>\r\n <plugin>\r\n <artifactId>maven-eclipse-plugin<\/artifactId>\r\n <version>2.9<\/version>\r\n <configuration>\r\n <additionalProjectnatures>\r\n <projectnature>org.springframework.ide.eclipse.core.springnature<\/projectnature>\r\n <\/additionalProjectnatures>\r\n <additionalBuildcommands>\r\n <buildcommand>org.springframework.ide.eclipse.core.springbuilder<\/buildcommand>\r\n <\/additionalBuildcommands>\r\n <downloadSources>true<\/downloadSources>\r\n <downloadJavadocs>true<\/downloadJavadocs>\r\n <\/configuration>\r\n <\/plugin>\r\n <plugin>\r\n <groupId>org.apache.maven.plugins<\/groupId>\r\n <artifactId>maven-compiler-plugin<\/artifactId>\r\n <version>2.5.1<\/version>\r\n <configuration>\r\n <source>1.6<\/source>\r\n <target>1.6<\/target>\r\n <compilerArgument>-Xlint:all<\/compilerArgument>\r\n <showWarnings>true<\/showWarnings>\r\n <showDeprecation>true<\/showDeprecation>\r\n <\/configuration>\r\n <\/plugin>\r\n <plugin>\r\n <groupId>org.codehaus.mojo<\/groupId>\r\n <artifactId>exec-maven-plugin<\/artifactId>\r\n <version>1.2.1<\/version>\r\n <configuration>\r\n <mainClass>org.test.int1.Main<\/mainClass>\r\n <\/configuration>\r\n <\/plugin>\r\n <\/plugins>\r\n <\/build>\r\n<\/project>\r\n<\/code><\/pre>\n\u5982\u679c\u60a8\u5bf9Spring RESTful\u670d\u52a1\u8fd8\u4e0d\u719f\u6089\uff0c\u5efa\u8bae\u9605\u8bfb\u300aSpring RESTful Web\u670d\u52a1\u793a\u4f8b\u300b\u6559\u7a0b\u3002<\/p>\n
\u6a21\u578b\u7c7b<\/h3>\n
\u6211\u4eec\u7684\u5458\u5de5\u5bf9\u8c61\u662f\u6839\u636e\u5458\u5de5\u8868\u8bbe\u8ba1\u7684\uff0c\u5177\u4f53\u5f62\u5f0f\u5982\u4e0b\u3002<\/p>\n
package com.Olivia.spring.jdbc.model;\r\n\r\nimport java.io.Serializable;\r\n\r\npublic class Employee implements Serializable{\r\n\r\n\tprivate static final long serialVersionUID = -7788619177798333712L;\r\n\t\r\n\tprivate int id;\r\n\tprivate String name;\r\n\tprivate String role;\r\n\t\r\n\tpublic int getId() {\r\n\t\treturn id;\r\n\t}\r\n\tpublic void setId(int id) {\r\n\t\tthis.id = id;\r\n\t}\r\n\tpublic String getName() {\r\n\t\treturn name;\r\n\t}\r\n\tpublic void setName(String name) {\r\n\t\tthis.name = name;\r\n\t}\r\n\t\r\n\tpublic String getRole() {\r\n\t\treturn role;\r\n\t}\r\n\tpublic void setRole(String role) {\r\n\t\tthis.role = role;\r\n\t}\r\n\t\r\n\t\r\n}\r\n<\/code><\/pre>\nSpring \u63a7\u5236\u5668\u7c7b<\/h3>\n
\u6211\u4eec\u7b80\u5355\u7684\u63a7\u5236\u5668\u7c7b\u5982\u4e0b\u6240\u793a\u3002<\/p>\n
package com.Olivia.spring.jdbc.controller;\r\n\r\nimport java.util.ArrayList;\r\nimport java.util.List;\r\nimport java.util.Map;\r\n\r\nimport javax.sql.DataSource;\r\n\r\nimport org.slf4j.Logger;\r\nimport org.slf4j.LoggerFactory;\r\nimport org.springframework.beans.factory.annotation.Autowired;\r\nimport org.springframework.beans.factory.annotation.Qualifier;\r\nimport org.springframework.jdbc.core.JdbcTemplate;\r\nimport org.springframework.stereotype.Controller;\r\nimport org.springframework.web.bind.annotation.RequestMapping;\r\nimport org.springframework.web.bind.annotation.RequestMethod;\r\nimport org.springframework.web.bind.annotation.ResponseBody;\r\n\r\nimport com.Olivia.spring.jdbc.model.Employee;\r\n\r\n\/**\r\n * Handles requests for the Employee JDBC Service.\r\n *\/\r\n@Controller\r\npublic class EmployeeController {\r\n\t\r\n\tprivate static final Logger logger = LoggerFactory.getLogger(EmployeeController.class);\r\n\t\r\n\t@Autowired\r\n\t@Qualifier(\"dbDataSource\")\r\n\tprivate DataSource dataSource;\r\n\r\n\tpublic void setDataSource(DataSource dataSource) {\r\n\t\tthis.dataSource = dataSource;\r\n\t}\r\n\r\n\t@RequestMapping(value = \"\/rest\/emps\", method = RequestMethod.GET)\r\n\tpublic @ResponseBody List<Employee> getAllEmployees() {\r\n\t\tlogger.info(\"Start getAllEmployees.\");\r\n\t\tList<Employee> empList = new ArrayList<Employee>();\r\n\t\t\/\/JDBC Code - Start\r\n\t\tString query = \"select id, name, role from Employee\";\r\n\t\tJdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);\r\n\r\n\t\tList<Map<String,Object>> empRows = jdbcTemplate.queryForList(query);\r\n\t\t\r\n\t\tfor(Map<String,Object> empRow : empRows){\r\n\t\t\tEmployee emp = new Employee();\r\n\t\t\temp.setId(Integer.parseInt(String.valueOf(empRow.get(\"id\"))));\r\n\t\t\temp.setName(String.valueOf(empRow.get(\"name\")));\r\n\t\t\temp.setRole(String.valueOf(empRow.get(\"role\")));\r\n\t\t\tempList.add(emp);\r\n\t\t}\r\n\t\t\r\n\t\treturn empList;\r\n\t}\r\n\r\n}\r\n<\/code><\/pre>\n\u63a7\u5236\u5668\u7c7b\u7684\u91cd\u70b9\u6709\u4ee5\u4e0b\u51e0\u70b9\uff1a<\/p>\n
\n- DataSource \u5c06\u901a\u8fc7\u540d\u4e3a
dbDataSource<\/code> \u7684 Spring Bean \u914d\u7f6e\u8fdb\u884c\u6ce8\u5165\u3002<\/li>\n- \u6211\u4eec\u4f7f\u7528
JdbcTemplate<\/code> \u6765\u907f\u514d\u5e38\u89c1\u7684\u9519\u8bef\uff0c\u4f8b\u5982\u8d44\u6e90\u6cc4\u6f0f\uff0c\u5e76\u79fb\u9664 JDBC \u6837\u677f\u4ee3\u7801\u3002<\/li>\n- \u83b7\u53d6\u5458\u5de5\u5217\u8868\u7684 URI \u5c06\u662f
https:\/\/{host}:{port}\/SpringDataSource\/rest\/emps<\/code>\u3002<\/li>\n- \u6211\u4eec\u4f7f\u7528
@ResponseBody<\/code> \u5c06\u5458\u5de5\u5bf9\u8c61\u5217\u8868\u4f5c\u4e3a\u54cd\u5e94\u53d1\u9001\uff0cSpring \u5c06\u8d1f\u8d23\u5c06\u5176\u8f6c\u6362\u4e3a JSON\u3002<\/li>\n<\/ul>\nSpring Bean \u914d\u7f6e<\/h3>\nSpring Bean\u914d\u7f6e\u6587\u4ef6\u4e2d\u7684JNDI\u67e5\u627e<\/h3>\n
\u6211\u4eec\u53ef\u4ee5\u901a\u8fc7\u4e24\u79cd\u65b9\u5f0f\u8fdb\u884cJNDI\u67e5\u627e\uff0c\u5e76\u5c06\u5176\u8fde\u63a5\u5230\u63a7\u5236\u5668\u6570\u636e\u6e90\u3002\u6211\u7684Spring Bean\u914d\u7f6e\u6587\u4ef6\u4e2d\u5305\u542b\u4e86\u8fd9\u4e24\u79cd\u65b9\u5f0f\uff0c\u4f46\u5176\u4e2d\u4e00\u79cd\u88ab\u6ce8\u91ca\u6389\u4e86\u3002\u60a8\u53ef\u4ee5\u5728\u8fd9\u4e24\u79cd\u65b9\u5f0f\u4e4b\u95f4\u8fdb\u884c\u5207\u6362\uff0c\u54cd\u5e94\u7ed3\u679c\u5c06\u662f\u76f8\u540c\u7684\u3002<\/p>\n
\n- \n
\u4f7f\u7528jee<\/code>\u547d\u540d\u7a7a\u95f4\u6807\u7b7e\u6267\u884cJNDI\u67e5\u627e\u5e76\u5c06\u5176\u914d\u7f6e\u4e3aSpring Bean\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u6211\u4eec\u8fd8\u9700\u8981\u5305\u542bjee<\/code>\u547d\u540d\u7a7a\u95f4\u548c\u6a21\u5f0f\u5b9a\u4e49\u3002<\/p>\n<\/li>\n- \n
\u901a\u8fc7\u4f20\u9012JNDI\u4e0a\u4e0b\u6587\u540d\u79f0\uff0c\u521b\u5efa\u4e00\u4e2a\u7c7b\u578b\u4e3aorg.springframework.jndi.JndiObjectFactoryBean<\/code>\u7684Bean\u3002\u5bf9\u4e8e\u6b64\u914d\u7f6e\uff0cjndiName<\/code>\u662f\u4e00\u4e2a\u5fc5\u9700\u7684\u53c2\u6570\u3002<\/p>\n<\/li>\n<\/ol>\n\u6211\u7684Spring Bean\u914d\u7f6e\u6587\u4ef6\u5982\u4e0b\u6240\u793a\uff1a<\/p>\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<beans:beans xmlns=\"https:\/\/www.springframework.org\/schema\/mvc\"\r\n\txmlns:jee=\"https:\/\/www.springframework.org\/schema\/jee\"\r\n\txmlns:xsi=\"https:\/\/www.w3.org\/2001\/XMLSchema-instance\" xmlns:beans=\"https:\/\/www.springframework.org\/schema\/beans\"\r\n\txmlns:context=\"https:\/\/www.springframework.org\/schema\/context\"\r\n\txsi:schemaLocation=\"https:\/\/www.springframework.org\/schema\/jee https:\/\/www.springframework.org\/schema\/jee\/spring-jee.xsd\r\n\t\thttps:\/\/www.springframework.org\/schema\/mvc https:\/\/www.springframework.org\/schema\/mvc\/spring-mvc.xsd\r\n\t\thttps:\/\/www.springframework.org\/schema\/beans https:\/\/www.springframework.org\/schema\/beans\/spring-beans.xsd\r\n\t\thttps:\/\/www.springframework.org\/schema\/context https:\/\/www.springframework.org\/schema\/context\/spring-context.xsd\">\r\n\r\n\t<!-- DispatcherServlet \u4e0a\u4e0b\u6587\uff1a\u5b9a\u4e49\u6b64Servlet\u7684\u8bf7\u6c42\u5904\u7406\u57fa\u7840\u8bbe\u65bd -->\r\n\r\n\t<!-- \u542f\u7528 Spring MVC @Controller \u7f16\u7a0b\u6a21\u578b -->\r\n\t<annotation-driven \/>\r\n\r\n\t<!-- \u5904\u7406\u5bf9 \/resources\/** \u7684 HTTP GET \u8bf7\u6c42\uff0c\u901a\u8fc7\u9ad8\u6548\u5730\u63d0\u4f9b ${webappRoot}\/resources \u76ee\u5f55\u4e2d\u7684\u9759\u6001\u8d44\u6e90 -->\r\n\t<resources mapping=\"\/resources\/**\" location=\"\/resources\/\" \/>\r\n\r\n\t<!-- \u5c06 @Controllers \u9009\u62e9\u7528\u4e8e\u6e32\u67d3\u7684\u89c6\u56fe\u89e3\u6790\u4e3a \/WEB-INF\/views \u76ee\u5f55\u4e2d\u7684 .jsp \u8d44\u6e90 -->\r\n\t<beans:bean\r\n\t\tclass=\"org.springframework.web.servlet.view.InternalResourceViewResolver\">\r\n\t\t<beans:property name=\"prefix\" value=\"\/WEB-INF\/views\/\" \/>\r\n\t\t<beans:property name=\"suffix\" value=\".jsp\" \/>\r\n\t<\/beans:bean>\r\n\r\n\t<!-- \u914d\u7f6e\u5c06 JSON \u4f5c\u4e3a\u8bf7\u6c42\u548c\u54cd\u5e94\u63d2\u5165\u65b9\u6cd5\u5904\u7406\u5668 -->\r\n\t<beans:bean\r\n\t\tclass=\"org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter\">\r\n\t\t<beans:property name=\"messageConverters\">\r\n\t\t\t<beans:list>\r\n\t\t\t\t<beans:ref bean=\"jsonMessageConverter\" \/>\r\n\t\t\t<\/beans:list>\r\n\t\t<\/beans:property>\r\n\t<\/beans:bean>\r\n\r\n\t<!-- \u914d\u7f6e Bean \u4ee5\u5c06 JSON \u8f6c\u6362\u4e3a POJO\uff0c\u53cd\u4e4b\u4ea6\u7136 -->\r\n\t<beans:bean id=\"jsonMessageConverter\"\r\n\t\tclass=\"org.springframework.http.converter.json.MappingJackson2HttpMessageConverter\">\r\n\t<\/beans:bean>\r\n\t\r\n\t<!-- \u521b\u5efa DataSource Bean -->\r\n\t \r\n\t<beans:bean id=\"dbDataSource\" class=\"org.springframework.jndi.JndiObjectFactoryBean\">\r\n \t<beans:property name=\"jndiName\" value=\"java:comp\/env\/jdbc\/MyLocalDB\"\/>\r\n\t<\/beans:bean>\r\n\t \r\n\t <!-- \u4f7f\u7528 JEE \u547d\u540d\u7a7a\u95f4\u8fdb\u884c\u67e5\u627e -->\r\n\t <!-- \r\n\t <jee:jndi-lookup id=\"dbDataSource\" jndi-name=\"jdbc\/MyLocalDB\"\r\n \t\t\texpected-type=\"javax.sql.DataSource\" \/>\r\n\t -->\r\n\t \r\n\t<context:component-scan base-package=\"com.Olivia.spring.jdbc.controller\" \/>\r\n\r\n<\/beans:beans>\r\n<\/code><\/pre>\nTomcat\u6570\u636e\u6e90JNDI\u914d\u7f6e<\/h3>\n
\u65e2\u7136\u6211\u4eec\u5df2\u7ecf\u5b8c\u6210\u4e86\u9879\u76ee\uff0c\u6700\u540e\u4e00\u6b65\u662f\u5728Tomcat\u5bb9\u5668\u4e2d\u8fdb\u884cJNDI\u914d\u7f6e\uff0c\u521b\u5efaJNDI\u8d44\u6e90\u3002<\/p>\n
<Resource name=\"jdbc\/TestDB\" \r\n global=\"jdbc\/TestDB\" \r\n auth=\"Container\" \r\n type=\"javax.sql.DataSource\" \r\n driverClassName=\"com.mysql.jdbc.Driver\" \r\n url=\"jdbc:mysql:\/\/localhost:3306\/TestDB\" \r\n username=\"scdev\" \r\n password=\"scdev123\" \r\n \r\n maxActive=\"100\" \r\n maxIdle=\"20\" \r\n minIdle=\"5\" \r\n maxWait=\"10000\"\/>\r\n<\/code><\/pre>\n\u5c06\u4e0a\u8ff0\u914d\u7f6e\u6dfb\u52a0\u5230server.xml<\/code>\u6587\u4ef6\u7684GlobalNamingResources<\/code>\u90e8\u5206\u3002<\/p>\n<ResourceLink name=\"jdbc\/MyLocalDB\"\r\n \tglobal=\"jdbc\/TestDB\"\r\n auth=\"Container\"\r\n type=\"javax.sql.DataSource\" \/>\r\n<\/code><\/pre>\n\u6211\u4eec\u8fd8\u9700\u8981\u521b\u5efa\u8d44\u6e90\u94fe\u63a5\uff0c\u4ee5\u4fbf\u5728\u5e94\u7528\u7a0b\u5e8f\u4e2d\u4f7f\u7528JNDI\u914d\u7f6e\u3002\u5c06\u5176\u6dfb\u52a0\u5230\u670d\u52a1\u5668\u7684context.xml<\/code>\u6587\u4ef6\u4e2d\u662f\u6700\u597d\u7684\u65b9\u6cd5\u3002\u8bf7\u6ce8\u610f\uff0cResourceLink<\/code>\u7684\u540d\u79f0\u5e94\u4e0e\u6211\u4eec\u5728\u5e94\u7528\u7a0b\u5e8f\u4e2d\u4f7f\u7528\u7684JNDI\u4e0a\u4e0b\u6587\u540d\u79f0\u76f8\u5339\u914d\u3002\u6b64\u5916\uff0c\u8bf7\u786e\u4fddMySQL\u7684JAR\u6587\u4ef6\u5b58\u5728\u4e8eTomcat\u7684lib<\/code>\u76ee\u5f55\u4e2d\uff0c\u5426\u5219Tomcat\u5c06\u65e0\u6cd5\u521b\u5efaMySQL\u6570\u636e\u5e93\u8fde\u63a5\u6c60\u3002<\/p>\n\u8fd0\u884cSpring DataSource JNDI\u793a\u4f8b\u9879\u76ee<\/h3>\n
\u6211\u4eec\u7684\u9879\u76ee\u548c\u670d\u52a1\u5668\u914d\u7f6e\u5df2\u7ecf\u5b8c\u6210\uff0c\u73b0\u5728\u53ef\u4ee5\u8fdb\u884c\u6d4b\u8bd5\u4e86\u3002\u5c06\u9879\u76ee\u5bfc\u51fa\u4e3aWAR\u6587\u4ef6\uff0c\u5e76\u5c06\u5176\u653e\u7f6e\u5728Tomcat\u7684\u90e8\u7f72\u76ee\u5f55\u4e2d\u3002REST\u8c03\u7528\u7684JSON\u54cd\u5e94\u5982\u4e0b\u56fe\u6240\u793a\u3002\u5173\u4e8eSpring\u4e0eServlet\u5bb9\u5668JNDI\u4e0a\u4e0b\u6587\u7684\u6574\u5408\u5c31\u53ea\u6709\u8fd9\u4e9b\u4e86\u3002\u60a8\u53ef\u4ee5\u4ece\u4e0b\u9762\u7684\u94fe\u63a5\u4e0b\u8f7d\u793a\u4f8b\u9879\u76ee\uff0c\u5e76\u81ea\u884c\u5c1d\u8bd5\u4ee5\u5b66\u4e60\u66f4\u591a\u3002<\/p>\n