import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class SimpleJDBCTest {
public static final String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
public static final String drivername = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
public static final String user = "sa";
public static final String password = "sa";
public static void main(String[] args) {
String sql = "select title,price from titles";
Connection connection = null;
Statement statement = null;
ResultSet resultSet = null;
try {
Class.forName(drivername);
System.out.println("加载驱动成功!");
connection = DriverManager.getConnection(url, user, password);
System.out.println("连接数据库成功!");
statement = connection.createStatement();
resultSet = statement.executeQuery(sql);
while (resultSet.next()) {
System.out.println("书名:" + resultSet.getString("title") + "定价:"
+ resultSet.getDouble("price"));
}
resultSet.close();
statement.close();
connection.close();
} catch (Exception e) {
e.printStackTrace(System.out);
} finally {
try {
if (resultSet != null) {
resultSet.close();
}
} catch (Exception e) {
System.err.println("关闭ResultSet时发生异常!");
}
try {
if (statement != null) {
statement.close();
}
} catch (Exception e) {
System.err.println("关闭statement时发生异常!");
}
try {
if (connection != null) {
connection.close();
}
} catch (Exception e) {
System.err.println("关闭connection时发生异常!");
}
}
}
}
JDBC连接数据库--入门
最新推荐文章于 2024-03-15 13:57:37 发布