毛毛的記事簿: Development

顯示具有 Development 標籤的文章。顯示所有文章

2015年4月29日星期三

[教學] 建立 Python + django + MySQL 開發環境 for windows

由於接了一個用 django 開發的項目，所以簡單整理一下它開發環境設定方法：

軟體需求：

Python for Windows
(視乎版本需求，建議用32 bit 版本，因為小弟試用過64 bit 版本，會有不明的問題，所以放棄了) https://www.python.org/download/releases/2.7.6/
pip (package manager for python)
下載get-pip.py
https://pip.pypa.io/en/latest/installing.html
MySQL-python driver
https://pypi.python.org/pypi/MySQL-python/1.2.5

安裝步驟:

安裝 python for windows

設定安裝目錄
設定好PATH 環境變數指向Python 根目錄
安裝pip

開啟cmd (run as administrator)，前往get-pip.py所在的目錄
執行python get-pip.py
經過一輪下載後完成安裝

安裝MySQL-Python Driver
利用pip 安裝django

執行 python -m pip install django==1.2.6
如預到以下這個問題，請按照這個網址修改Python 目錄下的Lib\mimetype.py
http://bugs.python.org/review/9291/diff/1663/Lib/mimetypes.py
經過一輪下載後安裝完成！

2013年4月24日星期三

[教學] 快速建立Tomcat Development Environment + 簡單 jsp 示範

本筆記是為一些有Java 經驗的朋友所寫，方便他們快速由頭開始建立好Tomcat 的開發環境，所以不懂Java 的朋友這篇文章或許不識合你。
另外本筆記依據小弟開發經驗所記下，由於現在用的開發環境已經用了好一陣子，所以我沒有由頭每一個步驟驗證，中間或有錯漏，有錯請指正！
Software Requirment:
1. Java EE 6 SDK
http://www.oracle.com/technetwork/java/javaee/downloads/index.html
2. Tomcat 6.0
http://tomcat.apache.org/download-60.cgi
3. Eclipse IDE for Java EE Developers
http://www.eclipse.org/downloads/packages/eclipse-ide-java-ee-developers/junosr2
4. MySQL
主要是在本教學內的JSP 示範用，MySQL 的安裝教學我想不難在網絡上找到
5. MySQL JDBC Driver
http://dev.mysql.com/downloads/connector/j/
開發環境設定:
1. Setup Java EE (全部選 default setting 即可)
2. Unzip eclipse，打開eclipse.exe (Eclipse 是小弟常用的IDE，所以在本教學都會用eclipse 演示)

3. 先在Eclipse設定好一個Web Project 備用: Right click “Project Explorer”，打開 New Project 選單，選擇 Dynamic Web Project ，做好一些簡單的設定

4. Eclipse 已經準備好了

5. 開始設定Tomcat: 打開Tomcat，先到conf folder 內，編輯tomcat-users.xml，這裡是tomcat manager 的使用者設定

6. 在lib folder 內放好JDBC Driver

7. 在<tomcat-users> 內插入以下使用者設定 (user=user1, password=welcome)

<role rolename="manager"/>
<role rolename="admin"/>
<user username="user1" password="welcome" roles="admin,manager"/>

8. 在tomcat 的bin folder 內，執行setclasspath.bat，最後執行startup.bat，你就會看到tomcat 在啓動了

9. 打開localhost:8080，看見老虎頭像就大功告成了

10. 現在假設MySQL 已經在本機安裝好，並有以下一個簡單的Database tutorial，裡面有一個Table tbl_tutorial，內容如下

11. 在Eclipse 的web project 裡，打開WebContent folder，然後新增一個jsp file (right click WebContent, New > JSP File)

12. 編輯JSP

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<%@ page import ="java.sql.*" %>
<%@ page import ="javax.sql.*" %>
<%@ page import ="java.util.*" %>
<%@ page import ="java.lang.Number" %>
<!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=ISO-8859-1">
<title>Insert title here</title>
</head>
<body> 
<% 

Class.forName("com.mysql.jdbc.Driver");
java.sql.Connection con = DriverManager.getConnection("jdbc:mysql://<DB host>:<DB port>/tutorial","<DB user>","<DB password>");
Statement st= con.createStatement(); 

String sql = "SELECT name FROM tbl_tutorial;";
ResultSet rs=st.executeQuery(sql); 

while (rs.next()){
    out.println("Hello world! " + rs.getString(1) + "<br/>");
} 

%> 

</body>
</html>

13. 將完成好的web app 打包成war 檔案：right click web project, Export > WAR file

14. 登入Tomcat Manager (用step 7 的設定)

