'분류 전체보기' 카테고리의 글 목록 (11 Page)

23DAY / 2017.05.08
[JDBC] 쿼리 공백 에러 2017.05.01
20DAY / JAVA Script / 카드게임만들기 2017.04.28
19DAY /Bootstrap,CSS 2017.04.27

DriverDB.java

package kr.or.ksmart.driverdb;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

public class DriverDB {

public Connection driverDbcon() throws ClassNotFoundException, SQLException{

System.out.println("driverDbcon DriverDB.java");

Connection reconn = null;

Class.forName("com.mysql.jdbc.Driver");

String jdbcDriver = "포트번호";

String dbUser = "dbid";

String dbPass = "dbpwi";

reconn = DriverManager.getConnection(jdbcDriver, dbUser, dbPass);

return reconn;

}

1) 기존파일 (ex - user_list) 에 import

<%@ page import ="kr.or.ksmart.driverdb.DriverDB" %>

2)드라이버 로딩 부분 삭제 후 입력

DriverDB db = new DriverDB();

conn = db.driverDbcon();

저작자표시

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 'id001'' at line 1

틀린 코드 ▼

수정한 코드▼

query = "select * from tb_member where "+sk+"= ?";

WHERE 조건문에서 공백을 주지않아서 쿼리에러가 발생하였다. 쿼리문장은 sql에서 실행후 복사,붙여넣기 하는것이 좋은것 같다

저작자표시

자바스크립트사용

자바스크립트 변수

변수타입

<!DOCTYPE html>
<html>
<head>
    <meta charset="EUC-KR">
    <title>Insert title here</title>
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
    <script>
    // db -> select -> 배열
    let card = [
                 {num:1,  kind:"spade"}
                ,{num:2,  kind:"spade"}
                ,{num:3,  kind:"spade"}
                ,{num:4,  kind:"spade"}
                ,{num:5,  kind:"spade"}
                ,{num:6,  kind:"spade"}
                ,{num:7,  kind:"spade"}
                ,{num:8,  kind:"spade"}
                ,{num:9,  kind:"spade"}
                ,{num:10, kind:"spade"}
                ,{num:11, kind:"spade"}
                ,{num:12, kind:"spade"}
                ,{num:13, kind:"spade"}
                ,{num:1,  kind:"heart"}
                ,{num:2,  kind:"heart"}
                ,{num:3,  kind:"heart"}
                ,{num:4,  kind:"heart"}
                ,{num:5,  kind:"heart"}
                ,{num:6,  kind:"heart"}
                ,{num:7,  kind:"heart"}
                ,{num:8,  kind:"heart"}
                ,{num:9,  kind:"heart"}
                ,{num:10, kind:"heart"}
                ,{num:11, kind:"heart"}
                ,{num:12, kind:"heart"}
                ,{num:13, kind:"heart"}
                ,{num:1,  kind:"diamond"}
                ,{num:2,  kind:"diamond"}
                ,{num:3,  kind:"diamond"}
                ,{num:4,  kind:"diamond"}
                ,{num:5,  kind:"diamond"}
                ,{num:6,  kind:"diamond"}
                ,{num:7,  kind:"diamond"}
                ,{num:8,  kind:"diamond"}
                ,{num:9,  kind:"diamond"}
                ,{num:10, kind:"diamond"}
                ,{num:11, kind:"diamond"}
                ,{num:12, kind:"diamond"}
                ,{num:13, kind:"diamond"}
                ,{num:1,  kind:"clover"}
                ,{num:2,  kind:"clover"}
                ,{num:3,  kind:"clover"}
                ,{num:4,  kind:"clover"}
                ,{num:5,  kind:"clover"}
                ,{num:6,  kind:"clover"}
                ,{num:7,  kind:"clover"}
                ,{num:8,  kind:"clover"}
                ,{num:9,  kind:"clover"}
                ,{num:10, kind:"clover"}
                ,{num:11, kind:"clover"}
                ,{num:12, kind:"clover"}
                ,{num:13, kind:"clover"}
                ];
    
        window.addEventListener("load",function(){
            let play = document.getElementById("play");
            play.addEventListener("click", function(){
                for(let i=0; i<10000; i++) {
                    let r = Math.floor(Math.random()*card.length); // 0 ~ 3
                    let temp = card[0];
                    card[0] = card[r];
                    card[r] = temp;
                }
                let str ="";
                for(let i=0; i<5; i++) {
                    let fileName = card[i].kind+card[i].num+".JPG";
                    let path = "<img src='./imgs/"+fileName+"'>"; 
                    str += path;
                }
                let result = document.getElementById("result");
                result.innerHTML = str;
            });
        });
        
        
 
        
    </script>
</head>
<body class="container">
    <button id="play" class="btn btn-primary">play</button>
    <div id="result">
    </div>
</body>
</html>