J2EE 企业应用开发开发环境.ppt

j2ee 企业应用开发开发环境,刘持标 数学与计算机科学系 2011年3月,java se development kit 安装（1）,java se development kit 安装（2）,java se development kit 安装（3）,java se development kit 安装（4）,java se development kit 安装（5）,java se development kit 安装（6）,可以忽略注册，关闭窗口,windows xp java_home、jre_home 配置（1）,windows xp java_home、jre_home 配置（2）,windows xp java_home、jre_home 配置（3）,windows 7 java_home、jre_home 配置（1）,windows 7 java_home、jre_home 配置（2）,windows 7 java_home、jre_home 配置（3）,windows 7/xp java_home、jre_home 配置（1）,java_home c:program filesjavajdk1.6.0_23 jre_home c:program filesjavajre6,windows 7/xp java_home、jre_home 配置（2）,windows 7/xp java_home、jre_home 配置（3）,安装mysql database (1),安装mysql database (2),安装mysql database (3),安装mysql database (4),安装mysql database (5),instance and database,the terms instance and database are closely related, but dont refer to the same thing. the database is the set of files where application data and meta data is stored. an instance is the software (and memory) that mysql or other db software uses to manipulate the data in the database. in order for the instance to be able to manipulate that data, the instance must open the database. a database can be opened (or mounted) by more than one instance, however, an instance can open at most one database.,安装mysql database (6),安装mysql database (7),安装mysql database (8),安装mysql database (9),innodb 给 mysql 提供了具有事务(transaction)、回滚(rollback) 和崩溃修复能力(crash recovery capabilities)、多版本并发控制(multi-versioned concurrency control)的事务安全(transaction-safe (acid compliant)型表。,安装mysql database (10),安装mysql database (11),安装mysql database (12),安装mysql database (13),安装mysql database (14),安装mysql database (15),sanming2011,安装mysql database (16),安装mysql database (17),安装mysql database (18),安装mysql database (19),安装mysql database (20),安装mysql database (21),安装mysql database (22),安装mysql database (23),安装mysql database (24),安装mysql database (25),create database test_db default character set gbk collate gbk_chinese_ci; create table test_table (id int(11) not null,姓名 char(10) not null)engine = myisam; insert into test_table values(1,刘持标); select * from test_table;,安装mysql database (26),配置java-mysql-jdbc（1）,配置java-mysql-jdbc（2）,配置java-mysql-jdbc（3）,配置java-mysql-jdbc（4）,配置java-mysql-jdbc（5）,配置apache tomcat服务器（1）,配置apache tomcat服务器（2）,配置apache tomcat服务器（3）,配置apache tomcat服务器（4）,配置apache tomcat服务器（5）,配置apache tomcat服务器（6）,配置apache tomcat服务器（7）,配置apache tomcat服务器（8）,配置apache tomcat服务器（9）,$catalina_homebinstartup.bat $catalina_homebinshutdown,配置apache tomcat服务器（10）,配置apache tomcat服务器（11）,配置apache tomcat服务器（12）,配置apache tomcat服务器（13）,配置apache tomcat服务器（14）,安装netbeans 开发平台（1）,安装netbeans 开发平台（2）,安装netbeans 开发平台（3）,安装netbeans 开发平台（4）,安装netbeans 开发平台（5）,安装netbeans 开发平台（6）,安装netbeans 开发平台（7）,安装netbeans 开发平台（8）,安装netbeans 开发平台（9）,测试netbeans 开发平台（1）,测试netbeans 开发平台（2）,测试netbeans 开发平台（3）,测试netbeans 开发平台（4）,测试netbeans 开发平台（5）,测试netbeans 开发平台（6）,测试netbeans 开发平台（7）,测试netbeans 开发平台（8）,测试netbeans 开发平台（9）,测试netbeans 开发平台（10）,配置mysql 数据库（1）,配置mysql 数据库（2）,配置mysql 数据库（3）,e:applicationsnetbeans 6.9.1idemodulesextmysql-connector-java-5.1.6-bin.jar,配置mysql 数据库（4）,配置mysql 数据库（5）,配置mysql 数据库（6）,配置mysql 数据库（7）,配置mysql 数据库（8）,配置mysql 数据库（9）,create database javaeetests default character set gbk collate gbk_chinese_ci; use javaeetests create table lcb_studentrecord (studentnumber int not null primary key,name char(60) not null,finalgrade double, timestamp timestamp(8)engine = myisam; insert into lcb_studentrecord(studentnumber,name,finalgrade) values(1,刘持标,90);,配置mysql 数据库（10）,配置mysql 数据库（11）,配置mysql 数据库（12）,配置mysql 数据库（13）,配置mysql 数据库（14）,配置mysql 数据库（15）,mysql-j2ee(jsp-servlet)web 服务（1）,mysql-j2ee(jsp-servlet)web 服务（2）,mysql-j2ee(jsp-servlet)web 服务（3）, jsp page “); out.println(“学号姓名成绩记录时间“); while (rs.next() out.println(“+ rs.getstring(1)+“+ rs.getstring(2)+“); out.println(rs.getdouble(3)+“+ rs.getstring(4)+ “); out.println(“); rs.close(); catch (classnotfoundexception e) out.println(“couldnt load database driver: “ + e.getmessage(); catch (sqlexception e) % ,mysql-j2ee(jsp-servlet)web 服务（4）,mysql-j2ee(jsp-servlet)web 服务（5）,mysql-j2ee(jsp-servlet)web 服务（6）,mysql-j2ee(jsp-servlet)web 服务（7）,mysql-j2ee(jsp-servlet)web 服务（8）, jsp page 学生成绩登记表 姓名: 学号: 期末成绩: 当前时间: ,mysql-j2ee(jsp-servlet)web 服务（9）,mysql-j2ee(jsp-servlet)web 服务（10）,mysql-j2ee(jsp-servlet)web 服务（11）,mysql-j2ee(jsp-servlet)web 服务（12）,mysql-j2ee(jsp-servlet)web 服务（13）,mysql-j2ee(jsp-servlet)web 服务（14）,package server; import java.io.ioexception; import java.io.printwriter; import javax.servlet.servletexception; import javax.servlet.annotation.webservlet; import javax.servlet.http.httpservlet; import javax.servlet.http.httpservletrequest; import javax.servlet.http.httpservletresponse; import java.sql.*; import java.util.properties;,插入,mysql-j2ee(jsp-servlet)web 服务（15）,这些行将被下页替换,mysql-j2ee(jsp-servlet)web 服务（16）,protected void processrequest(httpservletrequest request, httpservletresponse response) throws servletexception, ioexception, classnotfoundexception, sqlexception response.setcontenttype(“text/html;charset=utf-8“); printwriter out = response.getwriter(); try string databaseurl = “jdbc:mysql:/localhost:3306/javaeetests?useunicode=true ,mysql-j2ee(jsp-servlet)web 服务（17）,override protected void doget(httpservletrequest request, httpservletresponse response) throws servletexception, ioexception try processrequest(request, response); catch (classnotfoundexception ex) logger.getlogger(lcb_storerecord.class.getname().log(level.severe, null, ex); catch (sqlexception ex) logger.getlogger(lcb_storerecord.class.getname().log(level.severe, null, ex); override protected void dopost(httpservletrequest request, httpservletresponse response) throws servletexception, ioexception try processrequest(request, response); catch (classnotfoundexception ex) logger.getlogger(lcb_storerecord.class.getname().log(level.severe, null, ex); catch (sqlexception ex) logger.getlogger(lcb_storerecord.class.getname().log(level.severe, null, ex); ,mysql-j2ee(jsp-servlet)web 服务（18）,mysql-j2ee(jsp-servlet)web 服务（19）,mysql-j2ee(jsp-servlet)web 服务（20）,mysql-j2ee(jsp-servlet)web 服务（21）, jsp page function trim(s) return s.replace( /s*/, “ ).replace( /s*$/, “ ); function validate() if(trim(document.frmlogin.susername.value)=“) alert(“login empty“); document.frmlogin.susername.focus(); return false; else if(trim(document.frmlogin.spwd.value)=“) alert(“password empty“); document.frmlogin.spwd.focus(); return false; user name password ,create table usermaster ( suserid varchar(45) not null, semail varchar(250) not null, sfirstname varchar(45) not null, slastname varchar(45) not null, idob datetime not null, cgender varchar(45) not null, icountryid int(10) unsigned not null, icityid varchar(45) not null, iusertype varchar(45) default null, iuserlevel varchar(45) default null, spassword varchar(45) not null, sforgetpassword varchar(45) default null, scontact bigint(20) unsigned not null, screatedby varchar(45) default null, dcreateddate datetime default null, smodifiedby varchar(45) default null, smodifieddate datetime default null, sstatus varchar(45) not null, primary key (suserid), unique key semail (semail) ) engine = my