📄 employee.java

📁 help desk for hospitals/health care systems
💻 JAVA
字号:
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class employee extends HttpServlet
{

    public employee()
    {
    }

    public void init(ServletConfig servletconfig)
        throws ServletException
    {
        super.init(servletconfig);
        try
        {
            System.out.println("inside init");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:ecare","ecare","ecare");
//Class.forName("oracle.jdbc.driver.OracleDriver");
  //con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:project","ecare","ecare");
  st=con.createStatement();
            System.out.println("statement is created");
            System.out.println("statement is created cnu cnu cnu");
        }
        catch(Exception exception)
        {
            System.out.println(exception);
        }
    }

    public void service(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
        throws ServletException, IOException
    {
        PrintWriter printwriter = httpservletresponse.getWriter();
        httpservletresponse.setContentType("text/html");
        javax.servlet.http.HttpSession httpsession = httpservletrequest.getSession(true);
        String s5 = "";
        try
        {
            rs = st.executeQuery("select levelname,categoryid,moduleid,supportid,user_id from hdemp1");
            printwriter.println("<html>");
            printwriter.println("<head>");
            printwriter.println("<style>");
            printwriter.println("a{ Text-Decoration:none;}");
            printwriter.println("</style>");
            printwriter.println("</head>");
            printwriter.println("<body>");
            printwriter.println("<form > ");
            printwriter.println("<P align=center><FONT size=5><STRONG ");
            printwriter.println("style='COLOR: forestgreen'><U>EmployeeInfo</U></STRONG></FONT></P>");
            printwriter.println("<P align=center>&nbsp;</P>");
            printwriter.println("<P align=center>");
            printwriter.println("<TABLE border=0 cellPadding=1 cellSpacing=1 style='HEIGHT: 130px; WIDTH: 431px'");
            printwriter.println("width=75%>");
            printwriter.println("<TR>");
            printwriter.println("<TD><strong>LevelName&nbsp;&nbsp;</strong></TD>");
            printwriter.println("<TD><strong>&nbsp;&nbsp;CategoryId&nbsp;&nbsp;</strong></TD>");
            printwriter.println("<TD><strong>&nbsp;&nbsp;Module Id&nbsp;&nbsp;</strong></TD>");
            printwriter.println("<TD><strong>&nbsp;&nbsp;Support Id&nbsp;&nbsp;</strong></TD>");
            printwriter.println("<TD><strong>&nbsp;&nbsp;Employee Id&nbsp;&nbsp;</strong></TD>");
            printwriter.println("<TD><strong>&nbsp;&nbsp;Actions&nbsp;&nbsp;</strong></TD></TR>");
            for(; rs.next(); printwriter.println("</TR>"))
            {
                String s = rs.getString("levelname");
                String s3 = rs.getString("categoryid");
                String s4 = rs.getString("moduleid");
                String s6 = rs.getString("supportid");
                String s1 = rs.getString("user_id");
                System.out.println("id is" + s1);
                String s2 = "View Delete";
                printwriter.println("<TR>");
                printwriter.println("<TD>&nbsp;&nbsp;" + s + "&nbsp;&nbsp;</TD>");
                printwriter.println("<TD>&nbsp;&nbsp;" + s3 + "&nbsp;&nbsp;</TD>");
                printwriter.println("<TD>&nbsp;&nbsp;" + s4 + "&nbsp;&nbsp;</TD>");
                printwriter.println("<TD>&nbsp;&nbsp;" + s6 + "&nbsp;&nbsp;</TD>");
                printwriter.println("<TD>&nbsp;&nbsp;" + s1 + "&nbsp;&nbsp;</TD>");
                printwriter.println("<TD><a href='./viewemployee1?l=" + s + "&c=" + s3 + "&m=" + s4 + "&s=" + s6 + "&u=" + s1 + "'>View</a><a href='./deleteemployee?l=" + s + "&c=" + s3 + "&m=" + s4 + "&s=" + s6 + "&u=" + s1 + "'>&nbsp;&nbsp;Delete</a></TD>");
            }

            printwriter.println("<TR>");
            printwriter.println("<TD></TD>");
            printwriter.println("<TD></TD>");
            printwriter.println("<TD><strong>&nbsp;&nbsp;Click here to&nbsp;&nbsp;</strong> &gt;&gt;</TD>");
            printwriter.println("<TD>&nbsp;<a href='./addemployees.jsp'><strong>&nbsp;&nbsp;Add Employee Info&nbsp;&nbsp;</strong></a></TD></TR>");
            printwriter.println("<TR>");
            printwriter.println("<TD></TD>");
            printwriter.println("<TD></TD>");
            printwriter.println("<TD></TD>");
            printwriter.println("<TD></TD></TR></TABLE></P>");
            printwriter.println("<P align=center>&nbsp;</P>");
            printwriter.println("</form>");
            printwriter.println("</body>");
            printwriter.println("</html>");
        }
        catch(Exception exception)
        {
            System.out.println(exception);
            exception.printStackTrace();
            
        }
    }
Connection con;
Statement st;
    ResultSet rs;
}
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -