JAVA操作数据库,出现java.lang.ClassNotFoundException
我用java连接数据库时出现这种错误提示:
java.lang.ClassNotFoundException: com.mircosoft.jdbc.sqlserver.SQLServerDriver
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:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at com.excise1.StuManager.<init>(StuManager.java:35)
at com.excise1.StuManager.main(StuManager.java:96)
该怎么解决啊?
以下是源代码:
import javax.swing.*;
import javax.swing.JTable;
import java.awt.*;
import java.awt.event.*;
import java.util.*;
import java.sql.*;
public class StuManager extends JFrame
{
JTable jt=null;
JScrollPane jsp=null;
Vector rowData=null;
Vector columnNames=null;
Connection ct=null;
PreparedStatement ps=null;
ResultSet rs=null;
public StuManager()
{
columnNames=new Vector();
//设置列名
columnNames.add("学号");
columnNames.add("姓名");
columnNames.add("性别");
columnNames.add("年龄");
columnNames.add("籍贯");
columnNames.add("院系");
rowData=new Vector();
try
{
Class.forName("com.mircosoft.jdbc.sqlserver.SQLServerDriver");
ct=DriverManager.getConnection("jdbc:mircosoft:sqlserver://localhost:1433;databaseName=student","sa","sa");
ps=ct.prepareStatement("select * from student");
rs=ps.executeQuery();
while(rs.next())
{
Vector hang=new Vector();
hang.add(rs.getString(1));
hang.add(rs.getString(2));
hang.add(rs.getString(3));
hang.add(rs.getInt(4));
hang.add(rs.getString(5));
hang.add(rs.getString(6));
//加入的rowData
rowData.add(hang);
}
}
catch(Exception ex)
{
ex.printStackTrace();
}
finally
{
try
{
if(ps!=null)
{
ps.close();
}
if(ct!=null)
{
ct.close();
}
if(rs!=null)
{
rs.close();
}
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
//初始化JTable
jt=new JTable(rowData,columnNames);
//初始化JScrollPane
jsp=new JScrollPane(jt);
//把jscrollpane方式到JFrame中
this.add(jsp);
this.setSize(400,300);
this.setLocation(400, 200);
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setVisible(true);
}
public static void main(String[] args)
{
StuManager st=new StuManager();
}
}
[解决办法]