Seraph09
Seraph09
2021/01/20 00:55
  • r语言

分析差异基因,网站上下载下来是sizefactor_normalized_count, 查资料认为是DEseq2分析差异基因标准化获得的数据,但是,我又怎么通过这个数据去分析差异基因呢?如果要继续分析,我记得需要Dispersion等参数,又无法获得。谢谢大家的帮助。

1. limma包不能处理这个数据吧?

2. EdgeR包能分析这种数据吗?通过这个包分析出来的结果没什么差异。

3.使用DEseq包继续分析吗?

0个回复
barbed
barbed
2021/01/20 00:52
  • vue.js

前端 Vue项目

我设置的端口

运行时的端口

后台的端口是8666

为什么我运行时端口总是会+1,而且没有运行其他项目,其他项目也没有用8666这个端口

 

0个回复
a11111123121
a11111123121
2021/01/20 00:26
  • c语言

如题

如何才能把CSV转存到链表里的数组里,或者在存储的时候怎样解决逗号会被fscan装进%s里

0个回复
AimerDawn
エメの恋文
2021/01/20 00:23
  • python

错误是    C扩展:没有名为“pandas”的模块_库间隔“没有建造。如果要从源目录导入pandas,可能需要运行“python”设置.pybuild_ext--force'首先构建C扩展。

0个回复
xingdianp
星点xingdian
2021/01/20 00:01
  • sql
  • oracle
  • mysql
  • nosql

 

StockPrice Table

 

price_date

price

 

2019-09-25

23.23

 

2019-09-26

32.54

 

2019-09-27

34.55

 

2019-09-28

null

 

2019-09-29

null

 

2019-09-30

54.22

 

2019-10-01

null

 

2019-10-02

null

 

2019-10-03

null

 

2019-10-04

null

 

2019-10-05

null

 

2019-10-06

null

 

2019-10-07

null

 

2019-10-08

33.80

 

2019-10-09

33.83

 


上表节选自某上市公司股票每日收盘价记录,适逢股市休市或该股停牌,则无收盘价记录,于表中记为null。
 
现需通过sql获取该公司在第a天的收盘价,若第a天无收盘价记录,则取该日之前,最近的一个收盘价作为第a天的收盘价。(例如,2019-10-05的收盘价取2019-09-30的54.22)
select
  price_date,
        price,
        max(newprice) over (partition by num) close_price
from
(
    select
        price_date,
        price,
        newprice,
        sum(c) over ( UNBOUNDED PRECEDING) num
    from
        (
    select
        price_date,
        price,
        if(price = null,0,price) newprice,
        if(price = null,0,1) c
    from
        `StockPrice Table` 
        ) t1
)t2
改了下让求距离该日期最近的,就是说可以向前取也可以向后取,说如果求最近得价格,如果为null,就向前一天和后一天找,如果找到一个不为null且距离该日期最近的,比如:2019.5.12为null,2019.5.10是32.2,2019.5.13是23.0,那2019.5.12就是23.0.因为对于5.12来说5.13比5.10近

这个需求改变了,怎么改SQL?
 

0个回复
qq_45207224
qq_45207224
2021/01/19 23:10
  • mysql

安装双版本MySQL的时候,服务安装错了,但是我不记得卸载这个的命令了,有没有大佬记得能讲一下,我记得我之前还用过,但是没记下来。

f是我复制下来的路径,还没来得及改,然后他就执行了,说服务成功安装,然后我正确的路径用不了,卸载这个服务的命令我记得我之前用过,但是我不记得了,大哥们能不能讲讲0-0.

0个回复
weixin_44857342
weixin_44857342
2021/01/19 22:38
  • python
#coding=utf-8
import socket
import re


def handle_client(client_socket):
    "为一个客户端进行服务"
    recv_data = client_socket.recv(1024).decode('utf-8', errors="ignore")
    request_header_lines = recv_data.splitlines()
    for line in request_header_lines:
        print(line)

    http_request_line = request_header_lines[0]
    get_file_name = re.match("[^/]+(/[^ ]*)", http_request_line).group(1)
    print("file name is ===>%s" % get_file_name)  # for test

    # 如果没有指定访问哪个页面。例如index.html
    # GET / HTTP/1.1
    if get_file_name == "/":
        get_file_name = DOCUMENTS_ROOT + "/index.html"
    else:
        get_file_name = DOCUMENTS_ROOT + get_file_name

    print("file name is ===2>%s" % get_file_name) #for test

    try:
        f = open(get_file_name, "rb")
    except IOError:
        # 404表示没有这个页面
        response_headers = "HTTP/1.1 404 not found\r\n"
        response_headers += "\r\n"
        response_body = "====sorry ,file not found===="
    else:
        response_headers = "HTTP/1.1 200 OK\r\n"
        response_headers += "\r\n"
        response_body = f.read()
        f.close()
    finally:
        # 因为头信息在组织的时候,是按照字符串组织的,不能与以二进制打开文件读取的数据合并,因此分开发送
        # 先发送response的头信息
        client_socket.send(response_headers.encode('utf-8'))
        # 再发送body
        client_socket.send(response_body)
        client_socket.close()


