为什么数据库查询语句在JC4.0里面可以连上数据库,查询出数据;而把程序放到Myelipse6.0.1里面运行的时候,出现了抛错,p抛错ClassNotFoundException,查询不了数据!难道,Myelipse还要配置什么吗?
以下是程序:
import java.sql.*;
import java.io.*;
class Test{
public static void main(String args[])
{
String URL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Student";
String user ="sa";//这里替换成你自已的数据库用户名
String password = "";//这里替换成你自已的数据库用户密码
String sqlStr = "select * from Student"; 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("Student_ID") + " ");
System.out.print(rs.getString("Student_Name") + " ");
System.out.print(rs.getString("Student_Sex") + " ");
System.out.print(rs.getString("Student_Class") + " ");
System.out.print(rs.getString("Student_Tel") + " ");
}
rs.close();
st.close();
con.close();
}
catch(Exception err){
err.printStackTrace(System.out);
}
}
}
以下是程序:
import java.sql.*;
import java.io.*;
class Test{
public static void main(String args[])
{
String URL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Student";
String user ="sa";//这里替换成你自已的数据库用户名
String password = "";//这里替换成你自已的数据库用户密码
String sqlStr = "select * from Student"; 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("Student_ID") + " ");
System.out.print(rs.getString("Student_Name") + " ");
System.out.print(rs.getString("Student_Sex") + " ");
System.out.print(rs.getString("Student_Class") + " ");
System.out.print(rs.getString("Student_Tel") + " ");
}
rs.close();
st.close();
con.close();
}
catch(Exception err){
err.printStackTrace(System.out);
}
}
}
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)
以下是JC结果:
类实例化成功!
成功了!
创建连接对像成功!
创建Statement成功!
操作数据表成功!
----------------!
0018 梁华 男 06软件1班 13540005136
Process completed.
连接mssql需要的3个jar都添加到classpath中了没有?
.;%java_home%\lib\dt.jar;%java_home%\lib\tools.jar;%CATALINA_HOME%\common\lib\servlet.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;