自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+
  • 博客(4)
  • 资源 (12)
  • 收藏
  • 关注

原创 解决Oracle因安装时未设定字符集导致中文乱码问题

在CentOS 6.6上安装Oracle 11g没有设定字符集,采用的是操作系统默认字符集:WE8MSWIN1252,将字符集修改为:ZHS16GBK。SQL> select userenv('language') from dual;SIMPLIFIED CHINESE_CHINA.WE8MSWIN1252SQL> select * from nls_database_p

2016-01-27 10:19:17 1656

转载 linux重启oracle 各种方法

在linux下重启oracle数据库及监听器:方法1:用root以ssh登录到linux,打开终端输入以下命令:cd $ORACLE_HOME   #进入到oracle的安装目录 dbstart           #重启服务器 lsnrctl start     #重启监听器 cd $ORACLE_HOME   #进入到oracle的安装目录dbsta

2016-01-27 10:14:32 493

原创 oracle采用了WE8MSWIN1252字符集乱码的问题

出现此文的原因是本人在向Oracle中插入中文的时候全部变成了问号,在解决的过程中发现是Oracle字符集的问题,从下文中找到了完美的解决方案,特此记录备用:测试的时候,本机oracle安装采用了WE8MSWIN1252字符集,而项目的要求是gbk字符集,为了防止以后有不同字符集数据信息导入导出的问题,整理以下文档。修改oracle字符集新装了oracle,装为AL32UTF8格式,无

2016-01-27 10:10:31 9414 1

转载 ASCII、Unicode、GBK和UTF-8字符编码的区别联系

ASCII、Unicode、GBK和UTF-8字符编码的区别联系很久很久以前,有一群人,他们决定用8个可以开合的晶体管来组合成不同的状态,以表示世界上的万物。他们看到8个开关状态是好的,于是他们把这称为”字节“。再后来,他们又做了一些可以处理这些字节的机器,机器开动了,可以用字节来组合出很多状态,状态开始变来变去。他们看到这样是好

2016-01-22 09:18:28 374

mysql 5.6 linux 源码编译安装包

mysql 5.6 linux 源码编译安装包

2016-05-09

cmake 编译安装工具

cmake 编译安装工具

2016-05-09

C#jmail邮件发送源码

完整的web应用程序源码,使用jmail实现邮件的发送,并且可以发送多个附件文件。项目包含jmail的组件,无需下载jmail的安装版,也无需注册jmail。解压项目后,使用vs2008打开项目,修改web.config中的appSettings节点,配置自己的发送邮件的地址、密码及服务协议。运行即可。希望帮到需要者。 <appSettings> <!--邮件信息发送配置--> <add key="sendu_mail" value="xxxxxxxx@126.com"/> <add key="sendu_pwd" value="xxxxxxx"/> <add key="mail_stmp" value="smtp.126.com" /> </appSettings>

2014-09-14

ORCALE11-instantclient-basic-win32-11.2.0.1.0

ORCALE11-instantclient-basic-win32-11.2.0.1.0.

2013-12-21

android控件应用 自定义的ListView控件,下拉刷新上拉加载更多

android控件应用 自定义的ListView控件,下拉刷新上拉加载更多,完整的资源应用

2013-11-12

android自定义的可扩展漂亮的dialog对话框

android自定义可扩展漂亮的dialog对话框,支持android 2.2以上的版本,可用作条件筛选、消息提示、浮出窗口的应用操作。

2013-11-12

Silverlight实现简单拖放

Silverlight 2.0 开发应用示例,本模块主要是实现button的拖动和停放。

2009-11-14

jQuery.Select

a、优化代码。 b、针对索引值进行了测试,修正部分情况下索引值混乱的Bug。 c、增加对home\pg up\pg dn\end 的支持 d、生成select宽度可自动延展性质。 e、一些细节调整。

2009-08-15

在线投票,在线调查在线投票,在线调查

大学生调查投票系统源码 1、该系统管理员登录后,可向数据库中添加投票选项 2、系统能够自动统计投票数目,并将其转化为百分比和图像,使投票结果更直观形象。 3、登录后,能够对选项进行编辑,删除。 “编辑投票选项”说明编辑投票内容时,格式为"“票数,投票选项” 初始时,在“,”前指定为0.“,”为英文状态下输入的 DB_51aspx下为Sql数据库文件,附加即可 默认管理帐号/密码:51aspx/51aspx

2009-05-26

ASP.NET AJAX控件之ToggleButton.

AJAX控件 ToggleButton. ASP.NET AJAX控件之ToggleButton.

2009-04-08

NBEARLISY使用

