update query in mysql

update tablename set fieldname=value where condition
for example if i have a table h with field m to update the query will be
update h set m='newvalue'(if its integer no single quates doesn't needed)

Comments

Disabling DEP(data Excecution prevention) for third party softwares in windows

1.go to system properties. 2.go to Advanced system settings . 3. go to Advance tab ,performance settings,Data execution prevention tab make sure u have selected 1st option as highlighted in screenshot.after making changes you must restart system

java function to write into sql database from java

public static void runsql(String Q) { try { // create a mysql database connection String myUrl = "jdbc:mysql://localhost:3306/firewall?zeroDateTimeBehavior=convertToNull"; Class.forName("com.mysql.jdbc.Driver"); Connection conn = DriverManager.getConnection(myUrl,"root", "password"); if (conn != null) { System.out.println("Connected"); } Statement st = conn.createStatement(); st.executeUpdate(Q); conn.close(); } catch (Exception e) { System.err.println("Got an exception!"); System.err.println(e.getMessage()); } }

Encryption and Decryption functions for Java

public static String encrypt(String key, String initVector, String value) { try { IvParameterSpec iv = new IvParameterSpec(initVector.getBytes("UTF-8")); SecretKeySpec skeySpec = new SecretKeySpec(key.getBytes("UTF-8"), "AES"); Cipher cipher = Cipher.getInstance("AES/CBC/PKCS5PADDING"); cipher.init(Cipher.ENCRYPT_MODE, skeySpec, iv); byte[] encrypted = cipher.doFinal(value.getBytes()); System.out.println("encrypted string: " + Base64.encodeBase64String(encrypted)); return Base64.encodeBase64String(encrypted); } catch (Exception ex) { ...

CODING EXPERT

Search This Blog