deal.java

jsp程序开发范例宝典

package com.core;

import java.io.*;
import java.sql.ResultSet;
import com.core.ConnDB;
import javax.servlet.http.HttpServletRequest;

public class Deal {
    //获取要播放电影的URL地址
    public String getPath(HttpServletRequest request, String id) {
        ConnDB conn = new ConnDB();
        String sql = "select * from tb_film where id=" + id + "";
        ResultSet rs = conn.executeQuery(sql);
        String url = "";
        String filePath = request.getRequestURL().toString();  //获取请求页面的URL地址
        System.out.println("FILEPATH:"+filePath);
        try {
            if (rs.next()) {
                url = filePath.substring(0, filePath.lastIndexOf("/") + 1) +
                      rs.getString("src");
            }
        } catch (Exception e) {
            System.out.println("查询时的错误信息：" + e.getMessage());
        }
        return url;
    }
//更新点击次数
    public void updateHit(String id) {
        ConnDB conn = new ConnDB();
        String sql = "update tb_film set hit=hit+1 where id=" + id + "";
        try {
            conn.executeUpdate(sql);
        } catch (Exception e) {}
    }
}