def main():
    "作为程序的主控制入口"
    server_socket = socket.socket(socket.AF_INET, socket.SOCK_STREAM)
    server_socket.setsockopt(socket.SOL_SOCKET, socket.SO_REUSEADDR, 1)
    server_socket.bind(("", 7788))
    server_socket.listen(128)
    while True:
        client_socket, clien_cAddr = server_socket.accept()
        handle_client(client_socket)


#这里配置服务器
DOCUMENTS_ROOT = "./html"

if __name__ == "__main__":
    main()
0个回复
qq_41020955
qq_41020955
2021/01/19 22:23
  • sql

查询表时,想要将查询出来的数据格式从“1”变为“1天”,“365”变为“365天”

2个回复
chun201010
东方项天
2021/01/19 22:22
  • java
  • 测试用例

1.  测试用例如下:

```
@Test
    public void test1(){
        Object value = 23;
        logger.info("object1={};object2={}", Integer.parseInt(String.valueOf(value)), (Integer)value);

        Object value1 = 23.32;
        logger.info("object1={};object2={}", Double.parseDouble(String.valueOf(value1)), (Double)value1);

        logger.info("String.valueOf(23) = {}", String.valueOf(value));
        logger.info("String.valueOf(23.32) = {}", String.valueOf(value1));

        logger.info("object1={}", String.valueOf(value).contains(".")?Double.parseDouble(String.valueOf(value)):Integer.parseInt(String.valueOf(value)));
        logger.info("object2={}", String.valueOf(value1).contains(".")?Double.parseDouble(String.valueOf(value1)):Integer.parseInt(String.valueOf(value1)));

        logger.info("object1={}", String.valueOf(value).contains(".")?(Double)value:(Integer)value);
        logger.info("object2={}", String.valueOf(value1).contains(".")?(Double)value1:(Integer)value1);

        if(String.valueOf(value).contains(".")){
            logger.info("String.valueOf1(value):{}", String.valueOf(value));
        }else{
            logger.info("String.valueOf2(value):{}", String.valueOf(value));
        }
        if(String.valueOf(value).contains(".")){
            logger.info("convert1(value):{}", (Double)value);
        }else{
            logger.info("convert2(value):{}", (Integer)value);
        }
    }
```
2.  输出如下:

```
22:06:54.523 [main] INFO com.tikie.eureka.core.NormalTest - object1=23;object2=23
22:06:54.528 [main] INFO com.tikie.eureka.core.NormalTest - object1=23.32;object2=23.32
22:06:54.528 [main] INFO com.tikie.eureka.core.NormalTest - String.valueOf(23) = 23
22:06:54.528 [main] INFO com.tikie.eureka.core.NormalTest - String.valueOf(23.32) = 23.32
22:06:54.528 [main] INFO com.tikie.eureka.core.NormalTest - object1=23.0
22:06:54.528 [main] INFO com.tikie.eureka.core.NormalTest - object2=23.32
22:06:54.528 [main] INFO com.tikie.eureka.core.NormalTest - object1=23.0
22:06:54.528 [main] INFO com.tikie.eureka.core.NormalTest - object2=23.32
22:06:54.528 [main] INFO com.tikie.eureka.core.NormalTest - String.valueOf2(value):23
22:06:54.528 [main] INFO com.tikie.eureka.core.NormalTest - convert2(value):23

```
3.  为何同样的调用,有两个输出多了".0"??

输出内容 标题


 

1个回复
weixin_45580475
时光静下可好
2021/01/19 22:17
  • java

劳烦诸位大神帮忙看下,redis集群成功了,但是在通用客户端添加数据却提示内存不足呢,我并没有限制内存,这个redis里面也没有数据,也很好奇为什么主从成功后就立马传输了6MB数据(但是我并没有数据)

0个回复
qq_25971461
qq_25971461
2021/01/19 22:14
  • c语言

void keep(A *head)
{
  FILE *fp;
  A *cur = head->next;

  if ((fp = fopen("E:\\information.txt", "wb")) == NULL)
    printf("Save default!!!\n");
  while (cur)
  {
    fprintf(fp, "%d,%s,%s,%f,%f,%f,%f,%d\n ", cur->identifer, cur->name, cur->nature, cur->time_sum, cur->time_lesson, cur->time_practice, cur->credit, cur->term);
    cur = cur->next;
  }
  fclose(fp);
  printf("存档成功!\n");
}

 

0个回复
qq_39141094
丝攻积木
2021/01/19 22:00
  • python

今天学习opencv的傅里叶变换的时候,在jupter notebook上练习了一串代码。当时想着采用opencv自带的图片显示方式进行,却突然出现了这样的问题,抓狂了一天!!!!!! 代码如下

# 傅里叶变换 只取低频   图像模糊
# 第一步 读取图片
image = cv2.imread('img/demo.jpg', 0)
# 第二步 使用np.float32进行格式转换
float_image = np.float32(image)
# 第三步 使用cv2.dft进行傅里叶变化
dft_image = cv2.dft(float_image, flags=cv2.DFT_COMPLEX_OUTPUT)
# 第四步 使用np.fft.fftshift 将低频部分转换到图像的中心
shift_image = np.fft.fftshift(dft_image)

