[IT] How to search on Google

Two days ago I became one of the speakers on “Indonesia Awan Pengetahuan” workshop with another 4 speakers ( Mr. Wawan, Mr. Syawal, Mr. Sumarli, and Mr. Sukisno). The purpose of the workshop is to educate teachers of all level about basic computer, internet, mind mapping, and office. And show them how to optimizing all the resources they’ve learned to build a strong and powerful subject for the students.

This article supposed to be delivered on the workshop, but because of several problems, this idea was slightly missing on the list. hahahahahaaaaa…… so I’ll post it here instead.

Basically, we can search on Google by type down our keywords. just any words. but it will make the range become too wide and less specific to what we want to. so here is the code or we can call it google cheat sheet to make search on google hit the point on what we want to find :

BASIC SEARCH OPERATOR

  1. AND ( + ) : To search over something that contains both/or more keywords that connected by this Operator :
    Example :
    waffle+recipe, waffle AND recipe

  2. Continue reading

[tutorial] Fungsi Terbilang Ms. Excel

Disamping formula – formula built-in yang memang sudah ada di excel, kita juga bisa membuat fungsi tambahan dengan menggunakan Macro. berikut ini adalah tutorial untuk merubah angka menjadi huruf terbilang dari angka yang di maksud. Untuk menggunakan fungsi terbilang ini terlebih dahulu anda download file macro (add-in) yang akan membantu kita menggunakan fungsi terbilang.

[Download add-in terbilang]

[Download Contoh file Kuitansi]

[Download tutorial Fungsi Terbilang (word)]

Untuk Microsoft Office Excel 2007 :

  1. Buka Excel Anda
  2. Klik Office Button (tombol yang bulat di pojok kiri atas ) pilih Excel Options
    Gambar 1

    Gambar 1

     

Continue reading

[programming] Insert data into database with JSP via JSTL

I have lots of talented and reliable students around me, and I’m proud of them.Proud to meet them and teach them. I’m sooooo proud of them, wish they’ll have such a bright future ahead of them. I love them so much you know….. šŸ˜€

And tribute to Riedo Andy Kurniawan who helped me to work things out. heeheheee… We finally able to insert data into the database. I’ve been try various ways to insert form data into the database, all of those various ways was come to their Dead end. I searched over dozens of internet article related with this JSP things and failed. it was frustrating, I never try this hard to do such things in PHP, it makes me love PHP even more…. hahahahaaa…..

so here is the code to insert form data into the database via JSTL.

<%@ page import=”java.io.*,java.util.*,java.sql.*”%>
<%@ page import=”javax.servlet.http.*,javax.servlet.*” %>
<%@ taglib uri=”http://java.sun.com/jsp/jstl/core&#8221; prefix=”c”%>
<%@ taglib uri=”http://java.sun.com/jsp/jstl/sql&#8221; prefix=”sql”%>
<!DOCTYPE html>
<html>
<head>
<sql:setDataSource var=”snap” driver=”com.mysql.jdbc.Driver”
url=”jdbc:mysql://localhost:3306/data” user=”root” password=””
/>
<title>JSP Page</title>
</head>
<body><form method=”post”>
<table width=”228″ border=”1″>
<tr>
<td width=”54″>ID</td>
<td width=”8″>:</td>
<td width=”148″><label for=”nis”></label>
<input type=”text” name=”id” id=”id” /></td>
</tr>
<tr>
<td>NAMA</td>
<td>:</td>
<td><label for=”nama”></label>
<input type=”text” name=”nama” id=”nama” /></td>
</tr>
<tr>
<td>KELAS</td>
<td>:</td>
<td><label for=”alamat”></label>
<input type=”text” name=”kelas” id=”kelas” /></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td><input type=”submit” name=”submit” id=”submit” value=”Submit” /></td>
</tr>
</table>
</form>

<c:if test=”${pageContext.request.method==’POST’}”>
<c:catch var=”exception”>
<sql:update dataSource=”${snap}” var=”updatedTable”>
INSERT INTO siswa VALUES (?,?,?)
<sql:param value=”${param.id}” />
<sql:param value=”${param.nama}” />
<sql:param value=”${param.kelas}” />
</sql:update>
<c:if test=”${updatedTable>=1}”>
<span style=”font-weight:bold; color:green;” >Congratulations ! Data inserted
successfully.</span>
</c:if>
</c:catch>
<c:if test=”${exception!=null}”>
<c:out value=”Unable to insert data in database.” />
</c:if>
</c:if>
</body>
</html>

[tutorial] Database Connection in JSP with JSTL

I wrote the post about how to connect JSP applications and your Database, and in this post I’ll write the post that has same purpose but in the different way. we’ll connect the database via JSTL.

The project in this tutorial was made in the same project before, I just make another page in the same project. Continue reading

[programming] Processing Form Data In JSP

I miss this blog so much, another work loads. some applications to make, teaching schedule, and family’s event. And in this post I’ll show you how to process your data from form you made.

Before read the following tutorial, you should have basic knowledge about HTML, and Basic JSP.(about what to do with your computer before start to code in JSP)

At some point it feels familiar, and it will get more like family now. so come on.

  1. Insert and view data
    To access data that has been inserted into form basically you just need request.getParameter(“variable_name”) for example :

    <input name=address id=address type=text /> //text box in HTML
    <%
    String addr; //declare variable addr as String
    addr = request.getParameter("address"); // assign the form variable address into variable addr
    out.println(addr); //print the value of variable addr
    %>

    the syntax above will take data that has been inserted into address text box and print it into your page. All data that inserted into form is in String form. so when you want to insert an integer value you need to convert the value unto integer. For example :

    <input name=frprice id=frprice type=text />
    <%
    int price = Integer.parseInt(request.getParameter("frprice")); //define price variable as integer and convert the value of form variable frprice from string into integer.
    int count;
    count = price - (price * 5%);
    out.println(count);
    %>

    syntax above will convert string data from form variable named frprice into Integer and assign it into variable named price. Integer.parseInt(variable_name) in charge of converting string variable into integer.

[tutorial] How to Insert a Youtube Video in your Blog Post

This is a tutorial request from my student in Vocational high school, how to insert a video in your Blog Post. It’s suppppper easy you know, you don’t need to sweat yourself. It doesn’t even take 5 minutes (depending on your internet connection theheeeeeee.

So here you go,

  1. Step, Open your Post in a text mode ( I gave you an example of my post titled ‘[quilling paper] Flower‘)

    Open the Post

    Open the Post

Continue reading

[tutorial] Database Connection in JSP

have I told you that I am both a Programming teacher in Vocational High School and Lecturer in one of college in town. So, now in vocational high school we are in the second semester this year and based on the teaching subject that shared among the teachers, I -again- assigned to teach Java Server Page. I am a Web-Based-Application freak and I love web Programming. Web Programming allow me make the Program and designed the page at the same time. but I am more like a PHP Girl rather than a Java Woman, and I don’t want to cheat him… I don’t know, it isn’t like I hate Java, I just not so get along with him…. sorry Mr. Java.

But if the boss said that I have to teach it, so be it. When the First semester of the third class was learn about the basic of JSP, now this semester I will connect their application with the Database.

Application you might need : Continue reading