asked on

trying to upload files to server and file name to DB. can't compile + streamling.

I have the oreilly upload multifile form and servlet working correctly. but i cant add the functionality to have the file names upload to the DB.

i return 10 errors, 1 for each string i try and pass to the insert servlet.
[code]
imageUpload.java:62: cannot find symbol
symbol : variable img10
location: class savedata.imageUpload
insert(img1,img2,img3,img4,img5,img6,img7,img8,img9,img10);
^
[/code]

here is my entire code. why is it not getting the correct string? im printing out the value and it looks ok??

also, is there a better way to pass all those String names? I have a form with about 50 feilds. i can;t image passing 50 Strings through the method like that is good?

here is the entire code. I *think* it should work, or at least close to working once i can compile the file.

[code]
package savedata;

import javax.servlet.*;
import javax.servlet.http.*;
import com.oreilly.servlet.multipart.MultipartParser;
import com.oreilly.servlet.multipart.Part;
import com.oreilly.servlet.multipart.FilePart;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.*;

public class imageUpload extends HttpServlet {

private String fileSavePath;

public void init(){
// save uploaded files to a 'data' directory in the web app
fileSavePath = getServletContext().getRealPath("/") + "data";
}
public void doPost(HttpServletRequest request,
HttpServletResponse response) throws ServletException,
java.io.IOException {
response.setContentType("text/html");
java.io.PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head>");
out.println("<title>File uploads</title>");
out.println("</head>");
out.println("<body>");
out.println("<h2>Here is information about any uploaded files</h2>");
try{
// file limit size of five megabytes
MultipartParser parser = new MultipartParser(
request,5 * 1024 * 1024);
Part _part = null;
            int count = 1;
while ((_part = parser.readNextPart()) != null) {
if (_part.isFile()) {
// get some info about the file
FilePart fPart = (FilePart) _part;
String name = fPart.getFileName();
                   if (name != null) {
long fileSize = fPart.writeTo(
new java.io.File(fileSavePath));
out.println("The user's file path for the file: " +
fPart.getFilePath() + "<br>");
                        String img = "img" + count++;
                        out.print(img);
out.println("The content type of the file: " +
fPart.getContentType()+ "<br>");
out.println("The file size: " +fileSize+ " bytes<br><br>");
//commence with another file, if there is one
} else {
out.println(
"The user did not upload a file for this part.");
}
} else if (_part.isParam()) {
// do something else if it is a non-file type parameter,
//such as a user name
}
                    insert(img1,img2,img3,img4,img5,img6,img7,img8,img9,img10);
}// end while
out.println("</body>");
out.println("</html>");
out.close();


} catch (java.io.IOException ioe){
//an error-page in the deployment descriptor is
//mapped to the java.io.IOException
throw new java.io.IOException(
"IOException occurred in: " + getClass().getName());
}
}
public void doGet(HttpServletRequest request,
HttpServletResponse response) throws ServletException,
java.io.IOException {

throw new ServletException(
"GET method used with " + getClass().getName()+
": POST method required.");
}
public void insert(String img1,String img2,String img3, String img4,String img5,String img6,String img7, String img8, String img9,String img10) {
Connection con = null;
PreparedStatement prep = null;
String sql = null;
ResultSet result;

try {
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/root?user=root&password=");

if(!con.isClosed())
System.out.println("Successfully connected to " +
"MySQL server using TCP/IP...");

try
{
sql = "INSERT INTO form_main(img1,img2,img3,img4,img5,img6.img7,img8,img9,img10)VALUES(?,?,?,?,?,?,?,?,?,?)";
prep = con.prepareStatement(sql);
              prep.setString(1, img1);
              prep.setString(2, img2);
              prep.setString(3, img3);
              prep.setString(4, img4);
              prep.setString(5, img5);
              prep.setString(6, img6);
              prep.setString(7, img7);
              prep.setString(8, img8);
              prep.setString(9, img9);
              prep.setString(10,img10);
              prep.executeUpdate();
}
catch(Exception m)
{
System.out.print(m.getMessage());
}

} catch(Exception e) {
System.err.println("Exception: " + e.getMessage());
} finally {
try {
if(con != null)
con.close();
} catch(SQLException e) {}
}
}
}

[/code]