Page 421 - MDP2020-3

················································································ 명장양성프로젝트 【MDP】 과제발표회 자료집 Ⅲ | 415

4. 소스코드

- DAO.java : SQL을 통해 DB에 데이터 입력

import java.sql.DriverManager;
import java.sql.SQLException;

public class DAO {
public DAO() {
java.sql.Connection conn = null;
java.sql.PreparedStatement pstmt = null;
int score=8; //${score};
try {

String jdbcDriver = "jdbc:mysql://localhost:3306/mdp?" +

"useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&
serverTimezone=UTC&characterEncoding=utf8";
String dbUser = "root";

String dbPass = "apmsetup";
Class.forName("com.mysql.jdbc.Driver");
String SQL = "UPDATE rtconfrontation SET yscore=(?);";

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

pstmt = conn.prepareStatement(SQL);

pstmt.setInt(1, score);

pstmt.execute();
} catch(SQLException ex) {
System.out.println("�����߻�!: "+ex.getMessage());
ex.printStackTrace();
} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block
e.printStackTrace();
}
}
}