Rabu, 13 Oktober 2010

LITLE JAVASCRIPT

beberapa syntax javascript



### untuk menonaktifkan klik kanan mouse pada web page :
<script language=JavaScript>
<!--
//Disable right click script III- By Renigade (renigade@mediaone.net)
//For full source code, visit http://www.dynamicdrive.com

var message="";
///////////////////////////////////
function clickIE() {if (document.all) {(message);return false;}}
function clickNS(e) {if
(document.layers||(document.getElementById&&!document.all)) {
if (e.which==2||e.which==3) {(message);return false;}}}
if (document.layers)
{document.captureEvents(Event.MOUSEDOWN);document.onmousedown=clickNS;}
else{document.onmouseup=clickNS;document.oncontextmenu=clickIE;}

document.oncontextmenu=new Function("return false")
// -->
</script>



### untuk gwt get session page web
this.getThreadLocalRequest().getSession().setAttribute("somekey","somevalue");

SYNTAX JAVA PROGRAM

Untuk menetapkan/membuat session baru:
session.setAttribute("user",user); --> ... (nama variable yg jadi variabel session, nilai session)
session.setAttribute("password",password);

Untuk mengambil variabel session:
password = (String) session.getAttribute("password");  --> [nama variabel tampungan] = (type variabel) ...
user = (String) session.getAttribute("user");

Untuk langsung agar menuju page lain:
response.sendRedirect("/ipi/"); -->  ... ("nama alamat page")

Untuk penentuan kondisi dengan pembanding variabel String, contoh:
String var1 = null;
if(var1 == null) var1 = "a";
if(var1.equaltoignore("ADA")) out.println("huruf" + var1);
else if(var1.equaltoignore("A")) out.println("huruf" + var1)

Untuk mengambil passing variabel page:
String user=request.getParameter("user");
String password = request.getParameter("password");

Contoh untuk mengambil data field dari database:
String connectionURL = "jdbc:mysql://172.16.9.19:3306/ipi";
Connection connection = null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
try
  {
  connection = DriverManager.getConnection(connectionURL, "user", "password");
  Statement s3 = connection.createStatement();
  ResultSet hsl3 = s3.executeQuery(select * from packing where idpacking ='"+idpacking2+"');
    while (hsl3.next())
      {
      String vartamp1 = hsl3.getString("namafield");
      }
  }
catch(Exception e)
  {
    out.println("cannot acces syntax");
  }

Untuk mengambil nilai dari package yang dibuat sendiri:
import add_pr.beanpack;            --> penjelasan ... "nama package"."nama java class";
public class ...
  {
  beanpack hasil = new beanpack();    --> "java class" "var1"    = new "java class"();
  String outtext = hasil.getHasil();    --> ... = var1."nial variabel yg ada pada java class import"();
  out.println(outtext);
  }

SYNTAX MYSQL

Untuk mengubah field menjadi unique
---
alter table plan_dept add unique (workcenter)

Untuk menggabungkan dan mengambil field-field dari 2 tabel sekaligus:
---
select dhp.om, sampling.idqa
from sampling inner join dhp    --> penjelasan : from "tabel1" inner join "tabel2"
on sampling.iddhp = dhp.iddhp    --> penjelasan : on "tabel1.field" = "tabel2.field"

Update isi field tabel:
---
update masterkom set namakom ='', ip='', pemakai='', mutasi='M', ket='hapus' where idkom='l00001u'

Delete isi tabel:
---
delete from historikom where nama ='SUPPORT'

Menambah field tabel:
---
alter table masterkom add merek varchar(20)

Menghapus field tabel:
---
alter table masterkom DROP COLUMN merek;

Mengisi datetime:
---
now()

Mengisi time:
---
curtime()

Menambah tanda:
---
select LPAD('Roseindia.net',15,'#')as LPAD;
output : ##Roseindia.net

Mengganti table name
---
Alter table [name table] rename to [new table name];

Insert Data From another table
---
INSERT INTO database2.table1 (field1,field3,field9)
SELECT table2.field3,table2.field1,table2.field4
FROM table2;

Menbuat tabel baru:
create table ituser (nama varchar(15) not null, password varchar(15) not null, namalkp varchar(30), akses varchar(1) not null, program_aks varchar(20) not null, primary key (nama))