zhuce2.jsp

解压在c盘

<%@ page contentType="text/html;charset=gb2312"%> 
<%@ page import="java.sql.*"%> 

<% 
String spath="wangye/ec.mdb";   
String dbpath = application.getRealPath(spath);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); 
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)}; DBQ="+dbpath;
Connection conn= DriverManager.getConnection(url,"",""); 
Statement stmt=conn.createStatement();
String maijianame=(String)session.getAttribute("maijianame");


 %>
  <%
   String goodsname=request.getParameter("goodsname");
   String zhonglei=request.getParameter("zhonglei");
   int number=Integer.parseInt((String)request.getParameter("number"));
   String introduct=request.getParameter("introduct");
   String pic=request.getParameter("pic");
   int price=Integer.parseInt((String)request.getParameter("price"));
  
ResultSet rs=stmt.executeQuery("select * from maijia where username='"+maijianame+"'");
if (!rs.next()){
	out.println("<script language='javascript'>alert('请先登入或先注册！');window.location.href='zhuce3.htm';</script>");
}else{
%>


<%
 ResultSet sd=stmt.executeQuery("select * from goods where goodsname='"+goodsname+"'");
if (sd.next()){
	out.println("<script language='javascript'>alert('商品名称重复，请重新注册！');window.location.href='zhuce2.html';</script>");
}else{

   String reg="insert into goods(goodsname,zhonglei,num,introduct,pic,price)values('"+goodsname+"','"+zhonglei+"',"+number+",'"+introduct+"','"+pic+"',"+price+")";
   stmt.executeUpdate(reg); %>
%>

<% 
 out.print("加入物品成功");
 }
  %>

<%}
stmt.close(); 
conn.close(); 
%>