Thursday, October 1, 2015

Excel to Database



import java.sql.DriverManager;

import java.sql.SQLException;


import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import com.mysql.jdbc.Connection;

import com.mysql.jdbc.PreparedStatement;

public class ExlToDbase



* @param args


public static void main(String[] args)





Connection conn = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/mydbase","root","ALPHAS");


PreparedStatement pstm = null ;

PreparedStatement pstm1 = null ;

PreparedStatement pstm2 = null ;

PreparedStatement pstm3 = null ;

FileInputStream input = new FileInputStream("D:\\fileLoad.xlsx");

XSSFWorkbook wb = new XSSFWorkbook(input);

XSSFSheet sheet = wb.getSheetAt(0);

Row row;

int k= 1;

int i=1;

while (i<=sheet.getLastRowNum()  )   //for(int i=1; i<=sheet.getLastRowNum(); i++)


row = sheet.getRow(i);

//int id = (int) row.getCell(0).getNumericCellValue();

String w = row.getCell(0).getStringCellValue();

//String address = row.getCell(2).getStringCellValue();

//System.out.println("Import rows "+i);

char[] ch = w.toCharArray();

int y = w.length();

for (int m = y ; m <= y; m--)


     String pl1 = new String(ch,0,m);



        //int l=8;

      char[] dh = new char[y];

       int c=y-1;

       int g = y-1;

       int h = 1;


       for (int j=c; j<=y; j--)




        String mpm  = new String(dh,0,y);

            dh[g] = ch[j];


                String pl = new String(ch,0,m);

               // String mpm  = new String(dh,0,y);







String sql1 = "insert into  Stml values('"+pl+"')";

String sql2 = "insert into  Sffl values('"+mpm.trim()+"" +"')";

String sql3 = "insert into mop values('"+w+"','"+pl+"','"+mpm.trim()+""+"')";

//java.sql.PreparedStatement psmt = conn.prepareStatement(sql);

pstm1 = (PreparedStatement) conn.prepareStatement(sql1);

pstm2 = (PreparedStatement) conn.prepareStatement(sql2);

pstm3 = (PreparedStatement) conn.prepareStatement(sql3);










System.out.println("Import rows "+i);







System.out.println("Success import excel to mysql table");


catch(ClassNotFoundException e)




catch(SQLException ex)




catch(IOException ioe)






a)Aim of code is to read each row i cell 0 from excel sheet.

b)After reading applying for loop on each value.

c)But it reads only one value and does not apply for loop on it.

Please  solve this issue.

Friday, August 14, 2015

Contact Us

Our Address

Aristocrat Research Solutions
No: 283, First floor
P.H Road, Aminijikarai,
Chennai - 600 029.

Land Mark

Opposite to Mosque,
Feel free to call 0091 98945-95035
Mail us: / 

View Map

Saturday, July 11, 2015

Good topic selection for doctoral research would be possible by consulting with our research experts, who are well experienced and could make you taste at the earliest stage of the development stage of your research. They will provide an analyzed result through several different aspects after the selection of concept. Based on your perspective and suggestions, the work will be carried over and also we will provide you the direction of research. 
For further queries you can contact us at

Friday, July 10, 2015

Research Design

If you couldn't plan or setting up a systematic map for your PhD research then you try taking our design and framework service provided by experts with appropriate design fitting into your research module thereby providing a systematic approach for your study.

We have a research team that provides you a better assistance in narrowing down into your study that helps you in setting controls and providing sampling strategy. Also they will offer you the measurement techniques after considering the hypothesis and variables, thereby providing you the algorithms or the hypothesis. Thus providing suitable service that can make you monitor the process of your research with better guidance from our professional advisory committee.

To know more about your service kindly send your enquiry at  

Monday, June 29, 2015

how to write a Research Synopsis

The synopsis should contain the following parts:

Problem analysis/literature review
Methodology and methods
Appendix A
Research matrix
Appendix B
Data collection instruments (e.g., interview guide, questionnaire)

