import java.sql.*;


public class MySqlTest {

	/**
	 * @param args
	 */
	public static void main(String args[])
   {
	
		String url = "jdbc:mysql://localhost:3306/jiaoxue";
    String user ="root";//這里替換成你自已的數據庫用戶名
    String password = "123456";//這里替換成你自已的數據庫用戶密碼
    String sqlStr = "SELECT * FROM  student";

    try{   //這里的異常處理語句是必需的.否則不能通過編譯!   
        Class.forName("org.gjt.mm.mysql.Driver");
        System.out.println( "類實例化成功!" );

        Connection con = DriverManager.getConnection(url, user, password);

        System.out.println( "創建連接對像成功!" );

        Statement st = con.createStatement();
        System.out.println( "創建Statement成功!" );     
       
       st.executeUpdate("insert into student values(30,'aa',26)");
        System.out.println( "插入成功!" );
        ResultSet rs = st.executeQuery( sqlStr );
        System.out.println( "讀取成功!" );
        //st.executeUpdate("delect from student where Sno=1");
       // System.out.println( "刪除成功!" );
        System.out.println( "----------------!" );
        
        rs = st.executeQuery( sqlStr );
      while(rs.next())
        {
          System.out.print(rs.getString("Sno") + "   ");
          System.out.print(rs.getString("name") + "   ");
          System.out.println(rs.getString("age") + "   ");
        }
        rs.close();
        st.close();
        con.close();
    }
    catch(Exception err){
        err.printStackTrace(System.out);
    }
  }
}