例子8：添加记录——往数据库的表中添加记录（JSP）

最新推荐文章于 2024-07-04 17:17:35 发布

HaanLen

最新推荐文章于 2024-07-04 17:17:35 发布

阅读量3.3k

点赞数 3

分类专栏： JSP

JSP 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

一、项目文件目录结构图示

二、运行效果图示

三、代码示例

index.jsp

<%@ page contentType="text/html;charset=GB2312" %>
<%@ taglib tagdir="/WEB-INF/tags" prefix="inquire"%>
<HTML><BODY ><FONT>
<FORM action="newDatabase.jsp" method=post>
添加新记录:
<table border=1>
<tr><td> 产品号：</td><td><Input type="text" name="number"></td></tr>
<tr><td>名称：</td><td><Input type="text" name="name"></td></tr>
<tr><td width=150>生产日期：</td><td><Input type="text" name="madeTime"></td></tr>
<tr><td>价格：</td><td><Input type="text" name="price"></td></tr>
</table>
<BR><Input type="submit" name="b" value="提交">
</FORM>
<BR>product表添加新记录前的记录是：
 <inquire:QueryTag   dataBaseName="warehouse"
                     tableName="product" 
                     user="root" password=""/> 
<BR><%=queryResult%> 

</Font></BODY></HTML>

newDatabase.jsp

<%@ page contentType="text/html;charset=GB2312" %>
<%@ taglib tagdir="/WEB-INF/tags" prefix="inquire"%>
<HTML><BODY >
<%! 
    String handleStr(String s) {
        try {
           byte bb[]=s.getBytes("iso-8859-1");
           return new String(bb); 
        }
        catch(Exception exp){}
        return s;
    }
%>
<% String nu=handleStr(request.getParameter("number"));
   String na=handleStr(request.getParameter("name"));
   String mT=handleStr(request.getParameter("madeTime"));
   String pr=handleStr(request.getParameter("price"));
%>
 <inquire:AddRecord number="<%=nu%>"name="<%=na%>" 
                    madeTime="<%=mT%>"price="<%=pr%>"/> 
 <BR>product表添加新记录后的记录是：
 <inquire:QueryTag  dataBaseName="warehouse"tableName="product" user="root"  password=""/> 
 <BR><%=queryResult%></BODY></HTML>

QueryTag.tag

<%@ tag pageEncoding="GB2312" %>
<%@ tag import="java.sql.*" %>
<%@ attribute name="dataBaseName" required="true" %>
<%@ attribute name="tableName" required="true" %> 
<%@ attribute name="user" required="true" %>  
<%@ attribute name="password" required="false" %>  
<%@ variable name-given="biao" scope="AT_END" %>
<%@ variable name-given="queryResult" scope="AT_END" %>
<%  StringBuffer result;     
    result=new StringBuffer();
    try{  Class.forName("com.mysql.jdbc.Driver");
    }
    catch(Exception e){} 
    Connection con;
    Statement sql; 
    ResultSet rs;
    try{  result.append("<table border=1>"); 
          String uri="jdbc:mysql://127.0.0.1/"+dataBaseName;
          con=DriverManager.getConnection(uri,user,password);
          DatabaseMetaData metadata=con.getMetaData();
          ResultSet rs1=metadata.getColumns(null,null,tableName,null);
          int 字段个数=0;
          result.append("<tr>");
          while(rs1.next()){
             字段个数++;
             String clumnName=rs1.getString(4);
             result.append("<td>"+clumnName+"</td>");
          }
          result.append("</tr>");
          sql=con.createStatement();
          rs=sql.executeQuery("SELECT * FROM "+tableName);
          while(rs.next()){
               result.append("<tr>");
               for(int k=1;k<=字段个数;k++) 
                  result.append("<td>"+rs.getString(k)+"</td>");
               result.append("</tr>");
          }
          result.append("</table>");
          con.close();
    }
    catch(SQLException e){
          result.append("请输入正确的用户名和密码");
}
//返回对象queryResult： 
    jspContext.setAttribute("queryResult",new String(result)); 
    jspContext.setAttribute("biao",tableName);          //返回biao对象
%>

AddRecord.tag

<%@ tag pageEncoding="GB2312" %>
<%@ tag import="java.sql.*" %>
<%@ attribute name="number" required="true" %>
<%@ attribute name="name" required="true" %>
<%@ attribute name="madeTime" required="true" %>
<%@ attribute name="price" required="true" %>
<%  float p=Float.parseFloat(price);
    String condition=
    "INSERT INTO product VALUES"+
                "("+"'"+number+"','"+name+"','"+madeTime+"',"+p+")";
    try{   Class.forName("com.mysql.jdbc.Driver");
    }
    catch(Exception e){} 
    Connection con;
    Statement sql; 
    ResultSet rs;
    try{  String uri=
          "jdbc:mysql://127.0.0.1/warehouse?"+
          "user=root&password=&characterEncoding=gb2312";
           con=DriverManager.getConnection(uri);
           sql=con.createStatement();
           sql.executeUpdate(condition);
           con.close();
    }
    catch(Exception e){
          out.print(""+e);
    }
%>

HaanLen

关注

3
点赞
踩
20

收藏

觉得还不错? 一键收藏
0
评论
例子8：添加记录——往数据库的表中添加记录（JSP）

一、项目文件目录结构图示二、运行效果图示三、代码示例index.jsp<%@ page contentType="text/html;charset=GB2312" %><%@ taglib tagdir="/WEB-INF/tags" prefix="inquire"%><HTML><BODY ><FON...
复制链接

扫一扫

专栏目录