<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[One__PieceLufei的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/One__PieceLufei</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; One__PieceLufei]]></copyright><item><title><![CDATA[ORACLE SEQUENCE在xml中的实现]]></title><link>https://blog.youkuaiyun.com/One__PieceLufei/article/details/79231187</link><guid>https://blog.youkuaiyun.com/One__PieceLufei/article/details/79231187</guid><author>One__PieceLufei</author><pubDate>Thu, 01 Feb 2018 17:25:37 +0800</pubDate><description><![CDATA[select SEQ_student_ID.NEXTVAL from dual
   	
  	insert into BASE_REGIST_RADIO
    
      id,
      
        name,
       
    
  	 #{id,jdbcType=INTEGER},
      
        #{name},
      
  
  

这样即可]]></description><category></category></item><item><title><![CDATA[highcharts中设置被x轴和y轴围在里面的背景色]]></title><link>https://blog.youkuaiyun.com/One__PieceLufei/article/details/78813272</link><guid>https://blog.youkuaiyun.com/One__PieceLufei/article/details/78813272</guid><author>One__PieceLufei</author><pubDate>Fri, 15 Dec 2017 15:07:09 +0800</pubDate><description><![CDATA[highcharts中设置被x轴和y轴围在里面的背景色


如果y轴标签单位被覆盖，则设置margintop和marginright
在charts属性中设置，如下
 chart: {
        	marginRight: 20,
            marginTop: 20,
            type: 'spline',
            zoomType:]]></description><category></category></item><item><title><![CDATA[文本框中 只能显示2位整数]]></title><link>https://blog.youkuaiyun.com/One__PieceLufei/article/details/78491531</link><guid>https://blog.youkuaiyun.com/One__PieceLufei/article/details/78491531</guid><author>One__PieceLufei</author><pubDate>Thu, 09 Nov 2017 16:55:56 +0800</pubDate><description><![CDATA[文本框中 只能显示2位整数
oninput="if(value.length>2)value=value.slice(0,2)" onkeyup="if(this.value.length==1){this.value=this.value.replace(/[^0-9]/g,'')}else{this.value=this.value.replace(/\D/g,'')}" onafterpa]]></description><category></category></item><item><title><![CDATA[check数字，小数的位数以及Ip]]></title><link>https://blog.youkuaiyun.com/One__PieceLufei/article/details/78410620</link><guid>https://blog.youkuaiyun.com/One__PieceLufei/article/details/78410620</guid><author>One__PieceLufei</author><pubDate>Wed, 01 Nov 2017 09:43:34 +0800</pubDate><description><![CDATA[check数字，小数的位数的长度
jsp中如下

js中如下
function checkNum(obj) {
     //检查是否是非数字值
     if (isNaN(obj.value)) {
         obj.value = "";
     }
     if (obj != null) {
    	 if(obj.value.toString().split(".]]></description><category></category></item><item><title><![CDATA[页面滚动条的实现]]></title><link>https://blog.youkuaiyun.com/One__PieceLufei/article/details/78407018</link><guid>https://blog.youkuaiyun.com/One__PieceLufei/article/details/78407018</guid><author>One__PieceLufei</author><pubDate>Tue, 31 Oct 2017 19:36:04 +0800</pubDate><description><![CDATA[页面滚动条的实现
在jsp页面中，先创建一个div，如下


在css中写入
#scrollline{
	line-height: 2px;
    height: 200px;
    overflow: scroll;
}
如果想每次点击都默认滚动条在最上方，则在js中加入一句话
$("#scrollline").scrollTop(0);
这样一个简单的滚动条就好了]]></description><category></category></item><item><title><![CDATA[oracle内连接]]></title><link>https://blog.youkuaiyun.com/One__PieceLufei/article/details/78406883</link><guid>https://blog.youkuaiyun.com/One__PieceLufei/article/details/78406883</guid><author>One__PieceLufei</author><pubDate>Tue, 31 Oct 2017 19:20:35 +0800</pubDate><description><![CDATA[SELECT p1.id, p1.ra_id, p1.name
   FROM student p1 
   	inner join student p2 
    on   p2.id=p1.ra_id  ;]]></description><category></category></item><item><title><![CDATA[ORACLE SEQUENCE 的用法]]></title><link>https://blog.youkuaiyun.com/One__PieceLufei/article/details/78257720</link><guid>https://blog.youkuaiyun.com/One__PieceLufei/article/details/78257720</guid><author>One__PieceLufei</author><pubDate>Tue, 17 Oct 2017 10:34:40 +0800</pubDate><description><![CDATA[Create Sequence  
