Java程序辅导

Faculty of ESBE  SCADA Systems 
 
 
Dr. Perry XIAO Copyright © 2007-2013, London South Bank University 1 
Lab	
  3:	
  Data	
  Display	
  Through	
  WWW	
  using	
  JSP/MySQL	
  
 
 
The aim of this lab session is to understand how to display the PicoScope 2105 data through 
WWW pages using JSP/MySQL.  
 
Equipments: 
Two networked PCs with WindowsXP operating systems, a piezoelectric sensor, PicoScope 2105 
and its CD, Visual Studio 6 CDs, Java software, MySQL Community Server software, Tomcat 
software, logbook, and a USB memory stick for saving your work. 
 
Exercises 1: 
 
1. Boot up a WindowsXP computer, login as user “link”. To download Java SE JDK 7, just 
go to http://www.oracle.com/technetwork/java/javase/downloads/index.html, and 
follow the instructions to download an install Java	
  JDK	
  7. 
2. by	
  default,	
  Java	
  should	
  be	
  installed	
  in	
  C:\program	
  files\java	
  folder.	
  To	
  Test	
  Java,	
  from	
  a	
  MS-­‐DOS	
  prompt,	
  type 	
  
C:\java	
  	
  –version	
  
	
  
 
Exercises 2: 
 
1. To download Tomcat 7 from http://tomcat.apache.org/, follow the instructions to download 
a file called: apache-­‐tomcat-­‐7.0.26.exe, and save it to your desktop and double click to run 
it. 
2. To test that Tomcat is running, from another Windows XP computer, open a web browser, 
and type in following URL: http://xxx.xxx.xxx.xxx:8080, where xxx.xxx.xxx.xxx is the 
first Windows XP computer’s IP address or domain name. If everything is fine, you should 
be able to see a web page such as this. 
 
 
Faculty of ESBE  SCADA Systems 
 
 
Dr. Perry XIAO Copyright © 2007-2013, London South Bank University 2 
 
3. You can start, stop and configure the Tomcat server from your Desktop, find out how. 	
  	
  
 
Exercises 3: 
 1. To	
   use	
   database	
   in	
   JSP	
   files,	
   first	
   you	
   need	
   to	
   install	
   the	
  MySQL	
   database.	
   Goto	
  	
  http://www.mysql.com/downloads/mysql/,	
   and	
  download	
   and	
   install	
   the	
   latest	
  MySQL	
  database.	
  2. Second,	
   you	
   will	
   need	
   to	
   install	
   Java	
   JDBC	
   driver.	
   Go	
   to	
  http://www.mysql.com/downloads/connector/j/,	
  and	
  download	
  Connector/J.	
  	
  3. This	
  is	
  just	
  an	
  Java	
  JAR	
  file,	
  should	
  be	
  called:	
  	
  
mysql-­‐connector-­‐java-­‐5.1.18.zip	
  	
  4. Unzip	
   the	
   file,	
   and	
   then	
   copy	
   the	
   file	
  mysql-­‐connector-­‐java-­‐5.1.18-­‐bin.jar	
   to	
  following	
  directories.	
  	
  
C:\program	
  files\java\jdk1.6.0\lib	
  
C:\program	
  files\java\jdk1.6.0\jre\lib	
  
C:\program	
  files\java\jdk1.6.0\jre\lib\ext	
  
C:\apache-­‐tomcat-­‐7.0.2\lib	
  
C:\apache-­‐tomcat-­‐7.0.2\webapps\scada\WEB-­‐INF\lib	
  	
  5. Next,	
  start	
  MySQL	
  database	
  service.	
  
 
Exercises 4: 
 
1. To create a JSP web application, first you need to create a web application folder structure 
under the C:\apache-­‐tomcat-­‐7.0.2\webapps\	
   directory. In this case, we create a web 
