2 exp username/psw@TEST file=d:test.dmp owner=(ly)
3 exp username/psw@TEST file= d:test.dmp tables=(grid1,grid2)
3ž®†è¡¨grid1åQŒä¸Žgrid2导出
dåQštest.dmp是导出的文äšg地å€
imp命ä×oåQ?br />
2 imp system/psw@TEST full=y file=d:test.dmp ignore=y
3 imp system/psw@TEST file=d:test.dmp tables=(grid1)
3表示åªå¯¼å…¥grid1˜q™ä¸ªè¡?br />
在导入导出å‰è¦å…ˆ‹¹‹è¯•ä¸‹å¯¹åº”çš„æ•°æ®åº“是å¦æ˜¯é€šçš„åQštnsping testæ¥æµ‹è¯•ï¼ŒåŒæ ·test是æœåŠ¡å
所有命令å¯åœ¨cmd下执è¡?
public ActionForward add(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) throws Exception {
String encoding = request.getCharacterEncoding();
if ((encoding != null) && (encoding.equalsIgnoreCase("utf-8")))
{
response.setContentType("text/html; charset=gb2312");//如果没有指定¾~–ç åQŒç¼–ç æ ¼å¼äØ“gb2312
}
NodeForm theForm = (NodeForm) form;
String nodename=theForm.getNodename();
String note=theForm.getNote();
FormFile file = theForm.getTheFile1();//å–å¾—ä¸Šä¼ çš„æ–‡ä»?br> FormFile file2=theForm.getTheFile2();
FormFile file3=theForm.getTheFile3();
Session session=null;
String forward="";
try
{
/*
* å–当å‰ç³»¾lŸèµ\å¾?
*/
String filePath = this.getServlet().getServletContext()
.getRealPath("/");
System.out.println("---------------------------------------"+filePath);
if(file.getFileSize()!=0){
ByteArrayInputStream stream = (ByteArrayInputStream) file.getInputStream();//把文件读�br>
//ByteArrayOutputStream baos = new ByteArrayOutputStream();
/*
* å»ºç«‹ä¸€ä¸ªä¸Šä¼ æ–‡ä»¶çš„è¾“å‡º‹¹?
*/
OutputStream bos = new FileOutputStream(filePath +
"UploadFiles\\"+file.getFileName());
request.setAttribute("fileName",filePath + "/"
+ file.getFileName());
int bytesRead = 0;
byte[] buffer = new byte[8192];
while ((bytesRead = stream.read(buffer, 0, 8192)) != -1)
{
bos.write(buffer, 0, bytesRead);//ž®†æ–‡ä»¶å†™å…¥æœåŠ¡å™¨
}
bos.close();
stream.close();
}if(file2.getFileSize()!=0){
ByteArrayInputStream stream2 = (ByteArrayInputStream) file2.getInputStream();
OutputStream bos2 = new FileOutputStream(filePath +
"UploadFiles\\"+file2.getFileName());//å»ºç«‹ä¸€ä¸ªä¸Šä¼ æ–‡ä»¶çš„è¾“å‡º‹¹?br> int bytesRead2 = 0;
byte[] buffer2 = new byte[8192];
while ((bytesRead2 = stream2.read(buffer2, 0, 8192)) != -1)
{
bos2.write(buffer2, 0, bytesRead2);//ž®†æ–‡ä»¶å†™å…¥æœåŠ¡å™¨
}
bos2.close();
stream2.close();
}if(file3.getFileSize()!=0){
ByteArrayInputStream stream3 = (ByteArrayInputStream) file3.getInputStream();//把文件读�br> OutputStream bos3 = new FileOutputStream(filePath +
"UploadFiles\\"+file3.getFileName());//å»ºç«‹ä¸€ä¸ªä¸Šä¼ æ–‡ä»¶çš„è¾“å‡º‹¹?br> int bytesRead3 = 0;
byte[] buffer3 = new byte[8192];
while ((bytesRead3 = stream3.read(buffer3, 0, 8192)) != -1)
{
bos3.write(buffer3, 0, bytesRead3);//ž®†æ–‡ä»¶å†™å…¥æœåŠ¡å™¨
}
bos3.close();
stream3.close();
}
Configuration config = new Configuration().configure();
SessionFactory factory = config.buildSessionFactory();
session = factory.openSession();
Transaction transaction = session.beginTransaction();
Node node=new Node();
node.setNodeName(nodename);
node.setXsdName(file.getFileName());
node.setXslName(file2.getFileName());
node.setXhtmlName(file3.getFileName());
node.setNote(note);
session.save(node);
session.flush();
session.clear();
forward="display";
transaction.commit();
}
catch (Exception e)
{
forward="error";
System.err.print(e);
e.printStackTrace();
}
finally{
session.close();
}
return mapping.findForward(forward);
}
mysql 常用命ä×o
1˜qžæŽ¥æ•°æ®åº“：
˜q›å…¥mysql的安装èµ\径bin如：C:>cd C:Program FilesMySQLMySQL Server 5.0bin
输入用户å密ç ： C:Program FilesMySQLMySQL Server 5.0bin>mysql -uroot -p123456
2退出mysql
mysql>exit
3. 修改密ç :
C:Program FilesMySQLMySQL Server 5.0bin>mysqladmin -uroot -p123456 password 456123
4.å¢žåŠ ç”¨æˆ·åQ?br>æ·ÕdŠ 一个用户test1 密ç 为ABCåQ›è®©ä»–å¯ä»¥åœ¨ä»ÖM½•ä¸ÀLœºä¸Šç™»å½?òq¶å¯¹æ‰€æœ‰æ•°æ®åº“有查询ã€æ’å…¥ã€ä¿®æ”V€åˆ 除的æƒé™ã€‚首先用以root用户˜qžå…¥mysql,
mysql>grant select,insert,update,delete on *.* to test1@"%" Identified by "abc";
å¢žåŠ ä¸€ä¸ªç”¨æˆ·test2密ç 为abc,让其åªå¯ä»¥åœ¨localhost上登å½?òq¶å¯ä»¥å¯¹æ•°æ®åº“mydb˜q›è¡ŒæŸ¥è¯¢ã€æ’å…¥ã€ä¿®æ”V€åˆ 除的æ“作åQˆlocalhost指本åœîC¸»æœ?å³mysqlæ•°æ®åº“所在的那å°ä¸ÀLœºåQ?˜q™æ ·ç”¨æˆ·å³ä‹É用知é“test2的密ç ï¼Œä¹Ÿæ— æ³•ä»Žinternet上直接访问数æ®åº“,åªèƒ½é€šè¿‡mysqlä¸ÀLœºä¸Šçš„web™å‰|¥è®‰K—®äº†ã€?/p>
mysql>grant select,insert,update,delete on mydb.* to test2@localhost identified by "abc";
å¢žåŠ ä¸€ä¸ªå¯ä»¥ä»Žä»ÖM½•åœ°æ–¹˜qžæŽ¥æœåŠ¡å™¨çš„一个完全的‘…çñ”用户
mysql>grant all privileges on *.* to test3@"%" identified by 'abc' with grant option;
5.åˆ é™¤æŽˆæƒ(与上é¢æŽˆæƒç›¸å¯¹åº”)
mysql>revoke select,insert,update,delete on *.* from test1@"%" ;
mysql>revoke select,insert,update,delete on mydb.* from test2@localhost;
mysql>revoke all privileges on *.* from test3@"%";
6.昄¡¤ºæ•°æ®åº?br>mysql>show databases;
7.昄¡¤ºæ•°æ®åº“ä¸çš„表(examæ•°æ®åº“å)
mysql>use examåQ?br>mysql>show tablesåQ?/p>
8.昄¡¤ºè¡¨çš„¾l“æž„åQˆdb_testtemp表ååQ?br>mysql>describe db_testtemp;
9.建库
mysql>create database 库å;
10.å»ø™¡¨
mysql>use test;
mysql>create table teacher(
id int(3) auto_increment not null primary key,
name char(10) not null,
address varchar(50) default 'beijing',
year date
);
或�/p>
school.sql的内�/p>
use exam;
create table teacher(
id int(3) auto_increment not null primary key,
name char(10) not null,
address varchar(50) default 'beijing',
year date
);
把文件school.sql攑ֈ°c:下，òq¶åœ¨DOS状æ€è¿›å…¥ç›®å½•C:>cd C:Program FilesMySQLMySQL Server 5.0bin
然åŽC:Program FilesMySQLMySQL Server 5.0bin>mysql -uroot -p456123 < c:school.sql
如果æˆåŠŸåQŒç©ºå‡ÞZ¸€è¡Œæ— ä»ÖM½•æ˜„¡¤ºåQ›å¦‚有错误，会有æ示ã€?/p>
11.åˆ é™¤åº?br>mysql>drop database test;
å’Œåˆ é™¤è¡¨
mysql>use exam;
mysql>drop table teacher;
14.表é‡å‘½å
mysql>alter table teacher rename student;
15. 备䆾数æ®åº?生æˆçš„exam.sql攑֜¨ç›®å½•C:Program FilesMySQLMySQL Server 5.0binä¸?
C:Program FilesMySQLMySQL Server 5.0bin>mysqldump -hlocalhost -uroot -pncae2010 exam > exam.sql
16. æ¢å¤æ•°æ®åº?localhostä¸èƒ½ç”¨æœ¬æœºIP代替)
C:Program FilesMySQLMySQL Server 5.0bin>mysql -hlocalhost -uroot -pncae2010 exam < exam.sql
17.å¤åˆ¶æ•°æ®åº?把所有的数æ®åº“备份到目录C:Program FilesMySQLMySQL Server 5.0bin下的all-databases.sqlæ–‡äšgä¸?
C:Program FilesMySQLMySQL Server 5.0bin>mysqldump -hlocalhost -uroot -pncae2010 --all-databases > all-databases.sql
18.备䆾è¡?生æˆçš„student.sql攑֜¨ç›®å½•C:Program FilesMySQLMySQL Server 5.0binä¸?
C:Program FilesMySQLMySQL Server 5.0bin>mysqldump -hlocalhost -uroot -pncae2010 exam student > student.sql
19.æ¢å¤è¡?æ“作å‰å…ˆæŠŠåŽŸæ¥çš„è¡¨åˆ é™?
C:Program FilesMySQLMySQL Server 5.0bin>mysql -h(ip) -uroot -p(password) databasename tablename < tablename.sql
˜q˜æœ‰ä¸€äº›æœªå®žè·µ
20.ä¸ÞZº†æ”¹å˜åˆ—aåQŒä»ŽINTEGER改äØ“TINYINT NOT NULL(åå—一æ ?åQ?br>òq¶ä¸”改å˜åˆ—båQŒä»ŽCHAR(10)改äØ“CHAR(20)åQŒåŒæ—‰™‡å‘½å它，从b改äØ“c:
ALTER TABLE t2 MODIFY a TINYINT NOT NULL, CHANGE b c CHAR(20);
å¢žåŠ ä¸€ä¸ªæ–°TIMESTAMP列，åäØ“dåQ?br>ALTER TABLE t2 ADD d TIMESTAMP;
在列dä¸Šå¢žåŠ ä¸€ä¸ªçƒ¦å¼•ï¼Œòq¶ä¸”使列aä¸ÞZ¸»é”®ï¼š
ALTER TABLE t2 ADD INDEX (d), ADD PRIMARY KEY (a);
åˆ é™¤åˆ—cåQ?br>ALTER TABLE t2 DROP COLUMN c;
å¢žåŠ ä¸€ä¸ªæ–°çš„AUTO_INCREMENT整数列，命å为cåQ?br>ALTER TABLE t2 ADD c INT UNSIGNED NOT NULL AUTO_INCREMENT,ADD INDEX (c);
注æ„åQŒæˆ‘们烦引了cåQŒå› 为AUTO_INCREMENT柱必™å»è¢«ç´¢å¼•åQŒåƈ且å¦å¤–我们声明c为NOT NULLåQ?br>å› äؓ索引了的列ä¸èƒ½æ˜¯NULL
---------------------------------------------------------------
21.æ•°æ®çš„导入导å‡?br>A。mysqlimport
è¯æ³•åQšmysqlbinmysqlimport database tables.txt( æ–‡äšgå需è¦ä¸Žè¡¨å相åŒ)
å‚æ•°åQ?d or --delete æ–°æ•°æ®å¯¼å…¥æ•°æ®è¡¨ä¸ä¹‹å‰åˆ 除数æ®æ•°æ®è¡¨ä¸çš„所有信æ¯ï¼›
-f or --force ä¸ç®¡æ˜¯å¦é‡åˆ°é”™è¯¯î‚?br>-i or --ignore mysqlimportè·Œ™¿‡æˆ–者忽略那些有相åŒå”¯ä¸€å…³é”®å—的行， 导入文äšgä¸çš„数殞®†è¢«å¿½ç•¥åQ?br>-l or -lock-tables æ•°æ®è¢«æ’入之å‰é”ä½è¡¨åQŒè¿™æ ·å°±é˜²æ¢äº†ï¼Œ ä½ åœ¨æ›´æ–°æ•°æ®åº“æ—¶åQŒç”¨æˆïLš„查询和更新å—到媄å“ï¼›
--fields-enclosed- by= char
　　指定文本文äšgä¸æ•°æ®çš„记录时以什么括èµïLš„åQ?很多情况下数æ®ä»¥åŒå¼•åäh‹¬èµ—÷€?默认的情况下数æ®æ˜¯æ²¡æœ‰è¢«å—符括è“vçš„ã€?
　　--fields-terminated- by=char
　　指定å„个数æ®çš„å€ég¹‹é—´çš„分隔½W¦ï¼Œåœ¨å¥å·åˆ†éš”çš„æ–‡äšgä¸ï¼Œåˆ†éš”½W¦æ˜¯å¥å·ã€‚您å¯ä»¥ç”¨æ¤é€‰é¡¹æŒ‡å®šæ•°æ®ä¹‹é—´çš„分隔符。默认的分隔½W¦æ˜¯è·Ïx ¼½W?/p>
åQˆTabåQ?
　　--lines-terminated- by=str
　　æ¤é€‰é¡¹æŒ‡å®šæ–‡æœ¬æ–‡äšgä¸è¡Œä¸Žè¡Œä¹‹é—´æ•°æ®çš„分隔嗽W¦ä¸² 或者嗽W¦ã€?默认的情况下mysqlimport以newlineä¸ø™¡Œåˆ†éš”½W¦ã€?您å¯ä»¥é€‰æ‹©ç”¨ä¸€ä¸ªå—
½W¦ä¸²æ¥æ›¿ä»£ä¸€ä¸ªå•ä¸ªçš„å—符åQ?一个新行或者一个回车ã€?
　　mysqlimport命ä×o常用的选项˜q˜æœ‰-v 昄¡¤ºç‰ˆæœ¬åQˆversionåQ‰ï¼Œ -p æ示输入密ç åQˆpasswordåQ‰ç‰ã€?/p>
--------------------------------------------------------------
22.常用æ’å…¥ã€ä¿®æ”V€åˆ 除è¯å?br>æ’入记录åQšinsert into teacher s('','glchengang','深圳一ä¸?,'1976-10-10');
修改记录åQšupdate mytable set single=′y′ where name=′abccs′;
åˆ é™¤è®°å½•åQšdelete from mytable where name=′abc′;
出现: mysql çš„æ½Cºç¬¦åQŒæ¤æ—¶å·²˜q›å…¥mysql的交互æ“作方å¼ã€?br>3ã€é€€å‡ºMySQLæ“作界é¢
在mysql>æ示½W¦ä¸‹è¾“å…¥quitå¯ä»¥éšæ—¶é€€å‡ÞZº¤äº’æ“作界é¢ï¼š
mysql> quit
Bye
ä½ ä¹Ÿå¯ä»¥ç”¨control-D退出ã€?
4ã€ç¬¬ä¸€æ¡å‘½ä»?
mysql> select version(),current_date();
+----------------+-----------------+
| version() | current_date() |
+----------------+-----------------+
| 3.23.25a-debug | 2001-05-17 |
+----------------+-----------------+
1 row in set (0.01 sec)
mysql>
æ¤å‘½ä»¤è¦æ±‚mysqlæœåŠ¡å™¨å‘Šè¯‰ä½ 它的版本å·å’Œå½“å‰æ—¥æœŸã€‚å°è¯•ç”¨ä¸åŒå¤§å°å†™æ“作上˜q°å‘½ä»¤ï¼Œçœ‹ç»“果如何。结果说明mysql命ä×o的大ž®å†™¾l“果是一致的ã€?
¾lƒä¹ 如下æ“作åQ?
mysql>Select (20+5)*4;
mysql>Select (20+5)*4,sin(pi()/3);
mysql>Select (20+5)*4 AS Result,sin(pi()/3); (AS: 指定å‡å为Result)
<B>5ã€å¤šè¡Œè¯å?lt;/B>
一æ¡å‘½ä»¤å¯ä»¥åˆ†æˆå¤šè¡Œè¾“入，直到出现分巓åQ?#8221;为æ¢åQ?
<ccid_nobr>
<table width="400" border="1" cellspacing="0" cellpadding="2"
bordercolorlight = "black" bordercolordark = "#FFFFFF" align="center">
<tr>
<td bgcolor="e6e6e6" class="code" style="font-size:9pt">
<pre><ccid_code> mysql> select
-> USER()
-> ,
-> now()
->;
+--------------------+---------------------+
| USER() | now() |
+--------------------+---------------------+
| ODBC@localhost | 2001-05-1:59:15 |
+--------------------+---------------------+
1 row in set (0.06 sec)
mysql>
注æ„ä¸é—´çš„逗å·å’Œæœ€åŽçš„分å·çš„ä‹É用方法ã€?
6ã€ä¸€è¡Œå¤šå‘½ä×o
输入如下命ä×oåQ?
mysql> SELECT USER(); SELECT NOW();
+------------------+
| USER() |
+------------------+
| ODBC@localhost |
+------------------+
1 row in set (0.00 sec)
+---------------------+
| NOW() |
+---------------------+
| 2001-05-17 23:06:15 |
+---------------------+
1 row in set (0.00 sec)
mysql>
注æ„ä¸é—´çš„分åøP¼Œå‘½ä×o之间用分å·éš”å¼€ã€?
7ã€æ˜¾½Cºå½“å‰å˜åœ¨çš„æ•°æ®åº?
mysql> show databases;
+----------+
| Database |
+----------+
| mysql |
| test |
+----------+
2 row in set (0.06 sec)
mysql>
8ã€é€‰æ‹©æ•°æ®åº“åƈ昄¡¤ºå½“å‰é€‰æ‹©çš„æ•°æ®åº“
mysql> USE mysql
Database changed
mysql>
(USE å’?QUIT 命ä×oä¸éœ€è¦åˆ†åïL»“æŸã€‚）
mysql> select database();
+---------------+
| database() |
+---------------+
| mysql |
+---------------+
1 row in set (0.00 sec)
9ã€æ˜¾½Cºå½“å‰æ•°æ®åº“ä¸å˜åœ¨çš„è¡?
mysql> SHOW TABLES;
10ã€æ˜¾½Cø™¡¨(db)的内å®?
mysql>select * from db;
11ã€å‘½ä»¤çš„å–消
当命令输入错误而åˆæ— 法改å˜åQˆå¤šè¡Œè¯å¥æƒ…形）æ—Óž¼Œåªè¦åœ¨åˆ†å·å‡ºçŽ°å‰ž®±å¯ä»¥ç”¨ cæ¥å–消该æ¡å‘½ä»?
mysql> select
-> user()
-> c
mysql>
一ã€å¼€å‘å’Œ¾~–译代ç 时指定嗽W¦é›†ä¸ºUTF-8。JBuilderå’ŒEclipse都å¯ä»¥åœ¨™å¹ç›®å±žæ€§ä¸è®„¡½®ã€?
二ã€ä‹É用过滤器åQŒå¦‚果所有请求都¾l过一个Servlet控制分é…器，那么使用Servletçš„filter执行è¯å¥åQŒå°†æ‰€æœ‰æ¥è‡ªæµè§ˆå™¨çš„请求（requeståQ‰è{æ¢äØ“UTF-8åQŒå› 为æµè§ˆå™¨å‘过æ¥çš„è¯äh±‚åŒ…æ ¹æ®æµè§ˆå™¨æ‰€åœ¨çš„æ“作¾pÈ»Ÿ¾~–ç åQŒå¯èƒ½æ˜¯å„ç§å½¢å¼¾~–ç 。关键一å¥ï¼š
request.setCharacterEncoding("UTF-8")ã€?br>需è¦é…¾|®web.xml ‹È€‹z»è¯¥Filterã€?
三ã€åœ¨JSP头部声明åQ?lt;%@ page contentType="text/html;charset= UTF-8" %>ã€?
å››ã€åœ¨Jspçš„html代ç ä¸ï¼Œå£°æ˜ŽUTF-8:<meta http-equiv="Content-Type" content="text/html;charset=utf-8">
五ã€è®¾å®šæ•°æ®åº“˜qžæŽ¥æ–¹å¼æ˜¯UTF-8。例如连接MYSQLæ—‰™…¾|®URL如下åQ?br>jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8
一般数æ®åº“都å¯ä»¥é€šè¿‡½Ž¡ç†è®„¡½®è®‘Ö®šUTF-8
å…ã€å…¶ä»–和外界交互时能够设定编ç æ—¶ž®Þp®¾å®šUTF-8åQŒä¾‹å¦‚读å–æ–‡ä»Óž¼Œæ“作XML½{‰ã€?
七ã€å¦‚æžœä‹É用的是tomcatæœåŠ¡å™¨ï¼Œé‚£ä¹ˆä¿®æ”¹åœ?{tomcat_home}/conf/ä¸çš„server.xmlæ–‡äšgåQ?br><Connector port="8080"
maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
enableLookups="false" redirectPort="8443" acceptCount="100"
debug="0" connectionTimeout="20000"
disableUploadTimeout="true" URIEncoding="UTF-8" />
或者改为：
<Connector port="8080"
maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
enableLookups="false" redirectPort="8443" acceptCount="100"
debug="0" connectionTimeout="20000"
disableUploadTimeout="true" useBodyEncodingForURI="true" />
都能辑ֈ°å¾ˆå¥½çš„效果ã€?br>