Aristocrat IT Solutions
mail us at

Wednesday, June 24, 2015

Research Map

Research Map for Research

Step 1: Define the TOPIC
  • narrow down the topic
  • what is your knowledge regarding the research
  • what needs to be done
    • brainstrom
    • keywords
    • synonyms
Step 2: Gather the information
  • Websites
  • search journals from following websites
Step 3: Create a Process map or a Framework
  • Flowchart
  • what should be the input
  • what should be the output
  • what is the methodology
    • it can be an algorithm or hypothesis
Step 4: Evaluate the information
Step 5: Start writing your Paper
  • the paper should contain following contents

Tuesday, June 23, 2015

Friday, June 19, 2015

Plagiarism Technique

Studied a journal in science direct on how plagiarism could be detected using Singular Value Decomposition (what we call it as SVD in mathematics), and this has been proved to be efficient when compared with old plagiarism standards on testing 950 copies.

Stay tuned with more updates
Aristocrat Research Solution

(A Division of Aristocrat IT Solutions)

Novel Concept Creation

We Aristocrat team have arrived on a new algorithm in networking for security purpose - the concept is based on using hashing function instead of mac protocol.

Aristocrat Research Solution
(A Division of Aristocrat IT Solutions)

Thursday, June 18, 2015

Research Paper Format

How to format your research paper using either the MLA Format Research Paper or APA Format Research Paper guidelines. Be sure to follow any additional instructions that your teacher provides.

MLA Guidelines
Standard size (8.5 x 11" )
Page Margins
1" on all sides (top, bottom, left, right)
12-pt. easily readable (e.g., Times Roman)
Double-spaced throughout, including captions and bibliography
Alignment of Text
Flush left (with an uneven right margin)
Paragraph Indentation
1/2" (or five spaces)
End of Sentence
Leave one space after a period unless your teacher prefers two.
Page Numbers
On every page, in the upper right margin, 1/2" from the top and flush with the right margin put your last name followed by the page number.
Title Page
Only if your teacher requests one. Instead, on the first page, upper left corner place on separate lines, double-spaced:
  • Your name
  • Teacher's name
  • Course name or number
  • Date
Underneath, center the title using regular title capitalization rules and no underline. Start the report immediately below the title.
Section Headings
Tables & Illustrations
Place tables and illustrations as close as possible to the text they refer to.A table is labeled Table and given a number (e.g., Table 1). The table label and caption or title appear above the table, capitalized like a title, flush left. Sources and notes appear below the table, flush left.
Photos, graphs, charts or diagrams should be labeled Figure(usually abbreviate Fig.), and assigned a number (e.g., Fig. 1). The label, title, and source (if any) appear underneath the figure, flush left, in a continuous block of text rather than one element per line.

APA Guidelines

MLA Guidelines
1" on all sides (top, bottom, left, right)
12-pt. Times Roman or Courier. For figures, however, use a sans serif font such as Arial.
Page Margins
Flush left (with an uneven right margin)
5–7 spaces
Alignment of Text
Leave one space after a period unless your teacher prefers two.
Paragraph Indentation
On every page (except Figures), in the upper right margin, 1/2" from the top and flush with the right margin, two or three words of the paper title (this is called the running head) appear five spaces to the left of the page number, beginning with the title page.
End of Sentence
The title page is always the first page.On the line below the page number, the running head is typed flush left (all uppercase) following the words "Running head:"
Below the running head, the following are centered on their own lines, using upper and lower case:
  • Paper title
  • Your name
  • Your school
Page Numbers
Top level headings should be centered on the page, using upper and lower case.Second level headings should be flush left, italicized, using upper and lower case.
Title Page
Unless your teacher tells you otherwise, tables and illustrations appear at the end of the paper.Each table begins on a separate page with the label Table 1 (etc.) typed flush left on the first line below the page number. Double-space and type the table title flush left (italicized using uppercase and lowercase letters).
Figures Captions appear on the last numbered page of the paper. In this case the label Figure 1 (etc.) is italicized and the caption itself is not. The caption uses regular sentence capitalization. The figures themselves follow, one per page.
Section Headings
Each of these sections (if present) begins on a new page:
  • Title page
  • Abstract
  • Body
  • References
  • Appendixes
  • Footnotes
  • Tables
  • Figure Captions
  • Figures

Monday, June 15, 2015


Getting Started PhD Research 
Phd Guidance

Step 1: Most research begins with a question. 
  • Think about which topics and theories you are interested in and 
  • What you would like to know more about. 
  • Think about the topics and theories you have studied in your program. 
  • Is there some question you feel the body of knowledge in your field does not answer adequately?

Creative Writing
Step 2: Once you have a question in mind
  • Begin looking for information relevant to the topic and its theoretical framework. 
  • Read everything you can academic research writing, trade literature, and information in the popular press and on the Internet.
thesis writing
Step 3: As you become well-informed about your topic and prior research on the topic
  • Your knowledge should suggest a purpose for your thesis / dissertation. 
  • When you can articulate this purpose clearly, you are ready to write your research prospectus / research proposal writing
  • This document specifies the 
    • purpose of the study, 
    • significance of the study, 
    • a tentative review of the literature (literature review writing) on the topic 
    • theoretical framework (a working bibliography should be attached in thesis writing part), 
  • your research questions and/or hypotheses, and how you will collect and analyze your data (your proposed instrumentation should be attached).
Step 4: Recruit committee members and Preliminary meeting
  • At this point, master's students need to recruit committee members (if they haven't done so already) and hold a preliminary meeting. 
  • The purpose of this meeting is to refine your plans if needed and to make explicit expectations for completion of the thesis. 
  • Doctoral students discuss their dissertation proposal (research proposal) as part of their qualifying exam. 
  • At the completion of this meeting, the student should submit a memo to committee members summarizing what was agreed upon during the meeting.
