日韩欧美1区,国产午夜一区二区三区,国产精品v欧美精品∨日韩

oracle wm_concat函數行轉列多行變一行

oracle10g以上版本提供行轉列組合成字符串函數wm_concat，注意跟其他字段一起select的時候要用group by

例如有個users表如下：

id yhm xm

1 001 小唐

2 002 小李

3 003 小張

select wm_concat(yhm) 用戶名, wm_concat(xm) 姓名 from users

執行結果為：

用戶名姓名

001,002,003 小唐,小李,小張

posted @ 2012-03-23 16:38 yuhaibo736 閱讀(919) | 評論 (0) | 編輯收藏

    public static String lastMonFirstDay(){
        Calendar cal = Calendar.getInstance();
        int year = cal.get(Calendar.YEAR);
        int month = cal.get(Calendar.MONTH) + 1;
        cal.set(Calendar.DAY_OF_MONTH, 1);
        cal.add(Calendar.DAY_OF_MONTH, -1);
        int day = cal.get(Calendar.DAY_OF_MONTH);
        String months = "";
        String days = "";
        if (month > 1) {
            month--;
        } else {
            year--;
            month = 12;
        }
        if (!(String.valueOf(month).length() > 1)) {
            months = "0" + month;
        } else {
            months = String.valueOf(month);
        }
        if (!(String.valueOf(day).length() > 1)) {
            days = "0" + day;
        } else {
            days = String.valueOf(day);
        }
        String firstDay = "" + year + "-" + months + "-01";
        String[] lastMonth = new String[2];
        lastMonth[0] = firstDay;
        return firstDay;
    }

    public static String lastMonLastDay(){
        Calendar cal = Calendar.getInstance();
        int year = cal.get(Calendar.YEAR);
        int month = cal.get(Calendar.MONTH) + 1;
        cal.set(Calendar.DAY_OF_MONTH, 1);
        cal.add(Calendar.DAY_OF_MONTH, -1);
        int day = cal.get(Calendar.DAY_OF_MONTH);
        String months = "";
        String days = "";
        if (month > 1) {
            month--;
        } else {
            year--;
            month = 12;
        }
        if (!(String.valueOf(month).length() > 1)) {
            months = "0" + month;
        } else {
            months = String.valueOf(month);
        }
        if (!(String.valueOf(day).length() > 1)) {
            days = "0" + day;
        } else {
            days = String.valueOf(day);
        }
        String lastDay = "" + year + "-" + months + "-" + days;
        String[] lastMonth = new String[2];
        lastMonth[1] = lastDay;
        return lastDay;
    }

posted @ 2012-03-05 14:36 yuhaibo736 閱讀(644) | 評論 (0) | 編輯收藏

使用Spring JavaMail發送郵件總結

首先導入使用jar包：activation.jar，commons-logging-1.0.4.jar，mail.jar，spring.jar

1、使用xml配置javamail：
在classpath底下新建application-mail.xml，內容如下：

Xml代碼

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd">
<bean id="mailSender"
class="org.springframework.mail.javamail.JavaMailSenderImpl">
<property name="host">
<value>stmp.163.com</value>
</property>
<property name="javaMailProperties">
<props>
<prop key="mail.smtp.auth">true</prop>
<prop key="mail.smtp.timeout">25000</prop>
</props>
</property>
<property name="username">
<value>xxxx@163.com</value>
</property>
<property name="password">
<value>xxxxxx</value>
</property>
</bean>
</beans>

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd">
<!-- 注意:這里的參數(如用戶名、密碼)都是針對郵件發送者的 -->
<bean id="mailSender"
class="org.springframework.mail.javamail.JavaMailSenderImpl">
<property name="host">
<value>stmp.163.com</value>
</property>
<property name="javaMailProperties">
<props>
<prop key="mail.smtp.auth">true</prop>
<prop key="mail.smtp.timeout">25000</prop>
</props>
</property>
<property name="username">
<value>xxxx@163.com</value>
</property>
<property name="password">
<value>xxxxxx</value>
</property>
</bean>
</beans>

