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);
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]");
[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("关闭数据库时出现异常！");
}
}
}
}