Java的JDBC的一点小问题
public class ExecuteDDl {
private String driver;
private String url;
private String user;
private String pass;
public void initParam(String paramFile)throws Exception{
//使用Properties类来加载属性文件
Properties props = new Properties();
props.load(new FileInputStream(paramFile));
driver = props.getProperty("com.mysql.cj.jdbc.Driver");
url = props.getProperty("jdbc:mysql://localhost:3306/localhost");
user = props.getProperty("root");
pass = props.getProperty("asd857448959");
}
public void createTable(String sql)throws Exception{
//加载驱动
Class.forName(driver);
try(
//获取数据库链接
Connection conn = DriverManager.getConnection("url", "user", "pass");
//使用Connection来创建一个 Statement对象
Statement stmt = conn.createStatement())
{
//执行DDL语句,创建数据表
stmt.executeUpdate(sql);
}
}
public static void main(String[] args)throws Exception{
ExecuteDDl ed = new ExecuteDDl();
ed.initParam("mysql.ini");
ed.createTable("create table jdbc_test"
+"( jdbc_id int auto_increment primary key,"
+"jdbc_name varchar(255),"
+ "jdbc_desc text);");
System.out.println("-----建表成功--------");
}
}
当这代码执行产生一下错误
Exception in thread "main" java.lang.NullPointerException
at java.base/java.lang.Class.forName0(Native Method)
at java.base/java.lang.Class.forName(Unknown Source)
at JDBCno1.ExecuteDDl.createTable(ExecuteDDl.java:26)
at JDBCno1.ExecuteDDl.main(ExecuteDDl.java:41)
麻烦各位小哥哥小姐姐了,这个弄了挺久就是不知道咋办~~~