Jsp Blogs

How to Calculate the size of DataBase using mysql or schema?

2012-04-01T02:22:00.000-07:00

How to Calculate the size of DataBase using mysql or schema? Ans:- Query in mysql SELECT s.schema_name, CONCAT( IFNULL( ROUND( SUM( t.data_length ) /1024 /1024, 2 ) , 0.00 ) , "Mb" ) AS Data_size, CONCAT( IFNULL( ROUND( SUM( t.index_length ) /1024 /1024, 2 ) , 0.00 ) , "Mb" ) AS Index_size, COUNT( table_name ) total_tables FROM INFORMATION_SCHEMA.SCHEMATA s LEFT JOIN INFORMATION_SCHEMA.TABLES t ON s.schema_name = t.table_schema WHERE s.schema_name NOT IN ( "mysql", "information_schema", "test" )

how to create a connecction in mysql jsp?

2012-03-30T08:38:00.004-07:00

How to create mysql connectiion using jsp?

Ans:-
Creating connection using mysql,jsp

<%@ page language="java" import="java.sql.*" %>

<%
Connection con = null;
String databaseDriver = "com.mysql.jdbc.Driver";
String connectionURL="";

try {
connectionURL = "jdbc:mysql://localhost:3306/DataBaseName";
Class.forName(databaseDriver).newInstance();

con = DriverManager.getConnection(connectionURL, "username", "password");

}catch(Exception e){
out.print("Please wait 'http://rajdeokumarsingh1.blogspot.in/' will be back soon ");
}

%>

ow wait before doing this you have to put mySqlConnector.jar in lib folder of jdkx.xx.Ok

Doooooooooooooooooooooooooooooone!!!!!!!!!!!!!!!

you can download mySqlConnector.jar from this site
http://dev.mysql.com/downloads/connector/j/3.1.html

Extract it and paste on lib folder that's it

Now you done it

Thanks

How to Do Pagination using Jsp,Servlet ?

2012-03-30T08:17:00.002-07:00

For Pagination first of all you need to create a connection using jsp. i use the mysql server for data base.

create a table in mysql.

Create table pagination
(
id int ,
title varchar (50),
Description varchar(50),
)

Step 2:create the Database Connection.

create a connection.jsp file

Simple code:-

String connectionURL = "jdbc:mysql://localhost:3306/DatabaseName";
Connection con = null;
Statement statement = null;
ResultSet rs = null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection(connectionURL, "username", "Password");

save it to connection.jsp

Connection Created

Step 3:- Create a search.jsp file

"http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>

display data from the table using jsp

Welcome to music | Movie Search Engine

<%@include file="music.html"%>
/*
String connectionURL = "jdbc:mysql://localhost:3306/";
Connection con = null;
Statement statement = null;
ResultSet rs = null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection(connectionURL, "", "");
*/
<%@ include file="connection.jsp"%>
<%
Statement statement = null;
ResultSet rs = null;

try {

statement = con.createStatement();

String qs=request.getParameter("q");
if(qs==null)
qs="";

String item=request.getParameter("item");
if(item==null){item="0";}
int indexcounter=Integer.parseInt(item);

String query1 = "select count(*) from music_search where title LIKE '%"+qs+"%' order by id desc limit "+indexcounter+", 5";

Statement stat1 = con.createStatement();
ResultSet rs1 = stat1.executeQuery(query1);
rs1.next();
int resultcounter=0;
//resultcounter_blankresult=resultcounter;
resultcounter=rs1.getInt(1);

String QueryString = "SELECT * from music_search where title LIKE '%"+qs+"%' order by id desc limit "+indexcounter+", 5";

rs = statement.executeQuery(QueryString);
%>

<%
while (rs.next()) {

%>

<%}%>

<%
// close all the connections.
}catch (Exception ex){
%>
<%
out.println("Unable to connect to database.");
}
%>




<%=rs.getString(1)%>	<%=rs.getString(2)%>