JDBC 1:




_____________________________________________________________________
public class ItemType{
    
    Long id;
    String name;
    Double deposit;
    Double costPerDay;
    
    ItemType(){ }
    ItemType(Long id, String name, Double deposit, Double costPerDay){        
this.id = id;
this.name = name;
this.deposit = deposit;
this.costPerDay = costPerDay;    
    }
    
    public String getName() {
    return name;
    }

    public void setName(String name) {
    this.name = name;
    }
    
    
    public Double getDeposit() {
    return deposit;
    }

    public void setDeposit(Double deposit) {
    this.deposit = deposit;
    }
    
    public Long getId() {
    return id;
    }

    public void setId(Long id) {
    this.id = id;
    }
    
    public Double getCostPerDay() {
    return costPerDay;
    }

    public void setCostPerDay(Double costPerDay) {
    this.costPerDay = costPerDay;
    }
    
}
_________________________________________________________________

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.ResourceBundle;

public class DBConnection {
public static Connection getConnection() throws SQLException {        
        ResourceBundle rb = ResourceBundle.getBundle("oracle");
        String url = rb.getString("db.url");
        String username = rb.getString("db.username");
        String password = rb.getString("db.password");
        
        Connection conn = DriverManager.getConnection(url,username,password);
        return conn;
    }
}
_____________________________________________________________________
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
public class ItemTypeDAO {
public List<ItemType> getAllItemTypes() throws SQLException {
List<ItemType> itemTypeList = new ArrayList<>();
        Connection conn = DBConnection.getConnection();
        Statement stmt = conn.createStatement();
        String query = "select * from item_type";
        ResultSet rs = stmt.executeQuery(query);
        
        while(rs.next()){
            long id = rs.getLong(1);
            String name = rs.getString(2);
            double deposit = rs.getDouble(3);
            double costPerDay = rs.getDouble(4);
            
            ItemType it = new ItemType(id,name,deposit,costPerDay);
            itemTypeList.add(it);
            it=null;
        }
        return itemTypeList;
            
}
}
_______________________________________________________________________
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public class Main {
public static void main(String[] args) throws SQLException {
    ItemTypeDAO dao = new ItemTypeDAO();
        
        List<ItemType> itemList = new ArrayList<>();
        itemList=dao.getAllItemTypes();
        
        System.out.format("%-5s %-15s %-10s %s\n","ID","Name","Deposit","Cost per day");
        for(ItemType it:itemList){
            
             System.out.format("%-5s %-15s %-10s %s\n",it.getId(),it.getName(),it.getDeposit(),it.getCostPerDay());
        }
}
}



Comments

Post a Comment

Popular posts from this blog

  Primitive Wrappers | java.lang | java.util CUSTOMER ADDRESS USING STRING BUILDER Sample Input & Output: Enter Address Details : Enter Line 1 : 152, South Block Enter Line 2 : Raisina Hill Enter City : New Delhi Enter Country : India Enter Zip Code : 110011 Address Details : 152, South Block, Raisina Hill, New Delhi - 110011 India CODE: // fill your code here public class Address {      private String line1; private String line2; private String city; private String country; private int zipCode; public String getLine1() { return line1; } public void setLine1(String line1) { this.line1 = line1; } public String getLine2() { return line2; } public void setLine2(String line2) { this.line2 = line2; } public String getCity() { return city; } public void setCity(String city) { this.city = city; } public String getCountry() { return country; } public void setCountry(String country) { this.country = country...
Read more
Collections: ARRAYLIST - INTRODUCTION Sample Input and Output 1: Enter the username 1 John Do you want to continue?(y/n) y Enter the username 2 Joe Do you want to continue?(y/n) n The Names entered are: John Joe CODE: import java.util.ArrayList; import java.util.Scanner; public class Main {     public static void main(String args[]) { String user; Scanner sc = new Scanner(System.in); ArrayList<String> al = new ArrayList<String>(); int i = 1; do { System.out.println("Enter the username "+i); al.add(sc.nextLine()); System.out.println("Do you want to continue?(y/n)"); user = sc.nextLine(); i++; }while(user.equalsIgnoreCase("y")); System.out.println("The Names entered are:"); for(String a:al) { System.out.println(a); } } }
Read more
Collections: TREEMAP To assist Event organizers, you need to develop a console application that shows the number of tickets sold in a particular price category. Sample Input and Output : [All Texts in bold corresponds to the input and rest are output] Enter the number of events: 3 Enter event details in CSV(Customer Name,Ticket Price,No of Seats Booked) Emily ,100,5 Natalie ,200,10 Grace ,100,3 Ticket Price    Tickets Booked 100                 8 200                 10 CODE: //package com.mycom.collections.map; import java.util.Scanner; import java.util.Set; import java.util.TreeMap; public class Main {     public static void main(String[] args) { Scanner sc = new Scanner(System.in); System.out.println("Enter the number of events:"); int num = Integer.parseInt(sc.nextLine()); TreeMap<I...
Read more