2、TestDML语句实现添加数据

importjava.sql.Connection;

importjava.sql.DriverManager;

importjava.sql.SQLException;

importjava.sql.Statement;

publicclassTestDML{

     publicstaticvoidmain(String[]args){

          Statementstmt=null;

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

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

              intinsert=stmt.executeUpdate(sql);

              System.out.println(insert);

          }catch(ClassNotFoundExceptione){

              // 驱动找不到报异常

              e.printStackTrace();

          }catch(SQLExceptione){

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

              e.printStackTrace();

          }finally{// 关闭资源

              try{

                   if(stmt!=null){

                        stmt.close();

                        stmt=null;

                   }

                   if(conn!=null){

                        conn.close();

                        conn=null;

                   }

              }catch(SQLExceptione){

                   e.printStackTrace();

              }         }    }}