那位大虾能帮帮忙,小弟重分感谢!
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Test { public static void main(String[] arg)
{
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=master","sa","yun");
Statement sm = con.createStatement();
ResultSet rs = sm.executeQuery("select * from user1");
System.out.println(rs.getString(1));
}
catch(Exception e){
e.printStackTrace();
} }
}下面是Eclipe运行出现的错误:
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.luckytjx.concatKu.Test.main(Test.java:16)
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Test { public static void main(String[] arg)
{
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=master","sa","yun");
Statement sm = con.createStatement();
ResultSet rs = sm.executeQuery("select * from user1");
System.out.println(rs.getString(1));
}
catch(Exception e){
e.printStackTrace();
} }
}下面是Eclipe运行出现的错误:
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.luckytjx.concatKu.Test.main(Test.java:16)
解决方案 »
- SQL问题 XLS文件导入到SLQ表
- 关于表增加字段,视图需要重新更新的问题?
- 数据库附加问题请教
- ===============请问大家DBF是什么格式?是数据库的全部信息还是数据库的其中表呢+++++++++++++++++++++
- top的简单问题
- SQLServer触发器中 如何访问mySQL数据库?
- 请教一个从数据库里读取XML格式数据并存入一个XML文件里的问题
- @@rowcount的奇怪问题
- 初学,建系统,请给点意见与建议!(分不够再贴,UP有分!)
- 谁有VC++中应用ODBC API 连接数据库的例子?
- 求sql 行字段拼凑
- 急,在数据库质疑后,.下面执行真正的恢复操作,重建数据库日志文件 提示由于文件 ID 0(位于数据库 'test2' 中)无效,所以未能打开 FCB,这句话是什么意思呢
试试 还有添加驱动别忘了
Connection con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=master","sa","yun");
是这句话改成
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=master","sa","yun");
是这句话 别的好像都没错
java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=master
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.luckytjx.concatKu.Test.main(Test.java:17)