Step 5: Once instrumentation is developed
  • Once your instrumentation is developed, you need to clear it and your informed consent protocol with the Institutional Review Board before you begin collecting data. 
  • Leave adequate time to do so. 
  • The process can take several days or weeks.
Step 6: Collecting and Analyzing data
  • Obviously, the next steps are collecting and analyzing data, writing up the findings, and composing the final chapter. 
  • You also should make sure Chapters 1 and 2 are now fully developed. 
  • Your chair and committee members provide guidance as needed at this point but expect you to work as independently as possible.
Step 7: Hire Assistance with Coding and Data entry

You should be prepared to hire assistance with coding and data entry and analysis if needed.

Step 6: Gudielines from Universtity
  • Get a copy of the graduate school's guidelines for writing theses and dissertations and follow these guidelines exactly. 
Step 9: Writing thesis
  • Each thesis or dissertation is unique but all share several common elements. 
  • The following is not an exact guide but rather a general outline.

Chapter 1: Introduction
Purpose and Significance of the Study In the first chapter, clearly state what the purpose of the study is and explain the study's significance. The significance is addressed by discussing how the study adds to the theoretical body of knowledge in the field and the study's practical significance for communication professionals in the field being examined. Ph.D. students also must explain how their research makes an original contribution to the body of knowledge in their discipline. They also should address the significance of the study for mass communication education. It is especially critical that this chapter be well developed. Without a clearly defined purpose and strong theoretical grounding, the thesis or dissertation is fundamentally flawed from the outset. 3

Chapter 2: Literature Review Writing 
Review of the Literature The purpose of the study should suggest some theoretical framework to be explained further in this chapter. The literature review thus describes and analyzes previous research on the topic. This chapter, however, should not merely string together what other researchers have found. Rather, you should discuss and analyze the body of knowledge with the ultimate goal of determining what is known and is not known about the topic. This determination leads to your research questions and/or hypotheses. In some cases, of course, you may determine that replicating previous research is needed of thesis writing.
thesis writing

