import java.sql.Connection;
import java.sql.SQLException;
import java.sql.DriverManager;
import java.util.Properties;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;public class DBManager {
Properties propInfo = new Properties();
private Connection con = null;
public Connection getConnection() {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = DriverManager.getConnection("sa", "sa", "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException sqle) {
sqle.printStackTrace();
}
return con;
}大家帮忙看一下我哪错了,运行后的异常为
"java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.basicapp.util.DBManager.getConnection(DBManager.java:30)
at com.basicapp.util.Test.main(DBManager.java:58)";
import java.sql.SQLException;
import java.sql.DriverManager;
import java.util.Properties;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;public class DBManager {
Properties propInfo = new Properties();
private Connection con = null;
public Connection getConnection() {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = DriverManager.getConnection("sa", "sa", "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException sqle) {
sqle.printStackTrace();
}
return con;
}大家帮忙看一下我哪错了,运行后的异常为
"java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.basicapp.util.DBManager.getConnection(DBManager.java:30)
at com.basicapp.util.Test.main(DBManager.java:58)";
解决方案 »
- Integral cannot be resolved to a type 为什么这个类型他都认不出来
- java基础
- 可以在eclipse运行的程序打包后 使用一些功能就会报错
- 这样的错误是什么问题??description The server encountered an internal error () that prevented it from fulfilling this request....
- 有关基于授权事件和基于继承事件的问题???
- 项目需要,没时间学java >_< 有个问题请教大家,关于基类和接口同一方法名
- 我有一个读文件的类,在JSP中一调用它就出错,请高手帮帮忙
- jdbc一问
- resin的配置问题
- 哪里有visio2002正式版下载?
- 有关Iterator的问题,代码会报java.util.ConcurrentModificationException错
- 产生20个int类型的随机数,针对每个数使用if-then-else判断它是大于、小于或等于下一个数,最后一个数不参与比较。
写错了吧
应该是:
con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb","sa", "sa");