OKJSP: Java/JSP QnA

�ҽ� �ϳ�� ּ�� ̤�

�� — Wed, 19 Jun 2013 21:42:32 +0900

function aaaaaa(seq){ if(document.getElementById("Content"+seq).style.display == "none"){ document.getElementById("Content"+seq).style.display = ""; }else{ document.getElementById("Content"+seq).style.display = "none"; } }

��
��

��⼭ seq �� ǹ��ұ��?

�Ѱ�� °ſ� �л��Ű�°� �� ?

�� — Wed, 19 Jun 2013 18:42:27 +0900

�ڹٸ� �̿��Ұ�� ޸� �� ɸ鿡�� Ŭ�� ޽�� ޶� ���  �� °�, ��±�� ϴ°�, �� ϴ°�... �� ? �׸�� Ŭ�� ȿ�� Ž�带 �� °�� 𸣰ڽ��ϴ�. �� Խ��ǰ�� public all(){ String fn = request.getParameter("fn"); . . if(fn.equals("save")){} . . list... } ��Ͱ�� ޽�� ϳ�� fn�� ޾� �� ٽ� list�ѷ��ִ¹�� ɺ�� ޽�带 �� list�޽�� ̷�Ʈ �ϴ¹�� ɸ޽�� ϳ�, list�޽�� ϳ� �̷�� ΰ�� ... ��� ?

�� ߸� �Ȱɱ��?

�ʺ�� — Wed, 19 Jun 2013 18:25:50 +0900

UPDATE

TS_STAFF

SET

NM_USER_KOR = #nm_user_kor#,

NM_USER_ENG = #nm_user_eng#,

NM_USER_CHI = #nm_user_chi#,

NM_BUSINESS = #nm_business#,

ID_JUMIN = #id_jumin#,

ST_SEX = #st_sex#,

NM_AGE = #nm_age#,

NM_NATIONALITY = #nm_nationality#,

NM_ADDRESS = #nm_address#,

NM_TELNO = #nm_telno#,

NM_MOBILE = #nm_mobile#,

NM_EMAIL = #nm_email#,

ID_REGISTER = #id_register#,

DT_REGISTER SYSDATE

WHERE

ID_USER = #id_user#

ORA-00927: �� ȣ

�̷� �� ߴµ�� ߸��Ȱɱ��?

�� 帮�ڽ��ϴ�.

�ۼ�� — Wed, 19 Jun 2013 18:23:44 +0900

ul class="h_list02">

��

�� Ŭ�� Ʒ�� ſ� http://www.bbmarket.co.kr/movePage.do?pName=faq �� մϴ�. �� Ƿ� ��ֽñ� �ٶ��ϴ�. jsp�� Դϴ�. �Ʒ� �ҽ�� 10�� 1�� ˴ϴ�. �� 1�� Ŭ��ϸ� �� °�� 𸣰ڳ׿� �̤�

��
��

�� Ŭ�� ۼ�� ñ�� ֽ��ϴ�.

sinpk19 — Wed, 19 Jun 2013 17:21:14 +0900

��, ��̽�� ۼ� �� Ŀ� �� Ŭ�� ۼ��ϴµ�� ̶� �� Ŭ�� ̽�� ӹ޾Ƽ� �ۼ��ص� �Ǵ°��? �� Ʈ�� ޼ҵ��ε� ��̽�� ӹ�� ʰ� �׳� �� س��Ҵ��.. �� Ŭ�� ̽�� ̳信 ��Ǵ� �ǰ��?

�Խ��ǿ�� ̸�� Ŭ�� 󼼺�� ȭ�� Ѿ�⸦ �ϴ��ε��

�ʺ�� — Wed, 19 Jun 2013 16:31:47 +0900

log4j�ε� �� Ѿ�°� Ȯ�εǰ�

�� System.out.println�ؼ� ��Ȯ��

�и� �� Ѿ�µ� �� ߴµ��

----------------------��Ʈ�ѷ� �κ�-----------------------

@RequestMapping(value = "/client/member/clientMemberView.do")

public ModelAndView clientMemberView(HttpServletRequest request, HttpServletResponse response) throws Exception{

Map parameterMap = this.getParameterMap(request);

String id_user = parameterMap.get("id_user").toString();

cmbModel = clientMemberService.getClientMemberView(id_user);

System.out.println("cmbmodel = " + cmbModel);

Map map = new HashMap();

map.put("id_user", id_user);

System.out.println("View = "+ map);

ModelAndView mnv = new ModelAndView();

mnv.setViewName("/client/member/clientMemberView");

mnv.addAllObjects(map);

return mnv;

}

