C# (Csharp) 프로그래밍

C# ToUniversalTime 으로 사용하기

추천 : ToUniversalTime

using System.Linq;
using System.Text;
using System.Collections.ObjectModel;

namespace ConsoleTime
{
    class Program
    {
        static void Main(string[] args)
        {

            DateTime thisDate = new DateTime(2007, 3, 10, 0, 0, 0);
            DateTime dstDate = new DateTime(2007, 6, 10, 0, 0, 0);
            DateTimeOffset thisTime;

            thisTime = new DateTimeOffset(dstDate, new TimeSpan(-7, 0, 0));
            ShowPossibleTimeZones(thisTime);

            thisTime = new DateTimeOffset(thisDate, new TimeSpan(-6, 0, 0));
            
            ShowPossibleTimeZones(thisTime);

            thisTime = new DateTimeOffset(thisDate, new TimeSpan(+1, 0, 0));
            ShowPossibleTimeZones(thisTime);

            Console.ReadLine();
        }

        private static void ShowPossibleTimeZones(DateTimeOffset offsetTime)
        {
            TimeSpan offset = offsetTime.Offset;
            ReadOnlyCollection&lt;TimeZoneInfo&gt; timeZones;

            Console.WriteLine("{0} could belong to the following time zones:",
                              offsetTime.ToString());
            // Get all time zones defined on local system
            timeZones = TimeZoneInfo.GetSystemTimeZones();
            // Iterate time zones 
            foreach (TimeZoneInfo timeZone in timeZones)
            {
                // Compare offset with offset for that date in that time zone
                if (timeZone.GetUtcOffset(offsetTime.DateTime).Equals(offset))
                    Console.WriteLine("   {0}", timeZone.DisplayName);
            }
            Console.WriteLine();
        }
    }
}

using System.Linq;

using System.Text;

using System.Collections.ObjectModel;

namespace ConsoleTime

