<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="com.hanqi.*" %>
<%@ page import="com.hanqi.dao.*" %>    
<%@ page import="java.util.*"%>
<!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 src="js/jquery-1.11.3.min.js"></script>
<script>
function show() {
    $("#fo").show();
    $("#i1").hide();
}
function show1() {
    $("#i1").show();
    $("#fo").hide();
}
function check() {
    if(fo.name.value=="") {
        alert("联系人姓名不能为空");
        return false;
    }
    else if(fo.tel.value=="") {
        alert("电话号码不能为空");    
        return false;
    }
    else if(fo.groupid.value==0) {
        alert("请选择分组");
        return false;
    }
    else {
        return true;
    }
}
function con() {
    return confirm("确定要删除吗? 此操作不可撤销! ");
}
</script>
<script>
$(document).ready($("form").hide());
</script>
</head>
<body>

<table border="1" >
<tr align="center">
<td>姓名</td>
<td>电话</td>
<td>分组</td>
<td>&nbsp;</td>
</tr>
<%
ContactDal cd = new ContactDal();
ArrayList<Contactclass> al = cd.getContacts();
ContactDal cdg = new ContactDal();
ArrayList<Contactclass> algp = cdg.getGroups();
String name = null;
if(al!=null) {
    int id = 2;
    for(Contactclass ctc : al) {
        id = ctc.getGroupid();
        out.print("<tr><td>"+ctc.getName()+"</td>");
        out.print("<td>"+ctc.getTel()+"</td>");
        ContactDal cdgroup = new ContactDal();
        ArrayList<Contactclass> all = cdgroup.getGroupName(id);
        if(all!=null) {
            for(Contactclass ctc1:all) {
                name = ctc1.getName();
            }
        }
        out.print("<td>"+name+"</td>");
        out.print("<td><a href='ContactDetele?id="+ctc.getId()+"' onclick='return con()'>删除</a>");
        out.print("&nbsp;&nbsp;&nbsp;<input type='button' value='编辑' onclick=''/><br>");
        out.print("<form id='fo' action='#'>姓名<input name='name1' type='text' value=''>");
        out.print("电话<input name='tel1' type='text' value='' />分组<select name=groupid1>");
        out.print("<option value='0' selected>未选择</option>");
        for(Contactclass ccg : algp) {
            out.print("<option value='"+ccg.getId()+"'>"+ccg.getName()+"</option>");
        }
        out.print("</select><input type='submit' value='修改'></form></td></tr>");
    }
}
%>
</table>
<br>
<input id="i1" type="button" value="添加联系人" onclick="show()" />

<form id="fo" action="ContactsInsert" method="post" onsubmit="return check()">
<input type="button" value="返回" onclick="show1()"><br><br>
姓名: <input name="name" type="text" value="" /><br><br>
电话: <input name="tel" type="text" value="" /><br><br>
分组: 
<select name="groupid">
<option value="0" seleceted>未选择</option>
<%
ContactDal cdgroup1 = new ContactDal();
ArrayList<Contactclass> all = cdgroup1.getGroups();
if(all!=null) {
    for(Contactclass ctc2:all) {
        out.print("<option value='"+ctc2.getId()+"'>"+ctc2.getName()+"</option>");
    }
}
%>
</select>
<br><br>
<input type="submit" value="添加">
<input type="reset" value="重写">
</form>

</body>
</html>
<script>
$("#fo").hide();
</script>

View Code

2, Servlet控制层

录入联系人

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");
        response.setContentType("text/html; charset=utf-8");
        String name = request.getParameter("name");
        String tel = request.getParameter("tel");
        String groupid = request.getParameter("groupid");
        //response.getWriter().append("能接收到数据");
        if(name!=null&&name.trim().length()>0&&tel!=null&&tel.trim().length()>0&&groupid!=null&&groupid.trim().length()>0) {
            Contactclass c = new Contactclass();
            c.setName(name);
            c.setTel(tel);
            c.setGroupid(Integer.parseInt(groupid));
            //response.getWriter().append(c.getName()+c.getTel()+c.getGroupid());
            ContactDal cd = new ContactDal();
            try {
                if(cd.insert(c)>0) {
                    response.sendRedirect("index.jsp");
                }
                else {
                    response.getWriter().append("录入联系人数据失败");
                }
            }
            catch(Exception ex) {
                response.getWriter().append(ex.getMessage());
            }
        }
        else {
            response.getWriter().append("姓名,电话,分组都不能为空");
        }
    }

