on It Road.com
Java 执行数据库insert语句示例
package com.onitroad.jdbc.demo; import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; public class InsertDataDemo { public static void main(String[] args) { Connection connection = null; Statement stmt = null; try { // 加载驱动程序 Class.forName("com.mysql.jdbc.Driver"); // 连接到数据库 connection = DriverManager .getConnection("jdbc:mysql://localhost:3306/JDBCDemo", "root", "password"); // 执行 SQL INSERT 查询 // 创建一个 Statement 对象,然后使用它的 execute() 方法。 stmt = connection.createStatement(); stmt.execute("INSERT INTO EMPLOYEE (ID,FIRST_NAME,LAST_NAME,STAT_CD) " + "VALUES (1,'Jamez','Gupta',5)"); } catch (Exception e) { e.printStackTrace(); }finally { try { stmt.close(); connection.close(); } catch (Exception e) { e.printStackTrace(); } } } }
日期:2020-09-17 00:09:50 来源:oir作者:oir