<%
String n_id1 = request.getParameter("n_id1");
String n_forward_when1 = request.getParameter("n_forward_when1");
String n_forwarding1 = request.getParameter("n_forwarding1");
String db_url="jdbc:mysql://localhost:3306/ippbx";
String db_user = "ippbx";
String db_pass="ippbxrw";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
int chk_update1 = 0;
try {
Class.forName("org.gjt.mm.mysql.Driver");
conn = DriverManager.getConnection(db_url,db_user,db_pass);
stmt = conn.createStatement();
} catch (SQLException e) {
out.println(e);
}
String query1 = "update ippbx_member set" +
" forward_when = '"+ n_forward_when1 +"' "+
", forwarding = '"+ n_forwarding1 +"' " +
" where id = '"+ n_id1 +"'";
chk_update1 = stmt.executeUpdate(query1);
if ( chk_update1 > 0 ) {
%>
<script>
alert("변경 처리 되었습니다.");
location.href="../number/t_select.jsp";
</script>
<%
} else {
%>
<script>
alert("실패했습니다.");
location.href="../number/t_select.jsp";
</script>
<%
}
%>