Chapter 3: Methodology 
This chapter describes and justifies the data gathering method used. This chapter also outlines how you analyzed your data. Begin by describing the method you chose and why this method was the most appropriate. In doing so, you should cite reference literature about the method. Next, detail every step of the data gathering and analysis process. Although this section varies depending on method and analysis technique chosen, many of the following areas typically are addressed: 
--description of research design internal validity external validity 
--description of population and description of and justification for type of sample used or method for selecting units of observation 
--development of instrument or method for making observations (e.g., question guide, categories for content analysis) pre-test reliability and validity of instrument or method 
--administration of instrument or method for making observations (e.g., interviews, observation, content analysis, implementation such as matlab developing, ns2 implementation) 
--coding of data 
--description of data analysis statistical analysis and tests performed identification of themes/categories (qualitative or historical research)

Chapter 4: Findings 
This chapter addresses the results from your data analysis only. This chapter does not include discussing other research literature or the implications of your findings. Usually you begin by outlining any descriptive or exploratory/confirmatory analyses (e.g., reliability tests, factor analysis in thesis writing) that were conducted. You next address the results of the tests of hypotheses. You then discuss any ex post facto analysis. Tables and/or figures should be used to illustrate and summarize all numeric information. For qualitative and historical research, this chapter usually is organized by the themes or categories uncovered in your research. If you have conducted focus groups or interviews, it is often appropriate to provide a brief descriptive (e.g., demographic) profile of the participants first. Direct quotation and paraphrasing of data from focus groups, interviews, or historical artifacts then are used to support the generalizations made. In some cases, this analysis also includes information from field notes or other interpretative data (e.g., life history information of thesis writing).

Chapter 5: Discussion 
The purpose of this chapter is not just to reiterate what you found but rather to discuss what your findings mean in relation to the theoretical body of knowledge on the topic and your profession. Typically, students skimp on this chapter even though it may be the most important one because it answers the "So what?" question. Begin by discussing your findings in relation to the theoretical framework introduced in the literature review. In some cases, you may need to introduce new literature (particularly with qualitative research for thesis writing). This chapter also should address what your findings mean for communication professionals in the field being examined. In other words, what are the study's practical implications? Doctoral students also should discuss the pedagogical implications of the study. What does the study suggest for mass communication education? 4 This chapter next outlines the limitations of the study. Areas for future research then are proposed (research proposal writing). Obviously, the thesis writing or dissertation writing ends with a brief conclusion that provides closure. A strong final sentence should be written.


10. Do not expect to begin and finish your thesis in the same semester. You need to make significant progress (which usually means you are already collecting data for various tools such as matlab, ns2, java etc.,) the semester before you want to graduate. The defense is scheduled when the thesis has been completed successfully--not when it is convenient for the student to graduate. Even if nothing goes wrong (and things often do), a quality thesis takes about six to nine months to complete (from inception to graduate school clearance). Obviously, the same principles apply for dissertations as well but doctoral students must allot even more time. A quality dissertation usually takes about a year to complete (best case scenario).

11. Do not expect your chair or committee members to copy edit your thesis writing or dissertation writing. Before turning in any drafts, you should carefully edit and spells check your work. Thesis Editing occurs at two different levels at least. Micro editing involves correcting spelling and grammatical errors. It also involves checking for proper paragraph and sentence structure, consistent use of terms, and variety in word choice. Macro editing assesses the overall structure of the thesis writing. This includes making sure each chapter flows logically from the previous chapter, headings and subheadings are used properly and consistently, and transitions are included between major topics. Macro editing also determines whether any parts of the thesis writing need to be streamlined or expanded. In some cases, it may be necessary for you to hire a professional editor for thesis writers.

