java实验项目用户转账_转账类.java · acrowise/银行账户资金管理系统 - Gitee.com

//6.转账类

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.SQLException;

import keshe.Lianjie;

import test.quzhi;

public class Transfer{

private Connection dbConn = Lianjie.getSQL();

private PreparedStatement ps = null;

private PreparedStatement pd = null;

public Transfer() {

initComponents();

}

try {

// System.out.println(str);

ps = dbConn.prepareStatement("Update Bank_User set money=money+? WHERE userName = ?" );

ps.setObject(1,str);

ps.setObject(2,this.username.getText());

pd = dbConn.prepareStatement("Update Bank_User set money=money-? WHERE userName = ?" );

pd.setObject(1,str);

pd.setObject(2,quzhi.ch2);

//ps.setObject(2,pwd.getPwd());

int row &#