package mywork;import java.sql.DriverManager;
import java.sql.SQLException;import com.sun.corba.se.pept.transport.Connection;public class Test
{
public Connection conn;
String url="jdbc:mircrosoft:sqlserver://localhost:1433;DatabaseName=lijian";
String user="sa";
String password="1986829123";
public Test()
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLserverDriver");
}
catch(ClassNotFoundException e)
{};
try
{
conn=(Connection) DriverManager.getConnection(url,user,password);
}
catch(SQLException e)
{
System.out.println("sorry connection error!");
}
}
public static void main(String[] args)
{
new Test();
}
}
提示 sorry connection error
这异常该怎么解决呀!!!!
import java.sql.SQLException;import com.sun.corba.se.pept.transport.Connection;public class Test
{
public Connection conn;
String url="jdbc:mircrosoft:sqlserver://localhost:1433;DatabaseName=lijian";
String user="sa";
String password="1986829123";
public Test()
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLserverDriver");
}
catch(ClassNotFoundException e)
{};
try
{
conn=(Connection) DriverManager.getConnection(url,user,password);
}
catch(SQLException e)
{
System.out.println("sorry connection error!");
}
}
public static void main(String[] args)
{
new Test();
}
}
提示 sorry connection error
这异常该怎么解决呀!!!!
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at mywork.Test.<init>(Test.java:18)
at mywork.Test.main(Test.java:33)
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at mywork.Test.<init>(Test.java:24)
at mywork.Test.main(Test.java:33)
换成e.printStackTrace();看看到底是什么问题!
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at mywork.Test.<init>(Test.java:18)
at mywork.Test.main(Test.java:33)
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at mywork.Test.<init>(Test.java:24)
at mywork.Test.main(Test.java:33)就是这个呀
這個 com.sun.corba.se.pept.transport.Connection; 是什么?
怎么不用 java.sql.Connection; ?
确定端口是1433??
import java.sql.SQLException;import java.sql.*;public class Test
{
public Connection conn;
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=master";
String user="sa";
String password="1986829123";
public Test()
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(ClassNotFoundException e)
{e.printStackTrace();};
try
{
conn=(Connection) DriverManager.getConnection(url,user,password);
}
catch(SQLException e)
{
e.printStackTrace();
}
}
public static void main(String[] args)
{
new Test();
System.out.print("hello");
}
}
呵呵,现在可以了