application called: “scada”, following is its structure. 	
   	
  
C:\apache-­‐tomcat-­‐7.0.2\webapps\	
  
	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  \scada	
  
	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  \WEB-­‐INF	
  
	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  \classes	
  
	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  \lib	
  	
  	
  
2. Create a “index.jsp” file in the C:\apache-­‐tomcat-­‐7.0.2\webapps\scada folder, and put 
following lines into the file. 
 
<%@page	
  contentType="text/html"%>	
  
<%@page	
  pageEncoding="UTF-­‐8"%>	
  
	
  
	
  
	
  
	
  
Faculty of ESBE  SCADA Systems 
 
 
Dr. Perry XIAO Copyright © 2007-2013, London South Bank University 3 
<%@page	
  import	
  =	
  "java.sql.*"%>	
  
<%	
  
	
  	
  try{	
  
	
  	
  	
  	
  	
  	
  	
  	
  Class.forName("com.mysql.jdbc.Driver").newInstance();	
  
	
  	
  	
  	
  	
  	
  	
  	
  Connection	
  connection=DriverManager.getConnection("jdbc:mysql://localhost/scada",	
  
“root”,	
  “letmein”);	
  
	
  
	
  	
  	
  	
  	
  	
  	
  	
  Statement	
  statement=connection.createStatement();	
  
	
  	
  	
  	
  	
  	
  	
  	
  String	
  query;	
  
	
  	
  	
  	
  	
  	
  	
  	
  query="SELECT	
  *	
  FROM	
  picoscope";	
  
	
  	
  	
  	
  	
  	
  	
  	
  ResultSet	
  resultSet=statement.executeQuery(query);	
  
	
  	
  	
  	
  	
  	
  	
  	
  out.println("PicoScope	
  2105
ID	
  Time	
  Value
"+"=====================
");	
  
	
  	
  	
  	
  	
  	
  	
  	
  while	
  (resultSet.next()){	
  
	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  out.println(resultSet.getString(1)+"	
  ");	
  
	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  out.println(resultSet.getString(2)+"	
  ");	
  
	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  	
  out.println(resultSet.getString(3)+"
");	
  	
  
	
  	
  	
  	
  	
  	
  	
  	
  }	
  
	
  	
  }	
  catch	
  (Exception	
  e)	
  {	
  
	
  	
  	
  	
  	
  	
  out.println(e.toString());	
  
	
  	
  }	
  
	
  
%>	
  
	
  
	
  
	
  
	
  
3. From another Windows XP computer, open a web browser, and type in following URL: 
http://xxx.xxx.xxx.xxx:8080/scada/index.jsp, where xxx.xxx.xxx.xxx is the Windows XP 
computer’s IP address or domain name. If everything is fine, you should be able to see a 
web page showing the PicoScope data. 
 
 
 
4. Add following line into the “index.jsp” just before the  tag, repeat step 3, and 
comment the results. 
	
  
Faculty of ESBE  SCADA Systems 
 
 
Dr. Perry XIAO Copyright © 2007-2013, London South Bank University 4 
	
  
	
  
 
References: 
 
1. http://java.sun.com 
2. http://tomcat.apache.org/ 
3. http://www.linux-sxs.org/internet_serving/ 
4. http://java.sun.com/j2ee/tutorial/1_3-fcs/doc/JSPIntro.html  
5. http://java.sun.com/j2ee/tutorial/1_3-fcs/doc/Servlets.html 
6. http://www.jsptut.com/ 
7. http://eent3.sbu.ac.uk/staff/xiaop 
8. David Harms, “JSP, Servlets, and MySQL”, ISBN: 0764547879, M&T Book, 2001 
(http://www.covecomm.com/java). 
9. Barry Burd, JSP: JavaServer Pages, ISBN:0764535358, M & T Books, 2001 
 
Questions: 
 
1. Define the terms of CGI, Perl, ASP, JSP, Servlet. 
2. What are the differences between server side programs and client side programs? 
3. What is Tomcat, and what is Apache web server?