{

class Program

{

static void Main(string[] args)

{

DateTime thisDate = new DateTime(2007, 3, 10, 0, 0, 0);

DateTime dstDate = new DateTime(2007, 6, 10, 0, 0, 0);

DateTimeOffset thisTime;

thisTime = new DateTimeOffset(dstDate, new TimeSpan(-7, 0, 0));

ShowPossibleTimeZones(thisTime);

thisTime = new DateTimeOffset(thisDate, new TimeSpan(-6, 0, 0));

ShowPossibleTimeZones(thisTime);

thisTime = new DateTimeOffset(thisDate, new TimeSpan(+1, 0, 0));

ShowPossibleTimeZones(thisTime);

Console.ReadLine();

}

private static void ShowPossibleTimeZones(DateTimeOffset offsetTime)

{

TimeSpan offset = offsetTime.Offset;

ReadOnlyCollection<TimeZoneInfo> timeZones;

Console.WriteLine("{0} could belong to the following time zones:",

offsetTime.ToString());

// Get all time zones defined on local system

timeZones = TimeZoneInfo.GetSystemTimeZones();

// Iterate time zones

foreach (TimeZoneInfo timeZone in timeZones)

{

// Compare offset with offset for that date in that time zone

if (timeZone.GetUtcOffset(offsetTime.DateTime).Equals(offset))

Console.WriteLine(" {0}", timeZone.DisplayName);

}

Console.WriteLine();

}

결과 참조 : https://stackoverflow.com/questions/1201378/how-does-datetime-touniversaltime-work

SqlDataAdapter StoredProcedure

class DBData
{
static string connectionString = "server= 111.222.333.444;uid=id;pwd=pppp;database=UEUE";

public static string QueueHTML(string SID)
{
SqlConnection conn = new SqlConnection(connectionString);
SqlDataAdapter da = new SqlDataAdapter();
DataSet QUEUE = new DataSet();

try {
conn.Open();

SqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "QueueList";

SqlParameter paramSID = cmd.Parameters.Add("@SID", SqlDbType.Char, 3);
paramSID.Direction = ParameterDirection.Input;
paramSID.Value = SID;

da.SelectCommand = cmd;
da.Fill(QUEUE, "QUEUE");

XslCompiledTransform xslt = new XslCompiledTransform();
StringWriter stringWriter = new StringWriter();

xslt.Load("Queue.xsl");

XsltArgumentList args = new XsltArgumentList();

XmlDocument xml = new XmlDocument();

string dbXML = QUEUE.GetXml();
xml.LoadXml(dbXML);

xslt.Transform(xml, args, stringWriter);

string Content = stringWriter.ToString();

return Content;
}
catch (Exception ex)
{
//클라이언트에게 예외를 던진다.
//throw ex;
string Err = ex.ToString();
return "";
}

finally
{

}

}
}

class DBData

{

static string connectionString = "server= 111.222.333.444;uid=id;pwd=pppp;database=UEUE";

public static string QueueHTML(string SID)

{

SqlConnection conn = new SqlConnection(connectionString);

SqlDataAdapter da = new SqlDataAdapter();

DataSet QUEUE = new DataSet();

try {

conn.Open();

SqlCommand cmd = conn.CreateCommand();

cmd.CommandType = CommandType.StoredProcedure;

cmd.CommandText = "QueueList";

SqlParameter paramSID = cmd.Parameters.Add("@SID", SqlDbType.Char, 3);

paramSID.Direction = ParameterDirection.Input;

paramSID.Value = SID;

da.SelectCommand = cmd;

da.Fill(QUEUE, "QUEUE");

XslCompiledTransform xslt = new XslCompiledTransform();

StringWriter stringWriter = new StringWriter();

xslt.Load("Queue.xsl");

XsltArgumentList args = new XsltArgumentList();

XmlDocument xml = new XmlDocument();

string dbXML = QUEUE.GetXml();

xml.LoadXml(dbXML);

xslt.Transform(xml, args, stringWriter);

string Content = stringWriter.ToString();

return Content;

}

catch (Exception ex)

{

//클라이언트에게 예외를 던진다.

//throw ex;

string Err = ex.ToString();

return "";

}

finally

{

}

NuGet – MySqlConnector 설치 방법1. 포트연결은 : 아니고 , Insert 방법2. Asp.net Web.config Core 참조 : https://mysqlconnector.net/tutorials/connect-to-mysql/ Error : 원인 : MysqlBench 에서 나오는 쿼리에서 ‘(싱글쿼테이션)을 다 빼야지 된다. / C# 하고 java 의 문법적 차이

오목 게임 소스

vs2010 기준 다운로드 : Omk02

Java Programming Tutorial – 15 – Use Methods with Parameters

package apples;

import java.util.Scanner;
public class apples {
    public static void main(String[] args) {
		
		Scanner input = new Scanner(System.in);
		tuna tunaObject = new tuna();
		
		System.out.println("Enter your name here: ");
		String name  = input.nextLine();
		
		tunaObject.simpleMessage(name);
		}
}

//tuna.java
package apples;

public class tuna {
    public void simpleMessage(String name){
		System.out.println("Hello "+ name);
	}
}

package apples;

import java.util.Scanner;

public class apples {

public static void main(String[] args) {

Scanner input = new Scanner(System.in);

tuna tunaObject = new tuna();

System.out.println("Enter your name here: ");

String name = input.nextLine();

tunaObject.simpleMessage(name);

}

//tuna.java

package apples;

public class tuna {

public void simpleMessage(String name){

System.out.println("Hello "+ name);

}

Java Programming Tutorial – 14 – Using Multiple Classes

package apples;

public class apples {
    public static void main(String[] args) {
		tuna tunaObject = new tuna();
		tunaObject.simpleMessage();
		}
}

//tuna.java
package apples;

public class tuna {
    public void simpleMessage(){
		System.out.println("This is another class");
	}
}

package apples;

public class apples {

public static void main(String[] args) {

tuna tunaObject = new tuna();

tunaObject.simpleMessage();

}

//tuna.java

package apples;

public class tuna {

public void simpleMessage(){

System.out.println("This is another class");

}

Java Programming Tutorial – 13 – While Loop

사이트

https://nodejs.org/en/

snake.py

import pygame, random, sys
from pygame.locals import *

def collide(x1, x2, y1, y2, w1, w2, h1, h2):
    if x1+w1>x2 and x1<x2+w2 and y1+h1>y2 and y1<y2+h2:return True
	else:return False
	
def die(screen, score):
	f=pygame.font.SysFont('Arial', 30);
	t=f.render('Your score was: '+str(score), True, (0, 0, 0));
	screen.blit(t, (10, 270));pygame.display.update();
	pygame.time.wait(2000);sys.exit(0)
xs = [290, 290, 290, 290, 290];ys = [290, 270, 250, 230, 210];
dirs = 0;
score = 0;
applepos = (random.randint(0, 590), random.randint(0, 590));
pygame.init();
s=pygame.display.set_mode((600, 600));
pygame.display.set_caption('Snake');
appleimage = pygame.Surface((10, 10));
appleimage.fill((0, 255, 0));
img = pygame.Surface((20, 20));
img.fill((255, 0, 0));f = pygame.font.SysFont('Arial', 20);clock = pygame.time.Clock()

while True:
	clock.tick(10)
	for e in pygame.event.get():
		if e.type == QUIT:
			sys.exit(0)
		elif e.type == KEYDOWN:
			if e.key == K_UP and dirs != 0:dirs = 2
			elif e.key == K_DOWN and dirs != 2:dirs = 0
			elif e.key == K_LEFT and dirs != 1:dirs = 3
			elif e.key == K_RIGHT and dirs != 3:dirs = 1
	i = len(xs)-1
	while i >= 2:
		if collide(xs[0], xs[i], ys[0], ys[i], 20, 20, 20, 20):die(s, score)
		i-= 1
	if collide(xs[0], applepos[0], ys[0], applepos[1], 20, 10, 20, 10):score+=1;xs.append(700);ys.append(700);applepos=(random.randint(0,590),random.randint(0,590))
	if xs[0] < 0 or xs[0] > 580 or ys[0] < 0 or ys[0] > 580: die(s, score)
	i = len(xs)-1
	while i >= 1:
		xs[i] = xs[i-1];ys[i] = ys[i-1];i -= 1
	if dirs==0:ys[0] += 20
	elif dirs==1:xs[0] += 20
	elif dirs==2:ys[0] -= 20
	elif dirs==3:xs[0] -= 20	
	s.fill((255, 255, 255))	
	for i in range(0, len(xs)):
		s.blit(img, (xs[i], ys[i]))
		s.blit(appleimage, applepos);
		t=f.render(str(score), True, (0, 0, 0));
		s.blit(t, (10, 10));
		pygame.display.update()

import pygame, random, sys

from pygame.locals import *

def collide(x1, x2, y1, y2, w1, w2, h1, h2):

if x1+w1>x2 and x1<x2+w2 and y1+h1>y2 and y1<y2+h2:return True

else:return False

def die(screen, score):

f=pygame.font.SysFont('Arial', 30);

t=f.render('Your score was: '+str(score), True, (0, 0, 0));

screen.blit(t, (10, 270));pygame.display.update();

pygame.time.wait(2000);sys.exit(0)

xs = [290, 290, 290, 290, 290];ys = [290, 270, 250, 230, 210];

dirs = 0;

score = 0;

applepos = (random.randint(0, 590), random.randint(0, 590));

pygame.init();

s=pygame.display.set_mode((600, 600));

pygame.display.set_caption('Snake');

appleimage = pygame.Surface((10, 10));

appleimage.fill((0, 255, 0));

img = pygame.Surface((20, 20));

img.fill((255, 0, 0));f = pygame.font.SysFont('Arial', 20);clock = pygame.time.Clock()

while True:

clock.tick(10)

for e in pygame.event.get():

if e.type == QUIT:

sys.exit(0)

elif e.type == KEYDOWN:

if e.key == K_UP and dirs != 0:dirs = 2

elif e.key == K_DOWN and dirs != 2:dirs = 0

elif e.key == K_LEFT and dirs != 1:dirs = 3

elif e.key == K_RIGHT and dirs != 3:dirs = 1

i = len(xs)-1

while i >= 2:

if collide(xs[0], xs[i], ys[0], ys[i], 20, 20, 20, 20):die(s, score)

i-= 1

if collide(xs[0], applepos[0], ys[0], applepos[1], 20, 10, 20, 10):score+=1;xs.append(700);ys.append(700);applepos=(random.randint(0,590),random.randint(0,590))

if xs[0] < 0 or xs[0] > 580 or ys[0] < 0 or ys[0] > 580: die(s, score)

i = len(xs)-1

while i >= 1:

xs[i] = xs[i-1];ys[i] = ys[i-1];i -= 1

if dirs==0:ys[0] += 20

elif dirs==1:xs[0] += 20

elif dirs==2:ys[0] -= 20

elif dirs==3:xs[0] -= 20

s.fill((255, 255, 255))

for i in range(0, len(xs)):

s.blit(img, (xs[i], ys[i]))

s.blit(appleimage, applepos);

t=f.render(str(score), True, (0, 0, 0));

s.blit(t, (10, 10));

pygame.display.update()

C++ Basic Skills: Lesson 27 “Templates”

#include <iostream>
using namespace std;

template <class T>
void swap_these(T & a, T & b)
{
    T a_old = a;
    a = b;
    b = a_old;
}

int main()
{
    int array[5] ={1,2,3,5,4};
    swap_these(array[3], array[4]);
    for(int i=0;i<5;i++)
    {
        cout << array[i] << endl;
    }
return 0;
}

#include <iostream>

using namespace std;

template <class T>

void swap_these(T & a, T & b)

{

T a_old = a;

a = b;

b = a_old;

}

int main()

{

int array[5] ={1,2,3,5,4};

swap_these(array[3], array[4]);

for(int i=0;i<5;i++)

{

cout << array[i] << endl;

}

return 0;

}