星期一, 11月 12, 2012
[Android]如何建立APK檔
[Android]如何建立APK檔
jackiefu 在天空部落發表於16:05:51 | Android
當使用Eclipse完成專案後，除了可以直接部署至手機測試，但如何將此專案輸出至其他人的行動裝置中?接下來要介紹的是如何建立APK檔，與透過E-mail發布。
建立應用程式簽章所需的金鑰
透過網路部署Android應用程式，必須要有一組私密金鑰用來做為應用程式的簽章，底下將介紹如何建立金鑰...
星期日, 11月 11, 2012
如何建立 Windows To Go 工作區 - 學習中的隨手筆記- 點部落
Windows To Go 是 Windows 8 的一項新功能，它可以讓您將 Windows 8 安裝到 USB 儲存裝置中，包括一般常用的隨身碟或是隨身硬碟。安裝到 USB 儲存裝置後，您就可以在任何電腦上使用這個 USB 儲存裝置來開機使用，開機後的 Windows 8 我們稱之為 Windows To Go 工作區，在這個 Windows To Go 工作區中的功能，在基本操作上跟完整版的 Windows 8 相差無幾，但仍有數項功能上的差異。
星期六, 11月 03, 2012
运行AVD遇到“Emulator] could not get wglGetExtensionsStringARB”问题的原因 - Dr.Watson - 博客园
运行AVD遇到“Emulator] could not get wglGetExtensionsStringARB”问题的原因 - Dr.Watson - 博客园: "运行AVD遇到“Emulator] could not get wglGetExtensionsStringARB”问题的原因
2012-09-27 11:58 by Dr.Watson, 338 阅读, 0 评论, 收藏, 编辑
错误信息：
[ - Emulator] emulator: WARNING: Could not initialize OpenglES emulation, using software renderer.
[ - Emulator] could not get wglGetExtensionsStringARB"
'via Blog this' 官方作法： http://developer.android.com/tools/devices/emulator.html#accel-vm
2012-09-27 11:58 by Dr.Watson, 338 阅读, 0 评论, 收藏, 编辑
错误信息：
[ - Emulator] emulator: WARNING: Could not initialize OpenglES emulation, using software renderer.
[ - Emulator] could not get wglGetExtensionsStringARB"
'via Blog this' 官方作法： http://developer.android.com/tools/devices/emulator.html#accel-vm
如何解决：Android中 Error generating final archive: Debug Certificate expired on 10/09/18 16:30 的错误 - 子扬 - 博客园
如何解决：Android中 Error generating final archive: Debug Certificate expired on 10/09/18 16:30 的错误
问题概述：
在导入一个app后提示如下错误：
“Error generating final archive: Debug Certificate expired on 10/09/18 16:30”
星期二, 7月 24, 2012
星期一, 7月 23, 2012
星期六, 7月 21, 2012
星期二, 7月 17, 2012
星期日, 7月 08, 2012
星期四, 5月 24, 2012
星期六, 4月 28, 2012
星期日, 4月 22, 2012
星期日, 3月 25, 2012
星期日, 3月 04, 2012
星期五, 2月 03, 2012
星期日, 1月 29, 2012
星期六, 1月 28, 2012
星期六, 1月 14, 2012
星期三, 1月 11, 2012
星期日, 1月 08, 2012
星期一, 5月 02, 2011
星期六, 4月 02, 2011
How Do I Install the Android Market on Android SDK | Internet | Tech-Recipes
How Do I Install the Android Market on Android SDK | Internet | Tech-Recipes
1. Download and install Android SDK. After that, set up a new emulator. (You may want to learn how to set up an Android Emulator
2. Go to …….\android-sdk_r08-windows\android-sdk-windows\platforms\android-9\images (this is the default folder for SDK Platform Android 2.3, API 9, revision 1), copy system.img and paste it to C:\Users\Username\.android\avd\Emulator’s name.avd
1. Download and install Android SDK. After that, set up a new emulator. (You may want to learn how to set up an Android Emulator
2. Go to …….\android-sdk_r08-windows\android-sdk-windows\platforms\android-9\images (this is the default folder for SDK Platform Android 2.3, API 9, revision 1), copy system.img and paste it to C:\Users\Username\.android\avd\Emulator’s name.avd
星期日, 3月 27, 2011
星期二, 3月 22, 2011
星期二, 3月 15, 2011
Murphy Kuo's 曠男消滅無限公司 - Windows Live
Murphy Kuo's 曠男消滅無限公司 - Windows Live
Good Sites for English Learning Online
Good Sites for English Learning Online
Share some good sites for English Learning
星期一, 2月 28, 2011
星期五, 2月 25, 2011
Android HTC Hero新手必殺技-10.RMaps ( 離線地圖 ) @ 世界就是懂的騙不懂的，所以人生就是要多嚐試 :: 隨意窩 Xuite日誌
http://blog.xuite.net/aaronliu0308/clutter/29658599
Android內建的Google Map很好用吧，不過卻要隨時連上網才能看到地圖；而或許你有PaPaGo，這樣就不用上網也能用地圖導行，但是若出國出差旅遊呢?不能上網，且PaPaGo也沒有國外地圖，怎麼辨…..??
沒關係！現在就來介紹一套好用的離線地圖程式，以後不管到那裡，出國前把要去地方的地圖抓下來，然後放到你的SD卡中，再用RMap這套程式，就能在國外也不會路哦！最重要的是一切免費，而出國經驗=無價。
首先，先至下面網址將”地圖抓取製作程式.exe”這個程式執行，它會自動解壓
http://webhd.xuite.net/_oops/aaronliu0308/9s2
解壓後進到目錄中看到JRE16的資料夾，再進去安裝jre-6u17-windows-i586-s.exe
星期四, 2月 24, 2011
3rd IEEE Cloud ComputingTechnology and Science Conference
The “Cloud” is a natural evolution of distributed computing and of the widespread adaption of virtualization and SOA. In Cloud Computing, IT-related capabilities and resources are provided as services, via the Internet and on-demand, accessible without requiring detailed knowledge of the underlying technology. The IEEE International Conference and Workshops on Cloud Computing Technology and Science, steered by the Cloud Computing Association, aim to bring together researchers who work on cloud computing and related technologies.
星期二, 1月 04, 2011
The Reservoir model and architecture for open federated cloud computing
The emerging cloud-computing paradigm is rapidly gaining momentum as an alternative to traditional IT (information technology). However, contemporary cloud-computing offerings are primarily targeted for Web 2.0-style applications. Only recently have they begun to address the requirements of enterprise solutions, such as support for infrastructure service-level agreements.
星期三, 11月 03, 2010
IEEE Xplore - WSRec: A Collaborative Filtering Based Web Service Recommender System
IEEE Xplore - WSRec: A Collaborative Filtering Based Web Service Recommender System
As the abundance of Web services on the World Wide Web increase, designing effective approaches for Web service selection and recommendation has become more and more important. In this paper, we present WSRec, a Web service recommender system, to attack this crucial problem.
As the abundance of Web services on the World Wide Web increase, designing effective approaches for Web service selection and recommendation has become more and more important. In this paper, we present WSRec, a Web service recommender system, to attack this crucial problem.
Collaborative filtering with temporal dynamics
Collaborative filtering with temporal dynamics
Customer preferences for products are drifting over time. Product perception and popularity are constantly changing as new selection emerges.
Customer preferences for products are drifting over time. Product perception and popularity are constantly changing as new selection emerges.
星期六, 1月 16, 2010
ACM CCS 2010
ACM CCS 2010
The annual ACM Computer and Communications Security Conference is a leading international forum for information security researchers, practitioners, developers, and users to explore cutting-edge ideas and results, and to exchange techniques, tools, and experiences. We invite submissions from academia, government, and industry presenting novel research on all theoretical and practical aspects of computer security, as well as case studies and implementation experiences.
The annual ACM Computer and Communications Security Conference is a leading international forum for information security researchers, practitioners, developers, and users to explore cutting-edge ideas and results, and to exchange techniques, tools, and experiences. We invite submissions from academia, government, and industry presenting novel research on all theoretical and practical aspects of computer security, as well as case studies and implementation experiences.
Important Dates
- Paper Submission Due: Saturday, April 17, 2010 (11:59 PM CDT)
- Acceptance Notification: Monday, June 21, 2010
- Camera Ready Papers Due: Friday, July 16, 2010
12th ACM International Conference on Ubiquitous Computing | UBICOMP2010
12th ACM International Conference on Ubiquitous Computing UBICOMP2010
Welcome to the website for the 12th ACM International Conference on Ubiquitous Computing. Ubicomp 2010 will be held in Wonderful Copenhagen, Denmark, from September 26-29. Ubicomp is a premier venue for presenting research in the design, development, deployment, evaluation and understanding of ubiquitous computing systems. Ubicomp is an interdisciplinary field of research and development that utilizes and integrates pervasive, wireless, embedded, wearable and/or mobile technologies to bridge the gaps between the digital and physical worlds. Ubicomp 2010 will bring together top researchers and practitioners who are interested in both the technical and applied aspects of Ubiquitous Computing technologies, systems and applications. The Ubicomp 2010 program features keynotes, technical paper and notes sessions, specialized workshops, live demonstrations, posters, video presentations, and a Doctoral Colloquium.
Welcome to the website for the 12th ACM International Conference on Ubiquitous Computing. Ubicomp 2010 will be held in Wonderful Copenhagen, Denmark, from September 26-29. Ubicomp is a premier venue for presenting research in the design, development, deployment, evaluation and understanding of ubiquitous computing systems. Ubicomp is an interdisciplinary field of research and development that utilizes and integrates pervasive, wireless, embedded, wearable and/or mobile technologies to bridge the gaps between the digital and physical worlds. Ubicomp 2010 will bring together top researchers and practitioners who are interested in both the technical and applied aspects of Ubiquitous Computing technologies, systems and applications. The Ubicomp 2010 program features keynotes, technical paper and notes sessions, specialized workshops, live demonstrations, posters, video presentations, and a Doctoral Colloquium.
Important Dates:
- March 12, 2010 - Submission deadline
- May 25, 2010 - Accept/reject notifications
- Sep. 26, 2010 - Conference
WINSYS 2010
The purpose of WINSYS 2010, the International Conference on Wireless Information Networks and Systems, is to bring together researchers, engineers and practitioners interested on information systems and applications in the context of wireless networks and mobile technologies.
Information systems and information technology are pervasive in the whole communications field, which is quite vast, encompassing a large number of research topics and applications: from practical issues to the more abstract theoretical aspects of communication; from low level protocols to high-level networking and applications; from wireless networking technologies to mobile information systems; many other topics are included in the scope of WINSYS.
Important Dates
. Regular Paper Submission: February 03, 2010
. Authors Notification (regular papers): April 08, 2010
. Final Regular Paper Submission and Registration: April 22, 2010
Information systems and information technology are pervasive in the whole communications field, which is quite vast, encompassing a large number of research topics and applications: from practical issues to the more abstract theoretical aspects of communication; from low level protocols to high-level networking and applications; from wireless networking technologies to mobile information systems; many other topics are included in the scope of WINSYS.
Important Dates
. Regular Paper Submission: February 03, 2010
. Authors Notification (regular papers): April 08, 2010
. Final Regular Paper Submission and Registration: April 22, 2010
The Eighth International Network Conference (INC2010)
We invite you to participate in the International Network Conference 2010, to be held in Heidelberg, Germany, from 6 - 8 July 2010. This conference, the eighth in our series, will bring together leading figures from academia and industry to present and discuss the latest advances in networking technologies from research and commercial perspectives. The conference is jointly organised by the University of Plymouth (UK) and the Hochschule Darmstadt (Germany).
Call for papers deadling 2010/1/31.
Important Dates
31 January 2010 Deadline for submission of papers
5 March 2010 Notification of paper acceptance
9 April 2010 Deadline for camera-ready paper submission
23 April 2010 Deadline for author registration
Call for papers deadling 2010/1/31.
Important Dates
31 January 2010 Deadline for submission of papers
5 March 2010 Notification of paper acceptance
9 April 2010 Deadline for camera-ready paper submission
23 April 2010 Deadline for author registration
星期四, 9月 11, 2008
星期六, 3月 22, 2008
星期四, 3月 06, 2008
星期五, 12月 28, 2007
Online Abstract Submission - Online Review System - Conference Homepages
Online Abstract Submission - Online Review System - Conference Homepages: "You organize the meeting - we take care of the conference website and provide you with a conference management system, with online abstract submission, online peer review process and paper selection."
星期四, 12月 27, 2007
My Conference Calendar
My Conference Calendar
Bin Zhou, School of Computing Science, Simon Fraser University
Bin Zhou, School of Computing Science, Simon Fraser University
Welcome to Baihua Zheng's Homepage!
Welcome to Baihua Zheng's Homepage!
Assistant Professor
School of Information Systems
Singapore Management University
Assistant Professor
School of Information Systems
Singapore Management University
星期三, 12月 12, 2007
星期三, 10月 10, 2007
星期三, 7月 25, 2007
NCTUns Network Simulator and Emulator
NCTUns Network Simulator and Emulator: The NCTUns network simulator and emulator was first released on 11/18/2002. As of July 23, 2007, according to the download user database, more than 8,722 people from 114 countries have registered at the NCTUns web site and downloaded it.
星期三, 7月 18, 2007
Jiannong Cao at Hong Kong PolyU
Jiannong Cao at Hong Kong PolyU
Dr. Jiannong Cao is a professor in the Department of Computing at Hong Kong Polytechnic University. He received the B.Sc. degree in computer science from Nanjing University, China, in 1982, and the M.Sc. and Ph.D. degrees from Washington State University, USA, in 1986 and 1990, all in computer science. From 1982 to 1983, he studied as a MSc. student in the Graduate School of the Chinese Acadmy of Science in Beijing. Before joined the Hong Kong Polytechnic University in 1997, he has been on faculty of computer science in James Cook University and The University of Adelaide in Australia, and the City University of Hong Kong. Dr. Cao is an adjunct professor of BJTU, NUDT and NWPU, and a guest professor of CSU in China. He also held several visiting positions, including a visiting research professor in the National Key Lab for Novel Software Technology, Nanjing University of China, a visiting fellow in the School of Computer Engineering, Nanyang Technological University of Singapore, a visiting scholar at the Institute of Software, Chinese Academy of Science, and Peking University Overseas Scholar Lecture Program.
Dr. Jiannong Cao is a professor in the Department of Computing at Hong Kong Polytechnic University. He received the B.Sc. degree in computer science from Nanjing University, China, in 1982, and the M.Sc. and Ph.D. degrees from Washington State University, USA, in 1986 and 1990, all in computer science. From 1982 to 1983, he studied as a MSc. student in the Graduate School of the Chinese Acadmy of Science in Beijing. Before joined the Hong Kong Polytechnic University in 1997, he has been on faculty of computer science in James Cook University and The University of Adelaide in Australia, and the City University of Hong Kong. Dr. Cao is an adjunct professor of BJTU, NUDT and NWPU, and a guest professor of CSU in China. He also held several visiting positions, including a visiting research professor in the National Key Lab for Novel Software Technology, Nanjing University of China, a visiting fellow in the School of Computer Engineering, Nanyang Technological University of Singapore, a visiting scholar at the Institute of Software, Chinese Academy of Science, and Peking University Overseas Scholar Lecture Program.
星期五, 7月 13, 2007
Center for Experimental Research in Computer Systems - CERCS
Center for Experimental Research in Computer Systems - CERCS： In Fall 2001, the Georgia Tech Center for Experimental Research in Computer Systems (CERCS) opened its doors. CERCS brings together researchers from Georgia Tech's College of Computing and School of Electrical and Computer Engineering who share a common focus on the design and evaluation of computer and software systems through experimental methods. CERCS research focuses on complex systems, including their hardware, communications and system-level software, and applications. By emphasizing the experimental method, we promote the creation of knowledge through the design, implementation, and measurement of potentially large-scale prototype systems.
星期日, 5月 13, 2007
UMBC ebiquity research group
The UMBC eBiquity Research Group consists of faculty and students from the Department of Computer Science and Electrical Engineering (CSEE) of University of Maryland, Baltimore County (UMBC), located in Baltimore MD.
星期六, 3月 31, 2007
星期一, 3月 26, 2007
Java Swing Calculator Source Code
Java Swing Calculator Source Code: "This is a free Java calculator tutorial developed using Java Swing. Below you will find the java code for calculator along with the screenshot. It is a basic four-function calculator java program source code."
星期日, 3月 25, 2007
cs511: Projection Information Page
cs511: Projection Information Page: "SensorNetwork workBench (snBench)
Overview and Terminology Primer "
Overview and Terminology Primer "
星期二, 2月 20, 2007
TinyOS Community Forum || An open-source OS for the networked sensor regime.
TinyOS Community Forum An open-source OS for the networked sensor regime.: "TinyOS is an open-source operating system designed for wireless embedded sensor networks. It features a component-based architecture which enables rapid innovation and implementation while minimizing code size as required by the severe memory constraints inherent in sensor networks."
星期日, 1月 21, 2007
星期六, 12月 30, 2006
Dr. Jie Wu
Dr. Jie Wu
Distinguished Professor
Department of Computer Science and Engineering
Florida Atlantic University
Boca Raton, FL 33431Wireless Networks and Mobile Computing
Distinguished Professor
Department of Computer Science and Engineering
Florida Atlantic University
Boca Raton, FL 33431Wireless Networks and Mobile Computing
星期日, 11月 12, 2006
Drupal Taiwan | 繁體中文支援站
Drupal Taiwan | 繁體中文支援站
Drupal Taiwan是 Drupal 的繁體中文支援站。Drupal是一套開放源碼的內容管理平台，擁有多種實用的功能，可以用來建置從個人網誌到大型網路社群等各種類型的網站。
星期六, 10月 28, 2006
星期六, 10月 21, 2006
星期二, 9月 26, 2006
星期三, 2月 01, 2006
星期日, 1月 01, 2006
SSL/TLS Strong Encryption: FAQ
SSL/TLS Strong Encryption: FAQ
How can I get rid of the pass-phrase dialog at Apache startup time?
The reason this dialog pops up at startup and every re-start is that the RSA private key inside your server.key file is stored in encrypted format for security reasons. The pass-phrase is needed decrypt this file, so it can be read and parsed. Removing the pass-phrase removes a layer of security from your server - proceed with caution!
Remove the encryption from the RSA private key (while keeping a backup copy of the original file):
$ cp server.key server.key.org
$ openssl rsa -in server.key.org -out server.key
Make sure the server.key file is only readable by root:
$ chmod 400 server.key
Now server.key contains an unencrypted copy of the key. If you point your server at this file, it will not prompt you for a pass-phrase. HOWEVER, if anyone gets this key they will be able to impersonate you on the net. PLEASE make sure that the permissions on this file are such that only root or the web server user can read it (preferably get your web server to start as root but run as another user, and have the key readable only by root).
As an alternative approach you can use the ``SSLPassPhraseDialog exec:/path/to/program'' facility. Bear in mind that this is neither more nor less secure, of course.
How can I get rid of the pass-phrase dialog at Apache startup time?
The reason this dialog pops up at startup and every re-start is that the RSA private key inside your server.key file is stored in encrypted format for security reasons. The pass-phrase is needed decrypt this file, so it can be read and parsed. Removing the pass-phrase removes a layer of security from your server - proceed with caution!
Remove the encryption from the RSA private key (while keeping a backup copy of the original file):
$ cp server.key server.key.org
$ openssl rsa -in server.key.org -out server.key
Make sure the server.key file is only readable by root:
$ chmod 400 server.key
Now server.key contains an unencrypted copy of the key. If you point your server at this file, it will not prompt you for a pass-phrase. HOWEVER, if anyone gets this key they will be able to impersonate you on the net. PLEASE make sure that the permissions on this file are such that only root or the web server user can read it (preferably get your web server to start as root but run as another user, and have the key readable only by root).
As an alternative approach you can use the ``SSLPassPhraseDialog exec:/path/to/program'' facility. Bear in mind that this is neither more nor less secure, of course.
星期六, 12月 10, 2005
星期四, 11月 24, 2005
星期六, 11月 19, 2005
SANS
SANS is the most trusted and by far the largest source for information security training and certification in the world. It also develops, maintains, and makes available at no cost, the largest collection of research documents about various aspects of information security, and it operates the Internet's early warning system - Internet Storm Center. The SANS (SysAdmin, Audit, Network, Security) Institute was established in 1989 as a cooperative research and education organization. Its programs now reach more than 165,000 security professionals, auditors, system administrators, network administrators, chief information security officers, and CIOs who share the lessons they are learning and jointly find solutions to the challenges they face. At the heart of SANS are the many security practitioners in government agencies, corporations, and universities around the world who invest hundreds of hours each year in research and teaching to help the entire information security community.
OpenSSL for Win32 using Apache
OpenSSL for Win32 using ApacheApache 2.0.52 & OpenSSL 0.9.7e (installed on Dec 26, 2004)
Old Appache HTTP Archive at http://archive.apache.org/dist/httpd/
This page will describe the required software and tools to get Secure Sockets Layer, SSL, up and running under Windows 2000 using the Apache server. Before we proceed to the following page make sure you have downloaded the required software. The only assumption made is that the Apache 2.0.52 is already installed and running with out SSL support.
Some of this document is a repeat of easily obtain documents found on the web with additional information found through experience. Regardless, this document exist mainly for myself (and you) because there is no guarantee the existing website documents will be around in the near future. In addition, setting up a server, for me, is a one time process. I set it up, forget it and move on to development and that is exactly what will happen - I will forget it. This page will be a valuable tool for reinstalling the server...with SSL support.
Old Appache HTTP Archive at http://archive.apache.org/dist/httpd/
This page will describe the required software and tools to get Secure Sockets Layer, SSL, up and running under Windows 2000 using the Apache server. Before we proceed to the following page make sure you have downloaded the required software. The only assumption made is that the Apache 2.0.52 is already installed and running with out SSL support.
Some of this document is a repeat of easily obtain documents found on the web with additional information found through experience. Regardless, this document exist mainly for myself (and you) because there is no guarantee the existing website documents will be around in the near future. In addition, setting up a server, for me, is a one time process. I set it up, forget it and move on to development and that is exactly what will happen - I will forget it. This page will be a valuable tool for reinstalling the server...with SSL support.
OpenVPN
OpenVPN is a full-featured SSL VPN solution which can accomodate a wide range of configurations, including remote access, site-to-site VPNs, WiFi security, and enterprise-scale remote access solutions with load balancing, failover, and fine-grained access-controls (articles) (examples) (security overview) (non-english languages).
星期三, 10月 19, 2005
星期日, 10月 09, 2005
ITPapers
ITPapers is the Web's largest library of technical IT white papers, webcasts, and case studies. Covering IT categories including Data Management, IT Management, Networking, Communications, Enterprise Applications, Storage, Security and much more, ITPapers.com is the best source for technical white papers and IT information.
星期一, 9月 12, 2005
星期三, 8月 31, 2005
星期六, 8月 06, 2005
星期三, 7月 13, 2005
星期日, 5月 29, 2005
星期四, 5月 26, 2005
星期五, 4月 01, 2005
星期四, 2月 24, 2005
星期日, 2月 20, 2005
星期六, 2月 19, 2005
星期五, 2月 11, 2005
關聯資料表的附加功能未能啟動，解決方法
關聯資料表的附加功能未能啟動，解決方法如下：
Source PHP 5知識交換中心 伊蘇小勇者
要先建立一個 phpmyadmin 的資料庫
快速解決方案:
執行以下sql語法,把所有需要的table建立到phpmyadmin資料庫裡面
#
# 資料表格式： `PMA_bookmark`
#
CREATE TABLE `PMA_bookmark` (
`id` int(11) NOT NULL auto_increment,
`dbase` varchar(255) NOT NULL default '',
`user` varchar(255) NOT NULL default '',
`label` varchar(255) NOT NULL default '',
`query` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='Bookmarks' AUTO_INCREMENT=1 ;
# --------------------------------------------------------
#
# 資料表格式： `PMA_column_info`
#
CREATE TABLE `PMA_column_info` (
`id` int(5) unsigned NOT NULL auto_increment,
`db_name` varchar(64) NOT NULL default '',
`table_name` varchar(64) NOT NULL default '',
`column_name` varchar(64) NOT NULL default '',
`comment` varchar(255) NOT NULL default '',
`mimetype` varchar(255) NOT NULL default '',
`transformation` varchar(255) NOT NULL default '',
`transformation_options` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`)
) TYPE=MyISAM COMMENT='Comments for Columns' AUTO_INCREMENT=24 ;
# --------------------------------------------------------
#
# 資料表格式： `PMA_history`
#
CREATE TABLE `PMA_history` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`username` varchar(64) NOT NULL default '',
`db` varchar(64) NOT NULL default '',
`table` varchar(64) NOT NULL default '',
`timevalue` timestamp(14) NOT NULL,
`sqlquery` text NOT NULL,
PRIMARY KEY (`id`),
KEY `username` (`username`,`db`,`table`,`timevalue`)
) TYPE=MyISAM COMMENT='SQL history' AUTO_INCREMENT=1 ;
# --------------------------------------------------------
#
# 資料表格式： `PMA_pdf_pages`
#
CREATE TABLE `PMA_pdf_pages` (
`db_name` varchar(64) NOT NULL default '',
`page_nr` int(10) unsigned NOT NULL auto_increment,
`page_descr` varchar(50) NOT NULL default '',
PRIMARY KEY (`page_nr`),
KEY `db_name` (`db_name`)
) TYPE=MyISAM COMMENT='PDF Relationpages for PMA' AUTO_INCREMENT=3 ;
# --------------------------------------------------------
#
# 資料表格式： `PMA_relation`
#
CREATE TABLE `PMA_relation` (
`master_db` varchar(64) NOT NULL default '',
`master_table` varchar(64) NOT NULL default '',
`master_field` varchar(64) NOT NULL default '',
`foreign_db` varchar(64) NOT NULL default '',
`foreign_table` varchar(64) NOT NULL default '',
`foreign_field` varchar(64) NOT NULL default '',
PRIMARY KEY (`master_db`,`master_table`,`master_field`),
KEY `foreign_field` (`foreign_db`,`foreign_table`)
) TYPE=MyISAM COMMENT='Relation table';
# --------------------------------------------------------
#
# 資料表格式： `PMA_table_coords`
#
CREATE TABLE `PMA_table_coords` (
`db_name` varchar(64) NOT NULL default '',
`table_name` varchar(64) NOT NULL default '',
`pdf_page_number` int(11) NOT NULL default '0',
`x` float unsigned NOT NULL default '0',
`y` float unsigned NOT NULL default '0',
PRIMARY KEY (`db_name`,`table_name`,`pdf_page_number`)
) TYPE=MyISAM COMMENT='Table coordinates for phpMyAdmin PDF output';
# --------------------------------------------------------
#
# 資料表格式： `PMA_table_info`
#
CREATE TABLE `PMA_table_info` (
`db_name` varchar(64) NOT NULL default '',
`table_name` varchar(64) NOT NULL default '',
`display_field` varchar(64) NOT NULL default '',
PRIMARY KEY (`db_name`,`table_name`)
) TYPE=MyISAM COMMENT='Table information for phpMyAdmin';
config.inc.php 中以下相關地方修改:
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'PMA_bookmark';
$cfg['Servers'][$i]['relation'] = 'PMA_relation';
$cfg['Servers'][$i]['table_info'] = 'PMA_table_info';
$cfg['Servers'][$i]['table_coords'] = 'PMA_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'PMA_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'PMA_column_info';
$cfg['Servers'][$i]['history'] = 'PMA_history';
Source PHP 5知識交換中心 伊蘇小勇者
要先建立一個 phpmyadmin 的資料庫
快速解決方案:
執行以下sql語法,把所有需要的table建立到phpmyadmin資料庫裡面
#
# 資料表格式： `PMA_bookmark`
#
CREATE TABLE `PMA_bookmark` (
`id` int(11) NOT NULL auto_increment,
`dbase` varchar(255) NOT NULL default '',
`user` varchar(255) NOT NULL default '',
`label` varchar(255) NOT NULL default '',
`query` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='Bookmarks' AUTO_INCREMENT=1 ;
# --------------------------------------------------------
#
# 資料表格式： `PMA_column_info`
#
CREATE TABLE `PMA_column_info` (
`id` int(5) unsigned NOT NULL auto_increment,
`db_name` varchar(64) NOT NULL default '',
`table_name` varchar(64) NOT NULL default '',
`column_name` varchar(64) NOT NULL default '',
`comment` varchar(255) NOT NULL default '',
`mimetype` varchar(255) NOT NULL default '',
`transformation` varchar(255) NOT NULL default '',
`transformation_options` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`)
) TYPE=MyISAM COMMENT='Comments for Columns' AUTO_INCREMENT=24 ;
# --------------------------------------------------------
#
# 資料表格式： `PMA_history`
#
CREATE TABLE `PMA_history` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`username` varchar(64) NOT NULL default '',
`db` varchar(64) NOT NULL default '',
`table` varchar(64) NOT NULL default '',
`timevalue` timestamp(14) NOT NULL,
`sqlquery` text NOT NULL,
PRIMARY KEY (`id`),
KEY `username` (`username`,`db`,`table`,`timevalue`)
) TYPE=MyISAM COMMENT='SQL history' AUTO_INCREMENT=1 ;
# --------------------------------------------------------
#
# 資料表格式： `PMA_pdf_pages`
#
CREATE TABLE `PMA_pdf_pages` (
`db_name` varchar(64) NOT NULL default '',
`page_nr` int(10) unsigned NOT NULL auto_increment,
`page_descr` varchar(50) NOT NULL default '',
PRIMARY KEY (`page_nr`),
KEY `db_name` (`db_name`)
) TYPE=MyISAM COMMENT='PDF Relationpages for PMA' AUTO_INCREMENT=3 ;
# --------------------------------------------------------
#
# 資料表格式： `PMA_relation`
#
CREATE TABLE `PMA_relation` (
`master_db` varchar(64) NOT NULL default '',
`master_table` varchar(64) NOT NULL default '',
`master_field` varchar(64) NOT NULL default '',
`foreign_db` varchar(64) NOT NULL default '',
`foreign_table` varchar(64) NOT NULL default '',
`foreign_field` varchar(64) NOT NULL default '',
PRIMARY KEY (`master_db`,`master_table`,`master_field`),
KEY `foreign_field` (`foreign_db`,`foreign_table`)
) TYPE=MyISAM COMMENT='Relation table';
# --------------------------------------------------------
#
# 資料表格式： `PMA_table_coords`
#
CREATE TABLE `PMA_table_coords` (
`db_name` varchar(64) NOT NULL default '',
`table_name` varchar(64) NOT NULL default '',
`pdf_page_number` int(11) NOT NULL default '0',
`x` float unsigned NOT NULL default '0',
`y` float unsigned NOT NULL default '0',
PRIMARY KEY (`db_name`,`table_name`,`pdf_page_number`)
) TYPE=MyISAM COMMENT='Table coordinates for phpMyAdmin PDF output';
# --------------------------------------------------------
#
# 資料表格式： `PMA_table_info`
#
CREATE TABLE `PMA_table_info` (
`db_name` varchar(64) NOT NULL default '',
`table_name` varchar(64) NOT NULL default '',
`display_field` varchar(64) NOT NULL default '',
PRIMARY KEY (`db_name`,`table_name`)
) TYPE=MyISAM COMMENT='Table information for phpMyAdmin';
config.inc.php 中以下相關地方修改:
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'PMA_bookmark';
$cfg['Servers'][$i]['relation'] = 'PMA_relation';
$cfg['Servers'][$i]['table_info'] = 'PMA_table_info';
$cfg['Servers'][$i]['table_coords'] = 'PMA_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'PMA_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'PMA_column_info';
$cfg['Servers'][$i]['history'] = 'PMA_history';
星期四, 2月 03, 2005
星期三, 2月 02, 2005
星期二, 2月 01, 2005
星期日, 1月 16, 2005
星期一, 12月 20, 2004
JDBC 2.0 (Java Enterprise in a Nutshell)
JDBC 2.0 (Java Enterprise in a Nutshell): "ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATEABLE"
ResultSet.CONCUR_UPDATEABLE"
星期六, 12月 18, 2004
星期六, 12月 11, 2004
訂閱：
文章 (Atom)