sql复制代码select count(*) from tradeLog where month(createTime)=7;

csharp复制代码mysql> select count(*) from tradeLog where
    -> (createTime >= '2016-7-1' and createTime<'2016-8-1') or
    -> (createTime >= '2017-7-1' and createTime<'2017-8-1') or
    -> (createTime >= '2018-7-1' and createTime<'2018-8-1');

csharp复制代码select * from tradeLog where id+1=10000;

csharp复制代码mysql> select * from tradeLog where tradeid=1007;

csharp复制代码mysql> select * from tradeLog where CAST(tradid AS signed int) = 110717;

typescript复制代码public class Product {
    private String partA;
    
    private String partB;
    
    private String partC;
​
    public void show(){
        system.out.println(this)
    }
}

csharp复制代码public interface Builder {
    
    public void setPartA();
    
    public void setPartB();
    
    public void setPartC();
    
    public Product build();
}
​

typescript复制代码public class ConcreteBuilder implements Builder {
    
    private Product product;
    
    public ConcreteBuilder() {
        product = new Product();
    }
​
    @Override
    public void setPartA() {
        product.setPartA("Part A");
    }
​
    @Override
    public void setPartB() {
        product.setPartB("Part B");     
    }
​
    @Override
    public void setPartC() {
        product.setPartC("Part C");
    }
​
    @Override
    public Product build() {        
        return product;
    }
​
}

csharp复制代码public class Director {
    private Builder builder;
    
    // 指定建造者
    public Director(Builder builder) {
        this.builder = builder;
    }
    
    public Product construct() {
        builder.setPartA();
        builder.setPartB();
        builder.setPartC();
        return builder.build();
    }
}

cpp复制代码int funtion(int a, int b, int c)
{
	return a + b + c;
}
int funtion(double a, double b, int c)
{
	return a + b + c;
}
int funtion(int a)
{
	return a;
}

cpp复制代码nt funtion(int a, int b, int c)
{
	return a + b + c;
}
double function(double a, double b, double c)
{
	return a + b + c;
}

c复制代码#include<iostream>
using namespace std;

void print(int i)
{
        cout<<"print a integer :"<<i<<endl;
}

void print(string str)
{
        cout<<"print a string :"<<str<<endl;
}

int main()
{
        print(12);
        print("hello world!");
        return 0;
}

python复制代码import matplotlib.pyplot as plt 
plt.violinplot(dataset)

python复制代码import matplotlib.pyplot as plt

python复制代码data = [np.random.normal(0,2,100)]

python复制代码part = plt.violinplot(data,showmedians=True)

python复制代码plt.show()

python复制代码for pc in part["bodies"]:
    print(pc)
    pc.set_facecolor("pink")
    pc.set_edgecolor("black")
    pc.set_alpha(1)
    pc.set_linestyle("--")

scss复制代码data = [np.random.normal(0,i,100) for i in range(2,6)]
plt.grid()
part = plt.violinplot(data,showmedians=True,widths=[0.3,0.4,0.5,0.6])
for pc in part["bodies"]:
    print(pc)
    pc.set_facecolor("orange")
    pc.set_edgecolor("black")
    pc.set_alpha(1)
    pc.set_linestyle("--")

q1,me,q3 = np.percentile(data,[25,50,75],axis=1)
ind = np.arange(1,len(me)+1)

plt.scatter(ind,me,marker="o",color="r",s=50,zorder=3)
plt.vlines(ind,q1,q3,color="k",linestyles="-",lw=5)

csharp复制代码 	@DisplayName("测试简单断言")
    void testSimpleAssertions(){
        int addition = addition(3, 2);
        assertEquals(5,addition);
    }

    int addition(int i,int j){
        return i+j;
    }

less复制代码	@Test
    @DisplayName("组合断言")
    void all(){
        assertAll("test",
                ()->assertTrue(true),
                ()->assertEquals(1,1));
    }

less复制代码    @Test
    @DisplayName("异常断言")
    void testException(){
        assertThrows(ArithmeticException.class,()->{
            int i=0/0;
        },"10/0正常？");
    }

scss复制代码    @DisplayName("快速失败")
    void testFail(){
        if(2==2){
            fail("测试失败");
        }
    }

rust复制代码/// Represents a packet type.
/// Associated with each variant is its raw numeric representation.
enum PacketType {
    Data  = 0, // packet carries a data payload
    Fin   = 1, // signals the end of a connection
    State = 2, // signals acknowledgment of a packet
    Reset = 3, // forcibly terminates a connection
    Syn   = 4, // initiates a new connection with a peer
}

rust复制代码impl From<PacketType> for u8 {
    fn from(original: PacketType) -> u8 {
        match original {
            PacketType::Data  => 0,
            PacketType::Fin   => 1,
            PacketType::State => 2,
            PacketType::Reset => 3,
            PacketType::Syn   => 4,
        }
    }
}

