连接数据库 ms sql server 失败
class connectMSSQLSERVER
{
public void connect()
{
//Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
// connect to the database
// sqlConn=java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.0.2:1433;DatabaseName=pubs;SelectMethod=direct","dxxx","");
String dburl = "jdbc:microsoft:sqlserver://192.168.1.2:1433;DatabaseName=hd_pub";
String user = "sa";
String password = "sa";
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection c = DriverManager.getConnection(dburl,user, password);
if(c.isClosed())
{
System.out.println("error");
return;
}
c.setAutoCommit(false);
Statement s = c.createStatement();
ResultSet r = s.executeQuery("select cempno,cpdm from sys_parm");
while(r.next())
{
System.out.println(r.getString(1) + r.getString("cpdm"));
}
s.close();
c.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
错误提示:
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:198)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:186)
at java.lang.ClassLoader.loadClass(ClassLoader.java:299)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:265)
at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:140)
at aaa.connectMSSQLSERVER.connect(Frame1.java:133)
at aaa.Frame1.jButton1_actionPerformed(Frame1.java:65)
at aaa.Frame1_jButton1_actionAdapter.actionPerformed(Frame1.java:86)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1764)
at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1817)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:419)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:257)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245)
at java.awt.Component.processMouseEvent(Component.java:5134)
at java.awt.Component.processEvent(Component.java:4931)
at java.awt.Container.processEvent(Container.java:1566)
at java.awt.Component.dispatchEventImpl(Component.java:3639)
at java.awt.Container.dispatchEventImpl(Container.java:1623)
at java.awt.Component.dispatchEvent(Component.java:3480)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3450)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3165)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3095)
at java.awt.Container.dispatchEventImpl(Container.java:1609)
at java.awt.Window.dispatchEventImpl(Window.java:1590)
at java.awt.Component.dispatchEvent(Component.java:3480)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:450)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:197)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:144)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:136)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:99)
1. 我使用 jdatastore explorer 可以连接成功,连接参数也是那样 copy 下来的
实在想不出来那里还有错误, jsdv 的驱动安装了,三个文件也 copy 到了 jdk 下面的 lib 下面
2. 我怎么知道一个 connection 对象的状态,是否连接,难道一定要执行一个 SQL 吗???