pl/sql sql Oracle DRA-01008并非所有变量都已绑定

这个大佬能看看这中间有什么毛病嘛
图片说明

这边是我的sql语句

 Select a.*
  From (select /*+first_rows*/
         wi.iid as 顺序号,
         w.wname as 案件类型,
         i.name as 名称,
         x.联系人 as 联系人,
         wi.accepted_time as 接收时间,
         wi.submit_time as 提交时间,
         (Select user_name From st_user Where userid = wi.senduserid) as 前一用户,
         wi.wiid,
         wi.step as 所在岗位,
         x.业务类型id as BusinessId
          from ST_WORK_ITEM_HIST wi,
               xt_instance       x,
               st_instance       i,
               st_workflow       w
         where wi.iid = x.iid
           and x.iid = i.iid
           and i.wid = w.wid
           and wi.userid = :userId
           and x.业务类型id in
               (select id from sys_business_type b where b.type = :type)
         order by wi.accepted_time desc) a
 Where rownum <= 10

4个回答

type这个变量在哪里定义的?

(select id from sys_business_type b where b.type = :type)
换成具体的值,不用type变量看看是否报错。

qq_38081404
IT界98新星 一样的 我开始复制错代码了 我把占位符删了也是说01008
一年多之前 回复

那个代码 :type用具体的值 删掉也是报同一个错

今天碰到一个很普通的问题:ORA-01008:并非所有的变量都已绑定,看着错误的提示,总以为是自己的变量和值不是对称的,检查了很多遍,后来,突然想起可能是因为变量的值是null造成的,而并非值和和变量没有一一对应。经检查发现,确实有一个值是null,不是空格,然后把值改成空格,就好了。

分析执行计划的话,:换成&试试,应该就可以过去了

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
响应类型正在从JSON更改为HTML,而不进行任何代码更改

<div class="post-text" itemprop="text"> <p>I have a legacy application in CakePHP 2.x</p> <p>It has a method in a Controller that outputs JSON in a structure like this:</p> <pre><code>{"id":59,"name":"Association of Southeast Asian Nations (ASEAN)","n_grouptags":1} </code></pre> <p>The controller method used <code>$this-&gt;response-&gt;type('json');</code> to set the <code>content-type</code> in the response to <code>application/json; charset=UTF-8</code>. All good.</p> <p>What I noticed is that if the returned data becomes over a certain length, the <code>content-type</code> is set to <code>text/html; charset=UTF-8</code> <b>without any changes to the code</b>.</p> <p>I've included some screenshots below which show this, including the response type.</p> <p>Small amount of data (content type = <code>application/json</code> - expected):</p> <p><a href="https://i.stack.imgur.com/T2qQn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/T2qQn.png" alt="enter image description here"></a></p> <p><a href="https://i.stack.imgur.com/v6dra.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/v6dra.png" alt="enter image description here"></a></p> <p>More data (content type = <code>text/html</code> - unexpected):</p> <p><a href="https://i.stack.imgur.com/OPWA5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OPWA5.png" alt="enter image description here"></a></p> <p><a href="https://i.stack.imgur.com/wOuEE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wOuEE.png" alt="enter image description here"></a></p> <p>In both cases I have checked that the JSON is valid using <a href="https://jsonlint.com/" rel="nofollow noreferrer">https://jsonlint.com/</a></p> <p>Why is this? Does it depend on the length of the response as to how the browser treats it, or is this a CakePHP problem?</p> <p>The PHP that is responsible for the output is as follows - <i>but no changes have been made to this between the 2 different outputs given above</i>:</p> <pre><code> $this-&gt;autoRender = false; // No View (template) is associated with this $out = []; // Reset // $tags is some data from a model foreach ($tags as $k =&gt; $v) { $n_grouptags = 123; // Actual number comes from a Model $out[] = ['id' =&gt; $k, 'name' =&gt; $v, 'n_grouptags' =&gt; $n_grouptags]; } $this-&gt;response-&gt;type('json'); // We *want* a JSON response echo json_encode($out, JSON_FORCE_OBJECT); // Encode $out (the output) as JSON </code></pre> <p>Caching within the application is disabled: <code>Configure::write('Cache.disable', true);</code></p> </div>

Could not get JDBC Connection

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' ### The error may exist in cn/drzk/wanda/cinema/dao/form/dao/TicketsFromDao.java (best guess) ### The error may involve cn.drzk.wanda.cinema.dao.form.dao.TicketsFromDao.count ### The error occurred while executing a query ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'

event.setLocation(width/2, event.getY()); 是干嘛用的?

事件分发前getChildAt(0).dispatchTouchEvent(event) 为什么要用这个方法event.setLocation(width/2, event.getY()); 这个方法是干嘛用的?

windows wget没办法下载一个网页内的所有文件,怎么办?

