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 () ;

               }           }      }}