Learn By Example
|
1 2 3 4 |
@RequestMapping(value = "/", method = RequestMethod.POST) public ResponseEntity<Car> update(@RequestBody Car car) { ... } |
References https://www.leveluplunch.com/java/tutorials/014-post-json-to-spring-rest-webservice/
Continue reading »|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
package com.therealdanvega; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.boot.CommandLineRunner; import org.springframework.stereotype.Component; @Component public class DataLoader implements CommandLineRunner { private final Logger logger = LoggerFactory.getLogger(DataLoader.class); @Override public void run(String... strings) throws Exception { logger.info("Loading data..."); } } |
References https://www.quickprogrammingtips.com/spring-boot/how-to-use-commandlinerunner-in-spring-boot-application.html http://therealdanvega.com/blog/2017/04/07/spring-boot-command-line-runner
Continue reading »References https://docs.spring.io/spring-boot/docs/current/reference/html/common-application-properties.html
Continue reading »|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
@RequestMapping("/news/{year}/{month}/{day}/{title}") public ModelAndView news(HttpServletRequest request, HttpServletResponse response, @PathVariable int year, @PathVariable int month, @PathVariable int day, @PathVariable String title) { SessionBL sessionManager = new SessionBL(request, response); String postUrl = String.format("/%d/%d/%d/%s", year, month, day, title); ModelAndView modelAndView = new ModelAndView("index"); modelAndView.addObject("version", new Statics().getVersion()); return modelAndView; } |
References http://docs.spring.io/spring/docs/3.2.x/spring-framework-reference/html/mvc.html#mvc-ann-requestmapping-uri-templates-regex https://www.mkyong.com/spring-mvc/spring-rest-requestmapping-extract-incorrectly-if-value-contains/
Continue reading »To resolve this ambiguity you can use _ inside your method name to manually define traversal points. So our method name would end up like […]
Continue reading »build.gradle
|
1 2 |
compile('org.springframework.session:spring-session') compile('org.springframework.boot:spring-boot-starter-data-redis') |
application.properties
|
1 2 3 4 5 |
spring.session.store-type=redis spring.redis.host=localhost #spring.redis.password=secret spring.redis.port=6379 |
FormsApiController.java
|
1 2 3 4 5 6 7 8 9 10 11 |
@RequestMapping(value = "/api/form/saveForm", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_UTF8_VALUE) public Map saveForm(HttpServletRequest request, HttpServletResponse response, @RequestBody String payload) { SessionManager sessionManager = new SessionManager(request, response); Map result = null; FormBL formBL = new FormBL(request, response); result = formBL.saveForm(payload); return result; } |
FormBL.java
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 |
public Map<String, Object> saveForm(String payload) { Map<String, Object> result = new HashMap<>(); try { Gson gson = new Gson(); PojoForm pojoForm = gson.fromJson(payload, PojoForm.class); Form form = new Form(); if (pojoForm.formId > 0) { form.id = pojoForm.formId; } Machinery machinery = null; if (pojoForm.machineryId > 0) { machinery = Statics.machineryRepository.findById(pojoForm.machineryId); } form.name = pojoForm.formName; form.machinery = machinery; Form dbForm = Statics.formRepository.save(form); pojoForm.formId = dbForm.id; if (pojoForm.formRows.size() > 0) { for (PojoFormRow row : pojoForm.formRows) { FormRow formRow = new FormRow(); if (row.getId() > 0) { formRow.id = row.getId(); } formRow.rowOrder = row.row_order; formRow.rowType = row.getRowType(); formRow.title = row.getTitle(); formRow.form = dbForm; FormRow dbFormRow = Statics.formRowRepository.save(formRow); row.id = dbFormRow.id; if (row.getRow_values().size() > 0) { for (PojoRowValue rowValue : row.getRow_values()) { RowSelectValue rowSelectValue = new RowSelectValue(); if (rowValue.getId() > 0) { rowSelectValue.id = rowValue.getId(); } rowSelectValue.title = rowValue.title; rowSelectValue.titleOrder = rowValue.title_order; rowSelectValue.formRow = dbFormRow; RowSelectValue dbRowSelectValue = Statics.rowSelectValueRepository.save(rowSelectValue); rowValue.id = dbRowSelectValue.id; } } } } result.put("form", ""); result.put("error", 0); } catch (Exception ex) { // exception result.put("error", 1); ex.printStackTrace(); } return result; } |
|
1 2 3 4 5 6 |
@Transactional(readOnly = false) public interface FormRowRepository extends JpaRepository<FormRow, Long> { List<FormRow> findByForm(Form form); void deleteById(Long id); void deleteById(List<Long> ids); } |
References https://stackoverflow.com/questions/10394857/how-to-use-transactional-with-spring-data
Continue reading »|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
@Entity public class Troop { @OneToMany(mappedBy="troop") public Set<Soldier> getSoldiers() { ... } @Entity public class Soldier { @ManyToOne() @JoinColumn(name="troop_fk") public Troop getTroop() { ... } |
References https://stackoverflow.com/questions/11938253/jpa-joincolumn-vs-mappedby https://stackoverflow.com/questions/37047938/jpa-hibernate-onetoone-joincolumn-referencedcolumnname-ignored
Continue reading »build.gradle
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 |
buildscript { ext { springBootVersion = '1.5.2.RELEASE' } repositories { mavenCentral() } dependencies { classpath("org.springframework.boot:spring-boot-gradle-plugin:${springBootVersion}") } } apply plugin: 'java' apply plugin: 'application' apply plugin: 'org.springframework.boot' jar { baseName = 'logbook-server' version = '0.0.1-SNAPSHOT' } sourceCompatibility = 1.8 repositories { mavenCentral() } dependencies { compile('org.springframework.boot:spring-boot-starter-data-jpa') compile('org.springframework.session:spring-session') compile('org.springframework.boot:spring-boot-starter-thymeleaf') compile('org.springframework.boot:spring-boot-starter-web') compile('org.springframework.boot:spring-boot-starter-web-services') compile('org.springframework.boot:spring-boot-starter-websocket') runtime('org.springframework.boot:spring-boot-devtools') runtime('mysql:mysql-connector-java') compileOnly('org.springframework.boot:spring-boot-configuration-processor') compileOnly('org.projectlombok:lombok') testCompile('org.springframework.boot:spring-boot-starter-test') // https://mvnrepository.com/artifact/joda-time/joda-time compile group: 'joda-time', name: 'joda-time', version: '2.9.7' // https://mvnrepository.com/artifact/net.time4j/time4j-parent compile group: 'net.time4j', name: 'time4j-parent', version: '4.25' // https://mvnrepository.com/artifact/org.apache.commons/commons-lang3 compile group: 'org.apache.commons', name: 'commons-lang3', version: '3.5' // https://mvnrepository.com/artifact/org.bouncycastle/bcprov-jdk15on compile group: 'org.bouncycastle', name: 'bcprov-jdk15on', version: '1.56' // https://mvnrepository.com/artifact/com.google.code.gson/gson compile group: 'com.google.code.gson', name: 'gson', version: '2.8.0' // https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-tomcat compile group: 'org.springframework.boot', name: 'spring-boot-starter-tomcat' // https://mvnrepository.com/artifact/commons-io/commons-io compile group: 'commons-io', name: 'commons-io', version: '2.5' } |
application.properties
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
server.port=13602 spring.session.store-type=jdbc server.compression.enabled=true server.use-forward-headers=true server.compression.mime-types=application/json,application/xml,text/html,text/xml,text/plain,text/css,application/javascript logging.file=logbook-server.log spring.datasource.url=jdbc:mysql://localhost/logbook spring.datasource.username=root spring.datasource.password=12345 spring.datasource.driver-class-name=com.mysql.jdbc.Driver # Number of ms to wait before throwing an exception if no connection is available. spring.datasource.tomcat.max-wait=10000 # Maximum number of active connections that can be allocated from this pool at the same time. spring.datasource.tomcat.max-active=50 # Validate the connection before borrowing it from the pool. spring.datasource.tomcat.test-on-borrow=true spring.jpa.hibernate.ddl-auto=create |
HttpSessionConfig.java
|
1 2 3 4 5 |
@Configuration @EnableJdbcHttpSession public class HttpSessionConfig { } |
then execute this script on MySQL
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
CREATE TABLE SPRING_SESSION ( SESSION_ID CHAR(36), CREATION_TIME BIGINT NOT NULL, LAST_ACCESS_TIME BIGINT NOT NULL, MAX_INACTIVE_INTERVAL INT NOT NULL, PRINCIPAL_NAME VARCHAR(100), CONSTRAINT SPRING_SESSION_PK PRIMARY KEY (SESSION_ID) ) ENGINE=InnoDB; CREATE INDEX SPRING_SESSION_IX1 ON SPRING_SESSION (LAST_ACCESS_TIME); CREATE TABLE SPRING_SESSION_ATTRIBUTES ( SESSION_ID CHAR(36), ATTRIBUTE_NAME VARCHAR(200), ATTRIBUTE_BYTES BLOB, CONSTRAINT SPRING_SESSION_ATTRIBUTES_PK PRIMARY KEY (SESSION_ID, ATTRIBUTE_NAME), CONSTRAINT SPRING_SESSION_ATTRIBUTES_FK FOREIGN KEY (SESSION_ID) REFERENCES SPRING_SESSION(SESSION_ID) ON DELETE CASCADE ) ENGINE=InnoDB; CREATE INDEX SPRING_SESSION_ATTRIBUTES_IX1 ON SPRING_SESSION_ATTRIBUTES (SESSION_ID); |
References http://docs.spring.io/spring-session/docs/current/reference/html5/#api-jdbcoperationssessionrepository-storage http://stackoverflow.com/questions/37398905/spring-session-with-jdbc-configuration-table-test-spring-session-doesnt-exis
Continue reading »