Web Technologies Lab
(Experiment 9(a) and (b))
a) Accessing MySQL DB from Console Application:
package dbconnect;
import java.sql.*;
public class DBConnect {
/**
* @param args the command line arguments
*/
public static void main(String[] args) {
// TODO code application logic her
String url = "jdbc:mysql://127.0.0.1:3306/";
String dbName = "test";
String driver = "com.mysql.jdbc.Driver";
String dbUser = "root";
String dbPW = "";
Connection objConn;
Statement objStmt;
ResultSet objResSet;
try
{
Class.forName(driver).newInstance();
objConn = DriverManager.getConnection(url + dbName, dbUser, dbPW);
System.out.println("Connected Successfully");
objStmt = objConn.createStatement();
objResSet = objStmt.executeQuery("select * from employee");
while(objResSet.next())
System.out.println(objResSet.getInt(1)+" "+objResSet.getString(2)+" "+objResSet.getString(3));
objConn.close();
}
catch(Exception e)
{
System.out.println("Error in Connection");
}
}
}
b) Accessing MySQL DB from Web Application using JSP:
<%@ page import="javax.sql.*"%>
<html>
<head>
<title>JDBC Connection JSP example</title>
</head>
<body>
<h1>JDBC Connection JSP example</h1>
<%
try {
Class.forName("com.mysql.jdbc.
Connection con =
DriverManager.getConnection( "jdbc:mysql://127.0.0.1:3306/
Statement stmt=con.createStatement();
String qry="select * from emp";
ResultSet rs=stmt.executeQuery(qry);
while(rs.next())
{
out.print(rs.getInt(1)+" "+rs.getString(2)+" ");
}
}
catch(SQLException ex)
{
out.print("SQL Exception caught"+ex.getMessage());
}
%>
</body>
</html>
