×óÁ¬½Ó²éѯsqlÓï¾ä
ÓÐÈýÕűí LP_COMPANY, LP_COMPANYTYPE,LP_APPLICATION
SQLÓï¾äÊÇ
SELECT b.appname,c.typename,a.ID, a.APPID, a.PROVID, a.CITY, a.DISTRICT, a.TYPEID, a.PARENTID,
a.COMNAME, a.CHARGER, a.LICENSE, a.OPENBANK, a.ACCOUNT, a.NATAXNO, a.LOTAXNO,
a.STATUS, a.MEMO, a.ADDDATE, a.ADDTIME, a.REMARK1, a.REMARK2, a.REMARK3, a.REMARK4
from LP_COMPANY a
left join lp_application b on a.appid=b.id left join lp_companytype c on a.typeid=c.id
ÁíÍâÐè×¢ÒâµÄÊÇ
ÏîÄ¿ËùÓÿò¼ÜÊÇ struts2+spring2+ibatis2
¹ÊÔÚcompanyµÄbeanºÍactionÖÐ ¼ÓÈëÁ½¸öÊôÐÔtypeName ºÍappName
Ïà¹ØÎĵµ£º
½ñÌìҪͬ²½Ô¶³ÌÊý¾Ý¿âʱ³ö´í£¬±¨´í“ʵ¼ÊµÄ·þÎñÆ÷Ãû³Æ¡£¡£¡£¡£”£¬ÒÔÏÂÊǽâ¾ö·½·¨
SQL code--²é¿´µ±Ç°·þÎñÃû³Æ
select @@servername
--Èç¹ûÓ뵱ǰ¼ÆËã»úÃû²»Ò»Ö£¬ÔòÓÃÒÔÏÂÓï¾äÐÞ¸ÄSQL Server·þÎñÆ÷Ãû
sp_dropserver 'old_name' --ÏÈɾ³ýÔÃû³Æ
GO
sp_addserver 'new_name', lo ......
character-set-server = GB2312
collation-server = latin1_general_ci
MySQL×Ö·û¼¯ GBK¡¢GB2312¡¢UTF8Çø±ð ½â¾ö MYSQLÖÐÎÄÂÒÂëÎÊÌâ ÊÕ²Ø
MySQLÖÐÉæ¼°µÄ¼¸¸ö×Ö·û¼¯
character-set-server/default-character-set£º·þÎñÆ÷×Ö·û¼¯£¬Ä¬ÈÏÇé¿öÏÂËù²ÉÓõġ£
character-set-database£ºÊý¾Ý¿â×Ö·û¼¯¡£
character-set-table£ºÊ ......
1.´ò¿ªSQL server enterprise mananger “ÆóÒµ¹ÜÀíÆ÷”
ÔÚÄãÒªµ¼³öµÄSQLÊý¾Ý¿âÉÏÊó±êÓÒ¼ü²Ëµ¥£ºËùÓÐÈÎÎñ-¡·µ¼³öÊý¾Ý
2.»Ø³öÏÖÒ»¸öµ¼³öÏòµ¼´°¿Ú¡£
Ñ¡Ôñ±»µ¼³öµÄÊý¾ÝÔ´£¬ÎªÄã¸Õ²ÅËùÑ¡ÔñµÄÊý¾Ý¿â£¬Èç¹û·¢ÏÖ²»¶ÔÓ¦×ÔÐÐÐ޸ġ£
3.½øÈëµ¼³öµ½Ä¿±êÊý¾ÝÔ´µÄÑ¡Ôñ£¬ÕâÀïÎÒÃÇҪת³ÉACCESSµÄÊý¾Ý¿â¡£×¢ÒâÑ¡ÔñÊý¾ÝÔ´ÀàÐÍÎ ......
http://www.umgr.com/blog/PostView.aspx?bpId=36294
1. Ö´ÐÐsqlÓï¾ä
int sqlite3_exec(sqlite3*£¬ const char *sql£¬ sqlite3_callbacksql Óï·¨
£¬ void *£¬ char **errmsg );
Õâ¾ÍÊÇÖ´ÐÐÒ»Ìõ sql Óï¾äµÄº¯Êý¡£
µÚ1¸ö²ÎÊý²»ÔÙ˵ÁË£¬ÊÇÇ°Ãæopenº¯ÊýµÃµ½µÄÖ¸Õ롣˵ÁËÊǹؼüÊý¾Ý½á¹¹¡£
µÚ2¸ö²ÎÊýconst char ......
package com.itcast.service.base;
import java.util.LinkedHashMap;
import javax.persistence.Entity;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;
import org.springframework.transaction.annotation.Propagation;
import org.spri ......