Java添加JDBC

添加JDBC

1.SQL Server

SQL Server2005 下载 sqljdbc_4.0

https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774

jdbc.properties

    jdbc.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
    jdbc.url=jdbc:sqlserver://localhost:1433; DatabaseName=SpringStudy
    jdbc.username=sa
    jdbc.password=Qwert123456

Mysql

下载JDBC

http://dev.mysql.com/downloads/connector/j/3.1.html

jdbc.properties

    jdbc.driverClassName=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/web_demo?useUnicode=true&characterEncoding=UTF-8
    jdbc.username=root
    jdbc.password=123456