|
|
|
Hssqldb Install and run your first query |
Download hsqldb.
It is a zip file unzip it.
Go to hsqldb-2.0.0-rc9\hsqldb\bin directory and edit runServer.bat. Add correct JAVA_HOME and PATH to the file.
This version requires JDK version 1.6 or higher.
e.g.set JAVA_HOME=C:\Program Files\Java\jre1.6.0_05
set PATH=C:\Program Files\Java\jre1.6.0_05\bin;
Step 1: Run DB Manager hsqldb\bin\runManagerSwing.bat
Choose HSQL Database Engine Standalone. Change database name in URL (in this example trupti_db). Press OK.
This should create trupti_db.lck, trupti_db.log etc. files in hsqldb\data directory.
Step 2: Create table
Create table query :
CREATE CACHED TABLE EMPLOYEE_DTL (EMP_ID INTEGER PRIMARY KEY, FIRST_NM VARCHAR(15), LAST_NM VARCHAR(15),
DT_OF_BIRTH DATE, HIRE_DATE DATE)
Step 3: Insert
Now insert some data :
INSERT INTO EMPLOYEE_DTL (EMP_ID, FIRST_NM , LAST_NM, DT_OF_BIRTH, HIRE_DATE)
VALUES
(1,'Donald', 'DUCK', '1976-01-02', '2009-08-12')
Step 4: Select
Select Query : SELECT * FROM EMPLOYEE_DTL
You have successfully created new database, table and run insert and select query!!!!!!!
|
|
|
| How to loop arraylist JAVA6 Syntax
|
| How to iterrate through ArrayList and display multiple rows using for loop JAVA6 syntax..
|
| Java JSP |
2010-Oct-12 |
| How to loop arraylist
|
| How to iterrate through ArrayList and display multiple rows using for loop, JSTL tags..
|
| Java JSP |
2010-Oct-12 |
| Consumer using JAX WS Dispatch API and DOM parser 1
|
| Access/Consume Webservice using Servlet, JAX-WS Dispatch API dynamic client and parsing SOAP response using DOM parser...
|
| Java Webservice |
2010-Sep-20 |
| Simple Java first CXF Webservice 4
|
| Building Simple Java first CXF webservice using CXFServlet, Spring, jaxws:endpoint, @WebService, @SOAPBinding, @WebResult
|
| Java Webservice |
2010-Sep-19 |
| Simple Java first CXF Webservice 3
|
| Building Simple Java first CXF webservice using CXFServlet, Spring, jaxws:endpoint, @WebService, @SOAPBinding, @WebResult
|
| Java Webservice |
2010-Sep-18 |
| Simple Java first CXF Webservice 1
|
| Building Simple Java first CXF webservice using CXFServlet, Spring, jaxws:endpoint, @WebService, @SOAPBinding, @WebResult
|
| Java Webservice |
2010-Sep-18 |
| Simple Java first CXF Webservice 2
|
| Building Simple Java first CXF webservice using CXFServlet, Spring, jaxws:endpoint, @WebService, @SOAPBinding, @WebResult
|
| Java Webservice |
2010-Sep-18 |
| Encoding special characters in userinput or on server
|
| Encoding can be done either in Javascript or JAVA encodeURIComponent, escape, java.net.URLEncoder..
|
| Java JSP |
2010-Aug-09 |
| Jstl fmt tag i18n formatdate formatcurrency
|
| fmt:setBundle, native2ascii.exe, fmt:message, fmt:setLocale, fmt:formatDate, fmt:formatNumber type=currency..
|
| Java JSP |
2010-Aug-05 |
| How to read and write a file
|
| How to read and write a file java.io.BufferedReader,java.io.FileReader, InputStreamReader ...
|
| Java J2SE |
2010-Aug-04 |
| jQuery validate form using ajax 2
|
| How to validate/submit form using ajax and jQuery input#, ($.ajax)..
|
| Javascript |
2010-Jul-23 |
| jQuery validate form using ajax 1
|
| How to validate/submit form using ajax and jQuery ($.ajax)..
|
| Javascript |
2010-Jul-23 |
| How to create datasource in RAD Websphere
|
| Create JDBC provider, datasource and JAAS security setup, JDBC connection URLs
|
| Servers Websphere |
2010-Jul-08 |
| Get Started 4
|
| Struts2 framework structure, how various components fit together
|
| Java Struts2 |
2010-Jul-07 |
| How to populate a form when JSP is called first time
|
| This is achieved throught setting bean in request, using frameworks like Struts2, Spring3..
|
| Java JSP |
2010-Jul-07 |
| Spring3 And Hibernate 4
|
| Spring3 and Hibernate 3.5.3 working together @Controller, @RequestMapping, @InitBinder, HibernateTransactionManager, LocalSessionFactoryBean, HibernateTemplate
|
| Java Spring |
2010-Jul-07 |
|
|
