CREATE TABLE table_name(
column_name1 data_type(size),
column_name2 data_type(size),
column_name3 data_type(size));CREATE TABLE Student(
student_id int,
student_name varchar(255));CREATE TABLE test_table (
test_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
test_desc TEXT
); CREATE TABLE test_table (
test_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
test_desc TEXT
PRIMARY KEY ('test_id')
); UNSIGNED to tell the data type is UNSIGNED and using keyword PRIMARY KEY (fieldname) to tell this field is primary key package com.en.interceptor;
import org.springframework.web.servlet.handler.HandlerInterceptorAdapter;
import com.en.model.MasterModel;
public class MasterInterceptor extends HandlerInterceptorAdapter{
private String errorURL;
private MasterModel model;
public String getErrorURL() {
return errorURL;
}
public void setErrorURL(String errorURL) {
this.errorURL = errorURL;
}
public MasterModel getModel() {
return model;
}
public void setModel(MasterModel model) {
this.model = model;
}
}
package com.en.interceptor;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.log4j.Logger;
public class ExampleInterceptor extends MasterInterceptor{
private static Logger logger = Logger.getLogger(ExampleInterceptor.class);
public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
//request.getRequestDispatcher(errorURL).forward(request, response);
//return false;
logger.info("Interceptor running");
return true;
}
}
<bean id="urlMapping" class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping">
<property name="interceptors">
<list>
<ref local="exampleInterceptor"/>
</list>
</property>
<property name="mappings">
<props>
<prop key="/example_insert.html">exampleController</prop>
<prop key="/example_load.html">exampleController</prop>
<prop key="/example_delete.html">exampleController</prop>
<prop key="/example_ws.html">exampleController</prop>
<prop key="/example_sap.html">exampleController</prop>
</props>
</property>
</bean>
<bean id="welcomeController" class="com.spring.controller.WelcomeController">
<property name="methodNameResolver" ref="welcomeControllerResolver"/>
</bean>
<bean id="welcomeControllerResolver"
class="org.springframework.web.servlet.mvc.multiaction.PropertiesMethodNameResolver">
<property name="mappings">
<props>
<prop key="/welcome1.cdr">loadWelcome1</prop>
<prop key="/welcome2.cdr">loadWelcome2</prop>
</props>
</property>
</bean>
<bean id="urlMapping" class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping">
<property name="mappings">
<props>
<prop key="/welcome1.cdr">welcomeController</prop>
<prop key="/welcome2.cdr">welcomeController</prop>
</props>
</property>
</bean>
$html_page="<a href='test.php'>This is my page </a>";
$txt.=strip_tags($html_page);
$description.=" ".strip_tags(trim($html_page))." ".$main_term;
$description = ereg_replace( "\n", " ", $description);
$description = ereg_replace( "\r", " ", $description);
$description = ereg_replace( " ", " ", $description);
$description = ereg_replace( " ", " ", $description);
$description = ereg_replace( " ", " ", $description);
$description = ereg_replace( " ", " ", $description);
//Connect database
$username="root";
$password="root";
$database="testdb";
mysql_connect("localhost",$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
//SQL Query command
$query="select * from my_table where p_type='Y' order by last_view desc limit 0,10";
$result=mysql_query($query);
$x_num=mysql_numrows($result);
$x_i=0;
while ($x_i < $x_num) {
$code=mysql_result($result,$x_i,"code_id");
$title=mysql_result($result,$x_i,"title");
echo "<BR>".$code." : ".$title;
}
//SQL Insert / Update Command by using only mysql_query();
$query = "insert into test_comment (flash_id,content,post_by,create_date,last_update,ip) ";
$query.="values('$flash_id','$content2','$post_by','$_date','$_date','$ip')";
mysql_query($query);
$query = "update test_table set stat=$new_stat,last_view='$last_view' where code_id=$code_id";
mysql_query($query);
$username="dbuser";
$password="dbpassword";
$database="mydatabase";
mysql_connect("localhost",$username,$password);
//select database if fail print error
@mysql_select_db($database) or die( "Unable to select database");$query="select * from test_comment where flash_id='$code_id' order by comment_id desc";
$result=mysql_query($query);
$num=mysql_numrows($result);
$i=0;while ($i < $num) {
$content =mysql_result($result,$i,"content");
echo "
".$content;
}$query = "insert into test_comment (flash_id,content,post_by,create_date,last_update,ip) ";
$query.="values('$flash_id','$content2','$post_by','$_date','$_date','$ip')";
mysql_query($query);$query = "delete from test_comment ";
mysql_query($query);$query = "update test_comment set title='test' where code_id='1001'";
mysql_query($query);
response.addHeader("Content-disposition","attachment; filename=attes.doc");
response.addHeader("Content-Type","application/vnd.ms-word; charset=utf-8");
Date date=new Date();
System.out.println("No format :"+date);
java.text.SimpleDateFormat df= new java.text.SimpleDateFormat();
System.out.println("No pattern format :"+df.format(date));
df.applyPattern("dd/mm/yyyy");
System.out.println("dd/mm/yyyy format :"+df.format(date));
df.applyPattern("dd/mm/yyyy HH:mm:ss");
System.out.println("dd/mm/yyyy HH:mm:ss format :"+df.format(date));
package example.util;
import java.util.ArrayList;
import java.util.HashSet;
import java.util.Iterator;
import java.util.Vector;
public class ArrayListExample {
public void arrayListExample(){
//Create ArrayList Object
ArrayList arrayList=new ArrayList();
//Store data to ArrayList
arrayList.add("value1");
arrayList.add("value2");
arrayList.add("value3");
arrayList.add("value4");
arrayList.add("value5");
//Test Print all data with toString()
System.out.println("ArrayList Data befor "+arrayList);
//Remove data from ArrayList
String removeValue=arrayList.remove(2);
boolean remove1=arrayList.remove("value1");
boolean remove2=arrayList.remove("value3");
Vector v=new Vector();
v.add("value2");
boolean remove3=arrayList.removeAll(v);
//Removed data can return in VAL
System.out.println("Remove Value "+removeValue);
System.out.println("Remove1 "+remove1);
System.out.println("Remove2 "+remove2);
System.out.println("Remove3 "+remove3);
System.out.println("ArrayList Data after "+arrayList);
//Ged data from ArrayList
System.out.println("-- Example for Get Value from ArrayList --");
System.out.println("Get ArrayList value: "+arrayList.get(0));
System.out.println("Contains ArrayList: "+arrayList.contains("value1"));
System.out.println("Contains ArrayList: "+arrayList.contains("value3"));
//Loop data from Array List
System.out.println("-- Example for Iterate list from ArrayList --");
Iterator it=arrayList.iterator();
while(it.hasNext()){
String value=it.next();
System.out.println("List Iterated Value: "+value);
}
System.out.println("-- Example for Loop from ArrayList --");
for (String temp:arrayList){
System.out.println("For value ArrayList "+temp);
}
}
public static void main (String args[]){
//Test the code in main method
ArrayListExample arryList=new ArrayListExample();
arryList.arrayListExample();
}
}
//Create Instance for HashSet of String
HashSet hashSet=new HashSet();
//Add data to HashSet ...the same way for list
hashSet.add("aa");
hashSet.add("bb");
hashSet.add("ab");
//Check contain data in HashSet
System.out.println("HashSet contails "+hashSet.contains("aa"));
System.out.println("HashSet contails "+hashSet.contains("cc"));
//Loop data in hash Set
Iterator it=hashSet.iterator();
while(it.hasNext()){
System.out.println("HashSet Next Data "+it.next());
}
//Create instance for TreeSet of String
TreeSet treeSet=new TreeSet();
//Store data to TreeSet with mix order
treeSet.add("aa1");
treeSet.add("aa2");
treeSet.add("aa3");
treeSet.add("bb1");
treeSet.add("bb2");
//Test containing data .. the same function for Other Collection
System.out.println("TreeSet contails "+treeSet.contains("aa1"));
System.out.println("TreeSet contails "+treeSet.contains("bb1"));
//Loop data from TreeSet
Iterator it=treeSet.iterator();
while(it.hasNext()){
System.out.println("TreeSet Next Data "+it.next());
}
//Create instance for StringBuffer
StringBuffer stringbuffer =new StringBuffer();
//Append String to StringBuffer
stringbuffer.append("str1");
stringbuffer.append("str2");
stringbuffer.append("str3");
/*
..
.. You can append a lot of data you want
..
*/
//Transform it to String
String data=stringbuffer.toString();
System.out.println("StringBuffer data :"+data);
package example.util;
import java.util.*;
public class HashmapExample {
public void hashmapExample(){
//Create HashMap Object
HashMap<String,String> hashmap=new HashMap<String,String>();
//Store and Remove data from HashMap
hashmap.put("key1", "value1");
hashmap.put("key2", "value2");
hashmap.put("key3", "value3");
String key3=hashmap.remove("key3");
//Get Value from HashMap by using Key
System.out.println("-- Example for Get Value from HashMap --");
System.out.println("Get Hashmap value: "+hashmap.get("key1"));
System.out.println("Remove Hashmap value: "+key3);
System.out.println("Contains Key Hashmap: "+hashmap.containsKey("key1"));
System.out.println("Contains Key Hashmap: "+hashmap.containsKey("key3"));
System.out.println("Contains Value Hashmap: "+hashmap.containsValue("value1"));
System.out.println("Contains Value Hashmap: "+hashmap.containsValue("value3"));
//Loop data from HashMap by keySet and using key to get the Value
System.out.println("-- Example for Iterate list from Hash Map --");
Iterator<String> it=hashmap.keySet().iterator();
while(it.hasNext()){
String key=it.next();
String value=hashmap.get(key);
System.out.println("By Key :Key : "+key+" Value: "+value);
}
//Loop data from HashMap by Value List all value no need to using Key
it=hashmap.values().iterator();
while(it.hasNext()){
System.out.println("Value "+it.next());
}
}
public static void main (String args[]){
//Test run program in main method
HashmapExample hashmap=new HashmapExample();
hashmap.hashmapExample();
}
}
package example.util;
import java.util.*;
public class HashtableExample {
public void hashtableExample(){
//Create Hashtable Object
Hashtable<String,String> hashtable=new Hashtable<String,String>();
//Store and Remove data from Hashtable
hashtable.put("key1", "value1");
hashtable.put("key2", "value2");
hashtable.put("key3", "value3");
String key3=hashtable.remove("key3");
System.out.println("-- Example for Get Value from Hashtable --");
System.out.println("Get Hashtable value: "+hashtable.get("key1"));
System.out.println("Remove Hashtable value: "+key3);
System.out.println("Contains Key Hashtable: "+hashtable.containsKey("key1"));
System.out.println("Contains Key Hashtable: "+hashtable.containsKey("key3"));
System.out.println("Contains Value Hashtable: "+hashtable.containsValue("value1"));
System.out.println("Contains Value Hashtable: "+hashtable.containsValue("value3"));
System.out.println("-- Example for Iterate list from Hashtable --");
Iterator<String> it=hashtable.keySet().iterator();
while(it.hasNext()){
String key=it.next();
String value=hashtable.get(key);
System.out.println("By Key :Key : "+key+" Value: "+value);
}
it=hashtable.values().iterator();
while(it.hasNext()){
System.out.println("Value "+it.next());
}
}
public static void main (String args[]){
HashtableExample hashtable=new HashtableExample();
hashtable.hashtableExample();
}
}
public synchronized void testMethod(String obj){
// you method logic
}public void testMethod(String obj){
// your method logic
synchronized(this){
// your method logic
// your method logic
}
// your method logic
// your method logic
synchronized(Test.class){
// your method logic
// your method logic
}
// your method logic
} enum Car {
City(800000), Civic(1200000),Jaz(850000);
int price;
Car(int p) {
price = p;
}
int showPrice() {
return price;
}
}
public class EnumTest {
public static void main(String args[]) {
System.out.println("My Car List:");
for(Car m : Car.values()) {
System.out.println(m + " Price " + m.showPrice());
}
Car city;
city = Car.valueOf("City");
System.out.println("Test Selected Car : " + city);
}
}
HashMap hm=new HashMap();
hm.put("key1", "data1");
hm.put("key2", "data2");
String data=hm.get("key1");
System.out.println(data);
<script>
// Create array of String
arrayObj=["CAT","DOG","MAN","CAR"];
for (var i=0;i<arrayObj.length;i++)
document.write(arrayObj[i] + "<br>");
}
</script>
<script>
// Create array of String
arrayObj=["CAT","DOG","MAN","CAR"];
for (var i=0;i<arrayObj.length;i++)
document.write(arrayObj[i] + "<br>");
}
</script>