新手jdbc问题
小鸟向前飞 2010-05-23 09:31:51 连接sql server 2000
报错 请教一下 代码如下
try
{
Class.forName("com.Microsoft.jdbc.sqlserver.SQLServerDriver");
ct = DriverManager.getConnection
("jdbc:Microsoft:sqlserver://127.0.0.1:1433;databaseName = master");
ps = ct.prepareStatement("select * from emp");
rs = ps.executeQuery();
while(rs.next())
{
String name = rs.getString(2);
float f = rs.getFloat(6);
int i = rs.getInt(8);
System.out.println(name+" "+f+" "+i);
}
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
try {
rs.close();
ps.close();
ct.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
报错:
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 com.jdbctoodbc.Test3.main(Test3.java:19)
Exception in thread "main" java.lang.NullPointerException
at com.jdbctoodbc.Test3.main(Test3.java:40)
就是颜色字体那一行
是哪里写错了吗?谢谢