【数据库】兴唐第二十七节课之jdbc的使用

使用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行代码