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" >
???<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" />
?