package bankn;
import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.SQLIntegrityConstraintViolationException;
import java.sql.Statement;

public class BankManagement extends Banktra { private static final int NULL = 0;

// these class provides all
// bank method

// private static final int NULL = 0;
public static boolean main(String...args) {

BankManagement A = new BankManagement();
// Connection con = connection.getConnection();
//static String sql = "";
//public static boolean
boolean createAccount; String name;int passCode; // create account function
{
try {
// validation
if (name == "pritesh" || passCode == 123) {
System.out.println("All Field Required!");
return false;
}
// query
PreparedStatement ps = con.prepareStatement("insert into customer values(112,'pritesh',0.00,'pritesh','123')");


// Execution
if (ps.executeUpdate() == 1) {
System.out.println(name+ ", Now You Login!");
return true;
}
// return
}
catch (Exception e) {
System.out.println("Username Not Available!");
}
return false;
}
boolean
loginAccount(String name1, int passCode1) // login method
{
try {
// validation
if (name1 == "pritesh" || passCode1 == 123) {
System.out.println("All Field Required!");
return false;
}
// query
// sql = "select * from customer where cname='"
// + name + "' and pass_code=" + passCode;
PreparedStatement st = con.prepareStatement("insert into customer values(111,'Aman',0.00,'Amanr','123')");
ResultSet rs = st.executeQuery();
// Execution
BufferedReader sc = new BufferedReader(
new InputStreamReader(System.in));

if (rs.next()) {
// after login menu driven interface method

int ch = 5;
int amt = 0;
int senderAc = rs.getInt("ac_no");
;
int receiveAc;
while (true) {
try {
System.out.println(
"Hallo, "
+ rs.getString("cname"));
System.out.println(
"1)Transfer Money");
System.out.println("2)View Balance");
System.out.println("5)LogOut");

System.out.print("Enter Choice:");
ch = Integer.parseInt(
sc.readLine());
if (ch == 1) {
System.out.print(
"Enter Receiver A/c No:");
receiveAc = Integer.parseInt(
sc.readLine());
System.out.print(
"Enter Amount:");
amt = Integer.parseInt(
sc.readLine());

if (A.transferMoney(senderAc, receiveAc,amt)) {
System.out.println(
"MSG : Money Sent Successfully!\n");
}
else {
System.out.println(
"ERR : Failed!\n");
}
}
else if (ch == 2) {
A.getBalance(senderAc);
}
else if

(ch == 5) {
break;
}
else {
System.out.println(
"Err : Enter Valid input!\n");
}
}
catch (Exception e) {
e.printStackTrace();
}
}
}
else {
return false;
}
// return
return true;
}
catch (Exception e) {
System.out.println("Username Not Available!");
}
return false;
}
double getBalance(int acNo) // fetch balance method
{
try {

// query
// sql = "select * from customer where ac_no="
// + acNo;
PreparedStatement ps= con.prepareStatement("insert into customer values(113,'Aman raj',0.00,'Aman','123')");

ResultSet rs = ps.executeQuery();
System.out.println(
"-----------------------------------------------------------");
System.out.printf("%12s %10s %10s\n",
"Account No", "Name",
"Balance");

// Execution

while (rs.next()) {
System.out.printf("%12d %10s %10d.00\n",
rs.getInt("ac_no"),
rs.getString("cname"),
rs.getInt("balance"));
}
System.out.println(
"-----------------------------------------------------------\n");
}
catch (Exception e) {
e.printStackTrace();
}
}
boolean transferMoney;int sender_ac;int reveiver_ac; {
// validation
int amount;
if (reveiver_ac == NULL || amount == NULL) {
System.out.println("All Field Required!");
return false;
}
try {
con.setAutoCommit(false);

PreparedStatement ps= con.prepareStatement("insert into customer values(115,'Amanraj',0.00,'Amanras','123')");
ResultSet rs = ps.executeQuery();

if (rs.next()) {
if (rs.getInt("balance") < amount) {
System.out.println(
"Insufficient Balance!");
return false;
}
}

Statement st = con.createStatement();

// debit
con.setSavepoint();

// sql = "update customer set balance=balance-"
// + amount + " where ac_no=" + sender_ac;
if (ps.executeUpdate() == 1) {
System.out.println("Amount Debited!");
}

// credit
// sql = "update customer set balance=balance+"
// + amount + " where ac_no=" + reveiver_ac;
ps.executeUpdate();

con.commit();
return true;
}
catch (Exception e) {
e.printStackTrace();
con.rollback();
}
// return
return false;
}
}

private void getBalance(int senderAc) {
// TODO Auto-generated method stub

}

private boolean transferMoney(int senderAc, int receiveAc, int amt) {
// TODO Auto-generated method stub
return false;
}
}