Completed

File and data structure database in java

Hello dear , i have an assignment that's due this week and i'm stuck on it . it's about select table from database in java which is from the inserted table (the inserted to table code i'm done with it ) . the propose of work is first using the regular expression which is the pattern to put all the acceptable cases ( i have done the regular expression part and pretty sure it's working for all cases ) after that i have to done 10 steps :

1. the table name must be the belonging to the table that exist on the database. (i done with this part too)

2. each column should be a valid column name with in the table . the rule for it are :

- should be without any restriction of order

- without reputation ( which mean without reputation of column name so there is no duplicatable.

- without any quantity ( which mean with no = , >, <, etc ).

- it must be include a primary column at least once.

- the column is an optional and that i care on it the pattern (regular expression), so the user can select the table without a column name in some cases . so, if the column name is not given the asteroid(*) sign should given instead . and the column names default to the column names defined and order in schema.

3. for word aliasi , it should be a valid column name that used to rename the columns in the new table (so here in this step we should implement new table that deferent from the table used in first and second step) without modifying the name of the original table that's created in the column names.

- in this case also , if the given alias or sources column names result as duplicate column names in the new table , the query be invalid .

4. in the where word , if it's give the elected rows are defined to be all the rows in the original table for the given condition that evaluate as true.

- for the false condition , the selected rows should be in this case defined to be all the rows in the original table.

5. the rules for evaluation in a WHERE clause condition in per row are as follows :

- the left hand side , is a valid column name in the original table , and it's evaluate as the filed value in that column .

- the right hand side , is should be string or integer or boolean value ( that should similar to the insert into table query that i created ).

-the operators, which are = and <> are valid only when left hand side and right hand side are both string , or both integer , or both boolean. the evaluation will be true when the lest hand side and right hand side are respectively equal or unequal.

- the operators, which are <, >,<= ,>= are valid only when the left hand side and the right hand side are both string , or both integer, the evaluate in this case is true when left hand side is respectively < , >, <=, or >= to the right hand side according the lexicographic order for string and ascending order for integer.

- in the null case , if null equal null the result will be true , but the result will false in any other cases which an operand equal null.

- if the expression is invalid for some row , the query should entirely fail , even if it's valid for some other rows.

6. the query should return the new table that created. and contains the selected rows from the original table but only the indicated columns.

- the primary column of the new table should be the primary column in the original table(or the leftmost repeated instance if applicable).

7. in succesful réponse , it should be state the original table name , and the number or rows in the new table. and return the new table which including an appropriate schema.

8. in a failed response , should state the description of the error (a message ) and in this case return null.

this is all the description details about the assignment a help on . if any one interesting to help me out in it and if you are familiar with this topic please let me know . and if you have any more question or if any thing not clear let me know and i can explain it more . i can send the codes i created too.

Skills: Database Programming, Java

See more: how to create database in java, java database programming, java database, java database tutorial, data structures in java examples, data structures in java pdf, data structures and algorithms, data structure in java book, export data excel database java, data structure project java railway system country, data extraction database java program, insert xml file data sql database vbnet, building xml file data sql database, excel file data mysql table java, insert data html database java, search data mysql database java search, upload data csv database java, simple index file data structure, upload xls file data mysql database java, index file data structure

About the Employer:
( 0 reviews ) Morgantown, United States

Project ID: #18855359

Awarded to:

Hada36

Hello, Thank you very much post your project. I am very much interested on your [login to view URL] my Experience and Expertise I believe and very confident that I will be able to handle your project efficiently and effect More

$83 USD in 2 days
(15 Reviews)
3.6

24 freelancers are bidding on average $190 for this job

NovaSofts

Hello Sir/ Ma’am We are a group of Software Engineers (Programmers) having 10+ years of experience. Expert in JAVA, C, C++ , C# , Python, ANDROID,IOS, MATLAB, IONIC. Done 600+ projects here on FREELANCER.COM More

$155 USD in 3 days
(295 Reviews)
7.4
utkarshkatiyar19

Hi I'm an expert in java programming and databases. I'm sure that I can easily do this project. We can have a about it. Thanks..

$150 USD in 3 days
(269 Reviews)
7.1
urmate

Hi There I've excellent programming and development skills and knowledge. I can provide an efficient, perfect, well documented development of your Programming and Computer project according to 100% accuracy and More

$155 USD in 3 days
(303 Reviews)
6.8
kipdev13

Hi, Dear! I`m great interested in your suggest. If you're interested - contact me. Let's get in touch to discuss your project in more detail via here. It would be great to discuss details More

$100 USD in 3 days
(33 Reviews)
5.0
mehmood168

Hi, I am a full-stack Java developer having more than 4 years of professional experience. Apart from that, I've been helping people on this platform with their projects, lab tasks etc since 2015. I have understood t More

$116 USD in 4 days
(38 Reviews)
5.1
paulprabhakarand

Hi, This is Paul Devanesn has done [login to view URL] and [login to view URL] from IIT Madras. I am a tech savvy person, more than a decade I am developing and delivering applications on Android app and Java based technologies. I am a certif More

$90 USD in 3 days
(24 Reviews)
5.2
okzhang321

Hello. I have read your description and I am so interested in your project. I am confident in your project and I can finish it clearly on time. I am well experienced and skillful Java programmer. I have +15 years More

$100 USD in 3 days
(40 Reviews)
4.9
dungforever

Hi I have read your requirement carefully. It's a great chance to introduce my skill. I am a talented software developer with over 11+ years experience. I have full experience in Java Database. You can save time a More

$155 USD in 3 days
(20 Reviews)
4.8
ThinkAndCo

hi, We are a team of professional software developers. We have expertise in Java and can readily work on your requirements. Kindly consider our proposal for best results. Looking forward to talking for more info More

$100 USD in 1 day
(22 Reviews)
4.5
qunzhuang323

Hi I have read your project description very carefully so I am confidence to complete your project I have finished many similar Java projects successfully. I am an experienced and skillful java developer. I have More

$100 USD in 3 days
(7 Reviews)
3.6
HadiDar786

ok i got your requirements and i am willing to do this job for you according to your requirements ... message me so we can proceed further..thanks.........

$66 USD in 2 days
(3 Reviews)
3.0
dungchan44

Hello, sir! I am happy to put my bid on your project. I have a full of experience with database processing in java. I have finished a lot of projects like this. I can show you one of them if you want. I ensure the More

$100 USD in 1 day
(11 Reviews)
2.8
yasha53

Hi, I’m Oleksandr Yatsunyk from Ukraine (UTC+2) Highly skilled software engineer with more than 7 years software development experience. Full Stack backend developer. Main area are Java and Web. To don't waste your More

$222 USD in 3 days
(1 Review)
2.8
namitkhandelwal

hello, warm greetings! I am a Java developer working on Java technology since 7+ years having hands on windows and web development experience. I would like to help in your application development. I have some q More

$130 USD in 3 days
(5 Reviews)
2.7
innocentkus

hello sir, i have great experince in java programing and database. if you start chatting with me I will tell you how I will solve it then you can give me the project.

$166 USD in 5 days
(1 Review)
2.5
ayushbajaj056

Hello I have read the description and I can make this project in 24 hrs. i have a deep knowledge in java and jdbc. ready to work right away.

$35 USD in 1 day
(4 Reviews)
1.8
Danial2018

Hi, I read your project very carefully and ready to start working on it. I am an expert with all the skills which you mentioned in your project description. Please if possible come on chat for further details discussi More

$1666 USD in 30 days
(1 Review)
0.6
Hichem16

For the last two years I have been working in a similar role to the one you are advertising, and have been responsible for designing, building, testing and supporting Java applications. Being a key member of my exist More

$166 USD in 0 days
(0 Reviews)
0.0
praveendtut

Hi, I am well experienced in Java, DB Connectivity. Regular expressions as well. I did go through the attached document. I have few questions though. May be we can connect so that I can better understand your requir More

$80 USD in 3 days
(0 Reviews)
0.0
$196 USD in 3 days
(0 Reviews)
0.0