网王之塞巴斯蒂安幸村:抓狂ing 怎么做SQL Server 的连接?谢谢了!

来源:百度文库 编辑:高校问答 时间:2024/04/27 00:25:24
import java.sql.*;

public class DBUtil
{
private String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=business";
private Connection Con;
private Statement stat;
private ResultSet rs;
public DBUtil ()
{
Con = null;
stat = null;
rs = null;
}

public ResultSet executeSQL(String SQLString)
{
try
{

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

Con = DriverManager.getConnection(url, "sa", "");("jdbc:odbc:business", "", "");
String sqlString = SQLString.trim();
stat = Con.createStatement();

if("s".equalsIgnoreCase(sqlString.substring(0, 1)))
{
rs = stat.executeQuery(sqlString);
return rs;
}
else
{
stat.executeUpdate(sqlString);
}
}

catch(InstantiationException e)
{
e.printStackTrace();
}
catch(IllegalAccessException e)
{
e.printStackTrace();
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
catch(SQLException e)
{
e.printStackTrace();
}
return null;
}
}
_____________________________________________________
CMD报错一辈子了,怎么改呀?

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establis
hing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source
)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)

at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Sou
rce)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown S
ource)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
3个包我都加了,我也不知道我还有什么没做的?

有没有部署JDBC驱动??

msbase mssqlserver msutil 这三个包?????/