packagecn.tk.netcore.rest;importlombok.extern.slf4j.Slf4j;importorg.junit.Test;importorg.junit.runner.RunWith;importorg.springframework.boot.test.context.SpringBootTest;importorg.springframework.test.context.junit4.SpringRunner;import java.sql.*;
@SpringBootTest
@RunWith(SpringRunner.class)
@Slf4jpublic classJDBCExample {//第二步:说明JDBC驱动的名称和数据库的地址
static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";static final String DB_URL = "jdbc:mysql://ip:port/tktop";//第三步:说明数据库的认证账户及密码
static final String USER = "user";static final String PASS = "password";
@Testpublic voidjsbcTest() {//第四步:注册JDBC驱动
try{
Class.forName(JDBC_DRIVER);
}catch(ClassNotFoundException e) {//这里会发生类没有找到的异常!
e.printStackTrace();
}//第五步:获得数据库连接
try{
Connection connection=DriverManager.getConnection(DB_URL,USER,PASS);//设置手动提交
connection.setAutoCommit (false);
Statement statement=connection.createStatement();//第六步:执行修改语句
String sql = "UPDATE s_policymain s set s.sc