Main.java Source code

Introduction

Here is the source code for Main.java

Source

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Main {
    public static void main(String[] args) throws Exception {
        Class.forName("com.mysql.jdbc.Driver");
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost/testdb", "root", "");

        Statement statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                ResultSet.CONCUR_UPDATABLE);

        String query = "SELECT id, code, name, quantity, price FROM products";
        ResultSet uprs = statement.executeQuery(query);

        while (uprs.next()) {
            System.out.println(uprs.getString("id") + ":" + uprs.getString("code") + ":" + uprs.getString("name")
                    + ":" + uprs.getInt("quantity") + ":" + uprs.getDouble("price"));
        }
        uprs.first();
        uprs.updateString("name", "Java");
        uprs.updateRow();
        uprs.next();
        uprs.deleteRow();

        uprs.moveToInsertRow();
        uprs.updateString("code", "1");
        uprs.updateString("name", "Data Structures");
        uprs.updateInt("quantity", 1);
        uprs.updateDouble("price", 5.99);
        uprs.insertRow();

        uprs.beforeFirst();
        while (uprs.next()) {
            System.out.println(uprs.getString("id") + "\t" + uprs.getString("code") + "\t" + uprs.getString("name")
                    + "\t" + uprs.getInt("quantity") + "\t" + uprs.getDouble("price"));
        }
        connection.close();
    }
}