Spinner : Changing Header Text Color

1) main.xml

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout
 xmlns:android="http://schemas.android.com/apk/res/android"
 android:orientation="vertical"
 android:layout_width="fill_parent"
 android:layout_height="fill_parent"
 >
 <TextView
  android:id="@+id/selector"
  android:layout_width="fill_parent"
  android:layout_height="wrap_content"
 
  />
 <Spinner android:id="@+id/spinner"
  android:layout_width="fill_parent"
  android:layout_height="wrap_content"
  android:drawSelectorOnTop="true"/>
</LinearLayout>

 

2) SpinnerDemo.java

package com.commonsware.android.selection;

import android.app.Activity;
import android.graphics.Color;
import android.os.Bundle;
import android.view.View;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.Spinner;
import android.widget.TextView;

public class SpinnerDemo extends Activity
 implements AdapterView.OnItemSelectedListener {
 TextView selection;
 String[] items={"a", "b", "c", "d", "e",
     "e", "f", "g", "h", "i",
     "j", "k", "l", "james", "m"};
 
 @Override
 public void onCreate(Bundle icicle) {
  super.onCreate(icicle);
  setContentView(R.layout.main);
  selection=(TextView)findViewById(R.id.selector);
 
  Spinner spin=(Spinner)findViewById(R.id.spinner);
 
  spin.setOnItemSelectedListener(this);
 
  ArrayAdapter<String> aa=new ArrayAdapter<String>(this,
               android.R.layout.simple_spinner_item,
               items);
 
  aa.setDropDownViewResource(
   android.R.layout.simple_spinner_dropdown_item);

  spin.setAdapter(aa);
 }
 
 public void onItemSelected(AdapterView<?> parent,
                View v, int position, long id) {
  selection.setText(items[position]);
  ((TextView)parent.getChildAt(0)).setTextColor(Color.RED);

// Of cause, This source is abailable for index number more than 0.
 }
 
 public void onNothingSelected(AdapterView<?> parent) {
  selection.setText("");
 }
}

 

 

 

 

Reference source : http://apress.com

From javascript to java, From Java to javascript

 

 

Reference http://www.itcpub.co.kr

Access SDCard

C:\>mksdcard 256M c:\sd.img

C:\>dir c:\sd.img
 C 드라이브의 볼륨에는 이름이 없습니다.
 볼륨 일련 번호: D88A-40A9

 c:\ 디렉터리

2010-04-27  오전 09:49       268,435,456 sd.img
               1개 파일         268,435,456 바이트
               0개 디렉터리  68,453,728,256 바이트 남음

 

 

 

 

 

 

数独

Reference http://www.itcpub.co.kr/

Setting PHPMyAdmin

1) http://www.gilbut.co.kr/book/detailCscenterRead.asp > PHP4 무작정 따라하기 > p4util.zip 다운

 

2) p4util.zip 압축풀고  phpmyadmin.zip 압축풀어서 phpmyadmin 폴더를 C:\Program Files\Apache Group\Apache2\htdocs 안에 복사

 

3) C:\Program Files\Apache Group\Apache2\htdocs\phpmyadmin\config.inc.php 파일을 메모장으로 열고 아래부분 찾아서 아래와 같이 수정

 

$cfgServers[1]['host']          = 'localhost'; // MySQL hostname
$cfgServers[1]['port']          = '';          // MySQL port - leave blank for default port
$cfgServers[1]['socket']        = '';          // Path to the socket - leave blank for default socket
$cfgServers[1]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
$cfgServers[1]['stduser']       = '';        

$cfgServers[1]['stdpass']       = '';          //   access to the "mysql/user" and "mysql/db" tables)
$cfgServers[1]['auth_type']     = 'config';    

$cfgServers[1]['user']          = 'root';      // MySQL user
$cfgServers[1]['password']      = '1234';  // MySQL password (only needed with 'config' auth)
$cfgServers[1]['only_db']       = '';

 

4) 브라우저 실행후 http://localhost/phpmyadmin/index.php 실행

 

 

Connection PHP to MySql

1) mysql_connect 함수로 MySql 연결

