test

排序算法和 Java 集合&工具类；
多线程和并发包；
存储相关：Redis 、Elastic Search、MySQL；
框架：Spring，SpringMVC，Spring Boot
分布式：Dubbo；
设计模式；
https://github.com/alibaba
https://www.cnblogs.com/zhangxingeng/p/10721083.html
http://wiki.zjs.com.cn/bin/view/Blog/2019ZJS微服务监控体系建立%EF%BC%88性能、健康、链路%EF%BC%89/

场景应用

mybatis curd 配置

Install-Package Microsoft.Web.RedisSessionStateProvider -Version 4.0.1

Spring Cloud与Docker微服务架构实战
1，https://start.spring.io/
mysql
2，idea maven 更新
左下角窗口 maven projects lifecycle 

方法：

　　方法一：

　　①、右键单击项目；

　　②、在弹出菜单中选择Maven|Reimport菜单项。

　　方法二：

　　IDEA将通过网络自动下载相关依赖，并存放在Maven的本地仓库中。另外，可以将Maven的刷新设置为自动，配置方法为：

　　①、单击File|Setting菜单项，打开Settings选项卡;

 　　 ②、在左侧的目录树中，展开Maven节点；

　　③、勾选Import Maven projects automatically选择;

　　④、项目右键->Maven->Reimport;

　　经更新。

3.
?serverTimezone=UTC"

alter user 'root'@'%' identified with mysql_native_password by '123456';

idea 格式化
安装myql密码认证用普通。
mybatis-generator
https://www.cnblogs.com/gdjlc/p/10042815.html
https://mvnrepository.com/artifact/mysql/mysql-connector-java/5.1.37
run edit configurations 加maven name mybatis-generator  command line mybatis-generator:generate -e

一键格式化代碼: Ctrl+Alt+L

mybatis generator caching_sha2_password 

https://www.cnblogs.com/gdjlc/p/10042815.html

https://blog.csdn.net/qq_40223688/article/details/88191732

没有安装redis的时候报错
Error creating bean with name 'enableRedisKeyspaceNotificationsInitializer' defined in class path resource
下载安装就解决了报错
https://github.com/MicrosoftArchive/redis/releases

Cannot find template location: classpath:/templates/ (please add some templates or check your Thymeleaf configuration)

#thymeleaf
spring.thymeleaf.prefix=classpath:/templates/
spring.thymeleaf.suffix=.html
spring.thymeleaf.cache=false
spring.thymeleaf.mode=LEGACYHTML5
spring.thymeleaf.encoding=UTF-8 

spring.thymeleaf.cache=true # Enable template caching.
spring.thymeleaf.check-template=true # Check that the template exists before rendering it.
spring.thymeleaf.check-template-location=true # Check that the templates location exists.
##spring.thymeleaf.content-type=text/html # Content-Type value.
spring.thymeleaf.enabled=true # Enable MVC Thymeleaf view resolution.
spring.thymeleaf.encoding=UTF-8 # Template encoding.
spring.thymeleaf.excluded-view-names= # Comma-separated list of view names that should be excluded from resolution.
spring.thymeleaf.mode=HTML5 # Template mode to be applied to templates. See also StandardTemplateModeHandlers.
spring.thymeleaf.prefix=classpath:/templates/ # Prefix that gets prepended to view names when building a URL.
spring.thymeleaf.suffix=.html # Suffix that gets appended to view names when building a URL.
spring.thymeleaf.template-resolver-order= # Order of the template resolver in the chain.
spring.thymeleaf.view-names= # Comma-separated list of view names that can be resolved.

Tbschedule

                    sql = "insert into qyxx(a,b,c,ddd,qh,yb,cuser,ctime) values(@a,@b,@c,@ddd,@qh,@yb,@cuser,@ctime)";
                    ArrayList arr = new ArrayList();
                    arr.Add(item["a"].ToString());
                    arr.Add(item["b"].ToString());
                    arr.Add(item["c"].ToString());
                    arr.Add(item["a"].ToString() + item["b"].ToString() + item["c"].ToString());
                    arr.Add(item["qh"].ToString());
                    arr.Add(item["yb"].ToString());
                    arr.Add(TcpServer.Session.userid);
                    arr.Add(sj);
                    SQLiteHelper.ExecuteNonQuery(sql, arr.ToArray());

        Query query =new Query();
        Criteria criteria =    Criteria.where("aladinID").is(aladinId);
        criteria.andOperator(
            Criteria.where("updateTime").is(updateTime)
        );    
        query.addCriteria(criteria);
        return mongoTemplate.findOne(query, MqOutStockDto.class);

        private void Form1_Load(object sender, EventArgs e)
        {
            test t = new test();
            string tt = t.id.ToString();
            DataCommand.Insert(t);
        }
    }
    //没有使用反射,替代反射的方式。
    public class test : IData
    {
        public int id { get; set; }
        public Dictionary<string, object> getData()
        {
            Dictionary<string, object> dict = new Dictionary<string, object>();
            dict.Add("id", this.id);
            return dict;
        }
        public string GetValue(string Name)
        {
            string val = null;
            switch (Name)
            {
                case "id":
                    val = this.id.ToString();
                    break;

            }
            return val;
        }
        public void SetValue(string Name,string Value)
        {
            switch (Name)
            {
                case "id":
                    this.id = Convert.ToInt32(Value);
                    break;

            }
        }
    }
    public interface IData
    {
        Dictionary<string, object> getData();
        object GetValue(string Name);
        void SetValue(string Name, string Value);
    }
    public class  DataCommand
    {
        public static void Insert(IData data)
        {

        }
    }
    //参数化安全
    //DataCommand command = new DataCommand();
    //command.Add("");

    //SqlCommand sqlcommand = new SqlCommand();
    //sqlcommand.Parameters.Add("",);
    //public class DataCommand
    //{
    //    private IDbCommand dbprom;
    //    public void Add(string Name, object Value)
    //    {

    //    }
    //}

用msql拆库
mysql 123456
port 3366

下面这些都是作为默认值来看待的。
沉静、谦逊、耕耘、收获-----不谈人生、不谈理想、只谈技术！
空白。
0
0.00
1900-01-01
hessian
JVM；