- oracle
declare
cursor c is
select o.store astore,o.adate adate,o.gdgid gdgid,-sum(outbuyqty+outwsaleqty+outbuybckqty+outwsalebckqty) dq,
-sum(outbuyamt+outwsaleamt+outbuybckamt+outwsalebckamt) dt,-sum(outbuycost+outwsalecost+outbuybckcost+outwsalebckcost) di,
(case when p.store is not null then 1 else 0 end) prm,rtrim(g.sort) sort from std_jxcdrpt o
left join V_VENDORSUMDIFF_GXLH p on o.store= p.store and o.adate= p.begindate and o.gdgid= p.gdgid
left join goods g on o.gdgid= g.gid
where o.adate>='2021.01.20'
group by o.store,o.adate,o.gdgid,p.store,g.sort;
begin
for r in c loop
/*
if substr(r.sort,1,1) = '1'
then
substr(r.sort,1,4)
else if substr(r.sort,1,1) = '2'
then
if substr(r.sort,1,4) not in ('2002','2206','2208') then
substr(r.sort,1,4)
else
if substr(r.sort,1,4) in ('2002','2206') then
substr(r.sort,1,6)
else if substr(r.sort,1,1) = '3' or substr(r.sort,1,1) = '8'
then
substr(r.sort,1,2)
end if;
*/
select kd,tkd from yn_kd where code =(
if substr(r.sort,1,1) = '1'
then
substr(r.sort,1,4)
else if substr(r.sort,1,1) = '2'
then
if substr(r.sort,1,4) not in ('2002','2206','2208') then
substr(r.sort,1,4)
else
if substr(r.sort,1,4) in ('2002','2206') then
substr(r.sort,1,6)
else if substr(r.sort,1,1) = '3' or substr(r.sort,1,1) = '8'
then
substr(r.sort,1,2)
end if;)
if r.prm = 0 then
insert into mnfran
select r.astore,r.adate,r.gdgid,sort,kd,r.dq,r.dt,r.di,r.dt*kd,r.prm,0 from dual;
else
insert into mnfran
select r.astore,r.adate,r.gdgid,sort,r.tkd,r.dq,r.dt,r.di,r.dt*r.tkd,r.prm,0 from DUAL;
end if;
end loop;
end;
- java
- mysql
EXPLAIN SELECT
e.*
FROM
(
SELECT
a.group_id,
a.group_name,
a.target_return,
a.invest_money,
a.create_time,
a.currency_category_rate,
a.bond_category_rate,
a.stock_category_rate,
a.commodity_category_rate,
a.deposit_rate,
a.bank_financial_rate,
a.public_fund_rate,
a.risk,
a.bank_risk,
a.public_risk,
a.invest_duration,
a.group_type,
c.customer_name,
c.sex AS customerSex,
d.group_name AS basicGroupName
FROM
assets_config_wealth_group_base a
LEFT JOIN group_basic d ON a.group_type = d.group_id
LEFT JOIN customer_self_group_relation b ON a.group_id = b.group_id
LEFT JOIN customer_self_base_info c ON b.customer_id = c.customer_id
WHERE
a.customer_id IS NOT NULL
AND a.user_id = 'ht4'
AND a.org_id = 6510021
AND a.target_return IS NULL
AND a.is_del = 0 UNION ALL
SELECT
a.group_id,
a.group_name,
a.target_return,
a.invest_money,
a.create_time,
a.currency_category_rate,
a.bond_category_rate,
a.stock_category_rate,
a.commodity_category_rate,
a.deposit_rate,
a.bank_financial_rate,
a.public_fund_rate,
a.risk,
a.bank_risk,
a.public_risk,
a.invest_duration,
a.group_type,
c.customer_name,
c.sex AS customerSex,
d.group_name AS basicGroupName
FROM
assets_config_wealth_group_base a
LEFT JOIN group_basic d ON a.group_type = d.group_id
LEFT JOIN customer_other_group_relation b ON a.group_id = b.group_id
LEFT JOIN customer_other_base_info c ON b.customer_id = c.customer_id
WHERE
a.customer_id IS NULL
AND a.user_id = 'ht4'
AND a.target_return IS NULL
AND a.org_id = 6510021
AND a.is_del = 0
) e
WHERE
1 = 1
- android-studio
- android
- python
- list
- 正则表达式
- html5
- python
- unix
- centos
- java
- java-ee
- javascript
- vue.js
https://blog.csdn.net/qq_37880968/article/details/90373361我用这位老哥的方法,没成功,在plugin引入js文件那一步报错了,问题我发到阿里云那个问答里面了https://developer.aliyun.com/ask/317103?spm=a2c6h.13148508.0.0.7f9f4f0eXSQtem
我用阿里云的例子也不成功,我也发到问答里面了https://developer.aliyun.com/ask/317094?spm=a2c6h.13148508.0.0.7f9f4f0eXSQtem
瞎忙活了两天,啥也没做出来
- linux
- 负载均衡
- centos
- 神经网络
- 深度学习
- tensorflow
- sql
- spring
- intellij-idea
- mysql
我是一个初学者,学习mybatis框架。我查询可以查得出结果,但是添加就不能出结果。
首先这是实体数据类
package test;
public class Book1 {
private String name;
private String author;
public String getName() {
return name;
}
public String getAuthor() {
return author;
}
public void setName(String name) {
this.name = name;
}
public void setAuthor(String author) {
this.author = author;
}
public Book1(String name, String author) {
this.name = name;
this.author = author;
}
@Override
public String toString() {
return "Book{" +
"name='" + name + '\'' +
", author='" + author + '\'' +
'}';
}
public Book1() {
}
}
然后是mapper接口
public interface Bookmapper {
public List<Book1> select(String s);
public void add(Book1 book1);
}
两个xml文件
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="test.Bookmapper">
<select id="select" resultType="test.Book1" parameterType="String">
select * from book where author = #{author}
</select>
<insert id="add" parameterType="test.Book1" databaseId="mysql">
insert into book (name,author) values(#{name}, #{author})
</insert>
</mapper>
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/class?verifyServerCertificate=false&useSSL=false"/>
<property name="username" value="root"/>
<property name="password" value="weiziyao1214"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="mapper.xml"/>
</mappers>
</configuration>
这是测试类
public class Text {
@Test
public void test() throws IOException {
Book1 b=new Book1("悉达多","黑塞");
String resource = "mybatis.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory =
new SqlSessionFactoryBuilder().build(inputStream);
try (SqlSession session = sqlSessionFactory.openSession()) {
Bookmapper mapper = session.getMapper(Bookmapper.class);
List<Book1> book = mapper.select("川端康成");
System.out.println(book);
mapper.add(b);
session.commit();
}
}
}
输出结果如下
[Book{name='雪国', author='川端康成'}, Book{name='雪国', author='川端康成'}]
org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): test.Bookmapper.add
奇怪的是,我查询单条结果的时候返回为空,当我把返回值变成结果集的时候返回成功。但是添加操作就是不成。
- python
- r语言
df是包含TP1NP一个变量的数据框
tsh.hist <- hist(df1$TP1NP, breaks = seq(0,max(df1$TP1NP) + 0.1, 0.1), plot = FALSE)
tsh.df <- data.frame(tsh = tsh.hist$breaks[2:length(tsh.hist$breaks)],freq = tsh.hist$counts)
tsh.df <- as.mixdata(tsh.df)
fitg <- mix(tsh.df,
mixparam(c(0.1,2,6),c(0.1,1,2)),
constr = list(
conpi = "NONE",
conmu = "MFX",
consigma = "SFX",
fixpi = NULL,
fixmu = c(FALSE,FALSE, FALSE),
fixsigma = c(FALSE,FALSE, FALSE)),
"gamma", emsteps = 1)
fitg.coef <- coef(fitg, natpar = TRUE) -> tshg
报错:Error in nlm(mixlike, lmixdat = mixdat, lmixpar = fitpar, ldist = dist, : 参数里不能有遗漏值
- java
- jar
- 机器学习
- spring
- maven
- java
- intellij-idea
- c语言
- c++
- spring
- java
- intellij-idea
- jar
- java-ee
public class Main { public static void main(String[] args) throws InterruptedException { Test test = new Test(); Thread thread1 = new Thread(() -> { try { System.out.println(test.change()); } catch (InterruptedException e) { e.printStackTrace(); } }); Thread thread2 = new Thread(() -> { try { System.out.println(test.change()); } catch (InterruptedException e) { e.printStackTrace(); } }); thread1.start(); TimeUnit.MILLISECONDS.sleep(8); thread2.start(); } }
public class Test { private volatile int a = 0; public int change() throws InterruptedException { while (a == 0){ TimeUnit.MILLISECONDS.sleep(10); a++; } return a; } }
- 神经网络
- python
- tensorflow
初学者,正在使用maskrcnn检测一些长条状柱状物品,想要完成抓取作业。
物品检测可以顺利完成,现在想求出各个mask的中心坐标和两端的坐标,应该怎么做?利用像素点?还是转多边形再求中心和两端坐标?
以下是检测的部分代码
def detect_image(self, image):
image = [np.array(image)]
molded_images, image_metas, windows = mold_inputs(self.config,image)
image_shape = molded_images[0].shape
anchors = get_anchors(self.config,image_shape)
anchors = np.broadcast_to(anchors, (1,) + anchors.shape)
detections, _, _, mrcnn_mask, _, _, _ =\
self.model.predict([molded_images, image_metas, anchors], verbose=0)
final_rois, final_class_ids, final_scores, final_masks =\
unmold_detections(detections[0], mrcnn_mask[0],
image[0].shape, molded_images[0].shape,
windows[0])
r = {
"rois": final_rois,
"class_ids": final_class_ids,
"scores": final_scores,
"masks": final_masks,
}
drawed_image = visualize.display_instances(image[0], r['rois'], r['masks'],
r['class_ids'], self.class_names, r['scores'])
- linux
- 问答团队
- c语言
- c++
- 测试用例
一段测试代码,用来测试 freopen("out.txt", "w", stdin); 对输入的影响
#include <bits/stdc++.h>
using namespace std;
int main()
{
// freopen("in.txt", "r", stdin);
freopen("out.txt", "w", stdin);
int a=-100;
scanf("%d",&a);
printf("%d",a);
}
调试图:
a初始化为-100,此时控制台无法输入,可直接“下一步”
a的值一直为初始值-100
可一旦注释掉freopen("out.txt", "w", stdin);
整个程序就正常了(cin输入也有这个问题)
还发现freopen("in.txt", "r", stdin);并不会影响scanf输入,程序正常。
困扰了我好久,无意间注释掉这行才发现。
小白求救各位大神原因
- c++
这哪里错了
#include <cstdio>
using namespace std;
int n, k, cnt;
int s[1000], king[1000]; //一行内的合法状态
long long f[10][1000][100]; //[i][j][k] 在第i行状态为j共有k个国王时的摆法数量
int getkings(int x) {
int res = 0;
while (x) {
res += (x & 1);
x >>= 1;
}
return res;
}
int pre() {
scanf("%d%d", &n, &k);
int maxn = (1 << n);
for (int i = 0; i < maxn; i++) {
if (!(i & (i << 1))) {
s[cnt] = i;
king[cnt] = getkings(i);
f[1][cnt][king[cnt]] = 1;
}
}
}
void dp() {
for (int i = 2; i <= n; i++) {
for (int j = 0; j <= cnt; j++) { //当前行选定的状态
int st = s[j];
for (int l = 0; l <= cnt; l++) { //上一行的有效状态
int so = s[l];
if ((st & so) || (st & (so << 1) || (st & (so >> 1)))) {
continue;
}
for (int c = 0; c <= k; c++) {
f[i][j][c + king[j]] += f[i - 1][1][c];
}
}
}
}
long long ans = 0;
for (int i = 0; i < cnt; i++) {
ans += f[n][i][k];
}
printf("%lld", ans);
}
int main() {
pre();
dp();
return 0;
}
展开
题目描述
在N×N的棋盘里面放K个国王,使他们互不攻击,共有多少种摆放方案。国王能攻击到它上下左右,以及左上左下右上右下八个方向上附近的各一个格子,共8个格子。
注:数据有加强(2018/4/25)
输入格式
只有一行,包含两个数N,K ( 1 <=N <=9, 0 <= K <= N * N)
输出格式
所得的方案数
输入输出样例
输入 #1复制
3 2
输出 #1复制
16