Showing posts with label ADVANCE JAVA TECHNOLOGY. Show all posts
Showing posts with label ADVANCE JAVA TECHNOLOGY. Show all posts

Friday, May 24, 2013

Java Servlet that take First_ Name & Last_ Name from the user & generate login-id such that two characters are from First_ Name & four characters are from Last_ Name. Display the generated login-id.



AIM: Write a Servlet that take First_ Name & Last_ Name from the user & generate login-id such that two characters are from First_ Name & four characters are from Last_ Name. Display the generated login-id.
Login.html:
<html>
 <head>
 <title>LoginForm
 </title>
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
 <body>
      <form action="Welcome" method="post">
     First Name:<input type="textbox" name="fn"><br/>    
      Last Name:<input type="textbox" name="ln"> <br/>
   <input type="Submit" value="Submit">
 </form>
</body>
</html>









Welcome.java:
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class Welcome extends HttpServlet
{
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException
    {
      response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        String fn = request.getParameter("fn");
        String ln = request.getParameter("ln");
        int i = ln.length();
        String a = fn.substring(0, 2);
        String b = ln.substring(i-4, i);
        String c = a+b;
        out.println("Login id is:" +c);
    }
}

Output:

Java database application that allow user to insert, update and delete values in a table and manage appropriate exception handling when wrong values are enter



Aim:Write a database application that allow user to insert, update and delete values in a table and manage appropriate exception handling when wrong values are enter.

package bc;
import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
public class database extends javax.swing.JApplet
{
            public void init()
            {
                        setSize(350,250);
                        try
{
                                    java.awt.EventQueue.invokeAndWait(new Runnable()
                                    {
                                                public void run()
                                                {
                                                            initComponents();
                                                }
                                    });
                        }
                        catch (Exception ex)
                        {
                                    ex.printStackTrace();
                        }
            }
private void InsertActionPerformed(java.awt.event.ActionEvent evt)
{                                      
 try
                        {
                                    Connection con=DriverManager.getConnection("jdbc:odbc:DB1");
                                    Statement st= con.createStatement();
String stm="insert into student(Name,Department,Roll_No,Phone_No)     values('"+t1.getText()+"','"+t2.getText()+"','"+t3.getText()+"','"+t4.getText()+"')";
                                    JOptionPane.showMessageDialog(rootPane,"Data is Inserted");
st.executeUpdate(stm);
                        }
                        catch(SQLException sqlEx)
                        {
                                     System.out.println("error");
                        }
             }                                     
    private void deleteActionPerformed(java.awt.event.ActionEvent evt)
   {                                       
  try
            {
                        Connection con=DriverManager.getConnection("jdbc:odbc:DB1");
                        Statement pst= con.createStatement();
                        String stm="delete from student where Roll_No="+t3.getText()+" ";
                        pst.executeUpdate(stm);
 JOptionPane.showMessageDialog(rootPane,"Data is deleted");
             }
            catch(SQLException sqlEx)
            {
                        System.out.println("error");
        }
   }                                     
   private void updateActionPerformed(java.awt.event.ActionEvent evt)
   {                                      
            try
            {
                        Connection con=DriverManager.getConnection("jdbc:odbc:DB1");
                        Statement pst= con.createStatement();
                        String stm=”update student set Name='"+t1.getText()+'",
                                             Department='"+t2.getText()+"',
                                             Phone_No='"+t4.getText()+"',
                                WHERE Roll_No="+t3.getText()+" ";
                         pst.executeUpdate(stm);
                        JOptionPane.showMessageDialog(rootPane,"Data is updated");
            }
            catch(SQLException sqlEx)
            {
                        System.out.println("error");
            }
    }      

Output: