Permisi gan ane mo tanya ane lagi buat project buat nge Import file CSV ke MySql pake JSP , Syntaxnya kaya gini
Quote:
<%--
Document : jsppercobaan
Created on : Oct 12, 2012, 11:15:51 AM
Author : Willy
--%>
<%@page import="java.sql.DriverManager"%>
<%@page import="org.apache.jasper.tagplugins.jstl.core.Catch"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<h1>Hello World!</h1>
<%@page import="java.io.File" %>
<%@page import="java.sql.*" %>
<form>
<p> Pilih File yang akan diUpload</p>
<input type="file" name="path" value="path">
<br />
<input type="submit" value="submit" name="submit">
</form>
<%
String path = request.getParameter("path");
try {
Connection connection = null;
Statement statement = null;
ResultSet rs = null;
final String delimiter = ";";
Class.forName("com.mysql.jdbc.Driver");
String Host = "jdbc:mysql://localhost:3306/LATIHAN_JAVA";
connection = DriverManager.getConnection(Host, "root", "");
statement = connection.createStatement();
final String Data = "LOAD DATA INFILE'"+path+"' INTO TABLE LOADDATA FIELDS TERMINATED BY '"+delimiter+"'LINES TERMINATED BY '
' (Nama, NIM);";
try{
statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
rs = statement.executeQuery(Data);
rs.close();
statement.close();
connection.close();
}catch (SQLException SE){
out.println(SE);
}
} catch (Exception ex){
out.println(ex);
}
%>
</body>
</html>
nah pas ane running muncul pesan error
"java.sql.SQLException: File 'C:\xampp\mysql\data\latihan_java
ull' not found (Errcode: 2)"
ini kenapa ya gan????
