JspRun学习 搭建开发环境

          Java EE for Web Developers

Date: 01.1.15

---------------------------------------------------- DevSet ----------------------------------------------------

DEV
 JavaDevKit: JDK1.5
 WebServer/Container(Jsp/Servlet): Tomcat5.5
 DB: MySQL5.0
 IDE:Eclipse(Java EE 3.5)
 
 DBManager: MySQLYou、phpMyAdmin、MySQL Command Line Client

JAR(Eclipse J2EE)
 jsp-api.jar
 servlet-api.jar

 

---------------------------------------------------- JspRun ----------------------------------------------------

# JspRun Encoding:
 UTF-8
 
# DB config:
 /JspRun/WebContent/config.properties
 
# DB Script:
 /JspRun/WebContent/install/jsprun_zh_CN.sql 
 150,256 bytes 146M

# DB properties
 /JspRun/src/cn/jsprun/struts/*.properties

# DB DAO
 /JspRun/src/cn/jsprun/dao/impl/CronsDaoImpl.java

# DB Util
 /JspRun/src/cn/jsprun/utils/HibernateUtil.java

# DB table
 jrun_members  成员(管理员：username:admin  password:admin)
 jrun_admingroups 管理员组(权限)

 

---------------------------------------------------- Run Project ------------------------------------------------
# Hello JspRun!
 http://localhost:8080/

 

---------------------------------------------------- Exception --------------------------------------------------

# 数据库表中添加了不合法的测试数据，导致的系统初始化异常!
2010-1-15 14:57:51 org.apache.catalina.core.StandardHostValve custom
严重: Exception Processing ErrorPage[errorCode=500, location=/errors/error_500.jsp]
org.apache.jasper.JasperException: Exception in JSP: /errors/error_500.jsp:37

34:     }
35:    }
36:    if (flag) {
37:     ForumInit.initServletContext(context);
38:     Cache.updateCache();
39:     request.setAttribute("resultInfo","error_5001");
40:    }
原因：在数据库表中随便添加了些测试数据，导致系统启动初始化错误！
解决：删除数据库并重新导入,前提是数据库没有重要数据!

 

# Tomcat自动发布修改的文件，找不到Work Directory中编译的类文件时抛次异常!
2010-1-15 15:07:03 org.apache.catalina.core.StandardHostValve custom
严重: Exception Processing ErrorPage[errorCode=404, location=/errors/error_404.jsp]
org.apache.jasper.JasperException: Unable to load class for JSP
原因：修改相关文件并保存,Tomcat会自动发布(编译类文件)修改的文件，加载不到，就抛此异常!
解决：清理模块工作目录(Clean Module Work Directory)

 

---------------------------------------------------- Command ----------------------------------------------------

 

# MySQL Command

 * 查看版本
 mysql> \s
 
 * 删除数据库
 mysql> drop database jsprun;
 
 * 创建数据库
 mysql> drop database jsprun;
 
 * 导入脚本到数据库(未登陆)
 C:\Documents and Settings\Administrator>mysql -uroot -proot jsprun < E:\JspRun\WebContent\install\jsprun_zh_CN.sql
 脚本字符集utf8
 C:\Documents and Settings\Administrator>mysql -uroot -proot --default-character-set=utf8 jsprun < E:\jsprun_zh_CN.sql
 
 * 导入数据库(登陆后)
 mysql> source E:\JspRun\WebContent\install\jsprun_zh_CN.sql
 
 * 导出整个数据库到脚本(Dump:转储)
 C:\Documents and Settings\Administrator>mysqldump --opt -d -uroot -proot jsprun > E:\jsprun_zh_CN.sql
 

# JDK Command
 * native2ascii
 用法：native2ascii [-reverse] [-encoding 编码] [输入文件 [输出文件]]
 RE_ApplicationResources.properties GBK