C:\Program Files\Apache Group\Apache2\htdocs\MySqlEx1\connect.php

 

<?
$connect = mysql_connect("localhost","small","password");  
mysql_select_db("company", $connect); 
$result = mysql_query("select * from friend", $connect);

if (!$result) {

echo "거짓! 테이블이 없는데요.";
}else {
echo "참! user 테이블에 모든 데이터를 선택하였습니다.";
}
mysql_close($connect);
?>

 

IE에서 http://localhost/MySqlEx1/connect.php 실행

 

결과 >

참! user 테이블에 모든 데이터를 선택하였습니다.

 

2) mysql_num_rows 함수로 데이터 행의 개수 구하기

C:\Program Files\Apache Group\Apache2\htdocs\MySqlEx1\num_rows.php

 

<?
$connect = mysql_connect("localhost","small","password"); 
mysql_select_db("company", $connect);
$result = mysql_query("select * from friend", $connect);
$num = mysql_num_rows($result);
echo "$num";
mysql_close($connect);
?>

 

결과 >

2

 

3) mysql_fetch_array 함수로 쿼리의 결과를 한 줄 배열로 보여주기

 

C:\Program Files\Apache Group\Apache2\htdocs\MySqlEx1\fetch_array.php

 

<?
$connect = mysql_connect("localhost","small","password");
mysql_select_db("company", $connect);
$result = mysql_query("select * from friend", $connect);
while($row=mysql_fetch_array($result)) {
echo "no : $row[0] | name : $row[1] | tel : $row[2]<br>";
echo "no : $row[no] | name : $row[name] | tel : $row[tel]<br>";
}
mysql_close($connect);
?>

 

결과 >

no : 1 | name : James Kim | tel : 1089971234
no : 1 | name : James Kim | tel : 1089971234
no : 2 | name : Fernando Torres | tel : 1089977777
no : 2 | name : Fernando Torres | tel : 1089977777

MySql Start2

C:\mysql\bin>mysqldump -uroot -p1111 company > company.sql  //  백업

C:\mysql\bin>mysql -uroot -p1111 company < company.sql  // 복구

mysql> use company
Database changed
mysql> show tables
    -> ;
+-------------------+
| Tables_in_company |
+-------------------+
| friend            |
+-------------------+
1 row in set (0.00 sec)

mysql> desc friend;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| no    | int(11)     | YES  |     | NULL    |       |
| name  | varchar(15) | YES  |     | NULL    |       |
| tel   | int(30)     |      |     | 0       |       |
+-------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

 

mysql> insert into friend(no,name,tel) values('1','James Kim','01089971234');
Query OK, 1 row affected (0.00 sec)

mysql> select * from friend;
+------+-----------+------------+
| no   | name      | tel        |
+------+-----------+------------+
|    1 | James Kim | 1089971234 |
+------+-----------+------------+
1 row in set (0.00 sec)

 

mysql> insert into friend(no,name,tel) values('2','Steven Gerrard','010-8997-1235');
Query OK, 1 row affected (0.00 sec)

mysql> select * from friend;
+------+----------------+------------+
| no   | name           | tel        |
+------+----------------+------------+
|    1 | James Kim      | 1089971234 |
|    2 | Steven Gerrard |         10 |
+------+----------------+------------+
2 rows in set (0.00 sec)

mysql> delete from friend where no=2;
Query OK, 1 row affected (0.00 sec)

 

mysql> insert into friend(no,name,tel) values('2','Fernando Torres','01089971236');
Query OK, 1 row affected (0.00 sec)

mysql> select * from friend;
+------+-----------------+------------+
| no   | name            | tel        |
+------+-----------------+------------+
|    1 | James Kim       | 1089971234 |
|    2 | Fernando Torres | 1089971236 |
+------+-----------------+------------+
2 rows in set (0.00 sec)

mysql> update friend set tel='1089977777' where no=2;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from friend;
+------+-----------------+------------+
| no   | name            | tel        |
+------+-----------------+------------+
|    1 | James Kim       | 1089971234 |
|    2 | Fernando Torres | 1089977777 |
+------+-----------------+------------+
2 rows in set (0.00 sec)