|
?? SQLServer之JDBC驱动代码 收藏
最近写了一段sqlserver的JDBC代码，使用的是2000的自带的数据库，但要注意只有win2000(03server)或者xp打了sp2的补丁，1433端口才能打开，否则是不能成功的
import java.sql.*;
public class test{
???
??? public static void main(String [] args){
???????
??????? Connection conn=null;
??????? Statement stm=null;
??????? ResultSet rs=null;
??????? try{
??????????? Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
??????????? String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind;User=sa;Password=sa";
??????????? conn=DriverManager.getConnection(url);
??????????? stm=conn.createStatement();
??????????? rs=stm.executeQuery("SELECT * from Employees");
???????????
??????????? while(rs.next()){
??????????????? String firstname=rs.getString(2);
??????????????? String lastname=rs.getString(3);
??????????????? System.out.println(firstname+":"+lastname);
??????????? }
??????? }
??????? catch(Exception e)
??????? {
??????????? System.out.println(e.toString());
??????? }
??????? finally{
??????????? try{
??????????????? rs.close();
??????????????? stm.close();
??????????????? conn.close();
??????????? }
??????????? catch(Exception e){
??????????? }
??????? }
??? }
}
?
本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/echott/archive/2006/05/18/744043.aspx
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
