ibatis+Castle.MCV版NPetshop3源码

[Header]\r\n[Footer]\r\n[Header]\r\n2007-08-06 23:27:07,875 [3808] DEBUG IBatisNet.DataMapper.SqlMapSession [(null)] - Open Connection "36405595" to "Microsoft SQL Server, provider V2.0.0.0 in framework .NET V2.0". 2007-08-06 23:27:08,046 [3808] DEBUG IBatisNet.DataAccess.Configuration.DaoProxy [(null)] - Dao Proxy call to GetProductListByCategory 2007-08-06 23:27:08,078 [3808] DEBUG IBatisNet.DataMapper.Commands.DefaultPreparedCommand [(null)] - Statement Id: [GetProductListByCategory] PreparedStatement : [select Product_Id, Product_Name, Product_Description, P.Category_Id, Category_Name, Category_Description from Products as P, Categories as C where C.Category_ID= P.Category_ID and P.Category_Id = @param0] 2007-08-06 23:27:08,140 [3808] DEBUG IBatisNet.DataMapper.Commands.DefaultPreparedCommand [(null)] - Statement Id: [GetProductListByCategory] Parameters: [@param0=[value,BIRDS]] 2007-08-06 23:27:08,140 [3808] DEBUG IBatisNet.DataMapper.Commands.DefaultPreparedCommand [(null)] - Statement Id: [GetProductListByCategory] Types: [@param0=[String, System.String]] 2007-08-06 23:27:08,531 [3808] DEBUG IBatisNet.DataAccess.Configuration.DaoProxy [(null)] - End of proxyfied call to GetProductListByCategory 2007-08-06 23:27:08,578 [3808] DEBUG IBatisNet.DataMapper.SqlMapSession [(null)] - Close Connection "36405595" to "Microsoft SQL Server, provider V2.0.0.0 in framework .NET V2.0". 2007-08-06 23:29:06,921 [1840] DEBUG IBatisNet.Common.Utilities.ConfigWatcherHandler [(null)] - ConfigWatcherHandler : Deleted [dao.config] 2007-08-06 23:29:06,921 [1840] DEBUG IBatisNet.Common.Utilities.ConfigWatcherHandler [(null)] - ConfigWatcherHandler : Renamed [ve-121.tmp/dao.config] [Footer]\r\n[Header]\r\n2007-08-06 23:34:04,359 [3792] DEBUG IBatisNet.DataMapper.SqlMapSession [(null)] - Open Connection "35008925" to "Microsoft SQL Server, provider V2.0.0.0 in framework .NET V2.0". 2007-08-06 23:34:05,218 [3792] DEBUG IBatisNet.DataAccess.Configuration.DaoProxy [(null)] - Dao Proxy call to GetProductListByCategory 2007-08-06 23:34:05,265 [3792] DEBUG IBatisNet.DataMapper.Commands.DefaultPreparedCommand [(null)] - Statement Id: [GetProductListByCategory] PreparedStatement : [select Product_Id, Product_Name, Product_Description, P.Category_Id, Category_Name, Category_Description from Products as P, Categories as C where C.Category_ID= P.Category_ID and P.Category_Id = @param0] 2007-08-06 23:34:05,343 [3792] DEBUG IBatisNet.DataMapper.Commands.DefaultPreparedCommand [(null)] - Statement Id: [GetProductListByCategory] Parameters: [@param0=[value,DOGS]] 2007-08-06 23:34:05,343 [3792] DEBUG IBatisNet.DataMapper.Commands.DefaultPreparedCommand [(null)] - Statement Id: [GetProductListByCategory] Types: [@param0=[String, System.String]] 2007-08-06 23:34:05,734 [3792] DEBUG IBatisNet.DataAccess.Configuration.DaoProxy [(null)] - End of proxyfied call to GetProductListByCategory 2007-08-06 23:34:05,781 [3792] DEBUG IBatisNet.DataMapper.SqlMapSession [(null)] - Close Connection "35008925" to "Microsoft SQL Server, provider V2.0.0.0 in framework .NET V2.0". 2007-08-06 23:35:05,171 [2020] DEBUG IBatisNet.Common.Utilities.ConfigWatcherHandler [(null)] - ConfigWatcherHandler : Deleted [dao.config] 2007-08-06 23:35:05,187 [2020] DEBUG IBatisNet.Common.Utilities.ConfigWatcherHandler [(null)] - ConfigWatcherHandler : Renamed [ve-13C.tmp/dao.config] [Footer]\r\n[Header]\r\n2007-08-06 23:35:42,421 [1340] DEBUG IBatisNet.DataMapper.SqlMapSession [(null)] - Open Connection "60362572" to "Microsoft SQL Server, provider V2.0.0.0 in framework .NET V2.0". 2007-08-06 23:35:42,609 [1340] DEBUG IBatisNet.DataAccess.Configuration.DaoProxy [(null)] - Dao Proxy call to GetProductListByCategory 2007-08-06 23:35:42,656 [1340] DEBUG IBatisNet.DataMapper.Commands.DefaultPreparedCommand [(null)] - Statement Id: [GetProductListByCategory] PreparedStatement : [select Product_Id, Product_Name, Product_Description, P.Category_Id, Category_Name, Category_Description from Products as P, Categories as C where C.Category_ID= P.Category_ID and P.Category_Id = @param0] 2007-08-06 23:35:42,718 [1340] DEBUG IBatisNet.DataMapper.Commands.DefaultPreparedCommand [(null)] - Statement Id: [GetProductListByCategory] Parameters: [@param0=[value,REPTILES]] 2007-08-06 23:35:42,718 [1340] DEBUG IBatisNet.DataMapper.Commands.DefaultPreparedCommand [(null)] - Statement Id: [GetProductListByCategory] Types: [@param0=[String, System.String]] 2007-08-06 23:35:43,046 [1340] DEBUG IBatisNet.DataAccess.Configuration.DaoProxy [(null)] - End of proxyfied call to GetProductListByCategory 2007-08-06 23:35:43,093 [1340] DEBUG IBatisNet.DataMapper.SqlMapSession [(null)] - Close Connection "60362572" to "Microsoft SQL Server, provider V2.0.0.0 in framework .NET V2.0". [Footer]\r\n[Header]\r\n2007-08-06 23:39:35,484 [3244] DEBUG IBatisNet.DataMapper.Configuration.Statements.PreparedStatementFactory [(null)] - Statement Id: [GetCategory] Prepared SQL: [select Category_Id, Category_Name, Category_Description from Categories where Category_Id = @param0] 2007-08-06 23:39:35,843 [3244] DEBUG IBatisNet.DataMapper.Configuration.Statements.PreparedStatementFactory [(null)] - Statement Id: [GetProductListByCategory] Prepared SQL: [select Product_Id, Product_Name, Product_Description, P.Category_Id, Category_Name, Category_Description from Products as P, Categories as C where C.Category_ID= P.Category_ID and P.Category_Id = @param0] 2007-08-06 23:39:35,843 [3244] DEBUG IBatisNet.DataMapper.Configuration.Statements.PreparedStatementFactory [(null)] - Statement Id: [GetProduct] Prepared SQL: [select Product_Id, Product_Name, Product_Description from Products where Product_Id = @param0] 2007-08-06 23:39:35,937 [3244] DEBUG IBatisNet.DataMapper.Configuration.Statements.PreparedStatementFactory [(null)] - Statement Id: [GetItemListByProduct] Prepared SQL: [select Item_Id, Item_ListPrice, Item_UnitCost,Item_Attr1, I.Product_ID, Product_Name, Product_Description from Items as I, Products as P where P.Product_ID = I.Product_ID and I.Product_ID = @param0] 2007-08-06 23:39:35,953 [3244] DEBUG IBatisNet.DataMapper.Configuration.Statements.PreparedStatementFactory [(null)] - Statement Id: [GetItem] Prepared SQL: [select I.Item_Id, Item_ListPrice, Item_UnitCost,Item_Attr1,Item_Photo, I.Product_ID, Product_Name, Product_Description, Inventory_Quantity, S.Supplier_Id, Supplier_Name from Items as I, Products as P, Inventories as IV, Suppliers as S where P.Product_ID = I.Product_ID and IV.Item_ID = I.Item_Id and S.Supplier_ID = I.Supplier_ID and I.Item_ID = @param0] 2007-08-06 23:39:35,953 [3244] DEBUG IBatisNet.DataMapper.Configuration.Statements.PreparedStatementFactory [(null)] - Statement Id: [GetInventoryQuantity] Prepared SQL: [select Inventory_Quantity as val from Inventories where Item_ID = @param0] 2007-08-06 23:39:35,968 [3244] DEBUG IBatisNet.DataMapper.Configuration.Statements.PreparedStatementFactory [(null)] - Statement Id: [UpdateInventoryQuantity] Prepared SQL: [update Inventories set Inventory_Quantity = Inventory_Quantity - @param0 where Item_ID = @param1] 2007-08-06 23:39:36,015 [3244] DEBUG IBatisNet.DataMapper.Configuration.Statements.PreparedStatementFactory [(null)] - Statement Id: [GetAccountByLoginAndPassword] Prepared SQL: [select S.Account_Id, SignOn_Password, Account_Email, Account_FirstName, Account_LastName, Account_Status, Account_Addr1, Account_Addr2, Account_City, Account_State, Account_Zip, Account_Country, Account_Phone, Profile_LangPref, Profile_FavCategory, Profile_MyListOp