السلام عليكــم ورحمـة الله وبركاتــة
حاليا اقوم بعمل برنامج الصراف الالي بسيط واجهتنى مشكله اثنا ء القيام بانشاء الداله او الاكشن الخاص بعمليه السحب والاضافه Withdraw and deposit هي كود السحب ما بعرف شو الغلط في الداله مع انو في Complie ما بيعطي مشاكل بس لما اجي اعمل عمليه السحب ما بيرضي :
private void WithdrawButtonActionPerformed(java.awt.event.ActionEvent evt) {
try{
String value = JOptionPane.showInputDialog("Enter Amount:");
int newValue = Integer.parseInt(value);
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver");
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/bank");
Statement stmt = connection.createStatement();
ResultSet resultSet = stmt.executeQuery(
"SELECT balance FROM banktest WHERE id = '" + AccountNumber.getText() + "'");
StringBuffer results = new StringBuffer();
ResultSetMetaData metaData = resultSet.getMetaData();
int numberOfColumns = metaData.getColumnCount();
while ( resultSet.next() ) {
for ( int i = 1; i <= numberOfColumns; i++ ) {
results.append( resultSet.getObject( i ));
}
}
String current_balance1 = results.toString();
int balance = Integer.parseInt(current_balance1);
if(balance > newValue){
int answer = balance - newValue;
String updateString = "UPDATE banktest " +
"SET Balance = "+ answer + " " +
"WHERE id LIKE '" + AccountNumber.getText() + "'";
JOptionPane.showMessageDialog(null,"Data Entered into Database Successfully");
stmt.executeUpdate(updateString);
stmt.close();
connection.close();
}
else{
JOptionPane.showMessageDialog(null,"Error in Amount Entering");
}
}
catch ( SQLException sqlException ) {
JOptionPane.showMessageDialog( null,
sqlException.getMessage(), "Database Error",
JOptionPane.ERROR_MESSAGE );
System.exit( 1 );
}
catch ( ClassNotFoundException classNotFound ) {
JOptionPane.showMessageDialog( null,
classNotFound.getMessage(), "Driver Not Found",
JOptionPane.ERROR_MESSAGE );
System.exit( 1 );
}
}
