Arpit Panwar

package Encryption; import java.io.*; import java.security.*; import java.util.logging.Level; import java.util.logging.Logger; import javax.crypto.Cipher.*; import javax.crypto.*; import javax.crypto.spec.*; import sun.misc.BASE64Decoder; import sun.misc.BASE64Encoder; public class EncMain { private Cipher cipher = null; private SecretKeySpec skeySpec; // private String message = "asgfd"; private IvParameterSpec iv; private byte[] rawBytes = {66, -56, -63, -97, -23, -9, 27, -3, 63, -115, 85, 81, -31, 127, -48, -92}; private String Username = ""; private String key = ""; private String encrypted = ""; private String decrypted = ""; public EncMain() { Username = "arpitpanwar";//new UserBean.UserData().getUser(); try { skeySpec = new GenKey().Gen(Username); } catch (Exception e) { e.printStackTrace(); } } // public static void main(String[] args) throws Exception { public String getKey() throws Exception { byte[] gky = skeySpec.getEncoded(); BASE64Encoder ecode = new BASE64Encoder(); key = ecode.encodeBuffer(gky); // key=ecode.encode(gky); return key; } public String doEncrypt(String message) { EncMain m = new EncMain(); iv = new IvParameterSpec(rawBytes); //yaha par padding ho rahi hai String ec = Pad(message); byte[] btt = ec.getBytes(); encrypted = m.encrypt(btt); return encrypted; } public String doDecrypt(String enc, int len, String key) { String s1=Pad(enc); String dec = new EncMain().decrpyt(s1, key); //remove padding //String decrypted=UnPad(dec,len); return dec; } //encryption ho gaya // System.out.println("Encrypted string-:" + e); //decryption ho gaya // System.out.println("Decrypted string-:" +fi); // } private String encrypt(byte[] encrypted) { try { //instantiate the cipher cipher = Cipher.getInstance("AES/CBC/PKCS5Padding"); cipher.init(Cipher.ENCRYPT_MODE, skeySpec, iv); byte[] encrypt = cipher.doFinal(encrypted); return new String(encrypt); } catch (Exception ex) { return "their is an error"; } } private String decrpyt(String encrypted, String Key) { try { cipher = Cipher.getInstance("AES/CBC/PKCS5Padding"); iv = new IvParameterSpec(rawBytes); String retrivedbkey = Key;//from database BASE64Decoder dcode = new BASE64Decoder(); byte[] dkey = dcode.decodeBuffer(retrivedbkey); SecretKeySpec skeySpec1 = new SecretKeySpec(dkey,"AES"); cipher.init(Cipher.DECRYPT_MODE, skeySpec1, iv); byte[] original = cipher.doFinal(encrypted.getBytes()); String ostring = new String(original); return ostring; } catch (Exception ex) { ex.printStackTrace(); System.out.println(ex.getMessage()); return "Their is an IllegleBlockSizeException "; } } private static String Pad(String src) { // StringBuffer ms = null; StringBuffer s = new StringBuffer(src); int len = src.length(); int padlen1 = len % 16; int padlen = 16 - padlen1; if (padlen != 16) { for (int i = 0; i < padlen; i++) { s.append("5"); } } return s.toString(); } private static String UnPad(String src, int ht) { StringBuffer ms = null; StringBuffer s = new StringBuffer(src); String de = s.toString(); String re = de.substring(0, ht); return re.toString(); } } MY MAIN CLASS CODE IS : /* * To change this template, choose Tools | Templates * and open the template in the editor. */ package Encryption; /** * * @author Administrator */ public class test { public static void main(String[] args)throws Exception{ EncMain e = new EncMain(); String key = e.getKey(); //System.out.println(new String("This is amessage").length()); String encrypted = e.doEncrypt("Thisamessage"); System.out.println(key); // System.out.println(encrypted.getBytes().length); System.out.println("Excrypted:- "+encrypted); String decrypt = e.doDecrypt(encrypted, 16,key); System.out.println("Decrypted:- "+decrypt); } }

package Encryption; import java.io.*; import java.security.*; import java.util.logging.Level; import java.util.logging.Logger; import javax.crypto.Cipher.*; import javax.crypto.*; import javax.crypto.spec.*; import sun.security.pkcs.PKCS10; interface AESAlgorithm { public String encrypt(byte[] encrypted); public String decrpyt(byte[] encrypted); } public class EncMain implements AESAlgorithm { HexPass h=new HexPass(); GenKey g=new GenKey(); Cipher cipher; SecretKeySpec skeySpec1 = null; static String message = "qwsderfgvcbnhjmk"; public static void main(String[] args){ EncMain m = new EncMain(); byte[] btt = message.getBytes(); System.out.println("Encryptd string:" + m.encrypt(btt)); System.out.println("Decryptd string:" + m.decrpyt(btt)); } public String encrypt(byte[] encrypted) { try { cipher = Cipher.getInstance("AES/CBC/PKCS8Padding"); skeySpec1=g.Gen(); byte[] rawBytes = {16, 32, 64, 32, 48, 80, 96, 112, 96, 32, 48, 80, 96, 112, 64,16}; IvParameterSpec iv = new IvParameterSpec(rawBytes); cipher.init(Cipher.ENCRYPT_MODE, skeySpec1, iv); byte[] encrypt = cipher.doFinal(encrypted); return h.asHex(encrypt); } catch (Exception ex) { return "their is an error"; } } public String decrpyt(byte[] encrypted) { String ostring = null; try { //SecretKeySpec skeySpec = null; skeySpec1 =g.Gen(); byte[] rawBytes = {16, 32, 64, 32, 48, 80, 96, 112, 96, 32, 48, 80, 96, 112, 64,16}; IvParameterSpec iv = new IvParameterSpec(rawBytes); System.out.println(iv); cipher.init(Cipher.DECRYPT_MODE, skeySpec1, iv); byte[] original = cipher.doFinal(encrypted); ostring = new String(original); return ostring; } catch (IllegalBlockSizeException ex) { ex.printStackTrace(); return "error1"; } catch (Exception e) { e.printStackTrace(); return "errro2"; } } }
i keep getting badpading exception.
can anyone help me out on how to pad the message bits.

Can you specify what are the Exceptions you get...and how are you trying to install the Driver

wei liu wrote:

Arpit Panwar wrote:Make sure you change the Storage engine of your table to InnoDB
I think the default engine MyISAM doesnt support Transactions
Try it and let me know

Thanks Arpit, It works after change the engine from MyISAM to InnoDB.

Thanks for your help.

Pleased to help

André Asantos wrote:When I am using Sybase the query "select * from DatabaseCars.. TableKindOfCar " works differently when I use Mysql because the same query does not work... got it?

Can you post the error you get

Thanks
It Really Helped

Jan Cumps wrote:

Arpit Panwar wrote:Yup ResultSet returns no rows

ResultSet.getFetchSize() returns 0 i.e. no rows are being fetched

This method might not do what you expect that it does:
https://coderanch.com/t/299924/JDBC/java/workings-ResultSet-getFetchSize

Ok Thanks
Il try it out right away

I tried it without closing the connection the result is the same....
Still i keep Getting 0 rows
has is something to do with my Connection
public Connection getConnection(){ try{ Class.forName(driver).newInstance(); con = DriverManager.getConnection(url+database, username, password); System.out.println(con.getClientInfo()); }catch(ClassNotFoundException cnfe){ System.out.println("Class Not Found"); cnfe.printStackTrace(); }catch(InstantiationException ie){ System.out.println("Cannot Instantiate"); ie.printStackTrace(); }catch(IllegalAccessException ilae){ System.out.println("Illegal Access to the Database"); ilae.printStackTrace(); } catch(SQLException se){ System.out.println("Sql Exception"); se.printStackTrace(); } return con; }

Yup ResultSet returns no rows

ResultSet.getFetchSize() returns 0 i.e. no rows are being fetched

And should closing the Connection have anything to do with ResultSet object???

Make sure you change the Storage engine of your table to InnoDB
I think the default engine MyISAM doesnt support Transactions
Try it and let me know

public ResultSet selectQuery(String query){ try{ Statement st = conct.createStatement(); rs= st.executeQuery(query); st.executeUpdate("COMMIT"); new Connect().closeConnection(conct); }catch(SQLException se){ se.printStackTrace(); } return(rs); }

where ResultSet is defined in class as private ResultSet rs=null;

conct is a valid connection object
and query is also valid and the table also has rows in it...still resultset keeps fetching null....Can anyone help..

loop:for(int j=0;j<=length;j--){ if(((length+1+j)<=(int)(Math.pow(2, j)))){ checkBits=j; break loop; } }

Could anyone please point out the error in the code

for length =5
it gives checkbits= -6