George2 at 08:53, 25 May 2015

2015-05-25T08:53:23Z

George2 at 11:44, 23 September 2014

2014-09-23T11:44:16Z

George2 at 11:44, 23 September 2014

2014-09-23T11:44:02Z

George2 at 12:17, 17 September 2014

2014-09-17T12:17:11Z

George2: Created page with " import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import java.io.; import java.sql.; import java.util.*; import jav..."

2014-09-17T12:16:43Z

Created page with "<source lang="java"> import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import java.io.*; import java.sql.*; import java.util.*; import jav..."

New page

<source lang="java">

import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.io.*;
import java.sql.*;
import java.util.*;
import java.math.*;

public class App {
String url = "jdbc:mysql://argus.gold.ac.uk:3306/";
String dbName = "<db_name>";
String driver = "com.mysql.jdbc.Driver";
String userName = "<username>";
String password = "<password>";
Connection conn;
Statement st;
int n = 0;
String distinguished;
Hashtable ht;

App.Translate tr;
App.Mysql my ;
App.DateConvert dc;
App.MakeHash ha;
String header;

private static void copy(InputStream in, OutputStream out) throws IOException {
while (true) {
int c = in.read();
if (c == -1) {
break;
}
out.write((char) c);
}
}

void runnit() throws IOException, InterruptedException
{
tr = this.new Translate();
my = this.new Mysql();
dc = this.new DateConvert();
ha = this.new MakeHash();
ht = ha.makeIt();

ProcessBuilder processBuilder = new ProcessBuilder("c:\\my1.bat");
processBuilder.redirectErrorStream(true);

Process process = processBuilder.start();
copy(process.getInputStream(), System.out);
process.waitFor();
System.out.println("Exit Status : " + process.exitValue());

}

public static void main(String[] args) throws IOException,InterruptedException
{
App ap = new App();
ap.runnit();

App.FileStreamsTest fs = ap.new FileStreamsTest();
fs.reado();

}

class Translate
{
String trans(String s)
{
String in;
int FLAG=1;
String out="";
String outTemp, outTemp2;
in = s;
// outTemp2 = s.replace("'","_");
// outTemp = outTemp2.replace(",","','");

// out = "'" + outTemp + "'";

for (int index = 0; index < in.length();
index++) {
char aChar = in.charAt(index);

if ( FLAG == 1 && aChar == '"') { FLAG=0; outTemp=out+"\"";out=outTemp; }
else if ( FLAG == 0 && aChar == '"') {FLAG=1; outTemp=out+aChar; out = outTemp;}
else if ( FLAG ==1 && aChar == ',' ) { outTemp = out+"','" ; out = outTemp ;}
else if ( aChar =='\'' ) { outTemp=out+"\\'";out = outTemp;}
else { outTemp=out+aChar;out = outTemp;}

}
outTemp = "'"+out+"'";
out=outTemp;

return out;

}

}

class FileStreamsTest {
void reado(){
try {
File inputFile = new File("c:\\output.csv");

FileInputStream fis = new FileInputStream(inputFile);
BufferedReader br = new BufferedReader(new InputStreamReader(fis));

String strLine;

header = br.readLine();
System.out.println(header);

my.connect();
try{
st = conn.createStatement();

while((strLine = br.readLine())!= null )
{
String delimo = strLine;
delimo = delimo.replaceAll("'","_");
String[] tokeno = delimo.split("\",");
distinguished = tokeno[0]+'"';
System.out.println("The distinguiahed name is "+distinguished);

System.out.println("REPLACE into ad_fields ("+header+") VALUES("+tr.trans(strLine)+")");
System.out.println("==============================");
System.out.println("length of line is "+strLine.length()+ "n is "+ n);
n++;
st.executeUpdate("REPLACE into adfields ("+header+") VALUES("+tr.trans(strLine)+")");
System.out.println("Insert has been completed");
System.out.println("SELECT lastlogon FROM adfields where DN='"+distinguished+"'");
ResultSet res = st.executeQuery("SELECT lastlogon FROM adfields where DN='"+distinguished+"'");
if ( res.next() )
{
String LAST=res.getString("lastlogon");
System.out.println("lastlogoin is "+LAST);
if (LAST.length() > 6 )
{
String lastlog = dc.con(LAST);
System.out.println(lastlog);
st.executeUpdate("update adfields set lastlogon_date='"+lastlog+"' where DN='"+distinguished+"'" );
}

}
System.out.println("SELECT pwdLastSet FROM adfields where DN='"+distinguished+"'");
ResultSet ress = st.executeQuery("SELECT pwdLastSet FROM adfields where DN='"+distinguished+"'");
if ( ress.next() )
{
String LASTT=ress.getString("pwdLastSet");
System.out.println("pwdLastSet is "+LASTT);
if (LASTT.length() > 6 )
{
String lastpw = dc.con(LASTT);
System.out.println(lastpw);
st.executeUpdate("update adfields set pwdLastSet_date='"+lastpw+"' where DN='"+distinguished+"'" );
}

}
// Now for the hashtable

System.out.println("SELECT userAccountControl FROM adfields where DN='"+distinguished+"'");
ResultSet resss = st.executeQuery("SELECT userAccountControl FROM adfields where DN='"+distinguished+"'");
if ( resss.next() )
{
String LASTTT=resss.getString("userAccountControl");
System.out.println("userAccountControl is "+LASTTT);
if (LASTTT.length() > 2 )
{
String userAccountControl = (String)ht.get(LASTTT);
System.out.println(userAccountControl);
st.executeUpdate("update adfields set userAccountControl_interpreted='"+userAccountControl+"' where DN='"+distinguished+"'" );
}

}
st.executeUpdate("update adfields set updated=now() where DN='"+distinguished+"'" );

}

System.out.println("TEsting user account control for 512 "+(String)ht.get("512"));
//System.out.println("TEsting user account control for 514 "+(String)ht.get("514"));
// System.out.println("TEsting user account control for 66048 "+(String)ht.get("66048"));
// System.out.println("TEsting user account control for 66050 "+(String)ht.get("66050"));

// }
}
catch (SQLException ee) {
ee.printStackTrace();
}

//my.connect();

my.disconnect();
fis.close();

} catch (FileNotFoundException e) {
System.err.println("FileStreamsTest: " + e);
} catch (IOException e) {
System.err.println("FileStreamsTest: " + e);
}
}
}

class Mysql
{
void connect()
{
try {
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url+dbName,userName,password);
System.out.println("Successful connection to mysql on argus.gold.ac.uk");

} catch (Exception e) {
e.printStackTrace();

}

}

void disconnect()
{
try{
conn.close();
System.out.println("Database successfully closed");
}
catch (Exception e) {
e.printStackTrace();
}
}

}

