请高人指点:JBuilder 2007与SQL server 2000连接的问题!

来源:百度知道 编辑:UC知道 时间:2024/06/28 12:15:59
编写的程序连接不上数据库,其中的一段代码如下:
import java.sql.*;

public class cardConnect {
public cardConnect() {
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(ClassNotFoundException ee){

}
}

public static Connection getconn() throws SQLException{
String url = "jdbc:microsoft:sqlserver://hust-5cf3f8f222:1433;DatabaseName=pdx";
String username= "sa";
String password= "";
return DriverManager.getConnection(url,username,password);
}

public static void close(ResultSet rs){
try{
rs.close();
}
catch(Exception ex){

你做的有些乱;我给你个吧!记得给我加分就行了!哈哈
package emp_Dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Vector;

import java.sql.SQLException;

/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2008</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class Connemp {
public static Connection getConnection(String uli) {
Connection conn = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(uli);
} catch (SQLException ex) {
System.out.println(ex);

} catch (ClassNotFoundException x) {
System.out.println