2、TestDML语句实现添加数据

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

public class TestDML {

     public static void main(String[] args) {

          Statement stmt = null;

          Connection conn = null;

          // 跟数据库连接先找到数据库管家DriverManager(连接哪种数据库)

          // new出来mysql驱动类-class.forname

          try {

              Class.forName("com.mysql.jdbc.Driver");

              // 此时会自动注册DriverManager,可以拿到跟数据库连接

              conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/tab_demo?useSSL=false", "root", "123456");

              // 现在已经连接到数据库上了,现在执行sql语句

              // 创建一个语句对象Statement陈述语句的意思

              stmt = conn.createStatement();

              String sql = "INSERT INTO `tab_demo`.`inf` (`name`, `age`) VALUES ('张三', 17)";

              int insert = stmt.executeUpdate(sql);

              System.out.println(insert);

          } catch (ClassNotFoundException e) {

              // 驱动找不到报异常

              e.printStackTrace();

          } catch (SQLException e) {

              // 后面的SQL执行异常,通常记录在log文件里,用log for J开源框架记录在文件里

              e.printStackTrace();

          } finally {// 关闭资源

              try {

                   if (stmt != null) {

                        stmt.close();

                        stmt = null;

                   }

                   if (conn != null) {

                        conn.close();

                        conn = null;

                   }

              } catch (SQLException e) {

                   e.printStackTrace();

              }         }    }}