Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@cofearabi
cofearabi / Sample.java
Created November 18, 2015 00:18
get folder name from absolute path of a file
import java.io.File;
import java.util.Stack;
import java.util.StringTokenizer;
public class Sample {
/**
* @param args
@cofearabi
cofearabi / DeleteTable.java
Last active November 14, 2015 15:53
java sample code : delete table with jackcess (drop table with jackcess)
import java.io.File;
import java.io.IOException;
import java.util.HashMap;
import java.util.Map;
import com.healthmarketscience.jackcess.Cursor;
import com.healthmarketscience.jackcess.Database;
import com.healthmarketscience.jackcess.DatabaseBuilder;
import com.healthmarketscience.jackcess.Table;
@cofearabi
cofearabi / CreateTable.java
Created November 14, 2015 07:22
creating table with jackcess
import java.io.File;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Collection;
import com.healthmarketscience.jackcess.ColumnBuilder;
import com.healthmarketscience.jackcess.DataType;
import com.healthmarketscience.jackcess.Database;
import com.healthmarketscience.jackcess.DatabaseBuilder;
import com.healthmarketscience.jackcess.Table;
@cofearabi
cofearabi / Database0
Last active November 13, 2015 16:20
jackcess sample for creating database
import java.io.File;
import java.io.IOException;
import java.math.BigDecimal;
import java.sql.SQLException;
import java.sql.Types;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Map;
@cofearabi
cofearabi / AndroidManifest.xml
Created October 28, 2014 23:29
Android application which get the price of the stock written in Excel file
<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
package="com.example.andexcelread"
android:versionCode="1"
android:versionName="1.0" >
<uses-sdk
android:minSdkVersion="8"
android:targetSdkVersion="21" />
@cofearabi
cofearabi / AndroidManifest.xml
Created October 28, 2014 22:12
Android sample appli which read Excel file and display the data of the sheet.
<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
package="com.example.andexcelread0"
android:versionCode="1"
android:versionName="1.0" >
<uses-sdk
android:minSdkVersion="8"
android:targetSdkVersion="21" />
@cofearabi
cofearabi / andAddMdb
Created October 19, 2014 23:51
Android appli sample code which add a field of Access mdb database, needs three edittext fileds and two buttons.
package com.example.andaddmdb;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import android.support.v7.app.ActionBarActivity;
import android.text.SpannableStringBuilder;
import android.os.Bundle;
import android.os.Environment;
@cofearabi
cofearabi / andViewMdb
Created October 19, 2014 23:29
Android Application code referring to Access Database (mdb file)
package com.example.andviewmdb;
import android.support.v7.app.ActionBarActivity;
import android.os.Bundle;
import android.os.Environment;
import android.app.Activity;
import android.view.Menu;
import android.widget.LinearLayout;
@cofearabi
cofearabi / gist:5864873
Created June 26, 2013 04:57
get excel data and put data into access
Private Sub CommandButton1_Click()
Dim int_sheets_no
'int_sheets_no = Int(InputBox("", "", "1"))
int_sheets_no = 1
@cofearabi
cofearabi / MainActivity.java
Created June 23, 2013 17:25
Android sample of Listview
package com.example.listviewsample2;
import android.os.Bundle;
import android.app.Activity;
import android.view.Menu;
import android.view.View;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.ListView;
import android.widget.Toast;