![图片说明](https://img-ask.csdn.net/upload/201812/06/1544110629_850991.png)如图,我要批量下载这个网页目录下的所有文件。用了下面这段代码: ``` wget -r -nH --cut-dirs 2 --restrict-file-names=nocontrol -P F:\data --http-user=XXXX --http-passwd=XXXX https://n5eil01u.ecs.nsidc.org/SMAP/SPL2SMAP_S.002/2015.03.31/ ``` (由于隐私,用户名和密码我用XXXX代替) 执行代码后过程如下: ``` --2018-12-06 23:39:12-- https://urs.earthdata.nasa.gov/oauth/authorize?app_type=401&client_id=_JLuwMHxb2xX6NwYTb4dRA&response_type=code&redirect_uri=https%3A%2F%2Fn5eil01u.ecs.nsidc.org%2FOPS%2Fredirect&state=aHR0cDovL241ZWlsMDF1LmVjcy5uc2lkYy5vcmcvU01BUC9TUEwyU01BUF9TLjAwMi8yMDE1LjAzLjMxLw Resolving urs.earthdata.nasa.gov (urs.earthdata.nasa.gov)... 2001:4d0:241a:4081::89, 198.118.243.33 Connecting to urs.earthdata.nasa.gov (urs.earthdata.nasa.gov)|2001:4d0:241a:4081::89|:443... connected. HTTP request sent, awaiting response... 401 Unauthorized Authentication selected: Basic realm="Please enter your Earthdata Login credentials. If you do not have a Earthdata Login, create one at https://urs.earthdata.nasa.gov//users/new" Reusing existing connection to [urs.earthdata.nasa.gov]:443. HTTP request sent, awaiting response... 302 Found Location: https://n5eil01u.ecs.nsidc.org/OPS/redirect?code=b01004c779d377e755a8baf424ff2a756a0d61469640e0175dd9a42b92100c71&state=aHR0cDovL241ZWlsMDF1LmVjcy5uc2lkYy5vcmcvU01BUC9TUEwyU01BUF9TLjAwMi8yMDE1LjAzLjMxLw [following] --2018-12-06 23:39:14-- https://n5eil01u.ecs.nsidc.org/OPS/redirect?code=b01004c779d377e755a8baf424ff2a756a0d61469640e0175dd9a42b92100c71&state=aHR0cDovL241ZWlsMDF1LmVjcy5uc2lkYy5vcmcvU01BUC9TUEwyU01BUF9TLjAwMi8yMDE1LjAzLjMxLw Connecting to n5eil01u.ecs.nsidc.org (n5eil01u.ecs.nsidc.org)|128.138.97.102|:443... connected. HTTP request sent, awaiting response... 302 Found Location: https://n5eil01u.ecs.nsidc.org/SMAP/SPL2SMAP_S.002/2015.03.31/ [following] --2018-12-06 23:39:16-- https://n5eil01u.ecs.nsidc.org/SMAP/SPL2SMAP_S.002/2015.03.31/ Connecting to n5eil01u.ecs.nsidc.org (n5eil01u.ecs.nsidc.org)|128.138.97.102|:443... connected. HTTP request sent, awaiting response... 200 OK Length: unspecified [text/html] Saving to: 'F:/data/2015.03.31/index.html' 2015.03.31/index.html [ <=> ] 29.25K 49.5KB/s in 0.6s 2018-12-06 23:39:17 (49.5 KB/s) - 'F:/data/2015.03.31/index.html' saved [29950] FINISHED --2018-12-06 23:39:17-- Total wall clock time: 6.4s Downloaded: 1 files, 29K in 0.6s (49.5 KB/s) ``` 最终仅仅只是下了个Index文件。 我想问一下这里面是哪里出错了?

liunx 安装 systemd-219-42.el7.x86_64.rpm

为啥总是有那么多要安装啊!求大神指点 rpm -ivh systemd-219-42.el7.x86_64.rpm warning: systemd-219-42.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID f4a80eb5: NOKEY error: Failed dependencies: kmod >= 18-4 is needed by systemd-219-42.el7.x86_64 libc.so.6(GLIBC_2.16)(64bit) is needed by systemd-219-42.el7.x86_64 libc.so.6(GLIBC_2.17)(64bit) is needed by systemd-219-42.el7.x86_64 libcryptsetup.so.4()(64bit) is needed by systemd-219-42.el7.x86_64 libcryptsetup.so.4(CRYPTSETUP_1.0)(64bit) is needed by systemd-219-42.el7.x86_64 libkmod.so.2()(64bit) is needed by systemd-219-42.el7.x86_64 libkmod.so.2(LIBKMOD_5)(64bit) is needed by systemd-219-42.el7.x86_64 liblzma.so.5()(64bit) is needed by systemd-219-42.el7.x86_64 liblzma.so.5(XZ_5.0)(64bit) is needed by systemd-219-42.el7.x86_64 libmount.so.1(MOUNT_2.20)(64bit) is needed by systemd-219-42.el7.x86_64 libqrencode.so.3()(64bit) is needed by systemd-219-42.el7.x86_64 systemd-libs = 219-42.el7 is needed by systemd-219-42.el7.x86_64 dracut < 033-499 conflicts with systemd-219-42.el7.x86_64 initscripts < 9.49.28-1 conflicts with systemd-219-42.el7.x86_64

C#datatable不能正确显示平均数

AVG不能正常显示平均数,怎么办 ``` DataTable dt = new DataTable("rawData"); //新建行和列 dt.Columns.Add("Time"); dt.Columns.Add("FeederErr"); dt.Columns.Add("NozzleErr"); dt.Columns.Add("HeadErr"); dt.Columns.Add("AVG"); //获取数据 DataTable a = BLL.NXTChartMgr.GetNozzleData(); DataTable b = BLL.NXTChartMgr.GetFeederData(); DataTable c = BLL.NXTChartMgr.GetHeadData(); //先循环A,循环一条A,再找B和C,再插入到结果表里 foreach (DataRow drA in a.Rows) { //得到B和C的Err DataRow drB = b.Select("MACHINE='" + drA["MACHINE"] + "' and uplddte= '" + drA["uplddte"] +"'")[0]; DataRow drC = c.Select("MACHINE='" + drA["MACHINE"] + "' and uplddte= '" + drA["uplddte"] +"'")[0]; //计算avg值 List<double> list = new List<double>(); for (int i = 0; i < a.Rows.Count; i++) { double d = (Convert.ToDouble(a.Rows[i]["NozzleErr"]) + Convert.ToDouble(b.Rows[i]["FeederErr"]) + Convert.ToDouble(c.Rows[i]["HeadErr"])) / 3; list.Add(d); } //新建一行 DataRow dr = dt.NewRow(); //赋值 dr["Time"] = drA["uplddte"]; dr["NozzleErr"] = drA["NozzleErr"]; dr["FeederErr"] = drB["FeederErr"]; dr["HeadErr"] = drC["HeadErr"]; dr["AVG"] = list; //构造dr后,插入dt dt.Rows.Add(dr); } return dt; ``` ![图片说明](https://img-ask.csdn.net/upload/201612/22/1482394432_680354.png)

将我的RESTful API仅限于我的应用程序

<div class="post-text" itemprop="text"> <p>I recently started using BackboneJS and for a new project I need to access a MySQL database on a server I have full access to.</p> <p>I've been reading up on RESTful APIs and now I want to set up one but I'm not quite sure about one thing: will other people be able to insert rows into my database via the RESTful API I will set up (using <a href="http://slimframework.com/" rel="nofollow">Slim</a>)</p> <p>I know it won't be possible using JavaScript/AJAX because of the same domain policy. But what if someone POSTs to the API using PHP/cURL or something similar? Will it be possible to insert rows using this method without me checking stuff on the server-side?</p> <p>In short I just want to be sure I'm the only one that can insert (create, put, delete) things into the database, I don't really care about reading (get) but I'm guessing that if you can't insert you can't read either.</p> <p><strong>EDIT</strong></p> <p>Please note that this question is not about authenticating users, It's about whether others will be able to simply use my API using cURL or something similar.</p> </div>

为什么get_url()函数运行到response = requests.get(url, headers=headers),会被提示“无法加载源“<string>”: Source unavailable”?

``` import requests, time, random from fake_useragent import UserAgent from lxml import etree def get_url(url): headers = { "User-Agent": UserAgent().random } time.sleep(random.randint(3, 9)) response = requests.get(url, headers=headers) response.encoding='utf8' if response.status_code == 200: return response.text else: return None def parse_index(html): e = etree.HTML(html) movie_base_url = "https://maoyan.com{}?catId=3&showType=3" all_url = e.xpath('//div[@class="movie-item film-channel"]/a/@href') return [movie_base_url.format(url) for url in all_url] def parse_info(html): e = etree.HTML(html) name = e.xpath('//h1[@class="name"]') type_ = e.xpath('//li[@class="ellipsis"][1]') contary_duration = e.xpath('//li[@class="ellipsis"][2]') year = e.xpath('//li[@class="ellipsis"][3]') introduce = e.xpath('//span[@class="dra"]') return { "name": name, "type": type_, "contary_duration": contary_duration, "year": year, "introduce": introduce } def main(): """ base_url = "https://maoyan.com/films?catId=3&showType=3&offset={}" for i in range(0, 3): new_url = base_url.format(i*30) # time.sleep(random.randint(2,4)) html = get_url(new_url) movie_urls = parse_index(html) for movie_url in movie_urls: movie_html = get_url(movie_url) movie_info = parse_info(movie_html) with open('movie.txt', 'a', encoding='utf8') as f: f.write(movie_info, encoding='utf8') """ base_url = "https://maoyan.com/films?catId=3&showType=3&offset=0" html = get_url(base_url) movie_urls = parse_index(html) for movie_url in movie_urls: movie_html = get_url(movie_url) movie_info = parse_info(movie_html) with open('movie.txt', 'a', encoding='utf8') as f: f.write(movie_info, encoding='utf8') if __name__ == "__main__": main() ```

为什么会提示 无法加载源"<string>": sourse unavailable

get_url()函数运行到response=requests.get()处会提示:无法加载源“<string>”: Source unavailable。整个运行下来不会有任何结果。 import requests, time, random from fake_useragent import UserAgent from lxml import etree def get_url(url): headers = { "User-Agent": UserAgent().random } time.sleep(random.randint(3, 9)) response = requests.get(url, headers=headers) response.encoding='utf8' if response.status_code == 200: return response.text else: return None def parse_index(html): e = etree.HTML(html) movie_base_url = "https://maoyan.com{}?catId=3&showType=3" all_url = e.xpath('//div[@class="movie-item film-channel"]/a/@href') return [movie_base_url.format(url) for url in all_url] def parse_info(html): e = etree.HTML(html) name = e.xpath('//h1[@class="name"]') type_ = e.xpath('//li[@class="ellipsis"][1]') contary_duration = e.xpath('//li[@class="ellipsis"][2]') year = e.xpath('//li[@class="ellipsis"][3]') introduce = e.xpath('//span[@class="dra"]') return { "name": name, "type": type_, "contary_duration": contary_duration, "year": year, "introduce": introduce } def main(): base_url = "https://maoyan.com/films?catId=3&showType=3&offset={}" for i in range(0, 3): new_url = base_url.format(i*30) # time.sleep(random.randint(2,4)) html = get_url(new_url) movie_urls = parse_index(html) for movie_url in movie_urls: movie_html = get_url(movie_url) movie_info = parse_info(movie_html) with open('movie.txt', 'a', encoding='utf8') as f: f.write(movie_info, encoding='utf8') if __name__ == "__main__": main()

andriod TabHost问题

package xx.com.test; import android.app.ActivityManager; import android.app.LocalActivityManager; import android.content.Context; import android.content.Intent; import android.net.Uri; import android.R.string; import android.support.v7.app.AppCompatActivity; import android.os.Bundle; import android.util.Log; import android.widget.TabHost; import com.google.android.gms.appindexing.Action; import com.google.android.gms.appindexing.AppIndex; import com.google.android.gms.common.api.GoogleApiClient; public class MainActivity extends AppCompatActivity { private TabHost th; private Intent soft; private Intent money; private Intent bill; private Intent me; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); soft = new Intent(MainActivity.this, SoftyActivity.class); money = new Intent(MainActivity.this, MoneyActivity.class); bill = new Intent(MainActivity.this, BillActivity.class); me = new Intent(MainActivity.this, MeActivity.class); setContentView(R.layout.activity_main); th = (TabHost) findViewById(R.id.tabHost); th.setup(); th.addTab(buildTagSpec("tab_soft", R.string.soft, R.drawable.shezhi, soft)); th.addTab(buildTagSpec("tab_money", R.string.money, R.drawable.shezhi, money)); th.addTab(buildTagSpec("tab_bill", R.string.bill, R.drawable.shezhi, bill)); th.addTab(buildTagSpec("tab_me", R.string.me, R.drawable.shezhi, me)); } private TabHost.TabSpec buildTagSpec(String tagName, int tagLable, int icon, Intent content) { return th.newTabSpec(tagName) .setIndicator(getResources().getString(tagLable), getResources().getDrawable(icon, null)).setContent(content); } } ![图片说明](https://img-ask.csdn.net/upload/201603/27/1459067980_504354.png)

调用DOMPDF库的render方法时超时

<div class="post-text" itemprop="text"> <p>PDF with few pages it works perfectly but when I try to generate a PDF file with more than 20 pages, it presents this error in the browser</p> <p><a href="https://i.stack.imgur.com/HhqE9.png" rel="nofollow noreferrer">ERR_CONECTION_RESET</a></p> <p>This is my code to generate pdf:</p> <pre><code>$html = ' &lt;style&gt; * { font-family: Tahoma, Verdana, Segoe, sans-serif; color: #333333; font-size: 9px;} &lt;/style&gt; &lt;table width="100%" border="0" cellpadding="1" cellspacing="1" bgcolor="#333333"&gt; &lt;tr&gt; &lt;td height="70" bgcolor="#ffffff" colspan="7" align="center" valign="middle"&gt;&lt;b style="font-size: 18px;"&gt;RELATÓRIO DE FECHAMENTO - Nº '.$id.'&lt;/b&gt;&lt;br&gt;&lt;b&gt;Data do pagamento: '.date('d/m/Y', strtotime($objDados[$idx]-&gt;dtpagamento)).'&lt;/b&gt;&lt;/td&gt; &lt;td bgcolor="#ffffff" align="center" width="130"&gt;&lt;img src="data:image/gif;base64,R0lGODlhhQAwAPcAAAAAAP////7+//r7/e7y+Pb4+wZElD5urEp3sU56s1qDuGqPv3aYxHqbxoOiyoaky4qnzZKt0Jaw0p621aa82a7C3LLF3rbI4MLR5cvY6dLd7Nrj7+ft9erv9gBAkQFBkQJBkgdFlAhGlApHlQtIlgxJlg1Klw9LlxBMmBZQmhhSmxtUnRxVnR9XniBYnyFZnyNaoCRboSddoipfoytgpCxhpC9jpTBkpjFlpjVoqDdpqThqqTprqjtsqj9vrEBwrUJxrUNyrkV0r0RzrkZ0r0d1sE97s1F9tFJ9tFWAtlaAtleBt1iCt1mDt1yFuWCIumKJu2WMvWuQv2yRwG6SwHOWw3KVwnSXw3mbxXucxn+fyH6ex4SjyoWkyoimzIely4ypzY+rz46qzpGt0JOu0JSv0Ziy05mz05qz05u01J221Zy11KC41qG51qS72KO616e92ai+2aq/2q3C3LDE3bHF3bXI37fJ4LnL4bzN4sHR5MXU5sfV58bU5snX6MjW59Dc68/b6tTf7Nnj79ji7uDo8uPq8+Lp8uvw9s3a6d3m8OXs9Onv9uju9e3y9/T3+vj6/Pv8/f7+/v39/fz8/Pv7+/r6+vn5+fj4+Pf39/X19fPz8/Ly8vHx8fDw8O/v7+7u7u3t7ezs7Ovr6+rq6unp6efn5+bm5uXl5eTk5OPj4+Li4uHh4eDg4N/f397e3t3d3dra2tnZ2djY2NfX19bW1tXV1dPT09LS0tHR0dDQ0M/Pz83NzczMzMvLy8rKysnJycjIyMbGxsXFxcTExMPDw8LCwsHBwcDAwL+/v76+vry8vLq6uri4uLe3t7a2trW1tbS0tLOzs7KysrGxsbCwsK+vr66urqurq6qqqqmpqaioqKenp6WlpaOjo6Kiop+fn56enp2dnZycnJqampmZmZeXl5aWlpSUlJGRkZCQkI+Pj46Ojo2NjYyMjIuLi4qKiomJiYiIiIeHh4aGhoWFhYSEhIODg4GBgYCAgH9/f35+fn19ff///wAAAAAAACH5BAEAAP0ALAAAAACFADAAAAj/AAMIHEiwoMGDCBMqXMiwocOHECNKnEixosWLGDNq3Mixo8ePIEOKHEmypMmTKFOqXMmypcuXMGPKnEmzps2bOHPq3DlQGDduwngqFPTECJRBCz+hOsW0qdNTqDpx5EeV30YBgRJp3cp166ONWjyIhbBwXtWzaPm9k7SxHdV2G++InUu37pWNYuaaWZi2L1VLG9lRZbexTN3Dc41sDDP3zMJ0ftGeY6tRMD/CGvWAQHzYweLGCy1xGs0JWtVnpDlV4mgZs0YOi2IvcjE3j+xFHBmL3fvwWFVjBS+tajWqYKVUrUoR7NQqlUBSxoqJEmj5nUBYxY7pwpTQUy5jyITF/6KkUMZc3AYZUXjAxUwghX3KfCHjh6BuD24CNErDZcz7hMtUtUxB0VRlCkHJVOXKQO5QFYoqVYVDHVXjjALOWfTgYhAn26QVDzIJxTCXBgZJYUBdQyhi0B021KUDIALp9gEdboRAFxQAClgQNlWxQpAzVdEykFn8aJNPVeJMyE88+/S14ECi3BPZNgiJKBaJA0VyA2ciGEJQHJz9EKNYIKSAmBUIBUjVgARVU5UqBKnJTywDudXkWeYoWZU55JxlnUCTwFNVPM4sM85ZvBxkpQdYCvTEXEzgkccCc4kpEAd0vRAFEyJ4UMOYdIVAQ11p6tjmm3FWRadAblXlTCivtP+iJz+1CHTLWbIGAExV6AAm0DNVwWXQoo1uMBcRBDkxFyECUTFXEQN1IEQToIqVQCMBaICCWCKUumZBblIF50ByrhpAq/xMY5Bl+MBCUDe/CVROVasUJE9VoAw74kBfzOXlQIWAJoCZHnyACEL3IUDQFmKZ4C0/bA4ULj/jClRunVTNc5Bl6xTES1XVBHDJkfxoXBA3Vdmi75UDJTEXGGqssYYaWczVRQCKzJVDQvfNQRAcDT8csUATVxzAxaxS1fG6gxU0S1XcBBBKVecYBCxVvqzM6EA9cEYXAwHwMZcSPM+FBkFvBH2QnEMHMLFz5KqKMT/CFtRaQbJUReUoexr/1ExVvWjd6A5zbUbXBx+MYEEAGMy1RNliOTZQG2obxHZB1hhI0DByJ033xlSlU1AuVUkTgCdV/UlQNlXNIvhAQMzlx22yESBQBnMdALkHkgtEuQcOr22qxFW5O9A3nZ/7Fuj81KMJQTxSRUwAk9BTlScFvVPVJq8LFMVc/yHUwVwhQIIwaJNXXtDlBDGD5EDXnGVuq3UTZNllUgXAylmoCIQyVdogCDGopqh9CSRtYvGBQQRwMIFsSSw4GsgToBWA+/QuAL8LnuWGJ5C8Ue0a96PK/JbHtKrg4xlXo4o6BrK/qnhjF7mIX/IIQqyBFIAEcwmCHP7Qhzk0gAU4GAgC/8VyAC5gAQYeWEG1LphBhLiPKswoiCQalBZ0aI8fshjIFVVHkAbtQx1+gZtAChQZaCCkBeAjyAW85gEUEIQHnJmBQMAwFwkQZAJiKQFCgESVZhgEFII6izMkUZUsCoRk+TiIPqgCC9KdJR+5MIgyFokWexQjIScw4EDq8ALONIAgAjjCYVRgB4H0SywRIEga5oIQTvziGL/gxEEqQQxscOMZPgrALYzhi0sMBDvFMB7ejBEMwJiiGdvIBjJkeZBNBIMaP5FGLzIBHzB4oQKROMgcqtAEJCjACmw4xEH20AAFKGEKbhjAQBohgQecoYECcQQaunBBodjznvjMpz73yRnPfvrznwANqEAHStCCGvSgCE2oQhf6z4AAADs=" border="0"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td height="30" bgcolor="#ffffff" colspan="8" align="center" valign="middle" colspan="2"&gt;&lt;b style="font-size: 16px;"&gt;DETALHADO&lt;/b&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr style="color: #ffffff !important;"&gt; &lt;td bgcolor="#1369a1" width="45" height="20"&gt;&lt;b&gt;DATA&lt;/b&gt;&lt;/td&gt; &lt;td bgcolor="#1369a1"&gt;&lt;b&gt;TIPO&lt;/b&gt;&lt;/td&gt; &lt;td bgcolor="#1369a1" width="30"&gt;&lt;b&gt;CHAPA&lt;/b&gt;&lt;/td&gt; &lt;td bgcolor="#1369a1" width="150"&gt;&lt;b&gt;NOME&lt;/b&gt;&lt;/td&gt; &lt;td bgcolor="#1369a1"&gt;&lt;b&gt;BANCO&lt;/b&gt;&lt;/td&gt; &lt;td bgcolor="#1369a1" width="45"&gt;&lt;b&gt;AGENCIA&lt;/b&gt;&lt;/td&gt; &lt;td bgcolor="#1369a1" width="45"&gt;&lt;b&gt;CONTA&lt;/b&gt;&lt;/td&gt; &lt;td bgcolor="#1369a1"&gt;&lt;b&gt;VALOR em R$&lt;/b&gt;&lt;/td&gt; &lt;/tr&gt; '.$lista_individual.' &lt;/table&gt; &lt;br&gt; &lt;br&gt; &lt;table width="100%" border="0" cellpadding="1" cellspacing="1" bgcolor="#333333"&gt; &lt;tr&gt; &lt;td bgcolor="#ffffff" height="30" colspan="3" align="center"&gt;&lt;b style="font-size: 16px;"&gt;SUBTOTAL&lt;/b&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr style="color: #ffffff !important;"&gt; &lt;td bgcolor="#1369a1" width="45" height="20"&gt;&lt;b&gt;CHAPA&lt;/b&gt;&lt;/td&gt; &lt;td bgcolor="#1369a1"&gt;&lt;b&gt;NOME&lt;/b&gt;&lt;/td&gt; &lt;td bgcolor="#1369a1" width="130"&gt;&lt;b&gt;SUBTOTAL em R$&lt;/b&gt;&lt;/td&gt; &lt;/tr&gt; '.$lista_subtotal.' &lt;tr&gt; &lt;td bgcolor="#c8e5f7" colspan="2" align="center" height="20"&gt;&lt;b style="font-size: 16px;"&gt;TOTAL&lt;/b&gt;&lt;/td&gt; &lt;td bgcolor="#c8e5f7" width="130"&gt;&lt;b&gt;'.number_format($lista_total,2,',','.').'&lt;/b&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;br&gt; &lt;br&gt; &lt;table width="100%" border="0" cellpadding="1" cellspacing="1" bgcolor="#333333"&gt; &lt;tr&gt; &lt;td bgcolor="#1369a1" width="50%" height="20" align="center" style="color: white; font-size: 12px;"&gt;TOTAL BANCO SANTANDER - 033&lt;/td&gt; &lt;td bgcolor="#1369a1" width="50%" align="center" style="color: white; font-size: 12px;"&gt;TOTAL OUTROS BANCOS&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td bgcolor="#ffffff" height="20" align="center" &gt;&lt;b&gt;'.number_format($tot_santander, 2 , ',', '.').'&lt;/b&gt;&lt;/td&gt; &lt;td bgcolor="#ffffff" align="center"&gt;&lt;b&gt;'.number_format($tot_qualquerbanco, 2 , ',', '.').'&lt;/b&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; '; $dompdf-&gt;load_html(utf8_encode($html)); $dompdf-&gt;render(); $dompdf-&gt;stream( "saida.pdf", array( "Attachment" =&gt; false ) ); </code></pre> <p>Is there a way to optimize time? PDF with few pages works normally but in PDF with many pages DOMPDF returns this error in the browser...</p> <p>I'm trying to search for a solution all over the internet, but none worked. I tried to increase <code>set_time_limit</code> but it did not work either.</p> </div>

TabHost标签切换文字颜色改变问题

各位大神,小弟在做TabHost标签切换事件的时候,实现了标签切换的时候图片背景编号,可是标题的颜色改变不了,获取的title也为null,看了很多资料获取标题是同样的方法,为什么我获取的就是为null,没搞清楚,具体参见代码 ![图片说明](https://img-ask.csdn.net/upload/201707/15/1500083664_61736.png)

DrawerLayout 添加完监听事件 不进onDrawerClosed()和 onDrawerOpened()

import android.support.v4.widget.DrawerLayout; import android.support.v4.app.ActionBarDrawerToggle; public class MainActivity extends Activity{ private DrawerLayout drawer; private ActionBarDrawerToggle toggle; protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.menu); drawer = (DrawerLayout) findViewById(R.id.dra); toggle = new ActionBarDrawerToggle(this, drawer, R.drawable.searchmap, R.string.drawer_open,R.string.drawer_close){ @Override public void onDrawerClosed(View drawerView) { super.onDrawerClosed(drawerView); Log.i("mag", "关闭"); } @Override public void onDrawerOpened(View drawerView) { super.onDrawerOpened(drawerView); Log.i("mag", "打开"); } }; drawer.setDrawerListener(toggle); } }

