728x90
반응형
ajax
Asyncronous Javascript And Xml(비동기 통신)
ajax(비동기통신) 게시판의 페이지를 넘기기, 검색창에서 일부글자만으로 아래 자동검색창이 뜨는 등
전체의 페이지 로딩없이 DB에서 가져온 일부의 데이터를 볼 수 있도록 한다.
위 그림과 같이 사원정보를 조회하면 아래의 테이블에 해당되는 자료 정보만 표시되도록 되어 있다.
이는 전체페이지의 로딩(변경)없이 DB로부터 일부 데이터를 보여준다.
비동기 통신을 하기 위해서는 Database와 연결하여 해당 정보를 불러올 수 있어야 하며,
위 예시에서는 emplist.xml 파일을 해당 프로젝트의 Web-Content 안에 담아 활용했다.
1. body
<body>
<h1>데이터 가져오기</h1>
<fieldset>
<legend>사원정보 조회</legend>
<input type="text" name="empid"/>
<input type="button" id="emp_search" value="조회"/>
</fieldset>
<table>
<tr>
<th>사원번호</th>
<td><input type="text" name="empnum"/></td>
</tr>
<tr>
<th>이름</th>
<td><input type="text" name="lastname"/></td>
</tr>
<tr>
<th>이메일</th>
<td><input type="text" name="email"/></td>
</tr>
<tr>
<th>전화번호</th>
<td><input type="text" name="phone"/></td>
</tr>
<tr>
<th>입사일</th>
<td><input type="text" name="hire"/></td>
</tr>
</table>
</body>
2. script
<style type="text/css">
*{maring:0; padding:0;}
table{width: 400px;}
table tr:nth-child(odd){background: orange;}
fieldset{width: 400px;}
body{width:1000px; margin: 50px auto;}
</style>
<script type="text/javascript" src="resources/js/jquery-3.5.1.min.js"></script>
<script type="text/javascript">
$(function(){
$("#emp_search").click(function(){
var empid = $("input[name=empid]").val();
if(!isNaN(empid) && empid.length > 2){ //jquery api - low level ...
$.ajax({ //ajax: Asyncronous Javascript And Xml 비동기 통신(서버의 처리를 기다리지 않는다.)
url: "emplist.xml", // 통신 할 경로
method: "get", // 서버 전송 방식
async: true, // 비동기식(true: 비동기/ false: 동기)
dataType:"xml", // 전송받을 데이터 타입(xml, json, html, script, text...)
//data: {"key": "value"}, // 전송할 데이터
success: function(data){ // 통신이 성공했을 때
console.log(data);
var empInfo = $(data).find("EMPLOYEE_ID:contains(" + empid + ")").parent();
if(empInfo.is("ROW")){
$("table input").each(function(i){
$(this).val($(empInfo).children().eq(i).text());
});
} else {
alert("검색대상이 존재하지 않습니다.");
}
},
error: function(request, error){ // 통신이 실패했을 때
alert("code:" + request.status + "\n" +
"message :" + request.reponseText + "\n" +
"error :" + error);
}
});
}
});
});
</script>
<emplist.xml>
emllist에서 ROW 안의 tagName들은 EMPLOYEE_ID, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE이다.
<?xml version="1.0" encoding="UTF-8"?>
<ROWSET>
<ROW>
<EMPLOYEE_ID>100</EMPLOYEE_ID>
<LAST_NAME>King</LAST_NAME>
<EMAIL>SKING</EMAIL>
<PHONE_NUMBER>515.123.4567</PHONE_NUMBER>
<HIRE_DATE>1987. 6. 17 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>101</EMPLOYEE_ID>
<LAST_NAME>Kochhar</LAST_NAME>
<EMAIL>NKOCHHAR</EMAIL>
<PHONE_NUMBER>515.123.4568</PHONE_NUMBER>
<HIRE_DATE>1989. 9. 21 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>102</EMPLOYEE_ID>
<LAST_NAME>De Haan</LAST_NAME>
<EMAIL>LDEHAAN</EMAIL>
<PHONE_NUMBER>515.123.4569</PHONE_NUMBER>
<HIRE_DATE>1993. 1. 13 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>103</EMPLOYEE_ID>
<LAST_NAME>Hunold</LAST_NAME>
<EMAIL>AHUNOLD</EMAIL>
<PHONE_NUMBER>590.423.4567</PHONE_NUMBER>
<HIRE_DATE>1990. 1. 3 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>104</EMPLOYEE_ID>
<LAST_NAME>Ernst</LAST_NAME>
<EMAIL>BERNST</EMAIL>
<PHONE_NUMBER>590.423.4568</PHONE_NUMBER>
<HIRE_DATE>1991. 5. 21 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>105</EMPLOYEE_ID>
<LAST_NAME>Austin</LAST_NAME>
<EMAIL>DAUSTIN</EMAIL>
<PHONE_NUMBER>590.423.4569</PHONE_NUMBER>
<HIRE_DATE>1997. 6. 25 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>106</EMPLOYEE_ID>
<LAST_NAME>Pataballa</LAST_NAME>
<EMAIL>VPATABAL</EMAIL>
<PHONE_NUMBER>590.423.4560</PHONE_NUMBER>
<HIRE_DATE>1998. 2. 5 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>107</EMPLOYEE_ID>
<LAST_NAME>Lorentz</LAST_NAME>
<EMAIL>DLORENTZ</EMAIL>
<PHONE_NUMBER>590.423.5567</PHONE_NUMBER>
<HIRE_DATE>1999. 2. 7 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>108</EMPLOYEE_ID>
<LAST_NAME>Greenberg</LAST_NAME>
<EMAIL>NGREENBE</EMAIL>
<PHONE_NUMBER>515.124.4569</PHONE_NUMBER>
<HIRE_DATE>1994. 8. 17 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>109</EMPLOYEE_ID>
<LAST_NAME>Faviet</LAST_NAME>
<EMAIL>DFAVIET</EMAIL>
<PHONE_NUMBER>515.124.4169</PHONE_NUMBER>
<HIRE_DATE>1994. 8. 16 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>110</EMPLOYEE_ID>
<LAST_NAME>Chen</LAST_NAME>
<EMAIL>JCHEN</EMAIL>
<PHONE_NUMBER>515.124.4269</PHONE_NUMBER>
<HIRE_DATE>1997. 9. 28 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>111</EMPLOYEE_ID>
<LAST_NAME>Sciarra</LAST_NAME>
<EMAIL>ISCIARRA</EMAIL>
<PHONE_NUMBER>515.124.4369</PHONE_NUMBER>
<HIRE_DATE>1997. 9. 30 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>112</EMPLOYEE_ID>
<LAST_NAME>Urman</LAST_NAME>
<EMAIL>JMURMAN</EMAIL>
<PHONE_NUMBER>515.124.4469</PHONE_NUMBER>
<HIRE_DATE>1998. 3. 7 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>113</EMPLOYEE_ID>
<LAST_NAME>Popp</LAST_NAME>
<EMAIL>LPOPP</EMAIL>
<PHONE_NUMBER>515.124.4567</PHONE_NUMBER>
<HIRE_DATE>1999. 12. 7 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>114</EMPLOYEE_ID>
<LAST_NAME>Raphaely</LAST_NAME>
<EMAIL>DRAPHEAL</EMAIL>
<PHONE_NUMBER>515.127.4561</PHONE_NUMBER>
<HIRE_DATE>1994. 12. 7 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>115</EMPLOYEE_ID>
<LAST_NAME>Khoo</LAST_NAME>
<EMAIL>AKHOO</EMAIL>
<PHONE_NUMBER>515.127.4562</PHONE_NUMBER>
<HIRE_DATE>1995. 5. 18 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>116</EMPLOYEE_ID>
<LAST_NAME>Baida</LAST_NAME>
<EMAIL>SBAIDA</EMAIL>
<PHONE_NUMBER>515.127.4563</PHONE_NUMBER>
<HIRE_DATE>1997. 12. 24 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>117</EMPLOYEE_ID>
<LAST_NAME>Tobias</LAST_NAME>
<EMAIL>STOBIAS</EMAIL>
<PHONE_NUMBER>515.127.4564</PHONE_NUMBER>
<HIRE_DATE>1997. 7. 24 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>118</EMPLOYEE_ID>
<LAST_NAME>Himuro</LAST_NAME>
<EMAIL>GHIMURO</EMAIL>
<PHONE_NUMBER>515.127.4565</PHONE_NUMBER>
<HIRE_DATE>1998. 11. 15 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>119</EMPLOYEE_ID>
<LAST_NAME>Colmenares</LAST_NAME>
<EMAIL>KCOLMENA</EMAIL>
<PHONE_NUMBER>515.127.4566</PHONE_NUMBER>
<HIRE_DATE>1999. 8. 10 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>120</EMPLOYEE_ID>
<LAST_NAME>Weiss</LAST_NAME>
<EMAIL>MWEISS</EMAIL>
<PHONE_NUMBER>650.123.1234</PHONE_NUMBER>
<HIRE_DATE>1996. 7. 18 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>121</EMPLOYEE_ID>
<LAST_NAME>Fripp</LAST_NAME>
<EMAIL>AFRIPP</EMAIL>
<PHONE_NUMBER>650.123.2234</PHONE_NUMBER>
<HIRE_DATE>1997. 4. 10 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>122</EMPLOYEE_ID>
<LAST_NAME>Kaufling</LAST_NAME>
<EMAIL>PKAUFLIN</EMAIL>
<PHONE_NUMBER>650.123.3234</PHONE_NUMBER>
<HIRE_DATE>1995. 5. 1 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>123</EMPLOYEE_ID>
<LAST_NAME>Vollman</LAST_NAME>
<EMAIL>SVOLLMAN</EMAIL>
<PHONE_NUMBER>650.123.4234</PHONE_NUMBER>
<HIRE_DATE>1997. 10. 10 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>124</EMPLOYEE_ID>
<LAST_NAME>Mourgos</LAST_NAME>
<EMAIL>KMOURGOS</EMAIL>
<PHONE_NUMBER>650.123.5234</PHONE_NUMBER>
<HIRE_DATE>1999. 11. 16 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>125</EMPLOYEE_ID>
<LAST_NAME>Nayer</LAST_NAME>
<EMAIL>JNAYER</EMAIL>
<PHONE_NUMBER>650.124.1214</PHONE_NUMBER>
<HIRE_DATE>1997. 7. 16 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>126</EMPLOYEE_ID>
<LAST_NAME>Mikkilineni</LAST_NAME>
<EMAIL>IMIKKILI</EMAIL>
<PHONE_NUMBER>650.124.1224</PHONE_NUMBER>
<HIRE_DATE>1998. 9. 28 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>127</EMPLOYEE_ID>
<LAST_NAME>Landry</LAST_NAME>
<EMAIL>JLANDRY</EMAIL>
<PHONE_NUMBER>650.124.1334</PHONE_NUMBER>
<HIRE_DATE>1999. 1. 14 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>128</EMPLOYEE_ID>
<LAST_NAME>Markle</LAST_NAME>
<EMAIL>SMARKLE</EMAIL>
<PHONE_NUMBER>650.124.1434</PHONE_NUMBER>
<HIRE_DATE>2000. 3. 8 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>129</EMPLOYEE_ID>
<LAST_NAME>Bissot</LAST_NAME>
<EMAIL>LBISSOT</EMAIL>
<PHONE_NUMBER>650.124.5234</PHONE_NUMBER>
<HIRE_DATE>1997. 8. 20 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>130</EMPLOYEE_ID>
<LAST_NAME>Atkinson</LAST_NAME>
<EMAIL>MATKINSO</EMAIL>
<PHONE_NUMBER>650.124.6234</PHONE_NUMBER>
<HIRE_DATE>1997. 10. 30 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>131</EMPLOYEE_ID>
<LAST_NAME>Marlow</LAST_NAME>
<EMAIL>JAMRLOW</EMAIL>
<PHONE_NUMBER>650.124.7234</PHONE_NUMBER>
<HIRE_DATE>1997. 2. 16 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>132</EMPLOYEE_ID>
<LAST_NAME>Olson</LAST_NAME>
<EMAIL>TJOLSON</EMAIL>
<PHONE_NUMBER>650.124.8234</PHONE_NUMBER>
<HIRE_DATE>1999. 4. 10 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>133</EMPLOYEE_ID>
<LAST_NAME>Mallin</LAST_NAME>
<EMAIL>JMALLIN</EMAIL>
<PHONE_NUMBER>650.127.1934</PHONE_NUMBER>
<HIRE_DATE>1996. 6. 14 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>134</EMPLOYEE_ID>
<LAST_NAME>Rogers</LAST_NAME>
<EMAIL>MROGERS</EMAIL>
<PHONE_NUMBER>650.127.1834</PHONE_NUMBER>
<HIRE_DATE>1998. 8. 26 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>135</EMPLOYEE_ID>
<LAST_NAME>Gee</LAST_NAME>
<EMAIL>KGEE</EMAIL>
<PHONE_NUMBER>650.127.1734</PHONE_NUMBER>
<HIRE_DATE>1999. 12. 12 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>136</EMPLOYEE_ID>
<LAST_NAME>Philtanker</LAST_NAME>
<EMAIL>HPHILTAN</EMAIL>
<PHONE_NUMBER>650.127.1634</PHONE_NUMBER>
<HIRE_DATE>2000. 2. 6 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>137</EMPLOYEE_ID>
<LAST_NAME>Ladwig</LAST_NAME>
<EMAIL>RLADWIG</EMAIL>
<PHONE_NUMBER>650.121.1234</PHONE_NUMBER>
<HIRE_DATE>1995. 7. 14 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>138</EMPLOYEE_ID>
<LAST_NAME>Stiles</LAST_NAME>
<EMAIL>SSTILES</EMAIL>
<PHONE_NUMBER>650.121.2034</PHONE_NUMBER>
<HIRE_DATE>1997. 10. 26 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>139</EMPLOYEE_ID>
<LAST_NAME>Seo</LAST_NAME>
<EMAIL>JSEO</EMAIL>
<PHONE_NUMBER>650.121.2019</PHONE_NUMBER>
<HIRE_DATE>1998. 2. 12 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>140</EMPLOYEE_ID>
<LAST_NAME>Patel</LAST_NAME>
<EMAIL>JPATEL</EMAIL>
<PHONE_NUMBER>650.121.1834</PHONE_NUMBER>
<HIRE_DATE>1998. 4. 6 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>141</EMPLOYEE_ID>
<LAST_NAME>Rajs</LAST_NAME>
<EMAIL>TRAJS</EMAIL>
<PHONE_NUMBER>650.121.8009</PHONE_NUMBER>
<HIRE_DATE>1995. 10. 17 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>142</EMPLOYEE_ID>
<LAST_NAME>Davies</LAST_NAME>
<EMAIL>CDAVIES</EMAIL>
<PHONE_NUMBER>650.121.2994</PHONE_NUMBER>
<HIRE_DATE>1997. 1. 29 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>143</EMPLOYEE_ID>
<LAST_NAME>Matos</LAST_NAME>
<EMAIL>RMATOS</EMAIL>
<PHONE_NUMBER>650.121.2874</PHONE_NUMBER>
<HIRE_DATE>1998. 3. 15 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>144</EMPLOYEE_ID>
<LAST_NAME>Vargas</LAST_NAME>
<EMAIL>PVARGAS</EMAIL>
<PHONE_NUMBER>650.121.2004</PHONE_NUMBER>
<HIRE_DATE>1998. 7. 9 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>145</EMPLOYEE_ID>
<LAST_NAME>Russell</LAST_NAME>
<EMAIL>JRUSSEL</EMAIL>
<PHONE_NUMBER>011.44.1344.429268</PHONE_NUMBER>
<HIRE_DATE>1996. 10. 1 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>146</EMPLOYEE_ID>
<LAST_NAME>Partners</LAST_NAME>
<EMAIL>KPARTNER</EMAIL>
<PHONE_NUMBER>011.44.1344.467268</PHONE_NUMBER>
<HIRE_DATE>1997. 1. 5 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>147</EMPLOYEE_ID>
<LAST_NAME>Errazuriz</LAST_NAME>
<EMAIL>AERRAZUR</EMAIL>
<PHONE_NUMBER>011.44.1344.429278</PHONE_NUMBER>
<HIRE_DATE>1997. 3. 10 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>148</EMPLOYEE_ID>
<LAST_NAME>Cambrault</LAST_NAME>
<EMAIL>GCAMBRAU</EMAIL>
<PHONE_NUMBER>011.44.1344.619268</PHONE_NUMBER>
<HIRE_DATE>1999. 10. 15 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>149</EMPLOYEE_ID>
<LAST_NAME>Zlotkey</LAST_NAME>
<EMAIL>EZLOTKEY</EMAIL>
<PHONE_NUMBER>011.44.1344.429018</PHONE_NUMBER>
<HIRE_DATE>2000. 1. 29 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>150</EMPLOYEE_ID>
<LAST_NAME>Tucker</LAST_NAME>
<EMAIL>PTUCKER</EMAIL>
<PHONE_NUMBER>011.44.1344.129268</PHONE_NUMBER>
<HIRE_DATE>1997. 1. 30 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>151</EMPLOYEE_ID>
<LAST_NAME>Bernstein</LAST_NAME>
<EMAIL>DBERNSTE</EMAIL>
<PHONE_NUMBER>011.44.1344.345268</PHONE_NUMBER>
<HIRE_DATE>1997. 3. 24 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>152</EMPLOYEE_ID>
<LAST_NAME>Hall</LAST_NAME>
<EMAIL>PHALL</EMAIL>
<PHONE_NUMBER>011.44.1344.478968</PHONE_NUMBER>
<HIRE_DATE>1997. 8. 20 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>153</EMPLOYEE_ID>
<LAST_NAME>Olsen</LAST_NAME>
<EMAIL>COLSEN</EMAIL>
<PHONE_NUMBER>011.44.1344.498718</PHONE_NUMBER>
<HIRE_DATE>1998. 3. 30 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>154</EMPLOYEE_ID>
<LAST_NAME>Cambrault</LAST_NAME>
<EMAIL>NCAMBRAU</EMAIL>
<PHONE_NUMBER>011.44.1344.987668</PHONE_NUMBER>
<HIRE_DATE>1998. 12. 9 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>155</EMPLOYEE_ID>
<LAST_NAME>Tuvault</LAST_NAME>
<EMAIL>OTUVAULT</EMAIL>
<PHONE_NUMBER>011.44.1344.486508</PHONE_NUMBER>
<HIRE_DATE>1999. 11. 23 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>156</EMPLOYEE_ID>
<LAST_NAME>King</LAST_NAME>
<EMAIL>JKING</EMAIL>
<PHONE_NUMBER>011.44.1345.429268</PHONE_NUMBER>
<HIRE_DATE>1996. 1. 30 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>157</EMPLOYEE_ID>
<LAST_NAME>Sully</LAST_NAME>
<EMAIL>PSULLY</EMAIL>
<PHONE_NUMBER>011.44.1345.929268</PHONE_NUMBER>
<HIRE_DATE>1996. 3. 4 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>158</EMPLOYEE_ID>
<LAST_NAME>McEwen</LAST_NAME>
<EMAIL>AMCEWEN</EMAIL>
<PHONE_NUMBER>011.44.1345.829268</PHONE_NUMBER>
<HIRE_DATE>1996. 8. 1 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>159</EMPLOYEE_ID>
<LAST_NAME>Smith</LAST_NAME>
<EMAIL>LSMITH</EMAIL>
<PHONE_NUMBER>011.44.1345.729268</PHONE_NUMBER>
<HIRE_DATE>1997. 3. 10 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>160</EMPLOYEE_ID>
<LAST_NAME>Doran</LAST_NAME>
<EMAIL>LDORAN</EMAIL>
<PHONE_NUMBER>011.44.1345.629268</PHONE_NUMBER>
<HIRE_DATE>1997. 12. 15 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>161</EMPLOYEE_ID>
<LAST_NAME>Sewall</LAST_NAME>
<EMAIL>SSEWALL</EMAIL>
<PHONE_NUMBER>011.44.1345.529268</PHONE_NUMBER>
<HIRE_DATE>1998. 11. 3 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>162</EMPLOYEE_ID>
<LAST_NAME>Vishney</LAST_NAME>
<EMAIL>CVISHNEY</EMAIL>
<PHONE_NUMBER>011.44.1346.129268</PHONE_NUMBER>
<HIRE_DATE>1997. 11. 11 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>163</EMPLOYEE_ID>
<LAST_NAME>Greene</LAST_NAME>
<EMAIL>DGREENE</EMAIL>
<PHONE_NUMBER>011.44.1346.229268</PHONE_NUMBER>
<HIRE_DATE>1999. 3. 19 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>164</EMPLOYEE_ID>
<LAST_NAME>Marvins</LAST_NAME>
<EMAIL>MMARVINS</EMAIL>
<PHONE_NUMBER>011.44.1346.329268</PHONE_NUMBER>
<HIRE_DATE>2000. 1. 24 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>165</EMPLOYEE_ID>
<LAST_NAME>Lee</LAST_NAME>
<EMAIL>DLEE</EMAIL>
<PHONE_NUMBER>011.44.1346.529268</PHONE_NUMBER>
<HIRE_DATE>2000. 2. 23 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>166</EMPLOYEE_ID>
<LAST_NAME>Ande</LAST_NAME>
<EMAIL>SANDE</EMAIL>
<PHONE_NUMBER>011.44.1346.629268</PHONE_NUMBER>
<HIRE_DATE>2000. 3. 24 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>167</EMPLOYEE_ID>
<LAST_NAME>Banda</LAST_NAME>
<EMAIL>ABANDA</EMAIL>
<PHONE_NUMBER>011.44.1346.729268</PHONE_NUMBER>
<HIRE_DATE>2000. 4. 21 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>168</EMPLOYEE_ID>
<LAST_NAME>Ozer</LAST_NAME>
<EMAIL>LOZER</EMAIL>
<PHONE_NUMBER>011.44.1343.929268</PHONE_NUMBER>
<HIRE_DATE>1997. 3. 11 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>169</EMPLOYEE_ID>
<LAST_NAME>Bloom</LAST_NAME>
<EMAIL>HBLOOM</EMAIL>
<PHONE_NUMBER>011.44.1343.829268</PHONE_NUMBER>
<HIRE_DATE>1998. 3. 23 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>170</EMPLOYEE_ID>
<LAST_NAME>Fox</LAST_NAME>
<EMAIL>TFOX</EMAIL>
<PHONE_NUMBER>011.44.1343.729268</PHONE_NUMBER>
<HIRE_DATE>1998. 1. 24 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>171</EMPLOYEE_ID>
<LAST_NAME>Smith</LAST_NAME>
<EMAIL>WSMITH</EMAIL>
<PHONE_NUMBER>011.44.1343.629268</PHONE_NUMBER>
<HIRE_DATE>1999. 2. 23 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>172</EMPLOYEE_ID>
<LAST_NAME>Bates</LAST_NAME>
<EMAIL>EBATES</EMAIL>
<PHONE_NUMBER>011.44.1343.529268</PHONE_NUMBER>
<HIRE_DATE>1999. 3. 24 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>173</EMPLOYEE_ID>
<LAST_NAME>Kumar</LAST_NAME>
<EMAIL>SKUMAR</EMAIL>
<PHONE_NUMBER>011.44.1343.329268</PHONE_NUMBER>
<HIRE_DATE>2000. 4. 21 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>174</EMPLOYEE_ID>
<LAST_NAME>Abel</LAST_NAME>
<EMAIL>EABEL</EMAIL>
<PHONE_NUMBER>011.44.1644.429267</PHONE_NUMBER>
<HIRE_DATE>1996. 5. 11 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>175</EMPLOYEE_ID>
<LAST_NAME>Hutton</LAST_NAME>
<EMAIL>AHUTTON</EMAIL>
<PHONE_NUMBER>011.44.1644.429266</PHONE_NUMBER>
<HIRE_DATE>1997. 3. 19 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>176</EMPLOYEE_ID>
<LAST_NAME>Taylor</LAST_NAME>
<EMAIL>JTAYLOR</EMAIL>
<PHONE_NUMBER>011.44.1644.429265</PHONE_NUMBER>
<HIRE_DATE>1998. 3. 24 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>177</EMPLOYEE_ID>
<LAST_NAME>Livingston</LAST_NAME>
<EMAIL>JLIVINGS</EMAIL>
<PHONE_NUMBER>011.44.1644.429264</PHONE_NUMBER>
<HIRE_DATE>1998. 4. 23 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>178</EMPLOYEE_ID>
<LAST_NAME>Grant</LAST_NAME>
<EMAIL>KGRANT</EMAIL>
<PHONE_NUMBER>011.44.1644.429263</PHONE_NUMBER>
<HIRE_DATE>1999. 5. 24 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>179</EMPLOYEE_ID>
<LAST_NAME>Johnson</LAST_NAME>
<EMAIL>CJOHNSON</EMAIL>
<PHONE_NUMBER>011.44.1644.429262</PHONE_NUMBER>
<HIRE_DATE>2000. 1. 4 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>180</EMPLOYEE_ID>
<LAST_NAME>Taylor</LAST_NAME>
<EMAIL>WTAYLOR</EMAIL>
<PHONE_NUMBER>650.507.9876</PHONE_NUMBER>
<HIRE_DATE>1998. 1. 24 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>181</EMPLOYEE_ID>
<LAST_NAME>Fleaur</LAST_NAME>
<EMAIL>JFLEAUR</EMAIL>
<PHONE_NUMBER>650.507.9877</PHONE_NUMBER>
<HIRE_DATE>1998. 2. 23 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>182</EMPLOYEE_ID>
<LAST_NAME>Sullivan</LAST_NAME>
<EMAIL>MSULLIVA</EMAIL>
<PHONE_NUMBER>650.507.9878</PHONE_NUMBER>
<HIRE_DATE>1999. 6. 21 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>183</EMPLOYEE_ID>
<LAST_NAME>Geoni</LAST_NAME>
<EMAIL>GGEONI</EMAIL>
<PHONE_NUMBER>650.507.9879</PHONE_NUMBER>
<HIRE_DATE>2000. 2. 3 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>184</EMPLOYEE_ID>
<LAST_NAME>Sarchand</LAST_NAME>
<EMAIL>NSARCHAN</EMAIL>
<PHONE_NUMBER>650.509.1876</PHONE_NUMBER>
<HIRE_DATE>1996. 1. 27 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>185</EMPLOYEE_ID>
<LAST_NAME>Bull</LAST_NAME>
<EMAIL>ABULL</EMAIL>
<PHONE_NUMBER>650.509.2876</PHONE_NUMBER>
<HIRE_DATE>1997. 2. 20 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>186</EMPLOYEE_ID>
<LAST_NAME>Dellinger</LAST_NAME>
<EMAIL>JDELLING</EMAIL>
<PHONE_NUMBER>650.509.3876</PHONE_NUMBER>
<HIRE_DATE>1998. 6. 24 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>187</EMPLOYEE_ID>
<LAST_NAME>Cabrio</LAST_NAME>
<EMAIL>ACABRIO</EMAIL>
<PHONE_NUMBER>650.509.4876</PHONE_NUMBER>
<HIRE_DATE>1999. 2. 7 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>188</EMPLOYEE_ID>
<LAST_NAME>Chung</LAST_NAME>
<EMAIL>KCHUNG</EMAIL>
<PHONE_NUMBER>650.505.1876</PHONE_NUMBER>
<HIRE_DATE>1997. 6. 14 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>189</EMPLOYEE_ID>
<LAST_NAME>Dilly</LAST_NAME>
<EMAIL>JDILLY</EMAIL>
<PHONE_NUMBER>650.505.2876</PHONE_NUMBER>
<HIRE_DATE>1997. 8. 13 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>190</EMPLOYEE_ID>
<LAST_NAME>Gates</LAST_NAME>
<EMAIL>TGATES</EMAIL>
<PHONE_NUMBER>650.505.3876</PHONE_NUMBER>
<HIRE_DATE>1998. 7. 11 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>191</EMPLOYEE_ID>
<LAST_NAME>Perkins</LAST_NAME>
<EMAIL>RPERKINS</EMAIL>
<PHONE_NUMBER>650.505.4876</PHONE_NUMBER>
<HIRE_DATE>1999. 12. 19 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>192</EMPLOYEE_ID>
<LAST_NAME>Bell</LAST_NAME>
<EMAIL>SBELL</EMAIL>
<PHONE_NUMBER>650.501.1876</PHONE_NUMBER>
<HIRE_DATE>1996. 2. 4 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>193</EMPLOYEE_ID>
<LAST_NAME>Everett</LAST_NAME>
<EMAIL>BEVERETT</EMAIL>
<PHONE_NUMBER>650.501.2876</PHONE_NUMBER>
<HIRE_DATE>1997. 3. 3 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>194</EMPLOYEE_ID>
<LAST_NAME>McCain</LAST_NAME>
<EMAIL>SMCCAIN</EMAIL>
<PHONE_NUMBER>650.501.3876</PHONE_NUMBER>
<HIRE_DATE>1998. 7. 1 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>195</EMPLOYEE_ID>
<LAST_NAME>Jones</LAST_NAME>
<EMAIL>VJONES</EMAIL>
<PHONE_NUMBER>650.501.4876</PHONE_NUMBER>
<HIRE_DATE>1999. 3. 17 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>196</EMPLOYEE_ID>
<LAST_NAME>Walsh</LAST_NAME>
<EMAIL>AWALSH</EMAIL>
<PHONE_NUMBER>650.507.9811</PHONE_NUMBER>
<HIRE_DATE>1998. 4. 24 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>197</EMPLOYEE_ID>
<LAST_NAME>Feeney</LAST_NAME>
<EMAIL>KFEENEY</EMAIL>
<PHONE_NUMBER>650.507.9822</PHONE_NUMBER>
<HIRE_DATE>1998. 5. 23 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>198</EMPLOYEE_ID>
<LAST_NAME>OConnell</LAST_NAME>
<EMAIL>DOCONNEL</EMAIL>
<PHONE_NUMBER>650.507.9833</PHONE_NUMBER>
<HIRE_DATE>1999. 6. 21 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>199</EMPLOYEE_ID>
<LAST_NAME>Grant</LAST_NAME>
<EMAIL>DGRANT</EMAIL>
<PHONE_NUMBER>650.507.9844</PHONE_NUMBER>
<HIRE_DATE>2000. 1. 13 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>200</EMPLOYEE_ID>
<LAST_NAME>Whalen</LAST_NAME>
<EMAIL>JWHALEN</EMAIL>
<PHONE_NUMBER>515.123.4444</PHONE_NUMBER>
<HIRE_DATE>1987. 9. 17 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>201</EMPLOYEE_ID>
<LAST_NAME>Hartstein</LAST_NAME>
<EMAIL>MHARTSTE</EMAIL>
<PHONE_NUMBER>515.123.5555</PHONE_NUMBER>
<HIRE_DATE>1996. 2. 17 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>202</EMPLOYEE_ID>
<LAST_NAME>Fay</LAST_NAME>
<EMAIL>PFAY</EMAIL>
<PHONE_NUMBER>603.123.6666</PHONE_NUMBER>
<HIRE_DATE>1997. 8. 17 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>203</EMPLOYEE_ID>
<LAST_NAME>Mavris</LAST_NAME>
<EMAIL>SMAVRIS</EMAIL>
<PHONE_NUMBER>515.123.7777</PHONE_NUMBER>
<HIRE_DATE>1994. 6. 7 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>204</EMPLOYEE_ID>
<LAST_NAME>Baer</LAST_NAME>
<EMAIL>HBAER</EMAIL>
<PHONE_NUMBER>515.123.8888</PHONE_NUMBER>
<HIRE_DATE>1994. 6. 7 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>205</EMPLOYEE_ID>
<LAST_NAME>Higgins</LAST_NAME>
<EMAIL>SHIGGINS</EMAIL>
<PHONE_NUMBER>515.123.8080</PHONE_NUMBER>
<HIRE_DATE>1994. 6. 7 오전 12:00:00</HIRE_DATE>
</ROW>
<ROW>
<EMPLOYEE_ID>206</EMPLOYEE_ID>
<LAST_NAME>Gietz</LAST_NAME>
<EMAIL>WGIETZ</EMAIL>
<PHONE_NUMBER>515.123.8181</PHONE_NUMBER>
<HIRE_DATE>1994. 6. 7 오전 12:00:00</HIRE_DATE>
</ROW>
</ROWSET>
728x90
반응형
'Web > JQuery' 카테고리의 다른 글
[JQ]체크박스 (0) | 2020.08.06 |
---|---|
[JQ]ajax_02 (0) | 2020.08.05 |
[JQ]delete (0) | 2020.08.05 |
[JQ]wrap (0) | 2020.08.05 |
[JQ]외부삽입 (0) | 2020.08.04 |