新手请教问题，jsp里怎么用serverlet阿？能不能给个例子

我以前写的一个tree的servlet,不知道对你有没有帮助，你可以告诉我mail地址，我把所有的源代码给你mail.
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
import java.lang.*;
public class helloEvery extends HttpServlet {
  private static final String CONTENT_TYPE = "text/html; charset=GB2312";
  //Initialize global variables
  String HtmlStr = new String();
  String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
  String sConnStr = "jdbc:odbc:sunshine";
  private Connection conn = null;
  private Statement stmt = null;
  ResultSet rs = null;  public void init() throws ServletException {
  }
  //Process the HTTP Post request
  public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    response.setContentType(CONTENT_TYPE);
    PrintWriter out = response.getWriter();
    HttpSession Session = request.getSession(true);
    //String UserName = Session.putValue("username");
    String UserName = Session.getAttribute("username").toString();
    String Group_ID = Session.getAttribute("Group_ID").toString();
    int gid = Integer.parseInt(Group_ID);
    UserName = UserName.toUpperCase();    out.println("<html>");
    out.println("<script language=javascript src='../images/tree.js'></script>");
    out.println("<head><title>helloEvery</title>");
    out.println("<base target='main'>");
    out.println("</head>");
    out.println("<body background='../images/background.jpg'>");
    //out.println("<p>"+UserName+"</p>");
    this.HtmlStr = "";
    helloEvery_1(UserName,gid);
    out.println(this.HtmlStr);
    out.println("</body></html>");
  }
  //Clean up resources
  public void destroy()
  {
  }
  //public helloEvery()
  //{
  //}
  public void helloEvery_1(String UserName,int gid)
  {
      try {        Class.forName(sDBDriver);
        this.HtmlStr = this.HtmlStr + conn_data(0,0,UserName,gid);
       //int i = 0;
      }
      catch(java.lang.ClassNotFoundException e) {
        System.err.println("Error(): " + e.getMessage());
      }
  }
  private String conn_data(int fid,int layer,String UserName,int gid)
  {
          String html_str = new String();
          try{
                  String Sql_str = new String("select fid,description ,funcaddr ");
                  if (UserName.equals("SA"))
                     Sql_str +="  from sa_functions_v";
                  else
                     Sql_str +="  from all_functions_v";
                  Sql_str += " where upfid ='" + fid + "' and compid = '1' order by fid";
                  ResultSet rs = executeQuery(Sql_str);
                   int FID;
                   String func_desc;
                   String func_addr;
                   //String E_address;                   while (rs.next()) {
                      func_addr = "";
                      func_desc = "";
                      FID = rs.getInt("fid");
                      func_desc = rs.getString("description");
                      func_addr = rs.getString("funcaddr");
                      //html_str = html_str + "<p class=level1  value='1' style ='CURSOR: hand'>" + func_desc + "</p> " ;
                      //ResultSet rst = executeQuery("select fid,description,funcaddr from functions where upfid = " + FID + " and compid = 1 ");
                          for (int i = 0; i < layer; i++)
                                  html_str = html_str + " " ;
                      int Is_leaf = IsLeaf(gid,FID);
                      if (Is_leaf == -1)
                          {                                  html_str = html_str + " <IMG class=level1 id='" + FID + "img' src='../images/folder.gif' style ='CURSOR: hand'>  "
                                          + " <font class=level1  value='1' id='" + FID + "fnd' style ='CURSOR: hand;Font:9pt'>" + func_desc + "</font>"
                                          + " <br>"
                                          + " <div  id='" + FID + "son' style='DISPLAY: none'>";
                                  //layer = layer + 1  ;
                                  html_str = html_str + conn_data(FID,layer+1,UserName,gid);
                                  html_str = html_str +  "</div>";
                          }
                      else
                          {
                                  /*html_str = html_str + " <img class='line' src='../images/g_square.gif' WIDTH='2' HEIGHT='2'> ";
                                  html_str = html_str + " <font class=level1 size='1'><a class='general' href='" + func_addr + "' >"
                                          + func_desc + "</a></font><br>"; */
                                  if (Is_leaf !=0)
                                  {
                                    html_str = html_str + " <img class='line' src='../images/g_square.gif' WIDTH='2' HEIGHT='2'> ";
                                    html_str = html_str + " <font class=level1 size='1'><a class='general' href='" + func_addr + "' >"
                                          + func_desc + "</a></font><br>";

                                  }
                                  else
                                  {
                                    html_str = html_str + " <img class='line' src='../images/g_square.gif' WIDTH='2' HEIGHT='2'> ";
                                    html_str = html_str + " <font color='#666666' style='Font:9pt'>" + func_desc + "</font><br>" ;

                                  }
                          }
                      //rst.close();
                    }
                    rs.close();
                    closeStmt();
                    closeConn();          }catch(Exception e) {
                  e.printStackTrace();
          }
          return html_str;
  }  private int IsLeaf(int gid,int fid)
  {
    int return_value =0 ;
    try
    {
      String Sql_str = "select fid from all_functions_v where upfid='"
                        + fid + "' and compid= 1 ";
      ResultSet rsLeaf = executeQuery(Sql_str);
      if (rsLeaf.next())
      {
        return_value = -1;
      }
      else
      {
        Sql_str = "select power from power where fid="
                  + fid + " and gid ='" + gid + "'";
        ResultSet rsPower = executeQuery(Sql_str);
        if (rsPower.next())
           return_value = rsPower.getInt("power");
        else
           return_value = 0;
        rsPower.close();
      }
      rsLeaf.close();
    }catch(Exception e)
    {
      e.printStackTrace();
    }
    return return_value;
  }  public ResultSet executeQuery(String sql) {
    rs = null;
    try {
    conn = DriverManager.getConnection(sConnStr);
    stmt = conn.createStatement();
    rs = stmt.executeQuery(sql);
    }
    catch(SQLException ex) {
      System.err.println("aq.executeQuery: " + ex.getMessage());
    }
    return rs;
  }  public void executeUpdate(String sql) {
    stmt = null;
    rs=null;
    try {
    conn = DriverManager.getConnection(sConnStr);
    stmt = conn.createStatement();
    stmt.executeQuery(sql);
    stmt.close();
    conn.close();
    }
    catch(SQLException ex) {
      System.err.println("aq.executeQuery: " + ex.getMessage());
    }
  }  public void closeStmt(){
    try{
      stmt.close();
     }
    catch(SQLException e){
      e.printStackTrace();
     }
  }
  public void closeConn(){
    try{
      conn.close();
     }
    catch(SQLException e){
      e.printStackTrace();
     }
  }
}

