by romeoh
메뉴릿
카테고리
전체
JAVAScript
node.js
jQuery
CSS
html5
facebook
Mac
iPhone
Mobile
iPhone Cocos
ActionScript 2.0
ActionScript 3.0
away3D
MSSQL
Server
ASP
영상
3D
ShoppingZone
Design
ShoppingMall
Fashion
GoodSite
자료실
미분류
JAVAScript
node.js
jQuery
CSS
html5
Mac
iPhone
Mobile
iPhone Cocos
ActionScript 2.0
ActionScript 3.0
away3D
MSSQL
Server
ASP
영상
3D
ShoppingZone
Design
ShoppingMall
Fashion
GoodSite
자료실
미분류
최근 등록된 덧글
최근 등록된 트랙백
이전블로그
이글루링크
이글루 파인더
if(window.XMLHttpRequest) xmlhttp = new XMLHttpRequest();
else xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
xmlhttp.open("POST", "response.txt", false);
xmlhttp.onreadystatechange = function (aEvt) {
if(xmlhttp.readyState == 0){
console.log("open매소드 호출되지 않음");
}else if(xmlhttp.readyState == 1){
console.log("send 매소드가 호출 되지 않는 상태");
}else if(xmlhttp.readyState == 2){
console.log("status 와 헤더는 도착하지 않은 상태");
}else if(xmlhttp.readyState == 3){
console.log("데이터 일부를 받은 상태");
}else if(xmlhttp.readyState == 4){
if(xmlhttp.status == 200){
console.log("요청성공");
}else if(xmlhttp.status == 403){
console.log("접근거부");
}else if(xmlhttp.status == 404){
console.log("페이지없음");
}else if(xmlhttp.status == 500){
console.log("서버오류");
}
}
}
xmlhttp.send();
<html>
<meta charset="UTF-8">
<head></head>
<body>
<button id="btnCreate">테이블생성</button>
<button id="btnInsert">insert</button>
<button id="btnUpdate">update</button>
<button id="btnSelect">select</button>
<button id="btnDrop">drop</button>
<script type="text/javascript">
var btnCreate = document.querySelector("#btnCreate");
var btnInsert = document.querySelector("#btnInsert");
var btnUpdate = document.querySelector("#btnUpdate");
var btnSelect = document.querySelector("#btnSelect");
var btnDrop = document.querySelector("#btnDrop");
btnCreate.addEventListener("click", function(){
MPDB.transaction(
function(transaction){
transaction.executeSql("CREATE TABLE romeohTable(idx, userName, pw)", [], dataHandler, errorHandler);
}
)
}, false);
btnInsert.addEventListener("click", function(){
MPDB.transaction(
function(transaction){
transaction.executeSql("INSERT INTO romeohTable(idx, userName, pw) VALUES('1', '백국경', '1Q2W3E')", []);
}
)
}, false);
btnUpdate.addEventListener("click", function(){
MPDB.transaction(
function(transaction){
transaction.executeSql("UPDATE romeohTable SET userName='paek', pw='qwer' where idx='1'", [], dataHandler, errorHandler);
}
)
}, false);
btnSelect.addEventListener("click", function(){
MPDB.transaction(
function(transaction){
transaction.executeSql("SELECT * FROM romeohTable", [], dataSelectHandler, errorHandler);
}
)
}, false);
function dataSelectHandler(req, res){
for(var i=0; i<res.rows.length; i++){
var row = res.rows.item(i);
console.log("idx: " + row["idx"] + " - userName: " + row["userName"] + " - pw: " + row["pw"])
}
}
btnDrop.addEventListener("click", function(){
MPDB.transaction(
function(transaction){
transaction.executeSql("DROP TABLE romeohTable", [], dataHandler, errorHandler);
}
)
}, false);
initDB()
function initDB(){
if(!window.openDatabase){
console.log("local DB 지원 안됨")
}else{
var dbName = "romeoh",
c = "1.0",
displayName = "KIN",
maxSize = 100000;
MPDB = openDatabase(dbName, dbName, displayName, maxSize);
}
}
function dataHandler(){
console.log("성공");
}
function errorHandler(req, err){
if(err.code == 1){
console.log("DB가 존재함");
}else{
console.dir(err.code + " : " + err.message);
}
}
</script>
</body>
</html>
var http = require("http");
http.createServer(fn).listen(8080)
function fn(req, res){
res.writeHead(200, {"Content-Type":"text/plain"});
res.end("hello")
}
console.log("server start...")
| << 이전 페이지 | 다음 페이지 >> |
