useradd.java

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

package com.myservlet.user;

import java.io.*;
import java.sql.*;
import javax.servlet.*;	
import javax.servlet.http.*;

import com.dbconn.*;

public class UserAdd extends HttpServlet{
	
	/**
	 * 
	 */
	private static final long serialVersionUID = 85952605714989157L;


	public void doPost(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
   				  
		String id = request.getParameter("id").trim();
		String name = request.getParameter("name").trim();   	
		String sex = request.getParameter("sex").trim();
		String phone = request.getParameter("phone").trim();
		String pay = request.getParameter("pay").trim();	               	   
		String remark = request.getParameter("remark").trim();
		String status = request.getParameter("status").trim(); 
		String pwd = request.getParameter("pwd").trim();
    	   

	ConnManager connManager = new ConnManager();
	Connection conn = connManager.getConnection("market");
    PreparedStatement ps = null;
    try{																						//lpad('"+id+"','5','0')
    	String sql = "INSERT INTO consumer (id, name, sex, phone, pay, remark, status, pwd) VALUES (lpad('"+id+"','5','0'), '"+name+"', '"+sex+"', '"+phone+"', '"+pay+"', '"+remark+"', '"+status+"', '"+pwd+"')";
    	sql = new String(sql.getBytes("ISO8859-1"), "gbk");
    	System.out.println(sql);
    	ps = conn.prepareStatement(sql);
    	int m = ps.executeUpdate();
    	if(m != 0){
    		request.getSession(true).setAttribute("message4", "添加成功！");
    	}
    	else{
    		request.getSession(true).setAttribute("message4", "添加失败,请重新添加！");
    	}
    }
	catch(SQLException e){
		System.out.println(e);
		request.getSession(true).setAttribute("message4", "添加失败，您输入的ID已存在或输入的数据格式不正确，请重新添加！");
	}
	finally{
		try{
			ps.close();
			conn.close();
		}
		catch(SQLException e){
			System.out.println(e);
		}
		connManager.releaseConnection("market",conn);
	}
	
    RequestDispatcher dispatcher= request.getRequestDispatcher("user/result2.jsp");
    dispatcher.forward(request, response);
}


public void doGet(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
	doPost(request,response);
}

}