»Ë»Ñ Æ÷·³

¾Èµå·ÎÀÌµå ¸®½ºÆ®ºä À§Ä¡°ª ¾ò¾î¿Í¼­ µ¥ÀÌÅͺ£À̽º °ª »èÁ¦ÇÏ´Â ¹æ¹ý2

  • Ä«Å°Æù
  • µî·ÏÀÏ 2017-07-26 18:35
  • Á¶È¸¼ö 360
¿ì¼± µ¥ÀÌÅͺ£À̽º¿¡ ÀÖ´Â µ¥ÀÌÅ͸¦ selectÇؼ­ ¸®½ºÆ®ºä¿¡ »Ñ·ÁÁÖ°í ÀÖ½À´Ï´Ù.

 

»èÁ¦¸¦ ±¸ÇöÇÏ·Á°í Çϴµ¥¿ä

 

¸®½ºÆ®ºä 1¿­ ¸¶´Ù »èÁ¦¹öÆ°À» Ãß°¡Çسõ¾Ò°í

»èÁ¦¸¦ ´©¸£¸é ±× µ¥ÀÌÅ͸¦ »èÁ¦ÇÏ·Á°í ÇÕ´Ï´Ù.

 

±×·³ À§Ä¡°ªÀ» ¾ò¾î¿Í¾ßÇϴµ¥

 

±× À§Ä¡¶õ ¸®½ºÆ®ºäÀÇ n¹ø° À§Ä¡°¡ ¾Æ´Ñ µ¥ÀÌÅͺ£À̽ºÀÇ _id°ªÀ» ±¸ÇØ¿Í¾ß ÇÒ °Í °°½À´Ï´Ù.

 

±× °ªÀ» ¾î¶»°Ô ±¸ÇØ¿Í¾ß Çϳª¿ä?

 

Áö±Ý ÀÌÇØ°¡ ¾È°¡´Â ºÎºÐÀÌ º¸Åë »èÁ¦Çϸé Äõ¸®°¡

 

delete from Å×À̺í¸í where À̸§='»Ë»Ñ'

 

ÀÌ·¯¸é »Ë»Ñ°¡ Áö¿öÁö´Â°É·Î ¾Ë°í Àִµ¥

 

±×·³ »Ë»ÑÀÇ À妽º _id¸¦ ¾Ë¾Æ¿Í¾ß µÇ´Âµ¥ 

 

±× À妽º´Â ¸®½ºÆ®ºäÀÇ ¾î´À µ¥ÀÌÅ͸¦ °¡Áö°í ¾Ë¾Æ¿Í¾ßµÈ´Ù´Â°Çµ¥

listview.getText() = »Ë»Ñ

±×·³ select _id from Å×À̺í¸í where À̸§='»Ë»Ñ' ÀÌ·¸°Ô ÇØ¾ß _id¸¦ °¡Á®¿Ã ¼ö Àִ°ÅÁÒ?

 

 

 

 

ÇöÀç ÀÌ·¸°Ô ¸®½ºÆ®ºä¸¦ »Ñ·ÁÁÖ°í ÀÖ±¸¿ä

 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
    public View getView(int position, View convertView, ViewGroup parent) {
        Holder holder = null;
        final Login login = (Login) getItem(position);
        if (convertView == null) {
            convertView = new LinearLayout(context);
            ((LinearLayout) convertView).setOrientation(LinearLayout.HORIZONTAL);
 
            //»èÁ¦¹öÆ° ±¸Çö
            Button delete = new Button (context);
            delete.setText(R.string.delete);
            delete.setTextSize(20);
            delete.setGravity(Gravity.RIGHT);
            delete.setOnClickListener(
                    new Button.OnClickListener() {
                        public void onClick(View v) {
 
                            dbActivity.DeleteList();
                        }
                    }
            );
 
 
            TextView tvId = new TextView(context);
            tvId.setPadding(100200);
            tvId.setTextColor(Color.rgb(000));
            TextView tvName = new TextView(context);
            tvName.setPadding(200200);
            tvName.setTextColor(Color.rgb(000));
            TextView tvPw = new TextView(context);
            tvPw.setPadding(200200);
            tvPw.setTextColor(Color.rgb(000));
            ((LinearLayout) convertView).addView(tvId);
            ((LinearLayout) convertView).addView(tvName);
            ((LinearLayout) convertView).addView(tvPw);
            ((LinearLayout) convertView).addView(delete);
            holder = new Holder();
            holder.tv_id = tvId;
            holder.tvId = tvName;
            holder.tvPw = tvPw;
            convertView.setTag(holder);
        } else {
            holder = (Holder) convertView.getTag();
        }
        System.out.println("position"+position);
 
        holder.tv_id.setTextSize(20);
        holder.tv_id.setText(login.get_id() + "");
 
 
        holder.tvId.setTextSize(20);
        holder.tvId.setText(login.getId() + "   |");
 
 
        holder.tvPw.setTextSize(20);
        holder.tvPw.setText(login.getPw() + "   ");
 
 
        return convertView;
    }
cs

 

À§Ä¡°ªÀ» ¾ò¾î¿Í¾ßÇϴµ¥ ±×·³ ¾î´À ºÎºÐ¿¡¼­ À§Ä¡°ªÀ» ¾Ë¾Æ¿Í¾ßÇϴ°ǰ¡¿ä?

 

¾Æ´Ï¸é

¸®½ºÆ®ºäÀÇ N¹ø° À§Ä¡

µ¥ÀÌÅͺ£À̽ºÀÇ _id °ª

µÑ´Ù ÇÊ¿äÇÑ°¡¿ä?

 

0
ÃßõÇϱ⠴ٸ¥ÀÇ°ß 0
|
°øÀ¯¹öÆ°

´Ù¸¥ÀÇ°ß 0 Ãßõ 0 °ïÇÇ°ïÇÇv
2017-07-28 Á¡¾ÆÀÌÄÜ
  1. ´ñ±ÛÁÖ¼Òº¹»ç

´Ù¸¥ÀÇ°ß 0 Ãßõ 0 °í±Ô¸¶
2017-08-25 * Á¡¾ÆÀÌÄÜ
  1. ´ñ±ÛÁÖ¼Òº¹»ç
  • ¾Ë¸² ¿å¼³, »óó ÁÙ ¼ö ÀÖ´Â ¾ÇÇÃÀº »ï°¡ÁÖ¼¼¿ä.
©¹æ »çÁø  
¡â ÀÌÀü±Û¡ä ´ÙÀ½±Û -¸ñ·Ïº¸±â