application.properties:
server.port=9090
spring.datasource.url=jdbc:sqlserver://localhost:1433;DatabaseName=Tuhu;trustServerCertificate=true
spring.datasource.username=sa
spring.datasource.password=123qwe!@#
spring.datasource.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
SQLHelper
package com.example.tuhuApi;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
public class SqlHelper {
static String jdbc = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
static String url = "jdbc:sqlserver://localhost:1433;DatabaseName=Tuhu;trustServerCertificate=true";
static String user = "sa";
static String password = "123qwe!@#";
static public void register() {
try {
Class.forName(jdbc);
} catch (ClassNotFoundException e) {
throw new RuntimeException(e);
}
}
static public ResultSet search(String sql, String... params) {
register();
try {
var conn = DriverManager.getConnection(url, user, password);
var prepare = conn.prepareStatement(sql);
for (int i = 0; i < params.length; i++) {
prepare.setObject(i + 1, params[i]);
}
var result = prepare.executeQuery();
conn.close();
return result;
} catch (SQLException e) {
return null;
}
}
static public Integer execute(String sql, Object... params) {
register();
try {
var conn = DriverManager.getConnection(url, user, password);
var prepare = conn.prepareStatement(sql);
for (int i = 0; i < params.length; i++) {
prepare.setObject(i + 1, params[i]);
}
var result = prepare.executeUpdate();
conn.close();
return result;
} catch (SQLException e) {
return -1;
}
}
}