from flask import Flask, request, render_template
from day10.empdao import EmpDao
app = Flask(__name__)
@app.route('/')
@app.route('/emp', methods = ['POST', 'GET'])
def index():
dao = EmpDao()
emp = dao.selects()
return render_template('emp.html', param=emp)
if __name__ == '__main__':
app.run(debug=True)
HTMLํ์ผ์์ ์ ์ฉ์ํค๊ธฐ
<script src="{{url_for('static', filename='jquery-3.6.0.min.js')}}"></script>
<script src="static/jquery-3.6.0.min.js"></script>
.pyํ์ผ์์ ์ ์ฉ์ํค๊ธฐ
app = Flask(__name__, static_url_path='') #.py
<script src="jquery-3.6.0.min.js"></script> #html
๋ ์ค ํ๋์ ๋ฐฉ๋ฒ์ผ๋ก ์ ์ฉํด ์ค ์ ์๋ค.
@app.route('/ajaxone', methods=['POST'])
def ajaxone():
eId = request.form['e_id']
dao = EmpDao()
emp = dao.select(eId)
return jsonify({'emp': emp})
function fn_one(e_id){
var param = {'e_id' : e_id}
$.ajax({
url : "ajaxone",
data : param,
dataType : "json",
type : "post",
async: false,
success : function(res) {
var emp = res.emp;
$('#e_id').val(emp.e_id);
$('#e_name').val(emp.e_name);
$('#sex').val(emp.sex);
$('#addr').val(emp.addr);
}
});
}
@app.route('/ajaxmod', methods=['POST'])
def ajaxmod():
eId = request.form['e_id']
eName = request.form['e_name']
sex = request.form['sex']
addr = request.form['addr']
dao = EmpDao()
cnt = dao.update(eId, eName, sex, addr)
return jsonify({"cnt" : cnt})
function fn_mod(){
var e_id = $('#e_id').val();
var e_name = $('#e_name').val();
var sex = $('#sex').val();
var addr = $('#addr').val();
var param = "";
param += "dummy=" + Math.random();
param += "&e_id=" + e_id;
param += "&e_name=" + e_name;
param += "&sex=" + sex;
param += "&addr=" + addr;
$.ajax({
url : "ajaxmod",
data : param,
dataType : "json",
type : "post",
async: false,
success : function(res) {
var cnt = res.cnt;
if(cnt == 1){
alert("์ ์์ ์ผ๋ก ์์ ๋์์ต๋๋ค.");
fn_list();
$('#e_id').val("");
$('#e_name').val("");
$('#sex').val("");
$('#addr').val("");
}else{
alert("์์ ์คํจํ์์ต๋๋ค.");
}
}
});
}