jdbc连接sqlserver2005
安装JDBC FOR SQLSERVER2005
建立Java项目
建立一个Java Project，名字为JdbcTest
建立一个包jdbc
在包jdbc下建立一个类Test
输入代码
package jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Test {
private Connection conn = null;
public Test() {
super();
}
public void getConnection() {
try {
Class
.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver")
.newInstance();
String URL = "jdbc:sqlserver://localhost:1434;DatabaseName=testDB";
String USER = "sa"; // 根据你自己设置的数据库连接用户进行设置
String PASSWORD = "sa"; // 根据你自己设置的数据库连接密码进行设置
conn = DriverManager.getConnection(URL, USER, PASSWORD);
} catch (java.lang.ClassNotFoundException ce) {
System.out.println("Get Connection error:");
ce.printStackTrace();
} catch (java.sql.SQLException se) {
System.out.println("Get Connection error:");
se.printStackTrace();
} catch (Exception e) {
System.out.println("Get Connection error:");
e.printStackTrace();
}
}
public void testConnection() {
if (conn == null)
this.getConnection();
try {
String sql = "SELECT * FROM user1";
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
System.out.print(rs.getString("ID")+" ");
System.out.print(rs.getString("Name")+" ");
System.out.println(rs.getString("Email"));
}
rs.close();
stmt.close();
} catch (SQLException e) {
System.out.println(e.getMessage());
e.printStackTrace();
} finally {
if (conn != null)
try {
conn.close();
} catch (SQLException e) {
}
}
}
public static void main(String[] args) {
Test bean = new Test();
bean.testConnection();
}
}
导入jdbc的sqljdbc.jar
运行结果
posted on 2009-07-02 10:59 highmayor 阅读(1089) 评论(0) 编辑 收藏 举报
