Statement Update

PHOTO EMBED

Sun Nov 03 2024 13:56:40 GMT+0000 (Coordinated Universal Time)

Saved by @login123 

import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Connection;
public class javaupdate {
    public static void main(String[] args) throws ClassNotFoundException,SQLException{
        Connection conn = null;
        Statement st = null;
        String username = "system";
        String password = "1808";
        String QUERY = "UPDATE employee set job = 'manager' where empno=7999";
        try{
            conn = DriverManager.getConnection("jdbc:oracle:thin:@//localhost:1521/XE", username, password);
            st = conn.createStatement();
            int rows = st.executeUpdate(QUERY);
            System.out.println(rows);
        }catch(SQLException e)
        {
            e.printStackTrace();
        }
    }
}
content_copyCOPY