[+/-] : How to access a database by ADO with JavaScript

I have not found any sample that shows database access with javaScript. Well, I created one. It is very simple since Javascript has the activeXObject that allow us to call an external object in the same way that vbscript uses CreateObject.

//**************************************
// Name: ADO With JavaScript
// Description:I have not found any sample that shows database access with javaScript. Well, I created one.
// It is very simple since Javascript has the activeXObject that allow us to call an external object
// in the same way that vbscript uses CreateObject.
// By: Marcio Coelho
//
//Assumes:You need SQL Server, a valid login, and know the name of a table and at least one column to test the sample.
//
//Side Effects:None
//This code is copyrighted and has limited warranties.
//Please see http://www.Planet-Source-Code.com/xq/ASP/txtCodeId.2804/lngWId.2/qx/vb/scripts/ShowCode.htm
//for details.
//**************************************

<SCRIPT LANGUAGE=javascript>
 var conn = new ActiveXObject("ADODB.Connection") ;
 var connectionstring = "Provider=sqloledb; Data Source=itdev; Initial Catalog=pubs; User ID=sa;Password=yourpassword"
 conn.Open(connectionstring)
 var rs = new ActiveXObject("ADODB.Recordset")
 rs.Open("SELECT gif, description, page, location FROM menu1", conn)
// Be aware that I am selecting from this table, but you need to pick your own table
 while(!rs.eof)
  {
    alert(rs(0));
    rs.movenext
  }
   
   rs.close
  conn.close 
</SCRIPT>

...
Read more

[+/-] : Encrypts a string by the given "key"

A more slightly advanced encryption.Encrypts a string by the given "key".

import javax.swing.JOptionPane;


public class betterencryptor {

 public static void main(String[] args) {
  int key1 = Integer.parseInt(JOptionPane.showInputDialog("Input a key, a random large *prime* number:"));
  String message1 = JOptionPane.showInputDialog("Input a string to be encrypted/decrypted:");
  String crypt1 = cryptor(message1,key1);
  String decrypt1 = cryptor(crypt1,key1);
  System.out.println(crypt1);
  System.out.println(decrypt1);
 }


 public static String cryptor(String crypt,int key){
  byte[] string = crypt.getBytes();


  for(int k = 0;k < crypt.length();k++){
   string[k] = new Integer(string[k]^key%256).byteValue();
  }
  return (new String(string));
 }
}

...
Read more