# 第五步:构造掩模,使得掩模的中心位置为1,边缘位置为0
crow, ccol = int(image.shape[0] / 2), int(image.shape[1] / 2)  # 求得图像的中心点位置
mask = np.zeros((image.shape[0], image.shape[1], 2), np.uint8)
mask[crow - 30:crow + 30, ccol - 30:ccol + 30] = 1

# 第六步:将掩模与傅里叶变换后的图像结合(相乘),只保留中心部分的低频位置

mask_image = mask * shift_image

# 第七步:使用np.fft.ifftshift将低频部分转移回图像的原先位置
ishift = np.fft.ifftshift(mask_image)

# 第八步:使用cv2.idft进行傅里叶的反转换

idft_image = cv2.idft(ishift)

# 第九步:使用cv2.magnitude转化为空间域内
img_idf =cv2.magnitude(idft_image[:, :, 0], idft_image[:, :, 1])
print(idft_image)
print(image.shape)
print(img_idf)
# 显示图片

add_image=np.hstack((image.astype('uint8'),img_idf.astype('uint8')))


plt.subplot(121)
plt.imshow(image, cmap='gray')
plt.subplot(122)
plt.imshow(img_idf, cmap='gray')
plt.show()

cv2.imshow('img',img_idf)
cv2.waitKey(0)

cv2.destroyAllWindows()

运行结果却变成了这。。。。。。

屏幕截图 标题

即用matplotlib还能正常显示,用opencv就变成了抽象二值图像。。。。

求求各位大神告知为何

0个回复
qq_37486777
qq_37486777
2021/01/19 21:59
  • visual studio

有个视觉项目要需要字符用康耐视VisionPro软件,OCR工具怎么设置可以提高识别率

0个回复
qq_42495902
xj17854119516
2021/01/19 21:47
  • python

CMD中PIP安装成功了PyQt5,但是进入Python后,使用import pyqt5 却显示ModuleNotFoundError: No module named 'pyqt5'?各位大神这是怎么回事

0个回复
niudaidai233
涵林同学
2021/01/19 21:36
  • python

 

现有一个DataFrame中如图1所示,我想从backTime列中找出类型为float的元素(确定是哪一行)。

                                                                                                                     图1

 

问题背景

我想将rentTime列和backTime列转换为datetime类型于是使用了如下的代码,但是报错

 

我查看了几个backTime列元素的类型,发现是str类型没错。

 

于是怀疑可能数据源文件中有几个数据是float,但我不知道如何找出backTime列中类型为float 的元素

 

0个回复
weixin_47560677
男格子衫
2021/01/19 21:32
  • spring
  • java-ee

HTTP ERROR 500

Problem accessing /chapter11/firstController. Reason:

    Server Error

 

Caused by:

java.lang.NoClassDefFoundError: org/springframework/web/context/WebApplicationContext
	at java.lang.Class.getDeclaredConstructors0(Native Method)
	at java.lang.Class.privateGetDeclaredConstructors(Class.java:2671)
	at java.lang.Class.getConstructor0(Class.java:3075)
	at java.lang.Class.getDeclaredConstructor(Class.java:2178)
	at org.eclipse.jetty.server.handler.ContextHandler$Context.createInstance(ContextHandler.java:2653)
	at org.eclipse.jetty.servlet.ServletContextHandler$Context.createServlet(ServletContextHandler.java:1367)
	at org.eclipse.jetty.servlet.ServletHolder.newInstance(ServletHolder.java:1305)
	at org.eclipse.jetty.servlet.ServletHolder.initServlet(ServletHolder.java:648)
	at org.eclipse.jetty.servlet.ServletHolder.getServlet(ServletHolder.java:520)
	at org.eclipse.jetty.servlet.ServletHolder.prepare(ServletHolder.java:811)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:537)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1700)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1345)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:480)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1667)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1247)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
	at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:61)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
	at org.eclipse.jetty.server.Server.handle(Server.java:505)
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:370)
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:267)
	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)
	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
	at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.produce(EatWhatYouKill.java:132)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:698)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:804)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.ClassNotFoundException: org.springframework.web.context.WebApplicationContext
	at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:355)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
	at org.eclipse.jetty.webapp.WebAppClassLoader.loadClass(WebAppClassLoader.java:555)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
	... 39 more

Caused by:

