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)";
解决方案 »
- 菜鸟在GUI遇到的一点点问题~求帮忙!
- java中能实现当界面最小化后,仍能进行监听?
- Java如何终止程序运行
- 求解JAVA string.getBytes()问题。。
- 求助,java写的程序,用本bp算法实现模拟f(x)=sin6(5πx),结果总是0
- 求JAVA实现把汉字转化成拼音(给分贴,勿进)
- 哪里有Thinking in java第二版的英文版下载呀?
- 急急急!!!关于JAVASCRIPT表达式的问题,问题解决立马结贴.绝不食言!!!
- java编译反编译错误,急急急!
- ObjectOutputStream 乱码
- 有关Iterator的问题,代码会报java.util.ConcurrentModificationException错
- 产生20个int类型的随机数,针对每个数使用if-then-else判断它是大于、小于或等于下一个数,最后一个数不参与比较。
写错了吧
应该是:
con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb","sa", "sa");