我的程序在DOS下可以连到数据库,为什么放到elipse下就出错了!
import java.sql.*;
import java.io.*;
public class Test{
public static void main(String args[])
{
String URL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=master";
String user ="sa";//这里替换成你自已的数据库用户名
String password = "";//这里替换成你自已的数据库用户密码
String sqlStr = "select * from sysusers"; try{ //这里的异常处理语句是必需的.否则不能通过编译!
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
System.out.println( "类实例化成功!" );
System.out.println("成功了!");
Connection con = DriverManager.getConnection(URL,user,password);
System.out.println( "创建连接对像成功!" ); Statement st = con.createStatement();
System.out.println( "创建Statement成功!" ); ResultSet rs = st.executeQuery( sqlStr );
System.out.println( "操作数据表成功!" );
System.out.println( "----------------!" ); while(rs.next())
{
System.out.print(rs.getString("uid") + " ");
System.out.print(rs.getString("name") + " ");
//System.out.print(rs.getString("Student_Sex") + " ");
//System.out.print(rs.getString("Student_Class") + " ");
//System.out.println(rs.getString("Student_Tel") + " ");
}
rs.close();
st.close();
con.close();
}
catch(Exception err){
err.printStackTrace(System.out);
}
}
}java.lang.ClassNotFoundException
我想问下,还要配置什么吗?
import java.sql.*;
import java.io.*;
public class Test{
public static void main(String args[])
{
String URL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=master";
String user ="sa";//这里替换成你自已的数据库用户名
String password = "";//这里替换成你自已的数据库用户密码
String sqlStr = "select * from sysusers"; try{ //这里的异常处理语句是必需的.否则不能通过编译!
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
System.out.println( "类实例化成功!" );
System.out.println("成功了!");
Connection con = DriverManager.getConnection(URL,user,password);
System.out.println( "创建连接对像成功!" ); Statement st = con.createStatement();
System.out.println( "创建Statement成功!" ); ResultSet rs = st.executeQuery( sqlStr );
System.out.println( "操作数据表成功!" );
System.out.println( "----------------!" ); while(rs.next())
{
System.out.print(rs.getString("uid") + " ");
System.out.print(rs.getString("name") + " ");
//System.out.print(rs.getString("Student_Sex") + " ");
//System.out.print(rs.getString("Student_Class") + " ");
//System.out.println(rs.getString("Student_Tel") + " ");
}
rs.close();
st.close();
con.close();
}
catch(Exception err){
err.printStackTrace(System.out);
}
}
}java.lang.ClassNotFoundException
我想问下,还要配置什么吗?
下面是elipse的错误:
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.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at Test.main(Test.java:12)
eclipse中project选项卡->propertise->java Buiderpath->add extrnalJars