C++ Server Pages | Lập trình web với C++

toi0biet · 19-03-2008, 09:52 AM

Em xin tự giới thiệu, em tên là: Nguyễn Mai Ngọc Anh, sinh năm 1992. Tuy em là con gái nhưng rất thích lập trình, dù thích nhưng em chưa biết gì nhiều, rất mong các đàn anh giúp đỡ.

Em đặc biết khoái món làm web, trước em đã làm quen với PHP. Tình cờ em tìm thấy C++ Server Pages, chức năng cũng khá là thú vị. Sau đây là ví dụ:

http://cxxsp.sourceforge.net

Tệp Category.h

C++ Code:

Select All | Show/Hide

#ifndef CATEGORY_H
#define CATEGORY_H
#include <string>
struct Category {
long id;
std::string name;
};
#endif//CATEGORY_H

Tệp Products.cpp

C++ Code:

Select All | Show/Hide

#include <boost/lexical_cast.hpp>
#include <servlet/RequestDispatcher.h>
#include <boost/shared_ptr.hpp>
#include "Product.h"
#include "Category.h"
#include "mysql.h"
#include <servlet/HttpServlet.h>
#include <math.h>//ceilf
using namespace std;
using boost::lexical_cast;
using boost::shared_ptr;
using namespace servlet;
class Products : public HttpServlet {
typedef vector<Product> products_t;
typedef std::vector<Category> categories_t;
inline bool is(const Mysql::params_t::const_iterator& iter, const std::string& name) {
return (iter->first==name && !iter->second.empty());
}
categories_t fetch_categories();
string where_part(const Mysql::params_t& params);
string order_part(const std::string& productsOrder, const std::string& productsDir);
inline int getPageSize(const std::string& productsPageSize);
string limit_part(const std::string& productsPageSize, const std::string& productsPage);
products_t fetch(const std::string& sql);
int count(const std::string& sql);
string make_naviLink(HttpServletRequest& request);
void process(HttpServletRequest& request, HttpServletResponse &response);
public:
void doGet(HttpServletRequest& request, HttpServletResponse &response);
};
Products::categories_t Products::fetch_categories() {
const string sql = "SELECT * FROM store_categories";
shared_ptr<MYSQL_RES> result = mysql.query(sql);
categories_t categories;
MYSQL_ROW row;
while( (row = mysql_fetch_row(result.get())) ) {
Category category;
category.id=lexical_cast<long>(mysql.get(row,0));
category.name=mysql.get(row,1);
categories.push_back(category);
}
return categories;
}
string Products::where_part(const Mysql::params_t& params) {
vector<string> cond;
for(map<string,string>::const_iterator iter = params.begin(); iter!=params.end(); ++iter) {
if(is(iter,"category_id"))
cond.push_back("category_id=$category_id");
else if(is(iter,"s_keyword"))
cond.push_back("product_name LIKE '%$s_keyword%'");
else if(is(iter,"price_from"))
cond.push_back("price >= $price_from");
else if(is(iter,"price_to"))
cond.push_back("price <= $price_to");
}
string query;
if(!cond.empty()) {
query += " WHERE ";
for(unsigned i=0;;++i) {
query += cond[i];
if(i==cond.size()-1)
break;
query += " AND ";
}
}
return mysql.prepare(query,params);
}
string Products::order_part(const std::string& productsOrder, const std::string& productsDir) {
string query;
if(!productsOrder.empty()) {
query = " ORDER BY ";
query += (productsOrder == "price") ? "price" : "product_name";
if(!productsDir.empty()){
query += (productsDir == "ASC") ? " ASC" : " DESC";
}
}
return query;
}
int Products::getPageSize(const std::string& productsPageSize) {
int pageSize = 10;
if(!productsPageSize.empty())
pageSize = lexical_cast<int>(productsPageSize);
return pageSize;
}
string Products::limit_part(const std::string& productsPageSize, const std::string& productsPage) {
string query = " LIMIT ";
int pageSize = getPageSize(productsPageSize);
query += lexical_cast<string>(pageSize);
if(!productsPage.empty()) {
int page = lexical_cast<int>(productsPage) - 1;
if(page < 0)
page = 0;
query += " OFFSET " + lexical_cast<string>(page * pageSize);
}
return query;
}
Products::products_t Products::fetch(const std::string& sql) {
shared_ptr<MYSQL_RES> result = mysql.query(sql);
products_t products;
MYSQL_ROW row;
while( (row = mysql_fetch_row(result.get())) ) {
Product product;
product.product_id = lexical_cast<long>(mysql.get(row,0));
product.category_id = lexical_cast<long>(mysql.get(row,1));
product.name = mysql.get(row,2);
product.price = lexical_cast<float>(mysql.get(row,3));
product.img = mysql.get(row,4);
product.desc = mysql.get(row,5);
product.recomended = lexical_cast<bool>(mysql.get(row,6));
products.push_back(product);
}
return products;
}
int Products::count(const std::string& sql) {
shared_ptr<MYSQL_RES> result = mysql.query(sql);
MYSQL_ROW row;
if( (row = mysql_fetch_row(result.get())) )
return lexical_cast<int>(mysql.get(row,0));
return 0;
}
string Products::make_naviLink(HttpServletRequest& request) {
auto_ptr< vector<string> > names_ptr = request.getParameterNames();
vector<string>& names = *names_ptr;
string link;
for(unsigned i=0;i<names.size(); ++i) {
if(names[i] == "productsPage")
continue;
link += link.empty()?'?':'&';
link += names[i] + "=" + request.getParameter(names[i]);
}
link += (link.empty()?'?':'&') + string("productsPage=");
return ("Products.sxx"+link);
}
void Products::process(HttpServletRequest& request, HttpServletResponse &response) {
map<string,string> params;
params["category_id"]=request.getParameter("category_id");
params["s_keyword"]=request.getParameter("s_keyword");
params["price_from"]=request.getParameter("price_from");
params["price_to"]=request.getParameter("price_to");
const string WHERE = where_part(params) ;
string query = "SELECT * FROM store_products"
+ WHERE
+ order_part(request.getParameter("productsOrder"), request.getParameter("productsDir"))
+ limit_part(request.getParameter("productsPageSize"), request.getParameter("productsPage"));
products_t products = fetch(query);
request.setAttribute("products", products);
query = "SELECT COUNT(*) FROM store_products" + WHERE;
int ResultsFound = count(query);
request.setAttribute("ResultsFound", ResultsFound);
int pageSize = getPageSize(request.getParameter("productsPageSize"));
int pageCount = static_cast<int>( ceilf(static_cast<float>(ResultsFound)/pageSize) );
request.setAttribute("pageCount", pageCount);
int currentPage = 1;
string s_currentPage = request.getParameter("productsPage");
if(!s_currentPage.empty())
currentPage = lexical_cast<int>(s_currentPage);
request.setAttribute("currentPage", currentPage);
request.setAttribute("naviLink",make_naviLink(request));
}
void Products::doGet(HttpServletRequest& request, HttpServletResponse &response) {
try{
request.setAttribute("categories", fetch_categories());
process(request, response);
}catch(const exception& ex) {
request.setAttribute<string>("error",ex.what());
request.setAttribute("ResultsFound", 0);
request.setAttribute("products", products_t());
request.setAttribute("naviLink",string());
request.setAttribute("currentPage", 0);
}
request.getRequestDispatcher("ProductsView.csp")->forward(request,response);
}
EXPORT_SERVLET(Products);

