网页资讯视频图片知道文库贴吧地图采购
进入贴吧全吧搜索
齐街乡中吧 关注：49贴子：879
  • 2回复贴，共1页

666666666

xiao qin laiba


789.txt
大小：611B下载：1次转存：0次
文件已失效
<table border="1" align="center">
<tr>
<th>产品编号</th>
<th>产品类别</th>
<th>产品名称</th>
<th>产品单价</th>
<th>产品数量</th>
</tr>
<%while(rs.next()){ %>
<tr bgcolor="lightblue">
<td><%=rs.getString("p_id) %></td>
<td><%=rs.getString("p_type) %></td>
<td><%=rs.getString("p_name) %></td>
<td><%=rs.getFloat("p_price) %></td>
<td><%=rs.getInt("p_quantity) %></td>
</tr>
<%} %>
</table>
<%
pstmt.close();
pstmt2.close();
conn.close();
}
catch(Exception e)
{
out.println(e.toString());
}
%>
</body>
</html>


<%@ page contentType="text/html;charset=utf8" language="java" %>
<%@ page import="java.sql.*" %>
<html>
<head><title>成功添加新商品信息给出提示并读取商品列表</title></head>
<body>
<%
Connection conn=null;
try
{
Class.forName("com.mysql.jdbc.Driver");
String strConn="jdbc:mysql://localhost:3306/test";
String strUser="root";
String strPassword="hncc";
conn=DriverManager.getConnection(strConn,strUser,strPassword);
String p_id=request.getParameter("p_id");
String p_type=request.getParameter("p_type");
String p_name=request.getParameter("p_name");
float p_price=Float.parseFloat(request.getParameter("p_price"));
int p_quantity=Integer.parseInt(request.getParameter("p_quantity"));
String strSql="intsert into product values(?,?,?,?,?)";
PreparedStatement pstmt=conn.prepareStatement(strSql);
pstmt.setString(1,p_id);
pstmt.setString(2,p_type);
pstmt.setString(3,p_name);
pstmt.setString(4,p_price);
pstmt.setString(5,p_quantity);
int intTemp=pstmt.executeUpdate();
if(intTemp!=0)
{
out.println("<center><h3>")+"商品添加成功" + "</h3></center>";
}
else
{
out.println("<center><h3>" + "商品添加失败" + "</h3></center>");
}
String strSql2="SELECT p_id,p_type,p_name,p_price,p_quantity FROM product order by p_id desc";
PreparedStatement pstmt2=conn.prepareStatement(strSql2);
ResultSet rs=pstmt2.executeQuery();
%>


扫二维码下载贴吧客户端

下载贴吧APP
看高清直播、视频！
  • 2回复贴，共1页
分享到: