u can use MD5 secrity protocol
Posted By:
Anonymous
Posted On:
Thursday, October 9, 2003 11:19 PM
this is the sample program which i have used
import java.security.*;
import java.sql.*;
import java.net.*;
public class CreateParticipant {
public static void main (String [] args ){
MessageDigest md = null;
try{
md = MessageDigest.getInstance("MD5");
}catch(Exception e){}
String strLoginName = args[0];
String strPassword = args[1];
String strEncryptedPassword ="";
String strEncryptedPassword_computed ="";
String strURLEncodedEncryptedPassword ="";
byte [] abytPassword = null;
byte [] abytEncrptedPassword = null;
abytPassword = strPassword.getBytes();
abytEncrptedPassword = md.digest(abytPassword);
strEncryptedPassword_computed = new String(abytEncrptedPassword);
strURLEncodedEncryptedPassword = URLEncoder.encode(strEncryptedPassword_computed);
System.out.println("Password --" +strPassword);
System.out.println("Encrypted Password --" +strEncryptedPassword_computed);
System.out.println("Encrypted Password Length --" +strEncryptedPassword.length());
System.out.println("URL encoded Encrypted Password computed --" +strURLEncodedEncryptedPassword);
createParticipant(strLoginName , strURLEncodedEncryptedPassword);
}
public static void createParticipant(String strLoginName ,String strURLEncodedEncryptedPassword){
try {
String strDriver = "org.postgresql.Driver";
Class.forName(strDriver);
String strURL = "jdbc:postgresql://172.16.100.4:5432/general_user";
Connection conn = DriverManager.getConnection(strURL, "postgres" , "postgres");
StringBuffer stbQuery = new StringBuffer();
stbQuery.append("insert into participant ( login_name , password )values (? ,?)");
String strQuery = stbQuery.toString();
PreparedStatement pstmt = conn.prepareStatement(strQuery);
pstmt.setString(1,strLoginName.replaceAll("'","''"));
pstmt.setString(2,strURLEncodedEncryptedPassword);
System.out.println(strQuery);
pstmt.executeUpdate();
}catch (Exception e){System.out.println(e);}
}
}