- 此项目使用的是Maven开发,所以在pom.xml 中添加依赖
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>6.4.0.jre8</version>
</dependency>
-
定义链接的sqlserver的数据库参数
public final static String URL = "jdbc:sqlserver://localhost:1433;databaseName=数据库名";
public final static String SQLSERVERDRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
public final static String USERNAME = "sa";
public final static String PASSWORD = "tiger";
-
java代码
1. 普通数据类型
Class.forName(Contants.SQLSERVERDRIVER);
Connection conn = DriverManager.getConnection(Contants.URL, Contants.USERNAME, Contants.PASSWORD);
//存储过程名称
String call = "{
call dbo.DBi_***(?,?,?)}";
CallableStatement callStatement = conn.prepareCall(call);
ResultSet rs;
callStatement.setString(1, null)