Animals & Plants Arts & Entertainment Auto Beauty & Health Books and Literature Business Electronics Engineering & Technology Food & Drink History Hobbies Jobs & Education Law & Government Math People & Society Science Social Studies Sports Travel & Places

JSP and Servlets

JSP (JavaServer Pages) are Java programs encoded within webpages that research and generate pertinent results. Servlets, on the other hand, are objects (programs) that handle requests from users and provide results based on these requests.

500 Questions

JSP and Servlets

MySQL

How do you retrieve table data from mysql to jsp?

Asked by Wiki User

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

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

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

<%@ page language="java" import="java.util.*,java.text.SimpleDateFormat;" pageEncoding="ISO-8859-1"%>

<html>

Calendar currentDate = Calendar.getInstance();

SimpleDateFormat formatter= new SimpleDateFormat("dd/MM/yyyy");

String dateNow = formatter.format(currentDate.getTime());

String nam=(String)request.getAttribute("uname");

String pwd=(String)request.getAttribute("pwd");

request.setAttribute("date",dateNow);

request.setAttribute("nam",nam);

request.setAttribute("pwd",pwd);

System.out.print(nam);

String full_name=request.getParameter("fname");

String cn=request.getParameter("name");

String deg=request.getParameter("designation");

String ema=request.getParameter("email");

String mobile=request.getParameter("mob_no");

String serial=request.getParameter("ser_no");

String department=request.getParameter("deptt_name");

String off_add=request.getParameter("office_address");

String st_name=request.getParameter("state_name");

String spin=request.getParameter("pin");

String phn_no=request.getParameter("phone_no");

String svar1=request.getParameter("srvip");

String svar2=request.getParameter("srvloc");

String svar3=request.getParameter("destport");

String svar4=request.getParameter("descrsrv");

String placen=request.getParameter("place");

String vdate=request.getParameter("date");

String rname=request.getParameter("r_name");

String rdesg=request.getParameter("r_designation");

String remail=request.getParameter("r_email");

String rphone=request.getParameter("r_phone");

String cname=request.getParameter("c_name");

String cdesg=request.getParameter("c_designation");

String cemail=request.getParameter("c_email");

String cphone=request.getParameter("c_phone");

String issby=request.getParameter("captchatext");

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

Connection con = DriverManager.getConnection("jdbc:mysql://localhost/vpn","root","test123");

Statement st= con.createStatement();

int i=st.executeUpdate("insert into vpn_registration(cname,name,designation,email,mobile,serial_no,name_dept,off_add,state,pincode,off_phone,place,rname,rdesign,rmail,rmob,c_name,cdesign,cmail,cmob,issuedby) values ('"+cn+"','"+full_name+"','"+deg+"','"+ema+"','"+mobile+"','"+serial+"','"+department+"','"+off_add+"','"+st_name+"','"+spin+"','"+phn_no+"','"+placen+"','"+rname+"','"+rdesg+"','"+remail+"','"+rphone+"','"+cname+"','"+cdesg+"','"+cemail+"','"+cphone+"','"+issby+"')");

Statement st1= con.createStatement();

int y=st1.executeUpdate("insert into server_details(registration_no,serip,serloc,destport,desc_service) values ('"+svar1+"','"+svar2+"','"+svar3+"','"+svar4+"')");

st.close();

con.close();

<head>

<title>ONLINE VPN REGISTRATION FORM</title>

<style>

a, A:link, a:visited, a:active

