gysinfo.jsp

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

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

<jsp:useBean id="conn" scope="page" class="com.mingri.dbconn.DBResult" />
<%
	// regist.setGysinfo(gysinfo);
	//regist.regist();
	String sql = null;
	String gysname = null;
	String jc = null;
	String address = null;
	String postcode = null;
	String tel = null;
	String fax = null;
	String lxr = null;
	String lxrtel = null;
	String khyh = null;
	String email = null;
	gysname = request.getParameter("gysname");
	jc = request.getParameter("jc");
	address = request.getParameter("address");
	postcode = request.getParameter("postcode");
	tel = request.getParameter("tel");
	fax = request.getParameter("fax");
	lxr = request.getParameter("lxr");
	lxrtel = request.getParameter("lxrtel");
	khyh = request.getParameter("khyh");
	email = request.getParameter("email");
	sql = "insert into tb_supplier(gysname,jc,address,postcode,tel,fax,lxr,lxrtel,khyh,email) values("
			+ "'"
			+ gysname
			+ "','"
			+ jc
			+ "','"
			+ address
			+ "','"
			+ postcode
			+ "','"
			+ tel
			+ "','"
			+ fax
			+ "','"
			+ lxr
			+ "','" + lxrtel + "','" + khyh + "','" + email + "')";
	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>");
	}
%>