Tệp ProductsView.csp

Code:

<%@ page import="vector,Category.h,Product.h" %>
<%# using namespace std; %>
<%! 
    typedef vector<Category> categories_t; 
    typedef vector<Product> products_t;
%>
<html>
<head>
<title>SearchResults</title>
<link rel="stylesheet" type="text/css" href="style/Style.css">
</head>
<body bgcolor="#FFFFFF" link="#000000" alink="#FF0000" vlink="#000000" text="#000000" class="NoisePageBODY">
<%@ include file="Header.csp" %>
<p>
<form method="get">
  <font class="NoiseFormHeaderFont">Search Products</font> 
  <table border="0" cellpadding="2" cellspacing="1" class="NoiseFormTABLE">
    <% if(request.hasAttribute("error")) { %>
    <tr>
      <td colspan="2" class="NoiseErrorDataTD"><%= request.getAttribute<string>("error") %></td>
    </tr>
    <% } %>

    <tr>
      <td class="NoiseFieldCaptionTD">Category</td> 
      <td class="NoiseDataTD">
        <select class="NoiseSelect" name="category_id">
          <option selected value="">All</option>
          <% 
            categories_t categories = request.getAttribute<categories_t>("categories"); 
            for(unsigned i=0;i<categories.size();++i) {
          %>
          <option value="<%=categories[i].id%>"><%=categories[i].name%></option>
          <% } %>                        
        </select>
      </td> 
    </tr>
 
    <tr>
      <td class="NoiseFieldCaptionTD">Keyword</td> 
      <td class="NoiseDataTD"><input class="NoiseInput" maxlength="250" name="s_keyword" value="<%=request.getParameter("s_keyword")%>">&nbsp;</td> 
    </tr>
 
    <tr>
      <td colspan="2" align="right" class="NoiseFieldCaptionTD" nowrap>
        <input class="NoiseButton" type="submit" value="Search">&nbsp; </td> 
    </tr>
 
  </table>
