간단 프로젝또 10일차

position:relative; 어울려야 할때 빠지션
position:absolute; 혼자 놀때 빠지션

public void delete(HttpServletRequest request, 
HttpServletResponse response) throws Exception
{
	String id = request.getParameter("id");
	String table = request.getParameter("table");
	
	// 그림파일 삭제
	TourDao tdao = new TourDao();
	tdao.file_delete(id, request);
	
	String sql = "delete from "+table+" where id=?";
	
	PreparedStatement pstmt = conn.prepareStatement(sql);
	pstmt.setString(1, id);
	
	pstmt.executeUpdate();
	
	switch(table)
	{
		case "gongji" : response.sendRedirect("glist.jsp"); break;
		case "board" : response.sendRedirect("blist.jsp"); break;
		case "tour" : response.sendRedirect("tlist.jsp"); break;
	}
	
}

sql 실행문에
sum() : 합 // select sum(tprice) from reserve;
avg() : 평균 // select acg(tprice) from reserve;

function rview(my)
	{
		var userid = my.innerText;
		var chk = new XMLHttpRequest();
		
		var x = event.clientX;
		var y = event.clientY;
		
		chk.onload=function()
		{
			document.getElementById("rmsg").style.left=x+"px";
			document.getElementById("rmsg").style.top=y+"px";
			document.getElementById("rmsg").style.visibility="visible";
			document.getElementById("rmsg").innerHTML=chk.responseText.trim();
		}
		
		chk.open("get","getInfo.jsp?userid="+userid)
		chk.send();
	}
	function rhide(my)
	{
		document.getElementById("rmsg").style.visibility="hidden";
	}

이거 졸라 까먹음 적어둬야함