Jul 26, 2008

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

free web hosting

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 connection through jsp - 13.64 hr back. (1)
  2. entire code for online movie ticket booking in jsp and servlet - 14.27 hr back. (1)
  3. online movie ticket code in jsp - 15.45 hr back. (2)
  4. how to connect mysql database with jsp page - 16.18 hr back. (1)
  5. jsp jdbc mysql sample code - 16.47 hr back. (1)
  6. jsp mysql jdbc tutorial - 19.86 hr back. (1)
  7. connect jsp mysql - 21.36 hr back. (1)
  8. connecting mysql to jsp - 26.39 hr back. (1)
  9. connect jsp to mysql program - 26.87 hr back. (2)
  10. mysql jsp connection example - 29.63 hr back. (1)
  11. tutorial of connectivity of jsp from mysql - 31.07 hr back. (2)
  12. webstart can not find mysql database driver - 31.69 hr back. (1)
  13. connecting to mysql database from a jsp page - 33.98 hr back. (3)
  14. jsp connecting to mysql - 33.24 hr back. (2)
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

Searching Video's for connecting, jsp, mysql
advertisement



Connecting Jsp To Mysql



 

 

 

 

ADD REPLY / Got an Opinion! Remove these ADs! RAPID SEARCH! Free Web 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