Java开发网 - 请教：连接SQL Server2000时出错

Java开发网

您没有登录

» Java开发网 » Database/JDBC/SQL/JDO/Hibernate » MS SQL

打印话题 寄给朋友 订阅主题

作者

请教：连接SQL Server2000时出错

k704790

发贴: 35
积分: 0

于 2004-11-29 21:28

小弟最近写了一个连接MS SQL的测试程序，编译时没有错，可是运行时一行出现错误，不知哪位大哥可以帮一下小弟，代码如下：

package myClass.simon;

//import myClass.simon.*;

import java.sql.*;

/**
*
* @author k704790
*/
public class MyConnectionSQL {

public MyConnectionSQL() {

}

public static void main(String args[]){
//SQLServerConnectionFactory ConnFactory = null;
//JdbcOdbcConnectionFactory ConnFactory = null;
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String mySQL = "select job_id,job_desc from dbo.jobs";

System.out.println("这是一个显示SQL数据库连接的例子：");
//ConnFactory = new SQLServerConnectionFactory("localhost",1433,"simon","sa","");
/*try
{
ConnFactory = new SQLServerConnectionFactory("localhost",1433,"simon","sa","sa");
//ConnFactory = new JdbcOdbcConnectionFactory("LocalServer");
ConnFactory.setUserName("sa");
ConnFactory.setPassword("sa");
}
catch(Exception e)
{
System.out.println("初始化出现异常!");
return;
}

System.out.println("DriverName: " + ConnFactory.getDriverName());
System.out.println("URL: " + ConnFactory.getUrl());
System.out.println("UserName: " + ConnFactory.getUserName());
System.out.println("Password: " + ConnFactory.getPassword());
*/

try
{
//conn = ConnFactory.getConnection();
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(ClassNotFoundException e)
{
System.out.println("Can't find class");
return;
}

try
{
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=simon;User=sa;Password=sa");
//stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
stmt = conn.createStatement();
rs = stmt.executeQuery(mySQL);
}
catch(SQLException e)
{
System.out.println("Error when return resultset");
return;
}
catch(Exception e)
{
System.out.println("Error:");
e.printStackTrace();
return;
}

try
{
System.out.println("Return resultset: ");
System.out.println("1." + rs.getString("job_desc"));
}
catch(Exception e)
{
System.out.println("显示结果出错！");
}

错误如下：
Error when return resultset

k704790 edited on 2004-12-02 21:31

• 有了Swing为什么还要SWT?

话题树型展开

人气	标题	作者	字数	发贴时间
6539	请教：连接SQL Server2000时出错	k704790	2711	2004-11-29 21:28
5298	Re:请教：连接SQL Server2000时出错	xhxasdf	271	2004-12-08 14:40
4875	Re:请教：连接SQL Server2000时出错	k704790	3	2005-01-01 22:45

已读帖子

新的帖子

被删除的帖子