buy.java

jsp超市管理系统系统,是用经典的MVC设计模式开发的非常适合初学者学习。

package com.myservlet.buy;

import java.io.*;
import java.sql.*;
import javax.servlet.*;	
import javax.servlet.http.*;
import com.dbconn.*;
import com.mybean.*;

public class Buy extends HttpServlet{

	/**
	 * 
	 */
	private static final long serialVersionUID = 121249431739600442L;

	public void doPost(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException {
		
		String	id = req.getParameter("id");
		
		String sql = "SELECT * FROM goods WHERE id = '"+id+"'";
		//System.out.println(sql);	
		ConnManager connManager = new ConnManager();
		Connection conn = connManager.getConnection("market");  		
		PreparedStatement ps = null;
		ResultSet rs = null;
			
		try{
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery(sql);
			
			if(rs.next()){				
				Goods goods = new Goods();
					
				goods.setId(rs.getInt("id"));
				goods.setCode(rs.getString("code"));
				goods.setTname(rs.getString("tname"));
				goods.setAmount(rs.getInt("amount"));
				goods.setBprice(rs.getFloat("bprice"));
				goods.setSprice(rs.getFloat("sprice"));
				goods.setMaker(rs.getString("maker"));
				goods.setArea(rs.getString("area"));
				goods.setRemark(rs.getString("remark"));
				goods.setType(rs.getString("type"));

				req.getSession(true).setAttribute("goods", goods);
			}
		}
		catch(SQLException e){
			System.out.println(e);
		}
		finally{
			try{
				rs.close();
				ps.close();
				conn.close();
			}
			catch(SQLException e){
				System.out.println(e);
			}
			connManager.releaseConnection("market", conn);
		}
		
		resp.sendRedirect("buy/addBuy.jsp");	
	}

	public void doGet(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException {
		doPost(req, resp);
	}
}