geovi-CSDN博客

原创 Python: Flyweight Pattern

# 享元模式 Flyweight Pattern geovindu,Geovin Du,涂聚文

2022-10-22 11:49:38 149

//https://www.baeldung.com/jdbc-database-metadata //https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/DatabaseMetaData.html /** * 获取某数据库中的表列表涂聚文 Geovin Du geovindu * @param * @return TablesMetadata集合 ...

2021-12-25 08:29:11 933

原创 csharp: MySQL Stored Procedure using DAL

# 建表塗聚文 20160907drop table attendrecord;create table attendrecord( seq INT NOT NULL PRIMARY KEY AUTO_INCREMENT, emp_no varchar(20) null, rdate datetime not null, rtime time not n

2021-03-05 09:32:51 280

原创 three.js: Control gui and play sound set Volume

<!DOCTYPE html><html><head> <meta charset="utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no" /> <meta name="apple-moible-w.

2021-03-05 09:19:18 264 1

原创 PHP7.27: connect mysql 5.7 using new mysqli_connect

<!doctype html><html><head><meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta charset="utf-8"><title>my sql&am

2018-07-17 14:51:42 347

原创 FullCalendar – jQuery Event Calendar in ASP.NET

https://github.com/esausilva/ASP.Net-EventCalendarhttp://trentrichardson.com/examples/timepicker/https://github.com/posabsolute/jQuery-Validation-Enginehttps://github.com/xdan/datetimepickerLi

2017-04-17 21:53:07 784

原创 csharp: Oracle Stored Procedure DAL using ODP.NET

