vuejs, nodejs, mysql

Vue.js는 웹 애플리케이션의 사용자 인터페이스를 만들기 위해 사용하는 오픈 소스 프로그레시브 자바스크립트 프레임워크이다.

사용자 인터페이스를 만들기 위한 프로그레시브 프레임워크

 

 

node.js설치

https://nodejs.org/ko/download/

next계속하고 이부분만 체크 x  하고 설치

---

프로젝트 만들고

자바스크립트 파일 열어서

노트패드에서 열어서 내용 써주기 

var arr45 =[1,2,3,4,5,6,7,8,9,10
			,11,12,13,14,15,16,17,18,19,20
			,21,22,23,24,25,26,27,28,29,30
			,31,32,33,34,35,36,37,38,39
			,40,41,42,43,44,45];

//console.log(Math.random());
for(var i =0; i<100; i++){
	var rnd = parseInt(Math.random()*45);
	var a = arr45[0];
	var b =arr45[rnd];
	arr45[0] =b
	arr45[rnd]=a
}

console.log(arr45[0],arr45[1],arr45[2],arr45[3],arr45[4],arr45[5],arr45[6]);

unction add(a,b){
	return a+b;
}
function minus(a,b){
	return a-b;
	
}
function multiply(a,b){
	return a*b;
	
}
function divide(a,b){
	return a/b;
	
}
var sum =add(1,5);
var min =minus(4,1)
var mul = multiply(1,3);
var div =divide(4,2);
console.log("sum",sum)
console.log("min",min)
console.log("mul",mul)
console.log("div",div)

class Animal {
    constructor() {
        this.age = 1;
    }
    
    getOld() {
        this.age++;
    }
}

//export default Animal;

var a = new Animal();
console.log("a.age", a.age);
a.getOld();
console.log("a.age", a.age);

<package.json>

{
  "name": "hello_nodejs",
  "version": "1.0.0",
  "description": "",
  "main": "main.js",
  "scripts": {
    "test": "echo \"Error: no test specified\" && exit 1"
  },
  "author": "",
  "license": "ISC",
  "type":"module"
}

<main5.js>

import Animal from './main4.js';

var a = new Animal();
console.log("a.age", a.age);
a.getOld();
console.log("a.age", a.age);

<main4.js수정>

class Animal {
    constructor() {
        this.age = 1;
    }
    
    getOld() {
        this.age++;
    }
}

export default Animal;


function main(){
	if(require.main ===module){
		var a = new Animal();
		console.log("a.age", a.age);
		a.getOld();
		console.log("a.age", a.age);
	}
	
	
}

import Animal from './main4.js';

class Cat extends Animal{
	 constructor() {
		super();
        this.ssagaji = false;
    }
    
    onepunch() {
        this.ssagaji =true;
    }
	
}

var c = new Cat();

console.log(c.age);
console.log(c.ssagaji);
c.getOld();
c.onepunch();
console.log(c.age);
console.log(c.ssagaji);

<db연동하기>

npm install --save mariadb

npm update를 하면 여기에 서술된 대로 다시 다운로드가 받아짐 

 

 

다시!!

=> 노드 프로젝트 만들고 그대로 옮겨서 install해주기 

var mysql      = require('mysql');
var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'root',
  password : 'python',
  database : 'python',
  port:3305
});

connection.connect();

connection.query('SELECT * from emp', function (error, results, fields) {
	
  console.log("error:",error);
  console.log("==================================");
  console.log("results:",results);
  console.log("==================================");
	console.log("fields:",fields);
});

connection.end();

아 우리가 필요한건 results라는것을 알 수 있음 

---

<insert>

var mysql      = require('mysql');
var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'root',
  password : 'python',
  database : 'python',
  port:3305
});

connection.connect();

var sql="insert into emp values('3','1','1','1')";
connection.query(sql, function (error, results, fields) {
	console.log("error:", error);
	console.log("==================================");
	console.log("results:", results);
	console.log("==================================");
	console.log("fields:", fields);
 
});

