随笔分类 -  Study

sql convert函数使用小结
摘要：sql convert函数使用小结CONVERT(data_type,expression[,style]) convert(varchar(10),字段名,转换格式)说明:此样式一般在时间类型(datetime,smalldatetime)与字符串类型(nchar,nvarchar,char,varchar)相互转换的时候才用到.语句 结果SELECT CONVERT(varchar(100), GETDATE(), 0) 07 15 2009 4:06PMSELECT CONVERT(varchar(100), GETDATE(), 1) 07/15/09SELECT CONVERT(va 阅读全文
posted @ 2010-12-27 11:16 mylitboy 阅读(220) 评论(0) 推荐(0)
一个简单的iBatis入门例子
摘要：一个简单的iBatis入门例子，用ORACLE和Java测试目录结构：1.导入iBatis和oracle驱动。 ibatis-2.3.4.726.jar ojdbc14.jar2.创建类com/you/me/User.javapackage com.you.me;/** * author:you.me 2010-12-22 * */public class User { private int id; private String name; private String sex; private int age; private String username; private Strin. 阅读全文
posted @ 2010-12-21 16:59 mylitboy 阅读(137) 评论(0) 推荐(0)
Java 学习笔记
摘要：eclipse3.2英文版官网下载http://archive.eclipse.org/eclipse/downloads/drops/R-3.2.2-200702121330/eclipse-SDK-3.2.2-win32.zipeclipse3.2汉化包官网下载http://archive.eclipse.org/eclipse/downloads/drops/L-3.2_Language_Packs-200607121700/NLpack1-eclipse-SDK-3.2-win32.zipswt插件下载http://archive.eclipse.org/eclipse/downloa 阅读全文
posted @ 2008-10-05 10:32 mylitboy 阅读(96) 评论(0) 推荐(0)