使用mybatis的generatorSqlmapCustom逆向工程连接sqlserver数据库:
generatorConfig.xml:
<jdbcConnection driverClass="com.microsoft.sqlserver.jdbc.SQLServerDriver" connectionURL="jdbc:sqlserver://127.0.0.1;DatabaseName=表名 userId="sa" password="123456"> </jdbcConnection>
添加jar包:sqljdbc4.jar
附java开发(ssm):
application.properties:
spring.datasource.driver-class-name = com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.datasource.url = jdbc:sqlserver://127.0.0.1;databaseName=表名
spring.datasource.username = sa
spring.datasource.password = 123456
merver配置(阿里):
<dependency> <groupId>com.hynnet</groupId> <artifactId>sqljdbc4-chs</artifactId> <version>4.0.2206.100</version> </dependency>