Alienus Non diutius

BEGIN TRANSACTION문은 @@TRANCOUNT를 1씩 증가시킨다. ROLLBACK TRANSACTION문은 @@TRANCOUNT를 0으로 줄인다. COMMIT TRANSACTION문은 @@TRANCOUNT를 1씩 줄인다. PRINT @@TRANCOUNT -- 0 BEGIN TRAN -- BEGIN TRANSACTION문은 @@TRANCOUNT를 1씩 증가시킨다. PRINT @@TRANCOUNT -- 1 BEGIN TRAN -- BEGIN TRANSACTION문은 @@TRANCOUNT를 1씩 증가시킨다. PRINT @@TRANCOUNT -- 2 ROLLBACK -- ROLLBACK TRANSACTION문은 @@TRANCOUNT를 0으로 줄인다. PRINT @@TRANCOUNT -- 0 결과는 아..

청강컴정/DataBase 2009. 5. 4. 17:53

create trigger TRG_CAFE_UPDATE on cafe for update as begin if update(name) begin update cafe set description = '반갑습니다. ' + name + '입니다.' where sn = (select sn from inserted) end end update cafe set name = '교대피플' where name = '교대People'

청강컴정/DataBase 2009. 5. 4. 17:31

create trigger TRG_MEMBER_DELETE ON member instead of delete as begin declare @sn int set @sn = (select sn from deleted) delete from member_join where fk_member in @sn delete from member_visit where fk_member = @sn delete from member where sn = @sn end --실행 delete from member where sn = 1

청강컴정/DataBase 2009. 5. 4. 17:27

create trigger TRG_MEMBER_INS on member instead of insert as begin set nocount on; begin tran begin try declare @GET_SN int declare @MIN_SN int declare @NEW_SN int declare @MAX_SN int select @GET_SN = sn from inserted if @GET_SN IS NULL OR exists(select * from member where sn = @GET_SN) begin select @MIN_SN = MIN(SN) from member select top 1 @NEW_SN = RN from ( select sn,(row_number() over (orde..

청강컴정/DataBase 2009. 5. 4. 17:26

import org.kwis.msp.lcdui.*; import java.util.*; import java.io.IOException; public class CardGameEx extends Jlet { protected void startApp(String args[]) { Display dis = Display.getDefaultDisplay(); MainCard card = new MainCard(); dis.pushCard(card); } protected void destroyApp(boolean b){} } class MainCard extends Card { Font font; Image CardImg1, CardImg2; int x = 0, y = 0, w = getWidth(), h ..

청강컴정/소프트웨어공학 2009. 5. 4. 15:07

import org.kwis.msp.lcdui.*; import org.kwis.msp.lwc.*; public class RectEx extends Jlet { ShellComponent shell = new ShellComponent(); RectComponent rect = new RectComponent(); protected void startApp(String args[]) { shell.addComponent(rect); shell.show(); //Display dp = Display.getDefaultDisplay(); //RectClass card = new RectClass(); //dp.pushCard(card); } protected void destroyApp(boolean b)..

청강컴정/소프트웨어공학 2009. 5. 4. 15:07

import org.kwis.msp.lcdui.*; import org.kwis.msp.lwc.*; public class fontTest extends Jlet { ShellComponent shell = new ShellComponent(); FontComponent font = new FontComponent(); protected void startApp(String[] args) { shell.addComponent(font); shell.show(); } protected void pauseApp(){} protected void resumeApp(){} protected void destroyApp(boolean b){} } //Component를 상속받는다. class FontCompone..

청강컴정/소프트웨어공학 2009. 5. 4. 09:36

using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace datetype { //구조체 선언 struct structTest { public int a; public string b; } //나열형 선언 public enum Grades { F = 0, D = 1, C = 2, B = 3, A = 4 }; class Program { //구조체 선언 public struct CoOrds { public int x, y; public void test(int p1, int p2) { x = p1; y = p2; } } static void Main(string[] args) { //구조체의 사..

청강컴정/C# 2009. 5. 4. 02:10