SqlServer2008 jdbc 连接所需jar和代码示例

package model;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import org.junit.Test;

public class TestConn2005 {
???
?private Connection conn = null;
?private String url="jdbc:sqlserver://localhost:1433;DatabaseName=base1";
?private String USER = "sa";
?private String PASSWORD = "sa";
?private String driver ="com.microsoft.jdbc.sqlserver.SQLServerDriver";
?

?public void getConnection()? {
???try {
????Class.forName(driver);
???} catch (ClassNotFoundException e) {
????System.out.println("****加载驱动失败****");
???}
???try {
????conn =DriverManager.getConnection(url,USER,PASSWORD);
???} catch (SQLException e) {
????System.out.println("****连接失败****");
???}
??
?}
?
?public void testConnection() throws Exception {
??if (conn == null)
???this.getConnection();
???String sql = "select * from? student";
???Statement stmt = conn.createStatement();
???ResultSet rs = stmt.executeQuery(sql);
???while (rs.next()) {
????System.out.println(">>>"+rs.getString("姓名"));
???}
???rs.close();
???stmt.close();
??
?}
?
?public static void main(String[] args) throws Exception {
??TestConn2005 bean = new TestConn2005();
??bean.testConnection();
?}

}

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!