mysql> select * from employee where str_to_date(b_date,'%Y-%m-%d') between str_to_date('2019-2-26','%Y-%m-%d') and str_to_date('2019-2-30','%Y-%m-%d');
| id | name | b_date |
| 2 | tony stark | 2019-2-26 |
| 4 | black widow | 2019-2-27 |
2 rows in set (0.00 sec)
mysql> desc employee;
| Field | Type | Null | Key | Default | Extra |
| id | int(11) | NO | PRI | NULL | |
| name | varchar(20) | YES | | NULL | |
| b_date | varchar(20) | YES | | NULL | |
3 rows in set (0.03 sec)
mysql> select * from employee;
| id | name | b_date |
| 1 | steve rogers | 2019-2-24 |
| 2 | tony stark | 2019-2-26 |
| 3 | thor odinson | 2019-2-25 |
| 4 | black widow | 2019-2-27 |
4 rows in set (0.06 sec)
Hello
guys, this is unpossible pog and in this video, I shall teach you how
to find data between two dates if they are stored as varchar as
variable character.
First
I shall start mysql by entering username and password.
Then
I shall connect to the database, this is case, its sys.
Then
as you can see the employee data with the birth dates.
But
the b_date is stored as varchar.
So
in mysql, there is a function called str_to_date() which converts text to date.
So
type command like this in where condition, the first argument will be
the column name, which is b_date. Then in second argument, there will
be a pattern.
In
my database, the pattern is the year – month – date. So I shall
type percentage year – percentage month – percentage date.
Thank
you for watching, Dont forget to like share and subscribe.
On 14th of February 2019, I was checking my old videos inside video manager. By default, youtube's video manager shows videos from newest to oldest. So I was clicking on page links and I saw an unusual thing in my list. There was 2019 live stream within the list of 2016 videos. I don't know how that was happened. As a programmer, the possible things are.
1. It is a bug, means youtube coders neglected live stream video as as ascending order.
2. Maybe one employee changed the date and forgot to reenter it.
3. Some hacker intrude into youtube server and changed date.
This video is 1st part of the trip. This video will be about "what happened during the journey". We decided to do the visit bhimashankar temple. There are 3 ways to reach to the temple, 1: By road 2: By Stairs 3: By hiking over the montain. We chose the third option, that is to trek because our main goal is to look for an adventure and thrill. After almost completely exhausted by hiking halfway over the mountains, we decided to take a little rest. But it was not fun sitting around in the middle of journey. So we start bluetooth speakers and play songs and we started dancing.
In 2018, youtube introduced a new feature called "Miniplayer".
With this, a user can browse other videos while searching through youtube website. This concept is possibly inspired by mobile apps.
Although the miniplayer floats on window, it can not be dragged anywhere on browser screen, means it always stays at the right bottom. Miniplay is attached with browser, means if you minimize browser then the miniplayer also will be minimized with browser.
I hope there will be new features in miniplayer in future that can be dynamic in nature.
Code :-
import java.io.*; import java.util.*; class update_file { public static void main(String ar[]) { update_file uf=new update_file(); uf.update(); } public void update() { /////////phase 1 System.out.println("Enter the ID of employee that you want to update....."); Scanner sc=new Scanner(System.in); int id_to_change=sc.nextInt(); String to_change_column_names[]={"first name:","last name:","Salary:","Location:"}; int yes_no[]=new int[4]; String to_update[]=new String[4];
System.out.println("Select the columns that you want to update (0: No/1: Yes)"); for(int i=0;i<4;i++) { System.out.println(to_change_column_names[i]+""); int temp=sc.nextInt(); yes_no[i]=temp; }
////////////////phase2 System.out.println("_______________________________________________________"); System.out.println("Add new values to the columns"); for(int i=0;i<4;i++) { System.out.println(to_change_column_names[i]+""); if(yes_no[i]==1) { Scanner sc1=new Scanner(System.in); String temp_val=sc1.nextLine(); to_update[i]=temp_val; System.out.println(); } else { System.out.println("Cannot be changed"); } }
Hello guys, this is unpossible pog and and on youtube, this guy requested
me to make a code in java to perform update operation.
If
you want to skip intro, then jump to this time.
For
lot of you guys who don’t know, i made tutorials on how to use text
file as database using java.
I only made videos of inserting and
displaying data but not on how to update data.
When
I was trying to write a program however, I found out that it is vary
complex.
Let
me explain you.
SO
this is my table structure with 5 columns.
And
here as you can see, that there can be multiple “SET” keywords
that can be applied to multiple columns, and same goes to “WHERE”
clouse, where there can be multiple condition and other complications
like “AND-OR” and “IN” and “EQUALS TO”.
Now
I shall explain the simplest one, in that there is only unique ID in
condition, but you can select multiple columns.
I
solved the problem of selecting which columns will be updated by
flagging is either as 0 or 1.
If
u didn’t understand it, dont worry, you will understand when I
start writing a code.
Now,
in previous tutorials, we wrote a code on now to insert and display
data from text file. So let me just run it.
As
you can see, the data is entered in text file.
Because
the udate code is huge, I am going to create a new .java file, save
it as the same location where the text file is.
Make
a class and main function.
Now,
there are 4 phases,
In
first phase, we will get which ID will be in where condition and
create some arrays.
Here,
we are not updating ID, because in live projects, we don’t often do
that.
The
Array yes_no are made to give the flag to columns that is O or 1.
In
the for loop, we are asking users to select columns to be updated
Lets
check it, it should be an array.
First,we
will enter ID, then we will type either 0 or 1.
So
far so good.
Now
in second phase,we shall ask user to enter the value of columns which
user want to update.
We
shall store that in “to_change_clumn_names” array.
If
the flag is 1, then , we shall create scanner variable, and insert
values.
In
else, we shall tell user that you can not change this value.
As
you can see, the program is denying user because of the 0 flag he
gave.
In
phase three, we will modify data but won’t upload it in text
file. It will be in phase 4.
But
now in phase 3, we shall get data from text file,now from here, it
gets more complex.
We
shall need, a stringbuffer variable the store the modified value.
In
abstract word, in phase it, we go to each row, and find out whether
it’s ID matches with ID that we enter, if no, then we skip the
change, but if YES, then we find which columns should be updated and
swap their values.
We
append those value in StringBuffer.
Now
lets run it,
Actually
I forgeot to append, when flag is 1.
Now
in phase 3, we are writing the data in text file, it is vary easy.
Make
sure to close the printwriter, otherwise the file won’t be updated.
Lets
run the program and check in text file, whether or not the data has
been modified.
We
shall the value of employee where his ID is 1.
To
confirm it again, we shall the information of ID equals 2.
Thnak
you for watching, Dont forget to like share and subscribe.
One day, my colleagues (friends) asked me to come with them to visit Shirdi and refresh the mind from the work load. These guys are my first 20's friends, so I said "YES, Sure!" immediately. On the night of journey, I joined the rest of the crew, we were total 9 guys and getting a new experience to travel without booking any hotels and most traveling sources. I think it is an important experience to learn how to manage money and travel safely. Panicking is not an option. The thing that I learnt is "Help can be given to those who just simply ask for it". So I would like to thank the crew and the people that we meet who gave us helping hands.
Hello
guys, this is unpossible pog and in this video, I shall tell you how
to create MVC framework using jsp and servlet
First
I will show you the live example, blue dart’s old website was
developed using JSP MVC concept. They just forgot to give proper
names to servlet but whatever.
The
main reason to hide web page is to make it safe from hackers by not
leaving file names like .html . Jsp etc
So
lets create a web application in netbeans.
Give
any random name. Click next twice. And click on finish.
Now
lets run the web app first.
Ok,
so lets add my youtube channel name there.
Now
right click on default packages, and add servlet. Give the random
name, click on next and make sure to click on “Add information to
deployment descriptor” which will create web.xml file
automatically.
The
servlet file is open.
Then
go to web pages, then web-inf, and open web.xml.
You
can see the servlet’s name. Now lets create a link go from one
page to another.
Create
jsp page, and give it a any name, in href, give the name of jsp file
that we have created along with it’s extension.
Now
lets refresh project, and when you click you will go to second page
but the problem is that in URL you are reavealing the file name.
So,
go to web.xml and in url pattern, give the any name which will hide
the file name. Copy that name and replace it in href.
Inside
try, You can see that there is un necessory content, so just comment
that, and we shall create reuest dispatcher variable, and add
“second_page.jsp” file in getRequestDispatcher’s first
argument.
Now
we are forwarding, so lets re-run project and now when you click on
link, we went to send page without revealing the second_page.jsp.
But
what happen you u want to send value thrugh url, so for example, go
to youtube and search something, you can see that result is the
servlet, and we send value as thanos in search_query variable.
Go
to index page, and create variable as “search” and give the
value.
Oops,
there should be question mark.
Now
go to servlet, create string variable, and in getParameter, give the
variable name, in our case its “search”.
Now
we set attribute, give any random name in first argument, and in
second argument, add string variable “A”.
Now
go to second_page.jsp file and use jsp syntax to print value of
search using request.getAttribute, paste the name of variable from
servlet to second page, now lets run the project.
Thnak
you for watching, Dont forget to like share and subscribe, and in
next part, I will create working with model that is database, so stay
tuned.
