在写之前首先得感谢JAVA1234的小峰老师,是看了他的视频再开始的学习,非常感谢
package class1;
import java.sql.DriverManager;
import com.mysql.jdbc.Connection;
public class Demo2 {
private static String dburl="jdbc:mysql://localhost:3306/db_text";
private static String dbusername="root";
private static String dbpassword="876986919";//这是我QQ号,有想一起探讨的朋友可以加一下
private static String dbjdbcname="com.mysql.jdbc.Driver";
public static void main(String[] args) throws Exception {
try {
Class.forName(dbjdbcname);
System.out.println("加载数据库成功!");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("加载数据库失败!");
}
try {
Connection con=(Connection) DriverManager.getConnection(dburl, dbusername, dbpassword);
System.out.println("连接数据库成功!");
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("连接数据库失败!");
}
}
}
之前了解了try catch 现在看代码就明白多了,这里面能让我疑惑的就是这句: Connection con=(Connection) DriverManager.getConnection(dburl, dbusername, dbpassword);在视频中代码是Connection con= DriverManager.getConnection(dburl, dbusername, dbpassword); 但是为啥我的DriverManager前面就要加一个(Connection)呢?刚刚才发现,原来我少了java.sql.Connection 的接口····晕死················,所以新的代码就变成:
package class1;
import java.sql.DriverManager;
import java.sql.Connection ;
public class Demo2 {
private static String dburl="jdbc:mysql://localhost:3306/db_text";
private static String dbusername="root";
private static String dbpassword="876986919";
private static String dbjdbcname="com.mysql.jdbc.Driver";
public static void main(String[] args) throws Exception {
try {
Class.forName(dbjdbcname);
System.out.println("加载数据库成功!");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("加载数据库失败!");
}
try {
DriverManager.getConnection(dburl, dbusername, dbpassword);
System.out.println("连接数据库成功!");
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("连接数据库失败!");
}
}
}