一种多条件动态综合查询的方法

为了在管理信息系统中提供更好的查询方法解决方案,提出了一种多条件动态综合查询的方法,通过不同查询条件的组合动态生成 SQL 语句来实现多条件的查询,在生成 SQL 语句过程中,采用第-where 条件永远成立的方法来实现 SQL 语句生成的统一性。从而使得综合查询具有很要的灵活性。最后采用 ASP 技术进行了实现,在实际应用中具有良好的实用性和通用性。     

VF中SQL复杂查询的四步教学法研究

查询是SQL的核心,而复杂查询是学生学习的难点.根据多年教学经验,从查询涉及的字段、字段来自哪些表、表之间的关联、查询条件分析四个方面阐述了SQL复杂查询的四步教学法.该教学方法不仅对简单查询进行复习巩固,而且为后续表单查询打下坚实的基础.     

电子ERP沙盘训练系统设计与实现

在对实物ERP沙盘实战训练教学系统进行研究的基础上,以实物ERP沙盘和电子ERP沙盘合理结合应用来提高教学效果为出发点,对电子ERP沙盘的需求进行了分析,给出了系统设计方案,并应用Delphi7开发工具和SQL server数据库实现了该系统。该系统和实物ERP系统合理结合应用能够最大程度上解决实物ERP沙盘模拟训练过程存在问题。     

基于MVC架构的组合数据查询

数据查询系统是程序设计的一个非常重要的组成部分,而组合数据查询是查询系统中最为复杂的一部分.本文在阐述查询设计方法的基础上,针对包括集合查询在内的组合数据查询要求,提出一种新的基于MVC架构的Jsp、Servlet和JavaBean三层组合条件查询方法,重点对其中的SQL子句转换和合并进行了阐述,并给出了部分源代码.     

一种面向对象的Java Bean查询方法的实现

为了克服在Java Bean方法中编写许多SQL语句实现数据查询的缺点，通过查询条件进行了对象化的封装，提出了一种针对Java Bean的面向对象的查询方法．通过设置查询条件对象，使用文中所提出的查询方法能方便地实现不同条件的数据查询，可以有效地提高系统的开发效率．     

基坑群监测数据与施工信息动态同步#br# 分析系统的开发与应用

针对基坑群开挖过程中工况复杂、信息量大、开挖与监测信息难以进行耦合分析的问题,开发了监测数据与施工信息动态同步分析系统.利用结构化查询语言(SQL)标准中的数据库软件Microsoft SQL Server进行基坑施工与监测信息的标准化管理,以时间信息作为索引标志,建立两者的动态同步耦合关系;通过对Excel与Visio的二次开发分别实现监测数据与施工工况的可视化模拟,最终开发全局控制台将基坑施工信息与监测数据的可视化模型进行关联以实现动态同步分析.将该系统应用于上海世博园某地块基坑群,实现了基坑群施工中的分块开挖工况与各项监测数据的动态同步分析,呈现了相邻基坑开挖在宏观与局部时空尺度上的相互影响特征.该系统可为基坑群施工对基坑与周围环境受力变形影响机制的分析与验证提供高效的分析手段.     

基坑群监测数据与施工信息动态同步分析系统的开发与应用

针对基坑群开挖过程中工况复杂、信息量大、开挖与监测信息难以进行耦合分析的问题,开发了监测数据与施工信息动态同步分析系统.利用结构化查询语言(SQL)标准中的数据库软件Microsoft SQL Server进行基坑施工与监测信息的标准化管理,以时间信息作为索引标志,建立两者的动态同步耦合关系;通过对Excel与Visio的二次开发分别实现监测数据与施工工况的可视化模拟,最终开发全局控制台将基坑施工信息与监测数据的可视化模型进行关联以实现动态同步分析.将该系统应用于上海世博园某地块基坑群,实现了基坑群施工中的分块开挖工况与各项监测数据的动态同步分析,呈现了相邻基坑开挖在宏观与局部时空尺度上的相互影响特征.该系统可为基坑群施工对基坑与周围环境受力变形影响机制的分析与验证提供高效的分析手段.     

SQL考试随机组卷改卷系统的设计和实现

针对SQL(结构化查询语言)课程操作考试的组卷和阅卷中的实际问题,对VB访问SQL Server 2000数据库使用的ADO技术进行了阐述,该文采用VB结合SQL Server 2000实现SQL考试随机组卷改卷系统设计的依据和实现方法,并给出了系统开发过程中所需的一些关键技术的程序代码。     

基于Oracle数据库SQL查询语句优化规则的研究

通过对Oracle数据库中SQL查询语句的执行原理和过程进行研究,以现有系统书号实名申领信息系统中的数据库为例,对执行的SQL查询语句的执行计划进行了分析,从SQL语句执行过程涉及到的系统资源和执行方式入手,对SQL查询语句进行优化,最后得出一系列的优化规则,并根据优化结果对这些规则进行验证。     

