Updating a row in sql using jdbc
If column names are used, the developer should guarantee that they uniquely refer to the intended columns by using column aliases.A column alias effectively renames the column of a result set.The result of the query is as follows: By executing the Java program above, you will see the following output: If you execute the SELECT statement again, you will see that the changes have been applied to the candidates table.To create a Postgre SQL database connection from a Java program, you need to have the Postgre SQL JDBC driver.
When a getter method is called with a string and more than one column has the same alias or name as the string, the value of the first matching column is returned.
In this example we have created two jsp pages and updating
In the page, we are using a Text box where user can give his/her name and submit the page.
Bulusu Lakshman describes Oracle database access in Java using JDBC.
Learn the the details, from the querying and returning of resultsets to executing DML from the Oracle 8i database.