或者把以上的Beans配置到applicaiont.xml里面也可以。

2、發送Email類：

Java代碼

public class SendMail {
public ApplicationContext ctx = null;
public SendMail() {
//獲取上下文
ctx = new ClassPathXmlApplicationContext("applicationContext-mail.xml");
}
public void send() {
//獲取JavaMailSender bean
JavaMailSender sender = (JavaMailSender) ctx.getBean("mailSender");
SimpleMailMessage mail = new SimpleMailMessage(); //<SPAN style="COLOR: #ff0000">注意SimpleMailMessage只能用來發送text格式的郵件</SPAN>
try {
mail.setTo("xxx@qq.com");//接受者
mail.setFrom("xxxx@163.com");//發送者,這里還可以另起Email別名，不用和xml里的username一致
mail.setSubject("spring mail test!");//主題
mail.setText("springMail的簡單發送測試");//郵件內容
sender.send(mail);
} catch (Exception e) {
e.printStackTrace();
}
}

public class SendMail {
public ApplicationContext ctx = null;
public SendMail() {
//獲取上下文
ctx = new ClassPathXmlApplicationContext("applicationContext-mail.xml");
}
public void send() {
//獲取JavaMailSender bean
JavaMailSender sender = (JavaMailSender) ctx.getBean("mailSender");
SimpleMailMessage mail = new SimpleMailMessage(); //注意SimpleMailMessage只能用來發送text格式的郵件
try {
mail.setTo("xxx@qq.com");//接受者
mail.setFrom("xxxx@163.com");//發送者,這里還可以另起Email別名，不用和xml里的username一致
mail.setSubject("spring mail test!");//主題
mail.setText("springMail的簡單發送測試");//郵件內容
sender.send(mail);
} catch (Exception e) {
e.printStackTrace();
}
}

發送html格式的Email：

Java代碼

public class SendMail {
public ApplicationContext ctx = null;
public SendMail() {
//獲取上下文
ctx = new ClassPathXmlApplicationContext("applicationContext.xml");
}
public void send() {
//獲取JavaMailSender bean
JavaMailSender sender = (JavaMailSender) ctx.getBean("mailSender");
JavaMailSenderImpl senderImpl = new JavaMailSenderImpl();
MimeMessage mailMessage = senderImpl.createMimeMessage();
//設置utf-8或GBK編碼，否則郵件會有亂碼
MimeMessageHelper messageHelper = new MimeMessageHelper(mailMessage,true,"utf-8");
try {
messageHelper.setTo(email.getEmail());//接受者
messageHelper.setFrom("xxx@163.com");//發送者
messageHelper.setSubject("測試郵件");//主題
//郵件內容，注意加參數true，表示啟用html格式
messageHelper.setText("<html><head></head><body><h1>hello!!chao.wang</h1></body></html>",true);
sender.send(mailMessage);
} catch (Exception e) {
e.printStackTrace();
}
}

public class SendMail {
public ApplicationContext ctx = null;
public SendMail() {
//獲取上下文
ctx = new ClassPathXmlApplicationContext("applicationContext.xml");
}
public void send() {
//獲取JavaMailSender bean
JavaMailSender sender = (JavaMailSender) ctx.getBean("mailSender");
JavaMailSenderImpl senderImpl = new JavaMailSenderImpl();
MimeMessage mailMessage = senderImpl.createMimeMessage();
//設置utf-8或GBK編碼，否則郵件會有亂碼
MimeMessageHelper messageHelper = new MimeMessageHelper(mailMessage,true,"utf-8");
try {
messageHelper.setTo(email.getEmail());//接受者
messageHelper.setFrom("xxx@163.com");//發送者
messageHelper.setSubject("測試郵件");//主題
//郵件內容，注意加參數true，表示啟用html格式
messageHelper.setText("<html><head></head><body><h1>hello!!chao.wang</h1></body></html>",true);
sender.send(mailMessage);
} catch (Exception e) {
e.printStackTrace();
}
}

發送html格式并帶有附件的Email：

Java代碼

public class SendMail {
public ApplicationContext ctx = null;
public SendMail() {
//獲取上下文
ctx = new ClassPathXmlApplicationContext("applicationContext.xml");
}
public void send() {
//獲取JavaMailSender bean
JavaMailSender sender = (JavaMailSender) ctx.getBean("mailSender");
JavaMailSenderImpl senderImpl = new JavaMailSenderImpl();
MimeMessage mailMessage = senderImpl.createMimeMessage();
//設置utf-8或GBK編碼，否則郵件會有亂碼
MimeMessageHelper messageHelper = new MimeMessageHelper(mailMessage,true,"utf-8");
try {
messageHelper.setTo(email.getEmail());//接受者
messageHelper.setFrom("xxx@163.com");//發送者
messageHelper.setSubject("測試郵件");//主題
//郵件內容，注意加參數true
messageHelper.setText("<html><head></head><body><h1>hello!!chao.wang</h1></body></html>",true);
//附件內容
messageHelper.addInline("a", new File("E:/xiezi.jpg"));
messageHelper.addInline("b", new File("E:/logo.png"));
File file=new File("E:/測試中文文件.rar");
// 這里的方法調用和插入圖片是不同的，使用MimeUtility.encodeWord()來解決附件名稱的中文問題
messageHelper.addAttachment(MimeUtility.encodeWord(file.getName()), file);
sender.send(mailMessage);
} catch (Exception e) {
e.printStackTrace();
}
}

posted @ 2012-03-02 14:34 yuhaibo736 閱讀(9349) | 評論 (4) | 編輯收藏

Java集合轉換【List<-->數組、List<-->Set、數組<-->Set、Map-->Set、Map-->List】

public class TestApp {
public static void main(String[] args) {
//List-->數組
List<String> list = new ArrayList<String>();
list.add("蹇偉");
list.add("Jerval");
list.add("杰威");
Object[] objects = list.toArray();//返回Object數組
System.out.println("objects:"+Arrays.toString(objects));
String[] strings1 = new String[list.size()];
list.toArray(strings1);//將轉化后的數組放入已經創建好的對象中
System.out.println("strings1:"+Arrays.toString(strings1));
String[] strings2 = list.toArray(new String[0]);//將轉化后的數組賦給新對象
System.out.println("strings2:"+Arrays.toString(strings2));
//數組-->List
String[] ss = {"JJ","KK"};
List<String> list1 = Arrays.asList(ss);
List<String> list2 = Arrays.asList("AAA","BBB");
System.out.println(list1);
System.out.println(list2);
//List-->Set
List<String> list3 = new ArrayList<String>(new HashSet<String>());
//Set-->List
Set<String> set = new HashSet<String>(new ArrayList<String>());
//數組-->Set
String[] strs = {"AA","BB"};
Set<String> set2 = new HashSet<String>(Arrays.asList(strs));
System.out.println(set2);
//Set-->數組
Set<String> set3 = new HashSet<String>(Arrays.asList("PP","OO"));
String[] strSet = new String[set3.size()];
set3.toArray(strSet);
System.out.println(Arrays.toString(strSet));
//Map操作
Map<String, String> map = new HashMap<String, String>();
map.put("YYY", "UUU");
map.put("RRR", "TTT");
// 將鍵轉化為Set
Set<String> mapKeySet = map.keySet();
// 將值轉化為Set
Set<String> mapValuesSet = new HashSet<String>(map.values());
// 將值轉化為List
List<String> mapValuesList = new ArrayList<String>(map.values());
}
}

posted @ 2012-02-20 15:00 yuhaibo736 閱讀(6134) | 評論 (0) | 編輯收藏

ibatis批量插入表例子

public Integer batchInsertEntitylist(final List<Entity> list) {

return (Integer) this.getSqlMapClientTemplate().execute(new SqlMapClientCallback() {

public Object doInSqlMapClient(SqlMapExecutor executor) throws SQLException {

    executor.startBatch();
    int batch = 0;
    int count = 0;
    for (Entity entity: list) {
     executor.insert("insertEntitylist", entity);
     batch++;
     if (batch == 500) {
      executor.executeBatch();
      batch = 0;
     }
    }
    executor.executeBatch();
    count = 1;
    return count;
   }

});
}

posted @ 2012-02-15 14:00 yuhaibo736 閱讀(2019) | 評論 (0) | 編輯收藏

ASCII碼表

ASCII碼表

信息在計算機上是用二進制表示的，這種表示法讓人理解就很困難。因此計算機上都配有輸入和輸出設備，這些設備的主要目的就是，以一種人類可閱讀的形式將信息在這些設備上顯示出來供人閱讀理解。為保證人類和設備，設備和計算機之間能進行正確的信息交換，人們編制的統一的信息交換代碼，這就是ASCII碼表，它的全稱是“美國信息交換標準代碼”。

八進制	十六進制	十進制	字符	八進制	十六進制	十進制	字符
00	00	0	nul	100	40	64	@
01	01	1	soh	101	41	65	A
02	02	2	stx	102	42	66	B
03	03	3	etx	103	43	67	C
04	04	4	eot	104	44	68	D
05	05	5	enq	105	45	69	E
06	06	6	ack	106	46	70	F
07	07	7	bel	107	47	71	G
10	08	8	bs	110	48	72	H
11	09	9	ht	111	49	73	I
12	0a	10	nl	112	4a	74	J
13	0b	11	vt	113	4b	75	K
14	0c	12	ff	114	4c	76	L
15	0d	13	er	115	4d	77	M
16	0e	14	so	116	4e	78	N
17	0f	15	si	117	4f	79	O
20	10	16	dle	120	50	80	P
21	11	17	dc1	121	51	81	Q
22	12	18	dc2	122	52	82	R
23	13	19	dc3	123	53	83	S
24	14	20	dc4	124	54	84	T
25	15	21	nak	125	55	85	U
26	16	22	syn	126	56	86	V
27	17	23	etb	127	57	87	W
30	18	24	can	130	58	88	X
31	19	25	em	131	59	89	Y
32	1a	26	sub	132	5a	90	Z
33	1b	27	esc	133	5b	91	[
34	1c	28	fs	134	5c	92	\
35	1d	29	gs	135	5d	93	]
36	1e	30	re	136	5e	94	^
37	1f	31	us	137	5f	95	_
40	20	32	sp	140	60	96	'
41	21	33	!	141	61	97	a
42	22	34	"	142	62	98	b
43	23	35	#	143	63	99	c
44	24	36	$	144	64	100	d
45	25	37	%	145	65	101	e
46	26	38	&	146	66	102	f
47	27	39	`	147	67	103	g
50	28	40	(	150	68	104	h
51	29	41	)	151	69	105	i
52	2a	42	*	152	6a	106	j
53	2b	43	+	153	6b	107	k
54	2c	44	,	154	6c	108	l
55	2d	45	-	155	6d	109	m
56	2e	46	.	156	6e	110	n
57	2f	47	/	157	6f	111	o
60	30	48	0	160	70	112	p
61	31	49	1	161	71	113	q
62	32	50	2	162	72	114	r
63	33	51	3	163	73	115	s
64	34	52	4	164	74	116	t
65	35	53	5	165	75	117	u
66	36	54	6	166	76	118	v
67	37	55	7	167	77	119	w
70	38	56	8	170	78	120	x
71	39	57	9	171	79	121	y
72	3a	58	:	172	7a	122	z
73	3b	59	;	173	7b	123	{
74	3c	60	<	174	7c	124	\|
75	3d	61	=	175	7d	125	}
76	3e	62	>	176	7e	126	~
77	3f	63	?	177	7f	127	del

posted @ 2012-02-13 17:30 yuhaibo736 閱讀(163) | 評論 (0) | 編輯收藏

jquery實現文本框只能輸入數字函數

   $j.fn.numeral = function() {
        $j(this).css("ime-mode", "disabled");
        this.bind("keypress",function() {
            if (event.keyCode == 46) {
                if (this.value.indexOf(".") != -1) {
                    return false;
                }
            } else {
                return event.keyCode >= 46 && event.keyCode <= 57;
            }
        });
        this.bind("blur", function() {
            if (this.value.lastIndexOf(".") == (this.value.length - 1)) {
                this.value = this.value.substr(0, this.value.length - 1);
            } else if (isNaN(this.value)) {
                this.value = "";
            }
        });
        this.bind("paste", function() {
            var s = clipboardData.getData('text');
            if (!/\D/.test(s));
            value = s.replace(/^0*/, '');
            return false;
        });
        this.bind("dragenter", function() {
            return false;
        });
        this.bind("keyup", function() {
        if (/(^0+)/.test(this.value)) {
            this.value = this.value.replace(/^0*/, '');
            }
        });
    };

posted @ 2012-02-13 17:25 yuhaibo736 閱讀(1209) | 評論 (2) | 編輯收藏

ibatis in語句參數傳入方法

第一種：傳入參數僅有數組
       <select id="GetEmailList_Test" resultClass="EmailInfo_">
            select *
            from MailInfo with (nolock)
            where ID in
                <iterate open="(" close=")" conjunction="," >
                    #[]#
                </iterate>
        </select>
調用
            string[] strValue = new string[] { "1", "2", "3" };
            Reader.QueryForList<EmailInfoModel>("WebApp_Ibatisnet.dao.GetEmailList_Test", strValue );

       第二種：傳入參數有數組，且有其他數據
        <select id="GetEmailList_Test3" parameterClass="TestIn" resultClass="EmailInfo_">
            select top(#Count#)*
            from MailInfo with (nolock)
            where ID in
            <iterate open="(" close=")" conjunction="," property="ArrValue" >
                #ArrValue[]#
            </iterate>
        </select>
調用
            TestIn ti = new TestIn();
            ti.Count = 1;
            ti.ArrValue = strValue;
            return Reader.QueryForList<EmailInfoModel>("WebApp_Ibatisnet.dao.GetEmailList_Test3", ti);
實體類：
   public class TestIn
    {
        private int count;
        public int Count
        {
            get { return count; }
            set { count = value; }
        }
        private string[] arrValue;
        public string[] ArrValue
        {
            get { return arrValue; }
            set { arrValue = value; }
        }
    }

       第三種：in后面的數據確定，使用string傳入
        <select id="GetEmailList_Test2" parameterClass="TestIn" resultClass="EmailInfo_">
            select *
            from MailInfo with (nolock)
            where ID in
            ($StrValue$)
        </select>
調用
                Reader.QueryForList<EmailInfoModel>("WebApp_Ibatisnet.dao.GetEmailList_Test2", "1,2,3");

其他信息：
Iterate的屬性：
prepend －可被覆蓋的SQL語句組成部分，添加在語句的前面（可選）
property －類型為java.util.List的用于遍歷的元素（必選）
open －整個遍歷內容體開始的字符串，用于定義括號（可選）
close －整個遍歷內容體結束的字符串，用于定義括號（可選）
conjunction －每次遍歷內容之間的字符串，用于定義AND或OR（可選）
<iterate>遍歷類型為java.util.List的元素。

posted @ 2012-02-03 10:11 yuhaibo736 閱讀(16612) | 評論 (1) | 編輯收藏

獲取客戶端和服務器ip地址

//獲取客戶端ip地址

public String getIpAddr(HttpServletRequest request) {

String ip = request.getHeader("x-forwarded-for");

if(ip == null || ip.length() == 0 || "unknown".equalsIgnoreCase(ip)) {

ip = request.getHeader("Proxy-Client-IP");

}

if(ip == null || ip.length() == 0 || "unknown".equalsIgnoreCase(ip)) {

ip = request.getHeader("WL-Proxy-Client-IP");

}

if(ip == null || ip.length() == 0 || "unknown".equalsIgnoreCase(ip)) {

ip = request.getRemoteAddr();

}

return ip;

}

//獲取服務器ip地址

InetAddress inet = InetAddress.getLocalHost();

String hostAddress=inet.getHostAddress();

posted @ 2012-01-17 11:01 yuhaibo736 閱讀(823) | 評論 (0) | 編輯收藏

map的三種遍歷方法！

集合的一個很重要的操作---遍歷，學習了三種遍歷方法，三種方法各有優缺點~~
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package cn.tsp2c.liubao;
import java.util.Collection;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Map;
import java.util.Set;
import java.util.TreeMap;
/**
*
* @author Administrator
*/
public class TestMap {
    public static void main(String[] args) {
        Map<String, Student> map = new HashMap<String, Student>();
        Student s1 = new Student("宋江", "1001", 38);
        Student s2 = new Student("盧俊義", "1002", 35);
        Student s3 = new Student("吳用", "1003", 34);

        map.put("1001", s1);
        map.put("1002", s2);
        map.put("1003", s3);
        Map<String, Student> subMap = new HashMap<String, Student>();
        subMap.put("1008", new Student("tom", "1008", 12));
        subMap.put("1009", new Student("jerry", "1009", 10));
        map.putAll(subMap);
        work(map);
        workByKeySet(map);
        workByEntry(map);
    }
　　//最常規的一種遍歷方法，最常規就是最常用的，雖然不復雜，但很重要，這是我們最熟悉的，就不多說了！！
    public static void work(Map<String, Student> map) {
        Collection<Student> c = map.values();
        Iterator it = c.iterator();
        for (; it.hasNext();) {
            System.out.println(it.next());
        }
    }
　　//利用keyset進行遍歷，它的優點在于可以根據你所想要的key值得到你想要的 values，更具靈活性！！
    public static void workByKeySet(Map<String, Student> map) {
        Set<String> key = map.keySet();
        for (Iterator it = key.iterator(); it.hasNext();) {
            String s = (String) it.next();
            System.out.println(map.get(s));
        }
    }
　　//比較復雜的一種遍歷在這里，呵呵~~他很暴力哦，它的靈活性太強了，想得到什么就能得到什么~~
    public static void workByEntry(Map<String, Student> map) {
        Set<Map.Entry<String, Student>> set = map.entrySet();
        for (Iterator<Map.Entry<String, Student>> it = set.iterator(); it.hasNext();) {
            Map.Entry<String, Student> entry = (Map.Entry<String, Student>) it.next();
            System.out.println(entry.getKey() + "--->" + entry.getValue());
        }
    }
}
class Student {
    private String name;
    private String id;
    private int age;
    public Student(String name, String id, int age) {
        this.name = name;
        this.id = id;
        this.age = age;
    }
    @Override
    public String toString() {
        return "Student{" + "name=" + name + "id=" + id + "age=" + age + '}';
    }
}

posted @ 2012-01-17 10:58 yuhaibo736 閱讀(214) | 評論 (0) | 編輯收藏

yuhaibo736

oracle wm_concat函數行轉列多行變一行

獲取上個月的第一天和最后一天

使用Spring JavaMail發送郵件總結

Java集合轉換【List<-->數組、List<-->Set、數組<-->Set、Map-->Set、Map-->List】

ibatis批量插入表例子

ASCII碼表

jquery實現文本框只能輸入數字函數

ibatis in語句參數傳入方法

獲取客戶端和服務器ip地址

map的三種遍歷方法！

日歷

常用鏈接

留言簿

隨筆檔案

文章檔案

搜索

最新評論

閱讀排行榜

評論排行榜