connection.end();

<다른방법>

var mysql      = require('mysql');
var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'root',
  password : 'python',
  database : 'python',
  port:3305
});

connection.connect();

var e_id='3';
var e_name ='3';
var sex ='3';
var addr ='3';

var sql=`
	insert into emp
	(e_id,e_name,sex,addr)
	values
	(${e_id},${e_name},${sex},${addr})
`;
connection.query(sql, function (error, results, fields) {
	console.log("error:", error);
	console.log("==================================");
	console.log("results:", results);
	console.log("==================================");
	console.log("fields:", fields);
 
});

connection.end();

console.log("results:", results.affectedRows);

 

 

---

<update>

var mysql      = require('mysql');
var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'root',
  password : 'python',
  database : 'python',
  port:3305
});

connection.connect();

var sql="update emp set e_name='3', sex='3',addr='3'where e_id='3'" ;
connection.query(sql, function (error, results, fields) {
	console.log("error:", error);
	console.log("==================================");
	console.log("results:", results);
	console.log("==================================");
	console.log("fields:", fields);
 
});

connection.end();

<다른방법>

var e_id='4';
var e_name ='5';
var sex ='5';
var addr ='5';

var sql = `
    update emp 
    set 
        e_name = '${e_name}', 
        sex = '${sex}', 
        addr = '${addr}' 
    where 
        e_id = '${e_id}'
`;

<delete>

var mysql      = require('mysql');
var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'root',
  password : 'python',
  database : 'python',
  port:3305
});

connection.connect();

var sql="delete from emp where e_id='3'" ;
connection.query(sql, function (error, results, fields) {
	console.log("error:", error);
	console.log("==================================");
	console.log("results:", results);
	console.log("==================================");
	console.log("fields:", fields);
 
});

connection.end();

다른방법

var e_id='4'

var sql=`
	delete from emp
	 where e_id='${e_id}'
`;

---

아주 간단한 방법으로 mysql의 쿼리를 동기식으로 처리

=> 나중에 dao를 만들어야하는데 비동기가되면 못만들기에 동기형태로 처리를한다.

<select>

var MySql = require('sync-mysql');
 
var connection = new MySql({
  host     : 'localhost',
  user     : 'root',
  password : 'python',
  database : 'python',
  port     : 3305
});
 
const result = connection.query('SELECT * from emp');
console.log("result",result);

<insert>

var MySql = require('sync-mysql');
 
var connection = new MySql({
  host     : 'localhost',
  user     : 'root',
  password : 'python',
  database : 'python',
  port     : 3305
});
 
var e_id='4';
var e_name ='3';
var sex ='3';
var addr ='3';

var sql=`
	insert into emp
	(e_id,e_name,sex,addr)
	values
	('${e_id}','${e_name}','${sex}','${addr}')
`;

const result = connection.query(sql);
console.log("result",result.affectedRows);

---

<update>

var MySql = require('sync-mysql');
 
var connection = new MySql({
  host     : 'localhost',
  user     : 'root',
  password : 'python',
  database : 'python',
  port     : 3305
});
 
var e_id='4';
var e_name ='5';
var sex ='5';
var addr ='5';

var sql = `
    update emp 
    set 
        e_name = '${e_name}', 
        sex = '${sex}', 
        addr = '${addr}' 
    where 
        e_id = '${e_id}'
`;

const result = connection.query(sql);
console.log("result",result.affectedRows);

---

<delete>

var MySql = require('sync-mysql');
 
var connection = new MySql({
  host     : 'localhost',
  user     : 'root',
  password : 'python',
  database : 'python',
  port     : 3305
});
 
var e_id='4';


var sql = `
   delete from emp
   where
   e_id='${e_id}'
`;

const result = connection.query(sql);
console.log("result",result.affectedRows);