Tags JSP and Servlets MySQL

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

Subjects>Electronics>Computers

How do you retrieve table data from mysql to jsp?

Updated: 10/3/2023

Wiki User

∙ 11y ago

Best Answer

<%@ 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>

Wiki User

∙ 11y ago

This answer is: