20151223--联系人项目 

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="java.util.*" %>
    <%@ page import="com.hanqi.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>联系人</title>

<script type="text/javascript">
function disp_confirm()
  {
  var r = confirm("确定要删除该记录吗？")
  if (r == true)
    {
      response.sendRedirect("FindList");
    }
  }
</script>
</head>
<body>
<a href="FindList">显示全部内容:</a>

<table border="1">

<tr>
<th></th>
<th>姓名</th>
<th>电话</th>
<th>分组</th>
</tr>
<%

Object obj = request.getAttribute("userlist");

if(obj != null)
{
    ArrayList<Bao> array = (ArrayList<Bao>)obj;
    
    //遍历
    for(Bao u : array)
    {
        out.print( "<tr><td>"+ "\t <a onclick='return disp_confirm()' href='Delete?id="+u.getId() + "'>删除</a>"
        +"</td><td>"+ u.getName()+"</td><td>" + u.getTel() + "</td><td>" + u.getGroupId()+"</td></tr>");
    }
    //DeleteUser?       ?是要删除的userid
}
else
{
    out.append("用户列表为空");
}
%>
</table>
<form method="post" action="Baoc" >
<input name="id" type="hidden" value="0" />
<ul>
<li>请输入联系人姓名：<input name="name" type="text" width=30 /></li>

<li>请输入联系人电话号码：<input name="tel" type="text" width=30 /></li>
<li><input type="submit" value="提交" /> <input type="reset" value="取消" /> </li>
</ul>
</form>



</body>
</html>
index.jsp
package com.hanqi;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class Baoc
 */
@WebServlet("/Baoc")
public class Baoc extends HttpServlet {
    private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public Baoc() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        request.setCharacterEncoding("UTF-8");    
        response.setContentType("text/html;charset=UTF-8");
        response.setCharacterEncoding("UTF-8");    
        
        String id = request.getParameter("id");
        String name = request.getParameter("name");
        String tel = request.getParameter("tel");
        
        if(name != null && name.trim().length() > 0)
        {
            //get方式时需要的转码  post方式不需要
//            name = new String(name.getBytes("ISO-8859-1"),"UTF-8");
            
            if(tel != null && tel.trim().length() > 0)
            {
                //调用数据访问层
                //构建实体类  实例化
                Bao m = new Bao();
                m.setId(Integer.parseInt(id));
                m.setName(name);
                m.setTel(tel);
                DAL md = new DAL();
                try 
                {
                    if(md.insert(m) >0)
                    {
                        
                        request.getRequestDispatcher("index.jsp").forward(request,response);
                            
                    }
                    else
                    {
                        response.getWriter().append("保存数据失败");
                    }
                } 
                catch (Exception e)
                {
                    response.getWriter().append("发生错误" + e.getMessage());
                    
                    e.printStackTrace();
                }
            }
            else
            {
                response.getWriter().append("parentid不能为空");
            }
        }
        else
        {
            response.getWriter().append("请正确填写地区名称");
        }
        
        response.getWriter().append("Served at: ").append(request.getContextPath());
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}
数据保存--Baoc.java
package com.hanqi;

import java.util.ArrayList;

public class Bao {

private int id;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }
    
private String Name;
    
    public String getName() {
        return Name;
    }

    public void setName(String name) {
        Name = name;
    }



private String Tel; 
    public String getTel() {
        return Tel;
    }

    public void setTel(String tel) {
        Tel = tel;
    }

private int GroupId;
    public int getGroupId() {
        return GroupId;
    }

    public void setGroupId(int groupId) {
        GroupId = groupId;
    }
    public ArrayList<Bao> getListAll() {
        // TODO 自动生成的方法存根
        return null;
    }
    
}
Bao
package com.hanqi;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;

import com.hanqi.*;

public class DAL
{
    
    //增
        //创建一个实体类 m 并将它放置进去
        public int insert(Bao m) throws Exception
        {
            int rtn = 0;
                
            Connection conn = DB.getConnection();
                
            PreparedStatement pst = null;
                
            if (conn != null)
            {
                try
                {
                    String sql = "insert into CONTACTS (id, Name, TEL,Groupid) values (SQ_C_ID.nextval,?,?,?) ";
                    
                    pst = conn.prepareStatement(sql);
                    
                    pst.setString(1, m.getName());
                    pst.setString(2, m.getTel());
                    pst.setInt(3, m.getGroupId());
                    
                    //将执行结果赋给返回值
                    rtn = pst.executeUpdate();
                }
                catch(Exception ex)
                {
                    throw ex;
                }
                finally
                {
                    try
                    {
                        pst.close();
                    }
                    catch(Exception e) 
                    {
                        conn.close();        
                    }
                    }
                }
                return rtn;
            }
            
