[ASK] Error pada JSP

Beranda
Komunitas
Tech
Programmer Forum
[ASK] Error pada JSP

pepellz

14-01-2013 13:26

gan ini source codenya

Spoiler for source code:

Code:

<%@ page import="java.sql.*" %>

<%

 String Nim = request.getParameter("tf_Nim");

 String Nama = request.getParameter("tf_Nama");

 String Tgl_lahir = request.getParameter("tf_Tgl_Lahir");

 String Fakultas = request.getParameter("tf_Fakultas");

 String Departemen = request.getParameter("tf_Departemen");

 String Alamat = request.getParameter("tf_Alamat");

 String E_mail = request.getParameter("tf_E_mail");

 Connection con=null;

 String status="";

 Statement st = null;

 try{

 String connectionURL = "jdbc:mysql://localhost/komajsp";

 String username = "root";

 String password = "";

 Class.forName("com.mysql.jdbc.Driver");

 con= DriverManager.getConnection(connectionURL, username , password );

 if (con==null)

 status = "gagal";

 else

 status = "berhasil";

 }

 catch(ClassNotFoundException ex){

 status = "Driver Error";

 }catch(SQLException ex){

 status = "gagal";

 }

 String kueri = "INSERT INTO mahasiswa(nim, Nama, tgl_lahir,Fakultas,Departemen,Alamat,E_mail) VALUES ('"+Nim+"','"+Nama+"','"+Tgl_lahir+"','"+Fakultas+"','"+Departemen+"','"+Alamat+"','"+E_mail+")";

 st = con.createStatement();

 int IsiTabel = st.executeUpdate(kueri);

 st.close();

 con.close();

%>

<HTML>

<HEAD>

 <TITLE>Membuat Tabel</TITLE>

 </HEAD>

 <BODY>

 <%

 if (IsiTabel == 1)

 out.println("Penambahan data berhasil");

 else

 out.println("Penambahan data gagal");

 %>

<br>

<br>

 <a href="FormMasukanData.htm"> TAMBAH DATA </a>

<br>

<br>

 <a href="LihatData.jsp">LIHAT DATA </a>

 </BODY>

</HTML>

ini errornya gan

Code:

type Exception report



message An exception occurred processing JSP page /InputData.jsp at line 30



description The server encountered an internal error that prevented it from fulfilling this request.



exception



org.apache.jasper.JasperException: An exception occurred processing JSP page /InputData.jsp at line 30



27: }

28: String kueri = "INSERT INTO mahasiswa VALUES ('"+Nim+"','"+Nama+"','"+Tgl_lahir+"','"+Fakultas+"','"+Departemen+"','"+Alamat+"','"+E_mail+")";

29: Statement st = con.createStatement();

30: int IsiTabel = st.executeUpdate(kueri);

31: 

32: st.close();

33: con.close();





Stacktrace:

 org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:568)

 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:455)

 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)

 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)

 javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

root cause



javax.servlet.ServletException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '')' at line 1

 org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:912)

 org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:841)

 org.apache.jsp.InputData_jsp._jspService(InputData_jsp.java:125)

 org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

 javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)

 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)

 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)

 javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

root cause



com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '')' at line 1

 sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

 sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

 sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

 java.lang.reflect.Constructor.newInstance(Constructor.java:513)

 com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

 com.mysql.jdbc.Util.getInstance(Util.java:386)

 com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)

 com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)

 com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)

 com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)

 com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)

 com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2728)

 com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1811)

 com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1725)

 org.apache.jsp.InputData_jsp._jspService(InputData_jsp.java:93)

 org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

 javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)

 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)

 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)

 javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.30 logs.

mohon bantuannya gan, gimana buat gak jadi error , mohon bimbingannya

Diubah oleh pepellz 14-01-2013 14:21

3.7K

Kutip

Balasan

Komentar yang asik ya

Urutan

Terbaru

Terlama

Komentar yang asik ya

Komunitas Pilihan