工作笔记00

布满荆棘的人生 2021-12-20 07:23 284阅读 0赞

1、mysql中查询一个数据库中的所有表

SELECT  
table\_name,  
table\_comment  
FROM  
information\_schema.tables  
WHERE table\_schema = 'ysy\_cat';

2、mybatis plus查询日期区间

<if test="beginDate != null">
        AND soo.stock_out_date <![CDATA[>=]]> #{beginDate}
    </if>
    <if test="endDate != null">
        AND soo.stock_out_date <![CDATA[<=]]>#{endDate}
    </if>
    3、mysql中将datetime转换为date类型：
    SELECT CONVERT('传入的时间',DATE)
    4、mybatis中if-else写法

<choose>
       <when test="item.id != null and item.id !=''">
         #{item.id,jdbcType=CHAR},
       </when>
       <otherwise>
         '',
       </otherwise>
    </choose>
    5、sourcetree錯誤：error: Your local changes to the following files would be overwritten by merge:解決办法 git stash git pull origin master git stash pop 6、mybatis中模糊查询

AND u.name LIKE CONCAT(CONCAT('%',#{applicantId},'%'))
    7、
    
    <insert id="insertStockOutOrder" parameterType="com.yunsunyun.entity.monitor.po.CaStockOutOrder">

<selectKey resultType ="java.lang.Long" keyProperty= "id" order= "AFTER">
          SELECT LAST_INSERT_ID()
        </selectKey >
        INSERT INTO ca_stock_out_order (warehouse_id,code,create_id,create_time)
        VALUE (#{warehouseId},#{code},#{createId},#{createTime})
    </insert>
    
    <insert id="insertStockOutOrderItem" parameterType="java.util.List">
        <selectKey resultType ="java.lang.Long" keyProperty= "id" order= "AFTER">
            SELECT LAST_INSERT_ID()
        </selectKey >
        INSERT INTO ca_stock_out_order_item (stock_out_order_id,asset_id,quantity,in_order_item_type)
        values
        <foreach collection ="list" item="orderItemVos" index= "index" separator =",">
            (
            #{orderItemVos.stockOutOrderId}, #{orderItemVos.assetId},
            #{orderItemVos.quantity},
            #{orderItemVos.orderItemType}
            )
        </foreach >
    </insert>
    ---------

select STR_TO_DATE(#{startTime},'%H:%i:%s')
    将字符串转为想要的时间格式

select str\_to\_date(‘09/01/2009’,’%m/%d/%Y’)

select str\_to\_date(‘20140422154706’,’%Y%m%d%H%i%s’)

select str\_to\_date(‘2014-04-22 15:47:06’,’%Y-%m-%d %H:%i:%s’)

\-----------------------------------

@DatetimeFormat是将String转换成Date，一般前台给后台传值时用

@JsonFormat(pattern="yyyy-MM-dd")  将Date转换成String  一般后台传值给前台时

\----------------------------------------

2      <insert id ="insertCodeBatch" parameterType="java.util.List" >
     3             <selectKey resultType ="java.lang.Integer" keyProperty= "id"
     4                  order= "AFTER">
     5                 SELECT LAST_INSERT_ID()
     6             </selectKey >
     7            insert into redeem_code
     8            (bach_id, code, type, facevalue,create_user,create_time)
     9            values
    10             <foreach collection ="list" item="reddemCode" index= "index" separator =",">
    11                 (
    12                 #{reddemCode.batchId}, #{reddemCode.code},
    13                 #{reddemCode.type},
    14                 #{reddemCode.facevalue},
    15                 #{reddemCode.createUser}, #{reddemCode.createTime}
    16                 )
    17             </foreach >
    18      </insert >
    -------------------------------
    获取上个月,下个月

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM");
    Date dt = sdf.parse(yearsMonth);
    Calendar rightNow = Calendar.getInstance();
    rightNow.setTime(dt);
    rightNow.add(Calendar.MONTH, -1);
    Date dt1 = rightNow.getTime();
    
    
    -------------------------
    日期校验

public boolean isValidDate(String s)\{  
try \{  
// 指定日期格式为四位年/两位月份/两位日期，注意yyyy-MM-dd其中MM为大写  
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-mm");  
// 设置lenient为false. 否则SimpleDateFormat会比较宽松地验证日期，比如2004/02/29会被接受，并转换成2004/03/01  
dateFormat.setLenient(false);  
dateFormat.parse(s);  
return true;  
\}catch (Exception e) \{  
// 如果throw java.text.ParseException或者NullPointerException，就说明格式不对  
return false;  
\}  
\}

-------------------------------

CONCAT\_WS(' ',(SELECT DATE\_FORMAT(applicant.start\_date,'%Y-%m-%d')), CONCAT((SELECT DATE\_FORMAT(applicant.start\_date,'%H:%i')),'-',(SELECT DATE\_FORMAT(applicant.end\_date,'%H:%i')))) AS times,

\----------------------------------------------------

java获取移动端ip地址

String ipAddress = request.getRemoteAddr();  
if(ipAddress.equals("127.0.0.1") || ipAddress.equals("0:0:0:0:0:0:0:1"))\{  
//根据网卡获取本机配置的IP地址  
InetAddress inetAddress = null;  
try \{  
inetAddress = InetAddress.getLocalHost();  
\}  
catch (UnknownHostException e) \{  
e.printStackTrace();  
\}  
ipAddress = inetAddress.getHostAddress();  
\}  
//对于通过多个代理的情况，第一个IP为客户端真实的IP地址，多个IP按照','分割  
if(null != ipAddress && ipAddress.length() > 15)\{  
if(ipAddress.indexOf(",") > 0)\{  
ipAddress = ipAddress.substring(0, ipAddress.indexOf(","));  
\}  
\}  
\-------------------------------------------

前台出入的日期格式化

@DateTimeFormat(pattern = "yyyy-MM")@RequestParam(value = "date", required = false) Date date

转载于:https://www.cnblogs.com/lcwstudy/p/10874446.html