C# (Csharp) 프로그래밍

C# 에서 mysql 저장프로시저 호출시 에러 발생

C# 에서 mysql 저장프로시저 호출시 에러 발생 base {System.SystemException} = {“Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation ‘=’”}

Transact-SQL


CREATE DEFINER=`testCore`@`%` PROCEDURE `GetLog`(In sReq_SearchWord varchar(200))
BEGIN

SELECT TraceId
       ,Req_SearchWord
       ,Req_File
       ,Response_File
       ,Regi_Date 
FROM BasicCode.FareLog 
where  Req_SearchWord = sReq_SearchWord; 

END

CREATE DEFINER=`testCore`@`%` PROCEDURE `GetLog`(In sReq_SearchWord varchar(200))

BEGIN

SELECT TraceId

,Req_SearchWord

,Req_File

,Response_File

,Regi_Date

FROM BasicCode.FareLog

where Req_SearchWord = sReq_SearchWord;

END

추가 : COLLATE utf8_unicode_ci

Transact-SQL


CREATE DEFINER=`testCore`@`%` PROCEDURE `GetLog`(In sReq_SearchWord varchar(200))
BEGIN

SELECT TraceId
       ,Req_SearchWord
       ,Req_File
       ,Response_File
       ,Regi_Date 
FROM BasicCode.FareLog 
where  Req_SearchWord = sReq_SearchWord COLLATE utf8_unicode_ci; 

END

CREATE DEFINER=`testCore`@`%` PROCEDURE `GetLog`(In sReq_SearchWord varchar(200))

BEGIN

SELECT TraceId

,Req_SearchWord

,Req_File

,Response_File

,Regi_Date

FROM BasicCode.FareLog

where Req_SearchWord = sReq_SearchWord COLLATE utf8_unicode_ci;

END

Category: C#

