Navigation

Changeset 16258

Timestamp:

2008-07-01 15:39:13 (5 months ago)

Author:

xiao

Message:

Files:

r15948	r16258
39	39	String key = (String)ite.next();
40	40	Object value = arow.get(key);
41		logger.info(key + "=>" +value);
	41	//logger.info(key + "=>" +value);
42	42	if (value == null \|\| value.equals("")) continue;
43	43	info.addInfo(key.toLowerCase(),sqlState.undoDBSafe(value));
…	…
58	58	public boolean openConnection(String databasepath){
59	59	connection = sqlServer.connect(databasepath);
	60
60	61	if (connection == null) return false;
61	62
62	63	try{
	64	connection.setAutoCommit(false);
63	65	statement = connection.createStatement();
64	66	}
…	…
73	75	public ArrayList executeQuery(String query_statement){
74	76	//the database hasn't been correct yet
75		if (statement == null){
76		logger.info("the database hasn't been correct yet");
77		return new ArrayList();
78		}
	77	try{
	78
	79	if (statement == null){
	80	logger.info("the database hasn't been correct yet");
	81	return new ArrayList();
	82	}
79	83
80		ArrayList results = new ArrayList();
	84	ArrayList results = new ArrayList();
81	85
82		~~try{~~
83		ResultSet rs = statement.executeQuery(query_statement);
84		ResultSetMetaData rsmd = rs.getMetaData();
85		int numOfColumns = rsmd.getColumnCount();
86		while(rs.next()){
	86
	87	ResultSet rs = statement.executeQuery(query_statement);
	88	ResultSetMetaData rsmd = rs.getMetaData();
	89	int numOfColumns = rsmd.getColumnCount();
	90	while(rs.next()){
87	91	HashMap arow = new HashMap();
88	92	for(int i = 1; i <= numOfColumns ; i++){