link.java~17~

用户的注册 用户的登陆 发布用户的相关信息 浏览网站介绍的其他酒店的信息 通过本系统查询被预定的房间 查询客户的反馈意见

package dao;

import domain.LinkForm;
import java.util.Collection;
import tool.EidetSql;
import tool.Conn;
import tool.SQLCode;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.*;
import java.util.ArrayList;


public class Link implements LinkDao {
    EidetSql ed = new EidetSql();
    public Link() {
    }

    /*******************************************
     * method name:insert
     * method function :插入友情链接
     * return type:int
     * datetime : 2007-09-17
     *******************************************/

    public int insert(LinkForm link) {
        Connection con = null;
        Statement st = null;
        ResultSet rs = null;
        Conn cn = new Conn();
        SQLCode sc = new SQLCode();
        String sql = sc.getSQLCode("sql.link.insert");
        sql = ed.editSqlStr(sql, link.getLink_content());
        sql = ed.editSqlStr(sql, link.getLink_addr());
        int row = 0;
        try {
            con = cn.getConnection();
            st = con.createStatement();
            row = st.executeUpdate(sql);
            if (st != null) {
                st.close();
            }
            if (con != null) {
                con.close();
            }

        } catch (SQLException ex) {
            System.out.println("插入链接sql:" + ex.getMessage());
        } catch (ClassNotFoundException ex) {
            System.out.println("类加载sql:" + ex.getMessage());
        }
        return row;
    }

    /*******************************************
     * method name:update
     * method function :更新链接
     * return type:int
     * datetime : 2007-09-17
     *******************************************/


    public int update(LinkForm link) {
        Connection con = null;
        Statement st = null;
        ResultSet rs = null;
        Conn cn = new Conn();
        SQLCode sc = new SQLCode();
        String sql = sc.getSQLCode("sql.link.update");
        sql = ed.editSqlStr(sql, link.getLink_content());
        sql = ed.editSqlStr(sql, link.getLink_addr());
        sql = ed.editSqlStr(sql, link.getLink_time());
        sql = ed.editSqlInt(sql, link.getLink_id());
        int row = 0;
        try {
            con = cn.getConnection();
            st = con.createStatement();
            row = st.executeUpdate(sql);
        } catch (SQLException ex) {
            System.out.println("更新链接sql:" + ex.getMessage());
        } catch (ClassNotFoundException ex) {
            System.out.println("类加载sql:" + ex.getMessage());
        }

        return row;
    }

    /*******************************************
     * method name:delete
     * method function :删除链接
     * return type:int
     * datetime : 2007-09-17
     *******************************************/


    public int delete(LinkForm link) {
        Connection con = null;
        Statement st = null;
        ResultSet rs = null;
        Conn cn = new Conn();
        SQLCode sc = new SQLCode();
        String sql = sc.getSQLCode("sql.link.delete");
        sql = ed.editSqlInt(sql, link.getLink_id());
        int row = 0;
        try {
            con = cn.getConnection();
            st = con.createStatement();
            row = st.executeUpdate(sql);
        } catch (SQLException ex) {
            System.out.println("删除链接sql:" + ex.getMessage());
        } catch (ClassNotFoundException ex) {
            System.out.println("类加载sql:" + ex.getMessage());
        }
        return row;
    }


    /*******************************************
     * method name:select
     * method function :查询链接
     * return type:int
     * datetime : 2007-09-17
     *******************************************/


    public Collection select(LinkForm link, int page) {
        Connection con = null;
        Statement st = null;
        ResultSet rs = null;
        Conn cn = new Conn();
        SQLCode sc = new SQLCode();
        String sql = sc.getSQLCode("sql.link.select");
        Collection list = new ArrayList();
        try {
            con = cn.getConnection();
            st = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                     ResultSet.CONCUR_READ_ONLY);
            rs = st.executeQuery(sql);
            int tip = 5 * (page - 1);
            try {
                if (tip <= 0) {
                    rs.beforeFirst();
                } else {
                    if (!rs.absolute(tip)) {
                        rs.beforeFirst();
                    }
                }
            } catch (SQLException ex1) {
                System.out.println("tip" + ex1.getMessage());
            }
            for (int i = 1; rs.next() && i <= 5; i++) {
                link = new LinkForm();
                link.setLink_id(rs.getInt(1));
                link.setLink_content(rs.getString(2));
                link.setLink_addr(rs.getString(3));
                link.setLink_time(rs.getString(4));
                list.add(link);
            }
            if (rs != null) {
                rs.close();
            }
            if (st != null) {
                st.close();
            }
            if (con != null) {
                con.close();
            }

        } catch (SQLException ex) {
            System.out.println("查询链接sql:" + ex.getMessage());
        } catch (ClassNotFoundException ex) {
            System.out.println("类加载sql:" + ex.getMessage());
        }
        return list;
    }


    /*******************************************
     * method name:count
     * method function :统计链接
     * return type:int
     * datetime : 2007-09-17
     *******************************************/


    public int count() {
        Connection con = null;
        Statement st = null;
        ResultSet rs = null;
        Conn cn = new Conn();
        SQLCode sc = new SQLCode();
        String sql = sc.getSQLCode("sql.link.count");
        int row = 0;
        try {
            con = cn.getConnection();
            st = con.createStatement();
            rs = st.executeQuery(sql);
            if (rs.next()) {
                row = rs.getInt(1);
            }
        } catch (SQLException ex) {
            System.out.println("统计链接sql:" + ex.getMessage());
        } catch (ClassNotFoundException ex) {
            System.out.println("类加载sql:" + ex.getMessage());
        }
        return row;
    }
}