内容摘要：复制importjava.sql.Connection; importjava.sql.DriverManager; importjava.sql.Resu

复制import java.sql.Connection;  import java.sql.DriverManager;  import java.sql.ResultSet;  import java.sql.SQLException;  import java.sql.Statement;  import java.util.Scanner;  public class Example32 {      publicstatic void main(String[] args) {          Scanner sc=new Scanner(System.in);          System.out.println("请输入ID:");          String oldId=sc.next();          System.out.println("请输入你要修改的接口ID:");          String newId=sc.next();          String driver="com.mysql.jdbc.Driver";          try {              //加载驱动              Class.forName(driver);              //数据库地址，高防服务器本机、站群服务器实现数据删除数据端口号3306、b2b信息网修改数据库名为test              String url="jdbc:mysql://localhost:3306/test";              //用户名              String user="root";              //密码              String pwd="168168";              //连接数据库              Connection conn=DriverManager.getConnection(url,接口user,pwd);              //创建Statement对象              Statement stmt=conn.createStatement();              String sql="update student set id="+newId+" where id="+oldId+"";              //执行SQL语句              stmt.executeUpdate(sql);              sql="select * from student where id="+newId+"";              //执行SQL语句              ResultSet rs=stmt.executeQuery(sql);              //根据ID值获取数据              if(rs.next()){                  System.out.println("id:"+rs.getString("id")+"  name:"+rs.getString("name")+"  age:"+rs.getInt("age"));              }          } catch (ClassNotFoundException e) {              // TODO Auto-generated catch block              e.printStackTrace();          } catch (SQLException e) {              // TODO Auto-generated catch block              e.printStackTrace();          }      }  }  1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.