📄 encodeconnection.java
字号:
package mapcenter.service;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.SQLException;
import java.sql.PreparedStatement;
import java.sql.CallableStatement;
import java.sql.DatabaseMetaData;
import java.sql.SQLWarning;
import java.util.Map;
import java.sql.Savepoint;
import java.io.UnsupportedEncodingException;
/**
* <p>Title: </p>
* <p>Description: 该类没有对CallableStatement进行封装</p>
* <p>Copyright: Copyright (c) 2006</p>
* <p>Company: 亚奥数码</p>
* @author wei
* @version 1.0
*/
public class EncodeConnection implements Connection {
private Connection connection;
private String OrigCharSet, TargCharSet;
private static Log log = LogFactory.getLog("WebGIS");
public EncodeConnection(Connection connection, String OrigCharSet, String TargCharSet) {
this.connection = connection;
this.OrigCharSet = OrigCharSet;
this.TargCharSet = TargCharSet;
}
//================== 返回EncodeStatement ===========================
public Statement createStatement() throws java.sql.SQLException {
return new EncodeStatement(connection.createStatement(),OrigCharSet,TargCharSet);
}
//================ 对参数进行预编码,再对返回结果用EncodeXXX代替 ====================
public PreparedStatement prepareStatement(String parm1) throws java.sql.SQLException {
try{
parm1 = new String(parm1.getBytes(TargCharSet),OrigCharSet);
}catch(UnsupportedEncodingException e){
log.error(e.getMessage());
}
return new EncodePreparedStatement(connection.prepareStatement(parm1), OrigCharSet,TargCharSet);
}
public CallableStatement prepareCall(String parm1) throws java.sql.SQLException {
return connection.prepareCall(parm1);
}
public String nativeSQL(String parm1) throws java.sql.SQLException {
return connection.nativeSQL(parm1);
}
public void setAutoCommit(boolean parm1) throws java.sql.SQLException {
connection.setAutoCommit(parm1);
}
public boolean getAutoCommit() throws java.sql.SQLException {
return connection.getAutoCommit();
}
public void commit() throws java.sql.SQLException {
connection.commit();
}
public void rollback() throws java.sql.SQLException {
connection.rollback();
}
public void close() throws java.sql.SQLException {
connection.close();
}
public boolean isClosed() throws java.sql.SQLException {
return connection.isClosed();
}
public DatabaseMetaData getMetaData() throws java.sql.SQLException {
return connection.getMetaData();
}
public void setReadOnly(boolean parm1) throws java.sql.SQLException {
connection.setReadOnly(parm1);
}
public boolean isReadOnly() throws java.sql.SQLException {
return connection.isReadOnly();
}
public void setCatalog(String parm1) throws java.sql.SQLException {
try{
parm1 = new String(parm1.getBytes(TargCharSet),OrigCharSet);
connection.setCatalog(parm1);
}catch(UnsupportedEncodingException e){
log.error(e.getMessage());
}
}
public String getCatalog() throws java.sql.SQLException {
String returnValue = null;
try{
returnValue = new String(connection.getCatalog().getBytes(OrigCharSet), TargCharSet);
}catch(UnsupportedEncodingException e){
log.error(e.getMessage());
}
return returnValue;
}
public void setTransactionIsolation(int parm1) throws java.sql.SQLException {
connection.setTransactionIsolation(parm1);
}
public int getTransactionIsolation() throws java.sql.SQLException {
return connection.getTransactionIsolation();
}
public SQLWarning getWarnings() throws java.sql.SQLException {
return connection.getWarnings();
}
public void clearWarnings() throws java.sql.SQLException {
connection.clearWarnings();
}
public Statement createStatement(int parm1, int parm2) throws java.sql.SQLException {
return new EncodeStatement(connection.createStatement(parm1,parm2),OrigCharSet,TargCharSet);
}
public PreparedStatement prepareStatement(String parm1, int parm2, int parm3) throws java.sql.SQLException {
try{
parm1 = new String(parm1.getBytes(TargCharSet),OrigCharSet);
}catch(UnsupportedEncodingException e){
log.error(e.getMessage());
}
return new EncodePreparedStatement(connection.prepareStatement(parm1,parm2,parm3),OrigCharSet,TargCharSet);
}
public CallableStatement prepareCall(String parm1, int parm2, int parm3) throws java.sql.SQLException {
return connection.prepareCall(parm1,parm2,parm3);
}
public Map getTypeMap() throws java.sql.SQLException {
return connection.getTypeMap();
}
public void setTypeMap(Map parm1) throws java.sql.SQLException {
connection.setTypeMap(parm1);
}
public void setHoldability(int parm1) throws java.sql.SQLException {
connection.setHoldability(parm1);
}
public int getHoldability() throws java.sql.SQLException {
return connection.getHoldability();
}
public Savepoint setSavepoint() throws java.sql.SQLException {
return connection.setSavepoint();
}
public Savepoint setSavepoint(String parm1) throws java.sql.SQLException {
return connection.setSavepoint(parm1);
}
public void rollback(Savepoint parm1) throws java.sql.SQLException {
connection.rollback(parm1);
}
public void releaseSavepoint(Savepoint parm1) throws java.sql.SQLException {
connection.releaseSavepoint(parm1);
}
public Statement createStatement(int parm1, int parm2, int parm3) throws java.sql.SQLException {
return new EncodeStatement(connection.createStatement(parm1,parm2,parm3),OrigCharSet,TargCharSet);
}
public PreparedStatement prepareStatement(String parm1, int parm2, int parm3, int parm4) throws java.sql.SQLException {
try{
parm1 = new String(parm1.getBytes(TargCharSet),OrigCharSet);
}catch(UnsupportedEncodingException e){
log.error(e.getMessage());
}
return new EncodePreparedStatement(connection.prepareStatement(parm1,parm2,parm3,parm4),OrigCharSet,TargCharSet);
}
public CallableStatement prepareCall(String parm1, int parm2, int parm3, int parm4) throws java.sql.SQLException {
return connection.prepareCall(parm1,parm2,parm3,parm4);
}
public PreparedStatement prepareStatement(String parm1, int parm2) throws java.sql.SQLException {
try{
parm1 = new String(parm1.getBytes(TargCharSet),OrigCharSet);
}catch(UnsupportedEncodingException e){
log.error(e.getMessage());
}
return new EncodePreparedStatement(connection.prepareStatement(parm1,parm2),OrigCharSet,TargCharSet);
}
public PreparedStatement prepareStatement(String parm1, int[] parm2) throws java.sql.SQLException {
try{
parm1 = new String(parm1.getBytes(TargCharSet),OrigCharSet);
}catch(UnsupportedEncodingException e){
log.error(e.getMessage());
}
return new EncodePreparedStatement(connection.prepareStatement(parm1,parm2),OrigCharSet,TargCharSet);
}
public PreparedStatement prepareStatement(String parm1, String[] parm2) throws java.sql.SQLException {
try{
parm1 = new String(parm1.getBytes(TargCharSet),OrigCharSet);
for(int i=0; i<parm2.length; i++){
parm2[i] = new String(parm2[i].getBytes(TargCharSet),OrigCharSet);
}
}catch(UnsupportedEncodingException e){
log.error(e.getMessage());
}
return new EncodePreparedStatement(connection.prepareStatement(parm1,parm2),OrigCharSet,TargCharSet);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -