复制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、服务器租用修改数据库名为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. |
喜欢
讨厌