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 Method.getAllData(Method.java:19)
at Method.main(Method.java:77)----------------------------------------------------------------------------------
连接数据库用的是jtds-1.2.-----------------------------------------------------------------------------------
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;public class Method
{
public Vector<Message> getAllData()
{
Vector<Message> mes = new Vector<Message>();
Connection conn = null;
Statement st = null;
ResultSet rs = null;
//1、加载驱动
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//2、创建连接对象
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs","sa","123");
//3、创建语句执行器
st = conn.createStatement();
String sql = "select id, name, sex from message";
//4、执行数据库操作
rs = st.executeQuery(sql);
while(rs.next())
{
Message m = new Message();
m.setId(rs.getInt(1));
m.setName(rs.getString(2));
m.setSex(rs.getString(3));
mes.add(m);
}
}
catch (ClassNotFoundException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
if(st != null)
{
try
{
st.close();
}
catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(conn != null)
{
try
{
conn.close();
}
catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
return mes;
}
public static void main(String[] args)
{
System.out.println(new Method().getAllData());
}
}----------------------------------------------------------------------------------------
能帮一下看看什么错误吗?实在是看不出来
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 Method.getAllData(Method.java:19)
at Method.main(Method.java:77)----------------------------------------------------------------------------------
连接数据库用的是jtds-1.2.-----------------------------------------------------------------------------------
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;public class Method
{
public Vector<Message> getAllData()
{
Vector<Message> mes = new Vector<Message>();
Connection conn = null;
Statement st = null;
ResultSet rs = null;
//1、加载驱动
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//2、创建连接对象
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs","sa","123");
//3、创建语句执行器
st = conn.createStatement();
String sql = "select id, name, sex from message";
//4、执行数据库操作
rs = st.executeQuery(sql);
while(rs.next())
{
Message m = new Message();
m.setId(rs.getInt(1));
m.setName(rs.getString(2));
m.setSex(rs.getString(3));
mes.add(m);
}
}
catch (ClassNotFoundException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
if(st != null)
{
try
{
st.close();
}
catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(conn != null)
{
try
{
conn.close();
}
catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
return mes;
}
public static void main(String[] args)
{
System.out.println(new Method().getAllData());
}
}----------------------------------------------------------------------------------------
能帮一下看看什么错误吗?实在是看不出来
解决方案 »
- ssh框架 面试主要问哪些问题
- 有关io流保存图片的问题
- 问一个很弱智的问题!
- oracle10g jdbc驱动+hibernate3实现blob字段映射成byte[]类型时写入没有问题,读出总是不对,谁知道怎么办啊?
- 高手帮我看看这是什么情况
- 问一下有谁知道 MVS 是什么东东
- po,bo,jo,lo,VO什么的,我怎么都有些混啦,那位能给偶个头绪吗?(不够在加分)
- 数据库连接问题?
- 几天没来多了个版,人很多,不过。。。。。。
- springmvc上传文件 ajaxfileupload.js data参数怎么接受值,我的做法有啥问题
- 关于java socket
- 高手运行一下我的程序 为什么报错 啊 control.jsp这个页面报错
Jar包引入了没有?