xml复制代码<dependency>
   <groupId>org.springframework.security</groupId>
   <artifactId>spring-security-oauth2-authorization-server</artifactId>
   <version>0.2.0</version>
</dependency>

java复制代码http.authorizeRequests().antMatchers("/login/**").permitAll()

java复制代码http.authorizeRequests().antMatchers("/login").permitAll()

java复制代码http.formLogin().permitAll()

java复制代码    @Bean
    @Order(Ordered.HIGHEST_PRECEDENCE)
    public SecurityFilterChain authorizationServerSecurityFilterChain(HttpSecurity http) throws Exception {
        OAuth2AuthorizationServerConfiguration.applyDefaultSecurity(http);
        http.formLogin(withDefaults()).logout().and().cors();
        return http.build();
    }

java复制代码    private URI endSessionEndpoint(ClientRegistration clientRegistration) {
        if (clientRegistration != null) {
            ClientRegistration.ProviderDetails providerDetails = clientRegistration.getProviderDetails();
            Object endSessionEndpoint = providerDetails.getConfigurationMetadata().get("issuer");//oidc认证端点的网址
            if (endSessionEndpoint != null) {
                //组装自己的单点的登出请求地址，可以和SSO的普通登出地址不一致
                return URI.create(endSessionEndpoint + "/logout");
            }
        }
        return null;
    }

java复制代码.logout(logout ->
        logout.logoutSuccessHandler(mySsoLogoutSuccessHandler))
)

java复制代码@GetMapping("/logout")
@ResponseBody
public Result<String> logoutWithJson(HttpServletRequest request) throws ServletException {
    request.logout();
    return Result.ok("登出成功");//Result是我自己的返回类
}

java复制代码public class SsoOidcUserService extends OidcUserService {
    private WebClient webClient;
    public SsoOidcUserService(OAuth2AuthorizedClientManager authorizedClientManager){
    ServletOAuth2AuthorizedClientExchangeFilterFunction oauth2Client =
                new ServletOAuth2AuthorizedClientExchangeFilterFunction(authorizedClientManager);
    webClient = WebClient.builder()
                .apply(oauth2Client.oauth2Configuration()).build();
    }
    @Override
    public OidcUser loadUser(OidcUserRequest userRequest) throws OAuth2AuthenticationException {
        OidcUser oidcUser = super.loadUser(userRequest);
        UserEntity userEntity = getSsoUserEntity(new OAuth2AuthorizedClient(userRequest.getClientRegistration(),oidcUser.getName(),userRequest.getAccessToken()));
        //....
    }
    public UserEntity getSsoUserEntity(OAuth2AuthorizedClient oAuth2AuthorizedClient) {
        UserEntity entity = null;
        try {
            entity = UserEntityDTO.toUserEntity(webClient
                    .get()
                    .uri(oAuth2AuthorizedClient.getClientRegistration().getProviderDetails().getIssuerUri()+"/你的User rest请求端点")
                    .attributes(ServletOAuth2AuthorizedClientExchangeFilterFunction.oauth2AuthorizedClient(oAuth2AuthorizedClient))
                    .retrieve()
                    .bodyToMono(UserEntityDTO.class)
                    .block());
        } catch (Exception e) {
            e.printStackTrace();
        }
        return entity;
    }
}

bash复制代码proxy_set_header Host   $http_host;

yaml复制代码$ firewall-cmd --list-all

    target: default
    icmp-block-inversion: no
    interfaces: enp0s3 enp0s8
    sources: 
    services: ssh dhcpv6-client
    ports: 80/tcp 8099/tcp 8098/tcp
    protocols: 
    masquerade: no
    forward-ports: 
    source-ports: 
    icmp-blocks: 
    rich rules:

css复制代码firewall-cmd --reload

css复制代码firewall-cmd --add-port=80/tcp --permanent

css复制代码firewall-cmd --remove-port=80/tcp --permanent

css复制代码firewall-cmd  --list-ports

ini复制代码firewall-cmd --permanent  --add-rich-rule="rule family="ipv4" source address="192.168.0.4/24" port protocol="tcp" port="8080" reject"

ini复制代码firewall-cmd --permanent --add-rich-rule="rule family="ipv4" source address="192.168.0.4/24" port protocol="tcp" port="8080" accept"

ini复制代码firewall-cmd --permanent --remove-rich-rule="rule family="ipv4" source address="192.168.0.4/24" port protocol="tcp" port="8080" accept"

css复制代码firewall-cmd --permanent --add-masquerade

ruby复制代码firewall-cmd --add-forward-port=port=80:proto=tcp:toport=8080  --permanent