15. Deploy 剛剛 export 出來的WAR file
$]{7301[DVOM0Z}D8_8(UDFV$

16. 打開http://localhost:8080/Tutorial/testing.jsp 你就會看到結果了！

17. 最後簡單介紹一下剛deploy 的web app 的folder structure

Depoly 後在webapps 底下就會自動生成一個project 名的folder

對應Eclipse 內WebContent folder 內的所有檔案都會被搬到這裡

WEB-INF folder 內主要放complie 好的java class，如果將來要寫servlet ，class file 就會被搬到 classes folder 內
而lib 則是用來放這個web app 專用的library

2011年8月9日星期二

[教學] 在 eclipse 裡設定 JQuantLib 的開發環境 (Setup JQuantLib in eclipse)

工作需要，這幾天都在研究一套JAVA 的Quantative finance library – JQuantLib。
因為暫時只是在POC階段，所以先寫安裝方法，不寫這套library 的內容。

我的開發環境：

J2SE 1.5.0_22
Eclipse Helio (service release 2)

在eclipse 的設定方法 (假設大家都懂得如可在eclipse 加入新插件)：

安裝 Maven Integration for Eclipse
Maven 與 Eclipse 的 integration
Eclipse update url: http://download.eclipse.org/technology/m2e/releases
安裝 Subversive
打開 Help > Install New Software... > select Helios - http://download.eclipse.org/releases/helios > Collaboration Tools，安裝以下一堆plug-in

安裝完成後會有對話框詢問你要裝甚麼connector，我沒有理會，通通都把它裝起來。
安裝 FingBugs
Description: Tools that analyse your code and point out the place that you may got a bug or have a bad practise.
Eclipse update url: http://findbugs.cs.umd.edu/eclipse/
安裝 PMD
Description: Help to find bad constructions in the code, either those commonly known or those defined by JQuantLib.
Eclipse update url: http://pmd.sf.net/eclipse
安裝 EclEmma
Description: Tools for easy verify of the code coverage of your JUnit test cases.
Eclipse update url: http://update.eclemma.org/
設定 JQuantLib SVN Repository

Right click 有關的project，然後 New > Other，然後選SVN > Repository Location.
在URL輸入http://jquant.svn.sourceforge.net/svnroot/jquant/trunk/jquantlib，然後按Finish。
要加入的Repositories 有以下五個：
http://jquant.svn.sourceforge.net/svnroot/jquant/trunk/jquantlib
http://jquant.svn.sourceforge.net/svnroot/jquant/trunk/jquantlib-all
http://jquant.svn.sourceforge.net/svnroot/jquant/trunk/jquantlib-parent
http://jquant.svn.sourceforge.net/svnroot/jquant/trunk/jquantlib-helpers
http://jquant.svn.sourceforge.net/svnroot/jquant/trunk/jquantlib-samples

Check out JQuantLib source

打開Window > Show View > Others，點選 SVN Repositories。
在SVN Repositories 的 view 入面，right click 剛新加入的repositories，然後選Find/Check Out As…。
然後選 Check out as a project with the name specified:，然後按Finish。
Check out in progress ……
重覆以上步驟直到所有repositories 都check out 完成。
完成！

Reference:
http://www.jquantlib.org/index.php/JQuantLib_Users_Guide#Install_plugins
http://www.jquantlib.org/index.php/Checkout_in_Eclipse_with_SVN

2011年7月14日星期四

Internet Component Download - INF File Architecture

Introduction

An information file (.inf) provide the installation instruction for IE to setup and register your software distribution. It consists of any number of name section. And each section can have multiple items.

Each section will have its own predefined purpose, such as updating the registry, executing a command, copying some file, etc.

Main Sections of an INF File in Internet Component Download:

[Add.Code]
This section lists all the files to be installed, including optional files
```
[Add.Code]
filename1=section-name1
filename2=section-name2
```

[Setup Hook]
This section lists all hook that will be executed before setting up files in [Add.Code] section.

[Setup Hooks]
hookname1=section-name4
hookname2=section-name5
[hookname1]
run=extrac32.exe /e /a /y /l c:\MyApplication\client MyApp.cab

[Version]
For compatibility, the following lines must be added if we use hooks
```
[Version]
Signature="$CHICAGO$"
AdvancedINF=2.0
```
[DefaultInstall]
Installation section that is executed by default. Contains pointers to other sections specifying files to copy and delete, registry updates, .ini file updates, and so on. (for full list of pointer and the systax of this section please refer to here)
In this post we will just talk about AddReg. AddReg pointer point to a section for adding subkeys or value names to the registory, optionally setting the value.
```
[DefaultInstall]
AddReg=AddRegSection
[AddRegSection]
HKLM,Software\MyApp,ProgramName,,"My Application"
HKLM,Software\MyApp,"Program Location",,"%25%\MyApp.exe"
```
[Strings]
Defines one or more strings keys. The Installer expands the strings key to the given string and uses it for further processing. You must enclose a strings key in percent signs (%).
```
[String]
String0=”MyApplication”
String1=”Read me”
```

Reference:
Setup Information File (.inf) Definition
About INF File Architecture

2011年6月20日星期一

初探 Internet Component Download

這幾天都在研究 "Internet Component Download” 的資料，以下是一些網上資料的整理：

MSDN offical defination

Internet Component Download is a system service for downloading and installing software from Web sites on the Internet and intranets. This service also provides certificate checking. Internet Component Download is supported by Microsoft Internet Explorer 3.0 and later.
You, the software provider or Web master, can "package" components and place them on your Web servers for download. When users visit your Web site, Internet Component Download enables their browsers to pull down and install the programs.

Key Concept

Carbinet File (.cab) – a package that include all files for the software distribution (e.g.active X controls (.ocx), dll, exe, etc.). (詳細要怎樣打包我不懂，本身我是JAVA人，m記的東西本來就不太懂，因為工作關係我才接觸這topic)
Packaging – Code authors need to package the software for user to download. The packaging machanism is usually a cabinet file addressed by the “codebase” attribute of an “object” element on a web page. Here is a piece of sample html code:
<object classid="clsid:xxxx-xxxx-xxxx"
codebase="/cab/testing.cab">
</object>
Signing – To protect the user from downloading software from the internet, users with user security level set to default level normally cannot download and execute the software (e.g. User Access Control, UAC, in windows 7).

Digitial signature help to associate the software distribution to the code author, providing accountability for software developers.

According to MSDN:
When a user's security level is set at the default level, any object identified by the OBJECT tag on a Web page must be digitally signed. Internet Explorer's default security setting won't install a component that doesn't have a digital signature.

This is a screen capture for the pop-up when you try to download and install an unsigned cabinet file
Information file (.inf) – This file contain the setup information for Internet Explorer the use to install and register your software distribution. For the usage of INF file, we will discuss in another post.

訂閱：文章 (Atom)

2015年4月29日 星期三