JDBC+注册驱动+获取连接+定义sql语句+获取执行sql对象+执行sql

package com.itheima; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; public class jdbc { public static void main(String[] args) throws Exception{ //1.注册驱动 Class.forName("com.mysql.jdbc.Driver"); //2.获取连接 String url="jdbc:mysql://127.0.0.1:3306/db1?useSSL=false";//连接路径 String username="root"; String password="123456"; Connection conn=DriverManager.getConnection(url,username,password); //3.定义sql语句 String sql="update stus set id=4 where name='lsq'"; //4.获取执行sql对象 Statement stmt= conn.createStatement(); //5.执行sql int count=stmt.executeUpdate(sql); System.out.println(count); } }