Question
need help with this im new to java and how to connect this mysql to java eclipse Using the software installed for this course: Create
need help with this
im new to java
and how to connect this mysql to java eclipse
Using the software installed for this course:
Create following in MySQL database, following table scripts will be part of assignment submission:
Create following tables called TransactionType , AccountType, Accounts and Transaction. All the id fields are primary keys
TransactionType ( String: TranTypeId, String : TransactionDesc) Values (A:Authorization,C:Credit,P:Payment)
AccountType( int : AcctTypeId, String : AccountTypeDesc ) Values (10:Single, 20:Joint, 30:Minor)
Accounts ( int : AccountId, int : AcctTypeId, int : Balance ) Values ( 100, 10, 3000), ( 200, 20, 1000), ( 300, 30, 5000), ( 400, 10, 3000)
Transaction ( int : TransId, String : TranTypeId, int : AcctIdFrom, int: AcctIdTo, int Amount ) Values (1, A , 100, 200, 100), (1, C , 300, 200, 1000), (1, A , 400, 200, 100)
Eclipse Java Project:
Create Java class files for each tables above to insert, delete and update operations
Validate TransactionType is validated before inserting into Transaction table
Validate AccountType is validated before inserting into Accounts table
Validate TranTypeId, AcctIdFrom and AcctIdTo validated before inserting into Transaction table
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started