Scribd
Upload
5 views21 pages

VPN and Management System Login Forms

The document contains a series of HTML and JSP code snippets for a web application that includes login forms, registration forms, and student lists for various courses. It utilizes JDBC for database connectivity to manage user authentication and display student information based on course timings. The application also includes client-side validation for the enquiry form to ensure that all required fields are filled out before submission.

Uploaded by

kiran.negi.1912
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views21 pages

VPN and Management System Login Forms

The document contains a series of HTML and JSP code snippets for a web application that includes login forms, registration forms, and student lists for various courses. It utilizes JDBC for database connectivity to manage user authentication and display student information based on course timings. The application also includes client-side validation for the enquiry form to ensure that all required fields are filled out before submission.

Uploaded by

kiran.negi.1912
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

SOURCE CODE:

MAIN
<html>
<body bgcolor="pink">
<form method="post" action="[Link]">
<center>
<h3>VIRTUAL PRIVATE NETWORK </h3>
<BR>
<h2>Login Form</h2>
<br>
<table cellspacing="30">
<tr><td>Login</td><td><input type="text" name="user"></td></tr></td></tr>
<tr><td>Password</td><td><input type="password" name="pass"></td></tr>
<tr><td><input type="submit" value="Submit"></td><td><input type="reset" value="Reset"><tr>
</table> </center> </form> </body> </html>
CERTIFICATE
<%@page import="[Link].*"%>
<% String user=[Link]("user");
String pass=[Link]("pass");
String id;
[Link](pass);
Connection con=null;
PreparedStatement pr=null;
try { [Link]("[Link]");
con=[Link]("jdbc:odbc:central");
pr=[Link]("select cid from cert where pwd=? and name=?");
[Link](1,pass);
[Link](2,user);
ResultSet rs=[Link]();
if([Link]())
{ String cid = [Link](1);
[Link](cid);
%>
<jsp:forward page="[Link]?id=<>" />
<% [Link]([Link](1)); }
[Link](); }
catch(Exception ae)
{ [Link]("Exception in Login form" +ae); } %>
</body>
</html> CID <html> <head> cer </head>
<body> certificate
<% String id=[Link]("id");
[Link](id); %>
<form method="get" action="[Link]" > <input type="text" value="<%= id %>" >
<input type="submit" value=" ok " > </form> </body>
</html>
LOGIN
<html> <body bgcolor="Peachpuff">
<form method="post" action="[Link]">
<center> <h3>CENTRALIZED MANAGEMENT SYSTEM </h3> <BR>
<h2>Login Form</h2> <br>
<table cellspacing="30"> <tr><td>Login</td><td><select name="login">
<option value="Administrator">Administrator</option>
<option value="Marketing">Marketing</option> <option value="Faculty">Faculty</option>
</select></td></tr>
<tr><td>Password</td><td><input type="password" name="pass"></td></tr>
<tr><td><input type="submit" value="Submit"></td><td><input type="reset" value="Reset"><tr>
</table> </center> </body>
</html>
[Link]
<%@page import="[Link].*"%>
<% String log=[Link]("login"); String pass=[Link]("pass");
Connection con=null; PreparedStatement pr=null;
try { [Link]("[Link]");
con=[Link]("jdbc:odbc:central");
pr=[Link]("select username from login1 where password=?");
[Link](1,pass); ResultSet rs=[Link](); [Link]();
[Link]([Link](1)); [Link](log);
String s1=[Link](1); [Link]("before");
if([Link](log)) { [Link]("a"); %>
<jsp:forward page="[Link]"/> }
<% else { [Link]("b"); %>
<jsp:forward page="[Link]"/> <% }
[Link](); }
catch(Exception ae)
{[Link]("Exception in Login form" +ae); } %>
</body> </html>
ADMIN
<html>
<body bgcolor="Peachpuff" link="blue" alink="black">
<input type=button name=b1>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font size=5><b>Office</b></font>
<ul> <font size=4>
<li><b><a href="[Link]">Enquiry form</a></b><br></li><br>
<li><b><a href="[Link]">Registration form</a></b><br></li> <br>
<li><b><a href="[Link]">Course and fees details</a></b><br></li> <br>
<li><b><a href="[Link]">Salary details</a></b><br></li> </font> </ul> <br>
<input type=button name=b2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font size=5><b>Staff</b></font>
<ul> <font size=4>
<li><b><a href="[Link]">Attendance</a></b><br></li> <br>
</font> </ul> </body> </html>
REGISTRATION
<%@page import="[Link].*"%> <% String log=[Link]("login");
String pass=[Link]("pass"); Connection con=null; PreparedStatement pr=null; </body> </html>
REGISTRATION 1
<%@page import="[Link].*"%> <html> <body bgcolor="Peachpuff">
<CENTER><B><h3> J2EE BATCH I STUDENT LIST </H3> <H4>TIME [Link] TO [Link]
</H4></B></CENTER> <CENTER> <table BORDER="1" cellpadding="10">
<tr><td>RegNo</td><td>Name</td><td>Course</td><tr> <%
try{ Connection con=null; Statement stat=null; ResultSet rs=null;
[Link]("[Link]");
con=[Link]("jdbc:odbc:central"); stat=[Link]();
rs=[Link]("select regno,name,coursename from registration where coursename='J2EE' and
batchtimings='10am to 12pm'");
while([Link]()) { %>
<tr><td><%=[Link](1)%></td> <td><%=[Link](2)%></td> <td><%=[Link](3)%></td></tr>
<% } } catch(Exception e) { [Link]("error"); } %> </table> </body> </html>

REGISTRATION 2
<%@page import="[Link].*"%> <html> <body bgcolor="Peachpuff">
<CENTER><B><h3> J2EE BATCH II STUDENT LIST </H3> <H4>TIME [Link] TO [Link]
</H4></B></CENTER> <CENTER> <table BORDER="1" cellpadding="10">
<tr><td>RegNo</td><td>Name</td><td>Course</td><tr> <% </html>

REGISTRATION 3
<%@page import="[Link].*"%> <html> <body bgcolor="Peachpuff"> <CENTER><B><h3> J2EE BATCH
III STUDENT LIST </H3> <H4>TIME [Link] TO [Link] </H4></B></CENTER> <CENTER>
<table BORDER="1" cellpadding="10">
<tr><td>RegNo</td><td>Name</td><td>Course</td><tr> <%
try{Connection con=null; Statement stat=null; ResultSet rs=null;
[Link]("[Link]");
con=[Link]("jdbc:odbc:central"); stat=[Link]();
rs=[Link]("select regno,name,coursename from registration where coursename='J2EE' and
batchtimings='2pm to 4pm'");
while([Link]()) { %>
<tr><td><%=[Link](1)%></td> <td><%=[Link](2)%></td>
<td><%=[Link](3)%></td></tr> <% } }
catch(Exception e) { [Link]("error"); } %> </table> </body> </html>

REGISTRATION 4
<%@page import="[Link].*"%>
<html>
<body bgcolor="Peachpuff">
<CENTER><B><h3> J2EE BATCH IV STUDENT LIST </H3>
<H4>TIME [Link] TO [Link] </H4></B></CENTER>
<CENTER>
</html>

REGISTRATION 5
<%@page import="[Link].*"%>
<html>
<body bgcolor="Peachpuff">
<CENTER><B><h3> SOFTWARE TESTING BATCH I STUDENT LIST </H3>
<H4>TIME [Link] TO [Link] </H4></B></CENTER>
<CENTER>
<table BORDER="1" cellpadding="10">
<tr><td>RegNo</td><td>Name</td><td>Course</td><tr>
<%
try
{
Connection con=null;
Statement stat=null;
ResultSet rs=null;
[Link]("[Link]");
con=[Link]("jdbc:odbc:central");
stat=[Link]();
rs=[Link]("select regno,name,coursename from registration where coursename='Software
Testing' and batchtimings='10am to 12pm'");

while([Link]())
{
%>
<tr><td><%=[Link](1)%></td>
<td><%=[Link](2)%></td>
<td><%=[Link](3)%></td></tr>
<%
}
}
catch(Exception e)
{
[Link]("error");
}
%>
</table>
</body>
</html>

REGISTRATION 6
<%@page import="[Link].*"%>
<html>
<body bgcolor="Peachpuff">
<CENTER><B><h3> SOFTWARE TESTING BATCH II STUDENT LIST </H3>
<H4>TIME [Link] TO [Link] </H4></B></CENTER>
<CENTER>
<table BORDER="1" cellpadding="10">

<tr><td>RegNo</td><td>Name</td><td>Course</td><tr>
<%
try
{
Connection con=null;
Statement stat=null;
ResultSet rs=null;
[Link]("[Link]");
con=[Link]("jdbc:odbc:central");
stat=[Link]();
rs=[Link]("select regno,name,coursename from registration where coursename='Software
Testing' and batchtimings='12pm to 2pm'");
while([Link]())
{
%>
<tr><td><%=[Link](1)%></td>
<td><%=[Link](2)%></td>
<td><%=[Link](3)%></td></tr>
<%
}
}
catch(Exception e)
{
[Link]("error");
}
%>
</table>
</body>
</html>

REGISTRATION 6
<%@page import="[Link].*"%>
<html>
<body bgcolor="Peachpuff">
<CENTER><B><h3> SOFTWARE TESTING BATCH III STUDENT LIST </H3>
<H4>TIME [Link] TO [Link] </H4></B></CENTER>
<CENTER>
<table BORDER="1" cellpadding="10">

<tr><td>RegNo</td><td>Name</td><td>Course</td><tr>
<%
try
{
Connection con=null;
Statement stat=null;
ResultSet rs=null;
[Link]("[Link]");
con=[Link]("jdbc:odbc:central");
stat=[Link]();
rs=[Link]("select regno,name,coursename from registration where coursename='Software
Testing' and batchtimings='2pm to 4pm'");

while([Link]())
{
%>
<tr><td><%=[Link](1)%></td>
<td><%=[Link](2)%></td>
<td><%=[Link](3)%></td></tr>
<%
}
}
catch(Exception e)
{
[Link]("error");
}
%>
</table>
</body>
</html>

REGISTRATION 7
<%@page import="[Link].*"%>
<html>
<body bgcolor="Peachpuff">
<CENTER><B><h3> SOFTWARE TESTING BATCH IV STUDENT LIST </H3>
<H4>TIME [Link] TO [Link] </H4></B></CENTER>
<CENTER>
<table BORDER="1" cellpadding="10">

<tr><td>RegNo</td><td>Name</td><td>Course</td><tr>
<%
try
{
Connection con=null;
Statement stat=null;
ResultSet rs=null;
[Link]("[Link]");
con=[Link]("jdbc:odbc:central");
stat=[Link]();
rs=[Link]("select regno,name,coursename from registration where coursename='Software
Testing' and batchtimings='4pm to 6pm'");
while([Link]())
{
%>
<tr><td><%=[Link](1)%></td>
<td><%=[Link](2)%></td>
<td><%=[Link](3)%></td></tr>
<%
}
}
catch(Exception e)
{
[Link]("error");
}
%>

ENQUIRY
<html>
<body bgcolor="Peachpuff">
<SCRIPT LANGUAGE="JavaScript">
function valid(form)
{
var field1=[Link];
var field2=[Link];
var field3=[Link];
var field4=[Link];
var field5=[Link];
var field6=[Link];
var field7=[Link];
var field8=[Link];
var field9=[Link];
name=[Link];
address=[Link];
phone=[Link];
mphone=[Link];
email=[Link];
qualification=[Link];
regcourse=[Link];
timings=[Link];
reference=[Link];
alert("hai1");
if([Link]==0)
{
alert("Name cannot be blank");
[Link]();
return false;
}
else if([Link]==0)
{
alert("Address cannot be blank");
[Link]();
return false;
}

else if([Link]==0)
{
alert("Phone cannot be blank");
[Link]();
return false;
}
else if([Link]==0)
{
alert("MobilePhone cannot be blank");
[Link]();
return false;
}
else if([Link]==0)
{
alert("email cannot be blank");
[Link]();
return false;
}
else if([Link]==0)
{
alert("qualification cannot be blank");
[Link]();
return false;
}
else if([Link]==0)
{
alert("regcourse cannot be blank");
[Link]();
return false;
}
else if([Link]==0)
{
alert("timings cannot be blank");
[Link]();
return false;
}
else if([Link]==0)
{
alert("reference cannot be blank");
[Link]();
return false;
}
}
</SCRIPT>

<form onsubmit="return valid(this)" method="post" action="[Link]">


<center>
<h2><center><u>Enquiry form</u></center></h2>

<table border=0>
<tr>
<td>
<table border=0>
<tr>
<td><h4>Name:</h4></td><td><input type=text name="name"></td>
<tr>
<tr>
<td><h4>Address:</h4></td><td><textarea name="address" rows=3
cols=25></textarea></td>
<tr>
<tr>
<td><h4>Phone:</h4></td><td><input type=text name="phone"></td>
<tr>
<tr>
<td><h4>Mobile Phone:</h4></td><td><input type=text name="mphone"></td>
<tr>
<tr>
<td><h4>EMail:</h4></td><td><input type=text name="email"></td>
<tr>
</table>
</td>
<td valign=top>
<table border=0>
<tr>
<td><h4>Qualification:</h4></td><td><input type=text name="qualification"></td>
<tr>
<tr>
<td><h4>Course :</h4></td><td><select name="regcourse">
<option value="J2EE">J2EE</option>
<option value="Software Testing">Software Testing</option>
<option value="Call Center">Call Center</option>
<option value="Networking">Networking</option>
</select> </td>
<tr>
<tr>
<td><h4>Timings:</h4></td><td><select name="timings">
<option value="10 AM to 12 AM">10 am to 12 am</option>
<option value="1 PM to 3 PM">1 pm to 3
pm</option>
<option value="3 PM to 5 PM">3 pm to 5
pm</option>
<option value="5 PM to 7 PM">5 pm to 7
pm</option>
</select></td>
<tr>
<tr>
<td><h4>Reference:</h4></td><td><input type=text name="reference"></td>
<tr>
</table>
</td>
</tr>
</table>
</center>
<p><center>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit"
value="Submit">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="reset" value="Reset"></center></p>
</p>

</form>
</body>
</html>

STAFF ATTENDANCE

<html>
<body bgcolor="Peachpuff">
<SCRIPT LANGUAGE="JavaScript">
function valid(form)
{
var field1=[Link];
var field2=[Link];
number=[Link];
ename=[Link];
if ([Link]==0)
{
alert("enumber cannot be blank");
[Link]();
return false;
}
else if([Link]==0)
{
alert("ename cannot be blank");
[Link]();
return false;
}
}
</SCRIPT>
<form onsubmit="return valid(this)" method="post" action="[Link]">
<body>
<center>
<br>
<br>
<h2>Staff Attendance Form</h2>
<br>
<br>
<tr>
<tr>
<tr>
<table>
<tr><td>Employee Number</td><td><input type="text" name="number" size=20></td></tr>
<tr>
<tr>
<tr>
<tr><td>Employee Name</td><td><input type="text" name="ename" size="20"></td></tr>
<tr><tr>
<tr>

<tr>

<tr>
<tr>
<tr>
</table>
<center>
<br>

<input type="submit" value="Register">&nbsp&nbsp&nbsp&nbsp&nbsp<input type="reset" value="Reset">


</center>
</form>
</body>
</html>

STAFF [Link]
<%@page import="[Link].*"%>
<jsp:useBean id="st" class="[Link]"/>

<%
String empid=[Link]("number");
String name=[Link]("ename");

[Link](empid,name);
[Link]();

[Link]("Inserted successfully");
%>

ADD CLIENT
<html>
<body bgcolor="Peachpuff">
<SCRIPT LANGUAGE="JavaScript">
function valid(form)
{
var field1=[Link];
var field2=[Link];
var field3=[Link];
var field4=[Link];
var field5=[Link];
company=[Link];
address=[Link];
phone=[Link];
mail=[Link];
person=[Link];
if ([Link]==0)
{
alert("Company cannot be blank");
[Link]();
return false;
}
else if([Link]==0)
{
alert("Address cannot be blank");
[Link]();
return false;
}
else if([Link]==0)
{
alert("Phone cannot be blank");
[Link]();
return false;
}
else if([Link]==0)
{
alert("Mail cannot be blank");
[Link]();
return false;
}
else if([Link]==0)
{
alert("Person cannot be blank");
[Link]();
return false;
}
}
</SCRIPT>
<form onsubmit="return valid(this)" method="post" action="[Link]">
<h2><center>Add Client</center></h2>
<center>
<table cellspacing="20">
<tr>
<td>Enter the Company Name</td>
<td><input type="text" name="company"></td>
</tr>
<tr>
<td>Enter the Address</td>
<td><input type="text" name="address"></td>
</tr>
<tr>
<td>Enter the Phone Number</td>
<td><input type="text" name="phone"></td>
</tr>
<tr>
<td>Enter the MailId</td>
<td><input type="text" name="mail"></td>
</tr>
<tr>
<td>Enter the Contact Person</td>
<td><input type="text" name="person"></td>
</tr>
<tr>
<td><input type="submit" value="submit"></td>
<td><input type="reset" value="reset"></td>
</tr>
</table>
</center>
</form>
</body>
</html>

ADD [Link]
<%@page import="[Link].*"%>

<jsp:useBean id="val" class="[Link]"/>


<%

String company=[Link]("company");
String address=[Link]("address");
String phone=[Link]("phone");
String mail=[Link]("mail");
String person=[Link]("person");

[Link](company,address,phone,mail,person);
[Link]();

[Link]("inserted successfully");

%>

CLIENT [Link]
<%@page import="[Link].*"%>
<html>
<body bgcolor="Peachpuff">
<h2><center><u>Client Details</u></center></h2>
<form name=booksdet>
<center>
<table border=1 cellpadding=5>
<tr>
<td>Company</td>
<td>Address</td>
<td>Phone</td>
<td>MailID</td>
<td>Contact Person</td>
</tr>
<%
try
{
[Link]("[Link]");
Connection con=[Link]("jdbc:odbc:central");
PreparedStatement pr=[Link]("select * from ClientDetails");
ResultSet rs=[Link]();
while([Link]())
{
%>
<tr>
<td>
<%=[Link](1)%>
</td>
<td>
<%=[Link](2)%>
</td>
<td>
<%=[Link](3)%>
</td>
<td>
<%=[Link](4)%>
</td>
<td>
<%=[Link](5)%>
</td>
</tr>
<%
}
}
catch(Exception e)
{
[Link]("error"+ e);
}

%>

</table>
</center>
</form>
</body>
</html>

ADD PLACEMENT
<%@page import="[Link].*"%>
<jsp:useBean id="val" class="[Link]"/>

<%
String name=[Link]("name");
String placement=[Link]("placement");
String company=[Link]("company");
String person=[Link]("person");
String date=[Link]("date");

[Link](name,placement,company,person,date);
[Link]();

[Link]("inserted successfully");

%>
COURSE DETAILS
<html>
<body bgcolor="Peachpuff">
<h2><b><center>Training offered in various fields</center></b></h2>
<form name=coursedet>
<center>
<table border=0>
<tr>
<td><h2><a href="[Link]">J2EE</a></h2></td>
</tr>
<tr>
<td><h2><a href="[Link]">Call
Center</a></h2></td>
</tr>
<tr>
<td><h2><a href="[Link]">Software
Testing</a></h2></td>
</tr>
<tr>
<td><h2><a
href="[Link]">Networking</a></h2></td>
</tr>
</table>
</center>
</form>
</body>
</html>
MARKETING
<html>
<body bgcolor="Peachpuff" link="blue" alink="black">
<input type=button name=b1>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font
size=5><b>Marketing</b></font>
<ul>
<font size=4>
<li><b><a href="[Link]"> AddClient</a></b></li>
<li><b><a href="[Link]" target="main">ClientList</a></b></li>
<li><b><a href="[Link]">Add Placement</a></b></li>
</font>
</ul>
</body>
</html>
PROJECT
<html>
<body bgcolor="Peachpuff" link="blue" alink="black">
<font size=5><b><u>Projects</u></font>
<form name=projectdet1>
<center>
<table border=0>
<tr>
<td><h2>FireWall and IDs</h2></td>
</tr>
<tr>
<td><h2>MultiThreaded System</h2></td>
</tr>
<tr>
<td><h2>Intranet Group Chat</h2></td>
</tr>
<tr>
<td><h2>Mailing System in Jsp</h2></td>
</tr>
<tr>
<td><h2>Voice Conferencing</h2></td>
</tr>
<tr>
<td><h2>IP Chaining & Tunnelling</h2></td>
</tr>
<tr>
<td><h2>Help Desk Management</h2></td>
</tr>
<tr>
<td><h2>Voice Over Internet Protocol</h2></td>
</tr>
</table>
</center>
</form>
</body>
</html>
J2E
<html>
<body bgcolor="Peachpuff">
<h1><center><u>J2EE Training</center></h1>
<h2><center><u>Batch Timings</u></center></h2>
<form name=batchdet>
<center>
<table border=1 cellpadding=5>
<tr>
<th><font size=5><center>Timing</center></font></th>
<th><font size=5><center>Batch No</center></font></th>
</tr>
<tr>
<td><font size=4><b><center>10:00AM to 12:00PM</center></b></font></td>
<td><font size=4><b><center><a href="[Link]">Batch 1</a></center></b></font></td>
</tr>
<tr>
<td><font size=4><b><center>12:00PM to 2:00PM</center></b></font></td>
<td><font size=4><b><center><a href="[Link]">Batch 2</a></center></b></font></td>
</tr>
<tr>
<td><font size=4><b><center>2:00PM to 4:00PM</center></b></font></td>
<td><font size=4><b><center><a href="[Link]">Batch 3</a></center></b></font></td>
</tr>
<tr>
<td><font size=4><b><center>4:00PM to 6:00PM</center></b></font></td>
<td><font size=4><b><center><a href="[Link]">Batch 4</a></center></b></font></td>
</tr>
</table>
</center>
</form>
</body>
</html>
REGISTRATION-J2EE
<%@page import="[Link].*"%>
<html>
<body bgcolor="Peachpuff">
<CENTER><B><h3> NET WORKING BATCH IV STUDENT LIST </H3>
<H4>TIME [Link] TO [Link] </H4></B></CENTER>
<CENTER>
<table BORDER="1" cellpadding="10">

<tr><td>RegNo</td><td>Name</td><td>Course</td><tr>
<%
try
{
Connection con=null;
Statement stat=null;
ResultSet rs=null;
[Link]("[Link]");
con=[Link]("jdbc:odbc:central");
stat=[Link]();
rs=[Link]("select regno,name,coursename from registration where
coursename='Networking' and batchtimings='4pm to 6pm'");

while([Link]())
{
%>
<tr><td><%=[Link](1)%></td>
<td><%=[Link](2)%></td>
<td><%=[Link](3)%></td></tr>
<%
}
}
catch(Exception e)
{
[Link]("error");
}
%>
</table>
</body>
</html>
ADD [Link]
package centre;

import [Link].*;
import [Link].*;
import [Link].*;
public class addclient

{
public Connection con=null;
public ResultSet rs=null;
public Statement st=null;
public String Company,Address,Phone,Mail,Person,Query;

public void set(String Company,String Address,String Phone,String Mail,String Person)


{

[Link]=Company;
[Link]=Address;
[Link]=Phone;
[Link]=Mail;
[Link]=Person;
try
{
[Link]("[Link]");
con=[Link]("jdbc:odbc:central");
}catch(Exception e){}
}

public void insert()


{
try
{
Query="insert into ClientDetails values(' "+Company+" ',' "+Address+" ',' "+Phone+" ',' "+Mail+" ','
"+Person+" ')";
st=[Link]();
[Link](Query);
}catch(Exception e){}
}
}

[Link]
package centre;

import [Link].*;
import [Link].*;
import [Link].*;
public class dbsalary

{
public Connection con=null;
public ResultSet rs=null;
public Statement st=null;
public String empno,empname,doj,pay,Query;

public void set(String empno,String empname,String doj,String pay)


{

[Link]=empno;
[Link]=empname;
[Link]=doj;
[Link]=pay;

try
{
[Link]("[Link]");
con=[Link]("jdbc:odbc:central");
}catch(Exception e){}
}

public void insert()


{
try
{
Query="insert into salarydetails values(' "+empno+" ',' "+empname+" ',' "+doj+" ',' "+pay+" ')";
st=[Link]();
[Link](Query);
}catch(Exception e){}
}
}

[Link]
package centre;

import [Link].*;
import [Link].*;
import [Link].*;
public class dbcourse

{
public Connection con=null;
public ResultSet rs=null;
public Statement st=null;
public String courseno,cname,amount,duration,Query;

public void set(String courseno,String cname,String amount,String duration)


{

[Link]=courseno;
[Link]=cname;
[Link]=amount;
[Link]=duration;

try
{
[Link]("[Link]");
con=[Link]("jdbc:odbc:central");
}catch(Exception e){}
}

public void insert()


{
try
{
Query="insert into coursedetails values(' "+courseno+" ',' "+cname+" ',' "+amount+" ',' "+duration+"
')";
st=[Link]();
[Link](Query);
}catch(Exception e){}
}
}

[Link]
package centre;
import [Link].*;
import [Link].*;
import [Link].*;
public class addplacement
{
public Connection con=null;
try
{
[Link]("[Link]");
public void insert()
{
try {Query="insert into PlacementDetails values(' "+name+" ',' "+placement+" ',' "+company+" ',' "+person+"
',' "+dop+" ')";
st=[Link]();
[Link](Query);
}catch(Exception e){}
}
}

You might also like