java.lang.ClassNotFoundException: org.springframework.web.context.WebApplicationContext
	at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:355)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
	at org.eclipse.jetty.webapp.WebAppClassLoader.loadClass(WebAppClassLoader.java:555)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
	at java.lang.Class.getDeclaredConstructors0(Native Method)
	at java.lang.Class.privateGetDeclaredConstructors(Class.java:2671)
	at java.lang.Class.getConstructor0(Class.java:3075)
	at java.lang.Class.getDeclaredConstructor(Class.java:2178)
	at org.eclipse.jetty.server.handler.ContextHandler$Context.createInstance(ContextHandler.java:2653)
	at org.eclipse.jetty.servlet.ServletContextHandler$Context.createServlet(ServletContextHandler.java:1367)
	at org.eclipse.jetty.servlet.ServletHolder.newInstance(ServletHolder.java:1305)
	at org.eclipse.jetty.servlet.ServletHolder.initServlet(ServletHolder.java:648)
	at org.eclipse.jetty.servlet.ServletHolder.getServlet(ServletHolder.java:520)
	at org.eclipse.jetty.servlet.ServletHolder.prepare(ServletHolder.java:811)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:537)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1700)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1345)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:480)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1667)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1247)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
	at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:61)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
	at org.eclipse.jetty.server.Server.handle(Server.java:505)
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:370)
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:267)
	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)
	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
	at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.produce(EatWhatYouKill.java:132)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:698)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:804)
	at java.lang.Thread.run(Thread.java:748)


 

0个回复
daseg
kbgy
2021/01/19 21:21
  • c语言

1个回复
weixin_43932813
醽醁〇婀娜
2021/01/19 21:03
  • javascript
	var arr = [
	{name:"XM",age:20},
	{name:"Jack",age:10},
	{name:"Tom",age:30},
	{name:"XH",age:25}
	];
for(var i=0;i<arr.length;i++){
	for(var j=0;j<arr.length-i;j++){
		if(arr[i].age>arr[i+1].age){
			var tmp=arr[i];
			arr[i]=arr[i+1];
			arr[i+1]=tmp;
		}
	}
}

 

1个回复
qq_43802616
栖栖默默
2021/01/19 20:47
  • maven
  • java
  • jar

现代控制中,matlab中的c2d函数可以实现连续系统的离散化,已经知道状态空间表达式A,B,C,D,现在想要得到离散化后的系统矩阵a,请问java中有对应的c2d函数吗?或值可以得到离散化后的矩阵a即可

举个例子:例如2-22,如下图

只要利用java能够得到离散化的矩阵a即可,因为使用EKF要用到连续系统离散化后的系统矩阵a

0个回复
amimax
おもいね
2021/01/19 20:44
  • 测试用例

# include <reg52.h>
typedef unsigned int u16;
typedef unsigned  char u8;
u8 flag,a,i;
u8 table[]="I get";
void Init()
{

   TMOD = 0x20;
    SCON = 0x50;
    TH1 = 0xF3;
    TL1 = TH1;
    PCON = 0x80;
    EA = 1;
    ES = 1;
    TR1 = 1;
    
}
void main ()
{        
    Init();
    while(1){
        if(flag==1){
            ES=0;
            for(i=0;i<6;i++){
                SBUF = table[i];
                while(!TI);
                TI=0 ;
            }
            SBUF =a;
            while(!TI);
                TI=0 ;
                ES=1;
                flag=0;
            
        }
    }
}
void sda()interrupt 4{
    RI=0;
    a=SBUF; 
    flag=1;
}
 

0个回复
qq_41020955
qq_41020955
2021/01/19 20:39
  • sql