View Code

删除数据

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String id = request.getParameter("id");
        if(id!=null&&id.trim().length()>0) {
            ContactDal cd = new ContactDal();
            try {
                if(cd.delete(Integer.parseInt(id))>0) {
                    response.sendRedirect("index.jsp");
                }
                else {
                    response.getWriter().append("删除数据失败");
                }
            }
            catch (Exception e) {
                e.printStackTrace();
            }
        }
    }

View Code

修改联系人信息

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");
        response.setContentType("text/html; charset=utf-8");
        String name1 = request.getParameter("name1");
        String tel1 = request.getParameter("tel1");
        String groupid1 = request.getParameter("groupid1");
        String id1 = request.getParameter("id");
        if(name1!=null&&name1.trim().length()>0&&tel1!=null&&tel1.trim().length()>0&&groupid1!=null&&groupid1.trim().length()>0) {
            ContactDal cd = new ContactDal();
            try {
                int a = cd.update(Integer.parseInt(id1), name1, tel1, Integer.parseInt(groupid1));
                if(a>0) {
                    response.sendRedirect("index.jsp");
                }
                else {
                    response.getWriter().append("修改联系人失败");
                }
            }
            catch(Exception er) {
                response.getWriter().append(er.getMessage());
            }
        }
    }

View Code

3, Dal工具类

链接数据库, 加载驱动

package com.hanqi.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DbHelper {
    public static Connection getConn() throws ClassNotFoundException, SQLException {
        Class.forName("oracle.jdbc.driver.OracleDriver");
        String url = "jdbc:oracle:thin:@localhost:1521:orcl";
        Connection conn = DriverManager.getConnection(url,"sa","sasa");
        return conn;
    }
}

View Code

对象类

package com.hanqi.dao;

public class Contactclass {
    private int Id;
    private String Name;
    private String Tel;
    private int Groupid;
    
    public int getId() {
        return Id;
    }
    public void setId(int id) {
        Id = id;
    }
    public String getName() {
        return Name;
    }
    public void setName(String name) {
        Name = name;
    }
    public String getTel() {
        return Tel;
    }
    public void setTel(String tel) {
        Tel = tel;
    }
    public int getGroupid() {
        return Groupid;
    }
    public void setGroupid(int groupid) {
        Groupid = groupid;
    }
}

View Code

增删查方法体类

package com.hanqi;

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

import com.hanqi.dao.Contactclass;
import com.hanqi.dao.DbHelper;

