package com.ll; import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; public class jdbcdemo { public static void main(String[] args) throws Exception { String url ="jdbc:mysql://127.0.0.1:3306/sys?useSSL=false"; String username="root"; String password="123456"; Connection conn = DriverManager.getConnection(url,username,password); String sql="UPDATE emp SET sal=500 WHERE empNo=7366"; Statement st = conn.createStatement(); int count =st.executeUpdate(sql); System.out.println(count); st.close(); conn.close(); } }
/*sys是数据库表名,*/
/*update里面的是字段名*/
/*记得改类名,包名*/