为什么连接不成功呢?哪个能解答下
我连接数据库sql server 2005
下了jdbc驱动配置了很多次都不成功
有哪个朋友知道怎样配置吗? 这个下面代码连接出现的问题
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at test.main(test.java:12)
import java.sql.*;
public class test
{
public static void main(String[] args)
{
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;integratedSecurity=true;DatabaseName=JSPTest","sa","java");
stmt = con.createStatement();
rs = stmt.executeQuery("select userName,passWord,email from regist");
while(rs.next())
{
String strUserName = rs.getString(1);
String strPassWord = rs.getString(2);
System.out.println(strUserName+'\t'+strPassWord+'\t');
}
if(rs!=null)
rs.close();
if(stmt!=null)
stmt.close();
if(con!=null)
con.close();
}
catch (Exception e)
{
e.printStackTrace();
}
finally
{
System.out.println("演示完毕!");
}
}
}
我连接数据库sql server 2005
下了jdbc驱动配置了很多次都不成功
有哪个朋友知道怎样配置吗? 这个下面代码连接出现的问题
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at test.main(test.java:12)
import java.sql.*;
public class test
{
public static void main(String[] args)
{
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;integratedSecurity=true;DatabaseName=JSPTest","sa","java");
stmt = con.createStatement();
rs = stmt.executeQuery("select userName,passWord,email from regist");
while(rs.next())
{
String strUserName = rs.getString(1);
String strPassWord = rs.getString(2);
System.out.println(strUserName+'\t'+strPassWord+'\t');
}
if(rs!=null)
rs.close();
if(stmt!=null)
stmt.close();
if(con!=null)
con.close();
}
catch (Exception e)
{
e.printStackTrace();
}
finally
{
System.out.println("演示完毕!");
}
}
}
Connection conection=null;
String url="jdbc:microsoft:sqlserver://10.1.183.239:1433;databaseName=Student";
String user="用户";
String password="密码";
String classforname="com.microsoft.jdbc.sqlserver.SQLServerDriver";
try
{
Class.forName(classforname);
conection=DriverManager.getConnection(url, user,password );
}
搞的有点四不像了,你上网一查一片ls的就是一个正确的连接方式
是不是DatabaseName这个地方的"D"大写造成的
你换成小写的看看
但是2005好像没有别的包了
我的也是sqljdbc的jar包
我的连接字符串是jdbc:sqlserver://localhost:1433;databaseName=javateachingsystem
你试下吧
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at test.main(test.java:12)
演示完毕!