Create a REST API Using Spring Boot2. Data AccessCreate a MySQL database sbrest and use the following SQL script to populate the database: Edit the file src/main/resources/application.properties to include the following four properties:
And of course you should change the username and password to match the setup of your database. Add a data model class There are a few things worth mentioning for this model class: a) we use a number of JPA annotations to map this class to the users table in the sbrest database, b) the Add the following data access code to the project
DAO stands for Data Access Object, which is a Java EE design pattern for data access. Typically there is an interface (e.g. UserDao) and an implementation class (e.g. UserDaoImpl) involved in a DAO. The interface specifies what methods the data access layer provides to the application, and the implementation implements these methods using a particular technology, e.g. JPA or JDBC or something else depending on the underlying data store. Now to test our project, add a simple controller under the edu.csula.sbrest.controller package: To run the project in Eclipse, right click on SbrestApplication.java under the edu.csula.sbrest package and select Run As -> Java Application -- remember that the project is packaged in a JAR file with its own embedded Tomcat server, so we run it as a regular Java application instead of using "Run on Server" to deploy it to an existing server. When the application is running, use a browser to open the URL http://localhost:8080/users and you should see the users displayed as a JSON array.
|