tempinitial.java

来自「旅游自助系统」· Java 代码 · 共 43 行

/**
 * 
 */
package org.tshs;

import java.io.InputStream;
import java.sql.SQLException;
import java.util.Vector;

import org.tshs.core.CfgManager;
import org.tshs.storage.rdbms.DbManager;

/**
 * @author Administrator
 *
 */
public class TempInitial {

	/**
	 * @param args
	 * @throws SQLException 
	 */
	public static void main(String[] args) throws SQLException {
		Vector<String> vector = new Vector<String>();
		/*
		vector.add("insert into sightspot values('1000', '香山', '北京', '/upload/1000.jpg', '香山是个好地方。');");
		vector.add("insert into client(id, name, password, email, address, sex) values('1000000', 'liuyi', 'liuyi', '[e-mail]', 'beijing', '1');");
		vector.add("insert into travelcorp(id, name, password, email, address, description) values('10000', '超市发', 'chaoshifa', '[e-mail]', '北京', '哈哈');");
		vector.add("insert into traveldept(id, name, password, email, address, description) values('1', 'lvyouju', 'lvyouju', '[e-mail]', 'BJ', 'hehe');");
		vector.add("insert into sightspot(id, name, address, description) values('1001', 'xiangshan', 'beijing', 'haha');");
		vector.add("insert into travelgroup(id, name, capacity, total, start, description, corpId) values('100000', 'group', '10', '0', '2006-12-30 00:00:00', '^_^', '10001');");
		vector.add("insert into travelcorp(id, name, password, email, address, description) values('10001', '111', '111', '[e-mail]', '111', '111');");
		vector.add("insert into sightspot2group values(1000, 100000);");
		vector.add("insert into group2client values('1000000', '100000');");
		*/
		vector.add("insert into traveldept(id, name, password, email, address, description) values('1', 'lvyouju', 'admin', '[e-mail]', '', '');");
		for(String sql: vector){
			DbManager.excute(sql);
		}
	}

}