org.docshare.orm.StatementPool Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of yangmvc Show documentation

An efficient, fast, convenient, easy to learn, easy to use MVC framework and ORM framework. It is seamless compatible with JSTL and supports FreeMarker. It can run independently, and it can also be applied to traditional Java Web projects. It is an efficient, fast, convenient, easy to learn and easy to use MVC framework and ORM framework. It is seamless compatible with JSTL and supports FreeMarker. It can be run on its own, or it can be applied to traditional Java Web projects

There is a newer version: 2023.06.19

Show newest version

package org.docshare.orm;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.HashMap;

import org.docshare.log.Log;




/**
 * 语句池
 * @author HP
 *
 */
public class StatementPool {
	
	HashMap cache = new HashMap<>();
	public PreparedStatement get(Connection con,String sql) throws SQLException{
		PreparedStatement p ;
		if(cache.containsKey(sql)) {
			Log.v("StatementPool: return cached PreparedStatement" );
			p=cache.get(sql);
			//p.clearParameters();
		}
		else{
			p=con.prepareStatement(sql,Statement.RETURN_GENERATED_KEYS);
			cache.put(sql, p);
		}
		return p;
	}
	public void clear(){
		cache.clear();
	}

}