public class Test03 {
public static void main(String[] args) {
ResourceBundle bundle = ResourceBundle.getBundle("jdbc");
String driver = bundle.getString("driver");
String url = bundle.getString("url");
String user = bundle.getString("user");
String password = bundle.getString("password");
Statement stmt = null;
Connection conn = null;
try {
//1.
Class.forName("driver");
//2.
conn = DriverManager.getConnection(url, user, password);
System.out.println(conn);
//3.
stmt = conn.createStatement();
//4.
int count = stmt.executeUpdate("insert into t_student(no,name,sex) values(2,'555',3)");
System.out.println(count == 1 ? "保存成功" : "保存失败");
//5.
//6.
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
if (stmt != null) {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
结果:
java.lang.ClassNotFoundException: driver
at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:355)
at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at Test03.main(Test03.java:20)
Process finished with exit code 0
配置文件: driver=com.mysql.jdbc.Driver url=jdbc:mysql://127.0.0.1:3306/linf user=root password=891399129
已经知道原因啦
Class.forName("driver")???? 况且因为JAVA的SPI机制,现在已经不需要手动加载Driver驱动了。有兴趣可以了解一下SPI