netbeans - Make Java application create SQL document file -


i understand how create program creates text file. said text file formatted sql document, can imported derby database.

this code have now:

private void jbutton3actionperformed(java.awt.event.actionevent evt) {                                              joptionpane.showmessagedialog(frame, "thank joining bpa!");     string content = "first name: " + fname.gettext() + "\r\n" +                      "middle initial: " + mname.gettext() + "\r\n" +                      "last name: " + lname.gettext() + "\r\n" +                      "email address: " + email.gettext() + "\r\n" +                       "phone number: " + phone.gettext() + "\r\n" +                      "street address: " + saddress.gettext() + "\r\n" +                       "city: " + city.gettext() + "\r\n" +                        //state                      "zip: " + zip.gettext() + "\r\n" +                       //grade                      //shop                      "home room: " + hroom.gettext() + "\r\n" +                       "parent name: " + pname.gettext() + "\r\n" +                       "parent email: " + pemail.gettext() + "\r\n" +                      "\r\n" +                       "\r\n" +                       "please send file bpasignup@gmail.com complete registration process" + "\r\n" +                       "you may delete file after it's been sent";      try {              file file = new file("g:/bat/bpasignup.sql");              // if file doesnt exists, create             if (!file.exists()) {                 file.createnewfile();             }              filewriter fw = new filewriter(file.getabsolutefile());             bufferedwriter bw = new bufferedwriter(fw);             bw.write(content);    //step2: write             bw.close();              system.out.println("done");          } catch (ioexception e) {             e.printstacktrace();

it creates document looks this:

first name: middle initial: last name: email address: phone number: street address: city: zip: home room: parent name: parent email:

please send file hidden complete registration process may delete file after it's been sent

i change format, information pulled correct jtextfields before. please forgive me if i'm not being clear.

insert bpasignup (fname, minitial, lname, email, phonenum, saddress, city, state, grade, shop, hroom, pname, pemail) values (' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', , ' ', ' ');

thank in advance!


Comments

Post a Comment

Popular posts from this blog

aws api gateway - SerializationException in posting new Records via Dynamodb Proxy Service in API -

i getting "__type": "com.amazon.coral.service#serializationexception" as reply in postman & in test console in api gateway trying post record directly dynamodb using api proxy services.. referring aws article - https://aws.amazon.com/blogs/compute/using-amazon-api-gateway-as-a-proxy-for-dynamodb/ here's mapping { "tablename": "tablenamegoeshere", "item": { "id" : "$context.requestid" "eventname" : "$input.path('$.eventname')", "timestamp" : $input.path('$.timestamp'), "answers": "$util.parsejson($input.path('$.answers'))" } } update: did asked ... , worked if try add array of json objects gives me above same error - here's trying now. please - couldnt find on google well #set($inputroot = $input.path('$')) { "tablename": "answer", "item": {
Read more

asp.net - Problems sending emails from forum -

i have been redesigning site has message board, has been written guy looked after site. it has few problems , written in .asp , uses .mdb files database. you can see whole thing here . feel free post if helps, test thing have set using original files , new database. the basic problem when posts message, supposed email sent them, have posted it. when replies, originator supposed message, replier has been posted. i’d have thought @ point in process there should script/file in postmessage.asp? the postmessage.asp page below. <% option explicit %> <!-- #include virtual="common/adovbs.inc" --> <html> <head> <meta http-equiv="content-type" content="text/html; charset=windows-1252"> <meta name="generator" content="microsoft frontpage 4.0"> <meta name="progid" content="frontpage.editor.document"> <title>new page 2</title> <base target="_self"
Read more