action1.java

企业进销存管理系统

package action;

import java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

public class action1 extends Action{

	public ActionForward execute(ActionMapping mapping,ActionForm form,
			HttpServletRequest request,HttpServletResponse response)
	throws IOException,ServletException{
	//public void insmethod(HttpServletRequest request) {

		/*
		 * 
		 * String wareid=myform.getWareid(); String
		 * warename=myform.getWarename(); String standard=myform.getWareid();
		 * String unit=myform.getWarename(); String rate=myform.getWareid();
		 */

		String sflag = request.getParameter("flag");// get flag

		String wareid = request.getParameter("wareid");
		String warename = request.getParameter("warename");
		String standard = request.getParameter("standard");
		String unit = request.getParameter("unit");
		String rate = request.getParameter("rate");

		if (warename != null) {
			byte p[];
			try {
				p = warename.getBytes("8859_1");
				warename = new String(p, 0, p.length, "UTF-8");
			} catch (UnsupportedEncodingException e) {
				e.printStackTrace();
			}
		}
		if (standard != null) {
			byte p[];
			try {
				p = standard.getBytes("8859_1");
				standard = new String(p, 0, p.length, "UTF-8");
			} catch (UnsupportedEncodingException e) {
				e.printStackTrace();
			}
		}
		if (unit != null) {
			byte p[];
			try {
				p = unit.getBytes("8859_1");
				unit = new String(p, 0, p.length, "UTF-8");
			} catch (UnsupportedEncodingException e) {
				e.printStackTrace();
			}
		}
		if (rate != null) {
			byte p[];
			try {
				p = rate.getBytes("8859_1");
				rate = new String(p, 0, p.length, "UTF-8");
			} catch (UnsupportedEncodingException e) {
				e.printStackTrace();
			}
		}
		HttpSession session=request.getSession(true);

		if (sflag != null &&sflag.equals("ins")) {
			if(wareid==null||wareid.equals("")){
				session.setAttribute("message", "鍟嗗搧缂栧彿涓嶈兘涓虹┖");
				session.setAttribute("link", "insert.jsp");
				return mapping.findForward("failure");
			}
			if(warename==null||warename.equals("")){
				session.setAttribute("message", "鍟嗗搧鍚嶇О涓嶈兘涓虹┖");
				session.setAttribute("link", "insert.jsp");
				return mapping.findForward("failure");
			}
			if(standard==null||standard.equals("")){
				session.setAttribute("message", "鍟嗗搧瑙勬牸涓嶈兘涓虹┖");
				session.setAttribute("link", "insert.jsp");
				return mapping.findForward("failure");
			}
			if(unit==null||unit.equals("")){
				session.setAttribute("message", "鍟嗗搧鍗曚綅涓嶈兘涓虹┖");
				session.setAttribute("link", "insert.jsp");
				return mapping.findForward("failure");
			}
			if(rate==null||rate.equals("")){
				session.setAttribute("message", "鍟嗗搧鍗曚环涓嶈兘涓虹┖");
				session.setAttribute("link", "insert.jsp");
				return mapping.findForward("failure");
			}
			try {
				Class.forName("oracle.jdbc.driver.OracleDriver");
				Connection conn = DriverManager
						.getConnection("jdbc:oracle:thin:scott/tiger@localhost:1521:database");
				String sql = "select *from waremessage where wareid='"+wareid+"'";

				PreparedStatement psmt = conn.prepareStatement(sql);
				ResultSet re = psmt.executeQuery();
				if(re.next()){
					
				}else{
					try {
						Class.forName("oracle.jdbc.driver.OracleDriver");
						conn = DriverManager
								.getConnection("jdbc:oracle:thin:scott/tiger@localhost:1521:database");
						sql = "insert into waremessage values ('" + wareid
								+ "','" + warename + "','" + standard + "','" + unit
								+ "','" + rate + "')";

						psmt = conn.prepareStatement(sql);
						int record = psmt.executeUpdate();
						System.out.println("锟斤拷锟斤拷晒锟