Kode Java

 
package org.kodejava.example.sql;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
 
public class ScrollableMoveExample {
    public static void main(String[] args) throws Exception {
        Connection connection = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            connection = DriverManager.getConnection("jdbc:mysql://localhost/testdb", "root", "");
 
            //
            // In this example we first create a statement that allows us to go back and forth
            // in the result set object. First we'll iterate the result from beginning to the
            // end. 
            //
            Statement statement = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                    ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = statement.executeQuery("SELECT * FROM products");
            while (resultSet.next()) {
                String productCode = resultSet.getString("product_code");
                String productName = resultSet.getString("product_name");
                int quantity = resultSet.getInt("quantity");
                double price = resultSet.getDouble("price");
 
                System.out.println(productCode + "\t" + productName + "\t" + quantity + "\t" + price);
            }
            
            System.out.println("");
 
            //
            // Now the result set pointer is placed after the last record. With the previous
            // method of the result set we can now move the pointer backward to the beginning
            // of the result set.
            //            
            while (resultSet.previous()) {
                String productCode = resultSet.getString("product_code");
                String productName = resultSet.getString("product_name");
                int quantity = resultSet.getInt("quantity");
                double price = resultSet.getDouble("price");
 
                System.out.println(productCode + "\t" + productName + "\t" + quantity + "\t" + price);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if (connection != null) {
                connection.close();
            }
        }
    }
}
 
 

• How do I convert String to Date object?
• How do I convert array to collection?
• How do I get day, month, year value from the current date?
• How do I read a text file?
• How do I get the current month name?
• How do I convert collection into array?
• How do I format a number?
• How do I use StringTokenizer to split a string?
• How do I do a date add or substract?
• How do I write string data to file?

• What need to be prepared for learning Java Programming?
• How do I reverse a string?
• How do I implement a Singleton pattern?
• Hello World example in Java
• How do I split a string?
• How do I create a zip file?
• How do I create a connection to database?
• How do I create a beep sound?
• How do I read text file content line by line using commons-io?
• What is Autoboxing?

• How do I sort array values in case insensitive order?
• How do I sort array values in descending order?
• How do I limit the Hibernate query result?
• How do I store properties as XML file?
• How do I load properties from XML file?
• How do I convert InputStream to String?
• How do I convert string into InputStream?
• How do I determine bean's property type?
• How do I read mapped bean's property value?
• How do I read indexed bean's property value?

• How do I read bean's nested property value?
• How do I read bean's property value?
• How do I find text between two strings?
• How do I check for an empty string?
• How do I get the nearest hour, minute, second of a date?
• How do I format date and time using DateFormatUtils class?
• How do I find items in an array?
• How do I use CompareToBuilder class?
• How do I use ReflectionToStringBuilder class?
• How do I read system property as an integer?