- 要先说一下mysql.ini是什么,就是为了给Properties加载用的一些键值对,具体操作是新建一个文本文档,内容如下注意密码要修改成你的数据库的密码,然后把文本文档的后缀名改成ini,再把它拖到项目文件夹里面去。
- 没啥好说的,都在代码里了
- 创建表
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"); } public void createTable(String sql) throws Exception{ Class.forName(driver); // 通过反射加载驱动 try( Connection connection = DriverManager.getConnection(url, user, pass); // 链接数据库 Statement statement = connection.createStatement()){ // 获取Statement对象,再通过Statement对象来执行sql语句 statement.executeUpdate(sql); // 执行具体的sql语句 } } public static void main(String args[]) throws Exception{ ExecuteDDL ed = new ExecuteDDL(); ed.initParam("mysql.ini"); ed.createTable("create table jdbc_test1 " + "(jdbc_id int auto_increment primary key," + "jdbc_name varchar(255), " + "jdbc_desc text);"); System.out.println("ok~~"); } }
成功执行之后,打开数据库看到
-
向表中添加数据
import javax.swing.plaf.nimbus.State; import java.io.FileInputStream; import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; import java.util.Properties; public class ExecuteDML { private String driver; private String url; private String user; private String pass; public void iniParam(String paramFile) throws Exception{ Properties properties = new Properties(); properties.load(new FileInputStream(paramFile)); driver = properties.getProperty("driver"); url = properties.getProperty("url"); user = properties.getProperty("user"); pass = properties.getProperty("pass"); } public int insertData(String sql) throws Exception{ Class.forName(driver); try( Connection connection = DriverManager.getConnection(url, user, pass); Statement statement = connection.createStatement();){ return statement.executeUpdate(sql); } } public static void main(String args[]) throws Exception{ ExecuteDML ed = new ExecuteDML(); ed.iniParam("mysql.ini"); int result = ed.insertData("insert into jdbc_test1 values (2, 'S','a');"); System.out.println("ok~"); } }
成功执行之后,使用select * from jdbc_test1; 可以看到
java数据库编程(3) 创建表和向表中加入数据
最新推荐文章于 2021-12-22 15:52:57 发布