1.首先在该项目的src文件夹下右键File创建以properties结尾的文件,在其中填写文件内容(切记千万不要出现空格,分号):
driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT
user=root
pass=980204
2代码如下:
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.util.Properties;
public class ExecuteDDL {
private String driver;
private String url;
private String user;
private String pass;
public void initParam(String paramFile)throws Exception{
Properties props =new Properties();//加载文件属性
props.load(new FileInputStream(paramFile));//创建一个文件输入流
driver =props.getProperty("driver");//获取数据库驱动
url=props.getProperty("url");//获取想要操作的数据库及其信息
user=props.getProperty("user");//获取用户名
pass=props.getProperty("pass");//获取密码
System.out.println(driver);
System.out.println(url);
System.out.println(user);
System.out.println(pass);
}
public void createTable(String sql)throws Exception{
Class.forName(driver);
try (
Connection conn =DriverManager.getConnection(url,user,pass);
Statement stmt=conn.createStatement()
)
{
stmt.executeUpdate(sql);//执行sql语句
}
}
public static void main(String[] args) throws Exception{
ExecuteDDL ed= new ExecuteDDL();
ed.initParam("src\\mysql.properties");
ed.createTable("create table jdbc_test "+"( jdbc_id int auto_increment primary key, "
+"jdbc_name varchar(255), "+"jdbc_desc text);");
System.out.println("ok------------------");
}
}