viewproblem.java

来自「help desk for hospitals/health care syst」· Java 代码 · 共 84 行

JAVA
84 行
字号 
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class viewproblem extends HttpServlet
{

    public viewproblem()
    {
    }

    public void init(ServletConfig servletconfig)
        throws ServletException
    {
        super.init(servletconfig);
        try
        {

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("Inside view problem statement is created");
        }
        catch(Exception exception)
        {
            System.out.println(exception.getMessage());
        }
    }

    public void service(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
        throws ServletException, IOException
    {
        String s = "";
        String s2 = "";
        String s4 = "";
        String s6 = "";
        PrintWriter printwriter = httpservletresponse.getWriter();
        httpservletresponse.setContentType("text/html");
        printwriter.println("<html>");
        printwriter.println("<center><h1><font color=forestgreen>HD Problem Desk</h1>");
        printwriter.println("<body>");
        printwriter.println("<form> ");
        printwriter.println("<TABLE bgcolor=white border=1 cellPadding=1 cellSpacing=1 width=80% align=center>");
        printwriter.println("<P>");
        printwriter.println(" <Tr> ");
        printwriter.println(" <TD><strong>Ticket</strong></TD> ");
        printwriter.println(" <TD><strong>Solution Date</strong></TD> ");
        printwriter.println(" <TD><strong>Solution By</strong></TD> ");
        printwriter.println(" <TD><strong>Status</strong></TD> ");
        printwriter.println("</Tr>");
        try
        {
            for(rs = st.executeQuery("select * from problemhistory"); rs.next(); printwriter.println(" </tr>  "))
            {
                String s1 = rs.getString(1);
                String s5 = rs.getString(2);
                String s3 = rs.getString(5);
                String s7 = rs.getString(7);
                printwriter.println(" <tr><TD><a href=./viewticket?tickno=" + s1 + ">" + s1 + "</a></TD>");
                printwriter.println(" <TD>" + s5 + "</TD> ");
                printwriter.println(" <TD>" + s3 + "</TD> ");
                printwriter.println(" <TD>" + s7 + "</TD> ");
            }

            printwriter.println("</Table> ");
            printwriter.println("</P> ");
            printwriter.println("</form>");
            printwriter.println("</body>");
            printwriter.println("</html>");
        }
        catch(Exception exception)
        {
            printwriter.println(exception.getMessage());
        }
    }
Connection con;
Statement st;
    Statement st1;
    ResultSet rs;
}

viewproblem.java - 源码说明

本页面展示了「help desk for hospitals/health care systems」中的 viewproblem.java 源码文件，采用 Java 编程语言编写，共 84 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与hospitals相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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