关于巴巴运动网InitAction.java的问题？

Question

关于巴巴运动网的：
···省略
/**
 * ���ϵͳ����Ա
 */
private void initEmployee() {
if(employeeService.getCount()==0){
Employee employee = new Employee("admin");
employee.setDegree("��ѧ");
employee.setEmail("[email protected]");
employee.setGender(Gender.MAN);
employee.setIdCard(new IDCard("111111", "����", new Date()));
employee.setPassword("123456");
employee.setPhone("1");
employee.setRealname("����Ա");
employee.setSchool("xx");
employee.getGroups().addAll(groupService.getScrollData().getResultlist());
employeeService.save(employee);
}
}
···省略
上面是cn.itcast.web.action包中InitAction.java代码，自己运行后还是会出现下面的状况：
状况1进入管理后台输入admin和123456后无法登陆后台管理；
状况2打开http://localhost:8080/system/init.do后就出现了下面的代码。
问题：请问这是什么原因呢？是不是还没有初始化成功呢？
HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: org.springframework.transaction.TransactionSystemException: Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Error while commiting the transaction
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:520)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:427)
cn.itcast.web.action.privilege.PermissionProcessor.processActionPerform(PermissionProcessor.java:31)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
cn.itcast.web.filter.SetCodeFilter.doFilter(SetCodeFilter.java:43)
org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:112)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
root cause org.springframework.transaction.TransactionSystemException: Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Error while commiting the transaction
org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:465)
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:709)
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:678)
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
$Proxy42.batchSave(Unknown Source)
cn.itcast.web.action.InitAction.initSystemPrivilege(InitAction.java:130)
cn.itcast.web.action.InitAction.execute(InitAction.java:39)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
cn.itcast.web.action.privilege.PermissionProcessor.processActionPerform(PermissionProcessor.java:31)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
cn.itcast.web.filter.SetCodeFilter.doFilter(SetCodeFilter.java:43)
org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:112)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
root cause javax.persistence.RollbackException: Error while commiting the transaction
org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:71)
org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:456)
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:709)
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:678)
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
$Proxy42.batchSave(Unknown Source)
cn.itcast.web.action.InitAction.initSystemPrivilege(InitAction.java:130)
cn.itcast.web.action.InitAction.execute(InitAction.java:39)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
cn.itcast.web.action.privilege.PermissionProcessor.processActionPerform(PermissionProcessor.java:31)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
cn.itcast.web.filter.SetCodeFilter.doFilter(SetCodeFilter.java:43)
org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:112)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

Answer 1

root cause org.hibernate.exception.GenericJDBCException: could not insert: [cn.itcast.bean.privilege.SystemPrivilege]
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2295)
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2688)
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:456)
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:709)
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:678)
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
$Proxy42.batchSave(Unknown Source)
cn.itcast.web.action.InitAction.initSystemPrivilege(InitAction.java:130)
cn.itcast.web.action.InitAction.execute(InitAction.java:39)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
cn.itcast.web.action.privilege.PermissionProcessor.processActionPerform(PermissionProcessor.java:31)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
cn.itcast.web.filter.SetCodeFilter.doFilter(SetCodeFilter.java:43)
org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:112)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
root cause java.sql.BatchUpdateException: Incorrect string value: '\xD7\xAA\xEF\xBF\xBD\xD1...' for column 'name' at row 1
com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:648)
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:56)
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2275)
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2688)
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:456)
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:709)
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:678)
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
$Proxy42.batchSave(Unknown Source)
cn.itcast.web.action.InitAction.initSystemPrivilege(InitAction.java:130)
cn.itcast.web.action.InitAction.execute(InitAction.java:39)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
cn.itcast.web.action.privilege.PermissionProcessor.processActionPerform(PermissionProcessor.java:31)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
cn.itcast.web.filter.SetCodeFilter.doFilter(SetCodeFilter.java:43)
org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:112)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.
--------------------------------------------------------------------------------Apache Tomcat/6.0.18

Answer 2

批量提交的时候有， name 有不正确的值:java.sql.BatchUpdateException: Incorrect string value: '\xD7\xAA\xEF\xBF\xBD\xD1...' for column 'name' at row 1
可能是编码的问题(比如乱码)，数据库字符集不支持，LZ好好检查下啊。

Answer 3

巴巴运动网的后台，为什么进入不了呢？admin+123456
package cn.itcast.web.action;import java.util.ArrayList;
import java.util.Date;
import java.util.List;import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.springframework.stereotype.Controller;import cn.itcast.bean.privilege.Employee;
import cn.itcast.bean.privilege.IDCard;
import cn.itcast.bean.privilege.PrivilegeGroup;
import cn.itcast.bean.privilege.SystemPrivilege;
import cn.itcast.bean.user.Gender;
import cn.itcast.service.privilege.EmployeeService;
import cn.itcast.service.privilege.PrivilegeGroupService;
import cn.itcast.service.privilege.SystemPrivilegeService;
import cn.itcast.utils.SiteUrl;
/**
 * 系统初始化
 */