---------------------jsp �κ�(��ȭ�� °�)--------------

<%@page import="com.tlf.tshare.util.TextUtils"%>

<%@page import="com.tlf.tshare.model.ClientMemberModel"%>

<%@page contentType="text/html;charset=utf-8" %>

<%@ page import="java.util.List"%>

ClientMemberModel cmbModel = (ClientMemberModel)request.getAttribute("cmbModel");

String id_user = TextUtils.replaceNull(cmbModel.getId_user(), "");

String nm_user_kor = TextUtils.replaceNull(cmbModel.getNm_user_kor(), "");

String nm_user_eng = TextUtils.replaceNull(cmbModel.getNm_user_eng(), "");

String nm_user_chi = TextUtils.replaceNull(cmbModel.getNm_user_chi(), "");

String nm_business = TextUtils.replaceNull(cmbModel.getNm_business(), "");

String id_jumin = TextUtils.replaceNull(cmbModel.getId_jumin(), "");

String st_sex = TextUtils.replaceNull(cmbModel.getSt_sex(), "");

String nm_age = TextUtils.replaceNull(cmbModel.getNm_age(), "");

String nm_nationality = TextUtils.replaceNull(cmbModel.getNm_nationality(), "");

String nm_address = TextUtils.replaceNull(cmbModel.getNm_address(), "");

String nm_telno = TextUtils.replaceNull(cmbModel.getNm_telno(), "");

String nm_mobile = TextUtils.replaceNull(cmbModel.getNm_mobile(), "");

String nm_email = TextUtils.replaceNull(cmbModel.getNm_email(), "");

String id_register = TextUtils.replaceNull(cmbModel.getId_register(), "");

String dt_register = TextUtils.replaceNull(cmbModel.getDt_register(), "");

"http://www.w3.org/TR/html4/loose.dtd">

��

�󼼺��

��

��	�ѱ�	<%=nm_user_kor %>	��	<%=nm_business %>
	��	<%=nm_user_eng %>	�ֹε�Ϲ�ȣ	<%=id_jumin %>
	��	<%=nm_user_chi %>	��	<%=st_sex %>	��	<%=nm_age %>	��	<%=nm_nationality %>
��ּ�		<%=nm_address %>
��ȭ��ȣ		<%=nm_telno %>		E-mail	<%=nm_email %>
�޴��ȣ		<%=nm_mobile %>		E-mail	<%=nm_email %>
��̵�		<%=id_user %>		��		<%=dt_register %>

----------------------�� κ�------------------------

16:25:01 DEBUG JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:27) - {conn-100009} Connection

16:25:01 DEBUG JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:27) - {conn-100009} Preparing Statement: SELECT ID_USER AS id_user, NM_USER_KOR AS nm_user_kor, NM_USER_ENG AS nm_user_eng, NM_USER_CHI AS nm_user_chi, NM_BUSINESS AS nm_business, ID_JUMIN AS id_jumin, ST_SEX AS st_sex, NM_AGE AS nm_age, NM_NATIONALITY AS nm_nationality, NM_ADDRESS AS nm_address, NM_TELNO AS nm_telno, NM_MOBILE AS nm_mobile, NM_EMAIL AS nm_email, ID_REGISTER AS id_register, DT_REGISTER AS dt_register FROM TS_STAFF WHERE ID_USER = ?

16:25:01 DEBUG JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:27) - {pstm-100010} Executing Statement: SELECT ID_USER AS id_user, NM_USER_KOR AS nm_user_kor, NM_USER_ENG AS nm_user_eng, NM_USER_CHI AS nm_user_chi, NM_BUSINESS AS nm_business, ID_JUMIN AS id_jumin, ST_SEX AS st_sex, NM_AGE AS nm_age, NM_NATIONALITY AS nm_nationality, NM_ADDRESS AS nm_address, NM_TELNO AS nm_telno, NM_MOBILE AS nm_mobile, NM_EMAIL AS nm_email, ID_REGISTER AS id_register, DT_REGISTER AS dt_register FROM TS_STAFF WHERE ID_USER = ?

16:25:01 DEBUG JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:27) - {pstm-100010} Parameters: [test001]

16:25:01 DEBUG JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:27) - {pstm-100010} Types: [java.lang.String]

16:25:01 DEBUG JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:27) - {rset-100011} ResultSet

