registerimp.java

订餐系统

package Biz;

import java.sql.Connection;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.jsp.jstl.sql.Result;

import Dao.ConnectionManage;
import Dao.SQLCommandBean;

public class registerImp implements BizInterface{
	public String execute(HttpServletRequest request,HttpServletResponse response)
	{
		
		
        String name = (String) request.getParameter("loginName");
        String pass = (String) request.getParameter("loginPass");
		String path = "";
		try
		{
			Connection conn = ConnectionManage.getConnection();
			String sql = "insert Users values('"+name+"','"+pass+"',default)";
			SQLCommandBean sqlCommandBean = new SQLCommandBean();
			sqlCommandBean.setConn(conn);
			sqlCommandBean.setSqlValue(sql);
			int  i = sqlCommandBean.executeUpdate();
			if(i==0)
			{
				
				request.setAttribute("message",new Exception("数据库错误：注册时出错") );				
			}
			else
			{	
				
				path = "login.html";				
			}
		}
		catch(Exception ex)
		{
			request.setAttribute("message",new Exception("数据库错误：注册时出错") );
	        path="message.jsp";
		}
		return path;
	}

}