Drupal 6 的核心文件根目录 includes 文件夹下有一个 language.inc 的文件, 它的里面主要是 Drupal 网站语言控制的代码, 包括语言前缀, 浏览器语言判断等等.

在 Drupal 网站系统里面中文语言的默认前缀是 zh-hans, 一般形式如 http://域名/zh-hans/... . 而浏览器的语言, 以中文版 Firefox 为例 : 中文的语言的选择仅有
汉语 [zh];
汉语/新加坡 [zh-sg];
汉语/中国 [zh-cn];
汉语/中国台湾 [zh-tw];
汉语/中国香港 [zh-hk].

Drupal 7 使用 PDO 连接数据库，鉴于 PHP 6将把 PDO 做为默认数据库连接方式，这是必须的选择。实际上，Drupal 7之前的数据库抽象层，和 PDO 的某些理念一致，用相同的方法操作不同类型的数据库，减少了模块开发者的工作，也提升了程序的兼容性和可移植性。引入 PDO，相对于之前的版本，数据库接口当然有不小的变化。

最显著的，db_fetch_object()、db_fetch_array() 这两个最常用的函数没用了。从前，db_query()或pager_query()之后，几乎必然跟着上述两个函数之一，现在，没有了。而那些 SQL 语句中熟悉的占位符（%d, %s, %f, %n），也没有了。要谈这两个问题，先要了解一下大家最最熟悉的 db_query() 的改变。

在 Drupal 6 中，db_query() 接受无限个参数，第一个为 SQL 语句，后面的参数为查询值，用以替换语句中的占位符，大致类似于：
<?php
db_query("SELECT * FROM {system} WHERE filename = '%s'", 'system');
?>

 了解程序员能力矩阵, 指引你如何提升, 和你的提升空间.

"^\d+$"//非负整数（正整数+0）
"^[0-9]*[1-9][0-9]*$"//正整数
"^((-\d+)|(0+))$"//非正整数（负整数+0）
"^-[0-9]*[1-9][0-9]*$"//负整数
"^-?\d+$"//整数
"^\d+(\.\d+)?$"//非负浮点数（正浮点数+0）
"^(([0-9]+\.[0-9]*[1-9][0-9]*)|([0-9]*[1-9][0-9]*\.[0-9]+)|([0-9]*[1-9][0-9]*))$"//正浮点数
"^((-\d+(\.\d+)?)|(0+(\.0+)?))$"//非正浮点数（负浮点数+0）
"^(-(([0-9]+\.[0-9]*[1-9][0-9]*)|([0-9]*[1-9][0-9]*\.[0-9]+)|([0-9]*[1-9][0-9]*)))$"//负浮点数
"^(-?\d+)(\.\d+)?$"//浮点数
"^[A-Za-z]+$"//由26个英文字母组成的字符串
"^[A-Z]+$"//由26个英文字母的大写组成的字符串
"^[a-z]+$"//由26个英文字母的小写组成的字符串
"^[A-Za-z0-9]+$"//由数字和26个英文字母组成的字符串
"^\w+$"//由数字、26个英文字母或者下划线组成的字符串
"^[\w-]+(\.[\w-]+)*@[\w

asp.net模型层,CodeSmith代码自动生成模版

<%@ CodeTemplate Language="C#" TargetLanguage="C#" Description="Generates a very simple business object." %> <%@ Property Name="TargetTable" Type="SchemaExplorer.TableSchema" Category="Context" Description="TargetTable that the object is based on." %> <%@ Property Name="ModelsNamespace" Default="MyBookShop.Model" Type="System.String" Category="Context" Description="TargetTable that the object is based on." %> <%@ Assembly Name="SchemaExplorer" %> <%@ Assembly Name="System.Data" %> <%@ Import Namespace="SchemaExplorer" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Text.RegularExpressions" %> <% PrintHeader(); %> using System; using System.Collections.Generic; using System.Text;

