javaÖÐÊý¾Ý¿âµÄ±¸·ÝÓ뻹Ô
Ê×ÏÈ£¬ÉèÖÃmysqlµÄ»·¾³±äÁ¿£¨ÔÚpathÖÐÌí¼Ó%MYSQL_HOME%\bin£©£¬ÖØÆôµçÄÔ¡£
ÍêÕû´úÂ룺
/**
* @param args
*/
public static void main(String[] args) {
/*
* ±¸·ÝºÍµ¼ÈëÊÇÒ»¸ö»¥ÄæµÄ¹ý³Ì¡£
* ±¸·Ý£º³ÌÐòµ÷ÓÃmysqlµÄ±¸·ÝÃüÁ¶Á³ö¿ØÖÆÌ¨ÊäÈëÁ÷ÐÅÏ¢£¬Ð´Èë.sqlÎļþ£»
* µ¼È룺³ÌÐòµ÷ÓÃmysqlµÄµ¼ÈëÃüÁ°Ñ´Ó.sqlÎļþÖжÁ³öµÄÐÅϢдÈë¿ØÖÆÌ¨µÄÊä³öÁ÷
* ×¢Ò⣺´Ëʱ¶¨Ïò·û">"ºÍ"<"ÊDz»ÄÜÓõÄ
*/
backup();
load();
}
/**
* ±¸·Ý¼ìÑéÒ»¸ösqlÎļþÊÇ·ñ¿ÉÒÔ×öµ¼ÈëÎļþÓõÄÒ»¸öÅжϷ½·¨£º°Ñ¸ÃsqlÎļþ·Ö±ðÓüÇʱ¾ºÍultra
* edit´ò¿ª£¬Èç¹û¿´µ½µÄÖÐÎľùÕý³£Ã»ÓÐÂÒÂ룬Ôò¿ÉÒÔÓÃÀ´×öµ¼ÈëµÄÔ´Îļþ£¨²»¹ÜsqlÎļþµÄ±àÂë¸ñʽÈçºÎ£¬Ò²²»¹ÜdbµÄ±àÂë¸ñʽÈçºÎ£©
*/
public static void backup() {
try {
Runtime rt = Runtime.getRuntime();
// µ÷Óà mysql µÄ cmd:
Process child = rt
.exec("mysqldump -u root --set-charset=utf8 bjse act_obj");// ÉèÖõ¼³ö±àÂëΪutf8¡£ÕâÀï±ØÐëÊÇutf8
// °Ñ½ø³ÌÖ´ÐÐÖеĿØÖÆÌ¨Êä³öÐÅϢдÈë.sqlÎļþ£¬¼´Éú³ÉÁ˱¸·ÝÎļþ¡£×¢£ºÈç¹û²»¶Ô¿ØÖÆ
Ïà¹ØÎĵµ£º
Õâ¶Îʱ¼ä¿ªÊ¼Ñ§Ï°Ð´´æ´¢¹ý³Ì£¬Ö÷ÒªÔÒò»¹ÊÇÒòΪ¹¤×÷ÐèÒª°É£¬±¾À´ÒÔΪºÜ¼òµ¥µÄ£¬µ«¼¸¾´ìÕÛ£¬ºÀÆøÏûÄ¥´ù¾¡£¬µ«×ÜËã¸ãͨÁË£¬ÎªÁ˱ÜÃâºóÀ´ÕßÉÙ×ßÍä·£¬ÌؼÇÊöÓë´Ë£¬Í¬Ê±Òà¶Ô×Ô¼º½øÐйÄÀø¡£
Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
´æ´¢¹ý³ÌΪ£º
CREATE OR REPLACE PROCEDURE TESTA(PARA1 IN VARCHAR2,PARA2 IN VARCHAR2) AS
BEGIN
......
Õâ¸öÎÊÌâÔÚÓÚ ÔÚFrameÖÐÌí¼Ó×é¼þʱ£¬Ã¿¸ö×é¼þÏÈÉ趨ÁËλÖ㬵«ÊÇÌí¼Óµ½FrameÖкóʼÖÕ»á³öÏÖÎÊÌâ¡£
ÀýÈ磺
class MyGame extends Frame
{
MyGame()
{
Label c[] = new Label[8];
for(i = 0; i<8; i++)
{
c[i] = new Lab ......
ºÃ¶à´óÐÍµÄÆóÒµÏîÄ¿¶¼ÒªÓõ½¸ß¼¶JDBCÁ¬½ÓÊý¾Ý¿âÅäÖø߼¶JDBCʵÀýÈçÏ£º
µÚÒ»£ºÅäÖÃTomcatϵÄconfÎļþ¼ÐϵÄcontext.xmlÎļþ
<?xml version='1.0' encoding='utf-8'?>
<Context>
<Resource name="jdbc/Ãû³Æ" auth="Container" type="javax.sql.DataSource"
maxActive="10" maxIdle=" ......
±¾ÆªÄÚÈݳнÓÉÏÆªÖ®ºó£¬ÊôJAVA»ù´¡ÖªÊ¶Ö®Êý¾ÝÀàÐÍ£¬ËùÒÔ¸üÇãÏòÓÚJAVAÓïÑÔ±¾Éí£¬ÊʺϳõѧºÍ¸´Ï°µÄÅóÓÑÔĶÁ¡£
Ò»¡£Êý¾ÝÀàÐÍ
1.»ù±¾Êý¾ÝÀàÐÍ
&nb ......
java»·¾³±äÁ¿ÉèÖý̳Ì
ÏÂÔØºÃµÄJDKÊÇÒ»¸ö¿ÉÖ´Ðа²×°³ÌÐò£¬Ë«»÷°²×°¡£½«°²×°Â·¾¶¸ÄΪ£ºC:\jdk1.6.0£¨µ±È»ÆäËû·¾¶Ò²¿ÉÒÔ£©¡£
JDK°²×°Íê³ÉÖ®ºó
ÎÒÃÇÀ´ÉèÖû·¾³±äÁ¿£º
ÎҵĵçÄÔµãÓÒ¼ü£¬Ñ¡Ôñ“ÊôÐÔ”£¬Ñ¡Ôñ“¸ß¼¶”±êÇ©£¬½øÈë»·¾³±äÁ¿ÉèÖ㬷ֱðÉèÖÃÈçÏÂÈý¸ö»·¾³±äÁ¿£º
£¨1£©
ÉèÖúÃpath±äÁ¿£¬Ê¹µ ......