By GokiSoft.com| 21:51 03/03/2021|
Spring MVC

[Share Code] Hướng dẫn tại Resfull API - Spring MVC - Quản lý sinh viên - Spring MVC Res API

Để pass được cross domain: Enable Cross Domain (Chrome + Côc Cốc)

Để Test API có thể sử dụng postman

#Server Side:


#persistence.xml


<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.1" xmlns="http://xmlns.jcp.org/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd">
  <persistence-unit name="StudentMgrPU" transaction-type="RESOURCE_LOCAL">
    <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
    <class>aptech.entity.Student</class>
    <properties>
      <property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/student_management?serverTimezone=UTC"/>
      <property name="javax.persistence.jdbc.user" value="root"/>
      <property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver"/>
      <property name="javax.persistence.jdbc.password" value=""/>
    </properties>
  </persistence-unit>
</persistence>


#StudentController.java


/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package aptech.controller;

import aptech.entity.Student;
import java.util.List;
import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;
import javax.persistence.Query;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;

/**
 *
 * @author DiepTV
 */
@RestController
@RequestMapping(value = "/student")
public class StudentController {
    @RequestMapping(value = "/list", method = RequestMethod.GET, produces = "application/json")
    public List<Student> list() {
        //Ket noi toi database
        EntityManagerFactory factory = Persistence.createEntityManagerFactory("StudentMgrPU");
        EntityManager em = factory.createEntityManager();
        
        Query q = em.createNamedQuery("Student.findAll", Student.class);
        
        return q.getResultList();
    }
}


#TestController.java


/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package aptech.controller;

import aptech.model.Test;
import java.util.ArrayList;
import java.util.List;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.servlet.config.annotation.EnableWebMvc;

/**
 *
 * @author DiepTV
 */
@EnableWebMvc
@RestController
@RequestMapping(value = "/test")
public class TestController {
    
    @RequestMapping(value = "/message", method = RequestMethod.GET)
    public String showMessage() {
        return "Hello Worlds!!!";
    }
    
    @RequestMapping(value = "/create", method = RequestMethod.GET, produces = "application/json")
    public Test createTestObject() {
        Test t = new Test("Test", "OKOK");
        return t;
    }
    
    @RequestMapping(value = "/list", method = RequestMethod.GET, produces = "application/json")
    public List<Test> createTestList() {
        List<Test> list = new ArrayList<>();
        
        list.add(new Test("A", "ABC"));
        list.add(new Test("B", "ABC"));
        list.add(new Test("C", "ABC"));
        list.add(new Test("D", "ABC"));
        list.add(new Test("E", "ABC"));
        
        return list;
    }
}


#Student.java


/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package aptech.entity;

import java.io.Serializable;
import java.util.Date;
import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
import javax.validation.constraints.NotNull;
import javax.validation.constraints.Size;
import javax.xml.bind.annotation.XmlRootElement;

/**
 *
 * @author DiepTV
 */
@Entity
@Table(name = "student")
@XmlRootElement
@NamedQueries({
    @NamedQuery(name = "Student.findAll", query = "SELECT s FROM Student s")
    , @NamedQuery(name = "Student.findByRollno", query = "SELECT s FROM Student s WHERE s.rollno = :rollno")
    , @NamedQuery(name = "Student.findByFullname", query = "SELECT s FROM Student s WHERE s.fullname = :fullname")
    , @NamedQuery(name = "Student.findByBirthday", query = "SELECT s FROM Student s WHERE s.birthday = :birthday")
    , @NamedQuery(name = "Student.findByEmail", query = "SELECT s FROM Student s WHERE s.email = :email")
    , @NamedQuery(name = "Student.findByAddress", query = "SELECT s FROM Student s WHERE s.address = :address")})
public class Student implements Serializable {

    private static final long serialVersionUID = 1L;
    @Id
    @Basic(optional = false)
    @NotNull
    @Size(min = 1, max = 50)
    @Column(name = "rollno")
    private String rollno;
    @Basic(optional = false)
    @NotNull
    @Size(min = 1, max = 50)
    @Column(name = "fullname")
    private String fullname;
    @Column(name = "birthday")
    @Temporal(TemporalType.DATE)
    private Date birthday;
    // @Pattern(regexp="[a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\\.[a-z0-9!#$%&'*+/=?^_`{|}~-]+)*@(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?", message="Invalid email")//if the field contains email address consider using this annotation to enforce field validation
    @Size(max = 200)
    @Column(name = "email")
    private String email;
    @Size(max = 200)
    @Column(name = "address")
    private String address;

    public Student() {
    }

    public Student(String rollno) {
        this.rollno = rollno;
    }

    public Student(String rollno, String fullname) {
        this.rollno = rollno;
        this.fullname = fullname;
    }

    public String getRollno() {
        return rollno;
    }

    public void setRollno(String rollno) {
        this.rollno = rollno;
    }

    public String getFullname() {
        return fullname;
    }

    public void setFullname(String fullname) {
        this.fullname = fullname;
    }

    public Date getBirthday() {
        return birthday;
    }

    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    @Override
    public int hashCode() {
        int hash = 0;
        hash += (rollno != null ? rollno.hashCode() : 0);
        return hash;
    }

    @Override
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof Student)) {
            return false;
        }
        Student other = (Student) object;
        if ((this.rollno == null && other.rollno != null) || (this.rollno != null && !this.rollno.equals(other.rollno))) {
            return false;
        }
        return true;
    }

    @Override
    public String toString() {
        return "aptech.entity.Student[ rollno=" + rollno + " ]";
    }
    
}


