<%@ page contentType="text/html; charset=UTF-8" language="java" import="java.sql.*" errorPage="..\errorPage.htm" %>
<%@ page import = "petrel.*,com.ceic.ResultSets.*"%><%
System.out.println("1--------------------------------");
//get contact page info
String givenName = request.getParameter("givenName");
String lastName = request.getParameter("lastName");
String chineseName = "null";
String companyName = request.getParameter("companyName");
String title = request.getParameter("title");
String role = request.getParameter("role");
String TelNo = request.getParameter("Main_countryCode")+"-"+request.getParameter("Main_areaCode")+"-"+request.getParameter("Main_telNo");
String ExtNo = request.getParameter("ExtNo");
String MobNo = request.getParameter("Mob_countryCode")+"-"+request.getParameter("Mob_areaCode")+"-"+request.getParameter("Mob_telNo");
String FaxNo = request.getParameter("Fax_countryCode")+"-"+request.getParameter("Fax_areaCode")+"-"+request.getParameter("Fax_telNo");
String email = request.getParameter("email");
String country = request.getParameter("Country");
String stateOrProvince = request.getParameter("stateOrProvince");
String city = request.getParameter("city");
String address = request.getParameter("address");
String zipCode = request.getParameter("zipCode");
String recordNo = request.getParameter("RecordNo");
session.setAttribute("recordNo",recordNo);
//judge if the name is null
String errormsg="";
if((givenName==null)||(givenName.trim().length()==0)||(companyName==null)||(companyName.trim().length()==0))
{
errormsg = "Given Name Or Company Name can not be null!";
ErrorMsg.CreateMsg(request,response,errormsg,"ContactNew.jsp");
}else{
//connect to database,judge if the customer exists
Result rs = ResultFactory.getResult("Vector");
rs.setConnType("jdbc");
String checkSql = "select * from Contact where GivenName='"+givenName+"' and CompanyName='"+companyName+"'";
rs.setSql(checkSql);
System.out.println("1a");
rs.Create();
System.out.println("a2");
boolean find = false;
if (rs.next())
{
find = true;
System.out.println("3a");
errormsg = "This person has already existed, please use another name";
ErrorMsg.CreateMsg(request,response,errormsg,"ContactNew.jsp");
}
rs.close();
System.out.println("4a");
if(!find)
{
Result insertRs = ResultFactory.getResult("Vector");
insertRs.setConnType("Vector");
String sql = "insert into Contact values('"+givenName+"','"+companyName+"','"+recordNo+"','"+lastName+"','"+chineseName+"','"+title
+"','"+role+"','"+TelNo+"','"+ExtNo+"','"+MobNo+"','"+FaxNo+"','"+email+"','"+country+"','"+stateOrProvince
+"','"+city+"','"+address+"','"+zipCode+"')";
insertRs.setConnType("jdbc");
insertRs.setSql(sql,ResultInfo.INSERT);
insertRs.Update();
System.out.println("a5");
// boolean ok=insertRs.Update();
insertRs.close();
insertRs = null;
// if(ok)
// {
// errormsg = "Insert a person successfully!";
// System.out.println("6a");
%>
<jsp:forward page="ContactNew.jsp">
<jsp:param name = "RecordNo" value="<%= recordNo%>" />
</jsp:forward> <%
// }else
// {
// System.out.println("7a");
// errormsg= "Insert a person failed!some illegal character existed or databased duplicated.";
// ErrorMsg.CreateMsg(request,response,errormsg,"ContactNew.jsp");
// }
System.out.println("8a"); }
}%>
<%@ page import = "petrel.*,com.ceic.ResultSets.*"%><%
System.out.println("1--------------------------------");
//get contact page info
String givenName = request.getParameter("givenName");
String lastName = request.getParameter("lastName");
String chineseName = "null";
String companyName = request.getParameter("companyName");
String title = request.getParameter("title");
String role = request.getParameter("role");
String TelNo = request.getParameter("Main_countryCode")+"-"+request.getParameter("Main_areaCode")+"-"+request.getParameter("Main_telNo");
String ExtNo = request.getParameter("ExtNo");
String MobNo = request.getParameter("Mob_countryCode")+"-"+request.getParameter("Mob_areaCode")+"-"+request.getParameter("Mob_telNo");
String FaxNo = request.getParameter("Fax_countryCode")+"-"+request.getParameter("Fax_areaCode")+"-"+request.getParameter("Fax_telNo");
String email = request.getParameter("email");
String country = request.getParameter("Country");
String stateOrProvince = request.getParameter("stateOrProvince");
String city = request.getParameter("city");
String address = request.getParameter("address");
String zipCode = request.getParameter("zipCode");
String recordNo = request.getParameter("RecordNo");
session.setAttribute("recordNo",recordNo);
//judge if the name is null
String errormsg="";
if((givenName==null)||(givenName.trim().length()==0)||(companyName==null)||(companyName.trim().length()==0))
{
errormsg = "Given Name Or Company Name can not be null!";
ErrorMsg.CreateMsg(request,response,errormsg,"ContactNew.jsp");
}else{
//connect to database,judge if the customer exists
Result rs = ResultFactory.getResult("Vector");
rs.setConnType("jdbc");
String checkSql = "select * from Contact where GivenName='"+givenName+"' and CompanyName='"+companyName+"'";
rs.setSql(checkSql);
System.out.println("1a");
rs.Create();
System.out.println("a2");
boolean find = false;
if (rs.next())
{
find = true;
System.out.println("3a");
errormsg = "This person has already existed, please use another name";
ErrorMsg.CreateMsg(request,response,errormsg,"ContactNew.jsp");
}
rs.close();
System.out.println("4a");
if(!find)
{
Result insertRs = ResultFactory.getResult("Vector");
insertRs.setConnType("Vector");
String sql = "insert into Contact values('"+givenName+"','"+companyName+"','"+recordNo+"','"+lastName+"','"+chineseName+"','"+title
+"','"+role+"','"+TelNo+"','"+ExtNo+"','"+MobNo+"','"+FaxNo+"','"+email+"','"+country+"','"+stateOrProvince
+"','"+city+"','"+address+"','"+zipCode+"')";
insertRs.setConnType("jdbc");
insertRs.setSql(sql,ResultInfo.INSERT);
insertRs.Update();
System.out.println("a5");
// boolean ok=insertRs.Update();
insertRs.close();
insertRs = null;
// if(ok)
// {
// errormsg = "Insert a person successfully!";
// System.out.println("6a");
%>
<jsp:forward page="ContactNew.jsp">
<jsp:param name = "RecordNo" value="<%= recordNo%>" />
</jsp:forward> <%
// }else
// {
// System.out.println("7a");
// errormsg= "Insert a person failed!some illegal character existed or databased duplicated.";
// ErrorMsg.CreateMsg(request,response,errormsg,"ContactNew.jsp");
// }
System.out.println("8a"); }
}%>
解决方案 »
- 新手求助!!!!!!!!!!!
- struts2+jsp 怎么实现动态树??
- 不显示删除回复显示所有回复显示星级回复显示得分回复 请教!!!!eclipse rap中如何加入Jsp页面?请高手指点,谢谢
- [虚心请教:] tomcat下一个简单的jsp例子,errhandler抛出的异常在errorPage中如何捕捉??
- 可能是hibernate的缓存导致的问题,在线等
- http://community.csdn.net/Expert/PostNew.asp?room=5409与http://www.xxxx.com/shop/570906都是如何实现的
- winxp下不能安装ms sql2000是什么原因?
- 急需技术人员!
- Servlet程序和web.xml文件的关系如何,下面程序为何出错???
- 分布式数据库
- 一个刷新jsp的问题!
- 实现几个编码版本的语言包?但公用bean没法解决?
<jsp:forward page="ContactNew.jsp">
<jsp:param name = "RecordNo" value="<%= recordNo%>" />
</jsp:forward>