16:25:01 DEBUG JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:27) - {rset-100011} Header: [ID_USER, NM_USER_KOR, NM_USER_ENG, NM_USER_CHI, NM_BUSINESS, ID_JUMIN, ST_SEX, NM_AGE, NM_NATIONALITY, NM_ADDRESS, NM_TELNO, NM_MOBILE, NM_EMAIL, ID_REGISTER, DT_REGISTER]

16:25:01 DEBUG JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:27) - {rset-100011} Result: [test001, �׽�Ʈ1, test1, ��, si, 88888, m, 28, �ѱ�, �� , 0242422, 01000000, dgdse, systrm, 2013-06-14 13:35:30.0]

cmbmodel = ClientMemberModel [id_user=test001, nm_user_kor=�׽�Ʈ1, nm_user_eng=test1, nm_user_chi=��, nm_business=si, id_jumin=88888, st_sex=m, nm_age=28, nm_nationality=�ѱ�, nm_address=�� , nm_telno=0242422, nm_mobile=01000000, nm_email=dgdse, id_register=systrm, dt_register=2013-06-14 13:35:30.0]

View = {id_user=test001}

6�� 19, 2013 4:25:02 �� org.apache.catalina.core.ApplicationDispatcher invoke

SEVERE: Servlet.service() for servlet jsp threw exception

java.lang.NullPointerException

at org.apache.jsp.pages.client.member.clientMemberView_jsp._jspService(clientMemberView_jsp.java:73)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)

at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487)

at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:412)

at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:339)

at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:240)

at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:258)

at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1174)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:901)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)

at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

6�� 19, 2013 4:25:02 �� org.apache.catalina.core.StandardWrapperValve invoke

