java插入删除_插入.删除.修改



update.java

~~~

package zyw.crud;

import java.sql.*;

public class update {

public static void main(String[] args) throws SQLException, ClassNotFoundException {

// 1、注册数据库的驱动

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

// 2.获取数据库连接

String url="jdbc:mysql://122.14.200.136:3306/javadb";

Connection connection = DriverManager.getConnection(url, "root", "6a133f0024");

//3.获取操作数据库的对象

Statement statement= connection.createStatement();

// String sql = "insert into xuesheng VALUES ('xs005','zhangsna','男',20,'贵州','计算机')";

// String sql="delete from xuesheng where xuehao='xs005'";

String sql="update xuesheng set nianling=21 where xuehao='xs001'";

int result=statement.executeUpdate(sql);

//4.遍历结果集，取出数据

System.out.println("影响条数："+result);

//5.关闭对象

statement.close();

connection.close();

}

}

~~~