param.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;

/**
 * @author itsuser
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public final class Param {
    
    static public final int MoneyOfReg=10000;
	
	static public final String JDBCDriver = "com.mysql.jdbc.Driver";
	static public final String JDBCUrl = "jdbc:mysql://localhost/stock?user=root&password=208436&useUnicode=true&characterEncoding=GB2312";
	static public final String SQLGetName = "SELECT nametbl.name FROM nametbl WHERE nametbl.id = ?";
	static public final String SQLGetNameList = "SELECT name FROM nametbl";
	static public final String SQLGetCourseList = "SELECT course FROM coursetbl";
	static public final String SQLGetId = "SELECT nametbl.id FROM nametbl WHERE nametbl.name = ?";
	static public final String SQLGetScoreById = "SELECT coursetbl.course,coursetbl.score FROM coursetbl WHERE coursetbl.id = ?";
	static public final String SQLGetScoreByName = "SELECT nametbl.name,coursetbl.course,coursetbl.score FROM nametbl INNER JOIN coursetbl ON nametbl.id = coursetbl.id WHERE nametbl.name = ?";
	static public final String SQLGetScoreByCourse = "SELECT nametbl.id,nametbl.name,coursetbl.score FROM nametbl INNER JOIN coursetbl ON nametbl.id = coursetbl.id WHERE coursetbl.course = ?";
}