12. Leave time for the chair to read your completed thesis writing or dissertation writing  at least twice before giving it to your committee members. Don't expect to submit the completed thesis or dissertation for the first time to the chair and defend in the same or following week. Also, it is customary to give the thesis writing or dissertation writing to committee members at least a week before the defense.

13. It is the student’s responsibility to reserve a room for the defense and to bring the signature page and the examination form to the defense.

14. Be prepared for revisions after the defense. You can expedite clearance by the graduate school by letting the staff examine a draft of the thesis writing or dissertation writing before you defend.
thesis writing

15. It is customary to provide your chair and committee members with a bound copy of the final version of the thesis (complete thesis)  or dissertation (complete dissertation).

Sunday, May 31, 2015

Effective Article Writing Tips

The goal of this article is to not only help you snap out of writers block, but to help you hand yourself a completed article. 

1. Have A Title List

There are some people who enjoy an idea sheet, but I am not a fan those unless specific. Instead, I like a title sheet. While they may seem like the same thing, there is a distinctive difference.

2. Borrow Ideas From Other People

Now wait, before you think I am suggesting something unethical, give me a moment. All your work should be 100% yours. That being said, you can get phenomenal ideas reading other people’s work.

3. Lists And Bullet Points

People have thousands of distractions to choose from every day. Since you have a short time to capture their attention, you can keep it uncluttered with lists. Why do lists work so well?

They keep information concise
They attract the eye
They help with compression
They make points stronger and more urgent
The lists above speak for themselves.

4. Get Worked Up

Excitement over a subject is the best way to let the “ink flow.” If you are excited about what you are writing, the session will fly by quickly.  Excitement can present itself in all types of forms, such as happiness or debate. Don’t be afraid to walk away from an article because it isn’t working or you are bored. You can always go back to it later if you feel the inspiration has returned.

5.  Block Out The World

You can’t write quickly if the TV is on or your phone is getting 20 text messages. If you take the time to devote your undivided attention to your article, you will have more time for the funnier things in life. Remember what mom said, “You can’t go outside and play with your toys until you finish your homework!”

6.  Learn To Quote

Plagiarism isn’t cool, but quoting someone’s work is. Often someone can say something you want to say better. They can also say something you would like to debate. Whatever your stance, don’t be afraid to use large quotes from other sources and write about how it makes you feel.

7. Stop Overthinking It

Simple is smart. Quick is good. Don’t try to turn your article into something it isn’t just to make it different or longer. The best ideas genuinely can be the simplest ones.

8. Keep Your Hand On The Pulse Of The World

9. Keep A Pad With You At All Times

If you utilize these tips, you will have a more successful (and less stressful) article writing experience.

Saturday, March 28, 2015

How To Write Research Paper

What is a research paper?

A research paper is a written discussion based on an analytic thesis and supported by a collection of ideas and information. (Click here and here for more information on how to find a research topic)
 It is a way of presenting ideas and facts you have found through the reading of various materials.

Why do we write a research paper?

As part of our academic assignments
To relate information and study findings in a professional manner
To find answers to academic/ scholarly questions.
 For master’s and doctorate’s theses.
A well-written research paper is composed by the use of a variety of outside sources with high credibility.
You should use quoting, paraphrasing and summarizing techniques along with your own words.
You should follow a style guide while writing your paper like APA or MLA style.

Mainly, a research paper includes the parts below:

1.      Title
2.      Abstract
3.      Introduction
4.      Literature Review
5.      Methodology
6.      Results
7.      Discussion
8.      Conclusion
9.      References
10.    Appendices

1- Title Page:
Ø Choose a comprehensive title for your study.
Ø Write your title in the middle of the page.
Ø Below the title, write your name, the name of your instructor, the name of your institution and the year.
Ø Somewhere above the title, you write the running head.
Ø The running head should be as clear and short as possible.
Ø The running head should appear on every page with the page number.
Ø Click here to see a sample title page.

2- Abstract:

