收藏，1.3k 浏览
问题对人有帮助，内容完整，我也想知道答案
问题没有实际价值，缺少关键内容，没有改进余地
print 'try...'
r = 10 / 0
print 'result:', r
except ZeroDivisionError, e:
print 'except:', e
print 'finally...'
print 'END'
上面代码中的e是什么意思？
答案对人有帮助，有参考价值
答案没帮助，是错误的答案，答非所问
异常对象。except 语句跟着两个东西，前面是异常的类型，后面的是 异常对象，包含了一些异常信息
答案对人有帮助，有参考价值
答案没帮助，是错误的答案，答非所问
这个e是异常类的一个实例，如果我们完整地解释这个问题，我觉得还是从Python的自定义异常类说起比较好。
假如，我们现在自定义一个简单的异常类：
class MyError(Exception):
def __init__(self, value):
self.value = value
def __str__(self):
return repr(self.value)
我们抛这个异常的时候可以这么写：
raise MyError(2*2)
except MyError as e:
print 'My exception occurred, value:', e.value
我们在捕获这个异常之后假如需要访问TA的一些属性怎么办，这个时候就可以使用as关键字
所以，这里的e是前面MyError类的一个instance，我们可以直接访问他的value，也就是你看到的e.value
针对except MyError as e这句，我们推荐使用as而不是,
所以，明白这里的e是什么了吧？
同步到新浪微博
不要错过该问题的后续解决方案
如果你没找到答案，记得登录关注哦，大家会尽全力帮你解决的 ^___^
分享到微博？
关闭理由：
删除理由：
忽略理由：
推广（招聘、广告、SEO 等）方面的内容
与已有问题重复（请编辑该提问指向已有相同问题）
答非所问，不符合答题要求
宜作评论而非答案
带有人身攻击、辱骂、仇恨等违反条款的内容
无法获得确切结果的问题
非开发直接相关的问题
非技术提问的讨论型问题
其他原因（请补充说明）
举报理由：
推广（招聘、广告、SEO 等）方面的内容
带有人身攻击、辱骂、仇恨等违反条款的内容
与已有问题重复（请编辑该提问指向已有相同问题）
内容质量差，或不适合在本网站出现
答非所问，不符合答题要求
其他原因（请补充说明）
补充说明：posts - 42,&
comments - 2,&
trackbacks - 0
1、nested exception is java.lang.OutOfMemoryError: Java heap space：list
[hibernate]
1、should be mapped with insert="false" update="false"：存在重复映射的字段；
2、Caused by: org.hibernate.HibernateException: Unable to instantiate default tuplizer [org.hibernate.tuple.entity.PojoEntityTuplizer]：
配置文件与实体文件映射错误，多了字段或少了字段或少些了getter 方法；
3、org.hibernate.LazyInitializationException: could not initialize proxy - no Session：映射关系中加上 lazy="false"；
4、org.hibernate.ObjectNotFoundException: No row with the given identifier exists：根据外键id查询不到映射表的相应数据；
5、Could not determine type for: String, for columns: [org.hibernate.mapping.Column(XXX)]：type指的是*.hbm.xml配置文件中的类型，string要小写；
6、nested exception is org.hibernate.ObjectNotFoundException: No row with the given identifier exists：映射表中数据的主键id不匹配；
7、org.hibernate.PropertyAccessException: IllegalArgumentException occurred while calling setter of XXX：配置文件与实体类字段类型不一致；
8、org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1：级联新增，打印出来的sql语句显示主表为insert，从表为update &可以将配置文件中自增id设置&unsaved-value="0"；
9、ConstraintViolationException: Could not execute JDBC batch update：两个表建立了外键约束，删除约束后操作成功；
10、&nested exception is org.springframework.beans.NotWritablePropertyException：
11、org.springframework.beans.factory.BeanCreationException:Spring中的&asm-2.2.3.jar&和Hibernate中的&asm.jar&包冲突。解决办法是移除Spring2.0 AOP Libraries中的&asm-2.2.3.jar&即可
12、org.springframework.beans.MethodInvocationException:&在classes目录有一个以前的类，但现在的类的路径已经发生了变化，发生变化的类全部封装在 jar 里面，但class loader 是优先装载 classes 目录下的类，所以存在装载时发生&NoClassDefFoundError&错误！只要把classes下的class文件删除即可。
13、com.sun.faces.mgbean.ManagedBeanCreationException：数据问题
14、a different object with the same identifier value was already associated with the session：getHibernateTemplate().merge(object);
15、MySQLSyntaxErrorException: SELECT command denied to user 'XXX'@'XXX.XXX.XXX.XXX' for table 'XXX'：
1、org.springframework.beans.factory.parsing.BeanDefinitionParsingException: Configuration problem: Failed to import bean definitions from relative location [classes/config/spring/beans/DataSource.xml]：路径不对
2、spring未注入引起的NullPointException
ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");　　　　　//source目录（一般是在src目录下） 第一种获取配置文件的方式
//ApplicationContext context = new FileSystemXmlApplicationContext("D:\\applicationContext.xml");　//绝对路径　　第二种获取配置文件的方式
& IDao dao = (Dao)context.getBean("dao");　　//获取bean& //dao.add(obj);//正常调用方法
3、&java.lang.IllegalArgumentException: 'sessionFactory' or 'hibernateTemplate' is required：配置文件未配置sessionFactory
4、com.sun.faces.mgbean.ManagedBeanCreationException: 无法设置受管 bean buildingBean 的属性 buildingBo：实体类和配置文件映射错误
5、启动 org.springframework.beans.factory.BeanCreationException：asm.jar包冲突
1、mysql 内存表 #1114: The table is full &
修改tmp_table_size（set tmp_table_size=;）；
修改max_heap_table_size（Set max_heap_table_size=;）；
查询命令：&show variables like '%tmp_table_size%';&show variables like '%max_heap_table_size%';
2、Warning:&World-writable&config&file&'/f'&is&ignored：
3、mysql Starting MySQL..The server quit without updating PID file：
4、Can't start server: Bind on TCP/IP port: Permission denied &Do you already have another mysqld server running on port: 3308
5、mysqldump备份数据库时出现when using LOCK TABLES&
1、IOException while loading persisted sessions: java.io.EOFException：清理一下tomcat的work目录
[primefaces][jsf]
1、javax.faces.FacesException: Cannot find component "xxx" in view.：jsf调不到html页面中"xxx"这个id。
2、javax.el.PropertyNotFoundException: Property 'name' not found on type java.lang.String：使用标签&p:pickList 时未定义 converter；
3、com.sun.faces.config.ConfigManager&initialize &
信息:&Unsanitized&stacktrace&from&failed&start...&
4、viewExpiredException 无法恢复视图
1、session error ：web.xml需要配置
&init-param&
&param-name&crossDomainSessionSecurity&/param-name&
&param-value&false&/param-value&
&/init-param&
faces-config.xml：
&converter&
&converter-id&sceneConverter&/converter-id&
&converter-class&cn.ac.sim.ilec.utils.SceneConverter&/converter-class&
&/converter&
SceneConverter.java：
import ponent.UIC
import javax.faces.context.FacesC
import javax.faces.convert.C
import cn.ac.sim.ilec.model.S
*@description Scene是一个实体类
public class SceneConverter implements Converter {
public Object getAsObject(FacesContext context, UIComponent component, String value) {
Scene scene = new Scene();
scene.setId(Integer.parseInt(value));
public String getAsString(FacesContext context, UIComponent component, Object value) {
return String.valueOf(((Scene) value).getId());
&p:pickList id="scenesPickList" value="#{ruleBean.scenes}" converter="sceneConverter" var="scene"
itemLabel="#{scene.name}" itemValue="#{scene}" showSourceControls="true" showTargetControls="true"
showSourceFilter="true" showTargetFilter="true" filterMatchMode="contains" /&
阅读(...) 评论()做一个商品与商品组的多对多insert操作.但是在第三张表的关系维护插入操作时总是报这个异常
16:26:03,234 ERROR [org.hibernate.property.BasicPropertyAccessor] - IllegalArgumentException in class: org.szq.shop.pojo.Productgroup, getter method of property: pgid
org.springframework.orm.hibernate3.HibernateSystemException: IllegalArgumentException occurred calling getter of org.szq.shop.pojo.Productgroup. nested exception is org.hibernate.PropertyAccessException: IllegalArgumentException occurred calling getter of org.szq.shop.pojo.Productgroup.pgid
Caused by: org.hibernate.PropertyAccessException: IllegalArgumentException occurred calling getter of org.szq.shop.pojo.Productgroup.pgid
at org.hibernate.property.BasicPropertyAccessor$BasicGetter.get(BasicPropertyAccessor.java:171)
at org.hibernate.tuple.entity.AbstractEntityTuplizer.getIdentifier(AbstractEntityTuplizer.java:183)
at org.hibernate.persister.entity.AbstractEntityPersister.getIdentifier(AbstractEntityPersister.java:3589)
at org.hibernate.persister.entity.AbstractEntityPersister.isTransient(AbstractEntityPersister.java:3305)
at org.hibernate.engine.ForeignKeys.isTransient(ForeignKeys.java:181)
at org.hibernate.event.def.AbstractSaveEventListener.getEntityState(AbstractSaveEventListener.java:512)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:80)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)
at org.hibernate.engine.CascadingAction$1.cascade(CascadingAction.java:218)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:268)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:216)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:296)
at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:242)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:219)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
at org.hibernate.engine.Cascade.cascade(Cascade.java:130)
at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:456)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:334)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
at org.springframework.orm.hibernate3.HibernateTemplate$12.doInHibernate(HibernateTemplate.java:635)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:632)
at org.szq.shop.impl.ProductDAOImpl.doCreate(ProductDAOImpl.java:21)
at org.szq.shop.struts.action.ProductAction.insert(ProductAction.java:145)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.IllegalArgumentException: object is not an instance of declaring class
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.hibernate.property.BasicPropertyAccessor$BasicGetter.get(BasicPropertyAccessor.java:145)
... 69 more
虽然我知道错误在那里,但是我检查不出来这个错误,请大家帮忙看看.以下是mvc结构
package org.szq.shop.
import java.util.D
import java.util.S
* Product generated by MyEclipse Persistence Tools
public class Product implements java.io.Serializable {
// Constructors
public Set getGroups() {
public void setGroups(Set groups) {
this.groups =
public Set getPgids() {
public void setPgids(Set pgids) {
this.pgids =
/** default constructor */
public Product() {
/** minimal constructor */
public Product(Catalogplus cid) {
this.cid =
/** full constructor */
public Product(Catalogplus cid, String name, String shortdesc,
String detaildesc, String keywords, Integer click, Integer buys,
Integer alive, String imgb, String imgs, Double marketprice,
Double shopprice, Integer star, Date postdate, Integer starp) {
this.cid =
this.name =
this.shortdesc =
this.detaildesc =
this.keywords =
this.click =
this.buys =
this.alive =
this.imgb =
this.imgs =
this.marketprice =
this.shopprice =
this.star =
this.postdate =
this.starp =
// Property accessors
public Integer getPid() {
return this.
public void setPid(Integer pid) {
this.pid =
public Catalogplus getCid() {
return this.
public void setCid(Catalogplus cid) {
this.cid =
public String getName() {
return this.
public void setName(String name) {
this.name =
public String getShortdesc() {
return this.
public void setShortdesc(String shortdesc) {
this.shortdesc =
public String getDetaildesc() {
return this.
public void setDetaildesc(String detaildesc) {
this.detaildesc =
public String getKeywords() {
return this.
public void setKeywords(String keywords) {
this.keywords =
public Integer getClick() {
return this.
public void setClick(Integer click) {
this.click =
public Integer getBuys() {
return this.
public void setBuys(Integer buys) {
this.buys =
public Integer getAlive() {
return this.
public void setAlive(Integer alive) {
this.alive =
public String getImgb() {
return this.
public void setImgb(String imgb) {
this.imgb =
public String getImgs() {
return this.
public void setImgs(String imgs) {
this.imgs =
public Double getMarketprice() {
return this.
public void setMarketprice(Double marketprice) {
this.marketprice =
public Double getShopprice() {
return this.
public void setShopprice(Double shopprice) {
this.shopprice =
public Integer getStar() {
return this.
public void setStar(Integer star) {
this.star =
public Date getPostdate() {
return this.
public void setPostdate(Date postdate) {
this.postdate =
public Integer getStarp() {
return this.
public void setStarp(Integer starp) {
this.starp =
}
package org.szq.shop.
import java.util.S
* Productgroup generated by MyEclipse Persistence Tools
public class Productgroup implements java.io.Serializable {
// Constructors
public Set getPids() {
public void setPids(Set pids) {
this.pids =
public Set getProducts() {
public void setProducts(Set products) {
this.products =
/** default constructor */
public Productgroup() {
/** full constructor */
public Productgroup(String title) {
this.title =
// Property accessors
public Integer getPgid() {
return this.
public void setPgid(Integer pgid) {
this.pgid =
public String getTitle() {
return this.
public void setTitle(String title) {
this.title =
}
package org.szq.shop.
* Productgroupmap generated by MyEclipse Persistence Tools
public class Productgroupmap implements java.io.Serializable {
private ProductgroupmapI
// Constructors
/** default constructor */
public Productgroupmap() {
/** full constructor */
public Productgroupmap(ProductgroupmapId id) {
// Property accessors
public ProductgroupmapId getId() {
return this.
public void setId(ProductgroupmapId id) {
}
package org.szq.shop.
* ProductgroupmapId generated by MyEclipse Persistence Tools
public class ProductgroupmapId implements java.io.Serializable {
// Constructors
/** default constructor */
public ProductgroupmapId() {
/** full constructor */
public ProductgroupmapId(Integer pgid, Integer pid) {
this.pgid =
this.pid =
// Property accessors
public Integer getPgid() {
return this.
public void setPgid(Integer pgid) {
this.pgid =
public Integer getPid() {
return this.
public void setPid(Integer pid) {
this.pid =
public boolean equals(Object other) {
if ((this == other))
if ((other == null))
if (!(other instanceof ProductgroupmapId))
ProductgroupmapId castOther = (ProductgroupmapId)
return ((this.getPgid() == castOther.getPgid()) || (this.getPgid() != null
&& castOther.getPgid() != null && this.getPgid().equals(
castOther.getPgid())))
&& ((this.getPid() == castOther.getPid()) || (this.getPid() != null
&& castOther.getPid() != null && this.getPid().equals(
castOther.getPid())));
public int hashCode() {
int result = 17;
result = 37 * result
+ (getPgid() == null ? 0 : this.getPgid().hashCode());
result = 37 * result
+ (getPid() == null ? 0 : this.getPid().hashCode());
}
&?xml version="1.0" encoding="utf-8"?&
&!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"&
Mapping file autogenerated by MyEclipse Persistence Tools
&hibernate-mapping&
&class name="org.szq.shop.pojo.Product" table="product" catalog="mldnshop"&
&id name="pid" type="java.lang.Integer"&
&column name="pid" /&
&generator class="native"&&/generator&
&!--&property name="cid" type="java.lang.Integer"&
&column name="cid" not-null="true" /&
&/property&
--&&property name="name" type="java.lang.String"&
&column name="name" length="50" /&
&/property&
&property name="shortdesc" type="java.lang.String"&
&column name="shortdesc" /&
&/property&
&property name="detaildesc" type="java.lang.String"&
&column name="detaildesc" length="65535" /&
&/property&
&property name="keywords" type="java.lang.String"&
&column name="keywords" length="30" /&
&/property&
&property name="click" type="java.lang.Integer"&
&column name="click" /&
&/property&
&property name="buys" type="java.lang.Integer"&
&column name="buys" /&
&/property&
&property name="alive" type="java.lang.Integer"&
&column name="alive" /&
&/property&
&property name="imgb" type="java.lang.String"&
&column name="imgb" length="50" /&
&/property&
&property name="imgs" type="java.lang.String"&
&column name="imgs" length="50" /&
&/property&
&property name="marketprice" type="java.lang.Double"&
&column name="marketprice" precision="10" /&
&/property&
&property name="shopprice" type="java.lang.Double"&
&column name="shopprice" precision="10" /&
&/property&
&property name="star" type="java.lang.Integer"&
&column name="star" /&
&/property&
&property name="postdate" type="java.util.Date"&
&column name="postdate" length="19" /&
&/property&
&property name="starp" type="java.lang.Integer"&
&column name="starp" /&
&/property&
&many-to-one name="cid" class="org.szq.shop.pojo.Catalogplus" cascade="all" column="cid" /&
&set name="groups" table="productgroupmap" cascade="all"&
&key column="pid" /&
&many-to-many class="org.szq.shop.pojo.Productgroup" column="pgid" /&
&set name="pgids" table="productgroupmap" cascade="all"&
&key column="pid" /&
&many-to-many class="org.szq.shop.pojo.Productgroup" column="pgid" /&
&/hibernate-mapping&
&?xml version="1.0" encoding="utf-8"?&
&!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"&
Mapping file autogenerated by MyEclipse Persistence Tools
&hibernate-mapping&
&class name="org.szq.shop.pojo.Productgroup" table="productgroup" catalog="mldnshop"&
&id name="pgid" type="java.lang.Integer"&
&column name="pgid" /&
&generator class="native"&&/generator&
&property name="title" type="java.lang.String"&
&column name="title" length="50" not-null="true" /&
&/property&
&set name="products" table="productgroupmap" inverse="true" cascade="all"&
&key column="pgid" /&
&many-to-many class="org.szq.shop.pojo.Product" column="pid" /&
&set name="pids" table="productgroupmap" cascade="all"&
&key column="pgid" /&
&many-to-many class="org.szq.shop.pojo.Product" column="pid" /&
&/hibernate-mapping&
&?xml version="1.0" encoding="utf-8"?&
&!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"&
Mapping file autogenerated by MyEclipse Persistence Tools
&hibernate-mapping&
&class name="org.szq.shop.pojo.Productgroupmap" table="productgroupmap" catalog="mldnshop"&
&composite-id name="id" class="org.szq.shop.pojo.ProductgroupmapId"&
&key-property name="pgid" type="java.lang.Integer"&
&column name="pgid" /&
&/key-property&
&key-property name="pid" type="java.lang.Integer"&
&column name="pid" /&
&/key-property&
&/composite-id&
&/hibernate-mapping&
我的实现类
package org.szq.shop.
import java.sql.SQLE
import java.util.I
import java.util.L
import org.hibernate.HibernateE
import org.hibernate.Q
import org.hibernate.S
import org.springframework.orm.hibernate3.HibernateC
import org.springframework.orm.hibernate3.support.HibernateDaoS
import org.szq.shop.dao.ProductDAO;
import org.szq.shop.pojo.P
public class ProductDAOImpl extends HibernateDaoSupport implements ProductDAO {
public boolean doCreate(Product p) throws Exception {
// TODO Auto-generated method stub
boolean flag =
super.getHibernateTemplate().save(p);
} catch (Exception e) {
// TODO: handle exception
public boolean doRemove(int pid) throws Exception {
// TODO Auto-generated method stub
public boolean doUpdate(Product p) throws Exception {
// TODO Auto-generated method stub
public List&Product& findAll(final String kw, final int cp, final int ls) throws Exception {
// TODO Auto-generated method stub
List all =
super.getHibernateTemplate().setCacheQueries(true);
all = (List) super.getHibernateTemplate().execute(
new HibernateCallback() {
public Object doInHibernate(Session arg0)
throws HibernateException, SQLException {
// TODO Auto-generated method stub
String hql = "FROM Product p WHERE p.name LIKE ? or p.keywords LIKE ?";
Query q = arg0.createQuery(hql);
q.setString(0, "%" + kw + "%");
q.setString(1, "%" + kw + "%");
List temp = q.list();
Iterator iter = temp.iterator();
while (iter.hasNext()) {
Product p = (Product) iter.next();
p.getCid().getTitle();
p.getPgids().size();
} catch (Exception e) {
// TODO: handle exception
public Product findById(int pid) throws Exception {
// TODO Auto-generated method stub
public int getAllCount(final String kw) throws Exception {
// TODO Auto-generated method stub
int count = 0 ;
long temp = (Long) super.getHibernateTemplate().execute(
new HibernateCallback() {
public Object doInHibernate(Session arg0)
throws HibernateException, SQLException {
// TODO Auto-generated method stub
String hql = "SELECT COUNT(p.pid) FROM Product p WHERE p.name LIKE ? OR p.keywords LIKE ?";
Query q = arg0.createQuery(hql);
q.setString(0, "%" + kw + "%");
q.setString(1, "%" + kw + "%");
return q.uniqueResult();
count = (int)
} catch (Exception e) {
// TODO: handle exception
我的action
/*
* Generated by MyEclipse Struts
* Template path: templates/java/JavaClass.vtl
package org.szq.shop.struts.
import java.io.F
import java.io.FileNotFoundE
import java.io.FileOutputS
import java.util.D
import java.util.L
import java.util.TreeS
import javax.servlet.http.HttpServletR
import javax.servlet.http.HttpServletR
import org.apache.struts.action.ActionF
import org.apache.struts.action.ActionF
import org.apache.struts.action.ActionM
import org.apache.struts.actions.DispatchA
import org.apache.struts.upload.FormF
import org.szq.shop.dao.CatalogDAO;
import org.szq.shop.dao.CatalogplusDAO;
import org.szq.shop.dao.ProductDAO;
import org.szq.shop.dao.ProductgroupDAO;
import org.szq.shop.pojo.P
import org.szq.shop.pojo.P
import org.szq.shop.struts.form.ProductF
import org.szq.util.IPTimeS
* MyEclipse Struts Creation date: 04-30-2009
* XDoclet definition:
* @struts.action path="/product" name="productForm" input="/errors.jsp"
parameter="status" scope="request" validate="true"
public class ProductAction extends DispatchAction {
* Generated Methods
private CatalogDAO
private CatalogplusDAO
private ProductDAO
private ProductgroupDAO
public void setCatalogdao(CatalogDAO catalogdao) {
this.catalogdao =
public void setCatalogplusdao(CatalogplusDAO catalogplusdao) {
this.catalogplusdao =
public void setProductdao(ProductDAO productdao) {
this.productdao =
public void setProductgroupdao(ProductgroupDAO productgroupdao) {
this.productgroupdao =
* Method execute
* @param mapping
* @param form
* @param request
* @param response
* @return ActionForward
public ActionForward insertpre(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
ProductForm productForm = (ProductForm)
List allc =
List allcp =
List allpg =
allc = catalogdao.findAll();
allcp = catalogplusdao.findAll();
allpg = productgroupdao.findAll();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
request.setAttribute("allc", allc);
request.setAttribute("allcp", allcp);
request.setAttribute("allpg", allpg);
return mapping.findForward("insert");
public ActionForward insert(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
ProductForm productForm = (ProductForm)
//处理上传文件
FormFile imgb = productForm.getImgb();
String imgbname = new IPTimeStamp(request.getRemoteAddr())
.getIPTimeRand()
+ imgb.getFileName().substring(
imgb.getFileName().lastIndexOf("."));
String imgbpath = this.servlet.getServletContext().getRealPath("/")
+ "/upload/" +
FormFile imgs = productForm.getImgs();
String imgsname = new IPTimeStamp(request.getRemoteAddr())
.getIPTimeRand()
+ imgs.getFileName().substring(
imgs.getFileName().lastIndexOf("."));
String imgspath = this.servlet.getServletContext().getRealPath("/")
+ "/upload/" +
//载入数据
Product p = new Product();
p.setCid(catalogplusdao.findById(productForm.getCid()));
} catch (Exception e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
p.setName(productForm.getName());
p.setShortdesc(productForm.getShortdesc());
p.setDetaildesc(productForm.getDetaildesc());
p.setKeywords(productForm.getKeywords());
p.setClick(productForm.getClick());
p.setBuys(productForm.getBuys());
p.setAlive(productForm.getAlive());
p.setImgb(imgbname);
p.setImgs(imgsname);
p.setMarketprice(productForm.getMarketprice());
p.setShopprice(productForm.getShopprice());
p.setStar(productForm.getStar());
p.setPostdate(new Date());
p.setStarp(productForm.getStarp());
//处理pgid数组
int[] pgid = productForm.getPgid();
p.setPgids(new TreeSet());
for (int i = 0; i & pgid. i++) {
p.getPgids().add(pgid[i]);
boolean flag =
flag = productdao.doCreate(p);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
if(flag) {
FileOutputStream outb = new FileOutputStream(new File(imgbpath));
outb.write(imgb.getFileData());
outb.close();
FileOutputStream outs = new FileOutputStream(new File(imgspath));
outs.write(imgs.getFileData());
outs.close();
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
request.setAttribute("message", "保存成功");
request.setAttribute("message", "保存失败");
return mapping.findForward("forward");
public ActionForward list(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
ProductForm productForm = (ProductForm)
int cp = 1 ;
int ls = 3 ;
cp = Integer.parseInt(productForm.getCp());
ls = Integer.parseInt(productForm.getLs());
} catch (Exception e) {
String kw =
kw = productForm.getKw();
if(kw==null) {
List all =
List allpg =
int count = 0 ;
all = productdao.findAll(kw, cp, ls);
count = productdao.getAllCount(kw);
allpg = productgroupdao.findAll();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
request.setAttribute("all", all);
request.setAttribute("allRecorders", count);
request.setAttribute("currentPage", cp);
request.setAttribute("lineSize", ls);
request.setAttribute("keyWord", kw);
request.setAttribute("allpg", allpg);
return mapping.findForward("list");
public ActionForward test(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
ProductForm productForm = (ProductForm)
这几天一直卡在这里,郁闷极了.我会一直等,还请大大指出问题所在问题补充：附上数据库脚本:
DROP DATABASE
CREATE DATABASE
DROP TABLE IF EXISTS
DROP TABLE IF EXISTS
DROP TABLE IF EXISTS
DROP TABLE IF EXISTS
DROP TABLE IF EXISTS
DROP TABLE IF EXISTS
DROP TABLE IF EXISTS
DROP TABLE IF EXISTS
DROP TABLE IF EXISTS
DROP TABLE IF EXISTS
DROP TABLE IF EXISTS
DROP TABLE IF EXISTS
DROP TABLE IF EXISTS
DROP TABLE IF EXISTS
DROP TABLE IF EXISTS
DROP TABLE IF EXISTS
DROP TABLE IF EXISTS
DROP TABLE IF EXISTS
DROP TABLE IF EXISTS
/*==============================================================*/
/* Table: admin
/*==============================================================*/
create table admin
int(13) unsigned
AUTO_INCREMENT
varchar(45)
default NULL,
varchar(45)
default NULL,
lastlogindate
default NULL,
default NULL,
int(13) unsigned
default NULL,
primary key (adid),
key adgid (adgid)
/*==============================================================*/
/* Table: admingroup
/*==============================================================*/
create table admingroup
int(13) unsigned
AUTO_INCREMENT
varchar(45)
default NULL,
description
varchar(200)
default NULL,
primary key (adgid)
/*==============================================================*/
/* Table: admingroupauth
/*==============================================================*/
create table admingroupauth
int(13) unsigned
not null default 0,
int(13) unsigned
not null default 0,
primary key (adgid, ataid)
/*==============================================================*/
/* Table: authenticationaction
/*==============================================================*/
create table authenticationaction
int(10) unsigned
not null AUTO_INCREMENT,
int(3) unsigned
not null default 0,
description
varchar(255)
default NULL,
primary key (ataid)
/*==============================================================*/
/* Table: area
/*==============================================================*/
create table area
int AUTO_INCREMENT PRIMARY KEY NOT NULL,
varchar(100)
/*==============================================================*/
/* Table: areaplus
/*==============================================================*/
CREATE TABLE areaplus (
INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
INT NOT NULL,
title varchar(100) default NULL ,
foreign key (upid) references area (id) on delete cascade
/*==============================================================*/
/* Table: member
/*==============================================================*/
CREATE TABLE member (
mid int AUTO_INCREMENT PRIMARY KEY NOT NULL ,
account varchar(45) NOT NULL default '',
pwd varchar(45) NOT NULL default '',
email varchar(45) NOT NULL default '',
name varchar(45) default NULL,
sex VARCHAR(2) ,
province int ,
address varchar(200) default NULL,
postcode varchar(45) default NULL,
mobile varchar(45) default NULL,
tel varchar(45) default NULL,
postdate datetime default NULL,
lastlogindate datetime default NULL,
points int(10) unsigned default '0',
city int ,
foreign key (province) references area (id) on delete cascade ,
foreign key (city) references areaplus (id) on delete cascade
/*==============================================================*/
/* Table: catalog
/*==============================================================*/
CREATE TABLE catalog (
id int AUTO_INCREMENT PRIMARY KEY NOT NULL ,
title varchar(100) default NULL,
img varchar(100) default NULL,
description varchar(255) default NULL
/*==============================================================*/
/* Table: catalogplus
/*==============================================================*/
CREATE TABLE catalogplus (
id int AUTO_INCREMENT PRIMARY KEY NOT NULL,
upid int NOT NULL ,
title varchar(100) default NULL,
foreign key (upid) references catalog (id) on delete cascade
/*==============================================================*/
/* Table: delivery
/*==============================================================*/
create table delivery
int(13) AUTO_INCREMENT PRIMARY KEY NOT NULL,
varchar(45)
default NULL,
decimal(10,2) unsigned
default NULL,
description
varchar(255)
default NULL
/*==============================================================*/
/* Table: member_level
/*==============================================================*/
CREATE TABLE memberlevel (
mlid int AUTO_INCREMENT PRIMARY KEY NOT NULL,
stp int NOT NULL,
enp int NOT NULL,
levelname varchar(100) NOT NULL default '',
discount decimal(10,3) unsigned NOT NULL default '1.000'
/*==============================================================*/
/* Table: news
/*==============================================================*/
CREATE TABLE news (
nid int AUTO_INCREMENT PRIMARY KEY NOT NULL,
title varchar(255) default NULL,
content text,
keyw varchar(200) default NULL,
postdate datetime default NULL
/*==============================================================*/
/* Table: pevaluate
/*==============================================================*/
CREATE TABLE pevaluate (
peid int AUTO_INCREMENT PRIMARY KEY NOT NULL,
pid int unsigned NOT NULL default '0',
author varchar(45) NOT NULL default '',
content varchar(255) NOT NULL default '',
star int unsigned NOT NULL default '0',
postdate datetime NOT NULL default ' 00:00:00',
feedback varchar(255) NOT NULL default ''
/*==============================================================*/
/* Table: pay
/*==============================================================*/
CREATE TABLE pay (
pyid int AUTO_INCREMENT PRIMARY KEY NOT NULL ,
name varchar(45) default NULL,
costpercent decimal(10,3) default NULL,
description text,
bankaccount varchar(45) default NULL,
appendinfo varchar(255) default NULL
/*==============================================================*/
/* Table: porder
/*==============================================================*/
CREATE TABLE porder (
oid int AUTO_INCREMENT PRIMARY KEY NOT NULL ,
sumprice decimal(10,2) unsigned default '0.00',
actualpay decimal(10,2) unsigned default NULL,
mid int(13) unsigned default '0',
email varchar(45) default NULL,
province int(13) unsigned default '0',
name varchar(45) default NULL,
address varchar(200) default NULL,
postcode varchar(45) default NULL,
tel varchar(45) default NULL,
mobile varchar(45) default NULL,
note varchar(255) default NULL,
postdate datetime default NULL,
paytype int(13) unsigned default NULL,
paytypecostpercent decimal(10,3) unsigned default NULL,
deliveryno int(13) unsigned default NULL,
deltypecost decimal(10,2) unsigned default NULL,
handlestatus int(3) unsigned default '0',
handlenote varchar(255) default NULL,
deliverytype varchar(100) default NULL,
payappendinfo varchar(200) default NULL,
city int(10) unsigned default NULL,
provincename varchar(45) default NULL,
cityname varchar(45) default NULL
/*==============================================================*/
/* Table: porderline
/*==============================================================*/
CREATE TABLE porderline (
polid int AUTO_INCREMENT PRIMARY KEY NOT NULL ,
oid int NOT NULL,
pid int NOT NULL,
pcid int(13) unsigned default '0',
pctitle varchar(45) default NULL,
cid int(13) unsigned default '0',
ctitle varchar(45) default NULL,
quantity int(3) unsigned default '0',
shopprice decimal(10,2) default '0.00',
name varchar(45) default NULL,
amount decimal(10,2) default '0.00'
/*==============================================================*/
/* Table: product
/*==============================================================*/
CREATE TABLE product (
pid int AUTO_INCREMENT PRIMARY KEY NOT NULL,
cid int NOT NULL default '0',
name varchar(50) default NULL,
shortdesc varchar(255) default NULL,
detaildesc text,
keywords varchar(30) default NULL,
default '0',
default '0',
alive int(3) default '1',
imgb varchar(50) default NULL,
imgs varchar(50) default NULL,
marketprice decimal(10,2) unsigned default NULL,
shopprice decimal(10,2) unsigned default NULL,
star int(10) unsigned default '0',
postdate datetime default NULL,
default '0'
/*==============================================================*/
/* Table: productgroup
/*==============================================================*/
CREATE TABLE productgroup (
pgid int AUTO_INCREMENT PRIMARY KEY NOT NULL,
title varchar(50) NOT NULL default ''
/*==============================================================*/
/* Table: productgroupmap
/*==============================================================*/
CREATE TABLE productgroupmap (
pgid int NOT NULL,
pid int NOT NULL
-- 测试数据
INSERT INTO admin (account,pwd,lastlogindate,postdate,adgid) VALUES
('admin','A5AE4A801FC3',' 17:32:50',' 14:04:23',1);
INSERT INTO admingroup (name,description) VALUES ('超级管理员',NULL);
INSERT INTO admingroupauth (adgid,ataid) VALUES
(1,1), (1,2), (1,3), (1,4), (1,5),
(1,6), (1,7), (1,8), (1,9), (1,10),
(1,11), (1,12), (1,13), (1,14), (1,15);
INSERT INTO authenticationaction (type,description) VALUES
(1,'发布商品'), (1,'商品管理'), (1,'商品群组'), (2,'评论管理'),
(2,'货架管理'), (3,'订单管理'), (4,'支付管理'), (5,'配送管理'),
(6,'会员管理'), (6,'级别管理'), (6,'地区管理'),
(7,'发布新闻'), (7,'新闻管理'), (8,'账号管理'), (8,'权限管理');
INSERT INTO area (title) VALUES
('其他'), ('北京'), ('重庆'), ('福建'), ('甘肃'), ('广东'),
('广西'), ('贵州'), ('海南'), ('河北'), ('黑龙江'), ('河南'),
('香港'), ('湖北'), ('湖南'), ('江苏'), ('江西'), ('吉林'),
('辽宁'), ('澳门'), ('内蒙古'), ('宁夏'), ('青海'), ('山东'),
('上海'), ('山西'), ('陕西'), ('四川'), ('台湾'), ('天津'),
('新疆'), ('西藏'), ('云南'), ('浙江'), ('安徽');
INSERT INTO areaplus (upid,title) VALUES
(35,'合肥'), (35,'安庆'), (35,'蚌埠'), (35,'亳州'), (35,'巢湖'), (35,'滁州'),
(35,'阜阳'), (35,'贵池'), (35,'淮北'), (35,'淮化'), (35,'淮南'), (35,'黄山'),
(35,'九华山'), (35,'六安'), (35,'马鞍山'), (35,'宿州'), (35,'铜陵'), (35,'屯溪'),
(35,'芜湖'), (35,'宣城'), (2,'北京'), (3,'重庆'), (4,'福州'), (4,'福安'),
(4,'龙岩'), (4,'南平'), (4,'宁德'), (4,'莆田'), (4,'泉州'), (4,'三明'),
(4,'邵武'), (4,'石狮'), (4,'永安'), (4,'武夷山'), (4,'厦门'), (4,'漳州'),
(5,'兰州'), (5,'白银'), (5,'定西'), (5,'敦煌'), (5,'甘南'), (5,'金昌');
INSERT INTO areaplus (upid,title) VALUES
(5,'酒泉'), (5,'临夏'), (5,'平凉'), (5,'天水'), (5,'武都'), (5,'武威'),
(5,'西峰'), (5,'张掖'), (6,'广州'), (6,'潮阳'), (6,'潮州'), (6,'澄海'),
(6,'东莞'), (6,'佛山'), (6,'河源'), (6,'惠州'), (6,'江门'), (6,'揭阳'),
(6,'开平'), (6,'茂名'), (6,'梅州'), (6,'清远'), (6,'汕头'), (6,'汕尾'),
(6,'韶关'), (6,'深圳'), (6,'顺德'), (6,'阳江'), (6,'英德'), (6,'云浮'),
(6,'增城'), (6,'湛江'), (6,'肇庆'), (6,'中山'), (6,'珠海'), (7,'南宁');
INSERT INTO areaplus (upid,title) VALUES
(7,'百色'), (7,'北海'), (7,'桂林'), (7,'防城港'), (7,'河池'), (7,'贺州'),
(7,'柳州'), (7,'钦州'), (7,'梧州'), (7,'玉林'), (8,'贵阳'), (8,'安顺'),
(8,'毕节'), (8,'都匀'), (8,'凯里'), (8,'六盘水'), (8,'铜仁'), (8,'兴义'),
(8,'玉屏'), (8,'遵义'), (9,'海口'), (9,'儋县'), (9,'陵水'), (9,'琼海'),
(9,'三亚'), (9,'五指山'), (9,'万宁'), (10,'石家庄'), (10,'保定'), (10,'北戴河'),
(10,'沧州'), (10,'承德'), (10,'丰润'), (10,'邯郸'), (10,'衡水'), (10,'廊坊');
INSERT INTO areaplus (upid,title) VALUES
(10,'南戴河'), (10,'秦皇岛'), (10,'唐山'), (10,'新城'), (10,'邢台'), (10,'张家口'),
(11,'哈尔滨'), (11,'北安'), (11,'大庆'), (11,'大兴安岭'), (11,'鹤岗'), (11,'黑河'),
(11,'佳木斯'), (11,'鸡西'), (11,'牡丹江'), (11,'齐齐哈尔'), (11,'七台河'), (11,'双鸭山'),
(11,'绥化'), (11,'伊春'), (12,'郑州'), (12,'安阳'), (12,'鹤壁'), (12,'潢川'),
(12,'焦作'), (12,'济源'), (12,'开封'), (12,'漯河'), (12,'洛阳'), (12,'南阳'), (12,'平顶山'),
(12,'濮阳'), (12,'三门峡'), (12,'商丘'), (12,'新乡');
INSERT INTO areaplus (upid,title) VALUES
(12,'信阳'), (12,'许昌'), (12,'周口'), (12,'驻马店'), (13,'香港'), (13,'九龙'),
(13,'新界'), (14,'武汉'), (14,'恩施'), (14,'鄂州'), (14,'黄冈'), (14,'黄石'),
(14,'荆门'), (14,'荆州'), (14,'潜江'), (14,'十堰'), (14,'随州'), (14,'武穴'), (14,'仙桃'),
(14,'咸宁'), (14,'襄阳'), (14,'襄樊'), (14,'孝感'), (14,'宜昌'), (15,'长沙'), (15,'常德'),
(15,'郴州'), (15,'衡阳'), (15,'怀化'), (15,'吉首'), (15,'娄底'), (15,'邵阳'), (15,'湘潭'),
(15,'益阳'), (15,'岳阳'), (15,'永州');
INSERT INTO areaplus (upid,title) VALUES
(15,'张家界'), (15,'株洲'), (16,'南京'), (16,'常熟'), (16,'常州'), (16,'海门'),
(16,'淮安'), (16,'江都'), (16,'江阴'), (16,'昆山'), (16,'连云港'), (16,'南通'),
(16,'启东'), (16,'沭阳'), (16,'宿迁'), (16,'苏州'), (16,'太仓'), (16,'泰州'),
(16,'同里'), (16,'无锡'), (16,'徐州'), (16,'盐城'), (16,'扬州'), (16,'宜兴'),
(16,'仪征'), (16,'张家港'), (16,'镇江'), (16,'周庄'), (17,'南昌'), (17,'抚州'),
(17,'赣州'), (17,'吉安'), (17,'景德镇'), (17,'井冈山'), (17,'九江'), (17,'庐山');
INSERT INTO areaplus (upid,title) VALUES
(17,'萍乡'), (17,'上饶'), (17,'新余'), (17,'宜春'), (17,'鹰潭'), (18,'长春'),
(18,'白城'), (18,'白山'), (18,'珲春'), (18,'辽源'), (18,'梅河'), (18,'吉林'),
(18,'四平'), (18,'松原'), (18,'通化'), (18,'延吉'), (19,'沈阳'), (19,'鞍山'),
(19,'本溪'), (19,'朝阳'), (19,'大连'), (19,'丹东'), (19,'抚顺'), (19,'阜新'),
(19,'葫芦岛'), (19,'锦州'), (19,'辽阳'), (19,'盘锦'), (19,'铁岭'), (19,'营口'),
(20,'澳门'), (21,'呼和浩特'), (21,'阿拉善盟'), (21,'包头'), (21,'赤峰'), (21,'东胜');
INSERT INTO areaplus (upid,title) VALUES
(21,'海拉尔'), (21,'集宁'), (21,'临河'), (21,'通辽'), (21,'乌海'), (21,'乌兰浩特'),
(21,'锡林浩特'), (22,'银川'), (22,'固原'), (22,'石嘴山'), (22,'吴忠'), (23,'西宁'),
(23,'德令哈'), (23,'格尔木'), (23,'共和'), (23,'海东'), (23,'海晏'), (23,'玛沁'),
(23,'同仁'), (23,'玉树'), (24,'济南'), (24,'滨州'), (24,'兖州'), (24,'德州'),
(24,'东营'), (24,'菏泽'), (24,'济宁'), (24,'莱芜'), (24,'聊城'), (24,'临沂'),
(24,'蓬莱'), (24,'青岛'), (24,'曲阜'), (24,'日照'), (24,'泰安');
INSERT INTO areaplus (upid,title) VALUES
(24,'潍坊'), (24,'威海'), (24,'烟台'), (24,'枣庄'), (24,'淄博'), (25,'上海'),
(25,'崇明'), (25,'朱家角'), (26,'太原'), (26,'长治'), (26,'大同'), (26,'候马'),
(26,'晋城'), (26,'离石'), (26,'临汾'), (26,'宁武'), (26,'朔州'), (26,'忻州'),
(26,'阳泉'), (26,'榆次'), (26,'运城'), (27,'西安'), (27,'安康'), (27,'宝鸡'),
(27,'汉中'), (27,'渭南'), (27,'商州'), (27,'绥德'), (27,'铜川'), (27,'咸阳'),
(27,'延安'), (27,'榆林'), (28,'成都'), (28,'巴中'), (28,'达州'), (28,'德阳');
INSERT INTO areaplus (upid,title) VALUES
(28,'都江堰'), (28,'峨眉山'), (28,'涪陵'), (28,'广安'), (28,'广元'), (28,'九寨沟'),
(28,'康定'), (28,'乐山'), (28,'泸州'), (28,'马尔康'), (28,'绵阳'), (28,'眉山'),
(28,'南充'), (28,'内江'), (28,'攀枝花'), (28,'遂宁'), (28,'汶川'), (28,'西昌'),
(28,'雅安'), (28,'宜宾'), (28,'自贡'), (28,'资阳'), (29,'台北'), (29,'基隆'),
(29,'台南'), (29,'台中'), (30,'天津'), (31,'乌鲁木齐'), (31,'阿克苏'), (31,'阿勒泰'),
(31,'阿图什'), (31,'博乐'), (31,'昌吉'), (31,'东山'), (31,'哈密');
INSERT INTO areaplus (upid,title) VALUES
(31,'和田'), (31,'喀什'), (31,'克拉玛依'), (31,'库车'), (31,'库尔勒'), (31,'奎屯'),
(31,'石河子'), (31,'塔城'), (31,'吐鲁番'), (31,'伊宁'), (32,'拉萨'), (32,'阿里'),
(32,'昌都'), (32,'林芝'), (32,'那曲'), (32,'日喀则'), (32,'山南'), (33,'昆明'),
(33,'大理'), (33,'保山'), (33,'楚雄'), (33,'东川'), (33,'个旧'),
(33,'景洪'), (33,'开远'), (33,'临沧'), (33,'丽江'), (33,'六库'), (33,'潞西'),
(33,'曲靖'), (33,'思茅'), (33,'文山'), (33,'西双版纳'), (33,'玉溪');
INSERT INTO areaplus (upid,title) VALUES
(33,'中甸'), (33,'昭通'), (34,'杭州'), (34,'安吉'), (34,'慈溪'), (34,'定海'),
(34,'奉化'), (34,'海盐'), (34,'黄岩'), (34,'湖州'), (34,'嘉兴'), (34,'金华'),
(34,'临安'), (34,'临海'), (34,'丽水'), (34,'宁波'), (34,'瓯海'), (34,'平湖'),
(34,'千岛湖'), (34,'衢州'), (34,'江山'), (34,'瑞安'), (34,'绍兴'), (34,'嵊州'),
(34,'台州'), (34,'温岭'), (34,'温州'), (34,'舟山'), (1,'其他');
INSERT INTO catalog (title,img,description) VALUES
('电脑、软件、网络','40.jpg','杂志 小说 瑞丽 外语 考研 求职'),
('MP3、MP4、音响','20.gif','手机 CDMA 智能 充值 配件 小灵通 蓝牙 诺基亚 三星 索爱 MOTO 拍卖'),
('手机、通讯设备、卡','90.gif','ZIPPO 打火机 瑞士军刀 刀具 男包 饰品 烟具 烟斗 酒具 配件 剃须刀'),
('数码相机、摄影摄像','70.gif','走过路过千万别错过，各种品牌液精大优惠'),
('珠宝首饰、手表、眼镜','00.jpg','HIFI音响 纽曼 CD MD 一元 99元 199元 森海塞尔'),
('彩妆、香水、护肤','40.gif','佳能 索尼 尼康 三星 配件 闪存卡 数码相机 数码单反 DV 镜头 读卡器'),
('女装、女士精品','90.gif','银饰 韩国 水晶 外贸原单 Swatch 施华洛世奇 名表 发夹 项链 钻石'),
('男装、服饰配件','40.gif','各种品牌笔记本电脑全线大优惠'),
('网络游戏虚拟商品','20.gif','各种时尚、高档MP3、MP3'),
('音乐、影视、明星、娱乐','90.gif','这是一个美得上帝也要叹息的地方!它被浓阴华盖遮蔽，恬静、怡然，没有一丝尘世的喧嚣');
INSERT INTO catalogplus (upid,title) VALUES
(1,'硬件'), (1,'全新笔记本'), (1,'二手笔记本'), (1,'PDA'), (1,'笔记本配件'),
(1,'电脑周边'), (1,'网络服务'), (3,'手机'), (3,'CDMA'), (3,'配件'),
(3,'小灵通'), (2,'便携视听'), (2,'HIFI音响'), (2,'电脑音箱'), (4,'数码相机'),
(4,'数码单反'), (4,'专业相机'), (4,'DV'), (5,'银饰'), (5,'韩国'), (5,'水晶'),
(5,'外贸'), (6,'丰胸'), (6,'Swarovski'), (6,'减肥'), (6,'护肤'), (6,'香水'),
(6,'面膜'), (6,'雅芳'), (7,'吊带衫'), (7,'背心'), (7,'针织衫'), (7,'毛衣'),
(7,'衬衫'), (7,'T恤'), (8,'毛衣'), (8,'线衫'), (8,'外套'), (8,'帽衫'),
(8,'西装'), (8,'风衣'), (9,'梦幻/大话'), (9,'魔兽'), (9,'QQ 点卡'), (9,'装备'),
(9,'帐号'), (10,'韩剧'), (10,'明星'), (10,'演唱会'), (10,'音乐CD'), (10,'电影DVD');
INSERT INTO delivery (name,cost,description) VALUES
('EMS','15.00','邮政EMS'),
('申通快递','10.00','申通快递'),
('普通平邮','5.00','邮政普通平邮'),
('圆通快递','8.00','还行的快递公司');
INSERT INTO memberlevel (stp,enp,levelname,discount) VALUES
(,'VIP客户','0.900'),
(,'钻石客户','0.850'),
(999,'批发商家','0.300'),
(9999,'成本价格','1.000');
INSERT INTO news (title,content,keyw,postdate) VALUES
('放心购物在当当网联营店','放心购物在当当网联营店','网联营店',' 07:46:52'),
('当当网联营店：先行赔付','当当网联营店：先行赔付&BR&','先行赔付',' 08:16:48'),
('贴心保障：假一赔一','贴心保障：假一赔一','假一赔一',' 08:17:03'),
('买贵了:双倍礼券赔付','买贵了:双倍礼券赔付&BR&','礼券',' 08:17:22'),
('服务提速:4小时专递','服务提速:4小时专递','专递',' 08:18:50'),
('购物无忧：24小时服务','购物无忧：24小时服务','24小时服务',' 08:19:07'),
('购物满99元免运费','购物满99元免运费','购物满99元免运费',' 08:19:17'),
('浦发卡网上支付优惠说明!','&TABLE cellSpacing=2 cellPadding=2 width=560 align=center border=0&\r\n&TBODY&\r\n&TR&\r\n&TD&&IFRAME border=0 marginWidth=0 marginHeight=0 src=\"/html.ng/site=netease&affiliate=biz&cat=article&type=columnarticle&location=1\" frameBorder=no width=550 scrolling=no height=150&&/IFRAME&&/TD&&/TR&&/TBODY&&/TABLE&&!-- 文章主体内容 --&\r\n&DIV id=endMain&&!-- 文章标题信息 --&\r\n&DIV class=arcTitle&\r\n&H3&盛大痛下决心整风革新管理 痛批内部丑恶现象 &IMG src=\"/turbo_cwcshop/Face/face77.gif\" border=0&&/H3&\r\n&DIV class=text& 16:36:02　来源: &A href=\".cn/southnews/dd/dsb/\" target=_blank&南方报业网&/A&(广州)　 &A class=cDRed href=\"javascript:reply_allReply()\" target=_self&网友评论 &SPAN class=cDRed id=replycounttop&0&/SPAN& 条&/A& &A href=\"/bizbbs/\"&进入论坛&/A&&/DIV&&/DIV&\r\n&DIV id=endText&\r\n&P style=\"TEXT-INDENT: 2em\"&6月28日，盛大与英特尔宣布结成合作伙伴，共同推广游戏《龙与地下城》，这被看成是盛大收复失地的信号。&/P&\r\n&P style=\"TEXT-INDENT: 2em\"&近期，盛大北京分公司调整、市场中心解散，以及最近传出的SDS部门(内容事业部)裁员、几位中高层离职等消息，似乎更成为这一论断的注脚。&/P&\r\n&P style=\"TEXT-INDENT: 2em\"&日前，盛大新闻发言人诸葛辉证实，盛大内部目前推出了涉及所有部门的末位淘汰制度。而且还针对其主营业务部门、游戏运营中心SDG事业部进行了组织架构调整。&/P&\r\n&P style=\"TEXT-INDENT: 2em\"&按照陈天桥大输大赢的性格，越是在关键时刻越是要进行在外界看来可能“伤筋动骨”的改革，盛大到底发生了什么？&/P&\r\n&P style=\"TEXT-INDENT: 2em\"&&STRONG&盛大痛下决心搞“整风”&/STRONG&&/P&\r\n&P style=\"TEXT-INDENT: 2em\"&“外界聚焦的所谓人事“动荡”，其实是盛大内部建设的必然结果。”诸葛辉表示。&/P&\r\n&P style=\"TEXT-INDENT: 2em\"&在采访中，一位盛大的离职员工说，盛大一度人、财、物的扩张速度非常快，而盛大人的“创业基因”则不断被稀释和融合，这让盛大高层极为不满。&/P&\r\n&P style=\"TEXT-INDENT: 2em\"&去年以来，有感于盛大内部“大锅饭问题”、“资历问题”、“员工素质问题”等等，盛大董事长陈天桥号召发起了所谓“新文化运动”，痛批内部的丑恶现象。&/P&\r\n&P style=\"TEXT-INDENT: 2em\"&从去年下半年开始，盛大开始有意识加强内部控制，通过加强 审计、考核激励等措施，负责人力资源的盛大集团高级副总裁张燕梅把盛大这次已经持续半年多的组织架构调整，称作“瘦身”运动。&/P&\r\n&P style=\"TEXT-INDENT: 2em\"&张燕梅表示，盛大之所以做这些工作，是为了把堆积在高层的危机感有层次分解到企业层面，制造一种内部危机感。&/P&\r\n&P style=\"TEXT-INDENT: 2em\"&目前，一系列的规范化“整风”运动已经使不合理费用被大大压缩，企业的利润率也随之增加。&/P&\r\n&P style=\"TEXT-INDENT: 2em\"&“盛大之所以对2006年第一季度的财报表现出前所未有的积极态度(尽管收入已到历史最低)，跟内部控制的信心增强也有很大关系。这一点也得到了华尔街的认同和肯定。”&/P&\r\n&P style=\"TEXT-INDENT: 2em\"&&STRONG&新游戏成制度改革产物&/STRONG&&/P&\r\n&P style=\"TEXT-INDENT: 2em\"&此前，盛大北京分公司裁员70%以上的消息，也成为业界关注的一个焦点。&/P&\r\n&P style=\"TEXT-INDENT: 2em\"&采访中，盛大人力资源部经理陈越坦言。“盛大在年终对北京分公司做考核时，发现其商业模式不明，组织架构不清，没有任何核算和成本控制，费用支出惊人，增加了总公司的负担。”&/P&\r\n&P style=\"TEXT-INDENT: 2em\"&据了解，盛大早就开始建立以绩效目标管理为中心的激励制度，对被发现目标与收益有差异的部门进行常规调整，并保持5%-10%的淘汰率。&/P&\r\n&P style=\"TEXT-INDENT: 2em\"&据了解，目前盛大SDG事业部也在组织架构调整。&/P&\r\n&P style=\"TEXT-INDENT: 2em\"&以前，将所有的游戏项目设置在一个中心内，形成与其它游戏的支持中心并列的组织架构。当游戏项目大量增加后，这种大项目管小项目，甚至多个项目平衡管理，盈亏都划归公司的组织设置方式，不能给各项目部明确资源，对人员也激励不够，造成一些项目的重大损耗。&/P&\r\n&P style=\"TEXT-INDENT: 2em\"&实行垂直管理改革后，几十个项目部都将直属于事业部垂直管理，为各项目部打通了上升空间，项目都是单独列出，盈亏与项目组成员利益挂钩。成员职务甚至可以一直升到副总裁；反之成员的收入就会跟着下跌，直到最后项目撤消，成员下岗。&/P&\r\n&P style=\"TEXT-INDENT: 2em\"&据了解，盛大目前推出的两款大型网游《霸王大陆》和《龙与地下城》，以及正在研发的 迪士尼休闲网游，都是这个新制度下的产物。&/P&\r\n&P style=\"TEXT-INDENT: 2em\"&本报记者李宽宽 &A href=\"/\"&&IMG class=icon height=14 alt=橙子 src=\"/biz/newimg/arc_d.gif\" width=14 border=0&&/A& &/P&&/DIV&&!-- 分页 --&&!-- 发给好友 --&&/DIV&','浦发卡网上支付优惠说明',' 08:19:26'),
('常见问题','&TABLE class=p9v cellSpacing=0 cellPadding=0 width=\"92%\" border=0&\r\n&TBODY&\r\n&TR&\r\n&TD class=p12co align=middle height=28&订购须知 \r\n&HR noShade SIZE=1&\r\n&/TD&&/TR&\r\n&TR&\r\n&TD class=p9content vAlign=top height=132&\r\n&P&&&&&&& &我们的正常送花时间为每天9：00-19:00(节假日照常)。要求在正常送花时间外的特殊时间送花者,请尽量提前咨询订购，我们在确认可完成的前提下，根据实际情况适当加收服务费。&& &BR&&&&&&&& 以下三点是我们的赔偿标准：&BR&&&&&&&&&&B&&BR&&/B&&&&&&&&&&FONT color=#ff0000&一、 误单、漏单&/FONT&&BR&&&&&&&& 情节严重的，付给客户相应损失的双倍赔偿；&BR&&&&&&& &100%全额退款，可按顾客要求退回指定帐户，或存入虚拟帐户中，用于支付下次在网上购物的费用；&BR&&&&&& & 按客户指定时间，重新安排派送价值相同的商品；&BR&&&&&& & 附一张道歉卡，以快乐名义致歉；&&BR&&BR&&&&&&&STRONG&& &FONT color=#ff0000&二、&/FONT&&/STRONG&&FONT color=#ff0000&花材质量问题：不新鲜，有虫眼包装不符和要求，花材数量不够&BR&&/FONT&&&&&&& 100%全额退款，可按顾客要求退回指定帐户，或存入虚拟帐户中，用于支付下次在网上购物的费用； &BR&&&&&&& 按客户指定时间，免费重新安排派送等价值的商品；&BR&&&&&&& 附一张道歉卡，以快乐义致歉。&BR&&BR&&&&&&& &FONT color=#ff0000&三、卡片内容不符，字迹潦草无法看清，延时送达，耽误了客户使用，服务和礼仪不到位和不规范&/FONT&&BR&&&&&&& 情节严重的，免费重新安排派送等价值相同的商品；&BR&&&&&&& 一般性投诉，按花款价值的50%退赔，退赔款存入储值卡户中，用于支付下次在网上购物使用；&BR&&&&&&& 附一张道歉卡，以快乐名义致歉。&BR&&&&&&&& &BR&&&&&&&& 为保证送花的正确性，我们会在送花前与收花人进行电话联系，确认送花时间和地址。在确认无误后递送物品，并尽量做到收花人本人签收。如收花人不在，我们将在确保收花人短时内能收到物品的前提下请他人代签收。&BR&&BR&&&&&&&& 如订花人提出事先不要与收花人联系的要求，请订购时在备注写明(否则无效)。则我们将按照您提供的地址尽力递送。如收花人不在，我们将在确保收花人短时内能收到物品的前提下请他人代签收。如收花人在递送日当天无法收到货品(例：收花人近期不在，地址或电话号码有误，收花人已不在此处，无人代收等)，我们将及时联系订花人商量解决办法（通常可再次递送到您指定的第二个地址）。如确实无法递送，此情况视为递送完成，货款不退。&BR&&BR&&&&&&&& 如订花人提出必须由收花人本人签收的要求，请订购时在备注写明(否则无效)。则我们将在送花前与收花人进行电话联系，确认具体送花时间和地址，在确认无误后递送物品。如物品送到后由于非本网站原因造成收花人无法本人签收，我们将及时联系订花人商量处理办法，此情况视为递送完成，货款不退。&&BR&&BR&&&&&&&& 由收花人或代收人签收,均以签收条为凭证。我们将保留每份订单的签收条一个月供您查询，如果你想确认收花人是否收到鲜花请在一个月内查询，过期将不提供此服务。&BR&&BR&&&&&&&& 如因非本网站原因收花人拒收物品，则我们将请收花人在签收栏填写\"拒收，签名\"字样，停止递送物品并告知订花人。此情况视为递送完成，货款不退。&BR&&BR&&&&&&&&&我们将根据送花的实际情况尽力按您的要求来安排送花，但高峰送花日(如情人节,母亲节,圣诞节等节日) 由于送货量大、线路安排、交通状况等原因，我们只保证在当天送达，如没有按您要求的配送人员或时间段送达，请谅解。&BR&&BR&&&&&&&& 由于鲜花是手工制作，各花师对图片上花型的理解不同，实际产品与网页上看到的图片可能会有一些差异（部分图片来源于各地代理花店或互联网）。由于地区和季节及其它特殊原因的限制，如果有些花材或颜色在当时没有，我们会及时联系订货人确定其它花材。如订单紧急，我们在不影响您所选的鲜花效果的情况下，按照寓意相同、类似花材、价值相同替代原则代替，希望您能谅解。&BR&&/P&&/TD&&/TR&&/TBODY&&/TABLE&&BR&&BR&\r\n&TABLE class=p9v cellSpacing=0 cellPadding=0 width=\"92%\" border=0&\r\n&TBODY&\r\n&TR&\r\n&TD class=p12co align=middle height=28&为什么购物后没有与我联系？ \r\n&HR noShade SIZE=1&\r\n&/TD&&/TR&\r\n&TR&\r\n&TD class=p9content vAlign=top height=132&&SPAN style=\"FONT-SIZE: 10 COLOR: FONT-FAMILY: 宋体; mso-ascii-font-family: \'Times New Roman\'; mso-hansi-font-family: \'Times New Roman\'; mso-bidi-font-family: 宋体; mso-font-kerning: 1.0 mso-ansi-language: ZH-CN; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA\"&答：通常的无法与顾客取得联系的原因有：&BR&&&& 1、您如果没有成为快乐会员，请在付款前后主动联系我们，因为您没有留下任何和你取得联系的方式，我们无法和你取得联系。&BR&&&& 2、如果你以快乐会员身份订购：&BR&&&&&&&（1）&SPAN style=\"FONT-SIZE: 10 COLOR: FONT-FAMILY: \'Times New Roman\'; mso-bidi-font-family: 宋体; mso-font-kerning: 1.0 mso-ansi-language: ZH-CN; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体\"&&&/SPAN&&SPAN style=\"FONT-SIZE: 10 COLOR: FONT-FAMILY: 宋体; mso-ascii-font-family: \'Times New Roman\'; mso-hansi-font-family: \'Times New Roman\'; mso-bidi-font-family: 宋体; mso-font-kerning: 1.0 mso-ansi-language: ZH-CN; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA\"&会员注册信息中的电子邮件信箱已作废或有误：如多一个空格、少一个点号、&/SPAN&&SPAN style=\"FONT-SIZE: 10 COLOR: FONT-FAMILY: \'Times New Roman\'; mso-bidi-font-family: 宋体; mso-font-kerning: 1.0 mso-ansi-language: ZH-CN; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体\"& &/SPAN&&SPAN style=\"FONT-SIZE: 10 COLOR: FONT-FAMILY: 宋体; mso-ascii-font-family: \'Times New Roman\'; mso-hansi-font-family: \'Times New Roman\'; mso-bidi-font-family: 宋体; mso-font-kerning: 1.0 mso-ansi-language: ZH-CN; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA\"&字母顺序颠倒等。&BR&&&&&&&（2）&SPAN style=\"FONT-SIZE: 10 COLOR: FONT-FAMILY: 宋体; mso-ascii-font-family: \'Times New Roman\'; mso-hansi-font-family: \'Times New Roman\'; mso-bidi-font-family: 宋体; mso-font-kerning: 1.0 mso-ansi-language: ZH-CN; mso-fareast-language: ZH-CN
首先,出现多对多就是设计上的不对,一定要将多对多拆成一对多,然后很多问题就不存在了,这是正道.
已解决问题
未解决问题