public class ContactDal {
    //获取联系人的方法
    public ArrayList<Contactclass> getContacts() throws ClassNotFoundException, SQLException {
        ArrayList<Contactclass> al = null;
        Connection con = DbHelper.getConn();
        PreparedStatement ps = null;
        ResultSet rs = null;
        if(con!=null) {
            try {
                String sql = "select * from contacts";
                ps = con.prepareStatement(sql);
                rs = ps.executeQuery();
                al = new ArrayList<Contactclass>();
                if(rs!=null) {
                    while(rs.next()) {
                        Contactclass cc = new Contactclass();
                        cc.setId(rs.getInt("id"));
                        cc.setName(rs.getString("Name"));
                        cc.setGroupid(rs.getInt("groupid"));
                        cc.setTel(rs.getString("tel"));
                        al.add(cc);
                    }
                }
                con.close();
            }
            catch(Exception ex) {
                System.out.println(ex);
            }
            finally{
                try {
                    ps.close();
                }
                catch(Exception ex1) {
                    System.out.println(ex1);
                }
                finally{
                    rs.close();
                }
            }
        }
        return al;
    }
    //获取分组的方法
    public ArrayList<Contactclass> getGroupName(int id) throws ClassNotFoundException, SQLException {
        ArrayList<Contactclass> al = null;
        Connection con = DbHelper.getConn();
        PreparedStatement ps = null;
        ResultSet rs = null;
        if(con!=null) {
            try {
                String sql = "select * from groups where id ="+id;
                ps = con.prepareStatement(sql);
                rs = ps.executeQuery();
                if(rs!=null) {
                    al = new ArrayList<Contactclass>();
                    while(rs.next()) {
                        Contactclass cc = new Contactclass();
                        cc.setId(rs.getInt("id"));
                        cc.setName(rs.getString("Name"));
                        al.add(cc);
                    }
                }
                con.close();
            }
            catch(Exception ex) {
                System.out.println(ex);
            }
            finally{
                try {
                    ps.close();
                }
                catch(Exception ex1) {
                    System.out.println(ex1);
                }
                finally{
                    rs.close();
                }
            }
        }
        return al;
    }
    
    
    //录入联系人数据
    public int insert(Contactclass Obj) throws Exception{
        int row = 0;
        Connection con = DbHelper.getConn();
        PreparedStatement pps = null;
        if(con!=null) {
            try {
                String sql = "insert into contacts (id, name, tel, groupid) values (sq_contacts.nextval,?,?,?)";
                pps = con.prepareStatement(sql);
                pps.setString(1, Obj.getName());
                pps.setString(2, Obj.getTel());
                pps.setInt(3, Obj.getGroupid());
                row = pps.executeUpdate();
            }
            catch(Exception e) {
                System.out.println(e);
            }
            finally {
                try {
                    con.close();
                }
                catch(Exception e1) {
                    System.out.println(e1);
                }
                finally {
                    pps.close();
                }
            }
        }
        return row;
    }
    
    
    //删除联系人
    public int delete(int id) throws Exception {
        int row = 0;
        Connection co = DbHelper.getConn();
        String sql = "delete contacts where id ="+id;
        PreparedStatement p = null;
        if(co!=null) {
            try {
                p = co.prepareStatement(sql);
                row = p.executeUpdate();
            }
            catch(Exception e) {
                System.out.println(e);
            }
            finally {
                try {
                    p.close();
                }
                catch(Exception question) {
                    System.out.println(question);
                }
                co.close();
            }
        }
        return row;
    }
    
    //无参数获取全部分组的方法
    public ArrayList<Contactclass> getGroups() throws ClassNotFoundException, SQLException {
        ArrayList<Contactclass> al = null;
        Connection con = DbHelper.getConn();
        PreparedStatement ps = null;
        ResultSet rs = null;
        if(con!=null) {
            try {
                String sql = "select * from groups";
                ps = con.prepareStatement(sql);
                rs = ps.executeQuery();
                if(rs!=null) {
                    al = new ArrayList<Contactclass>();
                    while(rs.next()) {
                        Contactclass cc = new Contactclass();
                        cc.setId(rs.getInt("id"));
                        cc.setName(rs.getString("Name"));
                        al.add(cc);
                    }
                }
                con.close();
            }
            catch(Exception ex) {
                System.out.println(ex);
            }
            finally{
                try {
                    ps.close();
                }
                catch(Exception ex1) {
                    System.out.println(ex1);
                }
                finally{
                    rs.close();
                }
            }
        }
        return al;
    }
    
    
    //修改联系人方法
    public int update(int id,String name,String tel,int groupid) throws Exception {
        int row = 0;
        Connection con = DbHelper.getConn();
        String sql = "update contacts set name=?, tel=?, groupid=? where id="+id;
        PreparedStatement p = null;
        if(con!=null) {
            try {
                p = con.prepareStatement(sql);
                p.setString(1, name);
                p.setString(2, tel);
                p.setInt(3, groupid);
                row = p.executeUpdate();
            }
            catch(Exception e) {
                System.out.println(e);
            }
            finally {
                try {
                    con.close();
                }
                catch(Exception e) {
                    System.out.println(e);
                }
                finally {
                    p.close();
                }
            }
        }
        return row;
    }
}

View Code

posted on 2015-12-24 23:23 我就不吃芹菜阅读(193) 评论(0) 编辑收藏举报

会员力量，点亮园子希望

刷新页面返回顶部

导航