- r语言
- vue.js
- c语言
- python
- 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?
- mysql
- 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()
- sql
- 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"??

- java
- 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");
}
- 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就变成了抽象二值图像。。。。
求求各位大神告知为何
- visual studio
- python
- python
- 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)
- javascript
- maven
- java
- jar
- 测试用例
# 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;
}
- 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')
要求查询结果
- 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。希望大家能帮助我解释下这个正则表达式的意思。
- 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=周健聪}]]
- 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
错误原因,真的找不到哪里错误了。
- 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>
- 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)