ruby复制代码firewall-cmd --add-forward-port=proto=80:proto=tcp:toaddr=192.168.0.1  --permanent

ruby复制代码firewall-cmd --add-forward-port=proto=80:proto=tcp:toaddr=192.168.0.1:toport=8080  --permanent

arduino复制代码    作者：ZOUZDC
    链接：https://juejin.cn/post/7028963866063306760
    来源：稀土掘金
    著作权归作者所有。商业转载请联系作者获得授权，非商业转载请注明出处。

ini复制代码module adder(
 input ia,
 input ib,
 input cin,
 output cout,
 output cur
);
 assign cur = ia ^ ib ^ cin;                   //当前位
 assign cout = ia & cin | ib & cin | ia & ib;  // 进位
endmodule

module add_8(
 input [7:0] a,
 input [7:0] b,
 input cin,
 output [7:0] s,
 output o,      // overflow,
 output cout
);
 wire c0,c1,c2,c3,c4,c5,c6,c7;
 adder d0(a[0],b[0],cin,c0,s[0]);
 adder d1(a[1],b[1],c0,c1,s[1]);
 adder d2(a[2],b[2],c1,c2,s[2]);
 adder d3(a[3],b[3], c2,c3,s[3]);
 adder d4(a[4],b[4],c3,c4,s[4]);
 adder d5(a[5],b[5],c4,c5,s[5]);
 adder d6(a[6],b[6],c5,c6,s[6]);
 adder d7(a[7],b[7],c6,c7,s[7]);
 assign cout = c7;
 assign o = (a[7] & b[7] & ~s[7]) | (~a[7] & ~b[7] & s[7]);  // 溢出
endmodule

module add_sub_8(
 input [7:0] a,
 input [7:0] b,
 input cin,
 input op,
 output [7:0] res,
 output overflow,
 output cout
);
 add_8 d4(a,{op,op,op,op,op,op,op,op} ^ b,op ^ cin,res,overflow,cout);
endmodule

module slt(
 input [7:0] a,
 input [7:0] b,
 output result
);
 wire o, c;
 wire [7:0] r;
 add_sub_8 sub(a, b, 0, 1, r, o, c);
 assign result = o ^ r[7];
 
endmodule



