- 论坛徽章:
- 0
|
我在自己电脑上写了访问SQL SERVER 2000的程序,JDBC也下载了,可登陆服务器时总提醒登录失败,是怎么回事?
提醒:
建立数据库连接错误?[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]用户 'tanggm' 登录失败。
建立执行语句句柄有错误?null
源代码:
import java.io.* ;
import java.sql.*;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
public class TanggmJDBC
{
public Connection conn = null;
Statement stmt = null;
int rec;
String str; //此为公用字符串变量
String strArray[] = new String[5]; //此为公用字符串数组
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
ResultSet ret = null;
public TanggmJDBC() { }
//********************************
public void init()//初始化函数
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver" ;
}
catch (Exception ex)
{
System.out.println("调MS SQL SERVER驱动有错误?"+ex.getMessage());
}
try
{
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.0.171:1433;database=tanggm","tanggm", "" ;
}
catch (Exception ex)
{
System.out.println("建立数据库连接错误?"+ex.getMessage());
}
try
{
stmt = conn.createStatement();
}
catch (Exception ex)
{
System.out.println("建立执行语句句柄有错误?"+ex.getMessage());
}
}
public void Close()
{
try
{
if (conn!=null) conn.close();
}
catch (Exception ex)
{
System.out.println("释放连接错误?"+ex.getMessage());
}
}
public static void main(String args[])
{
try {
TanggmJDBC obj = new TanggmJDBC();
obj.init();
String c;
BufferedReader brr=new BufferedReader(new InputStreamReader(System.in));
obj.Close();
}
catch(Exception ex){System.out.println("主函数出错!"+ex.getMessage());}
}
} |
|