Java database connectivity with mysql

Download jdbc driver from mysql

http://dev.mysql.com/downloads/connector/j/5.1.html

Unzip this zip and copy jar file in WEB-INF/lib folder of your application. or copy this jar file in tomcat/lib folder. Restart tomcat

creating database connection with MySQL

<%@ page language="java" import="java.sql.*"%>
<%
    Connection conn = null;
    // load driver
    Class.forName("com.mysql.jdbc.Driver").newInstance();
    
    // connection string
    String sURL="jdbc:mysql://localhost:3306/DBName";
    
    // user name of mysql database
    String sUserName="UserName";
    
    // password of mysql database
    String sPwd="Password";
    
    /// geting connection object with database
    conn = DriverManager.getConnection(sURL,sUserName,sPwd);
    
    Statement stmt = conn.createStatement();
    ResultSet rs = stmt.executeQuery("select * from tableName");
%>
<html>
<head>
<title>Java database connectivity with mysql</title>
</head>
<body>
<%
 while(rs.next())
 {
   out.print(rs.getString("id"));
 }
%>
</body>
</html>
<%
  if(conn!=null)
    conn.close();
%>

Tags:

Bookmark  

 

Leave a Reply

Security Code:

 

  Random Post