{color: #0000aa; text-decoration: none; font-family: Tahoma, Verdana; font-size: 11px}

A:hover

{color: #ff0000; text-decoration: none; font-family: Tahoma, Verdana; font-size: 11px}

p, tr, td, ul, li

{color: #000000; font-family: Tahoma, Verdana; font-size: 11px}

.header1, h1

{color: #ffffff; background: #4682B4; font-weight: bold; font-family: Tahoma, Verdana; font-size: 13px; margin: 0px; padding-left: 2px; height: 21px}

.ctrl

{font-family: Tahoma, Verdana, sans-serif; font-size: 12px; width: 100%;}

.btnform

{border: 0px; font-family: tahoma, verdana; font-size: 12px; background-color: #DBEAF5; width: 100%; height:18px; text-align: center; cursor: hand;}

.btn

{background-color: #DBEAF5; padding: 0px;}

textarea, select,input

{font: 9px Verdana, arial, helvetica, sans-serif; background-color: #DBEAF5;}

</style>

function addRow(tableID) {

var table = document.getElementById(tableID);

var rowCount = table.rows.length;

if(rowCount>6)

{

alert("Cannot add more than 6 rows.");

return false;

}

document.getElementById("rowlength").value=rowCount;

var row = table.insertRow(rowCount);

var counts=rowCount-1;

var cell0 = row.insertCell(0);

var chk = document.createElement("input");

chk.type = "checkbox";

chk.name="chk"+counts+"";

cell0.appendChild(chk);

var cell1 = row.insertCell(1);

var srvip = document.createElement("input");

srvip.name="srvip"+counts+"";

srvip.id="srvip"+counts+"";

srvip.className='ctrl';

srvip.type = "text";

//srvip.onClick="hello()";

cell1.appendChild(srvip);

var cell2 = row.insertCell(2);

var srvloc = document.createElement("input");

srvloc.type = "text";

srvloc.className='ctrl';

srvloc.name="srvloc"+counts+"";

cell2.appendChild(srvloc);

var cell3 = row.insertCell(3);

var destport = document.createElement("input");

destport.type = "text";

destport.className='ctrl';

destport.name="destport"+counts+"";

destport.id="destport"+counts+"";

cell3.appendChild(destport);

var cell4 = row.insertCell(4);

var descrsrv = document.createElement("input");

descrsrv.type = "text";

descrsrv.className='ctrl';

descrsrv.name="descrsrv"+counts+"";

cell4.appendChild(descrsrv);

}

</SCRIPT>

function clearFields()

{

document.cmaForm.reset();

}

</script>

function deleteRow(tableID) {

try {

var table = document.getElementById(tableID);

var rowCount = table.rows.length;

for(var i=0; i<rowCount; i++) {

var row = table.rows[i];

var chkbox = row.cells[0].childNodes[0];

if(null != chkbox && true == chkbox.checked) {

if(rowCount <= 2) {

alert("Cannot delete all the rows.");

break;

}

table.deleteRow(i);

rowCount--;

i--;

}

}catch(e) {

alert(e);

}

</SCRIPT>

function setid()

{

var x=document.cmaForm.rowlength.value;

//alert(x);

document.cmaForm.id=x;

return true;

}

</script>

</head>

<tr>

</tr>

</table>

<tr>

<td class="header1" nowrap>NIC VPN Services<img src="img/line9.gif" width="10" height="1" border="0"></td>

</tr>

<tr>

<td colspan="7" align="center"><font size="2">National Infomatics Centre <br> Department of Information Technology<br>Ministry of Communications and Information Technology

<br> Government of India</font></td>

</tr>

<td colspan="7" align="center"><font size="2" color="white"><b>VPN Registration Form</b></font></td>

</tr>

<td colspan="7"><b>Note:</b>  Fields marked<font size="2" color="red"> * </font>are mandatory.

</td>

</tr>

<logic:present name="fail">

</logic:present>

<td colspan="7" align="center"><b>SECTION I : SUBSCRIBER INFORMATION</b></td>

</tr>

<td colspan="7"> 1.1 Personal Details:</td>

</tr>

<td colspan="1" width="5%"> Common Name:</td>

<td colspan="5" width="50%"><input type="text" name="name" value="<%= request.getParameter("uname")%>" readonly="readonly"class="ctrl"></td>

</tr>

<td width="15%"> Designation:<font size="2" color="red">* </font></td>

<td colspan="1" width="5%"> E-mail Address:<font size="2" color="red">* </font></td>

</tr>

<td width="15%"> Mobile:<font size="2" color="red">* </font></td>

<td colspan="1" width="5%"> DC Serial No.:</td>

<td colspan="5" width="50%"><input type="text" name="ser_no" value="<%= request.getParameter("pwd")%>" readonly="readonly"class="ctrl" size="10"></td>

</tr>

<td colspan="7"> 1.2 Official Address:</td>

</tr>

<td> Name of the Department:<font size="2" color="red">* </font></td>

</tr>

<td > Office Address:<font size="2" color="red">* </font></td>

</tr>

<td width="15%"> State:</td>

</tr>

<td width="15%" > Office Telephone:</td>

</tr>

<td colspan="7"> 1.3 List of Server to access through VPN:<font size="2" color="red">* </font></td>

</tr>

<TR>

<TD width="150">IP Address of the Server</TD>

<TD width="196">Location of the Server</TD>

<TD width="167">Destination Port</TD>

<TD width="162">Website/URL of Servers</TD>

</TR>

<TR>

<TD>

</TD>

</TR>

</TABLE>

</td>

</tr>

</tr>

<td colspan="7" align="center"><font size="2"><u>DECLARATION</u></font></td>

</tr>

<td colspan="7">I hereby declare that<br>     1. The information provided is correct.<br>

     2. Is responsible for the safety of the Digital Certificate, PIN, Username and Password issued for accessing VPN Service.<br>

     3. I undertake to surrender the VPN account and Digital certificate on transfer / leaving the division.<br>

     4. The certificate and VPN account are issued will be used only for accessing the NIC VPN Service as per the list provided in 1.3.<br>

     5. Will not indulge in any activity and no attempt will be made to gain unauthorized access to other NIC Websites and facilities.<br>

     6. I am responsible for the content/ data uploaded in the servers through VPN connection.<br>

 I have read the terms and conditions of NIC VPN Services and will comply with. If at a later stage any information is found to be incorrect or non-compliance with the terms and conditions will result in the cancellation of the DC issued by NIC for NIC VPN service.</td>

</tr>

<td width="15%"> Place:<font size="2" color="red">* </font></td>

</tr>

<td colspan="7" align="center"><b>SECTION II : RECOMMENDATION</b></td>

</tr>

<td colspan="7"> This is to certify that the person as identified in SECTION-I has provided correct information and is authorized on behalf of the organization to update and access servers listed in 1.3.<br>

 I shall intimate NIC VPN Division to deactivate the account when the person is transferred / relived from responsibility for which the VPN account and digital certificate is issued.

</td>

</tr>

<td colspan="7"> 2.1 Verification by Recommending/Reporting/Head of Office</td>

</tr>

<td colspan="1" width="5%"> Designation:<font size="2" color="red">* </font></td>

</tr>

<td width="15%"> E-mail Address:<font size="2" color="red">* </font></td>

<td colspan="1" width="5%"> Contact No.:<font size="2" color="red">* </font></td>

</tr>

<td colspan="7" align="center"><b>SECTION III : Verification by NIC-Coordinator</b></td>

</tr>

<td colspan="7" align="left" ><a href="http://webservices.nic.in/webcoord.aspx" target="blank"> <u>  Please refer the authorised NIC Web Co-ordinator</a></u></td>

</tr>

<td colspan="7"> User Category: Free / Paid<br>

 If free enclose the copy of the approval.<br>

 If paid, then confirm the period for which payment is made: From:.................To:.................<br>

 Project No. ......................................................................................................................<br>

 The web sites mentioned at 1.3 (a) in SECTION-I am correct. The subscriber is the authorized person to update this web site and require VPN Services. Permission may give for the same.<br>

 I shall intimate NIC VPN division to deactivate the account when the person is transferred / relived from responsibility for which the VPN account and digital certificate is issued.

</td>

</tr>

<td colspan="1" width="5%"> Designation:<font size="2" color="red">* </font></td>

</tr>

<td width="15%"> E-mail Address:<font size="2" color="red">* </font></td>

<td colspan="1" width="5%"> Contact No.:<font size="2" color="red">* </font></td>

</tr>

<td width="15%"> Enter the Letters:<font size="2" color="red">* </font></td>

</tr>

</table></td></tr></table>

</td>

</tr>

<tr>

<tr>

</tr>

</table>

</td>

</tr>

</table>

</form>

<td align="center"><font face="Tahoma">For any query please contact VPN Support:</font><font color="blue" face="Tahoma">vpnsupport[at]nic[dot]in</font>

<br>

<font face="Tahoma">Contact No:</font> <font color="blue" face="Tahoma">+91-11-24305391 / 99</font></td>

</tr>

<logic:present name="fail">

${fail}

</logic:present>

</table>

</body>

</html>

JSP and Servlets

What is a JSP implicit object?

Asked by Wiki User

Database Programming

JSP and Servlets

How do you get the image file from the database with JSP?

Asked by Wiki User

You can retrieve an image file from a database in JSP by writing a servlet that fetches the image from the database and streams it to the JSP page. The servlet will set the content type to "image/jpeg" or the appropriate image format and write the image data to the response output stream. In the JSP page, you can then display the image by setting the source attribute of the img tag to the servlet URL.

JSP and Servlets

How do you delete a column in jsp page?

Asked by Wiki User

JSP and Servlets

How jsp is translated to servlet?

Asked by Wiki User

JSP and Servlets

What are the different jsp tags?

Asked by Wiki User

JSP and Servlets

Why will a container impload?

Asked by Wiki User

JSP and Servlets

Write a jsp program to find Maximum of 3 numbers?

Asked by Wiki User

JSP and Servlets

What is j2ee and jsp?

Asked by Wiki User

JSP and Servlets

How do you update data in a database using servlet?

Asked by Wiki User

JSP and Servlets

How do you create a drop-down list with jsp?

Asked by Wiki User

JSP and Servlets

Why doesn't a servlet have a main method in it?

Asked by Wiki User

JSP and Servlets

How To

How to retrieve data from jsp to servlet?

Asked by Wiki User

JSP and Servlets

Is the JSP tutorial easy to follow and understand?

Asked by Wiki User

Yes, the JSP tutorial is easy to follow and understand. It tells you what it is doing from start to finish. When the JSP life cycle is complete a screen will pop up and they are finished.

JSP and Servlets

How get protocol dependent services in servlet class?

Asked by Wiki User

JSP and Servlets

What is javax servlet?

Asked by Wiki User

A Servlet is a Java programming language class used to extend the capabilities of a server. Although servlets can respond to any types of requests, they are commonly used to extend the applications hosted by web servers

A Servlet is a Java-based server-side web technology.

The javax.servlet package contains a number of classes and interfaces that describe and define the contracts between a servlet class and the runtime environment provided for an instance of such a class by a conforming servlet container.