thank you
[email protected]

我也想要 thank you
[email protected]

我也想要，[email protected],谢谢！

我也是这样的问题：
jsp:
<HTML>
<HEAD>
<TITLE>首页</TITLE>
</HEAD>
<BODY>
<form name="form1" method="Post" action="/beans.myjsp">
        用户名: <input type="text" name="userid" size="15" size="20" maxlength="8" onkeypress="onUsernameEnter()"><br>
        密码:  <input type="password" name="passwd" size="15" maxlength="64" onkeypress="onPassEnter()"><br>
            <input type="submit" name="Submit1" value="提交">
</form>
</BODY>
</HTML>servlt:
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;public class myjsp extends HttpServlet {
public void doPost(HttpServletRequest req, HttpServletResponse res) throws ServletException,IOException {
     String passwd = req.getParameter("passwd").trim();
     String userid = req.getParameter("userid").trim();
     res.setContentType("text/heml");
     PrintWriter out=res.getWriter();
     out.println("<head><title>");
     out.println("The first text");
     out.println("The userid is:"+userid);
     out.println("The passwd is:"+passwd);
     out.println("</h1><body>");
  }
}
我提交后返回的是错误页面

调试易

新手请教问题，jsp里怎么用serverlet阿？能不能给个例子

解决方案 »