sqlexecute.java

wml和jsp实现wap网站后台管理及手机显示的过程

package tagclass;
import javax.servlet.jsp.*;
import javax.servlet.jsp.tagext.*;
import java.sql.*;

public class SqlExecute extends TagSupport
{
  private String sql="";
 // private String flag="query";
 // private ResultSet rs;

  public String getSql()
  {
    return this.sql;
  }

  public void setSql(String newSql)
  {
    this.sql=newSql;
  }
  /*public String getFlag()
  {
    return this.flag;
  }

  public void setFlag(String newFlag)
  {
    this.flag=newFlag;
  }
  public ResultSet getRs()
  {
    return this.rs;
  }
*/
  public int doStartTag() throws JspException
  {
    if(this.getSql()=="")return SKIP_BODY;

    try
    {
      //jsp：连接mysql数据库
      Class.forName("org.gjt.mm.mysql.Driver").newInstance();
      String url ="jdbc:mysql://localhost/picring?user=nangua&password=2003herald&useUnicode=true&characterEncoding=8859_1";
      Connection con= DriverManager.getConnection(url);
      Statement statement=con.createStatement();
/*      if(this.flag=="update")
        statement.executeUpdate(this.getSql());
      else
        {
          rs = statement.executeQuery(this.sql);
        }
*/
      statement.executeUpdate(this.getSql());
      con.close();
    }
    catch(Exception e)
    {
      throw new JspException(e);
    }
    return SKIP_BODY;

  }
}