在Java JDBC 中使用slf4…

package cn.ouyang.test;

import java.sql.*;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

public class Test1 {

private static Logger logger=LoggerFactory.getLogger(Test1.class);

public static void main(String[] args) {

Connection connection = null;

Statement stmt = null;

ResultSet resultSet = null;

try {

//加载数据库驱动

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

//连接到数据库

connection = DriverManager.getConnection(

"jdbc:sqlserver://localhost:1433;DatatbaseName=HOUSE",

"sa", "123");

System.out.println("数据库连接成功！");

logger.debug("数据库连接成功！");

stmt = connection.createStatement();

//执行查询语句

resultSet = stmt.executeQuery("SELECT [DID],[DNAME] FROM [HOUSE].[dbo].[hos_district]");

while (resultSet.next()) {

System.out.println(resultSet.getInt("DID"));

System.out.println(resultSet.getString("DNAME"));

}

} catch (ClassNotFoundException e) {

logger.info("未发现数据库驱动！");

e.printStackTrace();

} catch (SQLException e) {

logger.info("SQL连接异常！");

e.printStackTrace();

} catch (Exception e) {

System.out.println("出现异常！");

logger.info("出现异常！");

e.printStackTrace();

} finally {//关闭使用项

try {

if (resultSet != null) {

resultSet.close();

resultSet=null;

}

if (stmt != null) {

stmt.close();

stmt=null;

}

if (connection != null) {

connection.close();

connection=null;

}

logger.debug("数据库关闭成功！");

} catch (SQLException e) {

e.printStackTrace();

logger.warn("关闭数据库时出现异常！");

}

}

}

}