创建语句如下：
CREATE SEQUENCE test
INCREMENT BY 1 -- 每次加几个
START WITH 1 -- 从1开始计数
NOMAXvalue -- 不设置最大值
NOCYCLE -- 一直累加，不循环
CACHE 10; --设置缓存cache个序列，如果系统down掉了或者其它情况将会导致序列不连续，也可以设置为------]]></description><category></category></item><item><title><![CDATA[jqgrid colmodel格式化时间]]></title><link>https://blog.youkuaiyun.com/One__PieceLufei/article/details/78257527</link><guid>https://blog.youkuaiyun.com/One__PieceLufei/article/details/78257527</guid><author>One__PieceLufei</author><pubDate>Tue, 17 Oct 2017 10:23:36 +0800</pubDate><description><![CDATA[在js中对应的时间标签这样写
{ label: '创建时间', name: 'createTime', index: "create_time", width: 80,formatter:function(value,options,row){  return new Date(value).Format('yyyy-MM-dd hh:mm:ss');}}



在js的最后面加上下面的]]></description><category></category></item><item><title><![CDATA[检查输入值字符串是否为空,一串字符是否全部是数字,手机号码格式,邮箱，两位小数的共通验证]]></title><link>https://blog.youkuaiyun.com/One__PieceLufei/article/details/78027373</link><guid>https://blog.youkuaiyun.com/One__PieceLufei/article/details/78027373</guid><author>One__PieceLufei</author><pubDate>Tue, 19 Sep 2017 10:44:09 +0800</pubDate><description><![CDATA[/**
 * 共通验证
 */
/**
 * 检查输入值字符串是否为空
 * 输入:str 字符串
 * 返回:true 或 flase; true表示为空
 */
function checkNull(str) {
	if (str == null || $.trim(str).length == 0) {
		return true;
	}
	return false;
}

