<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Mjh0801的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/Mjh0801</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Mjh0801]]></copyright><item><title><![CDATA[MySQL常用及复杂sql]]></title><link>https://blog.youkuaiyun.com/Mjh0801/article/details/120827838</link><guid>https://blog.youkuaiyun.com/Mjh0801/article/details/120827838</guid><author>Mjh0801</author><pubDate>Mon, 18 Oct 2021 16:47:54 +0800</pubDate><description><![CDATA[本文主要是总结一下我遇到过的常用的和复杂的sql语句

查询

进行模糊查询的时候有三种方式

# 模糊查询name为'cs'的
    name like '%cs%' 全匹配
    
# 模糊查询name开头为'cs'的
    like '%cs' 左匹配
    
# 模糊查询name结尾为'cs'的
    like 'cs%' 右匹配


修改

现在有两张表A和B，通过 A.uuid = B.aUuid关联，现在想要把b里的name字段赋值到A的name字段里，可以这样写

    upd.]]></description><category></category></item><item><title><![CDATA[mvc访问静态资源]]></title><link>https://blog.youkuaiyun.com/Mjh0801/article/details/102505098</link><guid>https://blog.youkuaiyun.com/Mjh0801/article/details/102505098</guid><author>Mjh0801</author><pubDate>Fri, 11 Oct 2019 17:16:51 +0800</pubDate><description><![CDATA[实现Controller跳转的jsp页面中调用WEB-INF下的静态资源（js,css,img）
1.在springmvc-config.xml中配置mvc
&lt;?xml version="1.0" encoding="UTF-8"?&gt;
&lt;beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:x...]]></description><category></category></item><item><title><![CDATA[订单的初步静态模型]]></title><link>https://blog.youkuaiyun.com/Mjh0801/article/details/99725020</link><guid>https://blog.youkuaiyun.com/Mjh0801/article/details/99725020</guid><author>Mjh0801</author><pubDate>Mon, 19 Aug 2019 14:21:01 +0800</pubDate><description><![CDATA[1.add.html
&lt;!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"&gt;
&lt;HTML&gt;
&lt;HEAD&gt;
&lt;TITLE&gt; New Document &lt;/TITLE&gt;
&lt;/HEAD&gt;
&lt;BODY&gt;
&lt;TABLE border="1" widt...]]></description><category></category></item><item><title><![CDATA[反射]]></title><link>https://blog.youkuaiyun.com/Mjh0801/article/details/98726415</link><guid>https://blog.youkuaiyun.com/Mjh0801/article/details/98726415</guid><author>Mjh0801</author><pubDate>Wed, 07 Aug 2019 09:49:15 +0800</pubDate><description><![CDATA[1.Student类
package com.pro.test;

public class Student {

	private int stId;
	private String stName;
	private int age;
	public void ff(String stId,String stName,int age) {
		System.out.println(stId+st...]]></description><category></category></item><item><title><![CDATA[多线程，奇数偶数，生产者，消费者]]></title><link>https://blog.youkuaiyun.com/Mjh0801/article/details/98725644</link><guid>https://blog.youkuaiyun.com/Mjh0801/article/details/98725644</guid><author>Mjh0801</author><pubDate>Wed, 07 Aug 2019 09:40:34 +0800</pubDate><description><![CDATA[一、奇数偶数
1.Date
public class Date {

	private int num;

	public int getNum() {
		return num;
	}

	public void setNum(int num) {
		this.num = num;
	}

	public Date(int num) {
		super();
		this.num = num;...]]></description><category></category></item><item><title><![CDATA[OCJP题库1Z0-851（21/30）]]></title><link>https://blog.youkuaiyun.com/Mjh0801/article/details/97019434</link><guid>https://blog.youkuaiyun.com/Mjh0801/article/details/97019434</guid><author>Mjh0801</author><pubDate>Tue, 23 Jul 2019 19:00:42 +0800</pubDate><description><![CDATA[1.Given a pre-generics implementation of a method:
11. public static int sum(List list) {
12. int sum = 0;
13. for ( Iterator iter = list.iterator(); iter.hasNext(); ) {
14. int i = ((Integer)iter.nex...]]></description><category></category></item><item><title><![CDATA[用ArrayList模拟数据库]]></title><link>https://blog.youkuaiyun.com/Mjh0801/article/details/96171921</link><guid>https://blog.youkuaiyun.com/Mjh0801/article/details/96171921</guid><author>Mjh0801</author><pubDate>Tue, 16 Jul 2019 19:33:04 +0800</pubDate><description><![CDATA[**
//person属性
**
public class Person {

	int pId;
	String pName;
	int age;
	public Person(int pId, String pName, int age) {
		super();
		this.pId = pId;
		this.pName = pName;
		this.age = age;
	}
	pub...]]></description><category></category></item></channel></rss>