使用jdbc修改数据库表中的信息
package java27practice;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCDemo {
public static void main(String[] args) {
Connection conn =null;
Statement stat = null;
try {
//加载驱动
Class.forName("com.mysql.jdbc.Driver");
//通过驱动获得数据库连接
String url = "jdbc:mysql://127.0.0.1:3306/tyrantforever";
conn = DriverManager.getConnection(url, "root", "root");
//使用数据库连接操作数据
stat = conn.createStatement();
String sql = "update students set stu_name = '小红' where scores = 99";
int affectedRow = stat.executeUpdate(sql);
if(affectedRow > 0) {
System.out.println("修改成功!");
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
try {
if(conn != null) {
conn.close();
}
if(stat != null) {
stat.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
就修改了一个名,用了40行代码