module shift(
    input [7:0] a,
    input b,
    input [1:0]m,
    output [7:0] out
);  // 将相与的值向左移动 m 位
    assign out = b == 1'b0 ? 8'b0000_0000 : ((8'b1111_1111 & a) << m);
 
endmodule

module mult(
    input [3:0] a,
    input [3:0] b,
    output [7:0] out
);
    wire [7:0] abs_a;       // a 的绝对值
    wire [7:0] abs_b;       // b 的绝对值
    wire flag;
    assign flag = a[3] ^ b[3];  // 通过对符号位的异或取得乘积的符号
    wire [3:0] t1;
    wire [3:0] t2;
    wire o1,c1,o2,c2,o3,c3,o4,c4,o5,c5,o6,c6;
    add_sub_8 m0(a,1,0,1,t1,o1,c1);  // a - 1
    add_sub_8 m1(b,1,0,1,t2,o2,c2);  // b - 1
    assign abs_a[7:4] = 4'b0000;    // 绝对值都是正数，所以拓展成 8 位后，前面四位都要补上 0
    assign abs_b[7:4] = 4'b0000; 
    assign abs_a[3:0] = a[3] == 1'b1 ? ~t1 : a;  // 取绝对值完成
    assign abs_b[3:0] = b[3] == 1'b1 ? ~t2 : b;
    wire [7:0] T1;
    wire [7:0] T2;
    wire [7:0] T3;
    wire [7:0] T4;
    shift h1(abs_a,abs_b[0],2'b00,T1);  // 四位数乘法转换成 四次加法运算
    shift h2(abs_a,abs_b[1],2'b01,T2);
    shift h3(abs_a,abs_b[2],2'b10,T3);
    shift h4(abs_a,abs_b[3],2'b11,T4); 
    
    wire [7:0] T5;
    wire [7:0] T6;
    wire [7:0] res;
    wire [7:0] T7;
    add_sub_8 m2(T1,T2,0,0,T5,o3,c3);  // T5 = T1 + T2
    add_sub_8 m3(T5,T3,0,0,T6,o4,c4);  // T6 = T5 + T3
    add_sub_8 m4(T6,T4,0,0,res,o5,c5); // res = T6 + T4
    
    add_sub_8 m5(~res,1,0,0,T7,o6,c6);  //  T7 = ~res + 1     即是取 res 的补码
    assign out = flag == 1'b1 ? T7 : res;  // 由乘积符号标志，确定输出的是原值还是它的补码
endmodule







module CPU(
    input read_to_R2,          // 是否把值存入 R2
    input alu,                 // 控制是否开启 alu 部分计算
    input clk,                 // 时钟
    input [7:0] b,             // 数据源
    output reg [7:0] led_id,
    output reg [6:0] out_led, // 数码管显示
    output ZF,                // 运算结果全零，则为 1
           CF,                // 进借位标志位
           OF,                // 溢出标志位
           SF,                // 符号标志位，与 F 的最高位相同
           PF                 // 奇偶标志位，F 有奇数个 1，则 PF=1，否则为 0
);
reg [7:0] R0;                // 对应地址码 00
reg [7:0] R1;                // 对应地址码 01
reg [7:0] R2;                // 对应地址码 10

reg [7:0] data_to_R2;       // 在 alu 计算 和 存入 R2 的值的零时变量

wire [7:0] res1,res2,res3,res4,res5;
wire res9;
wire OF1,OF2,OF3,OF4;
wire CF1,CF2,CF3,CF4;
reg of,cf;

reg [7:0] A1;
reg [7:0] B1;
wire [7:0] A;    // 第一个源数据
wire [7:0] B;    // 第二个源数据
assign A = A1;
assign B = B1;

add_sub_8 fun1(A,B,0,0,res1,OF1,CF1);    // res1 = A + B
add_sub_8 fun2(A,1,0,0,res2,OF2,CF2);    // res2 = A - 1
add_sub_8 fun3(A,B,0,1,res3,OF3,CF3);    // res3 = A - B
add_sub_8 fun4(A,1,0,1,res4,OF4,CF4);    // res4 = A - 1;
mult fun5(A[3:0],B[3:0],res5);           // res5 = A * B
slt fun9(A,B,res9);                      // 比较 A 和 B 的大小，A >= B, res9 = 0;    A < B, res9 = 1;


always@(b) begin

    if (read_to_R2 == 1'b1) R2 = data_to_R2;       // 是否将临时变量的值存如 R2
    
    if (b[7:6] == 2'b10 && alu == 1'b0) begin      // 写入数据进入寄存器
        if (b[5:4] == 2'b00) begin                 // 根据地址码，存入值
            if (b[3] == 1'b1) R0[7:4] = 4'b1111;   // 根据写入数（补码）最高位，判断并 4 位长拓展为 8 位，下同
            else              R0[7:4] = 4'b0000;
            R0[3:0] = b[3:0];
        end
        else if (b[5:4] == 2'b01) begin
            if (b[3] == 1'b1) R1[7:4] = 4'b1111;
            else              R1[7:4] = 4'b0000;
            R1[3:0] = b[3:0];
        end
        else if (b[5:4] == 2'b10) begin
            if (b[3] == 1'b1) begin
                R2[7:4] = 4'b1111;
                data_to_R2[7:4] = 4'b1111;
            end
            else begin
                R2[7:4] = 4'b0000;
                data_to_R2[7:4] = 4'b0000;
            end
            R2[3:0] = b[3:0];
            data_to_R2 = b[3:0];
        end
    end
    else if (alu == 1'b1) begin
        case(b[3:2])
            2'b00: A1 = R0;
            2'b01: A1 = R1;
            2'b10: A1 = R2;
        endcase
        case(b[1:0])
            2'b00: B1 = R0;
            2'b01: B1 = R1;
            2'b10: B1 = R2;
        endcase
        case(b[7:4])        // 以下模拟 alu 部分进行取出对应状态计算的结果和状态
            4'b0000: begin 
                data_to_R2 = res1;
                of = OF1;
                cf = CF1;
            end
            4'b0001: begin 
                data_to_R2 = res2;
                of = OF2;
                cf = CF2;
            end
            4'b0010: begin
                data_to_R2 = res3;
                of = OF3;
                cf = ~CF3;
            end
            4'b0011: begin
                data_to_R2 = res4;
                of = OF4;
                cf = ~CF4;
            end
            4'b1100: data_to_R2 = res5;
            4'b0100: data_to_R2 = A & B;
            4'b0101: data_to_R2 = A | B;
            4'b0110: data_to_R2 = A ^ B;
            4'b0111: data_to_R2 = res9;
        endcase
    end
end


// 数码管灯显示数据
wire [7:0] n;
assign n = b[7:0] == 8'b1111_0010 ? R2          :    // 读取 R2 的值
           b[7:0] == 8'b1111_0000 ? R0          :    // 读取 R0 的值
           b[7:0] == 8'b1111_0001 ? R1          :    // 读取 R1 的值
           b[7:0] == 8'b1111_0011 ? data_to_R2  :    // 读取储存 R2 值的中间变量
           b[7:0] == 8'b1111_0100 ? A           :    // 读取第二个源数据
           b[7:0] == 8'b1111_0101 ? B           :    // 读取第二个源数据
           8'b0000_0000;