</form>
</p>
<font class="NoiseFormHeaderFont" size="4"><b>Search
Results - <font class="NoiseFormHeaderFont" size="8"><%=request.getAttribute<int>("ResultsFound")%></font>&nbsp;products
found.</b></font>

<table border="0" cellpadding="2" cellspacing="1" class="NoiseFormTABLE">
  <% 
  products_t products = request.getAttribute<products_t>("products"); 
  if(!products.empty()) { 
    for(unsigned i=0;i<products.size(); ++i) { 
        const Product& product = products[i];
  %> 
  <tr>
    <td class="NoiseColumnTD" rowspan="2"><a class="NoiseDataLink" href="ProductDetails.sxx?product_id=<%=product.product_id%>"><img class="NoiseInput" src="<%=product.img%>" border="0"></a></td> 
    <td class="NoiseDataTD"><a class="NoiseDataLink" href="ProductDetails.sxx?product_id=<%=product.product_id%>"><%=product.name%></a></td> 
  </tr>
 
  <tr>
    <td class="NoiseDataTD">Price: $<%=product.price%></td> 
  </tr>
 
  <tr>
    <td class="NoiseDataTD" colspan="2">&nbsp;</td> 
  </tr>
  <%  } } else { %>
  <tr>
    <td class="NoiseDataTD" colspan="2">No records&nbsp;</td> 
  </tr>
  <% } %>
  <tr>
    <td align="middle" class="NoiseFieldCaptionTD" colspan="2" nowrap>&nbsp; 
      <% 
        int pageCount = request.getAttribute<int>("pageCount");
        int currentPage = request.getAttribute<int>("currentPage");
        string naviLink = request.getAttribute<string>("naviLink");
      %>
      <%
        if(currentPage>1) { 
      %>
        <a class="NoiseNavigatorLink" href="<%=naviLink%><%=1%>">First</a>
        <a class="NoiseNavigatorLink" href="<%=naviLink%><%=currentPage+1%>">Prev</a>
      <% } %>  
      <%
        for(int page=1;page<=pageCount; ++page) { 
            if(page==currentPage) 
                out << page; 
            else { %>
      <a class="NoiseNavigatorLink" href="<%=naviLink%><%=page%>"><%=page%></a>
            <% } %>
      &nbsp;
        <% } %>
      of
      <%= pageCount %>&nbsp; 
      <% if(currentPage<pageCount) { %>
        <a class="NoiseNavigatorLink" href="<%=naviLink%><%=currentPage+1%>">Next</a>
        <a class="NoiseNavigatorLink" href="<%=naviLink%><%=pageCount%>">Last</a>
      <% } %>  
    </td> 
  </tr>
</table>
<%@ include file="Footer.csp" %>
</body>
</html>

Có phải rất hay không các anh, cùng thảo luận nào

rox_rook · 19-03-2008, 10:01 AM

Cái này là CGI interface : dynamic web pages

http://www.rudeserver.com/

http://www.cs.tut.fi/~jkorpela/forms/cgic.html

Read if you're really interesting in Web with C++.

Hok_bik_zi · 19-03-2008, 10:01 AM

hic tui không chuyên cái nì ! chuyên java hơn

toi0biet · 21-03-2008, 10:44 PM

Nguyên bản được gửi bởi rox_rook

Cái này là CGI interface : dynamic web pages

Read if you're really interesting in Web with C++.

Cái này có gì đặc biệt vậy anh? Em thấy nó cũng giống như CGI cũ.

nguyenvandai · 27-03-2008, 08:41 PM

Tự dưng lại phải kiếm cái host support C++ :(

toi0biet · 29-03-2008, 02:40 PM

Vâng, đúng vậy anh à, em nghĩ cái này là dùng cho hệ thống riêng.

nguyenduong0205 · 20-03-2009, 01:23 AM

xin lỗi có ai giải thích chi tiết hơn không.

Kevin Hoang · 26-03-2009, 12:01 AM

Đây là vấn đề khá hay và đây là một đề tài liên quan:

Lập trình mạng | Simple WebServer C++

Và sau đây là 2 link khác để tham khảo
_http://www.adp-gmbh.ch/win/misc/webserver.html
_http://www.adp-gmbh.ch/win/misc/webserver.html

Đề tài: C++ Server Pages | Lập trình web với C++

Các công cụ đề tài

Display

C++ Server Pages | Lập trình web với C++

C++ Server Pages | Lập trình web với C++

Các đề tài tương tự

Ireport trong java lỗi the document has no pages?

Gửi mail trên web server lỗi The SMTP server requires a secure connection or the client was not authenticated?

Chuyển từ sql server sang sql server compact trong visual studio 2010

MS SQL với C# Backup trên Server A và Restore ở Server B cùng cấu trúc CSDL như thế nào?

Làm sao để đưa 1 cửa sổ hiện hành vào pages

Quyền hạn của bạn