string sql = "update view1 set E_Name='@name' where E_ID=@id"; SqlParameter[] para = { new SqlParameter("@name",name), new SqlParameter("@no",id) }; if( database.ExecuteNonQuery(sql, para)>=0) ---------------------------------------------------- public static int ExecuteNonQuery(string sql,SqlParameter[] para) { if (co.State == ConnectionState.Closed) { co.Open(); } SqlCommand com = new SqlCommand(sql); com.Connection = co; com.CommandText = sql; com.Parameters.AddRange(para); int i = com.ExecuteNonQuery(); return i; if (co.State == ConnectionState.Open) { co.Close(); co.Dispose(); } 为什么会出现必须声明标量变量 "@id"

using Model; using System; using System.Collections.Generic; using System.Data.SqlClient; using System.Linq; using System.Text; using System.Threading.Tasks; using Utility; namespace DAL { public class CommodityDAL { public bool EditCM(CommodityModel cm) { string sql = @"insert into Commodity(CommodityName, SortID, CommodityPrice, IsDiscount, ReducedPrice) values(@Name,@ID,@Price,@Discount,@RPrice)"; SqlParameter[] ps = { new SqlParameter("@Name",cm.CommodityName), new SqlParameter("@ID",cm.SortID), new SqlParameter("@Price",cm.CommodityPrice), new SqlParameter("@Discount",cm.IsDiscount), new SqlParameter("@RPrice",cm.ReducePrice) }; return SqlHelper.ExecuteNonQuery(sql) > 0; } } } 发生异常： “System.Data.SqlClient.SqlException”类型的未经处理的异常在 System.Data.dll 中发生 其他信息: 必须声明标量变量 "@Name"。 请问给位大神,这是怎么回事？断点查看 cm.CommodityName cm.SortID cm.CommodityPrice cm.IsDiscount cm.ReducePrice 都有相应的值！ 为什么就传不进去呢？

源码如下： Dao层 SqlHelper.cs： public class SqlHelper { public static int ExecuteNonQuery(string sql, params SqlParameter[] parameters) { String connStr = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString; SqlConnection conn = new SqlConnection(connStr); conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = sql; foreach (SqlParameter parameter in parameters) { cmd.Parameters.Add(parameter); } return cmd.ExecuteNonQuery(); } } 服务层 Service.cs ： public static int dataUpdate(int i,params Object[] o) { String strsql = "Update Device set TName = @TName Where Id = @Id "; SqlHelper.ExecuteNonQuery(strsql, new SqlParameter("@Id", i), new SqlParameter("@TName", o[0])); int result = SqlHelper.ExecuteNonQuery(strsql); return result; } 主窗体按钮： private void btnUpdate_Click(object sender, EventArgs e) { MessageBox.Show(pdtp.Value.ToString("yyyy/MM/dd")); Service.dataUpdate( Convert.ToInt32(textBox1.Text), NameText.Text ); } 服务层的内容使用Insert就没问题，为什么update就报错了？

StringBuilder strSql = new StringBuilder(); strSql.Append("insert into strImage (strClientCode,images,dateTM) "); strSql.Append(" values ( "); strSql.Append("@strClientCode,@images,@dateTM)"); SqlParameter[] paramers ={ new SqlParameter("@strClientCode",SqlDbType.VarChar,30), new SqlParameter("@images",SqlDbType.Image, 16), new SqlParameter("@dateTM",SqlDbType.DateTime) }; paramers[0].Value = strClientCode; paramers[1].Value =bytes; paramers[2].Value = DateTime.Now; pbClass.ExecuteNonQuery(strSql.ToString());

https://msdn.microsoft.com/zh-cn/library/vstudio/system.data.sqlclient.sqlparameter(v=vs.100).aspx 里备注说参数名称不区分大小写。 但我代码里，如果sql语句有@cid，参数名称是@CID，提示都是必须声明标量变量。

<div class="post-text" itemprop="text"> <p>so i'm trying in <code>PHP</code> to insert new members into a sql database with <code>sqlsrv</code>. we had a facebook login working BUT that now also doesn't work anymore as the query reaches the database, executes it and returns </p> <blockquote> <p>"Must declare the scalar variable "@P1"</p> </blockquote> <pre><code>$NewMemberRegisterSQL = "INSERT INTO dbo.members (MemberName, MemberPassword, MemberEmail) VALUES(?,?,?)"; $paramsNewMember = array($_POST['register-username'], $hashedPass, $_POST['register-email']); $InsertResult = sqlsrv_query( $conn, $NewMemberRegisterSQL, $paramsNewMember); </code></pre> <p>The Database exists of <code>MemberID</code> which is an auto increment, <code>FacebookID</code> which is allowed to be <code>null</code>,<code>MemberName</code> which is just the <code>username</code>,<code>MemberPassword</code> well guess what this one is, and <code>Memberemail</code>. <code>FacebookID</code>,<code>Memberpassword</code> and <code>memberemail</code> are allowed to be <code>NULL</code>.</p> </div>

本机数据库版本为2012，执行存储过程成功，放到服务器执行（版本为2005），运行报错，代码入下： ALTER proc [dbo].[proc_DingDan] @newNumber varchar(18) output as declare @maxNumber varchar(18) select @maxNumber=MAX(orderno) from [dbo].[Orders] where SUBSTRING(OrderNo,0,9) = convert(varchar(18),getdate(),112) declare @time varchar(20)=SUBSTRING(replace(replace(replace(convert(varchar,getdate(),120),'-',''),' ',''),':',''),0,13) if(@maxNumber is null) begin set @newNumber=@time+'000001' end else begin declare @haoma varchar(18) set @haoma= right('00000'+Convert(varchar(6),right(@maxNumber,6)+1),6) set @newNumber=@time+@haoma end print @newNumber 放服务器运行报错，错误代码如下： 消息 139，级别 15，状态 1，过程 proc_DingDan，第 0 行 不能向局部变量赋予默认值。 消息 137，级别 15，状态 2，过程 proc_DingDan，第 9 行 必须声明标量变量 "@time"。 消息 137，级别 15，状态 2，过程 proc_DingDan，第 16 行 必须声明标量变量 "@time"。 求高手相助http://ask.csdn.net/my#

sql查询语句 ，其中 realPrice 是别名 ``` @Query(value = "select *,case when db.order_type_code = 'Db2bOrder' then d.RealTotal else df.TotalMoney end realPrice from db2border_bill_detail db " + "left join db2border d on d.fID =db.source_id " + "left join db2brefund df on df.OrderID = db.source_id where db.group_id = ?1 and db.db2border_bill_id = ?2", nativeQuery = true) List<Db2BorderBillDetail> findAllByGroupIdAndDb2BorderBillId(String groupId,Long Id); ``` 在Db2BorderBillDetail实体类增加对应字段，这样查询正常 ，返回的realPrice的字段有值 ，但是发现保存报错 提示“Unknown column 'db2borderb0_.realPrice' in 'field list'” ``` @Transient() private BigDecimal realPrice; public BigDecimal getRealPrice() { return realPrice; } public void setRealPrice(BigDecimal realPrice) { this.realPrice = realPrice; } ``` 改成这样 则保存正常，但是sql查询的值就为null ``` private BigDecimal realPrice; @Transient() public BigDecimal getRealPrice() { return realPrice; } public void setRealPrice(BigDecimal realPrice) { this.realPrice = realPrice; } ``` 求大神赐教下，怎么才能查询保存都正常

<div class="post-text" itemprop="text"> <p>I'm learning Go but I feel it is a bit annoying that when compiling, I should not leave any variable or package unused. </p> <p>This is really quite slowing me down. For example, I just wanted to declare a new package and plan to use it later or just uncomment some command to test. I always get the error and need to go comment all of those uses.</p> <p>Is there any way to avoid this kind of check in Go? </p> </div> <p>转载于:https://stackoverflow.com/questions/21743841/how-to-avoid-annoying-error-declared-and-not-used</p>

<div class="post-text" itemprop="text"> <p>I would like to provide my controller object like this with hinclude.js :</p> <pre><code>{{ render_hinclude(controller("AppBundle:Default:Test"), { 'object': my_object }) }} </code></pre> <p>Unfortunately I got this error: </p> <blockquote> <p>"An exception has been thrown during the rendering of a template (\"Controller attributes cannot contain non-scalar/non-null values (value for key \"my_object\" is not a scalar or null).\")</p> </blockquote> <p>Can you help me ?</p> <p>Thanks in advance !</p> </div>

# -*- coding: utf-8 -*- # Form implementation generated from reading ui file 'C:\Users\yantao\PycharmProjects\untitled14\venv\untitled.ui' # # Created by: PyQt5 UI code generator 5.12 # # WARNING! All changes made in this file will be lost! from PyQt5 import QtCore, QtGui, QtWidgets class Ui_mainWindow(object): def setupUi(self, mainWindow): mainWindow.setObjectName("mainWindow") mainWindow.resize(796, 598) self.centralwidget = QtWidgets.QWidget(mainWindow) self.centralwidget.setObjectName("centralwidget") self.listView = QtWidgets.QListView(self.centralwidget) self.listView.setGeometry(QtCore.QRect(290, 300, 481, 192)) self.listView.setObjectName("listView") self.label = QtWidgets.QLabel(self.centralwidget) self.label.setGeometry(QtCore.QRect(290, 280, 91, 16)) self.label.setObjectName("label") self.label_2 = QtWidgets.QLabel(self.centralwidget) self.label_2.setGeometry(QtCore.QRect(10, 100, 54, 12)) self.label_2.setObjectName("label_2") self.label_3 = QtWidgets.QLabel(self.centralwidget) self.label_3.setGeometry(QtCore.QRect(10, 140, 54, 12)) self.label_3.setObjectName("label_3") self.textBrowser = QtWidgets.QTextBrowser(self.centralwidget) self.textBrowser.setGeometry(QtCore.QRect(70, 90, 81, 31)) self.textBrowser.setObjectName("textBrowser") self.textBrowser_2 = QtWidgets.QTextBrowser(self.centralwidget) self.textBrowser_2.setGeometry(QtCore.QRect(70, 130, 81, 31)) self.textBrowser_2.setObjectName("textBrowser_2") self.pushButton = QtWidgets.QPushButton(self.centralwidget) self.pushButton.setGeometry(QtCore.QRect(290, 510, 91, 41)) self.pushButton.setObjectName("pushButton") self.pushButton_2 = QtWidgets.QPushButton(self.centralwidget) self.pushButton_2.setGeometry(QtCore.QRect(20, 290, 75, 23)) self.pushButton_2.setObjectName("pushButton_2") self.pushButton_3 = QtWidgets.QPushButton(self.centralwidget) self.pushButton_3.setGeometry(QtCore.QRect(20, 490, 75, 23)) self.pushButton_3.setObjectName("pushButton_3") self.openGLWidget = QtWidgets.QOpenGLWidget(self.centralwidget) self.openGLWidget.setGeometry(QtCore.QRect(290, -10, 471, 281)) self.openGLWidget.setObjectName("openGLWidget") self.pushButton_4 = QtWidgets.QPushButton(self.centralwidget) self.pushButton_4.setGeometry(QtCore.QRect(210, 110, 75, 23)) self.pushButton_4.setObjectName("pushButton_4") self.radioButton = QtWidgets.QRadioButton(self.centralwidget) self.radioButton.setGeometry(QtCore.QRect(10, 50, 125, 16)) self.radioButton.setObjectName("radioButton") self.radioButton_2 = QtWidgets.QRadioButton(self.centralwidget) self.radioButton_2.setGeometry(QtCore.QRect(10, 20, 119, 16)) self.radioButton_2.setObjectName("radioButton_2") self.horizontalSlider = QtWidgets.QSlider(self.centralwidget) self.horizontalSlider.setGeometry(QtCore.QRect(120, 390, 141, 22)) self.horizontalSlider.setOrientation(QtCore.Qt.Horizontal) self.horizontalSlider.setObjectName("horizontalSlider") self.label_4 = QtWidgets.QLabel(self.centralwidget) self.label_4.setGeometry(QtCore.QRect(30, 380, 41, 31)) self.label_4.setObjectName("label_4") mainWindow.setCentralWidget(self.centralwidget) self.menubar = QtWidgets.QMenuBar(mainWindow) self.menubar.setGeometry(QtCore.QRect(0, 0, 796, 23)) self.menubar.setObjectName("menubar") self.menufile = QtWidgets.QMenu(self.menubar) self.menufile.setObjectName("menufile") self.menu_2 = QtWidgets.QMenu(self.menubar) self.menu_2.setObjectName("menu_2") self.menu_3 = QtWidgets.QMenu(self.menubar) self.menu_3.setObjectName("menu_3") self.menu_4 = QtWidgets.QMenu(self.menubar) self.menu_4.setObjectName("menu_4") self.menu_5 = QtWidgets.QMenu(self.menubar) self.menu_5.setObjectName("menu_5") mainWindow.setMenuBar(self.menubar) self.statusbar = QtWidgets.QStatusBar(mainWindow) self.statusbar.setObjectName("statusbar") mainWindow.setStatusBar(self.statusbar) self.actionopen = QtWidgets.QAction(mainWindow) self.actionopen.setObjectName("actionopen") self.actionExit = QtWidgets.QAction(mainWindow) self.actionExit.setObjectName("actionExit") self.action_7 = QtWidgets.QAction(mainWindow) self.action_7.setObjectName("action_7") self.action_8 = QtWidgets.QAction(mainWindow) self.action_8.setObjectName("action_8") self.action_10 = QtWidgets.QAction(mainWindow) self.action_10.setObjectName("action_10") self.menufile.addAction(self.actionopen) self.menufile.addAction(self.action_7) self.menufile.addAction(self.action_8) self.menufile.addSeparator() self.menufile.addAction(self.action_10) self.menubar.addAction(self.menufile.menuAction()) self.menubar.addAction(self.menu_2.menuAction()) self.menubar.addAction(self.menu_3.menuAction()) self.menubar.addAction(self.menu_4.menuAction()) self.menubar.addAction(self.menu_5.menuAction()) self.retranslateUi(mainWindow) QtCore.QMetaObject.connectSlotsByName(mainWindow) def retranslateUi(self, mainWindow): _translate = QtCore.QCoreApplication.translate mainWindow.setWindowTitle(_translate("mainWindow", "三维可视化")) self.label.setText(_translate("mainWindow", "Action Logs")) self.label_2.setText(_translate("mainWindow", "组织数：")) self.label_3.setText(_translate("mainWindow", "组织数：")) self.pushButton.setText(_translate("mainWindow", "显示函数值")) self.pushButton_2.setText(_translate("mainWindow", "上色")) self.pushButton_3.setText(_translate("mainWindow", "去色")) self.pushButton_4.setText(_translate("mainWindow", "输出画面")) self.radioButton.setText(_translate("mainWindow", "面绘制")) self.radioButton_2.setText(_translate("mainWindow", "体绘制")) self.label_4.setText(_translate("mainWindow", "透明度：")) self.menufile.setTitle(_translate("mainWindow", "文件")) self.menu_2.setTitle(_translate("mainWindow", "编辑")) self.menu_3.setTitle(_translate("mainWindow", "格式")) self.menu_4.setTitle(_translate("mainWindow", "查看")) self.menu_5.setTitle(_translate("mainWindow", "帮助")) self.actionopen.setText(_translate("mainWindow", "打开")) self.actionExit.setText(_translate("mainWindow", "Exit")) self.action_7.setText(_translate("mainWindow", "保存")) self.action_8.setText(_translate("mainWindow", "另存为")) self.action_10.setText(_translate("mainWindow", "退出")) if __name__ == "__main__": import sys app = QtWidgets.QApplication(sys.argv) mainWindow = QtWidgets.QMainWindow() ui = Ui_mainWindow() ui.setupUi(mainWindow) mainWindow.show() sys.exit(app.exec_())  ``` 功能一体绘制 ```import vtk from vtk.util.misc import vtkGetDataRoot # Create the renderer, the render window, and the interactor. The renderer # draws into the render window, the interactor enables mouse- and # keyboard-based interaction with the scene. ren = vtk.vtkRenderer() renWin = vtk.vtkRenderWindow() renWin.AddRenderer(ren) iren = vtk.vtkRenderWindowInteractor() iren.SetRenderWindow(renWin) # The following reader is used to read a series of 2D slices (images) # that compose the volume. The slice dimensions are set, and the # pixel spacing. The data Endianness must also be specified. The reader # usese the FilePrefix in combination with the slice number to construct # filenames using the format FilePrefix.%d. (In this case the FilePrefix # is the root name of the file: quarter.) # v16 = vtk.vtkVolume16Reader() # v16.SetDataDimensions(64, 64) # v16.SetImageRange(1, 93) # v16.SetDataByteOrderToLittleEndian() # v16.SetFilePrefix("D:/dicom_image/headsq/quarter") # v16.SetDataSpacing(3.2, 3.2, 1.5) v16 = vtk.vtkDICOMImageReader() # v16.SetDirectoryName('D:/dicom_image/vtkDicomRender-master/sample') v16.SetDirectoryName('C:\\Users\\yantao\\PycharmProjects\\untitled14\\Examples\\CT') # The volume will be displayed by ray-cast alpha compositing. # A ray-cast mapper is needed to do the ray-casting, and a # compositing function is needed to do the compositing along the ray. volumeMapper = vtk.vtkGPUVolumeRayCastMapper() volumeMapper.SetInputConnection(v16.GetOutputPort()) volumeMapper.SetBlendModeToComposite() # The color transfer function maps voxel intensities to colors. # It is modality-specific, and often anatomy-specific as well. # The goal is to one color for flesh (between 500 and 1000) # and another color for bone (1150 and over). volumeColor = vtk.vtkColorTransferFunction() volumeColor.AddRGBPoint(0, 0.0, 0.0, 0.0) volumeColor.AddRGBPoint(500, 1.0, 0.5, 0.3) volumeColor.AddRGBPoint(1000, 1.0, 0.5, 0.3) volumeColor.AddRGBPoint(1150, 1.0, 1.0, 0.9) # The opacity transfer function is used to control the opacity # of different tissue types. volumeScalarOpacity = vtk.vtkPiecewiseFunction() volumeScalarOpacity.AddPoint(0, 0.00) volumeScalarOpacity.AddPoint(500, 0.15) volumeScalarOpacity.AddPoint(1000, 0.15) volumeScalarOpacity.AddPoint(1150, 0.85) # The gradient opacity function is used to decrease the opacity # in the "flat" regions of the volume while maintaining the opacity # at the boundaries between tissue types. The gradient is measured # as the amount by which the intensity changes over unit distance. # For most medical data, the unit distance is 1mm. volumeGradientOpacity = vtk.vtkPiecewiseFunction() volumeGradientOpacity.AddPoint(0, 0.0) volumeGradientOpacity.AddPoint(90, 0.5) volumeGradientOpacity.AddPoint(100, 1.0) # The VolumeProperty attaches the color and opacity functions to the # volume, and sets other volume properties. The interpolation should # be set to linear to do a high-quality rendering. The ShadeOn option # turns on directional lighting, which will usually enhance the # appearance of the volume and make it look more "3D". However, # the quality of the shading depends on how accurately the gradient # of the volume can be calculated, and for noisy data the gradient # estimation will be very poor. The impact of the shading can be # decreased by increasing the Ambient coefficient while decreasing # the Diffuse and Specular coefficient. To increase the impact # of shading, decrease the Ambient and increase the Diffuse and Specular. volumeProperty = vtk.vtkVolumeProperty() volumeProperty.SetColor(volumeColor) volumeProperty.SetScalarOpacity(volumeScalarOpacity) # volumeProperty.SetGradientOpacity(volumeGradientOpacity) volumeProperty.SetInterpolationTypeToLinear() volumeProperty.ShadeOn() volumeProperty.SetAmbient(0.9) volumeProperty.SetDiffuse(0.9) volumeProperty.SetSpecular(0.9) # The vtkVolume is a vtkProp3D (like a vtkActor) and controls the position # and orientation of the volume in world coordinates. volume = vtk.vtkVolume() volume.SetMapper(volumeMapper) volume.SetProperty(volumeProperty) # Finally, add the volume to the renderer ren.AddViewProp(volume) # Set up an initial view of the volume. The focal point will be the # center of the volume, and the camera position will be 400mm to the # patient's left (which is our right). camera = ren.GetActiveCamera() c = volume.GetCenter() camera.SetFocalPoint(c[0], c[1], c[2]) camera.SetPosition(c[0] + 400, c[1], c[2]) camera.SetViewUp(0, 0, -1) # Increase the size of the render window renWin.SetSize(640, 480) # Interact with the data. iren.Initialize() renWin.Render() iren.Start() 功能二面绘制 # 抽取轮廓(等值面)的操作对象是标量数据。mianhuizhi2 import vtk # source—filter——mapper——actor——render——renderwindow——interactor aRenderer = vtk.vtkRenderer() # 渲染器 renWin = vtk.vtkRenderWindow() # 渲染窗口,创建窗口 renWin.AddRenderer(aRenderer) # 渲染窗口 # renWin.Render() iren = vtk.vtkRenderWindowInteractor() # 窗口交互 iren.SetRenderWindow(renWin) # The following reader is used to read a series of 2D slices(images) # that compose the volume.Theslicedimensions are set, and the # pixel spacing.The data Endianness must also be specified.The reader # uses the FilePrefix in combination with the slice number to construct # filenames using the format FilePrefix. % d.(In this case the FilePrefix # is the root name of the file. v16 = vtk.vtkDICOMImageReader() # v16.SetDirectoryName('D:/dicom_image/V') v16.SetDirectoryName('C:\\Users\\yantao\\PycharmProjects\\untitled14\\Examples\\CT') # An isosurface, or contour value of 500 is known to correspond to the # skin of the patient.Once generated, a vtkPolyDataNormals filter is # used to create normals for smooth surface shading during rendering. skinExtractor = vtk.vtkContourFilter() skinExtractor.SetInputConnection(v16.GetOutputPort()) skinExtractor.SetValue(0, -10) # skinExtractor.GenerateValues(2, 100, 110) skinNormals = vtk.vtkPolyDataNormals() skinNormals.SetInputConnection(skinExtractor.GetOutputPort()) skinNormals.SetFeatureAngle(60.0) skinMapper = vtk.vtkPolyDataMapper() # 映射器 skinMapper.SetInputConnection(skinNormals.GetOutputPort()) skinMapper.ScalarVisibilityOff() skin = vtk.vtkActor() # 设置颜色RGB颜色系统就是由三个颜色分量：红色(R)、绿色(G)和蓝色(B)的组合表示， # 在VTK里这三个分量的取值都是从0到1，(0, 0, 0)表示黑色，(1, 1, 1)表示白色。 # vtkProperty::SetColor(r,g, b)采用的就是RGB颜色系统设置颜色属性值。 #skin.GetProperty().SetColor(0, 0, 1) skin.SetMapper(skinMapper) skin.GetProperty().SetDiffuseColor(1, .49, .25) skin.GetProperty().SetSpecular(.5) skin.GetProperty().SetSpecularPower(20) # skin.GetProperty().SetRepresentationToSurface() # 构建图形的方框 outlineData = vtk.vtkOutlineFilter() outlineData.SetInputConnection(v16.GetOutputPort()) mapOutline = vtk.vtkPolyDataMapper() mapOutline.SetInputConnection(outlineData.GetOutputPort()) outline = vtk.vtkActor() outline.SetMapper(mapOutline) outline.GetProperty().SetColor(0, 0, 0) # 构建舞台的相机 aCamera = vtk.vtkCamera() aCamera.SetViewUp(0, 0, -1) aCamera.SetPosition(0, 1, 0) aCamera.SetFocalPoint(0, 0, 0) aCamera.ComputeViewPlaneNormal() # Actors are added to the renderer.An initial camera view is created. # The Dolly() method moves the camera towards the Focal　Point, # thereby enlarging the image. aRenderer.AddActor(outline) aRenderer.AddActor(skin) aRenderer.SetActiveCamera(aCamera) # 将相机的焦点移动至中央，The camera will reposition itself to view the center point of the actors, # and move along its initial view plane normal aRenderer.ResetCamera() # aCamera.Dolly(1.5) # aCamera.Roll(180) # aCamera.Yaw(60) aRenderer.SetBackground(250, 250, 250) # renWin.SetSize(640, 480) # 该方法是从vtkRenderWindow的父类vtkWindow继承过来的，用于设置窗口的大小，以像素为单位。 renWin.SetSize(500, 500) aRenderer.ResetCameraClippingRange() style = vtk.vtkInteractorStyleTrackballCamera() iren.SetInteractorStyle(style) iren.Initialize() iren.Start() ``` ```

<div class="post-text" itemprop="text"> <p>Ok where to start, I will try and explain as much as I can.</p> <p>I am using wordpress with contact form 7 and I am trying to populate 3 dropdown items on the contact form, I found some code that I was able to use with no problem but the problem with this was that it was getting the information from a excel file, the file is now to big and will not run on my website anymore so I would like to get the information from my database now.</p> <p>I have made a table in my database "vehicle_information" with 3 columns "vehicle_type", "vehicle_make", vehicle_model"</p> <p>I have code in my functions.php and code in my footer to be able to use the cf7 shortcodes.</p> <p>Code from funtions.php</p> <pre><code>function ajax_cf7_populate_values() { //MySQLi information $db_host = '***'; $db_username = '***'; $db_password = '***'; $vehicles_makes_models = array(); //connect to mysqli database (Host/Username/Password) $connection = mysqli_connect($db_host, $db_username, $db_password) or die('Error ' . mysqli_error()); //select MySQLi dabatase table $vehicles_makes_models = mysqli_select_db($connection, 'vehicle_information') or die('Error ' . mysqli_error()); $sql = mysqli_query($connection, 'SELECT * FROM vehicle_type'); while($row = mysqli_fetch_array($sql)) { $vehicles_makes_models[$row[0]][$row[1]][] = $row[2]; } } // setup the initial array that will be returned to the the client side script as a JSON object. $return_array = array( 'vehicles' =&gt; array_keys($vehicles_makes_models), 'makes' =&gt; array(), 'models' =&gt; array(), 'current_vehicle' =&gt; false, 'current_make' =&gt; false ); // collect the posted values from the submitted form $vehicle = key_exists('vehicle', $_POST) ? $_POST['vehicle'] : false; $make = key_exists('make', $_POST) ? $_POST['make'] : false; $model = key_exists('model', $_POST) ? $_POST['model'] : false; // populate the $return_array with the necessary values if ($vehicle) { $return_array['current_vehicle'] = $vehicle; $return_array['makes'] = array_keys($vehicles_makes_models[$vehicle]); if ($make) { $return_array['current_make'] = $make; $return_array['models'] = $vehicles_makes_models[$vehicle][$make]; if ($model) { $return_array['current_model'] = $model; } } } // encode the $return_array as a JSON object and echo it echo json_encode($return_array); wp_die(); // These action hooks are needed to tell WordPress that the cf7_populate_values() function needs to be called // if a script is POSTing the action : 'cf7_populate_values' add_action( 'wp_ajax_cf7_populate_values', 'ajax_cf7_populate_values' ); add_action( 'wp_ajax_nopriv_cf7_populate_values', 'ajax_cf7_populate_values' ); </code></pre> <p>Code from my footer</p> <pre><code>&lt;script&gt; (function($) { // create references to the 3 dropdown fields for later use. var $vehicles_dd = $('[name="vehicles"]'); var $makes_dd = $('[name="makes"]'); var $models_dd = $('[name="models"]'); // run the populate_fields function, and additionally run it every time a value changes populate_fields(); $('select').change(function() { populate_fields(); }); function populate_fields() { var data = { // action needs to match the action hook part after wp_ajax_nopriv_ and wp_ajax_ in the server side script. 'action' : 'cf7_populate_values', // pass all the currently selected values to the server side script. 'vehicle' : $vehicles_dd.val(), 'make' : $makes_dd.val(), 'model' : $models_dd.val() }; // call the server side script, and on completion, update all dropdown lists with the received values. $.post('&lt;?php echo admin_url( 'admin-ajax.php' ) ?&gt;', data, function(response) { all_values = response; $vehicles_dd.html('').append($('&lt;option&gt;').text(' -- choose vehicle -- ')); $makes_dd.html('').append($('&lt;option&gt;').text(' -- choose make -- ')); $models_dd.html('').append($('&lt;option&gt;').text(' -- choose model -- ')); $.each(all_values.vehicles, function() { $option = $("&lt;option&gt;").text(this).val(this); if (all_values.current_vehicle == this) { $option.attr('selected','selected'); } $vehicles_dd.append($option); }); $.each(all_values.makes, function() { $option = $("&lt;option&gt;").text(this).val(this); if (all_values.current_make == this) { $option.attr('selected','selected'); } $makes_dd.append($option); }); $.each(all_values.models, function() { $option = $("&lt;option&gt;").text(this).val(this); if (all_values.current_model == this) { $option.attr('selected','selected'); } $models_dd.append($option); }); },'json'); } })( jQuery ); </code></pre> <p></p> <p>The problem is I am still learning and this is the first time I have had to use this funtion.</p> <p>and I am getting an error on my website </p> <blockquote> <p>Warning: array_keys() expects parameter 1 to be array, null given in /customers/4/0/0/motobid.co.uk/httpd.www/wp-content/themes/storevilla-child/functions.php on line 38 {"vehicles":null,"makes":[],"models":[],"current_vehicle":false,"current_make":false} </p> </blockquote> <p>any help would be very greatful.</p> <p>Just like to say code was supplied by BDMW.</p> </div>

SQL 语句： insert into dbo.T117_F33 (ID,F1,F2,F3,F4) select xmspmx.ID,xmspmx.F1,xmspmx.F2,xmspmx.F3,xmspmx.F4 from dbo.T111_F34 as xmspmx where T117_F33.T117_ID = xmspmx.T111_ID 报错： 消息 4104，级别 16，状态 1，第 1 行 无法绑定由多个部分组成的标识符 "T117_F33.T117_ID"。

1 报错 extract_brodatz 错误使用 fopen 文件标识符必须为双精度类型的整数值标量。 出错 loadimg (line 9) fid = fopen(fn,'r'); 出错 extract_brodatz (line 37) texture = loadimg(filename,sz); 2代码 ``` function data = loadimg(fn,sz) if nargin == 1 sz = [128 128]; end; SZ = [sz sz]; fid = fopen(fn,'r'); data = fread(fid,SZ,'uchar')'; fclose(fid); ``` ``` filename = extractName(fn(i,:)); texture = loadimg(filename,sz); ```

怎么将i插入到[]中，使得div[i]、li[i]随i增加而变化。 ``` for i in range(0,4): web.find_element_by_xpath('//*[@class="inner"]/div[1]').click() time.sleep(1.5) web.find_element_by_xpath('//*[@class="el-scrollbar"]/div/ul/li[1]').click() time.sleep(1.5) ```

<div class="post-text" itemprop="text"> <p>I have this below code with three different conditions:</p> <ol> <li><p><code>"$json-&gt;clientip":["10.78.58.1", "10.75.22.12"]</code> if the clientip is an array</p></li> <li><p><code>"$json-&gt;clientip":"10.74.10.1, 10.75.10.132, 10.75.10.152"</code> if clientip is a string separated by comma</p></li> <li><p><code>"$json-&gt;clientip":"10.74.10.1, "</code> if clientip is a string with Single value</p></li> </ol> <p>All the three cases is returning an array.</p> <p>However when i am trying below condition: </p> <pre><code>"$json-&gt;clientip":"" </code></pre> <p>it is returning me an array of size 1 but i want an array of size of 0 if there is no data. Can someone please help me with the logic or code, how can i do that</p> <p></p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false"> <div class="snippet-code"> <pre class="snippet-code-html lang-html prettyprint-override"><code> switch (true) { case is_array($json-&gt;clientip): // Ips sent as a JSON array case .. // ... foreach ($json-&gt;clientip as $key =&gt; $ipValue) { $requestObj-&gt;clientip[] = (Utils::validatePattern(Utils::REGEXP_SECLOGS_IP, ((trim($ipValue)) ?? FALSE) )) ? trim($ipValue):NULL; } break; default: if (strpos($json-&gt;clientip, ',')) { // Comma separated IPs case ... // .. $tmp = explode(',', $json-&gt;clientip); foreach ($tmp as $key =&gt; $ipValue) { if (trim($ipValue) != '') $requestObj-&gt;clientip[] = (Utils::validatePattern(Utils::REGEXP_SECLOGS_IP, ((trim($ipValue)) ?? FALSE) )) ? trim($ipValue):NULL; } } else { // Single value case .. // ... $requestObj-&gt;clientip[] = trim($json-&gt;clientip); } } var_dump($requestObj-&gt;clientip);die;</code></pre> </div> </div> </div>

``` using System; using System.Collections.Generic; using System.Data.SqlClient; using System.Linq; using System.Text; using System.Threading.Tasks; using Dapper; namespace Hydrogis_API { class LoginDB { public static ResponseStatus UserLogin(UserInfo userInfo) { SqlConnection conn = new SqlConnection("server=xxx.xxx.xx.xxx,8033;database=Hydrology;uid=sa;pwd=123@abcd;"); try { conn.Open(); //验证用户名密码 string sql = "select * from Y where YM=@YM"; UserInfo user = conn.Query<UserInfo>(sql).First(); if (user.YMM == userInfo.YMM) { return new ResponseStatus() { Code = 1, Desc = "登陆成功" }; } else { return new ResponseStatus() { Code = 0, Desc = "登陆错误，请重新输入用户名以及密码" }; } } catch (Exception ex) { return new ResponseStatus() { Code = 0, Desc = "数据库错误，登录失败！" }; } finally { conn.Close(); } } } } ``` 就是想弄一个用户验证，然后异常显示@YM是未声明的标量变量，求教该怎么写

``` sql = "update news set columnID=@columnID, title=@title,content=@content,description=@description,display=@display,Home=@Home,Recommand=@Recommand,ImageURL=@ImageURL,MainImage=@MainImage,addDate=@addDate,RuZhiDate=@RuZhiDate,FaBuDate=@FaBuDate,Remark1=@Remark1,Remark2=@Remark2,Remark3=@Remark3,Remark4=@Remark4,Remark6=@Remark6,Remark5=@Remark5,Remark7=@Remark7 where ID=@ID"; ``` 这是一条sql语句 接着我用SqlParameter全部赋值 但是运行时总报错（必须声明标量变量@Remark6） ``` arrop[0] = new SqlParameter("@columnID", Convert.ToInt32(strddlist1)); arrop[1] = new SqlParameter("@title", strtitleName); arrop[2] = new SqlParameter("@content", strcontent); arrop[3] = new SqlParameter("@description", strdesc); arrop[4] = new SqlParameter("@display", strdisplay); arrop[5] = new SqlParameter("@Home", strHome); arrop[6] = new SqlParameter("@Recommand", strRecommand); arrop[7] = new SqlParameter("@ImageURL", newName); arrop[8] = new SqlParameter("@MainImage", newName1); arrop[9] = new SqlParameter("@addDate", Convert.ToDateTime(strAddDate)); arrop[10] = new SqlParameter("@RuZhiDate",Convert.ToDateTime(datePX.Text)); arrop[11] = new SqlParameter("@Remark1", newName2); arrop[12] = new SqlParameter("@Remark2", remark2); arrop[13] = new SqlParameter("@Remark3", newName3); arrop[14] = new SqlParameter("@Remark4", newName4); arrop[15] = new SqlParameter("@FaBuDate", DateTime.Now); arrop[16] = new SqlParameter("@Remark6", newName6);//没有声明Remark6 arrop[17] = new SqlParameter("@Remark5", Remark5.Text); arrop[18] = new SqlParameter("@Remark7", newName7); ```

这个代码本来是只有二维图，想用mesh生成一个三维图，请问该如何修改? 加了mesh总是报错 错误使用 mesh (line 75) Z 必须为矩阵，不能是标量或矢量。 ``` clc; clear; f = 750;%单频信号的频率 fsample = 50*f;%采样频率 dlts = 1/fsample;%采样周期 dd = 1;%阵元间距 cc=1500;%声速 dsita=2/360*pi;%扫描角度间隔 beam_no=2*pi/dsita;%波束个数 m=8;%阵元个数 dltc=cc*dlts;%一个采样周期声波传播的距离 t = 0.005:dlts:0.056; n = length(t); bn=round(dd/dltc); ks=n-floor(m/2)*2*bn-1; ss=zeros(beam_no,ks); theta =45; %单频信号 xx(1,:) = cos (2*pi*f.*t); xx(2,:) = cos(2*pi*f.*(t - 3*dd*cos(theta*pi/180)/cc)); xx(3,:) = cos(2*pi*f.*(t + 3*dd*sin(theta*pi/180)/cc)); xx(4,:) = cos(2*pi*f.*(t + 3*dd*cos(theta*pi/180)/cc)); xx(5,:) = cos(2*pi*f.*(t - 3*dd*sin(theta*pi/180)/cc)); xx(6,:) = cos(2*pi*f.*(t - dd*cos(theta*pi/180)/cc)); xx(7,:) = cos(2*pi*f.*(t - 2*dd*cos(theta*pi/180)/cc)); xx(8,:) = cos(2*pi*f.*(t + dd*sin(theta*pi/180)/cc)); xx(9,:) = cos(2*pi*f.*(t + 2*dd*sin(theta*pi/180)/cc)); xx(10,:) = cos(2*pi*f.*(t + dd*cos(theta*pi/180)/cc)); xx(11,:) = cos(2*pi*f.*(t + 2*dd*cos(theta*pi/180)/cc)); xx(12,:) = cos(2*pi*f.*(t - dd*sin(theta*pi/180)/cc)); xx(13,:) = cos(2*pi*f.*(t - 2*dd*sin(theta*pi/180)/cc)); for i=1:beam_no dltn(1)=0; dltn(2)=round(3*dd*cos(dsita*(i-1))/dltc); dltn(3)=round(-3*dd*sin(dsita*(i-1))/dltc); dltn(4)=round(-3*dd*cos(dsita*(i-1))/dltc); dltn(5)=round(3*dd*sin(dsita*(i-1))/dltc); dltn(6)=round(dd*cos(dsita*(i-1))/dltc); dltn(7)=round(2*dd*cos(dsita*(i-1))/dltc); dltn(8)=round(-dd*sin(dsita*(i-1))/dltc); dltn(9)=round(-2*dd*sin(dsita*(i-1))/dltc); dltn(10)=round(-dd*cos(dsita*(i-1))/dltc); dltn(11)=round(-2*dd*cos(dsita*(i-1))/dltc); dltn(12)=round(dd*sin(dsita*(i-1))/dltc); dltn(13)=round(2*dd*sin(dsita*(i-1))/dltc); for j=1:13 ss(i,:)=ss(i,:)+xx(j,bn*floor(m/2)+1+dltn(j)+1:n-bn*floor(m/2)-1+dltn(j)+1); end end peakx=zeros(1,beam_no); for i=1:beam_no peakx(i)=var(ss(i,:)); end alpha = 0:1/180*pi:2*pi-1/180*pi; polar(alpha,peakx); figure,mesh(abs(peakx)) ```

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

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

文章目录Java概述何为编程什么是Javajdk1.5之后的三大版本JVM、JRE和JDK的关系什么是跨平台性？原理是什么Java语言有哪些特点什么是字节码？采用字节码的最大好处是什么什么是Java程序的主类？应用程序和小程序的主类有何不同？Java应用程序与小程序之间有那些差别？Java和C++的区别Oracle JDK 和 OpenJDK 的对比基础语法数据类型Java有哪些数据类型switc...

昨天早上通过远程的方式 review 了两名新来同事的代码，大部分代码都写得很漂亮，严谨的同时注释也很到位，这令我非常满意。但当我看到他们当中有一个人写的 switch 语句时，还是忍不住破口大骂：“我擦，小王，你丫写的 switch 语句也太老土了吧！” 来看看小王写的代码吧，看完不要骂我装逼啊。 private static String createPlayer(PlayerTypes p...

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

1. 前言从2020 年 JVM 生态报告解读 可以看出Intellij IDEA 目前已经稳坐 Java IDE 头把交椅。而且统计得出付费用户已经超过了八成（国外统计）。IDEA 的...

昨天看到一档综艺节目，讨论了两个话题：（1）中国学生的数学成绩，平均下来看，会比国外好？为什么？（2）男生的数学成绩，平均下来看，会比女生好？为什么？同时，我又联想到了一个技术圈经常讨...

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

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

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

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

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

据羊城晚报报道，近日中芯国际从荷兰进口的一台大型光刻机，顺利通过深圳出口加工区场站两道闸口进入厂区，中芯国际发表公告称该光刻机并非此前盛传的EUV光刻机，主要用于企业复工复产后的生产线扩容。 我们知道EUV主要用于7nm及以下制程的芯片制造，光刻机作为集成电路制造中最关键的设备，对芯片制作工艺有着决定性的影响，被誉为“超精密制造技术皇冠上的明珠”，根据之前中芯国际的公报，目...

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

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

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

不知道是不是只有我这样子，还是你们也有过类似的经历。 上学的时候总有很多光辉历史，学年名列前茅，或者单科目大佬，但是虽然慢慢地长大了，你开始懈怠了，开始废掉了。。。 什么？你说不知道具体的情况是怎么样的？ 我来告诉你： 你常常潜意识里或者心理觉得，自己真正的生活或者奋斗还没有开始。总是幻想着自己还拥有大把时间，还有无限的可能，自己还能逆风翻盘，只不是自己还没开始罢了，自己以后肯定会变得特别厉害...

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

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

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

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

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

爬取彼岸桌面网站较为简单，用到了requests、lxml、Beautiful Soup4

最近微信又搞出了一个大利器，甚至都上了热搜，当然消息最敏捷的自媒体人，纷纷都开通了自己的视频号。01 视频号是什么呢？视频号是微信体系内的短视频，它不同...

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

你好，我是Vam的金豆之路，可以叫我豆哥。2019年年度博客之星、技术领域博客专家。主要领域：前端开发。我的微信是 maomin9761，有什么疑问可以加我哦，自己创建了一个微信技术交流群，可以加我邀请你一起交流学习。最后自己也创建了一个微信公众号，里面的文章是我自己精挑细选的文章，主要介绍各种IT新技术。欢迎关注哦，微信搜索：臻美IT，等你来。 欢迎阅读本博文，本博文主要讲述【】，文字通...

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

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

前几天我们公司做了一件蠢事，非常非常愚蠢的事情。我原以为从学校出来之后，除了找工作有测试外，不会有任何与考试有关的事儿。 但是，天有不测风云，公司技术总监、人事总监两位大佬突然降临到我们事业线，叫上我老大，给我们组织了一场别开生面的“考试”。 那是一个风和日丽的下午，我翘着二郎腿，左手端着一杯卡布奇诺，右手抓着我的罗技鼠标，滚动着轮轴，穿梭在头条热点之间。 “淡黄的长裙~蓬松的头发...

在2019年的ReactiveConf 上，《Elm in Action》的作者Richard Feldman对未来5年Web开发的发展做了预测，很有意思，分享给大家。如果你有机会从头...