Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 ´íÎó½â¾ö·½°¸

MySql Error Nr. 1045
¹Ø¼ü×Ö: error 1045
ÎÊÌâÃèÊö£º
Ò»¸ö¿Í»§µÄ·þÎñÆ÷£¨windows£©ÉÏÒѾ­×°ÁËÒ»¸öphp+apache+mysql£¬ÏÖÔÚÐèÒªÔÚÕą̂·þÎñÆ÷ÉÏÔÙ×°Ò»¸ö֪ʶ¿âϵͳ£¬
Êý¾Ý¿âÒ²ÊÇʹÓõÄmysql£¬È»ºó°²×°Ò»¸öеÄmysql£¬Ê¹ÓÃÁËеĶ˿ںͷþÎñÃû£¬
°²×°×îºóÒ»²½Ìáʾ“Error Nr. 1045 ......”£¬½øÈëMySQL Comm ......

mysql µ¼Èë¡¢µ¼³öÊý¾Ý¿â¡¢±í

DOS¡¡´°¿Ú
¿ªÊ¼£­£¾ÔËÐУ­£¾¡¡cmd
µ¼³öΪ£º¡¡mysqldump -u Óû§Ãû -p  --opt  Êý¾Ý¿âÓû§Ãû >
Êý¾Ý¿âÃû.sql
ÊäÈëÄãµÄÊý¾Ý¿âÃÜÂë!phpma.com
µ¼ÈëΪ£ºmysql -u Óû§Ãû -p Êý¾Ý¿âÓû§Ãû < Êý¾Ý¿âÃû.sql
£¨Òª
ÔÚµ±Ç°Ä¿Â¼Ï²Ù×÷£©
ÒªÏ뽫Îı¾Îļþ

pet.txt

×°ÔØµ½
pet
±íÖУ¬Ê¹Ó ......

ÐÞ¸ÄmysqlµÄrootÃÜÂëµÄ¼¸ÖÖ·½·¨

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 ......

MySQL¼à¿Ø

Ô­ÎÄÍøÖ·£ºhttp://knowhow.innovatedigital.com/mysql-monitoring.html
MySQLÊÇ×îÁ÷ÐеĿª·ÅÔ´´úÂë¹ØÏµÊý¾Ý¿âϵͳ¡£ÆäÐÔÄܺÍÒ×ÓÃÐÔ£¬Ê¹Æä³ÉΪLAMP¼Ü¹¹µÄÖÐÐÄÖ§ÖùÖ®Ò»¡£
       MySQL¼à¿ØÒ»Ö±ÊǹØ×¢MySQLÊý¾Ý¿âÐÔÄܺÍMySQLÊý¾Ý¿âÔËά¹ÜÀí¼¼ÊõÈËÔ±µÄ·Ç³£¸ÐÐËȤ»°Ìâ¡£ÈçºÎÈÃÄúµÄMySQLÊý¾Ý¿â° ......

ÐÞ¸ÄmysqlÊý¾Ý¿âµÄĬÈϱàÂ뷽ʽ


< type="text/javascript">
document.body.oncopy = function() {
if (window.clipboardData) {
setTimeout(function() {
var text = clipboardData.getData("text");
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