Servlet code to insert Record into Database USING Java Client-Server

/*HTML page to accept data(studid,studentname,rollno)*/

<html>
<body><center><h1>STUDENT INFORMATION</h1>
<form action="http://localhost:8080/DEMO/bcatemp" method="get" name="form1" class="style15" id="form1"><br>
Student ID:<input type="text" name="studid" size="30"><br><br>
Student Name:<input type="text" name="studnm" size="30"><br><br>
Roll no.:<input type="text" name="rno" size="30"><br><br>
<input type="submit" name="reset" value=" Submit " onClick=""><br></center><br>
</form><br>
</center><br>
</body><br>
</html><br>


------------------------------------------------------------------------------
/*bcatemp.java*/
/*Servlet code to insert Record into Database USING Java Client-Server*/
import java.io.*;
import java.net.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class bcatemp extends HttpServlet
{
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{Connection con;
String image;
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
/* TODO output your page here*/
try
{ /*Get Parameter From Html Page*/
String studid=request.getParameter("studid") ;
String studnm=request.getParameter("studnm") ;
String rno=request.getParameter("rno") ;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//JDBC Driver MS Windows XP
con=DriverManager.getConnection("Jdbc:Odbc:test");//Test is DSN Name
Statement st=con.createStatement();
int z=st.executeUpdate("insert into BCASTUDENT_TEMP values('"+ studid +"','"+ studnm +"','"+ rno +"')");
out.println("<h1>Record Inserted Successfully</h1>");
}
catch(Exception ae){
out.println("<td>"+ ae + "</td>");}
}
}
----------------------------------------------------------------------------------

/*web.xml file*/
<web-app>
<servlet>
<servlet-name>sendmessage</servlet-name>
<servlet-class>sendmessage</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>sendmessage</servlet-name>
<url-pattern>/sendmessage</url-pattern>
</servlet-mapping>
</web-app>

Comments

Post a Comment

Popular posts from this blog

Edit/Modify existing PDF using Java(iText)

import java.io.FileOutputStream; import java.io.IOException; import com.itextpdf.text.DocumentException; import com.itextpdf.text.pdf.BaseFont; import com.itextpdf.text.pdf.PdfContentByte; import com.itextpdf.text.pdf.PdfReader; import com.itextpdf.text.pdf.PdfStamper; public class EditExistingPDF { public static void main(String[] args) throws IOException, DocumentException { PdfReader reader = new PdfReader("C:\\signed.pdf"); // input PDF PdfStamper stamper = new PdfStamper(reader,new FileOutputStream( "C:\\test.pdf")); // output PDF BaseFont bf = BaseFont.createFont(BaseFont.HELVETICA, BaseFont.CP1252, BaseFont.NOT_EMBEDDED); // set font // loop on pages (1-based) for (int i = 1; i // get object for writing over the existing content; // you can also use getUnderContent for writing in the bottom // layer PdfContentByte over = stamper.getOverContent(i); // write text over.beginText(); over.setFontAndSize(bf, 10); // set font and size over....
Read more

Verify Digital Signature in PDF using Java(iText) and cacerts

Jars Files: itext-2.1.7.jar itextpdf-5.4.2.jar bcprov-ext-jdk14-1.47.jar bcprov-1.39.jar ---------------------------------------------------------------- import java.io.FileNotFoundException; import java.io.IOException; import java.security.KeyStore; import java.security.KeyStoreException; import java.security.NoSuchAlgorithmException; import java.security.SignatureException; import java.security.cert.CertificateException; import java.util.ArrayList; import java.util.Calendar; import java.util.Enumeration; import com.lowagie.text.pdf.AcroFields; import com.lowagie.text.pdf.PdfPKCS7; import com.lowagie.text.pdf.PdfReader; public class VerifySignature { public static void main(String[] args) throws KeyStoreException, NoSuchAlgorithmException, CertificateException, FileNotFoundException, IOException, SignatureException { //loads all the keystore imported in cacerts. To load your certificate from cacerts, first it needs to be imported using k...
Read more

Steps to create SOAP Web service using Eclipse

Image
Step 1 : Go to File -> New -> Dynamic Web Project Step 2 : Enter Project name as “SOAPWebSErvice” as created in below screenshot. Step 3 : Create below packages under src folder: a. com.test.controller b. com.test.model Step 4 : Add Employee.java under package - com.test.model Add EmployeeController.java under package - com.test.controller. Employee.java package com.test.model; public class Employee { private String id; private String name; public String getId() { return id; } public String getName() { return name; } public void setId(String id) { this.id = id; } public void setName(String name) { this.name = name; } } ------------------------------------------------------------------------------------------------------------------ EmployeeController.java package com.test.controller; import com.test.model.Employee; public class EmployeeController { public Employee employee; public Employee setEmployee(...
Read more