JDBCÁ¬½ÓMySQLÊý¾Ý¿âʵÏÖÔöɾ²é¸Ä
	
    
    
	package com.qll.operate;
import java.sql.*;
public class OperateUser {
 String driver = "com.mysql.jdbc.Driver";
 String url = "jdbc:mysql://localhost:3306/test";
 String name = "root";
 String password = "123456";
 static Connection conn = null;
 Statement st = null;
 ResultSet rs = null;
 String sql = null;
 public void add() {
  try {
   sql = "insert into tuser values(60024054,'È«ÀÚÀÚ','ÄÐ',24,'¹ã¶«Ê¡ÉîÛÚÊÐ')";
   Class.forName(driver);
   conn = DriverManager.getConnection(url, name, password);
   st = conn.createStatement();
   st.executeUpdate(sql);
   conn.close();
  } catch (Exception e) {
   e.printStackTrace();
  }
 }
 public void delete() {
  try {
   sql = "delete from tuser where id=60024054 ";
   Class.forName(driver);
   conn = DriverManager.getConnection(url, name, password);
   st = conn.createStatement();
   st.executeUpdate(sql);
   st.close();
   conn.close();
  } catch (Exception e) {
   e.printStackTrace();
  }
 }
 public void find() {
  try {
   sql = "select * from tuser";
   Class.forName(driver);
   conn = DriverManager.getConnection(url, name, password);
   st = conn.createStatement();
   rs = st.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getInt(1) + "\t" + rs.getString(2) + "\t"
      + rs.getString(3) + "\t" + rs.getInt(4) + "\t"
      + rs.getString(5));
   }
   rs.close();
   st.close();
 &nb
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    
Êý¾Ý¿âÉè¼Æ£º
--
-- Êý¾Ý¿â: `test`
--
-- --------------------------------------------------------
--
-- ±íµÄ½á¹¹ `menu`
--
CREATE TABLE IF NOT EXISTS `menu` (
`ID` int(10) unsigned NOT NULL auto_increment,
`PID` int(11) NOT NULL,
`TITLE` varchar(200) NOT NULL,
`REMARK` varchar(200) NOT  ......
	
    
        
    
    
MySQLÎå¸ö²éѯÓÅ»¯·½·¨
 
ÊìϤSQLµÄÈ˶¼ÖªµÀ£¬Íê³Éͬһ¸öÈÎÎñ£¬SQL¿ÉÄÜÓжàÖÖд·¨£¬µ«²»Í¬Ð´·¨µÄ²éѯ
ÐÔÄÜ¿ÉÄÜ»áÓÐÌìÈÀÖ®±ð£¬±¾ÎÄÁоٳöÎå¸ö²éѯÓÅ»¯µÄ·½·¨
£¬µ±È»£¬ÓÅ»¯µÄ·½·¨»¹Óкܶࡣ¡¡¡¡
1¡¢ÓÅ»¯Êý¾ÝÀàÐÍ
MySQL
ÖÐÊý¾ÝÀàÐÍÓжàÖÖ£¬Èç¹ûÄãÊÇÒ»ÃûDBA£¬ÕýÔÚ°´ÕÕÓÅ»¯µÄÔÔò¶ÔÊý¾ÝÀàÐͽøÐÐÑϸñµÄ¼ì²é£¬µ«¿ª·¢
ÈËÔ ......
	
    
        
    
    mysqlÊÇÒ»¸öÓÅÐãµÄ¿ªÔ´Êý¾Ý¿â£¬ËüÏÖÔÚµÄÓ¦Ó÷dz£µÄ¹ã·º£¬Òò´ËºÜÓбØÒª¼òµ¥µÄ½éÉÜÒ»ÏÂÓÃpython²Ù×÷mysqlÊý¾Ý¿âµÄ·½·¨¡£python²Ù×÷Êý¾Ý¿âÐèÒª°²×°Ò»¸öµÚÈý·½µÄÄ£¿é£¬ÔÚhttp://mysql-python.sourceforge.net/
ÓÐÏÂÔØºÍÎĵµ¡£
    ÓÉÓÚpythonµÄÊý¾Ý¿âÄ£¿éÓÐרÃŵÄÊý¾Ý¿âÄ£¿éµÄ¹æ·¶£¬ËùÒÔ£¬Æäʵ²»¹ÜʹÓÃÄÄÖÖÊý¾ ......
	
    
        
    
    
http://www.mysql.cn/
ÊÂÎñ£¬²ÎÊý£¬Ç¶Ì×µ÷Óã¬Óα꣬ѻ·, ´¥·¢Æ÷£¬ÊÓͼ£¬Ô¼Êø, Ë÷Òý£¬¡£¡£¡£
1. ´´½¨ÊµÀýÊý¾Ý¿â
   create database db5;
   use db5;
2.´´½¨Ò»¸ö¼òµ¥µÄ¹¤×÷±í,²¢²åÈëÊý¾Ý
   create table t(s1 int);
   insert into t values(5);
3.´´½¨³ÌÐòʵÀý crea ......