Question

Access Gallery Database Using a High-Level Language Acceptable Languages: C or any version (C++,C#, etc.) PHP XML Java Python Write an application that allows a user to: Print records from the DB Access any record based on attribute values Sort a report Program may use either dynamic or static sql, but static is preferred. Submit your program source and object code and a printout of it in

Answer 1

Please read given instructions in code carefully

package com.example.poc;

import java.sql.*;

public class SampleDb {

public SampleDb() {

// TODO Auto-generated constructor stub

}

// Assuming you have mysql installed on your system

// Create database name it gallery

// Create table gallery_table having attributes id and value both are integer

// (change as per your convenience make code change also);

public static void main(String args[]) {

try (Connection connection = createConnection();) {

SampleDb sampleDb = new SampleDb();

sampleDb.diplayAllRecords(connection);

// change input id value as per your requirement

Integer id = 2;

sampleDb.displaySpecificRecord(connection, id);

} catch (Exception e) {

System.out.println(e);

}

}

private void displaySpecificRecord(Connection connection, Integer id) throws SQLException {

Statement stmt = connection.createStatement();

// gallery table is sql tablename

ResultSet rs = stmt.executeQuery("select * from gallery_table where id=" + id + ";");

if (rs.isBeforeFirst()) {

while (rs.next()) {

System.out.println(rs.getInt("id") + " " + rs.getInt("value"));

}

} else {

System.out.println("Record not found for provide attribute");

}

}

private void diplayAllRecords(Connection connection) throws SQLException {

Statement stmt = connection.createStatement();

// gallery table is sql tablename

ResultSet rs = stmt.executeQuery("select * from gallery_table;");

if (rs.isBeforeFirst()) {

while (rs.next()) {

System.out.println(rs.getInt("id") + " " + rs.getInt("value"));

}

} else {

System.out.println("Nothing to print");

}

}

private static Connection createConnection() {

// Running on java 8

// for class not found exception put mysql-connector-java-5.0.8-bin.jar as

// external library

try {

Class.forName("com.mysql.jdbc.Driver");

// TODO put your database name instead of gallery and user-name password

Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/gallery", "root", "root");

return con;

} catch (ClassNotFoundException | SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return null;

}

}