import java.sql.*;
public class MSSQLTest {
static {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
System.out.println("Success loading MS SQL Server Driver...");
}
catch (Exception e) {}
}
public static void main(String[] args) {
String strSQL = "select * from abc";
try {
System.out.println("程序已经运行到这里....\n\n");
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydata");
/* 我的数据库是mydata, 里边有一张表叫abc,*/ System.out.println("已经成功连接数据库了...");//这一句没有被打印出来, 估计是上面一句出了错误。 Statement strtl = con.createStatement();
ResultSet rsl = strtl.executeQuery(strSQL); ResultSetMetaData mdrs1 = rsl.getMetaData();
int ColumnNum = mdrs1.getColumnCount();
for (int i = 1 ; i <= ColumnNum ; i++) {
System.out.print(mdrs1.getColumnName(i)+"\t");
}
System.out.print("\n--------------------------------------------------------------\n");
while (rsl.next()) {
String strData = "";
for (int i = 1 ; i <= ColumnNum ; i++) {
strData = strData+rsl.getString(i)+"\t";
}
System.out.println(strData);
}
con.close();
}
catch (Exception e) {
e.printStackTrace();
}
}
}
E:\java\Myprogram>java MSSQLTest
Success loading MS SQL Server Driver...
程序已经运行到这里....java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]用
户 '(null)' 登录失败。原因: 未与信任 SQL Server 连接相关联。
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source
)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Un
known Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Sour
ce)
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)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at MSSQLTest.main(MSSQLTest.java:17)出现了以上错误,
public class MSSQLTest {
static {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
System.out.println("Success loading MS SQL Server Driver...");
}
catch (Exception e) {}
}
public static void main(String[] args) {
String strSQL = "select * from abc";
try {
System.out.println("程序已经运行到这里....\n\n");
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydata");
/* 我的数据库是mydata, 里边有一张表叫abc,*/ System.out.println("已经成功连接数据库了...");//这一句没有被打印出来, 估计是上面一句出了错误。 Statement strtl = con.createStatement();
ResultSet rsl = strtl.executeQuery(strSQL); ResultSetMetaData mdrs1 = rsl.getMetaData();
int ColumnNum = mdrs1.getColumnCount();
for (int i = 1 ; i <= ColumnNum ; i++) {
System.out.print(mdrs1.getColumnName(i)+"\t");
}
System.out.print("\n--------------------------------------------------------------\n");
while (rsl.next()) {
String strData = "";
for (int i = 1 ; i <= ColumnNum ; i++) {
strData = strData+rsl.getString(i)+"\t";
}
System.out.println(strData);
}
con.close();
}
catch (Exception e) {
e.printStackTrace();
}
}
}
E:\java\Myprogram>java MSSQLTest
Success loading MS SQL Server Driver...
程序已经运行到这里....java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]用
户 '(null)' 登录失败。原因: 未与信任 SQL Server 连接相关联。
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source
)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Un
known Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Sour
ce)
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)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at MSSQLTest.main(MSSQLTest.java:17)出现了以上错误,
解决方案 »
- c++或者java如何找到mp3的链接并且下载?!!!
- 怎么样用java实现将汉字转换为拼音?
- 在java中怎么样使JFrame窗体置顶
- 请教jfreechart的问题,关于柱状图的柱子显示问题!
- 如何判断一个String是中文字符还是英文字符组成的呢?
- 怎么样脱离JAVA虚拟机运行JAVA的程序
- 请问,如何判断一个String变量是否是整型?
- frame自带的windows按钮如何去掉??
- JComboBox加入图片,但一下拉图片就显示不出了
- cannot resolve symbol
- 大家来畅谈一下java做哪方面的软件比较有前途啊
- 在这个网站上有好多的技术书籍提供下载,如果觉得好就顶一下
现在ODBC中添加一个SQL的数据源,然后在Design框中加入Database控件,点击Database控件的connection属性打开对话框,选择Driver为sun.jdbc.odbc.JdbcOdbcDriver,然后在URL中选择你刚才在ODBC中的数据源名就可以连通了。很方便的!!!
可这条语句怎么写啊, 我用ping lgh(我主机的名称)得到的地址是:192.168.123.143 数据库名称是:mydata ,里边有一张叫abc 的表,没有密码。
明显是用户名和密码问题。
到EnterpriseManager中Security下建立或查看相关的用户名和密码,
再用DriverManager.getConnection(url,user,pwd);连接。