/*
* Copyright (c) 2012, Codename One and/or its affiliates. All rights reserved.
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
* This code is free software; you can redistribute it and/or modify it
* under the terms of the GNU General Public License version 2 only, as
* published by the Free Software Foundation. Codename One designates this
* particular file as subject to the "Classpath" exception as provided
* by Oracle in the LICENSE file that accompanied this code.
*
* This code is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
* FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License
* version 2 for more details (a copy is included in the LICENSE file that
* accompanied this code).
*
* You should have received a copy of the GNU General Public License version
* 2 along with this work; if not, write to the Free Software Foundation,
* Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA.
*
* Please contact Codename One through http://www.codenameone.com/ if you
* need additional information or have any questions.
*/
package com.codename1.impl.javase;
import com.codename1.db.Cursor;
import com.codename1.db.Database;
import java.io.IOException;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
*
* @author Chen
*/
public class SEDatabase extends Database{
private java.sql.Connection conn;
public SEDatabase(java.sql.Connection conn) {
this.conn = conn;
try {
conn.setAutoCommit(true);
} catch(SQLException err) {}
}
@Override
public void beginTransaction() throws IOException {
System.out.println("**** Database.beginTransaction() is not supported in the Javascript port. If you plan to deploy to Javascript, you should avoid this method. *****");
try {
conn.setAutoCommit(false);
} catch (SQLException ex) {
ex.printStackTrace();
throw new IOException(ex.getMessage());
}
}
@Override
public void commitTransaction() throws IOException {
System.out.println("**** Database.commitTransaction() is not supported in the Javascript port. If you plan to deploy to Javascript, you should avoid this method. *****");
try {
conn.commit();
conn.setAutoCommit(true);
} catch (SQLException ex) {
ex.printStackTrace();
throw new IOException(ex.getMessage());
}
}
@Override
protected void finalize() throws Throwable {
if(conn != null) {
System.out.println("**** WARNING! Database object was released by the GC without being closed first! This might cause crashes on iOS *****");
}
}
@Override
public void close() throws IOException {
try {
conn.close();
conn = null;
} catch (SQLException ex) {
ex.printStackTrace();
throw new IOException(ex.getMessage());
}
}
private void cleanup(PreparedStatement ps) {
try {
if(ps != null) {
ps.close();
}
} catch (SQLException ex) {
}
}
@Override
public void execute(String sql) throws IOException {
PreparedStatement s = null;
try {
s = conn.prepareStatement(sql);
s.execute();
} catch (SQLException ex) {
ex.printStackTrace();
throw new IOException(ex.getMessage());
} finally {
cleanup(s);
}
}
@Override
public void execute(String sql, String[] params) throws IOException {
PreparedStatement s = null;
try {
s = conn.prepareStatement(sql);
if(params != null){
for (int i = 0; i < params.length; i++) {
String param = params[i];
s.setString(i+1, param);
}
}
s.execute();
} catch (SQLException ex) {
ex.printStackTrace();
cleanup(s);
throw new IOException(ex.getMessage());
}
}
@Override
public void execute(String sql, Object... params) throws IOException {
PreparedStatement s = null;
try {
s = conn.prepareStatement(sql);
if(params != null){
for (int i = 0; i < params.length; i++) {
Object p = params[i];
if (p == null) {
s.setNull(i+1, java.sql.Types.NULL);
} else {
if (p instanceof String) {
s.setString(i + 1, (String) p);
} else if (p instanceof byte[]) {
s.setBytes(i + 1, (byte[]) p);
} else if (p instanceof Double) {
s.setDouble(i + 1, ((Double) p).doubleValue());
} else if (p instanceof Long) {
s.setLong(i + 1, ((Long) p).longValue());
} else if (p instanceof Integer) {
s.setInt(i + 1, ((Integer) p).intValue());
} else {
s.setString(i + 1, (String) p.toString());
}
}
}
}
s.execute();
} catch (SQLException ex) {
cleanup(s);
ex.printStackTrace();
throw new IOException(ex.getMessage());
}
}
@Override
public Cursor executeQuery(String sql, String[] params) throws IOException {
PreparedStatement s = null;
try {
s = conn.prepareStatement(sql);
if(params != null){
for (int i = 0; i < params.length; i++) {
String param = params[i];
s.setString(i+1, param);
}
}
ResultSet resultSet = s.executeQuery();
return new SECursor(resultSet);
} catch (SQLException ex) {
cleanup(s);
ex.printStackTrace();
throw new IOException(ex.getMessage());
}
}
@Override
public Cursor executeQuery(String sql) throws IOException {
PreparedStatement s = null;
try {
s = conn.prepareStatement(sql);
ResultSet resultSet = s.executeQuery();
return new SECursor(resultSet);
} catch (SQLException ex) {
cleanup(s);
ex.printStackTrace();
throw new IOException(ex.getMessage());
}
}
@Override
public void rollbackTransaction() throws IOException {
System.out.println("**** Database.rollbackTransaction() is not supported in the Javascript port. If you plan to deploy to Javascript, you should avoid this method. *****");
try {
conn.rollback();
} catch (SQLException ex) {
ex.printStackTrace();
throw new IOException(ex.getMessage());
}
}
}