OPNET卫星网络路由算法仿真

最近要交毕设啦,OPNET的卫星网络路由仿真还不会做,求大神指导啊,真的很着急。算法主要 是收集链路状态信息,比如时延、带宽、丢包率,然后归一化到[0,1],分配权重作为 链路的Cost,然后用Dijkstra算法。 求指导啊,怎么做仿真,呜呜呜~

win10安装centos过程中报错

用u 盘安装centos7,安装过程报错了panic occurred, switching back to text comsole。怎么解决?求救

android setImageDrawable()

try { URL url = new URL(itemObj.iv); // String string = String.valueOf(itemObj.iv); // URL url = new URL(string); Utils.onLoadImage(url, new Utils.OnLoadImageListener() { @Override public void OnLoadImage(Bitmap bitmap, String bitmapPath) { if (bitmap != null) { // themeViewHolder.parallaxImageView.setImageBitmap(bitmap); BitmapDrawable bitmapDrawable = new BitmapDrawable(bitmap); themeViewHolder.parallaxImageView.setImageDrawable(bitmapDrawable); // themeViewHolder.parallaxImageView.setImageDrawable(context.getResources().getDrawable(itemObj.iv)); } } }); } catch (Exception e) { e.printStackTrace(); } 各位大牛,为什么这样不能显示图片

android如何显示专辑图片

我用 Cursor cursor=getContentResolver().query(MediaStore.Audio.Albums.EXTERNAL_CONTENT_URI, null,null, null, null); String pathName=cursor.getString(cursor.getColumnIndex(Audio.Albums.ALBUM_ART)); 找到路径。 然后用Bitmap bm=BitmapFactory.decodeFile(pathName); bm为null。 用Drawable dra=Drawable.createFromPath(pathName); dra也为null

FFmpeg的Decode支持GPU解码吗

最近使用Ffmpeg做视频解码, 发现使用它播放4K视频时,CPU使用率很高。想问下各位大神们,Ffmpeg能使用GPU进行解码吗? 该怎么解码

error LNK2019: 无法解析的外部符号

一共有三个文件一个是头文件 两个cpp。 ``` //a.h #include<iostream> namespace sales { const int quarters = 4; struct Sales { double sales[quarters]; double average; double max; double min; }; void setsales(Sales & s, const double ar[], int n); void setsales(Sales & s); void showsales(const Sales & s); } ``` ``` //1.cpp #include<iostream> #include"a.h" int main() { using namespace sales; Sales s1,s2; double sz[] = { 1,2,3 }; setsales(s1, sz, 3); for (int i = 0; i < 4; i++) { printf("Enter number#%d:", i + 1); std::cin >> s2.sales[i]; } setsales(s2); showsales(s1); showsales(s2); system("pause"); return 0; } ``` ``` ales.cpp #include<iostream> #include<string> #include"a.h" using namespace sales; void setsales(Sales & s, const double ar[], int n) { for(int i=0;i<n;i++) { s.sales[i] = ar[i]; } double sum=0; s.max = s.sales[0]; s.min = s.sales[0]; for (int j = 0; j < n; j++) { s.max = s.max < s.sales[j] ? s.sales[j] : s.max; s.min = s.min < s.sales[j] ? s.sales[j] : s.min; sum += s.sales[j]; } s.average = sum / n; if (n<4) { for (int i = n; i < 4; i++) s.sales[i] = 0; } } void setsales(Sales & s) { double sum = 0; s.max = s.sales[0]; s.min = s.sales[0]; for (int j = 0; j < 4; j++) { s.max = s.max < s.sales[j] ? s.sales[j] : s.max; s.min = s.min < s.sales[j] ? s.sales[j] : s.min; sum += s.sales[j]; } s.average = sum / 4; } void showsales(const Sales & s) { using std::cout; using std::cin; using std::endl; for (int i = 0; i <4; i++) { cout << s.sales[i] << " "; } cout << endl << "AVERAGE:" << s.average<<endl; cout << "MAX:" << s.max << endl; cout << "MIN:" << s.min << endl; } ``` 三个文件都在同一文件夹下,不知为何会报错 1>1.obj : error LNK2019: 无法解析的外部符号 "void __cdecl sales::setsales(struct sales::Sales &,double const * const,int)" (?setsales@sales@@YAXAAUSales@1@QBNH@Z),该符号在函数 _main 中被引用 1>1.obj : error LNK2019: 无法解析的外部符号 "void __cdecl sales::setsales(struct sales::Sales &)" (?setsales@sales@@YAXAAUSales@1@@Z),该符号在函数 _main 中被引用 1>1.obj : error LNK2019: 无法解析的外部符号 "void __cdecl sales::showsales(struct sales::Sales const &)" (?showsales@sales@@YAXABUSales@1@@Z),该符号在函数 _main 中被引用 1>D:\Documents\Visual Studio 2015\Projects\Win32Project4\Debug\Win32Project4.exe : fatal error LNK1120: 3 个无法解析的外部命令

在中国程序员是青春饭吗?

今年,我也32了 ,为了不给大家误导,咨询了猎头、圈内好友,以及年过35岁的几位老程序员……舍了老脸去揭人家伤疤……希望能给大家以帮助,记得帮我点赞哦。 目录: 你以为的人生 一次又一次的伤害 猎头界的真相 如何应对互联网行业的「中年危机」 一、你以为的人生 刚入行时,拿着傲人的工资,想着好好干,以为我们的人生是这样的: 等真到了那一天,你会发现,你的人生很可能是这样的: ...

程序员请照顾好自己,周末病魔差点一套带走我。

程序员在一个周末的时间,得了重病,差点当场去世,还好及时挽救回来了。

和黑客斗争的 6 天!

互联网公司工作,很难避免不和黑客们打交道,我呆过的两家互联网公司,几乎每月每天每分钟都有黑客在公司网站上扫描。有的是寻找 Sql 注入的缺口,有的是寻找线上服务器可能存在的漏洞,大部分都...

搜狗输入法也在挑战国人的智商!

故事总是一个接着一个到来...上周写完《鲁大师已经彻底沦为一款垃圾流氓软件!》这篇文章之后,鲁大师的市场工作人员就找到了我,希望把这篇文章删除掉。经过一番沟通我先把这篇文章从公号中删除了...

总结了 150 余个神奇网站,你不来瞅瞅吗?

原博客再更新,可能就没了,之后将持续更新本篇博客。

副业收入是我做程序媛的3倍,工作外的B面人生是怎样的?

提到“程序员”,多数人脑海里首先想到的大约是:为人木讷、薪水超高、工作枯燥…… 然而,当离开工作岗位,撕去层层标签,脱下“程序员”这身外套,有的人生动又有趣,马上展现出了完全不同的A/B面人生! 不论是简单的爱好,还是正经的副业,他们都干得同样出色。偶尔,还能和程序员的特质结合,产生奇妙的“化学反应”。 @Charlotte:平日素颜示人,周末美妆博主 大家都以为程序媛也个个不修边幅,但我们也许...

MySQL数据库面试题(2020最新版)

文章目录数据库基础知识为什么要使用数据库什么是SQL?什么是MySQL?数据库三大范式是什么mysql有关权限的表都有哪几个MySQL的binlog有有几种录入格式?分别有什么区别?数据类型mysql有哪些数据类型引擎MySQL存储引擎MyISAM与InnoDB区别MyISAM索引与InnoDB索引的区别?InnoDB引擎的4大特性存储引擎选择索引什么是索引?索引有哪些优缺点?索引使用场景(重点)...

如果你是老板,你会不会踢了这样的员工?

有个好朋友ZS,是技术总监,昨天问我:“有一个老下属,跟了我很多年,做事勤勤恳恳,主动性也很好。但随着公司的发展,他的进步速度,跟不上团队的步伐了,有点...

我入职阿里后,才知道原来简历这么写

私下里,有不少读者问我:“二哥,如何才能写出一份专业的技术简历呢?我总感觉自己写的简历太烂了,所以投了无数份,都石沉大海了。”说实话,我自己好多年没有写过简历了,但我认识的一个同行,他在阿里,给我说了一些他当年写简历的方法论,我感觉太牛逼了,实在是忍不住,就分享了出来,希望能够帮助到你。 01、简历的本质 作为简历的撰写者,你必须要搞清楚一点,简历的本质是什么,它就是为了来销售你的价值主张的。往深...

优雅的替换if-else语句

场景 日常开发,if-else语句写的不少吧??当逻辑分支非常多的时候,if-else套了一层又一层,虽然业务功能倒是实现了,但是看起来是真的很不优雅,尤其是对于我这种有强迫症的程序"猿",看到这么多if-else,脑袋瓜子就嗡嗡的,总想着解锁新姿势:干掉过多的if-else!!!本文将介绍三板斧手段: 优先判断条件,条件不满足的,逻辑及时中断返回; 采用策略模式+工厂模式; 结合注解,锦...

离职半年了,老东家又发 offer,回不回?

有小伙伴问松哥这个问题,他在上海某公司,在离职了几个月后,前公司的领导联系到他,希望他能够返聘回去,他很纠结要不要回去? 俗话说好马不吃回头草,但是这个小伙伴既然感到纠结了,我觉得至少说明了两个问题:1.曾经的公司还不错;2.现在的日子也不是很如意。否则应该就不会纠结了。 老实说,松哥之前也有过类似的经历,今天就来和小伙伴们聊聊回头草到底吃不吃。 首先一个基本观点,就是离职了也没必要和老东家弄的苦...

2020阿里全球数学大赛:3万名高手、4道题、2天2夜未交卷

阿里巴巴全球数学竞赛( Alibaba Global Mathematics Competition)由马云发起,由中国科学技术协会、阿里巴巴基金会、阿里巴巴达摩院共同举办。大赛不设报名门槛,全世界爱好数学的人都可参与,不论是否出身数学专业、是否投身数学研究。 2020年阿里巴巴达摩院邀请北京大学、剑桥大学、浙江大学等高校的顶尖数学教师组建了出题组。中科院院士、美国艺术与科学院院士、北京国际数学...

男生更看重女生的身材脸蛋,还是思想?

往往,我们看不进去大段大段的逻辑。深刻的哲理,往往短而精悍,一阵见血。问:产品经理挺漂亮的,有点心动,但不知道合不合得来。男生更看重女生的身材脸蛋,还是...

程序员为什么千万不要瞎努力?

本文作者用对比非常鲜明的两个开发团队的故事,讲解了敏捷开发之道 —— 如果你的团队缺乏统一标准的环境,那么即使勤劳努力,不仅会极其耗时而且成果甚微,使用...

为什么程序员做外包会被瞧不起?

二哥,有个事想询问下您的意见,您觉得应届生值得去外包吗?公司虽然挺大的,中xx,但待遇感觉挺低,马上要报到,挺纠结的。

当HR压你价,说你只值7K,你该怎么回答?

当HR压你价,说你只值7K时,你可以流畅地回答,记住,是流畅,不能犹豫。 礼貌地说:“7K是吗?了解了。嗯~其实我对贵司的面试官印象很好。只不过,现在我的手头上已经有一份11K的offer。来面试,主要也是自己对贵司挺有兴趣的,所以过来看看……”(未完) 这段话主要是陪HR互诈的同时,从公司兴趣,公司职员印象上,都给予对方正面的肯定,既能提升HR的好感度,又能让谈判气氛融洽,为后面的发挥留足空间。...

面试:第十六章:Java中级开发(16k)

HashMap底层实现原理,红黑树,B+树,B树的结构原理 Spring的AOP和IOC是什么?它们常见的使用场景有哪些?Spring事务,事务的属性,传播行为,数据库隔离级别 Spring和SpringMVC,MyBatis以及SpringBoot的注解分别有哪些?SpringMVC的工作原理,SpringBoot框架的优点,MyBatis框架的优点 SpringCould组件有哪些,他们...

面试阿里p7,被按在地上摩擦,鬼知道我经历了什么?

面试阿里p7被问到的问题(当时我只知道第一个):@Conditional是做什么的?@Conditional多个条件是什么逻辑关系?条件判断在什么时候执...

面试了一个 31 岁程序员,让我有所触动,30岁以上的程序员该何去何从?

最近面试了一个31岁8年经验的程序猿,让我有点感慨,大龄程序猿该何去何从。

大三实习生,字节跳动面经分享,已拿Offer

说实话,自己的算法,我一个不会,太难了吧

程序员垃圾简历长什么样?

已经连续五年参加大厂校招、社招的技术面试工作,简历看的不下于万份 这篇文章会用实例告诉你,什么是差的程序员简历! 疫情快要结束了,各个公司也都开始春招了,作为即将红遍大江南北的新晋UP主,那当然要为小伙伴们做点事(手动狗头)。 就在公众号里公开征简历,义务帮大家看,并一一点评。《启舰:春招在即,义务帮大家看看简历吧》 一石激起千层浪,三天收到两百多封简历。 花光了两个星期的所有空闲时...

《Oracle Java SE编程自学与面试指南》最佳学习路线图2020年最新版(进大厂必备)

正确选择比瞎努力更重要!

《Oracle Java SE编程自学与面试指南》最佳学习路线图(2020最新版)

正确选择比瞎努力更重要!

都前后端分离了,咱就别做页面跳转了!统统 JSON 交互

文章目录1. 无状态登录1.1 什么是有状态1.2 什么是无状态1.3 如何实现无状态1.4 各自优缺点2. 登录交互2.1 前后端分离的数据交互2.2 登录成功2.3 登录失败3. 未认证处理方案4. 注销登录 这是本系列的第四篇,有小伙伴找不到之前文章,松哥给大家列一个索引出来: 挖一个大坑,Spring Security 开搞! 松哥手把手带你入门 Spring Security,别再问密...

字节跳动面试官竟然问了我JDBC?

轻松等回家通知

面试官:你连SSO都不懂,就别来面试了

大厂竟然要考我SSO,卧槽。

阿里面试官让我用Zk(Zookeeper)实现分布式锁

他可能没想到,我当场手写出来了

终于,月薪过5万了!

来看几个问题想不想月薪超过5万?想不想进入公司架构组?想不想成为项目组的负责人?想不想成为spring的高手,超越99%的对手?那么本文内容是你必须要掌握的。本文主要详解bean的生命...

自从喜欢上了B站这12个UP主,我越来越觉得自己是个废柴了!

不怕告诉你,我自从喜欢上了这12个UP主,哔哩哔哩成为了我手机上最耗电的软件,几乎每天都会看,可是吧,看的越多,我就越觉得自己是个废柴,唉,老天不公啊,不信你看看…… 间接性踌躇满志,持续性混吃等死,都是因为你们……但是,自己的学习力在慢慢变强,这是不容忽视的,推荐给你们! 都说B站是个宝,可是有人不会挖啊,没事,今天咱挖好的送你一箩筐,首先啊,我在B站上最喜欢看这个家伙的视频了,为啥 ,咱撇...

代码注释如此沙雕,会玩还是你们程序员!

某站后端代码被“开源”,同时刷遍全网的,还有代码里的那些神注释。 我们这才知道,原来程序员个个都是段子手;这么多年来,我们也走过了他们的无数套路… 首先,产品经理,是永远永远吐槽不完的!网友的评论也非常扎心,说看这些代码就像在阅读程序员的日记,每一页都写满了对产品经理的恨。 然后,也要发出直击灵魂的质问:你是尊贵的付费大会员吗? 这不禁让人想起之前某音乐app的穷逼Vip,果然,穷逼在哪里都是...

立即提问
相关内容推荐