Package edu.pdx.cs.joy.phonebill

Class PhoneBillDAO

java.lang.Object

edu.pdx.cs.joy.phonebill.PhoneBillDAO

public class PhoneBillDAO
extends Object

A Data Access Object (DAO) for persisting PhoneBill instances to a database. This is a simple example to demonstrate basic JDBC operations. Students can expand this to include PhoneCall persistence and more sophisticated query capabilities.

Constructor Summary

Constructors

Constructor	Description
PhoneBillDAO(Connection connection)	Creates a new PhoneBillDAO with the specified database connection.

Method Summary

Modifier and Type	Method	Description
static void	createTable(Connection connection)	Creates the customers table in the database.
PhoneBill	findByCustomer(String customerName)	Finds a PhoneBill by customer name.
static void	main(String[] args)
void	save(PhoneBill bill)	Saves a PhoneBill to the database.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

PhoneBillDAO

public PhoneBillDAO(Connection connection)

Creates a new PhoneBillDAO with the specified database connection.

Parameters:

connection - the database connection to use

Method Details

createTable

public static void createTable(Connection connection)
                        throws SQLException

Creates the customers table in the database.

Parameters:

connection - the database connection to use

Throws:

SQLException - if a database error occurs

save

public void save(PhoneBill bill)
          throws SQLException

Saves a PhoneBill to the database.

Parameters:

bill - the phone bill to save

Throws:

SQLException - if a database error occurs

findByCustomer

public PhoneBill findByCustomer(String customerName)
                         throws SQLException

Finds a PhoneBill by customer name.

Parameters:

customerName - the customer name to search for

Returns:

the PhoneBill for the customer, or null if not found

Throws:

SQLException - if a database error occurs

main

public static void main(String[] args)
                 throws SQLException

Throws:

SQLException