C3P0Êý¾ÝÔ´ Á¬½ÓAccessÊý¾Ý¿â
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
<!-- ¶¨ÒåÊý¾ÝÔ´Bean£¬Ê¹ÓÃC3P0Êý¾ÝԴʵÏÖ -->
<bean id="dataSource"
class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close">
<!-- Ö¸¶¨Á¬½ÓÊý¾Ý¿âµÄÇý¶¯ -->
<property name="driverClass" value="com.hxtt.sql.access.AccessDriver" />
<!-- Ö¸¶¨Á¬½ÓÊý¾Ý¿âµÄURL -->
<property name="jdbcUrl"
value="jdbc:access:///c:/ÄãµÄAccessµÄ¾ø¶Ô·¾¶" />
<!-- Ö¸¶¨Á¬½ÓÊý¾Ý¿âµÄÓû§Ãû -->
<property name="user" value="" />
<!-- Ö¸¶¨Á¬½ÓÊý¾Ý¿âµÄÃÜÂë -->
<property name="password" value="" />
<!-- Ö¸¶¨Á¬½ÓÊý¾Ý¿âÁ¬½Ó³ØµÄ×î´óÁ¬½ÓÊý -->
&nb
Ïà¹ØÎĵµ£º
Access µÄ SQL ÖУ¬¼ÆËãÏàÓ¦±àºÅµÄ¼Ç¼֮¼ä ¼Ó ¼õ µÄ²éѯÃüÁî
ÀýÈç ¼ÆËãIDΪ 6 µÄ ºÏ¼Æ ¼õÈ¥ ID Ϊ 2¡¢3¡¢4 ÒÔ¼°¼ÓÉÏ ID Ϊ 5 µÄºÏ¼Æ
SELECT SUM(R) AS ½á¹û
from
(
SELECT ºÏ¼Æ AS R from T1 WHERE (ID = 6) UNION
SELECT -ºÏ¼Æ AS R from T1 WHERE (ID = 2) UNION
SELECT -ºÏ¼Æ AS R f ......
½üÆÚÓиöСCMSÏîÄ¿£¬ÓÉÓÚ·þÎñÆ÷¡¢ÈËÔ±ÒÔ¼°¹ÜÀíÖÆ¶ÈµÈһϵÁÐÎÊÌ⣬²»µÃ²»²ÉÓÃJava Web+AccessÕâÖÖ²»Âײ»ÀàµÄ×éºÏ½øÐпª·¢£¬ÆÚ¼äÓöµ½ÁËÒ»¸öСÎÊÌ⣬ÄǾÍÊÇÎÄÕÂÄÚÈݲÉÓÃAccessµÄ“±¸×¢”ÀàÐÍ´æÈ¡Ê±£¬·¢Éú×Ô¶¯½Ø¶ÏµÄÎÊÌâ¡£Ò²¾ÍÊÇ˵£¬´æ½øÈ¥10000×ÖµÄÎÄÕ£¬Ö»ÄÜÏÔʾ³ö3000 ......
3.ÄÚ¹¦Ìâ
¡¡¡¡ÊÔÌâ1£º·Ö±ð¸ø³öBOOL£¬int£¬float£¬Ö¸Õë±äÁ¿ Óë“ÁãÖµ”±È½ÏµÄ if Óï¾ä£¨¼ÙÉè±äÁ¿ÃûΪvar£©
¡¡¡¡½â´ð£º
¡¡¡¡¡¡BOOLÐͱäÁ¿£ºif(!var)
¡¡¡¡¡¡intÐͱäÁ¿£º if(var==0)
¡¡¡¡¡¡floatÐͱäÁ¿£º
¡¡¡¡¡¡const float EPSINON = 0.00001;
¡¡¡¡¡ ......
#include <stdio.h>
#include <string.h> /* ³ÌÐò¶à´Îµ÷ÓÃbiodkey()£¬Ó¦°üº¬Í·Îļþbios.h */
#include <bios.h><br>/* ³ÌÐò¶à´Îµ÷ÓÃclrscr()£¬Ó¦°üº¬Í·Îļþconio.h */
#include <conio.h>
#define MAX 100
#define PAGE 2
#define PRINT1 printf("------------------------------ ......