How does springmvc CRUD mssql?

< H2 > problem description < / H2 >

I want to achieve a restful webapi operation mssql database for the simplest addition, deletion, modification and query, after learning restful api has a general understanding, but ssm connection query mssql database has been a failure, I now want a successful demo project to let me analyze, or there is a better blog teaching to guide, I have turned a lot on the Internet and tried many times, do not get up run, ask you bosses to help!

< H2 > the environmental background of the problem and what methods you have tried < / H2 >
  1. background: spring springmvc mybatis framework performs CRUD operations on database ms sqlserver (schools require mssql not mysql)
  2. has tried to build reverse engineering, only to see that the establishment of mysql failed to change to mssql, and somehow the reverse engineering built by myself cannot be checked even by mysql
< H2 > need < / H2 >

A demo project that can operate mssql CRUD normally, if you want to analyze and learn it, it is best to have detailed notes. Or have a good blog recommendation, thank you!


take a look at this example
https://github.com/codedrinke...
if there is something in it that you don't understand
, you can take a look at a series of articles I wrote, in which is MySQL. But the databases are more or less the same
http://mp.weixin.qq.com/mp/ho...

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1cde430-1b8eb.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1cde430-1b8eb.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?