链接SQL Server数据库代码为什么链接不上

[cqm2008]

1:代码:
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://(local):1433;DatabaseName=ISO9000";
//ISO9000为数据库

String user="sa";
String password="admin";
con= DriverManager.getConnection(url,user,password);

con.setAutoCommit(false); //关闭自动提交

con.setTransactionIsolation(con.TRANSACTION_READ_COMMITTED); //设置事务级别

stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY); //创建一个JDBC声明
//stmt = con.createStatement();
a=1; //数据库连接成功返回1
return a;
}
catch (Exception e)
{
System.out.println(e.getMessage());
e.printStackTrace();

a=0; //数据库连接失败返回0
//JOptionPane.showMessageDialog(null,"链接数据库失败");
return a;
}


2:请问高手以上代码错在哪里,为什么总是报错,链接数据库失败?

3:不胜感激!

[cqm2008]

急,在线等!
问题解决立即全分送上!

[horseyet]

1。url可能写错了：改成jdbc:microsoft:sqlserver//:localhost:1433;DatabaseName=ISO9000试试
2。端口号是不是写错了

[cqm2008]

写成localhost:1433也是链接不上,端口号没错

[horseyet]

你先调试一下看看是不是con= DriverManager.getConnection(url,user,password);这句话报错？

[cqm2008]

com.microsoft.jdbc.sqlserver.SQLServerDriver
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:199)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:141)
at DataBaseManager.getConnection(DataBaseManager.java:22)
at UserLogin.actionPerformed(UserLogin.java:75)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:17
86)
at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Abstra
ctButton.java:1839)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel
.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258
)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonL
istener.java:245)
at java.awt.Component.processMouseEvent(Component.java:5100)
at java.awt.Component.processEvent(Component.java:4897)
at java.awt.Container.processEvent(Container.java:1569)
at java.awt.Component.dispatchEventImpl(Component.java:3615)
at java.awt.Container.dispatchEventImpl(Container.java:1627)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483
)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)

at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
at java.awt.Container.dispatchEventImpl(Container.java:1613)
at java.awt.Window.dispatchEventImpl(Window.java:1606)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:201)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:151)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
java.lang.NullPointerException
at DataBaseManager.getResult(DataBaseManager.java:62)
at UserLogin.actionPerformed(UserLogin.java:81)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:17
86)
at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Abstra
ctButton.java:1839)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel
.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258
)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonL
istener.java:245)
at java.awt.Component.processMouseEvent(Component.java:5100)
at java.awt.Component.processEvent(Component.java:4897)
at java.awt.Container.processEvent(Container.java:1569)
at java.awt.Component.dispatchEventImpl(Component.java:3615)
at java.awt.Container.dispatchEventImpl(Container.java:1627)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483
)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)

at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
at java.awt.Container.dispatchEventImpl(Container.java:1613)
at java.awt.Window.dispatchEventImpl(Window.java:1606)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:201)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:151)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)


上面为运行时报错信息!

用jdbc:sqlserver://local/ISO9000试试是不行的.

[cqm2008]

http://support.microsoft.com/default.aspx?scid=kb;zh-cn;313100

[xiongbing528]

多打印几个语句。。看看那里出错。。程序的漫漫调试。。。

[cqm2008]

是con= DriverManager.getConnection(url,user,password);这句报错的!!!!!!!!!!!
那么这句应该怎么写?
之前我写成用ODBC链接方式也是不成功的,但如果数据库是ACCESS用ODBC又是成功的.

[gengtaoo]

请问你的数据库是企业版的吗？有问题找我：121323996

[cqm2008]

肯定是企业版的呀
ENTERPRICE的

[xuyingjun]

感觉你没有用事务
就是普通的连接，为什么要 con.setAutoCommit(false); //关闭自动提交

con.setTransactionIsolation(con.TRANSACTION_READ_COMMITTED); //设置事务级别

[cqm2008]

错的不是在这两句呀.

前面一句:
con= DriverManager.getConnection(url,user,password);
就已经报错了!

请问有没有人遇到类似问题?
数据库设置问题还是代码问题?又应该如何去解决?

[cqm2008]

会不会是没有:com.microsoft.jdbc.sqlserver.SQLServerDriver

注册不了com.microsoft.jdbc.sqlserver.SQLServerDriver,以致链接不上,请问如果是这样那应如何解决?

[zzz968]

用jdbc:sqlserver://local/ISO9000试试
还有,那个Driver是不是不对啊