            private String getName() {
            return null;
        }

            private int getParentid() {
        // TODO 自动生成的方法存根
        return 0;
    }

            //删
            
            public int delete(int id) throws Exception
            {
                int rtn = 0;
                
                Connection conn = DB.getConnection();
                
                PreparedStatement pst = null;
                
                if (conn != null)
                {
                    try
                    {
                        String sql = "delete CONTACTS where id = ?";
                    
                        pst = conn.prepareStatement(sql);
                    
                        pst.setInt(1, id);
                    
                        rtn = pst.executeUpdate();
                    }
                    catch(Exception ex)
                    {
                        throw ex;
                    }
                    finally
                    {
                        try
                        {
                            pst.close();
                        }
                        catch(Exception e) 
                        {
                            conn.close();        
                        }
                    }
            }
                    
                
                return rtn;
            }
            
            //改
            public int update(Bao user) throws Exception
            {
            int rtn = -1;
            
            Connection conn = DB.getConnection();
            
            PreparedStatement pst = null;
            
            if (conn != null)
            {
                try
                {
                String sql = "update CONTACTS set name = ?,groupid = ? "
                        + "where id = ? ";
                
                pst = conn.prepareStatement(sql);
                
                pst.setInt(3, user.getId());
                pst.setString(1, user.getName());
                pst.setInt(2, user.getGroupId());
                
                rtn = pst.executeUpdate();
            }
                catch(Exception ex)
                {
                    throw ex;
                }
                finally
                {
                try
                {
                    pst.close();
                }
                catch(Exception e) 
                {
                    conn.close();        
                }
                }
            }
            
            return rtn;
        }

            
                //将全部数据全部查出
                public ArrayList<Bao> getListAll() throws Exception
                {
                    ArrayList<Bao> rtn = null;

                    Connection conn = DB.getConnection();
                    
                    PreparedStatement pst = null;
                    
                    if (conn != null)
                    {
                        try
                        {
                        
                        String sql = "select * from CONTACTS";
                        
                        pst = conn.prepareStatement(sql);
                        
                        ResultSet rs = pst.executeQuery();
                        rtn = new ArrayList<Bao>();
                        if(rs != null)
                        {
                            while(rs.next())
                            {
                                Bao u = new Bao();
                                u.setId(rs.getInt("id"));
                                u.setName(rs.getString("name"));
                                u.setTel(rs.getString("tel"));
                                u.setGroupId(rs.getInt("Groupid"));
                                rtn.add(u);        //取一个数就放一个数
                            }
                        }
                        }
                        catch(Exception ex)
                        {
                            throw ex;
                        }
                        finally
                        {
                        try
                        {
                            pst.close();
                        }
                        catch(Exception e) 
                        {
                            conn.close();        
                        }
                        }
                    }
                    return rtn;
                }
                
            }
DAL
package com.hanqi;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.hanqi.*;
/**
 * Servlet implementation class Delete
 */
@WebServlet("/Delete")
public class Delete extends HttpServlet {
    private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public Delete() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        
        
    request.setCharacterEncoding("UTF-8");    
    response.setContentType("text/html;charset=UTF-8");
    response.setCharacterEncoding("UTF-8");    
        
        
    String id = request.getParameter("id");
    DAL ud = new DAL();
    if(id != null && id.trim().length() > 0)
    {
//删除
        try 
        {
            
            ud.delete(Integer.parseInt(id));    //将 id 强制转换为 int 型
            
            response.sendRedirect("FindList");
            
        } 
        catch (Exception e) 
        {
            response.getWriter().append("删除数据失败");
            
            e.printStackTrace();
        }
//删除            
    }
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}
删除--Delete
package com.hanqi;

import java.io.IOException;
import java.util.ArrayList;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.hanqi.*;
/**
 * Servlet implementation class FindList
 */
@WebServlet("/FindList")
public class FindList extends HttpServlet {
    private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public FindList() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    
        request.setCharacterEncoding("UTF-8");    
        response.setContentType("text/html;charset=UTF-8");
        response.setCharacterEncoding("UTF-8");    
        
        DAL ud = new DAL();    
        try
        {
            ArrayList<Bao> al = ud.getListAll();
            request.setAttribute("userlist", al);
        }
        catch(Exception e)
        {
            response.getWriter().append("查找数据失败");
            e.printStackTrace();
        }
        //页面跳转
        request.getRequestDispatcher("index.jsp").forward(request,response);

}

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}
查找--FindList

 

posted @ 2015-12-23 23:05  業&裳  阅读(163)  评论(0)  编辑  收藏  举报