Welcome

Anti Essays offers essay examples to help students with their essay writing.

Sign Up

Java Database Query Essay

Open Document

Below is an essay on "Java Database Query" from Anti Essays, your source for research papers, essays, and term paper examples.

Java Paper
Karate member dates
1.
Purpose:   display all the members who joined before the selected date

Input:       Database Karate.mdb, Selected Date
Process:   Connect to database, using SQL statement display the members who joined before the selected date
Output:     Show in DataGridView control the result
2.

3.

Control Type Control Name Property Property Value  
Form Default Name: Form1 Text Karate Members  
Label Default Text Select a date  
Label Default Text Members who joined before this date  
DateTimePicker dtpPickDate Value Present day and time  
DataGridView dtgMembers Text Initially display all the members who joined before default date
 
Method Description  
Form1_Load Initialing the form with default values  
dtpPickDate_ValueChanged Change the DataViewGrid control items when DateTimePicker Value changed

Pseudocode:
Connect to the database
Using sql statement:
SELECT ID, Last_Name, First_Name, Phone, Date_Joined FROM Members
Where Members.Date_Joined < ?
ORDER BY Last_Name
get all members joined before the “some date - ?”
Paste   “?   = the date user” picked in fill function
Display results
Code:
Public Class Form1

    Private Sub MembersBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MembersBindingNavigatorSaveItem.Click
        Me.Validate() 'validate input when adding a row
        Me.MembersBindingSource.EndEdit()
        Me.MembersTableAdapter.Update(Me.KarateDataSet.Members) ' update all changes to db

    End Sub

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'fill the grid with sql statement when the form loads
        Me.MembersTableAdapter.Fill(Me.KarateDataSet.Members, dtpPickDate.Text.ToString)

    End Sub

    Private Sub dtpPickDate_ValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dtpPickDate.ValueChanged...

Show More


Citations

MLA Citation

"Java Database Query". Anti Essays. 17 Dec. 2018

<http://parimatch-stavka7.com/free-essays/Java-Database-Query-759617.html>

APA Citation

Java Database Query. Anti Essays. Retrieved December 17, 2018, from the World Wide Web: http://parimatch-stavka7.com/free-essays/Java-Database-Query-759617.html


Jin-hee Ji | Advertisement Analysis Essay | Selengkapnya