文件名称:MySqlDBUtilDemo
- 所属分类:
- C#编程
- 资源属性:
- [Windows] [Visual.Net] [源码]
- 上传时间:
- 2012-11-26
- 文件大小:
- 198kb
- 下载次数:
- 0次
- 提 供 者:
- 陈**
- 相关连接:
- 无
- 下载说明:
- 别用迅雷下载,失败请重下,重下不扣分!
介绍说明--下载内容均来自于网络,请自行研究使用
本示例演示了用C#操作MySQL的方法,提供了三个可重用的类MySqlDBUtil,MySqlPageUtil,Page。
本例程演示了:
1.MySQL数据库的插入,更新,修改,查询;
2.带参数的sql语句的使用,而不是拼SQL;
3.使用Limit子句的分页查询;
4.用事务同时执行多个SQL语句;
5.在插入数据的同时返回最新的ID值;
6.整型,实型,字符串,日期型,布尔型五种数据类型的操作;
7.使用正则表达式来验证整数和实数;
8.listview用来显示数据的一些基本用法。
-This example demonstrates the use of C# Operation method of MySQL to provide three types of reusable MySqlDBUtil, MySqlPageUtil, Page. Demonstrated the routine: 1.MySQL database insert, update, modify, query 2. The sql statement with parameter use, rather than fight SQL 3. The use of Limit clause paging query 4. With affairs at the same time to run multiple SQL statement 5. Insert data at the same time to return to the latest ID value 6. integer, real, string, date, type, five kinds of data types Boolean operations 7. use regular expressions to verify integer and real numbers 8.listview used to display some of the basic usage data.
本例程演示了:
1.MySQL数据库的插入,更新,修改,查询;
2.带参数的sql语句的使用,而不是拼SQL;
3.使用Limit子句的分页查询;
4.用事务同时执行多个SQL语句;
5.在插入数据的同时返回最新的ID值;
6.整型,实型,字符串,日期型,布尔型五种数据类型的操作;
7.使用正则表达式来验证整数和实数;
8.listview用来显示数据的一些基本用法。
-This example demonstrates the use of C# Operation method of MySQL to provide three types of reusable MySqlDBUtil, MySqlPageUtil, Page. Demonstrated the routine: 1.MySQL database insert, update, modify, query 2. The sql statement with parameter use, rather than fight SQL 3. The use of Limit clause paging query 4. With affairs at the same time to run multiple SQL statement 5. Insert data at the same time to return to the latest ID value 6. integer, real, string, date, type, five kinds of data types Boolean operations 7. use regular expressions to verify integer and real numbers 8.listview used to display some of the basic usage data.
(系统自动生成,下载前可以参看下载内容)
下载文件列表
MySqlDBUtilDemo
...............\AssemblyInfo.cs
...............\bin
...............\...\Debug
...............\...\Release
...............\lib
...............\...\MySql.Data.dll
...............\MainForm.cs
...............\MainForm.Designer.cs
...............\MainForm.resx
...............\MySqlDBUtil.cs
...............\MySqlDBUtilDemo.csproj
...............\MySqlDBUtilDemo.sln
...............\MySqlPageUtil.cs
...............\Page.cs
...............\PageQueryDao.cs
...............\Product.cs
...............\ProductDao.cs
...............\Program.cs
...............\readme.txt
...............\Validator.cs
...............\AssemblyInfo.cs
...............\bin
...............\...\Debug
...............\...\Release
...............\lib
...............\...\MySql.Data.dll
...............\MainForm.cs
...............\MainForm.Designer.cs
...............\MainForm.resx
...............\MySqlDBUtil.cs
...............\MySqlDBUtilDemo.csproj
...............\MySqlDBUtilDemo.sln
...............\MySqlPageUtil.cs
...............\Page.cs
...............\PageQueryDao.cs
...............\Product.cs
...............\ProductDao.cs
...............\Program.cs
...............\readme.txt
...............\Validator.cs