public class DateConvert
{

String con(String s)
{

final String secondsInHourStr = (60 * 60) + "";

//Convert the huge number to hours
BigInteger big = new BigInteger(s);
//Note, I got the spitByValue after trial/error testing, hope its correct
String splitByValue = "10000000";
BigInteger secondsBig = big.divide(new BigInteger(splitByValue));

BigInteger hoursBig = secondsBig.divide(new BigInteger(secondsInHourStr));

//Get the remaining seconds
BigInteger modSeconds = secondsBig.mod(new BigInteger(secondsInHourStr));
//Create a Calender object representing 1601-01-01 00:00:01
Calendar cal = Calendar.getInstance();
cal.set(Calendar.YEAR, 1601);
cal.set(Calendar.MONTH, 0);
cal.set(Calendar.DATE, 1);
cal.set(Calendar.HOUR, -12);
cal.set(Calendar.MINUTE, 0);
cal.set(Calendar.SECOND, 1);

//Add the hours
cal.add(Calendar.HOUR, hoursBig.intValue());

//Add seconds
cal.add(Calendar.SECOND, modSeconds.intValue());

//Here is your Java object
java.util.Date date = cal.getTime();
// System.out.println(date);
return date.toString();

}

}

class MakeHash
{
Hashtable myHash;

MakeHash()
{
myHash = new Hashtable(29);

myHash.put("514","ACCOUNTDISABLE");
myHash.put("528","Enabled - LOCKOUT");
myHash.put("530","ACCOUNTDISABLE - LOCKOUT");
myHash.put("544","Enabled - PASSWD_NOTREQD");
myHash.put("546","ACCOUNTDISABLE - PASSWD_NOTREQD");
myHash.put("560","Enabled - PASSWD_NOTREQD - LOCKOUT");
myHash.put("640","Enabled - ENCRYPTED_TEXT_PWD_ALLOWED");
myHash.put("2048","INTERDOMAIN_TRUST_ACCOUNT");
myHash.put("2080","INTERDOMAIN_TRUST_ACCOUNT - PASSWD_NOTREQD");
myHash.put("4096","WORKSTATION_TRUST_ACCOUNT");
myHash.put("8192","SERVER_TRUST_ACCOUNT");
myHash.put("66048","Enabled - DONT_EXPIRE_PASSWORD");
myHash.put("66050","ACCOUNTDISABLE - DONT_EXPIRE_PASSWORD");
myHash.put("66064","Enabled - DONT_EXPIRE_PASSWORD - LOCKOUT");
myHash.put("66066","ACCOUNTDISABLE - DONT_EXPIRE_PASSWORD - LOCKOUT");
myHash.put("66080","Enabled - DONT_EXPIRE_PASSWORD - PASSWD_NOTREQD");
myHash.put("66082","ACCOUNTDISABLE - DONT_EXPIRE_PASSWORD - PASSWD_NOTREQD");
myHash.put("66176","Enabled - DONT_EXPIRE_PASSWORD - ENCRYPTED_TEXT_PWD_ALLOWED");
myHash.put("131584","Enabled - MNS_LOGON_ACCOUNT");
myHash.put("131586","ACCOUNTDISABLE - MNS_LOGON_ACCOUNT");
myHash.put("131600","Enabled - MNS_LOGON_ACCOUNT - LOCKOUT");
myHash.put("197120","Enabled - MNS_LOGON_ACCOUNT - DONT_EXPIRE_PASSWORD");
myHash.put("532480","SERVER_TRUST_ACCOUNT - TRUSTED_FOR_DELEGATION (Domain Controller)");
myHash.put("1049088","Enabled - NOT_DELEGATED");
myHash.put("1049090","ACCOUNTDISABLE - NOT_DELEGATED");
myHash.put("2097664","Enabled - USE_DES_KEY_ONLY");
myHash.put("2687488","Enabled - DONT_EXPIRE_PASSWORD - TRUSTED_FOR_DELEGATION - USE_DES_KEY_ONLY");
myHash.put("4194816","Enabled - DONT_REQ_PREAUTH");
myHash.put("512","Enabled");

}

Hashtable makeIt()
{
return myHash;
}

}

}

</source>

@@ Line 248: / Line 248: @@
            Class.forName(driver).newInstance();
            conn = DriverManager.getConnection(url+dbName,userName,password);
-           System.out.println("Successful connection to mysql on argus.gold.ac.uk");
+           System.out.println("Successful connection to mysql on argus.goldilocks.ac.uk");
            } catch (Exception e) {

@@ Line 11: / Line 11: @@
 public class App {
-	      String url = "jdbc:mysql://<db_Server>:3306/";  /// Mysql connection
+	  String url = "jdbc:mysql://<db_Server>:3306/";  /// Mysql connection
            String dbName = "<db_name>";
            String driver = "com.mysql.jdbc.Driver";

App.java - Revision history

George2 at 08:53, 25 May 2015

George2 at 11:44, 23 September 2014

George2 at 11:44, 23 September 2014

George2 at 12:17, 17 September 2014

George2: Created page with " import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import java.io.*; import java.sql.*; import java.util.*; import jav..."

George2: Created page with " import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import java.io.; import java.sql.; import java.util.*; import jav..."