java连接数据库问题

[kelly0924]

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at JdbcConnect.getConnection(JdbcConnect.java:9)
at UserLogin.checkUser(UserLogin.java:68)
at UserLogin.actionPerformed(UserLogin.java:56)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6216)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
at java.awt.Component.processEvent(Component.java:5981)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4583)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4413)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4556)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4220)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4150)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2475)
at java.awt.Component.dispatchEvent(Component.java:4413)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
java.lang.NullPointerException
at UserLogin.checkUser(UserLogin.java:70)
at UserLogin.actionPerformed(UserLogin.java:56)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6216)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
at java.awt.Component.processEvent(Component.java:5981)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4583)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4413)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4556)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4220)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4150)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2475)
at java.awt.Component.dispatchEvent(Component.java:4413)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
报了这样的错，我把三个jar放在C:\Program Files\Java\jdk1.6.0_13\jre\lib\ext这个路径下，也打了SP3补丁，以前这样做能连上，但后来重装系统后重装SQL2000就连不了了，请指教 ，谢谢

[xiaohuanjie]

[Quote=引用 4 楼 kelly0924 的回复:]
以前没有数据库名字一样能连接得上，现在加了数据库名也一样连不上
[/Quote]




在你的SQL SERVER 里建好数据库没有，

[justlearn]

con=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=数据库名称;user=tom;password=123");

[panpanguo]

数据库名字··········

[tongjm2009]

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL.

楼主这个错误提示应该是你的连接串有问题。

[snowhite88]

MsSQL的驱动（JAR）文件放在LIB里面没有？

[hxj1225]

jdbc:jtds:sqlserver://127.0.0.1:1433/dbname
我是这样的url

[zuoguodang]

URL不对啊，已经提示出来了

[kelly0924]

数据库建好了，单用数据库能查询出来的。。。

[xiaohuanjie]

Unable to connect. Invalid URL.

无法连接。无效的URL


把连接数据库的代码贴出来看看

[kelly0924]

public class JdbcConnect {
public static Connection getConnection() {
Connection con = null;
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = DriverManager
.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433",
"tom", "123");
} catch (Exception e) {
e.printStackTrace();
}
return con;
}
}

[xiaohuanjie]

con = DriverManager
.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433",
"tom", "123");


这里漏了数据库的名字，没有数据库的名字，怎么能连接上呢

con = DriverManager
.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;Databasename=XXXXX",
"tom", "123");

[kelly0924]

以前没有数据库名字一样能连接得上，现在加了数据库名也一样连不上

[zliuzz]

莫不是2005用了2000的jar包？

[LZHLINZH]

该用odbc连接试试，记得配数据源

[jmi443]

url非法啊，加上数据库名字（确保该数据库存在），并且导入正确的jar

[rumlee]

连接字符串的问题，确保数据库是正常的，再确保驱动和连接串没有问题就肯定可以了。

[「已注销」]

http://javas.5d6d.com/forum-8-1.html Java核心语法在线视频 很好很强大 强烈推荐 免费资源

[yangweiqing2]

可能是补丁没打好吧，我以前也遇到过这样的问题，但后来重新安装下sql2000,并重新打补丁就好了，