大虾们...穷的要哭了...不能在技术区发帖
import java.sql.*;
public class DBTester{
public static void main(String args[])throws Exception{
Connection con;
Statement stmt;
ResultSet rs;
//加载驱动器,下面的代码为加载sqlserver驱动器
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//注册sqlserver驱动器
// DriverManager.registerDrive(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
//连接到数据库的URL
String dbUrl = "jdbc:microsoft:sqlserver//localhost:3306/STOREDB";
String dbUser="sa";
String dbPwd="ws2011it";
//建立数据库连接
con = java.sql.DriverManager.getConnection(dbUrl,dbUser,dbPwd);
//创建一个Statement对象
stmt = con.createStatement();
//增加新记录
String name1=new String("小王".getBytes("GB2312"),"ISO-8859-1");
String address1=new String("上海".getBytes("GB2312"),"ISO-8859-1");
stmt.executeUpdate("insert into CUSTOMERS (NAME,AGE,ADDRESS) VALUES ('"+name1+"',20,'"+address1+"')");
//查询记录
rs= stmt.executeQuery("SELECT ID,NAME,AGE,ADDRESS from CUSTOMERS");
//输出查询结果
while (rs.next()){
long id = rs.getLong(1);
String name = rs.getString(2);
int age = rs.getInt(3);
String address = rs.getString(4);
//字符编码转换
if(name!=null)name=new String(name.getBytes("ISO-8859-1"),"GB2312");
if(address!=null)address=new String(address.getBytes("ISO-8859-1"),"GB2312");
//打印所显示的数据
System.out.println("id="+id+",name="+name+",age="+age+",address="+address);
}
//删除新增加的记录
stmt.executeUpdate("delete from CUSTOMERS where name='"+name1+"'");
//释放相关资源
rs.close();
stmt.close();
con.close();
}
}
我在环境变量里面明明设置了JDBC驱动器类库的路径了,可是就是编译不过,大虾们救救我吧,纠结两天了
Exception in thread "main" java.lang.ClassNotFoundException: com.microsoft.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 DBTester.main(DBTester.java:9)
以上是错误