做数据映射层 NBearLite Version 1.0.0.9 beta ------------------------------- Author: Teddy (shijie.ma@gmail.com) Official Site: http://nbear.org Open Source License: BSD Copyright: 2007-2010 Release Notes ------------- Version 1.0.0.9 beta 1. Fix bug of getting oracle table and view info in QueryColumnsGenerator.exe tool. 2. Change the NBearLite_Documentation format from chm to general HTML to prevent some operation system's could not open it issue. Version 1.0.0.8 beta 1. Fix type cast bug when QueryColumnsGenerator.exe generated out parameter value is dbnull. 2. Enhance QueryColumnsGenerator.exe to generate one more method for each stored procedure with a DbTransaction tran parameter. Version 1.0.0.7 beta 1. Fix bug in Aggregation select. 2. Provide Chinese version full documentation of NBearLite in doc folder. Version 1.0.0.6 beta 1. Add ToDbCommand() method to InsertSqlSection/UpdateSqlSection/DeleteSqlSection classes. 2. Add 8 Save() method overridens to Database class to support DataTable/DataRows saving. e.g. Sample Save code: SelectSqlSection selectSection = db.Select(Northwind.Categories) .Where(Northwind.Categories.CategoryID == catID) .OrderBy(Northwind.Categories.CategoryID.Desc) .SetSelectRange(1, 0, Northwind.Categories.CategoryID); DataTable dt = selectSection.ToDataSet().Tables[0]; dt.Rows[0]["CategoryName"] = "modified"; //save a modified row db.Save(selectSection.ToDbCommand(), 10, dt); dt.Rows[0]["CategoryName"] = "modified2"; DataRow newRow = dt.NewRow(); newRow["CategoryName"] = "new"; dt.Rows.Add(newRow); //save 1 modified row and insert a new row db.Save(selectSection.ToDbCommand(), tran, 0, dt.Rows[0], dt.Rows[1]); Version 1.0.0.5 beta 1. Add ToDbCommand() method to SelectSqlSection class. e.g. We can use database.Select(Northwind.Categories).ToDbCommand(); 2. Enhance strong type query with sub query support. Add ToSubQuery() method to SelectSqlSection class. e.g. Sample strong type query with sub queries: DataSet ds = db.Select(Northwind.Products) .Where(Northwind.Products.CategoryID.In ( db.Select(Northwind.Categories, Northwind.Categories.CategoryID).SetSelectRange(10, 0, Northwind.Categories.CategoryID).ToSubQuery()) ) .ToDataSet(); ds = db.Select(Northwind.Products) .Where(Northwind.Products.CategoryID == ( db.Select(Northwind.Categories, Northwind.Categories.CategoryID).SetSelectRange(1, 0, Northwind.Categories.CategoryID).ToSubQuery()) ) .ToDataSet(); Version 1.0.0.4 beta 1. Enhanced NBearLite.QueryColumnsGenerator to generate Stored Procedure Wrapper methods for SqlServer, Oracle, MySql and PostgreSql databases. Version 1.0.0.3 beta 1. Fix bug in PostgreSql DbProvider. Version 1.0.0.2 beta 1. Fix bug in preview version. 2. Add PostgreSql DbProvider in NBearLite.AdditionalDbProviders.dll. 3. Release as the first beta version. Version 1.0.0.0 preview 1. Release the initial preview version. Introdution Q & A ----------------- Q: What is NBearLite? A: NBearLite is a .NET 2.0 data access component which supports MsAccess, SqlServer, Oracle, Sqlite, MySql, PostgreSql databases. Q: Is NBearLite an O/R Mapping component? A: No. Q: Then what are the main features of NBearLite? A: With NBearLite, you can transparently query databases by a strong type query language similar to LINQ. The strong type query language provided by NBearLite supports not only basic CRUD but also complex select queries with ORDER BY, GROUP BY, PAGING, INNER JOIN, BATCH OPERATION...- Most common database operations we may met in our development life, which significantly simplifies database operations from our .Net code and saves our development time. The select query of NBearLite returns Scalar, DataSet or IDataReader. Q: Is NBearLite easy to use? A: Yes, super easy. You can easily reference NBearLite.dll, use NBearLite.QueryColumnsGenerator.exe tool provided by together with NBearLite.dll to generate QueryColumns code from existing database and then freely query your database through NBearLite's strong type query language. Please check code in NBearLite.Test project for basic usage. NBearLite.QueryColumnsGenerator itself is a sample WinForm application using NBearLite. More tutorials is incoming. Q: What is the relation of NBearLite and NBear? A: NBearLite is maintained by NBear team. It shares the DbProvider and query kernalcode of NBear but provides cleaner namespaces, code structure and more powerful data access fucntions working with ADO.NET build-in DataSet instead of Entity classes in NBear. Yes, to begin from NBearLite, there is no need to write any entity classes or entity configurations.

2009-03-11

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

提示
确定要删除当前文章?
取消 删除