jsp - Use column names with periods -

-

i've been writing jsp insert values excel sheet , code below.

<%@page import="java.sql.*"%> <% connection con = null; statement stmnt = null; try {     int updatequery=0;     string a=request.getparameter("comments");     string b=request.getparameter("updatedl");     string c=request.getparameter("sid");     string d=request.getparameter("desc");     string e=request.getparameter("pubcode");     string f=request.getparameter("type");     string g=request.getparameter("status");     string h=request.getparameter("daterec");     string i=request.getparameter("startd");     string j=request.getparameter("assignedd");     string k=request.getparameter("senttoae");     string l=request.getparameter("respfrmae");     string m=request.getparameter("vwrcmp");     string n=request.getparameter("ps");     string o=request.getparameter("test");     string p=request.getparameter("units");     string q=request.getparameter("vwr");     string r=request.getparameter("ie");     string s=request.getparameter("revdate");     string t=request.getparameter("reviews");   class.forname( "sun.jdbc.odbc.jdbcodbcdriver" ); con = drivermanager.getconnection( "jdbc:odbc:driver={microsoft excel driver (*.xls)};dbq=c:/jus/excel1.xls;");   stmnt = con.createstatement();  //string query="select column_name 'feb$'"; string query = "insert [feb$] (comments,'no. of lines updated in psis','shipment id',"+ "'sap txt description', 'phoenix pub code', 'product type', 'status of job', 'date request received',"+ "'start date', 'date assigned', 'date file sent ae', 'date response ae',"+ "'date completed --vwr', 'assigned ps', 'time estimate', units, 'date file needs sent vendor (vwr)',"+ "'internal errors', 'review date',  'review sent (yes/no)') values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; preparedstatement ps=con.preparestatement(query); ps.setstring(1, a); ps.setstring(2, b); ps.setstring(3, c); ps.setstring(4, d); ps.setstring(5, e); ps.setstring(6, f); ps.setstring(7, g); ps.setstring(8, h); ps.setstring(9, i); ps.setstring(10, j); ps.setstring(11, k); ps.setstring(12, l); ps.setstring(13, m); ps.setstring(14, n); ps.setstring(15, o); ps.setstring(16, p); ps.setstring(17, q); ps.setstring(18, r); ps.setstring(19, s); ps.setstring(20, t);  //out.print(query); resultset rs = ps.executequery();  if (updatequery != 0) { %> <br> <table style="background-color: #e3e4fa;"  width="30%" border="1">    <tr><th>data inserted   in database.</th></tr> </table> <% }  } catch( exception e ) { out.println( e ); } { try { stmnt.close(); con.close(); } catch( exception e ) { out.println( e ); } }          %>

when run i'm getting below exception.

java.sql.sqlexception: [microsoft][odbc excel driver] invalid bracketing of name ''no. of lines updated in psis''.

please let me know how can rid of exception without changing column name.

thanks


Comments

Post a Comment

Popular posts from this blog

java - WrongTypeOfReturnValue exception thrown when unit testing using mockito -

-
my test list<person> mylist; @test public void testisvalidperson() { mylist = new arraylist<person>(); mylist.add(new person("tom")); when(persondao.get(person)).thenreturn(mylist); when((persondao.get(person)).isempty()).thenreturn(false);//------exception thrown boolean result = service.isvalid("tom"); assertfalse(result); } method tested: public boolean isvalid(string person){ persondao = new persondao(); person personobj = new person(person); return (persondao.get(person).isempty())?false : true; } exception thrown: org.mockito.exceptions.misusing.wrongtypeofreturnvalue: boolean cannot returned get() get() should return list *** if you're unsure why you're getting above error read on. due nature of syntax above problem might occur because: 1. exception *might* occur in wrongly written multi-threaded tests. please refer mockito faq on limitations of concurrency testing. 2. sp
Read more

php - Magento - Deleted Base url key -

-
i working on cleaning url: http://mydomain.com/shop/shop/deals i going through settings in configuration tab in admin panel on magento , change secure , unsecure base urls remove first base url "shop" web page read: http://mydomain.com/shop/deals so changed unsecure base urls mydomain.com/shop mydomain.com , secure 12.345.67.89/shop 12.345.67.89. wrong thing do. i cannot reload page or admin console. how access these files through ftp , change correctly there?? when make changes in admin panel changes made in database not in file. have make changes in database. 1.go database , select core_config_data table under table find web/unsecure/base_url , web/secure/base_url . make changes here. don't forget clear cache in var/cache folder
Read more

android - How to disable Button if EditText is empty ? -

-
i have edittext , button in application. when button clicked,the text entered in edittext added listview. i want disable button if edittext empty.how ? this code button click imagebutton imb=(imagebutton)findviewbyid(r.id.btn_send); imb.setonclicklistener(new onclicklistener() { @override public void onclick(view arg0) { edittext et = (edittext)findviewbyid(r.id.edittext1); string str = et.gettext().tostring(); web1.add(str); toast.maketext(shoutsingleprogram.this, "you entered...."+str, toast.length_short).show(); adapter1.notifydatasetchanged(); et.settext(""); } }); } how can ? edittext1.addtextchangedlistener(new textwatcher() { @override public void ontextchanged(charsequence s, int start, int before, in
Read more