package myapp;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class JDBCTest {
	
	private static String dbURL = "jdbc:derby:c:\\SupalDB;create=true;dataEncryption=true;bootPassword=clo760uds2caPe;encryptionProvider=com.ibm.j9.jce.provider.J9JCEProvider;encryptionAlgorithm=DES/CBC/NoPadding";
//	private static String dbURL = "jdbc:derby:c:\\SupalDB;create=true;dataEncryption=true;bootPassword=clo760uds2caPe;encryptionProvider=org.bouncycastle.jce.provider.BouncyCastleProvider";


	// jdbc Connection
	private static Connection conn = null;

	private static Statement stmt = null;

	public static void main(String[] args) {
		createConnection();
		shutdown();
	}

	private static void createConnection() {
		try {
			Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();
			conn = DriverManager.getConnection(dbURL);
			
		} catch (SQLException except) {
			except.printStackTrace();
			except.getNextException().printStackTrace();
			except.getNextException().getNextException().printStackTrace();
		} catch (Exception except) {
			except.printStackTrace();
		}
	}
	private static void shutdown() {
		try {
			if (stmt != null) {
				stmt.close();
			}
			if (conn != null) {
				DriverManager.getConnection(dbURL + ";shutdown=true");
				conn.close();
			}
		} catch (SQLException sqlExcept) {

		}

	}
}