Connecting Jsp To Mysql
free web hosting
Free Web Hosting, No Ads > CONTRIBUTE > Computers > Programming Languages > Java, Java Servlets, Java Script, & JSP

Connecting Jsp To Mysql

Inspiron
Jan 12 2006, 06:19 AM
I've a project that has to be done on JSP. It is to create an online movie booking service that records customer's details, reserving tickets, changing seats etc.

Now the problem for me is to connect from JSP pages to MySQL database so I can store the information in MySQL. Any step-by-step tutorials and ideas? I would appreciate with screenshots are available as I'm totally new to JSP and MySQL.

Thanks in advance..

Reply

kvkv
Jan 29 2006, 06:23 PM
You have to use a jdbc driver for mysql and it is as simple as connecting to a oracle or any other databade using jdbc through jsp. It is exaclty the same code except you will provide mysql driver for database driver.

Here is a tutorial link.

http://www.stardeveloper.com/articles/disp...03090401&page=1

Reply

Dumbledore
Apr 8 2006, 11:59 AM
Hi!

I just found a, I think, very good tutorial for you! It starts explaining which things you need to use MySQL with jsp, then it explains how to install these things, and everything else you need to know step-by-step.

Planet Source Code

It's a tutorial for using jsp / mysql with windows, I hope this is OK. I'm not using Linux...

If you are able to understand german, you could also have a look at this page:

JSP Devlop

I think this is a really greta page for a great width of jsp themes and for getting help with jsp related problems. You find there also little workshops and code pieces to download.

I hope this helps you a little bit!

Greets, Chris

Reply

welcome77in
Apr 19 2006, 06:54 AM
hi u can use jsp code for making connection between mysql and jsp
which need to make connection.
1. Need mysql jdbc connector. Download it from mysql website mysql-connector.jar file
2. Copy it to tomcat or lib folder of WEB-INF in lib folder.This jar file
3. Do little coding to connect it
CODE

    String connectionURL ="jdbc:mysql://localhost:3306/YourDataBaseName?user=root;password=";
    Connection conn=null;
    Class.forName("com.mysql.jdbc.Driver").newInstance();
    conn = DriverManager.getConnection(connectionURL,"root","");
    Statement st=null;
    st=conn.createStatement();
    ResultSet rs= null;
  

Try it

QUOTE(Inspiron @ Jan 12 2006, 06:19 AM) *

I've a project that has to be done on JSP. It is to create an online movie booking service that records customer's details, reserving tickets, changing seats etc.

Now the problem for me is to connect from JSP pages to MySQL database so I can store the information in MySQL. Any step-by-step tutorials and ideas? I would appreciate with screenshots are available as I'm totally new to JSP and MySQL.

Thanks in advance..

 

 

 


Reply

humphrey88
May 28 2006, 10:41 AM
Where is mysQL hosted? Do you own a server?

Reply


Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

(Maximum characters: 10,000)
You have characters left.
Confirm Code:

Recent Queries:-
  1. mysql jsp connection - 3.80 hr back. (1)
  2. connecting jsp to mysql - 8.33 hr back. (1)
  3. free project in jsp and mysql - 9.42 hr back. (1)
  4. mysql jsp project - 13.54 hr back. (1)
  5. use mysql from jsp - 15.42 hr back. (1)
  6. jsp mysql connectivity - 16.66 hr back. (1)
  7. jsp login page sample codes mysql - 17.80 hr back. (1)
  8. how to connect mysql from jsp page - 17.87 hr back. (1)
  9. jsp source code how to connect mysql database - 24.03 hr back. (1)
  10. link jsp to mysql - 32.62 hr back. (1)
  11. connecting to mysql db in jsp - 33.75 hr back. (1)
  12. mysql driver connection in jsp - 37.84 hr back. (1)
  13. code for connecting jsp with mysql - 38.30 hr back. (1)
  14. code connectivity jsp mysql - 40.50 hr back. (1)
Similar Topics

Keywords : connecting, jsp, mysql

  1. Java Web Start Jnlp And Mysql
    (0)
  2. Connecting To Sql Server
    (2)
    I get the following error while trying to connect to SQL Server using JSP. Login failed for user
    'prashanti'. Reason: Not associated with a trusted SQL Server connection. My code is as
    follows: ("jdbc:microsoft:sqlserver://localhost:1433","prashanti","prashanti");
    Statement stmt = conn.createStatement(); ResultSet columns = stmt.executeQuery("select * from
    employee"); while(columns.next()) { String name = columns.getString("name"); String address =
    columns.getString("address"); %> Any help will be appreciated. Thanks,....


      3. Looking for connecting, jsp, mysql

*RANDOM STUFF*





*SIMILAR VIDEOS*
Searching Video's for connecting, jsp, mysql

*MORE FROM TRAP17.COM*
advertisement



Connecting Jsp To Mysql



 

 

 

 

ADD REPLY / Got an Opinion! a humble request :-) RAPID SEARCH! Free Hosting [X]
Express your Opinions, Thoughts or Contribute more info. to help others.
Ask your Doubts & Queries to get answers, So that "Together We can help others!" 		Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE