sape leh tolong,saya nak buat insert function tp asyik error je.nak kata problem connection ngan database function login boleh la run.sape2 sudi tolong.codingnye ade kat bawah ni.

<%
String StrName = request.getParameter("name");
String StrMatrix = request.getParameter("matrix");
String StrIC = request.getParameter("ic");
String StrCpa = request.getParameter("cpa");
String StrProg = request.getParameter("prog");



Connection dbconn = null;
ResultSet results= null;
PreparedStatement ps =null;

Class.forName("org.gjt.mm.mysql.Driver");

dbconn = DriverManager.getConnection("jdbc:mysql://localhost/spath02","root","");

String sql ="SELECT register.* FROM register WHERE matrix= ?";

ps = dbconn.prepareStatement(sql);
ps.setString(2,StrMatrix);
ps.setString(3,StrIC);

results = ps.executeQuery();

if (results.next())
{
response.sendredirect("error.html");

}
else
{String status = 0;
sql = "INSERT INTO register(name, matrix, ic, cpa, prog,status) VALUES (?,?,?,?,?,?)";

ps = dbconn.prepareStatement(sql);

ps.setString(1,StrName);
ps.setString(2,StrMatrix);
ps.setString(3,StrIC);
ps.setfloat(4,StrCpa);
ps.setint(5,StrProg);
pc.setint(6,status);
ps.executeUpdate();

response.sendredirect("login.jsp");

}
results.close();
ps.close();
dbconn.close();


%>



lepas tu error dia lak ni yang kuar:

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

exception

org.apache.jasper.JasperException: /projek/checkRegister2.jsp(2,4) Invalid directive
org.apache.jasper.compiler.DefaultErrorHandler.jsp Error(DefaultErrorHandler.java:83)
org.apache.jasper.compiler.ErrorDispatcher.dispatc h(ErrorDispatcher.java:402)
org.apache.jasper.compiler.ErrorDispatcher.jspErro r(ErrorDispatcher.java:126)
org.apache.jasper.compiler.Parser.parseDirective(P arser.java:546)
org.apache.jasper.compiler.Parser.parseElements(Pa rser.java:1577)
org.apache.jasper.compiler.Parser.parse(Parser.jav a:171)
org.apache.jasper.compiler.ParserController.parse( ParserController.java:247)
org.apache.jasper.compiler.ParserController.parse( ParserController.java:149)
org.apache.jasper.compiler.ParserController.parse( ParserController.java:135)
org.apache.jasper.compiler.Compiler.generateJava(C ompiler.java:237)
org.apache.jasper.compiler.Compiler.compile(Compil er.java:456)
org.apache.jasper.compiler.Compiler.compile(Compil er.java:439)
org.apache.jasper.JspCompilationContext.compile(Js pCompilationContext.java:552)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:291)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet .java:856)


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

__________________
dyda

"org.apache.jasper.JasperException: /projek/checkRegister2.jsp(2,4) Invalid directive"

Check the checkRegister2.jsp for coding error.

__________________
LiewCF | Malaysia Bloggers Forum

hhuhuhuu lcf dah terer dah JSP... good try

__________________
I hate when:

vBulletin Message:
Sorry! The administrator has specified that users can only post one message every 60 seconds

coding saya kasi tu la,coding untuk checkregister2.jsp.page yg seblm 2 just form method ='post'.

__________________
dyda

terer in reading error messages only... because always got error in my code :P

dyda: no idea then... perhaps u need to read the tomcat log file. It will be located under <tomcat installation directory>/logs/

Log file is very helpful to debug

__________________
LiewCF | Malaysia Bloggers Forum

Hi,

On the first line of you file, make sure you have:
Something is wrong with the following bits of code, and your error probably lies within these few lines of code:
How come there is only 1 ? and two setStrings, and why does the setString start from 2? Since i don't really know what the variables StrMatrix or StrIC are, I can't help you edit the code.

Also, with the SQL statement, try using just "register" (without the dot) instead of "register."

Try editing those lines above and see what you get.

still error lagi la...
matrix dan ic dlm db variablenye nvarchar

error yg same gak kuar.
ke something setting yg saya dah miss place.
...please....

__________________
dyda

see log file. see log file. see log file.

__________________
LiewCF | Malaysia Bloggers Forum

cam ne nak baca log file tu...byk sgt dlm tu error yg append2

__________________
dyda

sape2 leh tolong lagi nih....semua page yg buat sql statement berproblem..dan errorr yg kuar semua same cam tu...
ade tak solution yg boleh settlekan problem ni.

__________________
dyda

hurm... x leh edit la... x tau var ape sebenarnya....
test tgk log ler

__________________
I hate when:

vBulletin Message:
Sorry! The administrator has specified that users can only post one message every 60 seconds

dah settle dah..sorry aa..x gi tau dah dapat.
acrtually lib java tu terlupa nak tulis page..
tu pasal dapat error cam tu..

__________________
dyda

:P

__________________
I hate when:

vBulletin Message:
Sorry! The administrator has specified that users can only post one message every 60 seconds