前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >mysql使用set类型_java修改request请求参数

mysql使用set类型_java修改request请求参数

作者头像
全栈程序员站长
发布2022-09-30 20:55:10
9290
发布2022-09-30 20:55:10
举报

大家好,又见面了,我是你们的朋友全栈君。

I am trying to send multiple images to server but,so I am storing all the images in one arraylist,but after that when I need to send to server,it shows error near line ,,………………….

conn.setRequestProperty(“image”, multimgss);

error

The method setRequestProperty(String, String) in the type URLConnection is not applicable for the arguments (String, ArrayList)..

MainActivity

public int uploadFile(String sourceFileUri) {

String fileName = sourceFileUri;

/*String[] mimgs = null;

mimgs.equals(fileName);*/

ArrayList multimgss=new ArrayList();

multimgss.add(fileName);

System.out.println(“multipleimagesss”+multimgss);

try {

abcd = new JSONArray(multimgss.toString());

} catch (JSONException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

//abcd=multimgss.add(fileName);

HttpURLConnection conn = null;

DataOutputStream dos = null;

String lineEnd = “\r\n”;

String twoHyphens = “–“;

String boundary = “*****”;

int bytesRead, bytesAvailable, bufferSize;

byte[] buffer;

int maxBufferSize = 1 * 1024 * 1024;

File sourceFile = new File(sourceFileUri);

if (!sourceFile.isFile()) {

dialog.dismiss();

Log.e(“uploadFile”, “Source File not exist :”+imagepath);

runOnUiThread(new Runnable() {

public void run() {

messageText.setText(“Source File not exist :”+ imagepath);

}

});

return 0;

}

else

{

try {

String cats[]=acTextView.getText().toString().split(“,”);

JsonParse jp=new JsonParse();

for(String cat:cats){

List list =jp.getParseJsonWCF(acTextView.getText().toString());

for(int i = 0;i

if(list.get(i).getName().equals(cat))

catid.add(list.get(i).getId().toString());

//params.add(new BasicNameValuePair(“parentid”,list.get(i).getId()));

}

}

catsids=catid.toString();

pname = proname.getText().toString();

pskucode = proskucode.getText().toString();

psalerate=prosalerate.getText().toString();

ppurchaserate=propurchaserate.getText().toString();

pweight = proweight.getText().toString();

pweighttype=proweighttype.getText().toString();

// pproactives = proactives.getTag().toString();

System.out.println(“active nu stauts”+catsids);

// pdisporder = prodisporder.getText().toString();

pdesc = prodesc.getText().toString();

upLoadServerUri = “http://webistname/web-service/addproduct.php?action=addproduct&name=”+pname+”&categoryid=”+catsids+”&skucode=”+pskucode+”&sale_rate=”+psalerate+”&purchase_rate=”+ppurchaserate+”&weight=”+pweight+”&weighttype=”+pweighttype+”&description=hello&image=”+abcd;

// open a URL connection to the Servlet

FileInputStream fileInputStream = new FileInputStream(sourceFile);

URL url = new URL(upLoadServerUri);

// Open a HTTP connection to the URL

conn = (HttpURLConnection) url.openConnection();

conn.setDoInput(true); // Allow Inputs

conn.setDoOutput(true); // Allow Outputs

conn.setUseCaches(false); // Don’t use a Cached Copy

conn.setRequestMethod(“POST”);

conn.setRequestProperty(“Connection”, “Keep-Alive”);

conn.setRequestProperty(“ENCTYPE”, “multipart/form-data”);

conn.setRequestProperty(“Content-Type”, “multipart/form-data;boundary=” + boundary);

conn.setRequestProperty(“name”, pname);

conn.setRequestProperty(“categoryid”, catsids);

conn.setRequestProperty(“skucode”, pskucode);

conn.setRequestProperty(“sale_rate”, psalerate);

conn.setRequestProperty(“purchase_rate”, ppurchaserate);

conn.setRequestProperty(“weight”, pweight);

conn.setRequestProperty(“weighttype”, pweighttype);

conn.setRequestProperty(“description”, “hello”);

// conn.setRequestProperty(“displayorder”, pdisporder);

// conn.setRequestProperty(“active”, pproactives);

conn.setRequestProperty(“image”, abcd.toString());

dos = new DataOutputStream(conn.getOutputStream());

dos.writeBytes(twoHyphens + boundary + lineEnd);

dos.writeBytes(“Content-Disposition: form-data; name=\”type\””

+ lineEnd);

dos.writeBytes(lineEnd);

// assign value

/*dos.writeBytes(“version=apps”);

dos.writeBytes(lineEnd);

dos.writeBytes(twoHyphens + boundary + lineEnd);*/

dos.writeBytes(“name=”+pname);

dos.writeBytes(lineEnd);

dos.writeBytes(twoHyphens + boundary + lineEnd);

dos.writeBytes(“categoryid=”+catsids);

dos.writeBytes(lineEnd);

dos.writeBytes(twoHyphens + boundary + lineEnd);

dos.writeBytes(“skucode=”+pskucode);

dos.writeBytes(lineEnd);

dos.writeBytes(twoHyphens + boundary + lineEnd);

dos.writeBytes(“sale_rate=”+psalerate);

dos.writeBytes(lineEnd);

dos.writeBytes(twoHyphens + boundary + lineEnd);

dos.writeBytes(“purchase_rate=”+ppurchaserate);

dos.writeBytes(lineEnd);

dos.writeBytes(twoHyphens + boundary + lineEnd);

dos.writeBytes(“weight=”+pweight);

dos.writeBytes(lineEnd);

dos.writeBytes(twoHyphens + boundary + lineEnd);

dos.writeBytes(“weighttype=”+pweighttype);

dos.writeBytes(lineEnd);

dos.writeBytes(twoHyphens + boundary + lineEnd);

dos.writeBytes(“description=”+”hello”);

dos.writeBytes(lineEnd);

dos.writeBytes(twoHyphens + boundary + lineEnd);

/* dos.writeBytes(“displayorder=”+pdisporder);

dos.writeBytes(lineEnd);

dos.writeBytes(twoHyphens + boundary + lineEnd);

dos.writeBytes(“active=”+pproactives);

dos.writeBytes(lineEnd);

dos.writeBytes(twoHyphens + boundary + lineEnd);*/

dos.writeBytes(“Content-Disposition: form-data; name=\”image\”;filename=\””

+ abcd.toString() + “\”” + lineEnd);

dos.writeBytes(lineEnd);

// create a buffer of maximum size

bytesAvailable = fileInputStream.available();

bufferSize = Math.min(bytesAvailable, maxBufferSize);

buffer = new byte[bufferSize];

// read file and write it into form…

bytesRead = fileInputStream.read(buffer, 0, bufferSize);

while (bytesRead > 0) {

dos.write(buffer, 0, bufferSize);

bytesAvailable = fileInputStream.available();

bufferSize = Math.min(bytesAvailable, maxBufferSize);

bytesRead = fileInputStream.read(buffer, 0, bufferSize);

}

// send multipart form data necesssary after file data…

dos.writeBytes(lineEnd);

dos.writeBytes(twoHyphens + boundary + twoHyphens + lineEnd);

// Responses from the server (code and message)

serverResponseCode = conn.getResponseCode();

String serverResponseMessage = conn.getResponseMessage();

Log.i(“uploadFile”, “HTTP Response is : “

+ serverResponseMessage + “: ” + serverResponseCode);

if(serverResponseCode == 200){

runOnUiThread(new Runnable() {

public void run() {

String msg = “File Upload Completed.\n\n See uploaded file here : \n\n”

+” F:/wamp/wamp/www/uploads”;

messageText.setText(msg);

Toast.makeText(MainActivity.this, “File Upload Complete.”, Toast.LENGTH_SHORT).show();

}

});

}

Fullcode

public class MainActivity extends Activity implements OnClickListener {

private static int RESULT_LOAD_IMAGE = 1;

private TextView messageText;

private Button uploadButton;

private ImageView imageview;

private int serverResponseCode = 0;

private ProgressDialog dialog = null;

private String upLoadServerUri = null;

private String imagepath=null;

private EditText proname;

private EditText proskucode;

private EditText prodesc;

//private CheckBox proactives;

private ImageView btnselectpic;

private String pskucode;

private EditText prosalerate;

private EditText propurchaserate;

private EditText proweight;

private EditText proweighttype;

//private EditText prodisporder;

private String pname;

private String psalerate;

private String ppurchaserate;

private String pweight;

private String pweighttype;

private String pproactives;

private String pdisporder;

private String pdesc;

private List catid=new ArrayList();

private AutoCompleteTextView acTextView;

private String catsids;

private Uri selectedImageUri;

private int columnIndex;

private ImageAdapter objImageAdapter;

private GridView gridView;

private JSONArray abcd;

@Override

public void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_main);

gridView = (GridView) findViewById(R.id.gridview);

//gridView.setAdapter(new ImageAdapter(this));

objImageAdapter= new ImageAdapter(this);

gridView.setAdapter(objImageAdapter);

gridView.setOnItemClickListener(new OnItemClickListener()

{

public void onItemClick(AdapterView> parent,

View v, int position, long id)

{

Toast.makeText(getBaseContext(),

“pic” + (position + 1) + ” selected”,

Toast.LENGTH_SHORT).show();

}

});

acTextView = (AutoCompleteTextView) findViewById(R.id.multautoComplete);

acTextView.setAdapter(new SuggestionAdapter(this,acTextView.getText().toString()));

// acTextView.setTokenizer(new MultiAutoCompleteTextView.CommaTokenizer());

proname=(EditText)findViewById(R.id.edt_proname);

proskucode=(EditText)findViewById(R.id.edt_proskucode);

prosalerate=(EditText)findViewById(R.id.edt_salerate);

propurchaserate=(EditText)findViewById(R.id.edt_purchaserate);

proweight=(EditText)findViewById(R.id.edt_weight);

proweighttype=(EditText)findViewById(R.id.edt_weighttype);

// prodesc=(EditText)findViewById(R.id.edt_desc);

// prodisporder=(EditText)findViewById(R.id.edt_disporder);

// proactives=(CheckBox)findViewById(R.id.edt_proactive);

uploadButton = (Button)findViewById(R.id.btn_addpro);

messageText = (TextView)findViewById(R.id.edt_imgs);

btnselectpic = (ImageView)findViewById(R.id.browsesimgs);

imageview = (ImageView)findViewById(R.id.imagevw);

btnselectpic.setOnClickListener(this);

uploadButton.setOnClickListener(this);

}

@Override

public void onClick(View arg0) {

if(arg0==btnselectpic)

{

/*Intent intent=new Intent(MainActivity.this,PhotoSelection.class);

startActivity(intent);*/

Intent intent = new Intent(Intent.ACTION_GET_CONTENT);

intent.setType(“image/*”);

startActivityForResult(intent, 1);

/*Intent intent = new Intent();

intent.setType(“image/*”);

intent.setAction(Intent.ACTION_GET_CONTENT);

startActivityForResult(Intent.createChooser(intent, “Complete action using”), 1);*/

/*Intent i = new Intent(Action.ACTION_MULTIPLE_PICK);

startActivityForResult(i, 200);*/

}

else if (arg0==uploadButton) {

dialog = ProgressDialog.show(MainActivity.this, “”, “Uploading file…”, true);

messageText.setText(“uploading started…..”);

new Thread(new Runnable() {

public void run() {

uploadFile(imagepath);

}

}).start();

}

}

@Override

protected void onActivityResult(int requestCode, int resultCode, Intent data) {

if (requestCode == RESULT_LOAD_IMAGE && resultCode == RESULT_OK && null != data) {

selectedImageUri= data.getData();

String[] filePathColumn = { MediaStore.Images.Media.DATA };

Cursor cursor = getContentResolver().query(selectedImageUri,

filePathColumn, null, null, null);

cursor.moveToFirst();

/* columnIndex = cursor.getColumnIndex(filePathColumn[0]);

picturePath = cursor.getString(columnIndex);

cursor.close();*/

// imageView = (ImageView) findViewById(R.id.imgView);

imageview.setImageBitmap(BitmapFactory.decodeFile(imagepath));

columnIndex = cursor.getColumnIndex(filePathColumn[0]);

String picturePath = cursor.getString(columnIndex);

objImageAdapter.addToList(picturePath);

cursor.close();

// addmores.setVisibility(View.VISIBLE);

}

/*if (requestCode == 1 && resultCode == RESULT_OK) {

//Bitmap photo = (Bitmap) data.getData().getPath();

selectedImageUri = data.getData();

imagepath = getPath(selectedImageUri);

Bitmap bitmap=BitmapFactory.decodeFile(imagepath);

imageview.setImageBitmap(bitmap);

messageText.setText(“Uploading file path:” +imagepath);

}*/

}

public String getPath(Uri uri) {

String[] projection = { MediaStore.Images.Media.DATA };

Cursor cursor = managedQuery(uri, projection, null, null, null);

int column_index = cursor.getColumnIndexOrThrow(MediaStore.Images.Media.DATA);

cursor.moveToFirst();

return cursor.getString(column_index);

}

public class ImageAdapter extends BaseAdapter

{

private Context context;

ArrayList arrayList=new ArrayList();

public ImageAdapter(Context c)

{

context = c;

}

//—returns the number of images—

public int getCount() {

return arrayList.size();

}

//—returns the ID of an item—

public Object getItem(int position) {

return position;

}

void addToList(String strPath)

{

this.arrayList.add(strPath);

this.notifyDataSetChanged();

}

public long getItemId(int position) {

return position;

}

//In this array you have to store all images path which is you want to display in baseapater and must be global to access in baseapater

public View getView(int position, View convertView, ViewGroup parent)

{

ImageView imageView;

if (convertView == null) {

imageView = new ImageView(context);

imageView.setLayoutParams(new GridView.LayoutParams(185, 185));

imageView.setScaleType(ImageView.ScaleType.CENTER_CROP);

imageView.setPadding(5, 5, 5, 5);

} else {

imageView = (ImageView) convertView;

}

String path = arrayList.get(position);

Bitmap myBitmap = BitmapFactory.decodeFile(path);

imageView.setImageBitmap(myBitmap);

return imageView;

}

}

public int uploadFile(String sourceFileUri) {

String fileName = sourceFileUri;

/*String[] mimgs = null;

mimgs.equals(fileName);*/

ArrayList multimgss=new ArrayList();

multimgss.add(fileName);

System.out.println(“multipleimagesss”+multimgss);

try {

abcd = new JSONArray(multimgss.toString());

} catch (JSONException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

//abcd=multimgss.add(fileName);

HttpURLConnection conn = null;

DataOutputStream dos = null;

String lineEnd = “\r\n”;

String twoHyphens = “–“;

String boundary = “*****”;

int bytesRead, bytesAvailable, bufferSize;

byte[] buffer;

int maxBufferSize = 1 * 1024 * 1024;

File sourceFile = new File(sourceFileUri);

if (!sourceFile.isFile()) {

dialog.dismiss();

Log.e(“uploadFile”, “Source File not exist :”+imagepath);

runOnUiThread(new Runnable() {

public void run() {

messageText.setText(“Source File not exist :”+ imagepath);

}

});

return 0;

}

else

{

try {

String cats[]=acTextView.getText().toString().split(“,”);

JsonParse jp=new JsonParse();

for(String cat:cats){

List list =jp.getParseJsonWCF(acTextView.getText().toString());

for(int i = 0;i

if(list.get(i).getName().equals(cat))

catid.add(list.get(i).getId().toString());

//params.add(new BasicNameValuePair(“parentid”,list.get(i).getId()));

}

}

catsids=catid.toString();

pname = proname.getText().toString();

pskucode = proskucode.getText().toString();

psalerate=prosalerate.getText().toString();

ppurchaserate=propurchaserate.getText().toString();

pweight = proweight.getText().toString();

pweighttype=proweighttype.getText().toString();

// pproactives = proactives.getTag().toString();

System.out.println(“active nu stauts”+catsids);

// pdisporder = prodisporder.getText().toString();

pdesc = prodesc.getText().toString();

upLoadServerUri = “http://mywebsitename/web-service/addproduct.php?action=addproduct&name=”+pname+”&categoryid=”+catsids+”&skucode=”+pskucode+”&sale_rate=”+psalerate+”&purchase_rate=”+ppurchaserate+”&weight=”+pweight+”&weighttype=”+pweighttype+”&description=hello&image=”+abcd;

// open a URL connection to the Servlet

FileInputStream fileInputStream = new FileInputStream(sourceFile);

URL url = new URL(upLoadServerUri);

// Open a HTTP connection to the URL

conn = (HttpURLConnection) url.openConnection();

conn.setDoInput(true); // Allow Inputs

conn.setDoOutput(true); // Allow Outputs

conn.setUseCaches(false); // Don’t use a Cached Copy

conn.setRequestMethod(“POST”);

conn.setRequestProperty(“Connection”, “Keep-Alive”);

conn.setRequestProperty(“ENCTYPE”, “multipart/form-data”);

conn.setRequestProperty(“Content-Type”, “multipart/form-data;boundary=” + boundary);

conn.setRequestProperty(“name”, pname);

conn.setRequestProperty(“categoryid”, catsids);

conn.setRequestProperty(“skucode”, pskucode);

conn.setRequestProperty(“sale_rate”, psalerate);

conn.setRequestProperty(“purchase_rate”, ppurchaserate);

conn.setRequestProperty(“weight”, pweight);

conn.setRequestProperty(“weighttype”, pweighttype);

conn.setRequestProperty(“description”, “hello”);

conn.setRequestProperty(“image”, abcd.toString());

dos = new DataOutputStream(conn.getOutputStream());

dos.writeBytes(twoHyphens + boundary + lineEnd);

dos.writeBytes(“Content-Disposition: form-data; name=\”type\””

+ lineEnd);

dos.writeBytes(lineEnd);

dos.writeBytes(lineEnd);

dos.writeBytes(twoHyphens + boundary + lineEnd);*/

dos.writeBytes(“name=”+pname);

dos.writeBytes(lineEnd);

dos.writeBytes(twoHyphens + boundary + lineEnd);

dos.writeBytes(“categoryid=”+catsids);

dos.writeBytes(lineEnd);

dos.writeBytes(twoHyphens + boundary + lineEnd);

dos.writeBytes(“skucode=”+pskucode);

dos.writeBytes(lineEnd);

dos.writeBytes(twoHyphens + boundary + lineEnd);

dos.writeBytes(“sale_rate=”+psalerate);

dos.writeBytes(lineEnd);

dos.writeBytes(twoHyphens + boundary + lineEnd);

dos.writeBytes(“purchase_rate=”+ppurchaserate);

dos.writeBytes(lineEnd);

dos.writeBytes(twoHyphens + boundary + lineEnd);

dos.writeBytes(“weight=”+pweight);

dos.writeBytes(lineEnd);

dos.writeBytes(twoHyphens + boundary + lineEnd);

dos.writeBytes(“weighttype=”+pweighttype);

dos.writeBytes(lineEnd);

dos.writeBytes(twoHyphens + boundary + lineEnd);

dos.writeBytes(“description=”+”hello”);

dos.writeBytes(lineEnd);

dos.writeBytes(twoHyphens + boundary + lineEnd);

dos.writeBytes(“Content-Disposition: form-data; name=\”image\”;filename=\””

+ abcd.toString() + “\”” + lineEnd);

dos.writeBytes(lineEnd);

// create a buffer of maximum size

bytesAvailable = fileInputStream.available();

bufferSize = Math.min(bytesAvailable, maxBufferSize);

buffer = new byte[bufferSize];

// read file and write it into form…

bytesRead = fileInputStream.read(buffer, 0, bufferSize);

while (bytesRead > 0) {

dos.write(buffer, 0, bufferSize);

bytesAvailable = fileInputStream.available();

bufferSize = Math.min(bytesAvailable, maxBufferSize);

bytesRead = fileInputStream.read(buffer, 0, bufferSize);

}

// send multipart form data necesssary after file data…

dos.writeBytes(lineEnd);

dos.writeBytes(twoHyphens + boundary + twoHyphens + lineEnd);

// Responses from the server (code and message)

serverResponseCode = conn.getResponseCode();

String serverResponseMessage = conn.getResponseMessage();

Log.i(“uploadFile”, “HTTP Response is : “

+ serverResponseMessage + “: ” + serverResponseCode);

if(serverResponseCode == 200){

runOnUiThread(new Runnable() {

public void run() {

String msg = “File Upload Completed.\n\n See uploaded file here : \n\n”

+” F:/wamp/wamp/www/uploads”;

messageText.setText(msg);

Toast.makeText(MainActivity.this, “File Upload Complete.”, Toast.LENGTH_SHORT).show();

}

});

}

fileInputStream.close();

dos.flush();

dos.close();

} catch (MalformedURLException ex) {

dialog.dismiss();

ex.printStackTrace();

runOnUiThread(new Runnable() {

public void run() {

messageText.setText(“MalformedURLException Exception : check script url.”);

Toast.makeText(MainActivity.this, “MalformedURLException”, Toast.LENGTH_SHORT).show();

}

});

Log.e(“Upload file to server”, “error: ” + ex.getMessage(), ex);

} catch (Exception e) {

dialog.dismiss();

e.printStackTrace();

runOnUiThread(new Runnable() {

public void run() {

messageText.setText(“Got Exception : see logcat “);

Toast.makeText(MainActivity.this, “Got Exception : see logcat “, Toast.LENGTH_SHORT).show();

}

});

Log.e(“Upload file to server Exception”, “Exception : ” + e.getMessage(), e);

}

dialog.dismiss();

return serverResponseCode;

}

}

}

ASRed.png
ASRed.png

解决方案

setRequestProperty method only accept String instead of ArrayList . get JSONArray from ArrayList as:

JSONArray jsonArrayImgs=new JSONArray();

ArrayList multimgss=new ArrayList();

for (String string : multimgss)

{

jsonArrayImgs.put(string);

}

Now pass jsonArrayImgs to setRequestProperty :

conn.setRequestProperty(“image”, jsonArrayImgs.toString());

EDIT:

sourceFileUri is null . so update getItem method as of Adapter:

public String getItem(int position) {

return arrayList.get[position];

}

now inside onItemClick of GridView asign selected image path to sourceFileUri as:

public void onItemClick(AdapterView> parent,

View v, int position, long id)

{

imagepath=objImageAdapter.getItem(position);

}

版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 举报,一经查实,本站将立刻删除。

发布者:全栈程序员栈长,转载请注明出处:https://javaforall.cn/195219.html原文链接:https://javaforall.cn

本文参与 腾讯云自媒体分享计划,分享自作者个人站点/博客。
原始发表:2022年9月10日 ,如有侵权请联系 cloudcommunity@tencent.com 删除

本文分享自 作者个人站点/博客 前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文参与 腾讯云自媒体分享计划  ,欢迎热爱写作的你一起参与!

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
相关产品与服务
数据库一体机 TData
数据库一体机 TData 是融合了高性能计算、热插拔闪存、Infiniband 网络、RDMA 远程直接存取数据的数据库解决方案,为用户提供高可用、易扩展、高性能的数据库服务,适用于 OLAP、 OLTP 以及混合负载等各种应用场景下的极限性能需求,支持 Oracle、SQL Server、MySQL 和 PostgreSQL 等各种主流数据库。
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档