化工行业ERP构架概述

在快速变化的环境中,ERP系统的开发需要一种新的体系结构框架。本文针对化工行业提出了一种新思路进行ERP系统体系结构的研究,目标是方便地将业务环境的变化通过体系结构层来描述,进而快速有效地构建新的化工ERP信息应用系统。     

Markedness and its Interpretation in Language Use

Language markedness is a common phenomenon in languages, and is reflected from hearing, vision and sense, i.e. the variation in the three aspects such as phonology, morphology and semantics. This paper focuses on the interpretation of markedness in language use following the three perspectives, i.e. pragmatic interpretation, psychological interpretation and cognitive interpretation, with an aim to define the function of markedness.     

Features of Women's language

Language is a means of verbal communication. People use language to communicate with each other. In the society, no two speakers are exactly alike in the way of speaking. Some differences are due to age, gender, statue and personality. Above all, gender is one of the obvious reasons. The writer of this paper tries to describe the features of women＇s language from these perspectives： pronunciation, intonation, diction, subjects, grammar and discourse. From the discussion of the features of women＇s language, more attention should be paid to language use in social context. What＇s more, the linguistic phenomena in a speaking community can be understood more thoroughly.     

低渗透非均质砂岩油藏启动压力梯度研究

理论推导与室内实验相结合,建立了低渗透非均质砂岩油藏启动压力梯度确定方法。首先借助油藏流场与电场相似的原理,推导了非均质砂岩油藏启动压力梯度计算公式。其次基于稳定流实验方法,建立了非均质砂岩油藏启动压力梯度测试方法。结果表明:低渗透非均质砂岩油藏的启动压力梯度确定遵循两个等效原则。平面非均质油藏的启动压力梯度等于各级渗透率段的启动压力梯度关于长度的加权平均;纵向非均质油藏的启动压力梯度等于各渗透率层的启动压力梯度关于渗透率与渗流面积乘积的加权平均。研究成果可用于有效指导低渗透非均质砂岩油藏的合理井距确定,促进该类油藏的高效开发。     

On Tragic Consciousness In The Works By Ernest Hemingway

As an American modern novelist who were famous in the literary world, Hemingway was not a person who always followed the trend but a sharp observer. At the same time, he was a tragedy maestro, he paid great attention on existence, fate and end-result. The dramatis personae's tragedy of his works was an extreme limit by all means tragedy on the meaning of fearless challenge that failed. The beauty of tragedy was not produced on the destruction of life, but now this kind of value was in the impact activity. They performed for the reader about the tragedy on challenging for the limit and the death.     

Achieving Unusual States of Matter Under High Pressure

正The periodicity of the elements and the non-reactivity of the inner-shell electrons are two related principles of chemistry,rooted in the atomic shell structure.Within compounds,Group I elements,for example,invariably assume the+1 oxidation state,and their chemical properties differ completely from those of the p-block elements.These general rules govern our understanding of chemical structures and reactions.Using first principles calcula-     

Exchange-Correlation and Electronic Excitation Energies from Pairing Matrix Fluctuations

We have developed an adiabatic connection to formulate the ground-state exchange-correlation energy in terms of pairing matrix linear fluctuations.This formulation of the exchange-correlation energy opens a new channel for density functional approximations based on the many-body perturbation theory.We illustrate the potential of such approaches with an approximation based on the particle-particle Random Phase Approximation(pp-RPA).This re-     

Density Functional Theory for the Response of Periodic Systems to Electric Fields Based on the Vector Potential Approach

正The electronic and nuclear(structural/vibrational)response of 1D-3D nanoscale systems to electric fields gives rise to a host of optical,mechanical,spectral,etc.properties that are of high theoretical and applied interest.Due to the computational difficulty of treating such large systems it is convenient to model them as infinite and periodic(at least,in first approximation).The fundamental theoretical/computational problem in doing so is that     

On the Thermodynamic Limit for Responses to Static Electromagnetic Fields

For molecular systems,the quantum-mechanical treatment of their responses to static electromagnetic fields usually employs a scalar-potential treatment of the electric field and a vector-potential treatment of the magnetic field.Although the potential for each field separately is associated with the choice of an(unphysical)origin,the precise choice of the origin for the electrostatic field has little consequences for the results.This is different for the     

Call for Papers

<正>"The Journal of Shanghai Normal University:Mathematics"is published by Shanghai Normal University as regular issues of The Journal of Shanghai Normal University each year from 2014 in English.The editors-in-chief of the issues are professors Yuhao Cong and Maoan Han.The Journal of Shanghai Normal University was started in 1958 with     

Journal of Donghua University ( English Edition) Contents of Volume 31

正~~