khinfo.jsp

用于商品进销存管理的BS系统

<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ page import="java.sql.*,java.io.*"%>
<% request.setCharacterEncoding("gb2312");%>

<jsp:useBean id="conn" scope="page" class="com.mingri.dbconn.DBResult" />
<%
	int currid = 0;
	ResultSet rs = null;
	ResultSet rstmp = null;
	String sql = null;
	String Khname = null;
	String Khjc = null;
	String Address = null;
	String Postcode = null;
	String Tel = null;
	String Fax = null;
	String Lxr = null;
	String Lxrtel = null;
	String Email = null;
	String Khyh = null;
	String Yhzh = null;
	rstmp = conn.getResult("select max(id) as maxid from tb_customer");
	rstmp.next();
	currid = rstmp.getInt("maxid")+1;
	Khname = request.getParameter("khname");
	Khjc = request.getParameter("khjc");
	Address = request.getParameter("address");
	Postcode = request.getParameter("postcode");
	Tel = request.getParameter("tel");
	Fax = request.getParameter("fax");
	Lxr = request.getParameter("lxr");
	Lxrtel = request.getParameter("lxrtel");
	Email = request.getParameter("email");
	Khyh = request.getParameter("khyh");
	Yhzh = request.getParameter("yhzh");
	sql = "insert into tb_customer(khname,khjc,address,postcode,tel,fax,lxr,lxrtel,Email,khyh,yhzh) values("+"'"+Khname+"',";
	sql += "'"+Khjc+"','"+Address+"','"+Postcode+"','"+Tel+"','"+Fax+"','"+Lxr+"','"+Lxrtel+"','"+Email+"','"+Khyh+"','"+Yhzh+"')";
	out.println(sql);
	int resu = conn.executeUpdate(sql);
	
	if(resu == 0)
	{
		out.println("<script language='javascript'>alert('登记失败');"+"window.location.href='khinfo.html';</script>");
	}

  else{
   		out.println("<script language='javascript'>alert('登记成功');"+"window.location.href='khinfo.html';</script>");
     }
%>