J2EE初学者2：Java连接SQL Server 2000之JDBC驱动连接

本实例实现了Java与SQL Server 2000数据库的连接，以数据库pubs为例！

?

/* JdbcDriver.java*/

package learner;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class JdbcDriver {private String className;//驱动名private String url;//数据库连接urlprivate String dbName;//要访问的数据库private String username;//数据库的登录名private String password;//数据库的登录密码private Connection conn;private Statement stmt;private ResultSet rs;public JdbcDriver() {dbName = "pubs";username = "pubs";password = "pubs";className = "com.microsoft.jdbc.sqlserver.SQLServerDriver";url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=" + dbName;try {Class.forName(className);try {conn = DriverManager.getConnection(url, username, password);} catch (SQLException e) {e.printStackTrace();}} catch (ClassNotFoundException e) {e.printStackTrace();}try {stmt = conn.createStatement();rs = stmt.executeQuery("select * from authors");} catch (SQLException e) {e.printStackTrace();}try {while (rs.next()) {System.out.println(rs.getString(1));}} catch (SQLException e1) {e1.printStackTrace();}try {rs.close();stmt.close();conn.close();} catch (SQLException e) {e.printStackTrace();}}public static void main(String[] args) {new JdbcDriver();}}

?

?