@Controller("/system/init")
public class InitAction extends Action {
@Resource SystemPrivilegeService privilegeService;
@Resource PrivilegeGroupService groupService;
@Resource EmployeeService employeeService; @Override
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
initSystemPrivilege();
initSystemGroup();
initEmployee();
request.setAttribute("message", "初始化成功");
request.setAttribute("urladdress", SiteUrl.readUrl("control.control.center"));
return mapping.findForward("message");
}
/**
 * 添加系统管理员
 */
private void initEmployee() {
if(employeeService.getCount()==0){
Employee employee = new Employee("admin");
employee.setDegree("大学");
employee.setEmail("[email protected]");
employee.setGender(Gender.MAN);
employee.setIdCard(new IDCard("111111", "北京", new Date()));
employee.setPassword("123456");
employee.setPhone("1");
employee.setRealname("管理员");
employee.setSchool("xx");
employee.getGroups().addAll(groupService.getScrollData().getResultlist());
employeeService.save(employee);
}
}
/**
 * 添加系统权限组
 */
private void initSystemGroup() {
if(groupService.getCount()==0){
PrivilegeGroup group = new PrivilegeGroup();
group.setName("系统管理组");
group.getPrivileges().addAll(privilegeService.getScrollData().getResultlist());
groupService.save(group);
}
}
/**
 * 添加系统权限
 */
private void initSystemPrivilege() {
if(privilegeService.getCount()==0){
List<SystemPrivilege> privileges = new ArrayList<SystemPrivilege>();
privileges.add(new SystemPrivilege("privilegeGroup","delete","权限组删除"));
privileges.add(new SystemPrivilege("privilegeGroup","insert","权限组添加"));
privileges.add(new SystemPrivilege("privilegeGroup","update","权限组修改"));
privileges.add(new SystemPrivilege("privilegeGroup","view","权限组查看"));

privileges.add(new SystemPrivilege("department","delete","部门删除"));
privileges.add(new SystemPrivilege("department","insert","部门添加"));
privileges.add(new SystemPrivilege("department","update","部门修改"));
privileges.add(new SystemPrivilege("department","view","部门查看"));

privileges.add(new SystemPrivilege("order","turnReceived","转已收货订单"));
privileges.add(new SystemPrivilege("order","turnDelivered","转已发货订单"));
privileges.add(new SystemPrivilege("order","turnWaitdeliver","转等待发货订单"));
privileges.add(new SystemPrivilege("order","cancelOrder","取消订单"));
privileges.add(new SystemPrivilege("order","confirmOrder","审核通过订单"));
privileges.add(new SystemPrivilege("order","confirmPayment","确认订单费用已支付"));
privileges.add(new SystemPrivilege("order","allUnLock","批量解锁订单"));
privileges.add(new SystemPrivilege("order","view","订单查看"));
privileges.add(new SystemPrivilege("order","modifyContactInfo","订单联系信息修改"));
privileges.add(new SystemPrivilege("order","modifyDeliverInfo","订单配送信息修改"));
privileges.add(new SystemPrivilege("order","modifyPaymentWay","支付方式修改"));
privileges.add(new SystemPrivilege("order","modifyDeliverWay","配送方式修改"));
privileges.add(new SystemPrivilege("order","modifyProductAmount","商品购买数量修改"));
privileges.add(new SystemPrivilege("order","modifyDeliverFee","配送费修改"));
privileges.add(new SystemPrivilege("order","deleteOrderItem","删除订单项"));

privileges.add(new SystemPrivilege("employee","leave","员工离职设置"));
privileges.add(new SystemPrivilege("employee","reg","员工注册"));
privileges.add(new SystemPrivilege("employee","update","员工信息修改"));
privileges.add(new SystemPrivilege("employee","view","员工查看"));
privileges.add(new SystemPrivilege("employee","privilegeGroupSet","员工权限设置"));

privileges.add(new SystemPrivilege("brand","insert","品牌添加"));
privileges.add(new SystemPrivilege("brand","update","品牌信息修改"));
privileges.add(new SystemPrivilege("brand","view","品牌查看"));

privileges.add(new SystemPrivilege("product","insert","产品添加"));
privileges.add(new SystemPrivilege("product","update","产品信息修改"));
privileges.add(new SystemPrivilege("product","view","产品查看"));
privileges.add(new SystemPrivilege("product","visible","产品上/下架"));
privileges.add(new SystemPrivilege("product","commend","产品推荐"));

privileges.add(new SystemPrivilege("productType","insert","产品类别添加"));
privileges.add(new SystemPrivilege("productType","update","产品类别修改"));
privileges.add(new SystemPrivilege("productType","view","产品类别查看"));

privileges.add(new SystemPrivilege("buyer","enable","网站用户启用"));
privileges.add(new SystemPrivilege("buyer","delete","网站用户禁用"));
privileges.add(new SystemPrivilege("buyer","view","网站用户查看"));
privilegeService.batchSave(privileges);
}
}}
没错啊？？？

Answer 4

管理员admin跟密码123456都没错，但为什么登录不了呢？是不是还要修改哪里呢？

Answer 5

。我遇到的则是
Caused by: net.paoding.analysis.exception.Paodin
gAnalysisException: dic home should not be a file, but a directory!