paramzjgp1.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.zjgp1;

/**
 * @author itsuser
 * 
 * TODO To change the template for this generated type comment go to Window -
 * Preferences - Java - Code Style - Code Templates
 */
public final class ParamZjgp1 {

	static public final String SQLGetResCash = "SELECT cashCanUsed,sumOfWth,numOfDone,incOfDay,incOfWeek,inc,dayOfReg FROM customer_info where userName=?";

	static public final String SQLGetResStk = "SELECT stockOwner_info.stkID,stock_info.stkName,stockOwner_info.stkSumNum,stockOwner_info.stkCanUsed,stockOwner_info.priBuyIn,stockOwner_info.priSelNow,stockOwner_info.numGetLos,stock_info.pri,stockOwner_info.priStpLos,stockOwner_info.stkState "
			+ "FROM stockOwner_info INNER JOIN stock_info ON stockOwner_info.stkID = stock_info.stkID where stockOwner_info.userName=?";
}