Advertisement
Guest User

Untitled

a guest
May 19th, 2016
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 26.49 KB | None | 0 0
  1. <?php
  2.  
  3. header('Content-Type: application/json;charset=UTF-8');
  4. echo json_encode($User_c2);
  5. ?>
  6.  
  7. CREATE TABLE `user` (
  8. `id` int(11) NOT NULL,
  9. `username` varchar(100) NOT NULL,
  10. `password` varchar(100) NOT NULL,
  11. `isAdmin` tinyint(1) NOT NULL,
  12. `is_delete_user` tinyint(1) NOT NULL
  13. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  14.  
  15. http://localhost/Perumahan/index.php/User_c
  16. [
  17. {
  18. "id": "4",
  19. "username": "2222",
  20. "password": "7cd24a3933af3d7ca86291ad6c3cc1b14adcc9b5",
  21. "isAdmin": "0",
  22. "is_delete_user": "0"
  23. },
  24. {
  25. "id": "5",
  26. "username": "marley5",
  27. "password": "",
  28. "isAdmin": "1",
  29. "is_delete_user": "0"
  30. },
  31. {
  32. "id": "6",
  33. "username": "marley6",
  34. "password": "",
  35. "isAdmin": "1",
  36. "is_delete_user": "0"
  37. },
  38. {
  39. "id": "7",
  40. "username": "marley7",
  41. "password": "da39a3ee5e6b4b0d3255bfef95601890afd80709",
  42. "isAdmin": "1",
  43. "is_delete_user": "0"
  44. },
  45. {
  46. "id": "9",
  47. "username": "marley9",
  48. "password": "da39a3ee5e6b4b0d3255bfef95601890afd80709",
  49. "isAdmin": "1",
  50. "is_delete_user": "0"
  51. }
  52. ]
  53.  
  54. import javax.persistence.Basic;
  55. import javax.persistence.Column;
  56. import javax.persistence.Entity;
  57. import javax.persistence.GeneratedValue;
  58. import javax.persistence.GenerationType;
  59. import javax.persistence.Id;
  60. import javax.persistence.Table;
  61. import com.fasterxml.jackson.annotation.JsonIgnoreProperties;
  62.  
  63. @Entity
  64. @Table(name="user2")
  65. public class User {
  66. @Id
  67. @GeneratedValue(strategy = GenerationType.IDENTITY)
  68. @Column(name = "id",unique=true, nullable = false)
  69. private Integer id;
  70. @Column
  71. private String username;
  72. @Column
  73. private String password;
  74. @Column
  75. private String isAdmin;
  76. @Column
  77. private String is_delete_user;
  78.  
  79. public Integer getId() {
  80. return id;
  81. }
  82. public void setId(Integer id) {
  83. this.id = id;
  84. }
  85. public String getUsername() {
  86. return username;
  87. }
  88. public void setUsername(String username) {
  89. this.username = username;
  90. }
  91. public String getPassword() {
  92. return password;
  93. }
  94. public void setPassword(String password) {
  95. this.password = password;
  96. }
  97. public String getIsAdmin() {
  98. return isAdmin;
  99. }
  100. public void setIsAdmin(String isAdmin) {
  101. this.isAdmin = isAdmin;
  102. }
  103. public String getIs_delete_user() {
  104. return is_delete_user;
  105. }
  106. public void setIs_delete_user(String is_delete_user) {
  107. this.is_delete_user = is_delete_user;
  108. }
  109.  
  110. }
  111.  
  112. package satria.dao;
  113. import java.util.LinkedHashMap;
  114. import java.util.List;
  115. import org.springframework.transaction.annotation.Transactional;
  116. import satria.model.User;
  117. public interface UserDAO {
  118. //void addUser(User[] users);
  119. //void addUser(User users);
  120. void addUser(List<LinkedHashMap> users);
  121. //void addUser(List<User> users);
  122.  
  123. }
  124.  
  125. import java.sql.Connection;
  126. import java.util.LinkedHashMap;
  127. import java.util.List;
  128.  
  129. import org.hibernate.Session;
  130. import org.hibernate.SessionFactory;
  131. import org.hibernate.Transaction;
  132. import org.springframework.beans.factory.annotation.Autowired;
  133. import org.springframework.stereotype.Repository;
  134. import org.springframework.transaction.annotation.Transactional;
  135.  
  136. import satria.model.User;
  137.  
  138. @Repository
  139. @Transactional
  140. public class UserDAOImpl implements UserDAO{
  141. @Autowired
  142. private SessionFactory sessionFactory;
  143.  
  144. public void addUser(List<LinkedHashMap> users) {
  145. Session session = sessionFactory.getCurrentSession();
  146.  
  147. session.save(users);
  148. }
  149.  
  150. }
  151.  
  152. package satria.service;
  153.  
  154. import java.util.LinkedHashMap;
  155. import java.util.List;
  156. import org.springframework.transaction.annotation.Transactional;
  157. import satria.model.User;
  158. public interface UserService {
  159. @Transactional
  160. void addUser(List<LinkedHashMap> users);
  161.  
  162. }
  163.  
  164. package satria.service;
  165.  
  166. import java.util.LinkedHashMap;
  167. import java.util.List;
  168.  
  169. import org.springframework.beans.factory.annotation.Autowired;
  170. import org.springframework.stereotype.Service;
  171. import org.springframework.transaction.annotation.Transactional;
  172.  
  173. import satria.dao.UserDAO;
  174. import satria.model.User;
  175.  
  176.  
  177. @Service
  178. public class UserServiceImpl implements UserService {
  179.  
  180. @Autowired
  181. private UserDAO userDAO;
  182.  
  183. @Transactional
  184. //public void addUser(List<LinkedHashMap> users){
  185. public void addUser(List<LinkedHashMap> users){
  186. userDAO.addUser(users);
  187. //System.out.print("BarangService"+barang);
  188. }
  189. }
  190.  
  191. package satria.utility;
  192.  
  193. import org.hibernate.SessionFactory;
  194. import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
  195. import org.hibernate.cfg.Configuration;
  196. import org.hibernate.service.ServiceRegistry;
  197.  
  198. public class HibernateUtility {
  199. private static final SessionFactory sessionFactory = buildSessionFactory();
  200.  
  201. private static SessionFactory buildSessionFactory() {
  202. Configuration configuration = new Configuration();
  203. configuration.configure();
  204.  
  205. ServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder()
  206. .applySettings(configuration.getProperties()).build();
  207. SessionFactory sessionFactory = configuration.buildSessionFactory(serviceRegistry);
  208.  
  209. return sessionFactory;
  210. }
  211.  
  212. public static SessionFactory getSessionFactory() {
  213. return sessionFactory;
  214. }
  215.  
  216. }
  217.  
  218. package satria.controller;
  219.  
  220. import java.io.IOException;
  221. import java.io.InputStream;
  222. import java.io.InputStreamReader;
  223.  
  224. import static org.junit.Assert.assertEquals;
  225. import java.io.StringReader;
  226. import java.lang.reflect.Type;
  227. import java.net.MalformedURLException;
  228. import java.net.URL;
  229. import java.util.Arrays;
  230. import java.util.HashMap;
  231. import java.util.Iterator;
  232. import java.util.LinkedHashMap;
  233. import java.util.List;
  234. import java.util.Map;
  235. import org.apache.log4j.Logger;
  236.  
  237. import javax.servlet.http.HttpServletRequest;
  238. import javax.servlet.http.HttpServletResponse;
  239. import javax.validation.Valid;
  240.  
  241. import org.codehaus.jackson.JsonGenerationException;
  242. import org.codehaus.jackson.JsonNode;
  243. import org.codehaus.jackson.JsonParseException;
  244. import org.codehaus.jackson.JsonParser;
  245. import org.codehaus.jackson.map.JsonMappingException;
  246. import org.codehaus.jackson.map.ObjectMapper;
  247. import org.jboss.logging.Message;
  248. import org.junit.Test;
  249. import org.slf4j.LoggerFactory;
  250. import org.springframework.beans.factory.annotation.Autowired;
  251. import org.springframework.boot.autoconfigure.SpringBootApplication;
  252. import org.springframework.dao.DataIntegrityViolationException;
  253. import org.springframework.http.HttpEntity;
  254. import org.springframework.http.HttpHeaders;
  255. import org.springframework.http.MediaType;
  256. import org.springframework.http.ResponseEntity;
  257. import org.springframework.http.converter.HttpMessageConverter;
  258. import org.springframework.http.converter.json.MappingJackson2HttpMessageConverter;
  259. import org.springframework.http.converter.xml.Jaxb2RootElementHttpMessageConverter;
  260. import org.springframework.stereotype.Controller;
  261. import org.springframework.ui.Model;
  262. import org.springframework.http.HttpStatus;
  263. import org.springframework.ui.ModelMap;
  264. import org.springframework.validation.BindingResult;
  265. import org.springframework.web.bind.annotation.RequestBody;
  266. import org.springframework.web.bind.annotation.RequestMapping;
  267. import org.springframework.web.bind.annotation.RequestMethod;
  268. import org.springframework.web.bind.annotation.RequestParam;
  269. import org.springframework.web.bind.annotation.ResponseBody;
  270. import org.springframework.web.bind.annotation.ResponseStatus;
  271. import org.springframework.web.bind.annotation.RestController;
  272. import org.springframework.web.client.RestTemplate;
  273. import org.springframework.web.servlet.ModelAndView;
  274. import org.springframework.web.util.UriComponentsBuilder;
  275.  
  276. import com.google.gson.Gson;
  277. import com.google.gson.GsonBuilder;
  278. import com.google.gson.JsonArray;
  279. import com.google.gson.reflect.TypeToken;
  280. import com.google.gson.stream.JsonReader;
  281.  
  282. import satria.model.User;
  283. import satria.service.UserService;
  284.  
  285. @Controller
  286. @RequestMapping(value = "/user")
  287.  
  288. public class UserController {
  289.  
  290. @Autowired
  291. private UserService userService;
  292. private Gson gson = new GsonBuilder().setDateFormat("dd/MM/yyyy").create();
  293.  
  294. @ResponseBody
  295. @RequestMapping(value = "/rest/list", method = RequestMethod.GET, produces = { "application/json; charset=UTF-8" })
  296.  
  297. public String listOfUser() {
  298. //User users = new User();
  299.  
  300. String URI = "http://localhost/Perumahan/index.php/User_c";
  301. RestTemplate restTemplate = new RestTemplate();
  302. HttpHeaders headers = new HttpHeaders();
  303. headers.setContentType(MediaType.APPLICATION_JSON);
  304. List<LinkedHashMap> users = restTemplate.getForObject(URI, List.class);
  305. //userService.addUser(users);
  306. return gson.toJson(users);
  307.  
  308. }
  309.  
  310. @ResponseBody
  311. @RequestMapping(value = "/rest/addList", method = RequestMethod.POST, produces = { "application/json; charset=UTF-8" })
  312.  
  313. public String listOfUserPOST() {
  314. //User users = new User();
  315.  
  316. String URI = "http://localhost/Perumahan/index.php/User_c";
  317. RestTemplate restTemplate = new RestTemplate();
  318. HttpHeaders headers = new HttpHeaders();
  319. headers.setContentType(MediaType.APPLICATION_JSON);
  320. List<LinkedHashMap> users = restTemplate.getForObject(URI, List.class);
  321. userService.addUser(users);
  322. String message ="Succes Input to MySQL";
  323. return gson.toJson(message);
  324.  
  325. }
  326.  
  327. @ResponseBody
  328. @RequestMapping(value = "/rest/add", method = RequestMethod.GET, produces = { "application/json; charset=UTF-8" })
  329.  
  330. public String listOfUser2() throws JsonParseException, JsonMappingException, MalformedURLException, IOException {
  331. // String URI = "http://localhost:8085/Perumahan/index.php/User_c";
  332. // RestTemplate restTemplate = new RestTemplate();
  333. try {
  334. ObjectMapper mapper = new ObjectMapper();
  335. User[] users = mapper.readValue(new URL("http://localhost/Perumahan/index.php/User_c"), User[].class);
  336. //return gson.toJson(users); pake ini bisa
  337. userService.addUser(users);
  338. } catch (JsonGenerationException e) {
  339. e.printStackTrace();
  340. } catch (JsonMappingException e) {
  341. e.printStackTrace();
  342. } catch (IOException e) {
  343. e.printStackTrace();
  344. }
  345. System.out.println("sampeeee");
  346. return "";
  347. }
  348.  
  349. @ResponseBody
  350. @RequestMapping(value = "/rest/add2", method = RequestMethod.POST, produces = { "application/json; charset=UTF-8" })
  351.  
  352. public String listOfUser3() throws JsonParseException, JsonMappingException, MalformedURLException, IOException {
  353. // String URI = "http://localhost:8085/Perumahan/index.php/User_c";
  354. // RestTemplate restTemplate = new RestTemplate();
  355. try {
  356. ObjectMapper mapper = new ObjectMapper();
  357. User[] users = mapper.readValue(new URL("http://localhost/Perumahan/index.php/User_c"), User[].class);
  358. // userService.addUser(users);
  359. String message = "Barang was successfully added.";
  360.  
  361. return gson.toJson(message);
  362. } catch (JsonGenerationException e) {
  363. e.printStackTrace();
  364. } catch (JsonMappingException e) {
  365. e.printStackTrace();
  366. } catch (IOException e) {
  367. e.printStackTrace();
  368. }
  369. return null;
  370. }
  371. }
  372.  
  373. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  374. xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
  375. <modelVersion>4.0.0</modelVersion>
  376. <groupId>com.satria</groupId>
  377. <artifactId>SpringHibernateReadUrlJson</artifactId>
  378. <packaging>war</packaging>
  379. <version>0.0.1-SNAPSHOT</version>
  380. <name>SpringHibernateReadUrlJson Maven Webapp</name>
  381. <url>http://maven.apache.org</url>
  382. <properties>
  383. <hibernate.version>4.3.1.Final</hibernate.version>
  384. <mysql.connector.version>5.1.21</mysql.connector.version>
  385. <spring.version>4.2.5.RELEASE</spring.version>
  386. </properties>
  387.  
  388. <dependencies>
  389. <!-- DB related dependencies -->
  390. <dependency>
  391. <groupId>org.hibernate</groupId>
  392. <artifactId>hibernate-core</artifactId>
  393. <version>${hibernate.version}</version>
  394. </dependency>
  395. <dependency>
  396. <groupId>org.hibernate</groupId>
  397. <artifactId>hibernate-entitymanager</artifactId>
  398. <version>${hibernate.version}</version>
  399. </dependency>
  400.  
  401.  
  402. <dependency>
  403. <groupId>org.hibernate</groupId>
  404. <artifactId>hibernate-validator</artifactId>
  405. <version>${hibernate.version}</version>
  406. </dependency>
  407. <dependency>
  408. <groupId>mysql</groupId>
  409. <artifactId>mysql-connector-java</artifactId>
  410. <version>${mysql.connector.version}</version>
  411. </dependency>
  412. <dependency>
  413. <groupId>commons-dbcp</groupId>
  414. <artifactId>commons-dbcp</artifactId>
  415. <version>1.4</version>
  416. </dependency>
  417. <dependency>
  418. <groupId>javassist</groupId>
  419. <artifactId>javassist</artifactId>
  420. <version>3.12.1.GA</version>
  421. </dependency>
  422. <!-- SPRING -->
  423. <dependency>
  424. <groupId>org.springframework</groupId>
  425. <artifactId>spring-webmvc</artifactId>
  426. <version>${spring.version}</version>
  427. </dependency>
  428. <dependency>
  429. <groupId>org.springframework</groupId>
  430. <artifactId>spring-tx</artifactId>
  431. <version>${spring.version}</version>
  432. </dependency>
  433. <dependency>
  434. <groupId>org.springframework</groupId>
  435. <artifactId>spring-jdbc</artifactId>
  436. <version>${spring.version}</version>
  437. </dependency>
  438. <dependency>
  439. <groupId>org.springframework</groupId>
  440. <artifactId>spring-orm</artifactId>
  441. <version>${spring.version}</version>
  442. </dependency>
  443. <!-- CGLIB is required to process @Configuration classes -->
  444. <dependency>
  445. <groupId>cglib</groupId>
  446. <artifactId>cglib</artifactId>
  447. <version>2.2.2</version>
  448. </dependency>
  449. <!-- Servlet API and JSTL -->
  450. <dependency>
  451. <groupId>javax.servlet</groupId>
  452. <artifactId>javax.servlet-api</artifactId>
  453. <version>3.0.1</version>
  454. <scope>provided</scope>
  455. </dependency>
  456. <dependency>
  457. <groupId>jstl</groupId>
  458. <artifactId>jstl</artifactId>
  459. <version>1.2</version>
  460. </dependency>
  461.  
  462. <dependency>
  463. <groupId>javax.servlet.jsp</groupId>
  464. <artifactId>jsp-api</artifactId>
  465. <version>2.2</version>
  466. <scope>provided</scope>
  467. </dependency>
  468.  
  469. <!-- Test -->
  470. <!-- http://mvnrepository.com/artifact/junit/junit -->
  471. <dependency>
  472. <groupId>junit</groupId>
  473. <artifactId>junit</artifactId>
  474. <version>4.12</version>
  475. </dependency>
  476.  
  477. <dependency>
  478. <groupId>org.springframework</groupId>
  479. <artifactId>spring-test</artifactId>
  480. <version>${spring.version}</version>
  481. <scope>test</scope>
  482. </dependency>
  483. <dependency>
  484. <groupId>org.springframework</groupId>
  485. <artifactId>spring-test-mvc</artifactId>
  486. <version>1.0.0.M1</version>
  487. <scope>test</scope>
  488. </dependency>
  489. <!-- Dependency for Jquery -->
  490. <!-- <dependency> <groupId>org.webjars</groupId> <artifactId>jquery</artifactId>
  491. <version>2.1.4</version> </dependency> <dependency> <groupId>org.webjars</groupId>
  492. <artifactId>jquery-validation</artifactId> <version>1.14.0-1</version> </dependency> -->
  493. <dependency>
  494. <groupId>javax.validation</groupId>
  495. <artifactId>validation-api</artifactId>
  496. <version>1.1.0.Final</version>
  497. </dependency>
  498. <!-- Library untuk JSON -->
  499. <dependency>
  500. <groupId>com.google.code.gson</groupId>
  501. <artifactId>gson</artifactId>
  502. <version>2.4</version>
  503. </dependency>
  504. <!-- Display tag library for paging -->
  505. <dependency>
  506. <groupId>displaytag</groupId>
  507. <artifactId>displaytag</artifactId>
  508. <version>1.2</version>
  509. </dependency>
  510. <dependency>
  511. <groupId>displaytag</groupId>
  512. <artifactId>displaytag-export-poi</artifactId>
  513. <version>1.2</version>
  514. </dependency>
  515. <!-- for log. -->
  516. <dependency>
  517. <groupId>org.springframework.boot</groupId>
  518. <artifactId>spring-boot-starter</artifactId>
  519. <version>1.3.3.RELEASE</version>
  520. </dependency>
  521. <!-- Convert to json -->
  522. <dependency>
  523. <groupId>com.google.code.gson</groupId>
  524. <artifactId>gson</artifactId>
  525. <version>2.6.2</version>
  526. </dependency>
  527. <dependency>
  528. <groupId>com.fasterxml.jackson.core</groupId>
  529. <artifactId>jackson-core</artifactId>
  530. <version>2.7.3</version>
  531. </dependency>
  532.  
  533. <dependency>
  534. <groupId>com.fasterxml.jackson.core</groupId>
  535. <artifactId>jackson-databind</artifactId>
  536. <version>2.7.3</version>
  537. </dependency>
  538.  
  539. <dependency>
  540. <groupId>com.fasterxml.jackson.core</groupId>
  541. <artifactId>jackson-annotations</artifactId>
  542. <version>2.7.3</version>
  543. </dependency>
  544. <dependency>
  545. <groupId>org.codehaus.jackson</groupId>
  546. <artifactId>jackson-mapper-asl</artifactId>
  547. <version>1.9.13</version>
  548. </dependency>
  549.  
  550.  
  551.  
  552. </dependencies>
  553. <repositories>
  554. <repository>
  555. <id>spring-maven-milestone</id>
  556. <name>Spring Maven Milestone Repository</name>
  557. <url>http://maven.springframework.org/milestone</url>
  558. </repository>
  559. </repositories>
  560.  
  561. <build>
  562. <finalName>SpringHibernateReadUrlJson</finalName>
  563. <plugins>
  564. <plugin>
  565. <artifactId>maven-compiler-plugin</artifactId>
  566. <version>2.3.2</version>
  567. <configuration>
  568. <source>1.8</source>
  569. <target>1.8</target>
  570. </configuration>
  571. </plugin>
  572. <plugin>
  573. <groupId>org.apache.maven.plugins</groupId>
  574. <artifactId>c</artifactId>
  575. <version>3.3</version>
  576. <configuration>
  577. <source>1.8</source>
  578. <target>1.8</target>
  579. </configuration>
  580. </plugin>
  581.  
  582. <plugin>
  583. <groupId>org.eclipse.jetty</groupId>
  584. <artifactId>jetty-maven-plugin</artifactId>
  585. <version>9.2.11.v20150529</version>
  586. <configuration>
  587. <scanIntervalSeconds>10</scanIntervalSeconds>
  588. <webApp>
  589. <contextPath>/SpringHibernateMysqlRest</contextPath>
  590. </webApp>
  591. </configuration>
  592. </plugin>
  593. <!-- Config: Maven Tomcat Plugin -->
  594. <!-- http://mvnrepository.com/artifact/org.apache.tomcat.maven/tomcat7-maven-plugin -->
  595. <plugin>
  596. <groupId>org.apache.tomcat.maven</groupId>
  597. <artifactId>tomcat7-maven-plugin</artifactId>
  598. <version>2.2</version>
  599. <!-- Config: contextPath and Port (Default - /HelloSpringMVC : 8080) -->
  600. <!-- <configuration> <path>/</path> <port>8899</port> </configuration> -->
  601. </plugin>
  602.  
  603. </plugins>
  604. </build>
  605. </project>
  606.  
  607. <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  608. xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
  609. xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
  610. version="3.0">
  611. <display-name>Archetype Created Web Application</display-name>
  612. <!-- Spring Configuration -->
  613. <servlet>
  614. <servlet-name>spring</servlet-name>
  615. <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  616. <load-on-startup>1</load-on-startup>
  617. </servlet>
  618. <servlet-mapping>
  619. <servlet-name>spring</servlet-name>
  620. <url-pattern>/</url-pattern>
  621. </servlet-mapping>
  622. <context-param>
  623. <param-name>contextConfigLocation</param-name>
  624. <param-value>/WEB-INF/spring-servlet.xml</param-value>
  625. </context-param>
  626. <listener>
  627. <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  628. </listener>
  629. <!-- Config for accessing JS/CSS files from with JSP files -->
  630. <servlet-mapping>
  631. <servlet-name>default</servlet-name>
  632. <url-pattern>*.js</url-pattern>
  633. </servlet-mapping>
  634.  
  635. <servlet-mapping>
  636. <servlet-name>default</servlet-name>
  637. <url-pattern>*.css</url-pattern>
  638. </servlet-mapping>
  639. </web-app>
  640.  
  641. <?xml version="1.0" encoding="ISO-8859-1"?>
  642. <beans xmlns="http://www.springframework.org/schema/beans"
  643. xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:context="http://www.springframework.org/schema/context"
  644. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
  645. xmlns:tx="http://www.springframework.org/schema/tx"
  646. xsi:schemaLocation="http://www.springframework.org/schema/beans
  647. http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
  648. http://www.springframework.org/schema/mvc
  649. http://www.springframework.org/schema/mvc/spring-mvc.xsd
  650. http://www.springframework.org/schema/context
  651. http://www.springframework.org/schema/context/spring-context-4.0.xsd
  652. http://www.springframework.org/schema/tx
  653. http://www.springframework.org/schema/tx/spring-tx-4.0.xsd">
  654.  
  655.  
  656. <context:property-placeholder location="classpath:application.properties" />
  657. <!-- <context:property-placeholder location="classpath:validation.properties"
  658. /> -->
  659. <tx:annotation-driven />
  660. <context:component-scan base-package="satria.*" />
  661.  
  662. <!-- Untuk manggil validation.properties -->
  663. <!-- <bean id="messageSource" class="org.springframework.context.support.ResourceBundleMessageSource">
  664. <property name="basename" value="classpath:validation" /> <property name="defaultEncoding"
  665. value="UTF-8" /> </bean> -->
  666. <!-- <bean id="messageSource"
  667. class="org.springframework.context.support.ReloadableResourceBundleMessageSource"
  668. p:basename="/WEB-INF/messages/messages_en_US" />
  669. <bean id="barangValidator" class="satria.validator.BarangValidator" />
  670. -->
  671. <!-- Configuration defining views files -->
  672.  
  673. <bean
  674. class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  675. <property name="prefix">
  676. <value>/WEB-INF/view/</value>
  677. </property>
  678. <property name="suffix">
  679. <value>.jsp</value>
  680. </property>
  681. </bean>
  682. <!-- Enables the Sprtng MVC @Controller programming model -->
  683. <!-- <tx:annotation-driven transaction-manager="transactionManager" /> -->
  684.  
  685. <bean id="dataSource"
  686. class="org.springframework.jdbc.datasource.DriverManagerDataSource">
  687. <property name="driverClassName" value="${jdbc.driverClassName}" />
  688. <property name="url" value="${jdbc.url}" />
  689. <property name="username" value="${jdbc.username}" />
  690. <property name="password" value="${jdbc.password}" />
  691.  
  692. </bean>
  693.  
  694. <bean id="sessionFactory"
  695. class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
  696. <property name="dataSource" ref="dataSource" />
  697. <property name="packagesToScan">
  698. <list>
  699. <value>satria.*</value>
  700. </list>
  701. </property>
  702. <property name="hibernateProperties">
  703. <props>
  704. <prop key="hibernate.dialect">${hibernate.dialect}</prop>
  705. <prop key="hibernate.show_sql">${hibernate.show_sql:true}</prop>
  706. <prop key="hibernate.format_sql">${hibernate.format_sql:false}</prop>
  707. <prop key="hibernate.jdbc.batch_size">30</prop>
  708. </props>
  709. </property>
  710. </bean>
  711.  
  712. <bean id="transactionManager"
  713. class="org.springframework.orm.hibernate4.HibernateTransactionManager">
  714. <property name="dataSource" ref="dataSource" />
  715. <property name="sessionFactory" ref="sessionFactory" />
  716. </bean>
  717.  
  718. <bean id="persistenceExceptionTranslationPostProcessor"
  719. class="org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor" />
  720.  
  721. </beans>
  722.  
  723. http://localhost:8080/SpringHibernateReadUrlJson/user/rest/list
  724.  
  725. [
  726. {
  727. "id": "4",
  728. "username": "2222",
  729. "password": "7cd24a3933af3d7ca86291ad6c3cc1b14adcc9b5",
  730. "isAdmin": "0",
  731. "is_delete_user": "0"
  732. },
  733. {
  734. "id": "5",
  735. "username": "marley5",
  736. "password": "",
  737. "isAdmin": "1",
  738. "is_delete_user": "0"
  739. },
  740. {
  741. "id": "6",
  742. "username": "marley6",
  743. "password": "",
  744. "isAdmin": "1",
  745. "is_delete_user": "0"
  746. },
  747. {
  748. "id": "7",
  749. "username": "marley7",
  750. "password": "da39a3ee5e6b4b0d3255bfef95601890afd80709",
  751. "isAdmin": "1",
  752. "is_delete_user": "0"
  753. },
  754. {
  755. "id": "9",
  756. "username": "marley9",
  757. "password": "da39a3ee5e6b4b0d3255bfef95601890afd80709",
  758. "isAdmin": "1",
  759. "is_delete_user": "0"
  760. }
  761. ]
  762.  
  763. [
  764. {
  765.  
  766. "username": "2222",
  767. "password": "7cd24a3933af3d7ca86291ad6c3cc1b14adcc9b5",
  768. "isAdmin": "0",
  769. "is_delete_user": "0"
  770. },
  771. {
  772.  
  773. "username": "marley5",
  774. "password": "",
  775. "isAdmin": "1",
  776. "is_delete_user": "0"
  777. },
  778. {
  779.  
  780. "username": "marley6",
  781. "password": "",
  782. "isAdmin": "1",
  783. "is_delete_user": "0"
  784. },
  785. {
  786.  
  787. "username": "marley7",
  788. "password": "da39a3ee5e6b4b0d3255bfef95601890afd80709",
  789. "isAdmin": "1",
  790. "is_delete_user": "0"
  791. },
  792. {
  793.  
  794. "username": "marley9",
  795. "password": "da39a3ee5e6b4b0d3255bfef95601890afd80709",
  796. "isAdmin": "1",
  797. "is_delete_user": "0"
  798. }
  799. ]
  800.  
  801. HTTP Status 404 -
  802.  
  803. type Status report
  804.  
  805. message
  806.  
  807. description The requested resource () is not available.
  808.  
  809. Apache Tomcat/6.0.29
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement