使用sqlserver官方驱动包调用存储过程遇到的坑及解决方法_MsSql_

import java.sql.CallableStatement; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Calendar; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; public class Test { final static String SERVERURL = "jdbc:jtds:sqlserver://127.0.0.1:1433;DatabaseName=XXX"; final static String SERVERDriver = "net.sourceforge.jtds.jdbc.Driver"; final static String SERVERUSERNAME = "username"; final static String SERVERPASSWORD = "password"; public static void main(String[] args) { try { //调用存储过程 Class.forName(SERVERDriver); Connection conn = DriverManager.getConnection(SERVERURL, SERVERUSERNAME, SERVERPASSWORD); System.out.println("sql server连接成功"); String call = "{call 存储过程名称(?)}"; CallableStatement callableStatement = conn.prepareCall(call); callableStatement.setString(1, "2022-10-13"); ResultSet rs = callableStatement.executeQuery(); while(rs.next()) { System.out.println(rs.getString("aaa")); System.out.println(rs.getString("bbb")); System.out.println(rs.getString("ccc")); System.out.println(rs.getString("ddd")); } callableStatement.close(); conn.close(); } catch (Exception e) { e.printStackTrace(); } } }