#Test.java


/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package aptech.model;

import java.io.Serializable;

/**
 *
 * @author DiepTV
 */
public class Test implements Serializable{
    String name, result;

    public Test() {
    }

    public Test(String name, String result) {
        this.name = name;
        this.result = result;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getResult() {
        return result;
    }

    public void setResult(String result) {
        this.result = result;
    }
    
    
}

#Client Side:


#config.js


// DOMAIN
var DOMAIN = 'http://localhost:8080/student-management'

// API TEST
var API_TEST_MESSAGE = DOMAIN + '/test/message'
var API_TEST_LIST = DOMAIN + '/test/list'
var API_TEST_CREATE = DOMAIN + '/test/create'

// API Student
var API_STUDENT_LIST = DOMAIN + '/student/list'
var API_STUDENT_CREATE = DOMAIN + '/student/create'
var API_STUDENT_UPDATE = DOMAIN + '/student/update'
var API_STUDENT_DELETE = DOMAIN + '/student/delete'


#guideline.txt


Nội dung kiến thức:
	- API Resful Spring MVC

Xậy dựng 1 website theo yêu cầu sau:
	- Server Side:
		API: /student
			- /list => Trả về danh sách sinh viên -> GET
			- /add => Thêm 1 sinh viên mới -> POST
			- /delete => Xóa sinh viên -> POST
			- /update => Sửa thông tin 1 sinh viên -> POST
		DB: student_management
			Student
				rollno
				fullname
				birthday
				email
				address
	- Client Side:
		Website => bootstrap/jquery => Phát triển dự án.
		Mobile: Android/iOS -> API
Bước để xấy dựng 1 dự:
B1. Xây dựng dự án Server Side:
	- Tạo 1 API Resfull TEST
	- Student
		- list
		- them
		- sua
		- xoa
	- Tao database
		create table Student (
			rollno varchar(50) primary key,
		    fullname varchar(50) not null,
		    birthday date,
		    email varchar(200),
		    address varchar(200)
		)
B2. Client Side:


#student.html


<!DOCTYPE html>
<html>
<head>
	<title>API - TEST</title>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1">

	<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
	<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
	<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
	<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.4.0/font/bootstrap-icons.css">

	<script type="text/javascript" src="config.js"></script>
	<script type="text/javascript" src="student.js"></script>
</head>
<body>
	<div class="container">
		<button class="btn btn-danger" onclick="showStudentList()">Show Student List</button>
		<table class="table table-bordered table-striped">
			<thead>
				<tr>
					<th>No</th>
					<th>RollNo</th>
					<th>Full Name</th>
					<th>Birthday</th>
					<th>Email</th>
					<th>Address</th>
				</tr>
			</thead>
			<tbody id="result">
				
			</tbody>
		</table>
	</div>
</body>
</html>


#student.js


function showStudentList() {
	$.get(API_STUDENT_LIST, function(data) {
		console.log(data)

		$('#result').empty()

		for (var i = 0; i < data.length; i++) {
			$('#result').append(`<tr>
					<td>${i + 1}</td>
					<td>${data[i].rollno}</td>
					<td>${data[i].fullname}</td>
					<td>${data[i].birthday}</td>
					<td>${data[i].email}</td>
					<td>${data[i].address}</td>
				</tr>`)
		}
	})
}

/**
std = {
	'rollno': 'R003',
	'fullname': 'TRAN VAN C',
	'email': 'c@gmail.com',
	'address': 'Ninh Binh',
	'birthday': '1999-02-06'
}
-> Hoat dong nhu submit form -> input form (quan ly sinh vien)
*/
function addStudent(std) {
	$.post(API_STUDENT_CREATE, {
		'rollno': std.rollno,
		'fullname': std.fullname,
		'email': std.email,
		'address': std.address,
		'birthday': std.birthday
	}, function(data) {
		//Du lieu tra ve sau khi add sinh vien xong
		console.log(data)
	})
}


#test.html


<!DOCTYPE html>
<html>
<head>
	<title>API - TEST</title>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1">

	<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
	<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
	<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
	<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.4.0/font/bootstrap-icons.css">

	<script type="text/javascript" src="config.js"></script>
	<script type="text/javascript" src="test.js"></script>
</head>
<body>
	<div class="container">
		<button class="btn btn-warning" onclick="showMessage()">Show Message</button>
		<button class="btn btn-success" onclick="showStudent()">Show Student</button>
		<button class="btn btn-danger" onclick="showStudentList()">Show Student List</button>
		<p id="message_id"></p>
		<table class="table table-bordered table-striped">
			<thead>
				<tr>
					<th>Name</th>
					<th>Result</th>
				</tr>
			</thead>
			<tbody id="result">
				
			</tbody>
		</table>
	</div>
</body>
</html>


#test.js


function showMessage() {
	$.get(API_TEST_MESSAGE, function(data) {
		console.log(data)
		$('#message_id').html(data)
	})
}

function showStudent() {
	$.get(API_TEST_CREATE, function(data) {
		console.log(data)
		$('#result').append(`<tr>
					<td>${data.name}</td>
					<td>${data.result}</td>
				</tr>`)
	})
}

function showStudentList() {
	$.get(API_TEST_LIST, function(data) {
		console.log(data)
		$('#result').empty()

		for (var i = 0; i < data.length; i++) {
			$('#result').append(`<tr>
					<td>${data[i].name}</td>
					<td>${data[i].result}</td>
				</tr>`)
		}
	})
}


Phản hồi từ học viên

5

(Dựa trên đánh giá ngày hôm nay)