JDBCÁ¬½ÓMySQL³ÌÐò_by ÀÏ´ó&stone
ѧjava,ÓÐ×ÅÌ«¶àµÄÒÉÎʺͲ»½â,¾ÀúÁËÎÞÊýËÆºõ¼òµ¥µ½ÎÊÌâ½â¾öºóͻȻ·¢ÏÖ×Ô¼ºÄÇôsxµÄµØ²½,È»¶ø¾ÍÎҵĸоõ,¶Ôÿ¸ö³õѧÕßÀ´Ëµ¶¼ÎÞ·¨±ÜÃâµÄÒª¾¹ýÕâ¸öÈÃÈËÍ´¿àµ½¶ñÐÄŻ͵½µ½»èØÊµÄµØ²½;ÕâÒ²ÐíÕýÊÇjava½ø½×֮ǰËùν×òÒ¹Î÷·çµò±ÖÊ÷°ãµÄ±Ø¾Ö®Í¾°É!
·Ï»°²»¶à˵ÁË,ÏÂÃæÕâ¸öÊÇÒ»¸öÔÚeclipseÖÐÔËÐÐͨ¹ýµÄÍêÕû³ÌÐò;ÔÚmysqlÊý¾Ý¿âÖн¨Á¢Á˱íangel_info,±íÖÐÓÐ×Ö¶ÎidºÍname,ͨ¹ýÏÂÃæµÄ³ÌÐò¿ÉÒÔ½«±íÖеÄÄÚÈݲéÕÒ²¢ÏÔʾ³öÀ´!
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
//import com.sun.corba.se.pept.transport.Connection;
public class connect {
/**
* @param args
*/
public static void main(String[] args) {
try
{
Class.forName("com.mysql.jdbc.Driver");
Connection con=(Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","stone");
Statement stat=(Statement) ((java.sql.Connection) con).createStatement();
String sql="select * from angel_info";
ResultSet rs=((java.sql.Statement) stat).executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getString("id"));
System.out.println(rs.getString("name"));
}
}
catch(SQLException e)
{System.out.println(e);}
catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
}
ÕÊ»§ÊÇÓÃĬÈϵÄ:root,stone
Êý¾Ý¿âÃû×ÖÊÇ:test
±íÊÇ:angel_info
ÀïÃæ¾ÍÁ½¸ö×ֶΣºid ºÍ name
Ïà¹ØÎĵµ£º
MYSQL ɾ³ýͬһ±íÖÐÖØ¸´¼Ç¼
CREATE TABLE `user` (
`db_id` varchar(255) NOT NULL,
`name` varchar(45) default NULL,
`age` int(10) unsigned NOT NULL,
`address` varchar(45) default NULL,
PRIMARY KEY (`db_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
&nb ......
[perl] ÅúÁ¿Ìø¹ýmysql slave´íÎóС½Å±¾
2009Äê02ÔÂ20ÈÕ 16:24
·¢ÏÖmysql slave·þÎñÆ÷¾³£ÒòÎªÒ»Ð©ÌØÊâ×Ö·û»òÕß·ûºÅ²úÉúµÄ¸üÐÂÓï¾ä±¨´í£¬Õû¸öͬ²½Ò²»áÒò´Ë¶ø¿¨ÔÚÄÇ£¬×î³õµÄ°ì·¨Ö»ÊÇÊÖ¶¯È¥³ö´íµÄ»úÆ÷£¬Ö´ÐÐÏÂÃæÈýÌõsqlÓï¾ä£¬Ìø¹ý´íÎó¼´¿É¡£
slave stop;
set GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
slave start;
һ̨slave»ú ......
http://www.xiaojb.com/archives/it/mysqlroot.shtml
Method 1:
ÔÚ/usr/local/mysql/bin/Ï£º
./mysqladmin -u root password ‘new_password’
Ò»°ã°²×°Ê±Óô˷½·¨ÉèÖá£
Method 2:
ÔÚmysql״̬Ï£º
mysql>UPDATE user SET password=PASSWORD(’new_password’) WHERE user=’root&rsq ......
ºÜ¾ÃûÓÐЩһЩÓÐÓô¦µÄµÄ¶«Î÷ÁË£¡½ñÌì¾Í²»ºúÂÒµÄд¶«Î÷ÁË!дһЩÓÐÓõ졵±È»Ç°ÌáÏÂÊǺܸÐлºÜ¶à¾³£À´ÎÒ²©¿ÍµÄÅóÓÑһϣ¡¶àл´ó¼Ò£¡£¡£¡£¡£¡
½ñÌìдµÄÊǹØÓÚphp»·¾³¼ÜÉèµÄµÚÒ»ÖÖ·½Ê½£¡µ±È»ÎҾͲ»½ØÍ¼ÁË£¡´ó¼ÒÖ»Òª°´ÕÕ²Ù×÷¾Í¿ÉÒÔʵÏֵģ¡
Ò»¡¢°²×° PHP £º±¾ÎÄPHP°²×°Â·¾¶È¡ÎªD:\php\php4\(Ϊ±Ü»ìÏý£¬PHP5.1.x°æ±¾°²×°Â·¾ ......
PHPµÄÖ´ÐÐЧÂÊÊÇÓÐÄ¿¹²¶ÃµÄ£¬ÕâÒ²ÊÇÎÒϲ»¶ËüµÄÔÒòÖ®Ò»£¬ºÍËü³ÆÎª¾øÃî´îµµµÄMysqlÒÔ¼°ApacheÏëÈںϣ¬²»Äܲ»¾ªÌ¾ÆäЧÂÊÁË¡£PHP¸üÐÂÒ²ºÜ¿ì£¬ÕâÀïÁоÙÁËĿǰ×îа汾PHP4.3.2RC4£¨¼¸ºõûÓÐBUGÁË£¬¹À¼ÆÐ´ÍêÕâÆª²»¾ÃºóÕýʽ°æ¾Í³öÁË£©£¬ºÍ×îа汾µÄMysql4.0.13µÄ°²×°¹ý³Ì¡£
¡¡¡¡PHPµÄ°²×°Îļþ¿ÉÒÔÖ±½Óµ½ &nb ......