//冲数据库中取出学生信息package come.test1;
import java.util.Vector;import javax.swing.JFrame;
import javax.swing.JTable;
import javax.swing.JScrollPane;
import java.sql.*;
class Test2 extends JFrame
{
Vector rowData, columnNames;//raw 用来存放行数据 那个事列数据
JTable jt=null;
JScrollPane jsp=null;
//定义连接数据库的东西
PreparedStatement ps=null;
Connection ct=null;
ResultSet rs=null;
public static void main (String[] args){
Test2 test2=new Test2();
}
public Test2()
{ columnNames=new Vector();
JTable jt=null;
JScrollPane jsp=null;
//定义连接数据库的东西
PreparedStatement ps=null;
Connection ct=null;
ResultSet rs=null; columnNames.add("学号");
columnNames.add("名字");
columnNames.add("性别");
columnNames.add("年龄");
columnNames.add("籍贯");
columnNames.add("系别");
rowData=new Vector();
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLSserverDriver");
ct=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1443;databaseName=oo","sa","123456");
ps=ct.prepareStatement("selec * from stu");
rs=ps.executeQuery();
while(rs.next()){
//rowdata可以存放多行)
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.add(hang);
}
}catch (Exception e){
e.printStackTrace();}
finally{
System.out.println("Game Over~"); try{
if(rs!=null ) rs.close();
if(ps!=null ) rs.close();
if(ct!=null ) rs.close();
} catch (Exception e){
e.printStackTrace();} } }
}
异常如下
Game Over~
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLSserverDriver
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 come.test1.Test2.<init>(Test2.java:39)
at come.test1.Test2.main(Test2.java:20)
import java.util.Vector;import javax.swing.JFrame;
import javax.swing.JTable;
import javax.swing.JScrollPane;
import java.sql.*;
class Test2 extends JFrame
{
Vector rowData, columnNames;//raw 用来存放行数据 那个事列数据
JTable jt=null;
JScrollPane jsp=null;
//定义连接数据库的东西
PreparedStatement ps=null;
Connection ct=null;
ResultSet rs=null;
public static void main (String[] args){
Test2 test2=new Test2();
}
public Test2()
{ columnNames=new Vector();
JTable jt=null;
JScrollPane jsp=null;
//定义连接数据库的东西
PreparedStatement ps=null;
Connection ct=null;
ResultSet rs=null; columnNames.add("学号");
columnNames.add("名字");
columnNames.add("性别");
columnNames.add("年龄");
columnNames.add("籍贯");
columnNames.add("系别");
rowData=new Vector();
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLSserverDriver");
ct=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1443;databaseName=oo","sa","123456");
ps=ct.prepareStatement("selec * from stu");
rs=ps.executeQuery();
while(rs.next()){
//rowdata可以存放多行)
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.add(hang);
}
}catch (Exception e){
e.printStackTrace();}
finally{
System.out.println("Game Over~"); try{
if(rs!=null ) rs.close();
if(ps!=null ) rs.close();
if(ct!=null ) rs.close();
} catch (Exception e){
e.printStackTrace();} } }
}
异常如下
Game Over~
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLSserverDriver
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 come.test1.Test2.<init>(Test2.java:39)
at come.test1.Test2.main(Test2.java:20)
改为
Class.forName("com.microsoft.jdbc.sqlserver.SQLSserverDriver");
试试具体的要看看mssqlserver.jar里SQLServerDriver.class的位置
多写了一个S