java环境1

一，jdk安装

    1，解压

    2，环境变量：

         a.  JAVA_HOME : D:\jdk150_06

         b.  path : %JAVA_HOME%\bin;%JAVA_HOME%\jre\bin

         c.  CLASSPATH : .;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME %\lib\tools.jar;

    3，测试： java -version 

 

二， tomcat安装

     1，解压

     2，修改JAVA_HOME:  修改catalina.bat 里面的 set JAVA_HOME=D:\jdk150_06

 

三， eclipse j2ee ide

1,新建web项目

  a.  file -> new -> dynamic web project

  b.  next

 

2,配置tomcat

  a.  window - > preferences -> server -> runtime enviroments -> add -> 选择tomcat安装目录

 

四， oracle安装

1，按提示安装：数据库口令：xxx
全局数据库名：orcl
系统标识（SID）：orcl
服务器参数文件名：E:\oracle\product\10.2.0\db_1/dbs/spfileorcl.ora
Database Control URL 为 http://GZ_Vanceinfo:1158/em

 

2，用PL/SQL登录：用户名：SYSTEM   密码：xxx

 

3,  创建用户：

CREATE USER testuser
IDENTIFIED BY xxx
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP;

 

4，赋权限：

grant connect to testuser;
grant dba to testuser;
grant sysdba to testuser;

 

5，用testuser登录，建表test：

create table test (tid int not null,tname varchar(10));

 

6，jdbc测试，下载oracle驱动包ojdbc14.jar

 

7，编写测试代码：

import java.sql.CallableStatement;  
import java.sql.Connection;  
import java.sql.DriverManager;  
import java.sql.PreparedStatement;  
import java.sql.ResultSet;  
import java.sql.Types;  
public class ConnectionManager {  
    public static void main(String[] args) {  
       try {  
           Class.forName("oracle.jdbc.driver.OracleDriver");  
           String url = "jdbc:oracle:thin:@localhost:1521:orcl";  
           Connection conn = DriverManager.getConnection(url, "testuser", "xxx");  
           System.out.println("链接成功：" + conn.toString());  
           conn.setAutoCommit(true); // 设置自动提交  
 

           // 查询，带有分页语句  
           String sql_select = "select tid,tname from test";  
           PreparedStatement pstmt_sel = conn.prepareStatement(sql_select);  
//           pstmt_sel.setInt(1, 4);  
//           pstmt_sel.setInt(2, 3);  
           ResultSet rs = pstmt_sel.executeQuery();  
           while (rs.next()) {  
               System.out.println(rs.getInt("tid") + " " 
                       + rs.getString("tname"));  
           }  
 
           // 增加  
           String sql_insert = "insert into test values(1,?)";  
           PreparedStatement pstmt_add = conn.prepareStatement(sql_insert);  
           pstmt_add.setString(1, "JDBC测试2");  
           int result_insert = pstmt_add.executeUpdate();  
           System.out.println(result_insert);  
 
// 删除  
           String sql_delete = "delete from test where tid=?";  
           PreparedStatement pstmt_del = conn.prepareStatement(sql_delete);  
           pstmt_del.setInt(1, 2);  
           int result_delete = pstmt_del.executeUpdate();  
           System.out.println(result_delete);  
 
           // 修改  
           String sql_update = "update test set tname=? where tid=?";  
           PreparedStatement pstmt_mod = conn.prepareStatement(sql_update);  
           pstmt_mod.setString(1, "FBI组");  
           pstmt_mod.setInt(2, 2);  
           int result_update = pstmt_mod.executeUpdate();  
           System.out.println(result_update);  
 
       } catch (Exception e) {  
           e.printStackTrace();  
       }  
   }  
} 

 

 五，struts2（2.2.1）搭建

1，准备6个必须的jar文件：

     a.   commons-fileupload-1.2.1.jar

     b.   commons-io-1.3.2.jar

     c.    freemarker-2.3.16.jar

     d.   javassist-3.7.ga.jar

     e.   ognl-3.0.jar

     f.    struts2-core-2.2.1.1.jar

     g.   xwork-core-2.2.1.1.jar

2, 配置struts2的过滤器

<filter>
   <filter-name>
   struts2
   </filter-name>
   <filter-class>
   org.apache.struts2.dispatcher.FilterDispatcher
   </filter-class>
  </filter>
 
 
  <filter-mapping>
   <filter-name>struts2</filter-name>
   <url-pattern>/*</url-pattern>
  </filter-mapping>
  <!-- struts2 end -->

3，配置action

<struts> 
   <package name="test"  extends="struts-default">
        <action name="hello" class="com.vance.struts.test.TestAction" >
   <result>/WEB-INF/page/hello.jsp</result>
        </action>
    </package>
</struts>

4，编写action

public class TestAction extends ActionSupport{
 
 private List<String> list;

 public String execute(){
  System.out.println("---execute---");
  return "success";
 }
 
 public String test(){
  System.out.println("---test---");
  return "success";
 }

 public List<String> getList() {
  if (list == null){
   list = new ArrayList<String>();
   list.add("a");
   list.add("b");
   list.add("c");
  }
  return list;
 }

 public void setList(List<String> list) {
  this.list = list;
 }

}

 

5，编写jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@taglib prefix='s' uri='/struts-tags' %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>struts2 测试</title>

</head>
<body>
 
 这里是内容。
 <s:iterator value="list">
  <s:property />
 </s:iterator>

</body>
</html>

6，部署项目，ie测试

http://localhost:8080/web1/test/hello.action

 

7，国际化

   a.   struts.xml 中添加<constant name="struts.custom.i18n.resources" value="zqmmsg"></constant>

   b.  类根目录下添加文件zqmmsg_zh_CN.properties

   c.  jsp中引用
 <s:text name="test.content" />