namespace <%= ModelsNamespace %> { ? ?[Serializable()] ?public class <%= GetModelClassName() %> ?{ ? ??private <%= GetPKPropertyType() %> <%= GetPKMemberVarName() %>; ??<% ?? ??if(TargetTable.ForeignKeys.Count > 0) ??{ ???foreach (TableKeySchema key in TargetTable.ForeignKeys) ???{ ??%> ??private <%= GetFKPropertyType(key) %> <%= GetFKMemberVarName(key) %>; ??<% ???}??? ??} ?? ??foreach (ColumnSchema column in TargetTable.NonKeyColumns) ???{ ???if(GetMemberVariableDefaultValue(column) != "") ???{ ??%> ??private <%= GetPropertyType(column) %> <%= GetMemberVarName(column) %> = <%= GetMemberVariableDefaultValue(column) %>; ??<% ???} ???else ???{ ??%> 节省页面省去后续大量代码......下载CodeSmith代码模板文件dbmadmodels

asp.net三层架构数据访问层,CodeSmith代码自动生成模版

<%@ CodeTemplate Language="C#" TargetLanguage="C#" Description="Generates a very simple business object." %> <%@ Property Name="TargetTable" Type="SchemaExplorer.TableSchema" Category="Context" Description="TargetTable that the object is based on." %> <%@ Property Name="ModelsNamespace" Default="MyBookShop.Model" Type="System.String" Category="Context" Description="TargetTable that the object is based on." %> <%@ Property Name="DALNamespace" Default="MyBookShop.DAL" Type="System.String" Category="Context" Description="TargetTable that the object is based on." %> <%@ Property Name="DALClassNameSurfix" Default="DAL" Type="System.String" Category="Context" Description="TargetTable that the object is based on." %> <%@ Assembly Name="SchemaExplorer" %> <%@ Assembly Name="System.Data" %> <%@ Import Namespace="SchemaExplorer" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Text.RegularExpressions" %> <% PrintHeader(); %> using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.SqlClient; using <%= ModelsNamespace %>; namespace <%= DALNamespace %> { ?public class <%= GetDALClassName() %> ?{ ??<%-- public? Book AddBook(Book book) --%> ??????? public? int Add<%= GetModelClassName() %>(<%= GetModelClassName() %> <%= GetModelParamName() %>) ??{ ??????????? string sql = ????<%= GetInsertSQLLine1()%> ????<%= GetInsertSQLLine2()%> ???? ???sql += " ; SELECT @@IDENTITY"; ??????????? try ??????????? { ????SqlParameter[] para = new SqlParameter[] ????{ ?????<% ?????foreach(TableKeySchema key in TargetTable.ForeignKeys) ?????{ ?????%> ?????new SqlParameter("@<%= GetFKForeignIdName(key) %>", <%= GetModelParamName() %>.<%= GetFKPropertyName(key) %>.<%= GetFKPrimaryIdName(key) %>), //FK ?????<% ?????} ?????for(int i=0; i<TargetTable.NonKeyColumns.Count-1; i++) ?????{ ??????ColumnSchema column = TargetTable.NonKeyColumns[i]; ?????%> ?????new SqlParameter("@<%= column.Name %>", <%= GetModelParamName() %>.<%= column.Name %>), ?????<% ?????} ?????for(int i=TargetTable.NonKeyColumns.Count-1; i<TargetTable.NonKeyColumns.Count; i++) ?????{ ??????ColumnSchema lastColumn = TargetTable.NonKeyColumns[i]; ?????%> ?????new SqlParameter("@<%= lastColumn.Name %>", <%= GetModelParamName() %>.<%= lastColumn.Name %>) ?????<% ?????} ?????%> ????}; ???? ??????????????? int row = SqlHelper.ExecuteSql(sql, para); ????return row; ??????????? } ??????????? catch (Exception e) ??????????? { ??????????????? throw e; ??????????? } ??} ?? ??节省页面省去后续大量代码......下载CodeSmith代码模板文件dbmaddal

asp.net三层架构业务层,CodeSmith代码自动生成模版

<%@ CodeTemplate Language="C#" TargetLanguage="C#" Description="Generates a very simple business object." %> <%@ Property Name="TargetTable" Type="SchemaExplorer.TableSchema" Category="Context" Description="TargetTable that the object is based on." %> <%@ Property Name="ModelsNamespace" Default="MyBookShop.Model" Type="System.String" Category="Context" Description="TargetTable that the object is based on." %> <%@ Property Name="DALNamespace" Default="MyBookShop.DAL" Type="System.String" Category="Context" Description="TargetTable that the object is based on." %> <%@ Property Name="BLLNamespace" Default="MyOffice.BLL" Type="System.String" Category="Context" Description="TargetTable that the object is based on." %> <%@ Property Name="BLLClassNameSurfix" Default="Manager" Type="System.String" Category="Context" Description="TargetTable that the object is based on." %> <%@ Property Name="DALClassNameSurfix" Default="DAL" Type="System.String" Category="Context" Description="TargetTable that the object is based on." %> <%@ Assembly Name="SchemaExplorer" %> <%@ Assembly Name="System.Data" %> <%@ Import Namespace="SchemaExplorer" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Text.RegularExpressions" %> <% PrintHeader(); %> using System; using System.Collections.Generic; using System.Text; using <%= DALNamespace %>; using <%= ModelsNamespace %>; namespace <%= BLLNamespace %> { ??? public class <%= GetBLLClassName() %> ??? { ??private static readonly <%= GetDALClassName() %> dal = new <%= GetDALClassName() %>(); ??????? public? int Add<%= GetModelClassName() %>(<%= GetModelClassName() %> <%= GetModelParamName() %>) ??????? { ???<% ???if(TargetTable.ForeignKeyColumns.Count>0) ???{ ????foreach(TableKeySchema key in TargetTable.ForeignKeys) ????{ ?????if(key.PrimaryKeyTable.ExtendedProperties.Contains("DefaultId")) ?????{ ???%> ??????????? if (<%= GetModelParamName() %>.<%= GetFKPropertyName(key) %> == null) ??????????? { ??????????????? <%= GetModelParamName() %>.<%= GetFKPropertyName(key) %> = new <%= 节省页面省去后续大量代码......下载CodeSmith代码模板文件dbmadbll