QuestionAsk Questions?
View Answers
November 25, 2009 at 12:10 PM
Hi Friend,
Try the following code:
<%@page import="java.sql.*"%>
<HTML>
<HEAD>
<SCRIPT LANGUAGE=JavaScript>
var numberOfClicks = 0;
function hello(){
numberOfClicks++;
alert( numberOfClicks );
document.form1.text.value=numberOfClicks;
}
</SCRIPT>
</HEAD>
<BODY>
<FORM NAME="form1" action="countClicks.jsp">
<a href="http://www.roseindia.net"; onclick="hello();" name="link">Click Here</a>
<INPUT TYPE="hidden" name="text" >
<INPUT TYPE="submit" name="myButton" VALUE="Save" >
</FORM>
</BODY>
</HTML>
<%
String value = " ";
if(request.getParameter("text") != null){
value = request.getParameter("text");
int num=Integer.parseInt(value);
System.out.println("value.......................... " + num);
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/register","root","root";);
Statement st = con.createStatement();
int i=st.executeUpdate("insert into click(clicks) values("+num+")");
out.println("Inserted Successfully");
}
catch(Exception e){
System.out.println(e);
}
}
%>
Thanks
Try the following code:
<%@page import="java.sql.*"%>
<HTML>
<HEAD>
<SCRIPT LANGUAGE=JavaScript>
var numberOfClicks = 0;
function hello(){
numberOfClicks++;
alert( numberOfClicks );
document.form1.text.value=numberOfClicks;
}
</SCRIPT>
</HEAD>
<BODY>
<FORM NAME="form1" action="countClicks.jsp">
<a href="http://www.roseindia.net"; onclick="hello();" name="link">Click Here</a>
<INPUT TYPE="hidden" name="text" >
<INPUT TYPE="submit" name="myButton" VALUE="Save" >
</FORM>
</BODY>
</HTML>
<%
String value = " ";
if(request.getParameter("text") != null){
value = request.getParameter("text");
int num=Integer.parseInt(value);
System.out.println("value.......................... " + num);
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/register","root","root";);
Statement st = con.createStatement();
int i=st.executeUpdate("insert into click(clicks) values("+num+")");
out.println("Inserted Successfully");
}
catch(Exception e){
System.out.println(e);
}
}
%>
Thanks
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
