Continue to follow the rhythm of the previous section, simple and fast integration of JDBC
First import jdbc and MySQL springboot jar files
<!--mysql-->
<dependency>
<groupId>mysql</groupId>
<artifactId> mysql-connector-java</artifactid>
</dependency>
<!--jdbc-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactid>spring-boot-starter-jdbc </artifactId>
</dependency>
You also need to configure the following code in Application.properties:
Database connection address, port number, connection name, setting encoding format
spring.datasource.url=jdbc:mysql://localhost:3306/test?autoreconnect=true& Useunicode=true&characterencoding=utf-8/
/username
spring.datasource.username=root
//password
Spring.datasource.password=root
//Database driver
spring.datasource.driver-class-name=com.mysql.jdbc.driver
This is my file location, name screenshot:
In the new entity file, build a studententity test entity class inside it:
public class Studententity {//ID private Integer ID;
Name private String name;
Age private Integer;
gender private String sex;
Address private String addresses;
Whether tombstone (0: not deleted, 1: deleted) private Integer isdelete;
Public Integer GetId () {return id;
The public void SetId (Integer id) {this.id = ID;
Public String GetName () {return name;
public void SetName (String name) {this.name = name;
Public Integer Getage () {return age;
public void Setage (Integer age) {this.age = age;
Public String Getsex () {return sex;
} public void Setsex (String sex) {this.sex = sex;
Public String getaddress () {return address;
public void setaddress (String address) {this.address = address;
Public Integer Getisdelete () {return isdelete; } public void Setisdelete(Integer Isdelete)
{this.isdelete = Isdelete;
}
}
Down directly to the service, create the Studentservice interface code as follows:
Public interface Studentservice {
//write Data
int savestudent ();
Query data
list<studententity> queryallstudent ();
Update Data
int updatestudent (studententity studententity);
Delete data
int deletestudent (Integer ID);
Also create Impl file, Studentserviceimpl class, code as follows:
Import com.demo.entity.StudentEntity;
Import Com.demo.mapper.StudentMapper;
Import Com.demo.service.StudentService;
Import org.springframework.beans.factory.annotation.Autowired;
Import Org.springframework.jdbc.core.JdbcTemplate;
Import Org.springframework.jdbc.core.PreparedStatementSetter;
Import Org.springframework.jdbc.core.RowMapper;
Import Org.springframework.stereotype.Service;
Import Javax.annotation.Resource;
Import java.sql.PreparedStatement;
Import Java.sql.ResultSet;
Import java.sql.SQLException;
Import java.util.List; @Service ("studentservices")/Alias public class Studentserviceimpl implements Studentservice {@Resource private Jd
Bctemplate JdbcTemplate;
JDBC writes data @Override public int savestudent () {//initialization attribute parameter String name = "John";
Integer age = 12;
Execute write int row = Jdbctemplate.update ("INSERT into student (name,age) VALUES (?,?);", "Dick", 12);
Returns the result return row; //JDBC Query Data @OverridE public list<studententity> queryallstudent () {//sql String SQL = ' select * FROM student wher
E is_delete=0 "; Results list<studententity> List = jdbctemplate.query (sql, new rowmapper<studententity> () {/
/map per row of data @Override public studententity Maprow (ResultSet rs, int rownum) throws SQLException {
Studententity stu = new studententity ();
Stu.setid (Rs.getint ("ID"));
Stu.setage (Rs.getint ("Age"));
Stu.setname (rs.getstring ("NAME"));
Stu.setaddress (rs.getstring ("Address"));
return Stu;
}
});
Returns the result return list; //JDBC Update Data @Override public int updatestudent (studententity studententity) {//sql String sql = "Update tudent set name=?,address=?"
where id=? "; result int row = jdbctemplate.update (sql, New PreparedStatementSetter () {//Map data @Override public void Setvalues (PreparedStatement preparedstatement) throws
SQLException {preparedstatement.setstring (1, Studententity.getname ());
Preparedstatement.setstring (2, studententity.getaddress ());
Preparedstatement.setint (3, Studententity.getid ());
}
});
The result return row; }//delete data @Override public int deletestudent (Integer id) {//sql+ result int resrow = JdbcTemplate. Update ("Update student SET is_delete=1 WHERE id=?", new PreparedStatementSetter () {//Mapping data @Overri
De public void setvalues (PreparedStatement PS) throws SQLException {Ps.setint (1, id);
}
});
Returns the result return resrow;
}
}
The
ends with controller, creating Studentcontrollerimpl: Code as follows
Import com.demo.entity.StudentEntity;
Import Com.demo.service.StudentService;
Import org.springframework.beans.factory.annotation.Autowired;
Import org.springframework.web.bind.annotation.RequestMapping;
Import Org.springframework.web.bind.annotation.RestController;
Import Javax.annotation.Resource;
Import java.util.ArrayList;
Import Java.util.Iterator;
Import java.util.List;
@RestController public class Studentcontrollerimpl {@Autowired private studentservice studentservices; /** * NEW Data * * */@RequestMapping ("/save") public String Save () {int row = Studentservices.savestu
Dent ();
Judgment result if (row==-1) {return "new failure";
}else{return "new success"; }/** * Query data */@RequestMapping ("/query") public String query () {//Lookup data Lis
T list = Studentservices.queryallstudent ();
Assembly data List NewList = new ArrayList (); Loop out result for (int i = 0; I <list.size ();
i++) {//New Student object studententity stu = (studententity) list.get (i);
Fill Data Newlist.add (Stu.getid ());
Newlist.add (Stu.getname ());
Newlist.add (Stu.getage ());
Newlist.add (Stu.getsex ());
Newlist.add (Stu.getaddress ());
//Return the data Back newlist.tostring (); /** * UPDATE Data * */@RequestMapping ("/update") public String Update () {//New object delivery data St
Udententity stu = new studententity ();
Stu.setid (2);
Stu.setname ("Nicholas");
Stu.setaddress ("Northeast");
Perform an update operation int row = Studentservices.updatestudent (stu);
Judgment result if (row==-1) {return "update failed";
}else {return "successful update";
}/** * Delete data * */@RequestMapping ("/delete") public String Delete () {//Initialize data
Integer id = 3; Execute Delete int row = StudentseRvices.deletestudent (ID);
Judgment result if (row==-1) {return "delete failed";
}else{return "Delete Success";
}
}
}
This is done, start running my url:localhost:8080/save, please pass the great God a lot of advice, if you have questions or questions please leave a message,