写一个转账的方法，根据传入的转出账户、转入账户和金额，修改表中账户的金额

package com.account.jdbc;

import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;
import java.util.Scanner;

import javax.xml.soap.SAAJResult;
/**
 * 写一个转账的方法，根据传入的转出账户、转入账户和金额，修改表中账户的金额
 * @author Administrator
 *
 */
public class Account {

	public static void main(String[] args) {
		Properties prop = new Properties();	
		Scanner sc = new Scanner(System.in);
		
		System.out.println("请输入转出账户：");
		String roolout = sc.nextLine();
		System.out.println("请输入转入账户：");
		String roolin = sc.nextLine();
		System.out.println("请输入金额：");
		long price = sc.nextInt();	
		
		try {
			prop.load(new FileInputStream("config\\db.properties"));
			
			Class.forName(prop.getProperty("driver"));
			String user = prop.getProperty("username");
			String password = prop.getProperty("password");
			String url = prop.getProperty("url");			
			Connection conn = DriverManager.getConnection(url, user, password);
			
			String sql = "update account set money =? where aname=?";
			PreparedStatement ps = conn.prepareStatement(sql);
			
			String sqlstr = "select aname,money from account where aname =?";
			PreparedStatement pst = conn.prepareStatement(sqlstr);
			pst.setString(1, roolin);
			ResultSet rs = pst.executeQuery();
			
			PreparedStatement pst2 = conn.prepareStatement(sqlstr);
			pst2.setString(1, roolout);
			ResultSet rs2 = pst2.executeQuery();
				if(rs2.next()) {	
					if(rs2.getLong("money") > price) {
						conn.setAutoCommit(false);
						ps.setLong(1, rs2.getLong("money")-price);
						ps.setString(2, roolout);
						if(rs.next()) {
							ps.setLong(1, rs.getLong("money")+price);
							ps.setString(2, roolin);
						}else {
							System.out.println("转入的账户不存在");
							return;
						}
						ps.executeUpdate();
						conn.commit(); //手动提交
						conn.setAutoCommit(true); //恢复自动提交
						System.out.println("转账成功!");
					}else {
						System.out.println("转出金额过大！无法操作！");
						return;
					}
				}else {
					System.out.println("转出的账户不存在");
				}
			rs.close();
			rs2.close();
			ps.close();	
			conn.close();		
		}catch (Exception e) {
			e.printStackTrace();
		}

	}

}

切记，转账的过程中转出的金额减少，转入的金额增多，数据库中两个字段发生变化。数据库表省略