dbexample.htm
<html>
<body>
<form method=post action=dbexample.jsp>
type the selectquery here
<input type=text size=60 name='text1'> <br>
<input type=submit>
</form>
</body>
</html>
dbexample.jsp
<html>
<body>
<%@page import="java.sql.*" %>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:telephone"; // an access database registered in odbc
Connection con = DriverManager.getConnection(url);
Statement stm = con.createStatement(); // container for sql
String sql = request.getParameter('text1'); // sql
ResultSet rs = stm.executeQuery ( sql);
while(rs.next())
{
out.println(rs.getString(1)+"<br>"); // name
out.println(rs.getString(2)+"<br>"); // telephone number
out.println("========");
}
%>
</body>
</html>
mailservlet.htm
<html>
<body>
<form method=post action="http://localhost:8080/servlet/mailservlet">
sender <input type=text name=text1><br>
Reciever <input type=text name=text2><br>
Subject <input type=text name=text3><br>
Message <textarea name='area1' rows=5 cols=30> </textarea>
<input type=submit>
</form>
</body>
</html>
mailservlet.java
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import javax.mail.*;
import javax.mail.internet.*; // important
import javax.mail.event.*; // important
import java.net.*;
import java.util.*;
public class servletmail extends HttpServlet
{
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws ServletException, IOException
{
PrintWriter out=response.getWriter();
response.setContentType("text/html");
try
{
Properties props=new Properties();
props.put("mail.smtp.host","localhost"); // 'localhost' for testing
Session session1 = Session.getDefaultInstance(props,null);
String s1 = request.getParameter("text1"); //sender (from)
String s2 = request.getParameter("text2");
String s3 = request.getParameter("text3");
String s4 = request.getParameter("area1");
Message message =new MimeMessage(session1);
message.setFrom(new InternetAddress(s1));
message.setRecipients
(Message.RecipientType.TO,InternetAddress.parse(s2,false));
message.setSubject(s3);
message.setText(s4);
Transport.send(message);
out.println("mail has been sent");
}
catch(Exception ex)
{
System.out.println("ERROR....."+ex);
}
}
}