/**
 * 检]]></description><category></category></item><item><title><![CDATA[当点击(批量)删除后，需要删除好几张表]]></title><link>https://blog.youkuaiyun.com/One__PieceLufei/article/details/77686612</link><guid>https://blog.youkuaiyun.com/One__PieceLufei/article/details/77686612</guid><author>One__PieceLufei</author><pubDate>Tue, 29 Aug 2017 20:18:08 +0800</pubDate><description><![CDATA[delete from class where id in
		<foreach item="id" collection="array" open="(" separator=","
			close=")">
			#{id}
		
		;
		delete from students where classid in 
		
			#{classid}
		
当删除班级的时候，把班级所在的学]]></description><category></category></item><item><title><![CDATA[当在数据库为数字，需要显示的为文字的时候怎么处理（如性别，星期）]]></title><link>https://blog.youkuaiyun.com/One__PieceLufei/article/details/77508406</link><guid>https://blog.youkuaiyun.com/One__PieceLufei/article/details/77508406</guid><author>One__PieceLufei</author><pubDate>Wed, 23 Aug 2017 17:08:23 +0800</pubDate><description><![CDATA[当在数据库为数字，需要显示的为文字的时候怎么处理（如性别，星期）
其中A为java的一个类
以星期为例
			  A.getWeekno() == 1 ? "周一"
                          :A.getWeekno() == 1 ? "周一"
                          : A.getWeekno() == 3 ? "周三"
      ]]></description><category></category></item><item><title><![CDATA[在两个日期之间查询数据]]></title><link>https://blog.youkuaiyun.com/One__PieceLufei/article/details/77116575</link><guid>https://blog.youkuaiyun.com/One__PieceLufei/article/details/77116575</guid><author>One__PieceLufei</author><pubDate>Sat, 12 Aug 2017 14:51:59 +0800</pubDate><description><![CDATA[根据日历时间进行查询
在HTML中写入
	开始时间
	
	结尾时间
	
	查询



然后在js中写入
$("#startTime").datepicker({
      	   format: "yyyy-mm-dd",
           autoclose: true,
           todayBtn: true,
           todayHighlight]]></description><category></category></item><item><title><![CDATA[判断日期是否过期，以及根据日期判断周几]]></title><link>https://blog.youkuaiyun.com/One__PieceLufei/article/details/76841852</link><guid>https://blog.youkuaiyun.com/One__PieceLufei/article/details/76841852</guid><author>One__PieceLufei</author><pubDate>Mon, 07 Aug 2017 14:46:54 +0800</pubDate><description><![CDATA[判断日期是否过期
 Date dates;
	        try
	        {
	            dates = new SimpleDateFormat("yyyy-MM-dd").parse(hisR.getldate());
	            Date sysdate = new SimpleDateFormat("yyyy-MM-dd").parse(new ]]></description><category></category></item><item><title><![CDATA[使用js下载pdf文档，点击下载不打开文档，直接下载]]></title><link>https://blog.youkuaiyun.com/One__PieceLufei/article/details/76684737</link><guid>https://blog.youkuaiyun.com/One__PieceLufei/article/details/76684737</guid><author>One__PieceLufei</author><pubDate>Fri, 04 Aug 2017 14:45:35 +0800</pubDate><description><![CDATA[使用js下载pdf文档，点击下载不打开文档，直接下载

在html中写入
 下载


在js中写入
download: function() {
			var id = getSelectedRow();
			if(id == null){
				return ;
			}
			var rowData = $("#jqGrid").getRowData(id);
			var u]]></description><category></category></item><item><title><![CDATA[实现二级联动]]></title><link>https://blog.youkuaiyun.com/One__PieceLufei/article/details/76684035</link><guid>https://blog.youkuaiyun.com/One__PieceLufei/article/details/76684035</guid><author>One__PieceLufei</author><pubDate>Fri, 04 Aug 2017 14:32:45 +0800</pubDate><description><![CDATA[实现二级联动，选择一个城市，下个选择框中会出现选择了的城市里面的地区，如下
html中的代码  
这是选择地区


			   	 <select  v-model="address.addressid" 
			   	         @change="selectChange(address.addressid)">
			   	 --请选择地区--
			   
			   	 ]]></description><category></category></item><item><title><![CDATA[There is no getter for property named 'studentno ' in 'class java.lang.String']]></title><link>https://blog.youkuaiyun.com/One__PieceLufei/article/details/76650520</link><guid>https://blog.youkuaiyun.com/One__PieceLufei/article/details/76650520</guid><author>One__PieceLufei</author><pubDate>Thu, 03 Aug 2017 20:47:38 +0800</pubDate><description><![CDATA[当传入一个参数的时候需要在xml中写value 而不是参数名字
如 		
			
				 studentno LIKE CONCAT('%', #{value}, '%')
			
		这样就可以解决了]]></description><category></category></item><item><title><![CDATA[使用js下载pdf文件]]></title><link>https://blog.youkuaiyun.com/One__PieceLufei/article/details/76544585</link><guid>https://blog.youkuaiyun.com/One__PieceLufei/article/details/76544585</guid><author>One__PieceLufei</author><pubDate>Tue, 01 Aug 2017 16:39:01 +0800</pubDate><description><![CDATA[使用js下载pdf文件，可浏览后再下载
在html中写入

 下载 

在js文件中写入
download: function() {
			
			var id = getSelectedRow();
			if(id == null){
				return ;
			}
			
			var rowData = $("#jqGrid").getRowData(id);
			va]]></description><category></category></item><item><title><![CDATA[参数一个以上的问题解决方法]]></title><link>https://blog.youkuaiyun.com/One__PieceLufei/article/details/76528139</link><guid>https://blog.youkuaiyun.com/One__PieceLufei/article/details/76528139</guid><author>One__PieceLufei</author><pubDate>Tue, 01 Aug 2017 14:49:24 +0800</pubDate><description><![CDATA[在使用Spring，SpirngMVC,Mybatis这三大框架的时候，若要在Controller层中传2个参数，则需要在ServiceImpl里把参数封装一下，例如：
@Override
    public HisDocEntity getDocId(String sta, Integer id)
    {
        
        Map params = new Has]]></description><category></category></item><item><title><![CDATA[遇到Expected one result (or null) to be returned by selectOne(), but found: 2怎么解决]]></title><link>https://blog.youkuaiyun.com/One__PieceLufei/article/details/76527295</link><guid>https://blog.youkuaiyun.com/One__PieceLufei/article/details/76527295</guid><author>One__PieceLufei</author><pubDate>Tue, 01 Aug 2017 14:38:48 +0800</pubDate><description><![CDATA[在编程过程过，运行后会出现Expected one result (or null) to be returned by selectOne(), but found: 2的错误


其意思为查询的结果应该是一条，但实际查询的结果是多条或是空的


这时应该去看下数据库里面的记录是不是只有一条记录]]></description><category></category></item><item><title><![CDATA[MySQL的三大范式]]></title><link>https://blog.youkuaiyun.com/One__PieceLufei/article/details/76218903</link><guid>https://blog.youkuaiyun.com/One__PieceLufei/article/details/76218903</guid><author>One__PieceLufei</author><pubDate>Thu, 27 Jul 2017 20:27:33 +0800</pubDate><description><![CDATA[1.需要保证每一列的原子性
2.确保表中的每列都和主键有关
3.确保每列都和主键直接相关，不是间接相关]]></description><category></category></item></channel></rss>