Oracel sql:--书分类目录kind -- Geovin Du create table BookKindList( BookKindID INT PRIMARY KEY, BookKindName nvarchar2(500) not null, BookKindParent INT null, BookKindCode varchar(100) ---編號

2016-09-21 11:26:36 641

原创 MySQL Stored Procedure Prepared Statement (Dynamic SQL) Parameterized

类似于SQL Server中的:sp_executesqlsql server script:--- 涂聚文 20160906IF EXISTS (SELECT * FROM sysobjects WHERE [name] = 'proc_Select_DuDeptUserCount')DROP PROCEDURE proc_Select_DuDeptUserCountGOCR

2016-09-07 16:33:00 773

原创 csharp: MySQL Stored Procedure using DAL

# 建表塗聚文 20160907drop table attendrecord;create table attendrecord( seq INT NOT NULL PRIMARY KEY AUTO_INCREMENT, emp_no varchar(20) null, rdate datetime not null, rtime time not n

2016-09-07 11:01:01 841

原创 C++: DataGridView::DataSource

#pragma once#include "Form2.h"namespace cdemo { using namespace System; using namespace System::ComponentModel; using namespace System::Collections; using namespace System::Windows::Forms; us

2016-08-05 15:53:58 1919

原创 Csharp: Create Excel Workbook or word from Template File using aspose.Word 14.5 and aspose.Cell 8.1

winform:/// /// /// /// /// private void btnGenWord_Click(object sender, EventArgs e) { Dictionary dictSource = new Dictiona

2016-08-04 14:16:49 893

原创 csharp:asp.net Importing or Exporting Data from Worksheets using aspose cell

using System;using System.Data;using System.Configuration;using System.Collections;using System.Collections.Generic;using System.Web;using System.Web.Security;using System.Web.UI;using System.

2016-08-02 11:40:01 933

原创 csharp: Procedure with DAO and DAL

sql script code:CREATE TABLE DuCardType( CardTypeId INT IDENTITY(1,1) PRIMARY KEY, CardTypeName NVARCHAR(100) NOT NULL, --卡类名称 CardTypeColor NVARCHAR(50) NOT NULL --卡颜色(或样本))GO

2016-07-04 11:32:22 2250

原创 csharp: DataRelation objects to represent a parent/child/Level relationship

/// /// /// /// /// protected void Page_Load(object sender, EventArgs e) { var sections = new List { new

2016-05-24 10:54:47 579

原创 Fluent Nhibernate and Stored Procedures

DROP TABLE DepartmentGOCREATE TABLE Department( Id INT IDENTITY(1,1) PRIMARY KEY, DepName VARCHAR(50), PhoneNumber VARCHAR(50))GOCREATE PROCEDURE [dbo].[GetDepartmentId] ( @Id INT )AS

2016-03-29 23:45:16 725

原创 javascript: Jquery each loop with json array or object

json:{ "justIn": [{ "textId": "123", "text": "Hello,geovindu", "textType": "Greeting" },{ "textId": "514", "text":"What's up?", "textType": "Question" },{ "textId": "122", "text":"Come over he

2016-01-12 15:53:03 678

原创 How to get the query string by javascript?

1.htmltest getQueryString2.html:javascript获取url参数和script标签中获取url参数//lastest: url paramter： //测试链接：test getQueryStringvar queryStrings=function() {//get url querystring var params=d

2016-01-08 23:58:39 625

原创 csharp:百度翻译

参考:http://api.fanyi.baidu.com/api/trans/product/indexhttp://developer.baidu.com/wiki/index.php?title=%E5%B8%AE%E5%8A%A9%E6%96%87%E6%A1%A3%E9%A6%96%E9%A1%B5/%E7%99%BE%E5%BA%A6%E7%BF%BB%E8%AF%91APIw

2015-11-26 11:47:15 1168

转载 javascript: detect mobile devices or browser

http://detectmobilebrowsers.com/http://hgoebl.github.io/mobile-detect.js/http://www.hand-interactive.com/resources/detect-mobile-javascript.htmhttps://github.com/danielpoe/DeviceDetection/bl

2015-10-29 13:06:09 10863

原创 sql: table,view,function, procedure created MS_Description in sql server

--添加描述 Geovin Du--https://msdn.microsoft.com/en-us/library/ms180047.aspx--https://msdn.microsoft.com/zh-cn/library/ms180047(v=sql.120).aspx--https://msdn.microsoft.com/zh-cn/library/ms179853(v=sql.

2015-09-27 22:08:45 1035

原创 SQL Server: Get table primary key and Foreign Key using sql query

---某個錶的列名,主键，外键---20150923 涂聚文 SQL Server: Get table primary key and Foreign Key using sql query DECLARE @SchemaName VARCHAR(200),@TableName VARCHAR(200)SET @SchemaName='dbo'SET @TableName='Bo

2015-09-23 10:53:16 745

原创 Csharp: read excel file using Open XML SDK 2.5

/// /// /// public class SheetNameInfo { private int _sheetId; private string _sheetName; private string _rid; /// /// ///

2015-08-20 09:28:04 1165

原创 csharp: Export or Import excel using NPOI

excel 2003:using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;

2015-07-31 00:22:32 855

原创 csharp: Export or Import excel using MyXls

excel 2003 (效果不太理想)using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Wi

2015-07-31 00:17:20 676

原创 csharp: 用Enterprise Library对象实体绑定数据

Enterprise Library: https://msdn.microsoft.com/en-us/library/ff648951.aspx/// /// 是否存在该记录 /// /// /// public bool Exists(string ReportID) {

2015-07-26 02:53:28 665

原创 csharp:Dapper Sample

You can find Dapper on Google Code here: http://code.google.com/p/dapper-dot-net/ and the GitHub distro here: https://github.com/SamSaffron/dapper-dot-net. /// /// 追加记录 ///

2015-07-26 02:26:28 831

原创 csharp: Data binding in WPF DataGrid control

<Window x:Class="WpfProjectDemo.MainWindow" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" Title="M

2015-07-13 17:55:40 1057

原创 csharp: Export DataSet into Excel and import all the Excel sheets to DataSet

/// /// Export DataSet into Excel /// /// /// private void Form3_Load(object sender, EventArgs e) { //Create an Emplyee DataTable Da

2015-07-10 17:30:29 760

原创 csharp: DataTable Rename ColumnName and remove Column

enum ChangeNume { /// /// 简体 /// gbk=1, /// /// 英文 /// en=2, /// /// 繁体 ///

2015-07-09 20:39:42 1039

原创 sql: Oracle 11g create procedure

CREATE OR REPLACE PROCEDURE proc_Insert_BookKindList (temTypeName nvarchar2,temParent int)ASncount number;begin--SELECT COUNT (*) INTO ncount FROM BookKindList fm1 where EXISTS (SELECT BookKi

2015-05-26 22:44:05 913

原创 sql: Oracle 11g create table, function,trigger, sequence

----自动增长ID --序列创建 drop SEQUENCE BookPlaceList_SEQ;CREATE SEQUENCE BookPlaceList_SEQINCREMENT BY 1 -- 每次加几个START WITH 1 -- 从1开始计数NOMAXVALUE -- 不设置最大值NOCYCLE --

2015-05-22 09:35:29 774

原创 csharp: Oracle Metadata queries

数据类型表：TypeNameProviderDbTypeColumnSizeCreateFormatCreateParametersDataTypeBFILE14294967296BFILE System.Byte[]BLOB24294

2015-05-17 00:27:12 691

转载 sql:SQL Server metadata queries

-- 2012--https://technet.microsoft.com/zh-cn/library/ms186778(v=sql.110).aspx--对象目录视图 (Transact-SQL)select * from sys.foreign_keysselect * from sys.foreign_key_columnsselect * from sys.all_colum

2015-05-15 17:20:29 785

转载 csharp:A Custom CheckedListBox with Datasource

from A Custom CheckedListBox with Datasource http://www.codeproject.com/Articles/22960/A-Custom-CheckedListBox-with-Datasource-Implementa /// /// (eraghi) /// Custom CheckedListBox w

2015-05-09 21:16:05 600

原创 sql:MySql create FUNCTION,VIEW,PROCEDURE

use geovindu;#函数DELIMITER $$drop function if exists f_GetDepartmentName $$CREATE function f_GetDepartmentName( did int) returns nvarchar(400) begindeclare str nvarchar(100);select Depar

2015-04-03 17:57:18 1247

原创 sql: postgreSQL sql script

--pg_catalogSELECT * from pg_class c,pg_attribute a,pg_type t where c.relname='BookKindList' and a.attnum>0 and a.attrelid=c.oid and a.atttypid=t.oidSELECT a.attname from pg_class c,pg_attribute a,

2015-04-02 12:20:08 965

原创 Getting SQLite metadata with Csharp

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Dat

2015-03-24 21:23:17 949

原创 Mysql问题：Connector/Net no longer supports server versions prior to 5.0

我用Connector/Net 6.9读取MySql 4.1 时，会报以下错：1.Connector/Net no longer supports server versions prior to 5.02.Unable to connect to any of the specified MySQL hosts.后来我下载 http://dev.mysql.com/downloads

2015-03-23 12:05:08 1663

原创 MySql:局域网和权限用户管理

MySql 5.6(XP)/5.7(win7) 添加用户和设置局域访问权限操作.请在 http://sourceforge.net/ 下载MySql Control Center(不是安装版本). use mysql; select * from user; update user set authentication_string=password('0214') wher

2015-03-20 12:59:51 1330