SEVERE: Servlet.service() for servlet [spring] in context with path [] threw exception [An exception occurred processing JSP page /pages/client/member/clientMemberView.jsp at line 9

6: <%

7: ClientMemberModel cmbModel = (ClientMemberModel)request.getAttribute("cmbModel");

9: String id_user = TextUtils.replaceNull(cmbModel.getId_user(), "");

10: String nm_user_kor = TextUtils.replaceNull(cmbModel.getNm_user_kor(), "");

11: String nm_user_eng = TextUtils.replaceNull(cmbModel.getNm_user_eng(), "");

12: String nm_user_chi = TextUtils.replaceNull(cmbModel.getNm_user_chi(), "");

�̷�� ߸鼭(500��)

�� ʽ��ϴ�.

�̰͸� �ذ�Ǹ� �ɲ� ��

��° �̰Ŷ�� ϰ� �־ �Ӹ�� ̳׿�

��ü �� 𸣰ڳ׿� �Ф�

��Ե� �Ѱ�� ��

�ۼ�� — Wed, 19 Jun 2013 15:49:28 +0900

��
��

�� Ŭ�� Ʒ�� ſ� http://www.bbmarket.co.kr/movePage.do?pName=faq �� մϴ�. �� Ƿ� ��ֽñ� �ٶ��ϴ�. jsp�� Դϴ�.

�� Խ�� ¥�� ε� ȸ�� κп�� 帱�� ֽ��ϴ�

��ں� — Wed, 19 Jun 2013 15:09:33 +0900

ȸ�� DB�� not null�� ƴ� �� ĭ�̾ DB�� η� ���� ϰ� ��
�� Է°�� ־�� DB�� Ǵµ�
��ĭ�� ĭ�̶� �� 쿡�� fail�� ǳ׿�
�ҽ� ��غ��
jsp

ȸ��

   �̸�:

   ��̵�:


   �н��:

   �н��Ȯ��:

   ��ȭ��ȣ:

   �ڵ��:

   �̸��:@

   �ּ�:

   �ŷ��:

   ��¹�ȣ:




*��Ʈ�ѷ�
@RequestMapping(value="/join.do", method = RequestMethod.POST)
public ModelAndView addMember(@ModelAttribute("Member") Member member, BindingResult result){
  ModelAndView mav = new ModelAndView();
  if(result.hasErrors()){
   mav.setViewName("join");
   return mav;
  }

  context = new ClassPathXmlApplicationContext("/config/applicationContext.xml");
  MemberDaoImpl memberDaoImpl = (MemberDaoImpl) context.getBean("memberDao");

  if(memberDaoImpl.addMember(member)){
   mav.setViewName("success"); // success to add new member; move to index page
  } else {
   mav.setViewName("join");
  }
  return mav;
}

Model

package model;
import org.joda.time.DateTime;

public class Member {
private int usernum;
private String userid;
private String username;
private String password;
private int tel;
private int mobile;
private String email1;
private String email2;
private String address;
private String bank;
private int account;
private DateTime regdate;

public String getUserid() {
  return userid;
}
public void setUserid(String userid) {
  this.userid = userid;
}
public String getUsername() {
  return username;
}
public void setUsername(String username) {
  this.username = username;
}
public String getPassword() {
  return password;
}
public void setPassword(String password) {
  this.password = password;
}
public int getTel() {
  return tel;
}
public void setTel(int tel) {
  this.tel = tel;
}
public int getMobile() {
  return mobile;
}
public void setMobile(int mobile) {
  this.mobile = mobile;
}
public String getEmail1() {
  return email1;
}
public void setEmail1(String email1) {
  this.email1 = email1;
}
public String getEmail2() {
  return email2;
}
public void setEmail2(String email2) {
  this.email2 = email2;
}
public String getAddress() {
  return address;
}
public void setAddress(String address) {
  this.address = address;
}
public String getBank() {
  return bank;
}
public void setBank(String bank) {
  this.bank = bank;
}
public int getAccount() {
  return account;
}
public void setAccount(int account) {
  this.account = account;
}
public DateTime getRegdate() {
  return regdate;
}
public void setRegdate(DateTime regdate) {
  this.regdate = regdate;
}
public int getUsernum() {
  return usernum;
}
public void setUsernum(int usernum) {
  this.usernum = usernum;
}
}

*impl
public boolean updateMember(UpdateModel update){
  sqlMapClientTemplate.update("member.updateMember",update);
  return true;
}

Dao
boolean updateMember(UpdateModel update);

��

  insert into member(userid,
  username, password, tel, mobile, email1, email2, address, bank,
  account, regdate)
  values(#userid#, #username#, #password#, #tel#, #mobile#, #email1#, #email2#,
  #address#, #bank#, #account#, now())

�Դϴ� �ʹ� �μ�� ˼��մϴ�

�� ѱ۹�� 帳�ϴ�

�ֱ�Ӹ� — Wed, 19 Jun 2013 15:04:46 +0900

jsp �� ѱ�� & # 5 0 9 4 8 ; & # 5 1 2 0 4 ; (�ѱ۷� ǥ��Ǿ� ��) �� ·� DB�� ˴ϴ�. �嵥 Ư��ҿ�� ѱ�� ٸ��ҿ�� ·� ��ȯ�Ǿ� ��˴ϴ�. �� ϱ��?

�� ӿ�ũ �� ؼ��

�ۼ�� — Wed, 19 Jun 2013 14:40:59 +0900

�� ӿ�ũ�� ߵ� �ý�� ϰ��ִµ�� ӿ�ũ�� ߵ� �� ý�� ÷�� Ѵٵ簡, �� ҽ�� ƴ϶� JSP �� ߿� �� ߼ҽ� �� ٿ�� ַ� �޽�� ߻��ϳ��? �� ӿ�ũ �� ڵ��Ÿ�� ٸ��?

OKJSP: Java/JSP QnA

�ҽ� �ϳ��� ���ּ��� �̤�

�Ѱ��� ��°ſ� �л��Ű�°� ���� �� �������?

�� ������ ��� �߸� �Ȱɱ��?

������ �帮�ڽ��ϴ�.

���������� ���� Ŭ���� �ۼ��� �ñ��� ���� �ֽ��ϴ�.

�Խ��ǿ��� �̸��� Ŭ���� �󼼺��� ȭ������ �Ѿ�⸦ �ϴ����ε���

�󼼺���

�����Ե� �Ѱ��� �������

���������� �Խ����� ¥�� ���ε� ȸ������ �κп��� �����帱�� �ֽ��ϴ�

ȸ������

������ ���� �� �ѱ۹��� �����帳�ϴ�

������ �����ӿ�ũ ���������� ���ؼ���

�ҽ� �ϳ�� ּ�� ̤�

�Ѱ�� °ſ� �л��Ű�°� �� ?

�� ߸� �Ȱɱ��?

�� 帮�ڽ��ϴ�.

�� Ŭ�� ۼ�� ñ�� ֽ��ϴ�.

�Խ��ǿ�� ̸�� Ŭ�� 󼼺�� ȭ�� Ѿ�⸦ �ϴ��ε��

�󼼺��

��Ե� �Ѱ�� ��

�� Խ�� ¥�� ε� ȸ�� κп�� 帱�� ֽ��ϴ�

ȸ��

�� ѱ۹�� 帳�ϴ�

�� ӿ�ũ �� ؼ��