USE [PASSTEST]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[patientinfo](
    [patientid] [varchar](50) NULL,
    [patientname] [varchar](50) NULL,
    [birthdate] [varchar](20) NULL,
    [startdate] [varchar](20) NULL,
    [enddate] [varchar](20) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[patientinfo] ([patientid], [patientname], [birthdate], [startdate], [enddate]) VALUES (N'28406504', N'蒋跃波', N'1993-06-19', N'2020-06-01', N'2020-07-20')
INSERT [dbo].[patientinfo] ([patientid], [patientname], [birthdate], [startdate], [enddate]) VALUES (N'28406083', N'李亿鑫', N'1988-01-09', N'2020-06-01', N'2020-06-21')
INSERT [dbo].[patientinfo] ([patientid], [patientname], [birthdate], [startdate], [enddate]) VALUES (N'28407632', N'吴尔曼', N'1991-07-10', N'2020-06-01', N'2020-07-10')

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[drugdict](
    [drugcode] [varchar](50) NULL,
    [drugname] [varchar](50) NULL,
    [is_anti] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[drugdict] ([drugcode], [drugname], [is_anti]) VALUES (N'XY31204', N'注射用头孢呋辛钠', 1)
INSERT [dbo].[drugdict] ([drugcode], [drugname], [is_anti]) VALUES (N'XY31203', N'注射用替加环素', 1)
INSERT [dbo].[drugdict] ([drugcode], [drugname], [is_anti]) VALUES (N'XY31188', N'注射用头孢孟多酯钠', 1)
INSERT [dbo].[drugdict] ([drugcode], [drugname], [is_anti]) VALUES (N'XY31181', N'替硝唑片', 0)
INSERT [dbo].[drugdict] ([drugcode], [drugname], [is_anti]) VALUES (N'XY31131', N'注射用脂溶性维生素', 0)
INSERT [dbo].[drugdict] ([drugcode], [drugname], [is_anti]) VALUES (N'XY31151', N'金银花软胶囊', 0)

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[costinfo](
    [patientid] [varchar](50) NULL,
    [drugcode] [varchar](50) NULL,
    [drugcost] [varchar](10) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[costinfo] ([patientid], [drugcode], [drugcost]) VALUES (N'28406504', N'XY00352', N'48.0000')
INSERT [dbo].[costinfo] ([patientid], [drugcode], [drugcost]) VALUES (N'28406504', N'XY00865', N'43.1200')
INSERT [dbo].[costinfo] ([patientid], [drugcode], [drugcost]) VALUES (N'28406504', N'XY30127', N'32.4200')
INSERT [dbo].[costinfo] ([patientid], [drugcode], [drugcost]) VALUES (N'28406504', N'XY30909', N'61.7600')
INSERT [dbo].[costinfo] ([patientid], [drugcode], [drugcost]) VALUES (N'28406083', N'XY30278', N'120.0000')
INSERT [dbo].[costinfo] ([patientid], [drugcode], [drugcost]) VALUES (N'28406083', N'XY31188', N'59.4200')
INSERT [dbo].[costinfo] ([patientid], [drugcode], [drugcost]) VALUES (N'28406083', N'XY31203', N'37.7600')
INSERT [dbo].[costinfo] ([patientid], [drugcode], [drugcost]) VALUES (N'28406083', N'XY31203', N'37.7600')
INSERT [dbo].[costinfo] ([patientid], [drugcode], [drugcost]) VALUES (N'28406083', N'XY31151', N'15.3600')
INSERT [dbo].[costinfo] ([patientid], [drugcode], [drugcost]) VALUES (N'28406083', N'CY30777', N'32.4200')
INSERT [dbo].[costinfo] ([patientid], [drugcode], [drugcost]) VALUES (N'28407632', N'XY31131', N'28.4300')
INSERT [dbo].[costinfo] ([patientid], [drugcode], [drugcost]) VALUES (N'28407632', N'XY31131', N'28.4300')
INSERT [dbo].[costinfo] ([patientid], [drugcode], [drugcost]) VALUES (N'28407632', N'XY31203', N'37.7600')
INSERT [dbo].[costinfo] ([patientid], [drugcode], [drugcost]) VALUES (N'28407632', N'XY31188', N'59.4200')

要求查询结果

1个回复
sasasada
sasasada
2021/01/19 20:31
  • php
<?php
	$str = 'This is an example!';
	$preg = '/\b\w{2}\b/';
	$num1 = preg_match($preg,$str,$str1);
	echo $num1.'<br>';
	var_dump($str1);
	$num2 = preg_match_all($preg,$str,$str2);
	echo '<br>'.$num2.'<br>';
	var_dump($str2);
?>

我知道\b是单词分界符,\w是任意一个字符,{2},是匹配两次,这个正则表达式我理解的是匹配到任意2个重复的字符,比如可以匹配到aa、ee这样的字符串,但是$str1的输出结果是'is'。从输出结果看,是匹配到任意两个字符组合的重复,比如opisop,会匹配到op。希望大家能帮助我解释下这个正则表达式的意思。

3个回复
q2617426
无感五
2021/01/19 20:02
  • spring
  • java

List<List<LinkedHashMap<String, String>>> 这样的数据如何提取出来存放到数据库

以下这样的一个数据格式,我需要怎么样才可以提取出来然后保存到数据库里面呢

[[{0=20080006, 1=2020-08-15, 2=血清, 3=中枢4项, 4=陈玉仪, 5=女, 6=29, 7=脱髓鞘性脑病?, 8=P944503, 9=广东省人民医院, 10=神经内科二区, 11=, 12=15170159, 13=赖晓毅, 14=2020-08-14, 15=2020-08-14, 16=2020-08-15, 17=79530@qq.com, 18=SF1193242432617, 19=单周圆}, {0=20080007, 1=2020-08-15, 2=脑脊液, 3=自免8项, 4=陈玉仪, 5=女, 6=29, 7=脱髓鞘性脑病?, 8=P944503, 9=广东省人民医院, 10=神经内科二区, 11=, 12=15170159, 13=赖晓毅, 14=2020-08-14, 15=2020-08-14, 16=2020-08-15, 17=792830@qq.com, 18=SF1193242432617, 19=单周圆}, {0=20080008, 1=2020-08-15, 2=脑脊液, 3=中枢4项, 4=陈玉仪, 5=女, 6=29, 7=脱髓鞘性脑病?, 8=P944503, 9=广东省人民医院, 10=神经内科二区, 11=, 12=159170159, 13=赖晓毅, 14=2020-08-14, 15=2020-08-14, 16=2020-08-15, 17=795530@qq.com, 18=SF10922301418, 19=周健聪}, {0=20080009, 1=2020-08-15, 2=脑脊液, 3=副瘤11项, 4=陈旭东, 5=男, 6=49, 7=副瘤综合征待排, 8=, 9=佛山市第一人民医院, 10=神经内科, 11=, 12=13922909, 13=陈静娟, 14=2020-08-14, 15=2020-08-14, 16=2020-08-17, 17=5984126@qq.com, 18=SF10922301418, 19=周健聪}]]

 

2个回复
qq502444021
Juicer Skill Star
2021/01/19 19:56
  • linux
  • centos

0个回复
weixin_45095372
麦穗灬
2021/01/19 19:55
  • spring
  • java

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [com/roncoo/spring/boot/autoconfigure/druid/DruidAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.alibaba.druid.pool.DruidDataSource]: Factory method 'dataSource' threw exception; nested exception is java.lang.RuntimeException: java.sql.SQLException: url not set
错误原因,真的找不到哪里错误了。

 

1个回复
weixin_40357515
weixin_40357515
2021/01/19 19:43
  • php
<?php 
/**
*
* example目录下为简单的支付样例,仅能用于搭建快速体验微信支付使用
* 样例的作用仅限于指导如何使用sdk,在安全上面仅做了简单处理, 复制使用样例代码时请慎重
* 请勿直接直接使用样例对外提供服务
* 
**/
require_once "../lib/WxPay.Api.php";
require_once "WxPay.JsApiPay.php";
require_once "WxPay.Config.php";
require_once 'log.php';

//初始化日志
//$logHandler= new CLogFileHandler("../logs/".date('Y-m-d').'.log');
//$log = Log::Init($logHandler, 15);

//打印输出数组信息
function printf_info($data)
{
    foreach($data as $key=>$value){
        echo "<font color='#00ff55;'>$key</font> :  ".htmlspecialchars($value, ENT_QUOTES)." <br/>";
    }
}


//①、获取用户openid
if(isset($_REQUEST["money"]) && $_REQUEST["money"] != ""){

	$tools = new JsApiPay();
	$openId = $tools->GetOpenid();
	$money = $_REQUEST["money"];

	//②、统一下单
	$input = new WxPayUnifiedOrder();
	$input->SetBody("test");
	$input->SetAttach("test");
	$input->SetOut_trade_no(date("YmdHis"));
	$input->SetTotal_fee($money*100);     //订单金额
	$input->SetTime_start(date("YmdHis"));
	$input->SetTime_expire(date("YmdHis", time() + 600));
	$input->SetGoods_tag("test");
	$input->SetNotify_url("http://paysdk.weixin.qq.com/notify.php");
	$input->SetTrade_type("JSAPI");
	$input->SetOpenid($openId);
	$config = new WxPayConfig();
	$order = WxPayApi::unifiedOrder( $config,$input);
	//echo '<font color="#f00"><b>统一下单支付单信息</b></font><br/>';
	//printf_info($order);    统一下单支付单信息
	$jsApiParameters = $tools->GetJsApiParameters($order);

	//获取共享收货地址js函数参数
	$editAddress = $tools->GetEditAddressParameters();
  
    
}
//③、在支持成功回调通知中处理成功之后的事宜,见 notify.php
/**
 * 注意:
 * 1、当你的回调地址不可访问的时候,回调通知会失败,可以通过查询订单来确认支付是否成功
 * 2、jsapi支付时需要填入用户openid,WxPay.JsApiPay.php中有获取openid流程 (文档可以参考微信公众平台“网页授权接口”,
 * 参考http://mp.weixin.qq.com/wiki/17/c0f37d5704f0b64713d5d2c37b468d75.html)
 */
?>

<html>
 <head> 
   
 <meta charset="UTF-8" />
    <meta name="viewport" content="width=device-width,initial-scale=1,minimum-scale=1,maximum-scale=1,user-scalable=no" />
    <title>大河小马-支付</title>
    <meta http-equiv='Content-Language' content='zh' />
    <meta content="yes" name="apple-mobile-web-app-capable">
    <meta id="viewport" name="viewport" content="width=device-width,minimum-scale=1.0,maximum-scale=1.0,user-scalable=no">
    <link rel="stylesheet" type="text/css" href="css/bootstrap-4.0.0-dist/css/bootstrap.min.css" />
	<link rel="stylesheet" type="text/css" href="css/style.css" />
    <script type="text/javascript">
	//调用微信JS api 支付   
 
	function jsApiCall()
	{
		WeixinJSBridge.invoke(
			'getBrandWCPayRequest',
			<?php echo $jsApiParameters; ?>,
			function(res){
				WeixinJSBridge.log(res.err_msg);
				alert(res.err_code+res.err_desc+res.err_msg);
			}
		);
	}

	function callpay()
	{
		if (typeof WeixinJSBridge == "undefined"){
		    if( document.addEventListener ){
		        document.addEventListener('WeixinJSBridgeReady', jsApiCall, false);
		    }else if (document.attachEvent){
		        document.attachEvent('WeixinJSBridgeReady', jsApiCall); 
		        document.attachEvent('onWeixinJSBridgeReady', jsApiCall);
		    }
		}else{
		    jsApiCall();
		}
	}
	</script>
	<script type="text/javascript">
	//获取共享地址
	function editAddress()
	{
		WeixinJSBridge.invoke(
			'editAddress',
			<?php echo $editAddress; ?>,
			function(res){
				var value1 = res.proviceFirstStageName;
				var value2 = res.addressCitySecondStageName;
				var value3 = res.addressCountiesThirdStageName;
				var value4 = res.addressDetailInfo;
				var tel = res.telNumber;
				
				alert(value1 + value2 + value3 + value4 + ":" + tel);
			}
		);
	}
	
window.onload = function(){
		 var src;
		 src = '<?=$money;?>';
 
		if(src) {
			document.getElementById("money").value = '<?=$money;?>';
			if (typeof WeixinJSBridge == "undefined"){
			    if( document.addEventListener ){
			        document.addEventListener('WeixinJSBridgeReady', jsApiCall, false);
			    }else if (document.attachEvent){
			        document.attachEvent('WeixinJSBridgeReady', jsApiCall); 
			        document.attachEvent('onWeixinJSBridgeReady', jsApiCall);
			    }
			}else{
			    jsApiCall();
			}
		}
	};

	
	</script>
</head>
<body>
	<section >
		<header class="text-center font-16 ">欢迎来到大河小马支付</header>
		<div class="content m-15">
			<form class="container "  action="#" method="post">
				<div class="form-group pt-10">
					<label for="exampleInputEmail1">付款金额</label>
					<input type="number"  class="form-control" id="money" placeholder="请输入您的付款金额" name="money">
				</div>
				<button type="submit" class="btn btn-primary btn-block">提交支付</button>
			</form>
		</div>
	</section>
	<script type="text/javascript" src="js/jquery-3.3.1.min.js"></script>
	<script type="text/javascript" src="css/bootstrap-4.0.0-dist/js/bootstrap.min.js"></script>
    <!-- <form action="#" method="post">
        <div style="margin-left:2%;color:#f00">微信支付公司</div><br/>
        <div style="margin-left:2%;">输入金额:</div><br/>
        <input type="text" style="width:96%;height:35px;margin-left:2%;" name="money"; id="money" /><br /><br />
		<div align="center">
			<input type="submit" value="支付" style="width:210px; height:80px; border-radius: 15px;background-color:#FE6714; border:0px #FE6714 solid; cursor: pointer;  color:white;  font-size:16px;" type="button" />
		</div>
	</form> -->
</body>
</html>

 

0个回复
Vshang66666
s浅殇丶
2021/01/19 19:41
  • android
  • java

 在git上刚拉的代码,没有任何改动,gradle编译的时候就报错了,新建一个空的android也是这个,求大佬们看一看

Cause: java.util.ConcurrentModificationException
	at java.base/java.util.HashMap.computeIfAbsent(Unknown Source)
	at com.android.ide.common.gradle.model.ModelCache.computeIfAbsent(ModelCache.java:29)
	at com.android.ide.common.gradle.model.IdeProductFlavor.copyVectorDrawables(IdeProductFlavor.java:80)
	at com.android.ide.common.gradle.model.IdeProductFlavor.<init>(IdeProductFlavor.java:56)
	at com.android.ide.common.gradle.model.IdeProductFlavorContainer.lambda$new$0(IdeProductFlavorContainer.java:42)
	at com.android.ide.common.gradle.model.ModelCache.lambda$computeIfAbsent$0(ModelCache.java:29)
	at java.base/java.util.HashMap.computeIfAbsent(Unknown Source)
	at com.android.ide.common.gradle.model.ModelCache.computeIfAbsent(ModelCache.java:29)
	at com.android.ide.common.gradle.model.IdeProductFlavorContainer.<init>(IdeProductFlavorContainer.java:40)
	at com.android.ide.common.gradle.model.IdeAndroidProjectImpl.lambda$new$0(IdeAndroidProjectImpl.java:86)
	at com.android.ide.common.gradle.model.ModelCache.lambda$computeIfAbsent$0(ModelCache.java:29)
	at java.base/java.util.HashMap.computeIfAbsent(Unknown Source)
	at com.android.ide.common.gradle.model.ModelCache.computeIfAbsent(ModelCache.java:29)
	at com.android.ide.common.gradle.model.IdeAndroidProjectImpl.<init>(IdeAndroidProjectImpl.java:84)
	at com.android.ide.common.gradle.model.IdeAndroidProjectImpl.<init>(IdeAndroidProjectImpl.java:68)
	at com.android.tools.idea.gradle.project.model.AndroidModuleModel.<init>(AndroidModuleModel.java:134)
	at com.android.tools.idea.gradle.project.model.AndroidModuleModel.<init>(AndroidModuleModel.java:125)
	at com.android.tools.idea.gradle.project.sync.idea.AndroidGradleProjectResolver.populateModuleContentRoots(AndroidGradleProjectResolver.java:213)
	at org.jetbrains.plugins.gradle.service.project.AbstractProjectResolverExtension.populateModuleContentRoots(AbstractProjectResolverExtension.java:97)
	at org.jetbrains.plugins.gradle.service.project.AbstractProjectResolverExtension.populateModuleContentRoots(AbstractProjectResolverExtension.java:97)
	at org.jetbrains.plugins.gradle.service.project.AbstractProjectResolverExtension.populateModuleContentRoots(AbstractProjectResolverExtension.java:97)
	at org.jetbrains.kotlin.idea.configuration.KotlinGradleProjectResolverExtension.populateModuleContentRoots(KotlinGradleProjectResolverExtension.kt:295)
	at org.jetbrains.plugins.gradle.service.project.AbstractProjectResolverExtension.populateModuleContentRoots(AbstractProjectResolverExtension.java:97)
	at org.jetbrains.kotlin.android.configure.KotlinAndroidMPPGradleProjectResolver.populateModuleContentRoots(KotlinAndroidMPPGradleProjectResolver.kt:51)
	at org.jetbrains.plugins.gradle.service.project.AbstractProjectResolverExtension.populateModuleContentRoots(AbstractProjectResolverExtension.java:97)
	at org.jetbrains.plugins.gradle.service.project.AbstractProjectResolverExtension.populateModuleContentRoots(AbstractProjectResolverExtension.java:97)
	at org.jetbrains.plugins.gradle.service.project.TracedProjectResolverExtension.populateModuleContentRoots(TracedProjectResolverExtension.java:62)
	at org.jetbrains.plugins.gradle.service.project.GradleProjectResolver.doResolveProjectInfo(GradleProjectResolver.java:379)
	at org.jetbrains.plugins.gradle.service.project.GradleProjectResolver.access$200(GradleProjectResolver.java:73)
	at org.jetbrains.plugins.gradle.service.project.GradleProjectResolver$ProjectConnectionDataNodeFunction.fun(GradleProjectResolver.java:736)
	at org.jetbrains.plugins.gradle.service.project.GradleProjectResolver$ProjectConnectionDataNodeFunction.fun(GradleProjectResolver.java:719)
	at org.jetbrains.plugins.gradle.service.execution.GradleExecutionHelper.execute(GradleExecutionHelper.java:227)
	at org.jetbrains.plugins.gradle.service.project.GradleProjectResolver.resolveProjectInfo(GradleProjectResolver.java:138)
	at org.jetbrains.plugins.gradle.service.project.GradleProjectResolver.resolveProjectInfo(GradleProjectResolver.java:73)
	at com.intellij.openapi.externalSystem.service.remote.RemoteExternalSystemProjectResolverImpl.lambda$resolveProjectInfo$0(RemoteExternalSystemProjectResolverImpl.java:36)
	at com.intellij.openapi.externalSystem.service.remote.AbstractRemoteExternalSystemService.execute(AbstractRemoteExternalSystemService.java:57)
	at com.intellij.openapi.externalSystem.service.remote.RemoteExternalSystemProjectResolverImpl.resolveProjectInfo(RemoteExternalSystemProjectResolverImpl.java:36)
	at com.intellij.openapi.externalSystem.service.remote.wrapper.ExternalSystemProjectResolverWrapper.resolveProjectInfo(ExternalSystemProjectResolverWrapper.java:44)
	at com.intellij.openapi.externalSystem.service.internal.ExternalSystemResolveProjectTask.doExecute(ExternalSystemResolveProjectTask.java:99)
	at com.intellij.openapi.externalSystem.service.internal.AbstractExternalSystemTask.execute(AbstractExternalSystemTask.java:165)
	at com.intellij.openapi.externalSystem.service.internal.AbstractExternalSystemTask.execute(AbstractExternalSystemTask.java:151)
	at com.intellij.openapi.externalSystem.util.ExternalSystemUtil$3.executeImpl(ExternalSystemUtil.java:559)
	at com.intellij.openapi.externalSystem.util.ExternalSystemUtil$3.lambda$execute$0(ExternalSystemUtil.java:399)
	at com.intellij.openapi.project.DumbServiceImpl.suspendIndexingAndRun(DumbServiceImpl.java:146)
	at com.intellij.openapi.externalSystem.util.ExternalSystemUtil$3.execute(ExternalSystemUtil.java:399)
	at com.intellij.openapi.externalSystem.util.ExternalSystemUtil$5.run(ExternalSystemUtil.java:664)
	at com.intellij.openapi.progress.impl.CoreProgressManager$TaskRunnable.run(CoreProgressManager.java:731)
	at com.intellij.openapi.progress.impl.CoreProgressManager.lambda$runProcess$2(CoreProgressManager.java:164)
	at com.intellij.openapi.progress.impl.CoreProgressManager.registerIndicatorAndRun(CoreProgressManager.java:586)
	at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:532)
	at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:86)
	at com.intellij.openapi.progress.impl.CoreProgressManager.runProcess(CoreProgressManager.java:151)
	at com.intellij.openapi.progress.impl.CoreProgressManager$4.run(CoreProgressManager.java:403)
	at com.intellij.openapi.application.impl.ApplicationImpl$1.run(ApplicationImpl.java:311)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
	at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.base/java.lang.Thread.run(Unknown Source)

 

0个回复
qq_40245248
别再叫我打游戏了
2021/01/19 19:40
  • 神经网络
  • 深度学习

只是求个关于深度学习的毕设题目,目标检测或者行为识别的都行。

0个回复