Skip to content

Instantly share code, notes, and snippets.

@cofearabi
cofearabi / gist:5845135
Created June 23, 2013 14:05
VBA Macro which gets the Excel data and put it into MySQL database.
Sub send_mysql()
Dim int_sheets_no
int_sheets_no = 1
@cofearabi
cofearabi / scrape4_mysql.pl
Created June 16, 2013 03:40
get stock data from yahoo and put them into mysql database server
#!/usr/bin/perl
use strict;
use warnings;
use Web::Scraper;
use URI;
use Encode;
# use Spreadsheet::WriteExcel;
use strict;
use warnings;
use utf8;
@cofearabi
cofearabi / AndroidManifest.xml
Last active July 21, 2020 12:50
Android sample connect to the mysql server database and get the values of field of table , and display them.
<uses-permission android:name="android.permission.INTERNET"/>
<uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />
@cofearabi
cofearabi / MainActivity.java
Created February 26, 2013 09:36
Android sample . When buntton is clicked , it displays message with Toast.
package com.example.andtoast;
import android.os.Bundle;
import android.app.Activity;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.Toast;
@cofearabi
cofearabi / MainActivity.java
Last active December 14, 2015 04:39
Android sample using Thread, Handler
package com.example.andrunnable2;
import android.os.Bundle;
import android.os.Handler;
import android.os.Message;
import android.app.Activity;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
package com.example.andrunnable;
import android.os.Bundle;
import android.os.Handler;
import android.os.Message;
import android.app.Activity;
import android.view.Menu;
import android.widget.TextView;
@cofearabi
cofearabi / MainActivity.java
Created February 19, 2013 04:34
Android AChartEngine(sample chart using AChartEngine)
package com.example.achartengine;
import org.achartengine.ChartFactory;
import org.achartengine.GraphicalView;
import org.achartengine.model.XYMultipleSeriesDataset;
import org.achartengine.model.XYSeries;
import org.achartengine.renderer.XYMultipleSeriesRenderer;
import org.achartengine.renderer.XYSeriesRenderer;
import android.app.Activity;
package com.example.andfileapp2;
import java.io.BufferedWriter;
import java.io.FileWriter;
import java.io.BufferedReader;
import java.io.FileReader;
@cofearabi
cofearabi / java_chart
Created January 24, 2013 14:20
(Java) make a chart
import org.jfree.chart.JFreeChart;
import org.jfree.chart.ChartFactory;
import org.jfree.data.category.DefaultCategoryDataset;
import org.jfree.chart.plot.PlotOrientation;
import javax.swing.JFrame;
import java.awt.BorderLayout;
import org.jfree.chart.ChartPanel;
import org.jfree.chart.ChartUtilities;
@cofearabi
cofearabi / access_dsnless
Last active December 11, 2015 15:38
(Java) connect to a access mdb database without dsn
import java.sql.*;
public class password {
public static void main(String[] args) {
try{
//
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//