[C#] using MySql.Data.MySqlClient; this namespace is not working

using MySql.Data.MySqlClient; this namespace is not working download : https://dev.mysql.com/downloads/connector/net/


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySql.Data.MySqlClient;
 
namespace Console_Core
{
    class DBData
    {
        //Connect //
        static string connection = "server=***.***.***.****;user id=oracleuser;database=DBdata;Pwd=******;allowuservariables=True"; //수정 
        try{
                string US_ID = "";
                
                MySqlConnection conn = new MySqlConnection(connection);
                conn.Open();
				
                MySqlCommand cmd = conn.CreateCommand();
                cmd.CommandText = "SELECT * FROM mc  Limit 1;";
 
                MySqlDataAdapter adap = new MySqlDataAdapter(cmd);
                DataSet ds = new DataSet();
 
                MySqlDataReader reader = cmd.ExecuteReader();
                
                while (reader.Read())
                {
                    US_ID = reader["US_ID"].ToString();
                }
 
                reader.Close();
                return US_ID;
            }
 
            catch (Exception ex)
            {
                //클라이언트에게 예외를 던진다.
                ///throw ex;
                string Err = ex.ToString();
                return US_ID;
            }
 
            finally
            {
                if(conn.State == ConnectionState.Open)
                {
                    conn.Close();
                }
            }
    }
}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using MySql.Data.MySqlClient;

namespace Console_Core

{

class DBData

{

//Connect //

static string connection = "server=***.***.***.****;user id=oracleuser;database=DBdata;Pwd=******;allowuservariables=True"; //수정

try{

string US_ID = "";

MySqlConnection conn = new MySqlConnection(connection);

conn.Open();

MySqlCommand cmd = conn.CreateCommand();

cmd.CommandText = "SELECT * FROM mc Limit 1;";

MySqlDataAdapter adap = new MySqlDataAdapter(cmd);

DataSet ds = new DataSet();

MySqlDataReader reader = cmd.ExecuteReader();

while (reader.Read())

{

US_ID = reader["US_ID"].ToString();

}

reader.Close();

return US_ID;

}

catch (Exception ex)

{

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

///throw ex;

string Err = ex.ToString();

return US_ID;

}

finally

{

if(conn.State == ConnectionState.Open)

{

conn.Close();

}

Category: C#

아파치(Apache2) 와 톰캣(Tomcat8) 연동하기

아파치/ java 를 설치한 다음 진행할 작업이다. 1. 연동 커넥터 mod_jk 설치

Vim


sudo apt-get install libapache2-mod-jk

sudo apt-get install libapache2-mod-jk

mod_jk 를 설치하면 /etc/apache2/mods-available 경로에 jk.conf , jk.load 두 파일이 설치된 것을 확인 할 수 있다. /etc/libapache2-mod-jk/workers.properties 파일도 생성 되는데 내용은 다음과 같다.

Vim


# cat /etc/libapache2-mod-jk/workers.properties

workers.tomcat_home=/usr/share/tomcat8
workers.java_home=/usr/lib/jvm/default-java
ps=/
worker.list=ajp13_worker

worker.ajp13_worker.port=8009
worker.ajp13_worker.host=localhost
worker.ajp13_worker.type=ajp13
worker.ajp13_worker.lbfactor=1

worker.loadbalancer.type=lb
worker.loadbalancer.balance_workers=ajp13_worker

# cat /etc/libapache2-mod-jk/workers.properties

workers.tomcat_home=/usr/share/tomcat8

workers.java_home=/usr/lib/jvm/default-java

ps=/

worker.list=ajp13_worker

worker.ajp13_worker.port=8009

worker.ajp13_worker.host=localhost

worker.ajp13_worker.type=ajp13

worker.ajp13_worker.lbfactor=1

worker.loadbalancer.type=lb

worker.loadbalancer.balance_workers=ajp13_worker

톰켓하나만 돌리면 따로 수정할 필요가 없다.

Vim


#sudo nano /etc/apache2/mods-available/jk.conf 

중간 생략 
JkWorkersFile /etc/libapache2-mod-jk/workers.properties

#sudo nano /etc/apache2/mods-available/jk.conf

중간 생략

JkWorkersFile /etc/libapache2-mod-jk/workers.properties

디폴트로 workers.properties 이 연결 된것을 확인할 수 있다. 3. VirtualHost 파일을… Read More »

Category: java

placeholder 기능 쓰기

input textbox 제목을 textbox 안에 간단히 표시해보자 적용소스

XHTML


<!doctype html>
<html>
	<head>
		<meta charset="utf-8">
		<meta http-equiv="X-UA-Compatible" content="IE=edge">
		<meta name="viewport" content="width=device-width, initial-scale=1">
		<title>Placeholdem // Placeholder Caret Animation</title>
		
		<link href="assets/css/style.min.css" rel="stylesheet">
		<link href="assets/images/favicon.ico" rel="shortcut icon" type="image/x-icon">
	</head>
	<body>
		<div class="container">
			
			<h3 class="fade">placeholder</h3>
			<form>
				<label class="fade">
					<input name="field1" placeholder="제목을 입력하세요." />
					<div class="arrow"></div>
				</label>
				<label class="fade">
					<textarea name="field2" placeholder="내용을 입력하세요."></textarea>
					<div class="arrow"></div>
				</label>
			</form>
			
		<script src="placeholdem.min.js"></script>
		<script>
			Placeholdem( document.querySelectorAll( '[placeholder]' ) );

			var fadeElems = document.body.querySelectorAll( '.fade' ),
				fadeElemsLength = fadeElems.length,
				i = 0,
				interval = 50;

				function incFade() {
					if( i < fadeElemsLength ) {
						fadeElems[ i ].className += ' fade-load';
						i++;
						setTimeout( incFade, interval );
					}
				}

				setTimeout( incFade, interval );
		</script>
	</body>
</html>

<!doctype html>

<html>

<head>

<title>Placeholdem // Placeholder Caret Animation</title>

</head>

<body>

<h3 class="fade">placeholder</h3>

<form>

</label>

</label>

</form>

Placeholdem( document.querySelectorAll( '[placeholder]' ) );

var fadeElems = document.body.querySelectorAll( '.fade' ),

fadeElemsLength = fadeElems.length,

i = 0,

interval = 50;

function incFade() {

if( i < fadeElemsLength ) {

fadeElems[ i ].className += ' fade-load';

i++;

setTimeout( incFade, interval );

}

setTimeout( incFade, interval );

</script>

</body>

</html>

git hub : https://github.com/jackrugile/placeholdem

Category: javascipt

정규식 이용하여 문자열 패턴 가져오기

ASP


' 정규식 이용하여 문자열 패턴 가져오기 
pattern0 = "[^가-?]"               '한글만
pattern1 = "[^-0-9 ]"               '숫자만
pattern2 = "[^-a-zA-Z]"             '영어만
pattern3 = "[^-가-?a-zA-Z0-9/ ]"   '숫자와 영어 한글만 
pattern4 = "<[^>]*>"                '태그만
pattern5 = "[^-a-zA-Z0-9_/ ]"       '영어 숫자만 (-_ 포함)

Function Word_check(str,patrn)
    Dim regEx, match, matches
    SET regEx = New RegExp
    regEx.Pattern = patrn               ' 패턴을 설정합니다.
    regEx.IgnoreCase = True             ' 대/소문자를 구분하지 않도록 합니다.
    regEx.Global = True                 ' 전체 문자열을 검색하도록 설정합니다.
    SET Matches = regEx.Execute(str)

    If 0 < Matches.count Then
        Word_check = false
    Else
        Word_check = true
    End if
End Function

Dim pattern1_True  '숫자만
pattern1_True = Word_check(ID, pattern1)

if pattern1_True="True" then
  '로직
end if

' 정규식 이용하여 문자열 패턴 가져오기

pattern0 = "[^가-?]" '한글만

pattern1 = "[^-0-9 ]" '숫자만

pattern2 = "[^-a-zA-Z]" '영어만

pattern3 = "[^-가-?a-zA-Z0-9/ ]" '숫자와 영어 한글만

pattern4 = "<[^>]*>" '태그만

pattern5 = "[^-a-zA-Z0-9_/ ]" '영어 숫자만 (-_ 포함)

Function Word_check(str,patrn)

Dim regEx, match, matches

SET regEx = New RegExp

regEx.Pattern = patrn ' 패턴을 설정합니다.

regEx.IgnoreCase = True ' 대/소문자를 구분하지 않도록 합니다.

regEx.Global = True ' 전체 문자열을 검색하도록 설정합니다.

SET Matches = regEx.Execute(str)

If 0 < Matches.count Then

Word_check = false

Else

Word_check = true

End if

End Function

Dim pattern1_True '숫자만

pattern1_True = Word_check(ID, pattern1)

if pattern1_True="True" then

'로직

end if

Category: ASP

asp 디비 접속하여 Rs 레코드 가져오기

ASP


<!--#include file="../dbconn.asp"-->

<%
call dbconn_sub '디비연결'

   strSQL = "Select top 1 id, mail from board where idx = '"&id&"' and mail ='" & email & "'"
   SET Rs=db.Execute(strSQL)
   
   if (Rs.BOF or Rs.EOF) then
      response.write "데이타가 없습니다."
   else
      response.write Rs("id")
      response.write Rs("mail")
      Rs.close : set Rs = nothing
   end if
'/// DB접속끊기
db.close : set db=nothing
%>

call dbconn_sub '디비연결'

strSQL = "Select top 1 id, mail from board where idx = '"&id&"' and mail ='" & email & "'"

SET Rs=db.Execute(strSQL)

if (Rs.BOF or Rs.EOF) then

response.write "데이타가 없습니다."

else

response.write Rs("id")

response.write Rs("mail")

Rs.close : set Rs = nothing

end if

'/// DB접속끊기

db.close : set db=nothing

Category: ASP

E-메일 형식 javascript

JavaScript


function EmailCheck(){

var check2 = /^[a-zA-Z0-9\-\.\_]+\@[a-zA-Z0-9\-\.]+\.([a-zA-Z]{2,6})$/; 

   if (document.Input.txtemail.value ==""){
		alert("글 작성시 Email을 입력해 주십시오.");
		document.Input.email.focus;
		return 0;
		}
    
    if ( check2.test(document.Input.txtemail.value)) { 
		} 
		else { 
			alert("E-메일이 형식에 맞지 않습니다.\n\n  확인바랍니다.");
			document.Input.email.focus;
			return 0; 
		} 	

}

function EmailCheck(){

var check2 = /^[a-zA-Z0-9\-\.\_]+\@[a-zA-Z0-9\-\.]+\.([a-zA-Z]{2,6})$/;

if (document.Input.txtemail.value ==""){

alert("글 작성시 Email을 입력해 주십시오.");

document.Input.email.focus;

return 0;

}

if ( check2.test(document.Input.txtemail.value)) {

}

else {

alert("E-메일이 형식에 맞지 않습니다.\n\n 확인바랍니다.");

document.Input.email.focus;

return 0;

}

Category: javascipt

IP 국가 리스트 편하기 검색하기

Transact-SQL


USE [ipv]
GO

/****** Object:  Table [dbo].[ipv4_KR]    Script Date: 2020-05-18 오후 5:12:30 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ipv4_KR](
	[IDX] [int] NOT NULL,
	[Standard_Date] [varchar](20) NOT NULL CONSTRAINT [DF_ipv4_KR_Standard_Date]  DEFAULT (''),
	[Cuntry_Code] [varchar](10) NOT NULL CONSTRAINT [DF_ipv4_KR_Cuntry_Code]  DEFAULT (''),
	[Start_IP_Number] [float] NOT NULL CONSTRAINT [DF_ipv4_KR_Start_IP_Number]  DEFAULT ((0)),
	[End_IP_Number] [float] NOT NULL CONSTRAINT [DF_ipv4_KR_End_IP_Number]  DEFAULT ((0)),
	[Start_IP] [varchar](20) NOT NULL CONSTRAINT [DF_ipv4_KR_Start_IP]  DEFAULT (''),
	[End_IP] [varchar](20) NOT NULL CONSTRAINT [DF_ipv4_KR_End_IP]  DEFAULT (''),
	[PREFIX] [varchar](20) NOT NULL CONSTRAINT [DF_ipv4_KR_PREFIX]  DEFAULT (''),
	[Regi_Date] [varchar](20) NOT NULL CONSTRAINT [DF_ipv4_KR_Regi_Date]  DEFAULT (''),
 CONSTRAINT [PK_ipv4_KR] PRIMARY KEY CLUSTERED 
(
	[IDX] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

USE [ipv]

/****** Object: Table [dbo].[ipv4_KR] Script Date: 2020-05-18 오후 5:12:30 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[ipv4_KR](

[IDX] [int] NOT NULL,

[Standard_Date] [varchar](20) NOT NULL CONSTRAINT [DF_ipv4_KR_Standard_Date] DEFAULT (''),

[Cuntry_Code] [varchar](10) NOT NULL CONSTRAINT [DF_ipv4_KR_Cuntry_Code] DEFAULT (''),

[Start_IP_Number] [float] NOT NULL CONSTRAINT [DF_ipv4_KR_Start_IP_Number] DEFAULT ((0)),

[End_IP_Number] [float] NOT NULL CONSTRAINT [DF_ipv4_KR_End_IP_Number] DEFAULT ((0)),

[Start_IP] [varchar](20) NOT NULL CONSTRAINT [DF_ipv4_KR_Start_IP] DEFAULT (''),

[End_IP] [varchar](20) NOT NULL CONSTRAINT [DF_ipv4_KR_End_IP] DEFAULT (''),

[PREFIX] [varchar](20) NOT NULL CONSTRAINT [DF_ipv4_KR_PREFIX] DEFAULT (''),

[Regi_Date] [varchar](20) NOT NULL CONSTRAINT [DF_ipv4_KR_Regi_Date] DEFAULT (''),

CONSTRAINT [PK_ipv4_KR] PRIMARY KEY CLUSTERED

(

[IDX] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

fn_GetIdxDataLikeSplit

Transact-SQL


-----------------------------------------------------------------------------------------------------------  
--  Split 유형의 함수  
--  문자열에서 구분자(@iSeparator)로 몇번째 단어 가져오기  
--  예: SELECT 데이터베이스명.소유자명.fn_GetIdxDataLikeSplit('가-나-다',2,'-') --> '나'  
-----------------------------------------------------------------------------------------------------------  
-----------------------------------------------------------------------------------------------------------  
-- 프로시저 생성  
-----------------------------------------------------------------------------------------------------------  
Alter  FUNCTION  [dbo].[fn_GetIdxDataLikeSplit]   
    (  
        @iText          VARCHAR(200),  
        @idx                INT,  
        @iSeparator     VARCHAR(10) = '.'  
    )  
RETURNS  VARCHAR(200)   
AS  
BEGIN  
    DECLARE @wData          VARCHAR(200)  
    DECLARE @wText          VARCHAR(200)  
    DECLARE @wSeparator VARCHAR(10)  
    DECLARE @wNum           INT  
  
    SET @wData          = ''  
    SET @wNum           = 1;  
    SET @wSeparator = LTRIM(RTRIM(@iSeparator));  
    SET @wText          = LTRIM(RTRIM(@iText)) + @wSeparator;   
  
    IF CHARINDEX(@wSeparator, @iText) > 0  
    BEGIN  
        WHILE    @idx >= @wNum  
        BEGIN  
            IF CHARINDEX(@wSeparator, @wText) > 0  
            BEGIN  
                   -- 문자열의 인덱스 위치의 요소를 반환  
                   SET @wData   = SUBSTRING(@wText, 1, CHARINDEX(@wSeparator, @wText) - 1);  
                   SET @wData   = LTRIM(RTRIM(@wData));  
  
                -- 반환된 문자는 버린후 좌우공백 제거     
                    SET @wText  = LTRIM(RTRIM(RIGHT(@wText, LEN(@wText) - (LEN(@wData) + LEN(@iSeparator)))))  
            END   
            ELSE  
            BEGIN  
                    SET @wData  = ''  
            END  
            SET @wNum = @wNum + 1  
        END  
    END  
    ELSE  
    BEGIN  
        SET @wData  = @iText  
    END  
      -- HEO ADd
    if Len(@wData) =1
	    begin Set @wData =  '00' + @wData   end  
	else if(Len(@wData) =2)
	    begin Set @wData =  '0' + @wData   end  
	  
    RETURN(@wData)  
      
END

-----------------------------------------------------------------------------------------------------------

-- Split 유형의 함수

-- 문자열에서 구분자(@iSeparator)로 몇번째 단어 가져오기

-- 예: SELECT 데이터베이스명.소유자명.fn_GetIdxDataLikeSplit('가-나-다',2,'-') --> '나'

-----------------------------------------------------------------------------------------------------------

-- 프로시저 생성

-----------------------------------------------------------------------------------------------------------

Alter FUNCTION [dbo].[fn_GetIdxDataLikeSplit]

(

@iText VARCHAR(200),

@idx INT,

@iSeparator VARCHAR(10) = '.'

)

RETURNS VARCHAR(200)

BEGIN

DECLARE @wData VARCHAR(200)

DECLARE @wText VARCHAR(200)

DECLARE @wSeparator VARCHAR(10)

DECLARE @wNum INT

SET @wData = ''

SET @wNum = 1;

SET @wSeparator = LTRIM(RTRIM(@iSeparator));

SET @wText = LTRIM(RTRIM(@iText)) + @wSeparator;

IF CHARINDEX(@wSeparator, @iText) > 0

BEGIN

WHILE @idx >= @wNum

BEGIN

IF CHARINDEX(@wSeparator, @wText) > 0

BEGIN

-- 문자열의 인덱스 위치의 요소를 반환

SET @wData = SUBSTRING(@wText, 1, CHARINDEX(@wSeparator, @wText) - 1);

SET @wData = LTRIM(RTRIM(@wData));

-- 반환된 문자는 버린후 좌우공백 제거

SET @wText = LTRIM(RTRIM(RIGHT(@wText, LEN(@wText) - (LEN(@wData) + LEN(@iSeparator)))))

END

ELSE

BEGIN

SET @wData = ''

END

SET @wNum = @wNum + 1

END

ELSE

BEGIN

SET @wData = @iText

END

-- HEO ADd

if Len(@wData) =1

begin Set @wData = '00' + @wData end

else if(Len(@wData) =2)

begin Set @wData = '0' + @wData end

RETURN(@wData)

END

Transact-SQL


Declare @IDX int
Declare @Start_IP varchar(20), @End_IP varchar(20)

Declare @Start_IP_01 varchar(3),@Start_IP_02 varchar(3),@Start_IP_03 varchar(3),@Start_IP_04 varchar(3)
Declare @End_IP_01 varchar(3),@End_IP_02 varchar(3),@End_IP_03 varchar(3),@End_IP_04 varchar(3)
 
Declare con_cursor cursor for SELECT IDX, Start_IP, End_IP  FROM [IBE_Basic_Code].[dbo].[ipv4_KR] 
	open con_cursor --커스를 연다.
	fetch next from con_cursor into @IDX, @Start_IP, @End_IP
	while (@@fetch_status <>-1)
		begin
		if (@@fetch_status = -2)
		continue
			begin

			   Set @Start_IP_01 = [dbo].[fn_GetIdxDataLikeSplit](@Start_IP,1,'.')
			   Set @Start_IP_02 = [dbo].[fn_GetIdxDataLikeSplit](@Start_IP,2,'.')
			   Set @Start_IP_03 = [dbo].[fn_GetIdxDataLikeSplit](@Start_IP,3,'.')
			   Set @Start_IP_04 = [dbo].[fn_GetIdxDataLikeSplit](@Start_IP,4,'.')
			   
			   Set @End_IP_01 = [dbo].[fn_GetIdxDataLikeSplit](@End_IP,1,'.')
			   Set @End_IP_02 = [dbo].[fn_GetIdxDataLikeSplit](@End_IP,2,'.')
			   Set @End_IP_03 = [dbo].[fn_GetIdxDataLikeSplit](@End_IP,3,'.')
			   Set @End_IP_04 = [dbo].[fn_GetIdxDataLikeSplit](@End_IP,4,'.')


			   update [IBE_Basic_Code].[dbo].[ipv4_KR] set Start_IP_Number = CONVERT(numeric, @Start_IP_01 +  @Start_IP_02 + @Start_IP_03 + @Start_IP_04)
														  ,End_IP_Number = CONVERT(numeric, @End_IP_01 +  @End_IP_02 + @End_IP_03 + @End_IP_04)
			   where IDX = @IDX



			   
			end
		fetch next from con_cursor into @IDX, @Start_IP, @End_IP
		end
	close con_cursor
Deallocate con_cursor

Declare @IDX int

Declare @Start_IP varchar(20), @End_IP varchar(20)

Declare @Start_IP_01 varchar(3),@Start_IP_02 varchar(3),@Start_IP_03 varchar(3),@Start_IP_04 varchar(3)

Declare @End_IP_01 varchar(3),@End_IP_02 varchar(3),@End_IP_03 varchar(3),@End_IP_04 varchar(3)

Declare con_cursor cursor for SELECT IDX, Start_IP, End_IP FROM [IBE_Basic_Code].[dbo].[ipv4_KR]

open con_cursor --커스를 연다.

fetch next from con_cursor into @IDX, @Start_IP, @End_IP

while (@@fetch_status <>-1)

begin

if (@@fetch_status = -2)

continue

begin

Set @Start_IP_01 = [dbo].[fn_GetIdxDataLikeSplit](@Start_IP,1,'.')

Set @Start_IP_02 = [dbo].[fn_GetIdxDataLikeSplit](@Start_IP,2,'.')

Set @Start_IP_03 = [dbo].[fn_GetIdxDataLikeSplit](@Start_IP,3,'.')

Set @Start_IP_04 = [dbo].[fn_GetIdxDataLikeSplit](@Start_IP,4,'.')

Set @End_IP_01 = [dbo].[fn_GetIdxDataLikeSplit](@End_IP,1,'.')

Set @End_IP_02 = [dbo].[fn_GetIdxDataLikeSplit](@End_IP,2,'.')

Set @End_IP_03 = [dbo].[fn_GetIdxDataLikeSplit](@End_IP,3,'.')

Set @End_IP_04 = [dbo].[fn_GetIdxDataLikeSplit](@End_IP,4,'.')

update [IBE_Basic_Code].[dbo].[ipv4_KR] set Start_IP_Number = CONVERT(numeric, @Start_IP_01 + @Start_IP_02 + @Start_IP_03 + @Start_IP_04)

,End_IP_Number = CONVERT(numeric, @End_IP_01 + @End_IP_02 + @End_IP_03 + @End_IP_04)

where IDX = @IDX

end

fetch next from con_cursor into @IDX, @Start_IP, @End_IP

end

close con_cursor

Deallocate con_cursor

Category: 미분류

이클립스 에러 Multiple annotations found at this line: – The superclass “javax.servlet.http.HttpServlet” was not found on the Java Build Path 진행중인 프로젝트 에서 속성-> Project Facts 에서 자바 runtime 을 톰켓버전에 맞추어 체크 한다.

Category: java

XMLHttpRequest 호출

XHTML


<!DOCTYPE html>
<html>
<body>

<p>XMLHttpRequest sample </p>

<p id="demo">dd</p>

<script>
function airline(code) {
    
	//var decode = code;
    
    var xmlHttp = new XMLHttpRequest();
    xmlHttp.open( "GET", "https://code.auctpro.co.kr/airline.php?code=" + code, false ); 
    xmlHttp.send( null );
	
    document.getElementById("demo").innerHTML = xmlHttp.responseText;
    //decode =  xmlHttp.responseText;
	
	//return decode;
}

airline('KE');

</script>

</body>
</html>

<!DOCTYPE html>

<html>

<body>

<p>XMLHttpRequest sample </p>

function airline(code) {

//var decode = code;

var xmlHttp = new XMLHttpRequest();

xmlHttp.open( "GET", "https://code.auctpro.co.kr/airline.php?code=" + code, false );

xmlHttp.send( null );

document.getElementById("demo").innerHTML = xmlHttp.responseText;

//decode = xmlHttp.responseText;

//return decode;

}

airline('KE');

</script>

</body>

</html>

Category: PHP

Post navigation

← Older posts