Ø Your abstract should be as short and clear as possible.
Ø While writing your abstract:
Ø Give a brief introduction of the general topic of the study.
Ø Explain the exact research questions and the aims
Ø Give a brief description of the methodology.
Ø Give a brief description of the results.
Ø Give a brief description of the discussion.

In other words, you answer the following questions in your abstract:
ü  Why did you do the study?
ü  What is the problem being addressed?
ü  What did you do?
ü  What did you find out?
ü  What conclusions do you have?
ü  Click here to see a sample abstract.
ü  Click here for the "How to Write an Abstract" Wiki

3- The introduction:

This is the part where you start with a broad basis and then narrow down to the particular field of study, explaining the rationale* behind each step.
You give some background information, the importance of the study, the limitations of the study and your assumptions.
•        Specifically;

1- Set the scene,

By giving your paper a context.
By showing how your study fits in with the previous research in the field.

2- Give the rationale behind the research,
By justifying why your study is an essential component of research in the field.

3- State the limitations,
By saying what you could have improved.

4- State your assumptions,
By giving the reasons.

4- Literature Review:

ü  It is a process of gathering and documenting information from other sources.
ü  It is a critical and in depth evaluation of previous research.
A GOOD literature review...
ü  integrates the previous research together.
ü  Explains how it integrates into the proposed research program.
ü  highlights areas of agreement and disagreement.


 A Literature Review is NOT a chronological catalog of all of the sources,
 A collection of quotes and paraphrasing from other sources;
It is an evaluation of the quality and findings of the previous research.
If your literature review can answer the questions below, it is a good one!
Click here for the "How to Write a Literature Review" Wiki.

5- Methodology:

ü  This part is the core of your paper as it is a proof that you use the scientific method.
ü  You give a completely accurate description of the equipment and the techniques for collecting the data.
ü  You explain how the raw data was collected and analyzed.

ü  Describe the materials and equipment that you used in the research.
ü  Explain how you gathered the sample:
ü  Did you use any randomization techniques?
ü  How did you prepare the samples?
ü  Explain how you made the measurements:
ü  What calculations did you make?
ü  Describe the statistical techniques that you used upon the data.
ü  You can write this section in subgroups like setting, participants, instruments and procedure if it is applicable for your study.

6- Results:

Writing the results section is announcing your findings to the world.
In this part, present your findings without interpreting or evaluating.
Include graphs, figures and tables to make your point clear.
You make a commentary of exactly what you observed and found.
It is a link to the discussion section.

7- Discussion:

Ø  It is the part where you add interpretations to your work.
Ø  Comment on the data and your findings.
Ø  Criticize your methodology.
Ø  Suggest any modifications or improvements for your design.
Ø  Give recommendations for future researchers.
Ø  Ask and answer “Do your results agree or disagree with previous research?”
Ø  Ask and answer “Has the experiment contributed to knowledge in the field?”

8- Conclusion:

Ø  It is the final part of your research paper.
Ø  You should consider the following questions while writing your conclusion:
Ø  What has your research shown?
Ø  Give a brief description of the results
Ø  Give a brief summary of the discussion
Ø  How has your study added to what is known about the subject?
Ø  Point out the significance of your study
Ø  Discuss how your study relates to the field
Ø  What were the shortcomings?
Ø  Explain how any deficiencies may affect your results
Ø  Has your research left some unanswered questions?
Ø  Do the findings open up any suggestions for future research?
Ø  Are the results of any use in the real world?
Ø  Can you suggest any practical uses for the findings?


ü  This part is also called “the citation list”.
ü  It is very important because it helps you...
ü  Prevent any accusations of plagiarism.
ü  Give fair credit to the work of previous authors in the field.
ü  It must include all of the direct sources referred in the body of the paper.

ENJOY your writing!
”Writing is easy: All you have to do is sit staring at a blank sheet of paper until drops of blood form on your forehead.” Gene Fowler.

For Details Visit: