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..

Comment/Reply (w/o sign-up)

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

Comment/Reply (w/o sign-up)

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

Comment/Reply (w/o sign-up)

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..