mysql connection using jsp
how cna i connect mysql database with my login form using jsp in linux operating system?
Software/Hardware used:
Software/Hardware used:
ASKED:
May 17, 2010 10:05 AM
UPDATED:
October 12, 2010 7:09 AM
Answer Wiki:
I provide the article just follow the steps:
Step 1 - Creating a MySQL database
Log into the Mysql, Enter a database username and password of your choice, the database name will be your username with "db" appended to it, so if you created a database called "amazon" your database name would be "amazondb".
Step 2 - Connecting to MySQL using JSP and JDBC
Once you've successfully created your database can you connect to it using JSP via JDBC using the following connection example. Change the connection parameters in red to the ones you've chosen in Step 1.
<%@ page import="java.sql.*"%>
<html>
<head>
<title>JDBC Connection example</title>
</head>
<body>
<h1>JDBC Connection example</h1>
<%
java.sql.Connection cn;
Class.forName("org.gjt.mm.mysql.Driver");
cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/database_name", "database_username", "database_password");
%>
</body>
</html>
Note: No matter what os u r using. Just install Mysql for linux and web browser may be Firefox / safari
Hope u get the answer.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
