parambuy.java

structejbmysql开发工程源码

/*
 * Created on 2007/03/05
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package course.sys.buy;

/**
 * @author itsuser
 * 
 * TODO To change the template for this generated type comment go to Window -
 * Preferences - Java - Code Style - Code Templates
 */
public final class ParamBuy {
	
	static public final String SQLGetStkInf = "SELECT pri,priStpDwn,priStpUp FROM stock_info where stkID=?";

	static public final String SQLGetCashCanUsed = "SELECT cashCanUsed FROM customer_info where userName=?";
	static public final String SQLGetStkCanUsed = "SELECT stkCanUsed FROM stockOwner_info where userName=? and stkID=?";
	
	static public final String SQLInsertStkOwnInf = "INSERT INTO stockOwner_info (userName,stkID,stkSumNum,stkCanUsed,priBuyIn,priSelNow,numGetLos,priStpLos,stkState,reason) VALUES (?,?,?,?,?,?,?,?,?,?)";
    static public final String SQLUpDateStkOwnInf ="UPDATE stockOwner_info SET stkSumNum= ?,stkCanUsed=?,priBuyIn=?,priSelNow=?,numGetLos=?,priStpLos=?,stkState=? ,reason=? WHERE userName=? AND stkID=?"; 
    static public final String SQLUpdateUserInf ="UPDATE customer_info SET cashCanUsed=?,sumOfWth=?,numOfDone=?,incOfDay=?,incOfWeek=?,inc=?WHERE userName=?"; 
    static public final String SQLGetCustomer_info ="SELECT cashCanUsed,sumOfWth,numOfDone,incOfDay,incOfWeek,inc,dayOfReg FROM customer_info where userName=?";
    static public final String SQLGetStockOwner_info ="SELECT stkSumNum,stkCanUsed,priBuyIn,priSelNow,numGetLos,priStpLos,stkState,reason FROM stockOwner_info where userName=? AND stkID=?";
	
	

}