2012年7月11日
1 SQL腳本
CREATE TABLE `tb_goods1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`price` float DEFAULT NULL,
`unit` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`manufacturer` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
)
2 創建網站
3 新建Servlet 名稱是GoodsServlet 包名是com.jht.servlet
4 引用Tomcat, 附加jar包文件 <Build Path菜單>
mysql-connector-java-3.0.16-ga-bin :數據庫操作類
jstl-api-1.2 JSP標準標簽庫
jstl-impl-1.2 JSP標準標簽庫
5 創建實體類 GoodsForm 包名是 com.jht.model
代碼如下：
public class GoodsForm {
private int id = 0; // 編號屬性
private String name = ""; // 商品名稱屬性
private float price = 0.0f; // 單價屬性
private String unit = ""; // 單位屬性
private String manufacturer = ""; // 廠商屬性
public void setId(int id) {
this.id = id;
}
public int getId() {
return id;
}
public void setName(String name) {
this.name = name;
}
public String getName() {
return name;
}
public void setPrice(float price) {
this.price = price;
}
public float getPrice() {
return price;
}
public void setUnit(String unit) {
this.unit = unit;
}
public String getUnit() {
return unit;
}
public void setManufacturer(String manufacturer) {
this.manufacturer = manufacturer;
}
public String getManufacturer() {
return manufacturer;
}
}
6 編寫數據庫連接與操作類
package com.jht.tools;
import java.io.InputStream;
import java.sql.*;
import java.util.Properties;
public class ConnDB {
public Connection conn=null;
public Statement stmt=null;
public ResultSet rs=null;
private static String propFileName="connDB.properties";
private static Properties prop=new Properties();
private static String dbClassName="com.mysql.jdbc.Driver";
private static String dbUrl="jdbc:mysql://127.0.0.1:3306/db_Database07?user=root&password=111&characterEncoding=UTF-8";
public ConnDB() { //定義構造方法
try { //捕捉異常
//將Properties文件讀取到InputStream對象中
InputStream in = getClass().getResourceAsStream(propFileName);
prop.load(in); // 通過輸入流對象加載Properties文件
dbClassName = prop.getProperty("DB_CLASS_NAME"); // 獲取數據庫驅動
dbUrl = prop.getProperty("DB_URL", dbUrl); //獲取URL
} catch (Exception e) {
e.printStackTrace(); // 輸出異常信息
}
}
public static Connection getConnection() {
Connection conn = null;
try { //連接數據庫時可能發生異常因此需要捕捉該異常
Class.forName(dbClassName).newInstance(); //裝載數據庫驅動
//建立與數據庫URL中定義的數據庫的連接
conn = DriverManager.getConnection(dbUrl);
} catch (Exception ee) {
ee.printStackTrace(); //輸出異常信息
}
if (conn == null) {
System.err
.println("警告: DbConnectionManager.getConnection() 獲得數據庫鏈接失敗.\r\n\r\n鏈接類型:"
+ dbClassName
+ "\r\n鏈接位置:"
+ dbUrl); //在控制臺上輸出提示信息
}
return conn; //返回數據庫連接對象
}
/*
* 功能：執行查詢語句
*/
public ResultSet executeQuery(String sql) {
try { // 捕捉異常
conn = getConnection(); // 調用getConnection()方法構造Connection對象的一個實例conn
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql); //執行SQL語句，并返回一個ResultSet對象rs
} catch (SQLException ex) {
System.err.println(ex.getMessage()); // 輸出異常信息
}
return rs; // 返回結果集對象
}
/*
* 功能:關閉數據庫的連接
*/
public void close() {
try { // 捕捉異常
if (rs != null) { // 當ResultSet對象的實例rs不為空時
rs.close(); // 關閉ResultSet對象
}
if (stmt != null) { // 當Statement對象的實例stmt不為空時
stmt.close(); // 關閉Statement對象
}
if (conn != null) { // 當Connection對象的實例conn不為空時
conn.close(); // 關閉Connection對象
}
} catch (Exception e) {
e.printStackTrace(System.err); // 輸出異常信息
}
}
}
7 配置文件connDB.properties 內容如下：
DB_CLASS_NAME=com.mysql.jdbc.Driver
DB_URL=jdbc:mysql://127.0.0.1:3306/c2cd?user=root&password=root&characterEncoding=UTF-8
8 web.xml 文件配置如下：
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5"
xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<servlet>
<servlet-name>GoodsServlet</servlet-name>
<servlet-class>com.jht.servlet.GoodsServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>GoodsServlet</servlet-name>
<url-pattern>/GoodsServlet</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
</web-app>
9 index.jsp 代碼如下：
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!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>Insert title here</title>
</head>
<body>
<c:redirect url="GoodsServlet">
<c:param name="action" value="query" />
</c:redirect>
</body>
</html>
10 GoodsList.jsp 代碼如下：
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!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>Insert title here</title>
</head>
<body>
<table width="450" height="47" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#333333">
<tr>
<td height="30" colspan="5" bgcolor="#EFEFEF">·商品列表</td>
</tr>
<tr>
<td width="36" height="27" align="center" bgcolor="#FFFFFF">編號</td>
<td width="137" align="center" bgcolor="#FFFFFF">商品名稱</td>
<td width="85" align="center" bgcolor="#FFFFFF">單價</td>
<td width="38" align="center" bgcolor="#FFFFFF">單位</td>
<td width="148" align="center" bgcolor="#FFFFFF">廠商</td>
</tr>
<c:forEach var="goods" items="${requestScope.goodsList}">
<tr>
<td height="27" bgcolor="#FFFFFF">
<c:out value="${goods.id}"/></td>
<td bgcolor="#FFFFFF">
<c:out value="${goods.name}"/></td>
<td bgcolor="#FFFFFF">
<c:out value="${goods.price}"/>（元）</td>
<td bgcolor="#FFFFFF">
<c:out value="${goods.unit}"/></td>
<td bgcolor="#FFFFFF">
<c:out value="${goods.manufacturer}"/></td>
</tr>
</c:forEach>
</table>
</body>
</html>
11 顯示數據庫中的商品信息
posted @
2012-07-11 14:35 jhtchina 閱讀(397) |
評論 (0) |
編輯 收藏
2012年7月4日
1 創建test1 Dynamic Web Project站點
2 創建Servlet 設置java package(com.servlet)和class name(MyServlet)。
設置：
選擇Add Library 
選擇tomcat
3 在WebContent/WEB-INF 下面創建web.xml文件。
Web.xml文件內容如下：
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="
xmlns:xsi="
xsi:schemaLocation="
http://java.sun.com/xml/ns/javaee <servlet>
<servlet-name>MyServlet</servlet-name>
<servlet-class>com.servlet.MyServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>MyServlet</servlet-name>
<url-pattern>/MyServlet</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>MyServlet</welcome-file>
</welcome-file-list>
</web-app>
4 編寫MyServlet.java代碼
import java.io.PrintWriter;
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html");
response.setCharacterEncoding("GBK");
PrintWriter out=response.getWriter();
out.println("<HTML>");
out.println("<HEAD><TITLE>servlet sample</TITLE></HEAD>");
out.println("<BODY>");
out.println("servlet 實例 ");
out.println(this.getClass());
out.println("</BODY>");
out.println("</HTML>");
out.flush();
out.close();
}
5 WebContent下面創建index.jsp
Body里面增加代碼<jsp:forward page="MyServlet"></jsp:forward>
6 運行結果如下：
servlet 實例 class com.servlet.MyServlet
備注：
MyServlet.java代碼修改
response.setContentType("text/html");
response.setCharacterEncoding("GBK");
PrintWriter out = response.getWriter();
out.print("<p>上下文路徑：" + request.getServletPath() + "</p>");
out.print("<p>HTTP請求類型：" + request.getMethod() + "</p>");
out.print("<p>請求參數：" + request.getQueryString() + "</p>");
out.print("<p>請求URI：" + request.getRequestURI() + "</p>");
out.print("<p>請求URL：" + request.getRequestURL().toString() + "</p>");
out.print("<p>請求Servlet路徑：" + request.getServletPath() + "</p>");
out.flush();
out.close();
運行結果：
上下文路徑：/MyServlet
HTTP請求類型：GET
請求參數：null
請求URI：/test1/MyServlet
請求URL：http://localhost:8080/test1/MyServlet
請求Servlet路徑：/MyServlet
注意：Web Deployment Assembly增加Add，對mysql.jar的引用
posted @
2012-07-04 16:32 jhtchina 閱讀(118) |
評論 (0) |
編輯 收藏t10.jsp
<%@ page language="java" contentType="text/html; charset=gbk" errorPage="11.jsp"
pageEncoding="gbk"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<title>Insert title here</title>
</head>
<body>
<%
int apple=Integer.parseInt("ghj");
System.out.println("apple:"+apple);
%>
</body>
</html>
t11.jsp
<%@ page language="java" contentType="text/html; charset=gbk" isErrorPage="true"
pageEncoding="gbk"%>
<%@ page import="java.util.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<title>Insert title here</title>
</head>
<body>
<%=exception.getMessage() %>
</body>
</html>
posted @
2012-07-04 14:58 jhtchina 閱讀(166) |
評論 (0) |
編輯 收藏Application 提供了對應用程序環境屬性訪問的方法。
在WEB-INF目錄下面新建web.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.4"
xmlns=" xmlns:xsi=" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
<context-param> <!-- 定義連接數據庫URL -->
<param-name>url</param-name>
<param-value>jdbc:mysql://localhost:3306/db_database15</param-value>
</context-param>
<context-param> <!-- 定義連接數據庫用戶名 -->
<param-name>name</param-name>
<param-value>root</param-value>
</context-param>
<context-param> <!-- 定義連接數據庫mim -->
<param-name>password</param-name>
<param-value>111</param-value>
</context-param>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
</web-app>
t9.jsp代碼如下：
<%@ page language="java" contentType="text/html; charset=gbk"
pageEncoding="gbk"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<title>Insert title here</title>
<base href="<%=basePath%>">
</head>
<body>
<%
String url = application.getInitParameter("url"); //獲取初始化參數，與web.xml文件中內容對應
String name = application.getInitParameter("name");
String password = application.getInitParameter("password");
out.println("URL: "+url+"<br>");
out.println("name: "+name+"<br>");
out.println("password: "+password+"<br>");
%>
</body>
</html>
posted @
2012-07-04 14:39 jhtchina 閱讀(166) |
評論 (0) |
編輯 收藏t7.jsp
<%@ page language="java" contentType="text/html; charset=GBK"
pageEncoding="GBK"%>
<%@ page import="javax.servlet.http.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>Insert title here</title>
</head>
<body>
<%
String welcome="第一次訪問";
String[] info=new String[]{"","",""};
Cookie[] cook=request.getCookies();
if (cook!=null)
{
for(int i=0;i<cook.length;i++)
{
if (cook[i].getName().equals("myCookInfo"))
{
info=cook[i].getValue().split("#");
welcome="，歡迎回來！";
}
}
}
%>
<%=info[0]+welcome %>
<form action="t8.jsp" method="post">
<ul>
<li>
姓名：<input name="name" type="text" value="<%=info[0] %>" >
</li>
<li>
出生日期:<input name="birthday" type="text" value="<%=info[1] %>">
</li>
<li>
郵箱地址:
<input name="mail" type="text" value="<%=info[2] %>" >
</li>
<li>
<input type="submit" value="提交">
</li>
</ul>
</form>
</body>
</html>
t8.jsp
<%@ page language="java" contentType="text/html; charset=GBK"
pageEncoding="GBK"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>Insert title here</title>
</head>
<body>
<%
String name =new String(request.getParameter("name").getBytes("ISO8859_1"),"GBK");
String birthday = request.getParameter("birthday");
String mail = request.getParameter("mail");
Cookie myCook = new Cookie("myCookInfo",name+"#"+birthday+"#"+mail);
myCook.setMaxAge(60*60*24*365);
response.addCookie(myCook);
%>
表單提交成功
<ul style="line-height: 24px">
<li>姓名：<%= name %>
<li>出生日期：<%= birthday %>
<li>電子郵箱：<%= mail %>
<li><a href="t7.jsp">返回</a>
</ul>
</body>
</html>
posted @
2012-07-04 14:23 jhtchina 閱讀(147) |
評論 (0) |
編輯 收藏