JDBC-SQLSERVER2000

function StorePage() { d=document; t=d.selection?(d.selection.type!='None'?d.selection.createRange().text:''):(d.getSelection?d.getSelection():''); void(keyit=window.open('http://www.365key.com/storeit.aspx?t='+escape(d.title)+'&u='+escape(d.location.href)+'&c='+escape(t),'keyit','scrollbars=no,width=475,height=575,left=75,top=20,status=no,resizable=yes')); keyit.focus(); }

package zmsjdbc;

import java.sql.*;

public class sqlserver1

{

private String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=catv";

private String user="sa";

private String pwd="";

public Connection getcon()

{

Connection con;

try

{ //加載驅動程式

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();

//建立連接配接

con=DriverManager.getConnection(url,user,pwd);

return con;

}

catch(ClassNotFoundException e)

{

System.out.println("加載驅動程式出錯");

}

catch(SQLException e)

{

System.out.println(e.getMessage());

}

catch(Exception e)

{

System.out.println("出現了好大的錯誤");

}

return null;

}

public ResultSet executeSql(String sqlstr)

{

Connection conn;

Statement stmt;

try

{

conn=getcon();

stmt=conn.createStatement();

ResultSet rs=stmt.executeQuery(sqlstr);

return rs;

}

catch(SQLException e)

{

System.out.print("擷取資料集時出現錯誤");

}

return null;

}

public static void main(String[] args)

{

ResultSet rs1;

sqlserver1 sql1=new sqlserver1();

rs1=sql1.executeSql("select ui_id,ui_name from userinfo");

try

{

while(rs1.next())

{

System.out.println(rs1.getString("ui_id")+" 姓名:"+rs1.getString("ui_name"));

}

}

catch(Exception e)

{

System.out.println(e.getMessage());

}

}

}

package zmsjdbc;

import java.sql.*;

public class sqlserver1

{

private String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=catv";

private String user="sa";

private String pwd="";

public Connection getcon()

{

Connection con;

try

{ //加載驅動程式

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();

//建立連接配接

con=DriverManager.getConnection(url,user,pwd);

return con;

}

catch(ClassNotFoundException e)

{

System.out.println("加載驅動程式出錯");

}

catch(SQLException e)

{

System.out.println(e.getMessage());

}

catch(Exception e)

{

System.out.println("出現了好大的錯誤");

}

return null;

}

public ResultSet executeSql(String sqlstr)

{

Connection conn;

Statement stmt;

try

{

conn=getcon();

stmt=conn.createStatement();

ResultSet rs=stmt.executeQuery(sqlstr);

return rs;

}

catch(SQLException e)

{

System.out.print("擷取資料集時出現錯誤");

}

return null;

}

public static void main(String[] args)

{

ResultSet rs1;

sqlserver1 sql1=new sqlserver1();

rs1=sql1.executeSql("select ui_id,ui_name from userinfo");

try

{

while(rs1.next())

{

System.out.println(rs1.getString("ui_id")+" 姓名:"+rs1.getString("ui_name"));

}

}

catch(Exception e)

{

System.out.println(e.getMessage());

}

}

}

package zmsjdbc;

import java.sql.*;

public class sqlserver1

{

private String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=catv";

private String user="sa";

private String pwd="";

public Connection getcon()

{

Connection con;

try

{ //加載驅動程式

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();

//建立連接配接

con=DriverManager.getConnection(url,user,pwd);

return con;

}

catch(ClassNotFoundException e)

{

System.out.println("加載驅動程式出錯");

}

catch(SQLException e)

{

System.out.println(e.getMessage());

}

catch(Exception e)

{

System.out.println("出現了好大的錯誤");

}

return null;

}

public ResultSet executeSql(String sqlstr)

{

Connection conn;

Statement stmt;

try

{

conn=getcon();

stmt=conn.createStatement();

ResultSet rs=stmt.executeQuery(sqlstr);

return rs;

}

catch(SQLException e)

{

System.out.print("擷取資料集時出現錯誤");

}

return null;

}

public static void main(String[] args)

{

ResultSet rs1;

sqlserver1 sql1=new sqlserver1();

rs1=sql1.executeSql("select ui_id,ui_name from userinfo");

try

{

while(rs1.next())

{

System.out.println(rs1.getString("ui_id")+" 姓名:"+rs1.getString("ui_name"));

}

}

catch(Exception e)

{

System.out.println(e.getMessage());

}

}

}

/*11:08 2005-2-24 -by beyond

1:對于SQLSERVER 必須下載下傳 SQLSERVER驅動

http://download.microsoft.com/download/3/0/f/30ff65d3-a84b-4b8a-a570-27366b2271d8/setup.exe

然後把 msbase.jar mssqlserver.jar msutil.jar 複制到 d:\jbuilder9/jdk1.4/lib/jre 下

2：如果出現錯誤：

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

說明 SQLERVER 端口号 不對 》》》更改端口号：SQLSERVER->屬性-正常-網絡配置-正常-TCP/IP-屬性--更改端口号

有個指令可以用： cmd-> netstat-a

例如：String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=zmstv";

說明你使用的是1433 在CMD 下 輸入 netstat -a -n

應該看不到：TCP 127.0.0.1:1433 0.0.0.0:0 LISTENING