Java-Rules: Oct 1, 2011

Saturday, October 1, 2011

web.xml file

<web-app>
<context-param>
<param-name>driverclassname</param-name>
<param-value>oracle.jdbc.driver.OracleDriver</param-value>
</context-param>
<context-param>
<param-name>url</param-name>
<param-value>jdbc:oracle:thin:@localhost:1521:xe</param-value>
</context-param>
<servlet>
<servlet-name>ab</servlet-name>
<servlet-class>AddBook</servlet-class>
<init-param>
<param-name>dbuser</param-name>
<param-value>system</param-value>
</init-param>
<init-param>
<param-name>dbpass</param-name>
<param-value>system</param-value>
</init-param>
<init-param>
<param-name>sqlstatement</param-name>
<param-value>insert into AddBook values(?,?,?,?)</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>ab</servlet-name>
<url-pattern>/AddBook</url-pattern>
</servlet-mapping>

<servlet>
<servlet-name>srf</servlet-name>
<servlet-class>StudentRegForm</servlet-class>
<init-param>
<param-name>dbuser</param-name>
<param-value>system</param-value>
</init-param>
<init-param>
<param-name>dbpass</param-name>
<param-value>system</param-value>
</init-param>
<init-param>
<param-name>sqlstatement</param-name>
<param-value>insert into AddBook values(?,?,?,?,?,?,?)</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>srf</servlet-name>
<url-pattern>/StudentRegForm</url-pattern>
</servlet-mapping>

<servlet>
<servlet-name>af</servlet-name>
<servlet-class>AddFee</servlet-class>
<init-param>
<param-name>dbuser</param-name>
<param-value>system</param-value>
</init-param>
<init-param>
<param-name>dbpass</param-name>
<param-value>system</param-value>
</init-param>
<init-param>
<param-name>sqlstatement</param-name>
<param-value>insert into AddBook values(?,?,?,?,?,?,?,?)</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>af</servlet-name>
<url-pattern>/AddFee</url-pattern>
</servlet-mapping>

<servlet>
<servlet-name>ul</servlet-name>
<servlet-class>UserLogin</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>ul</servlet-name>
<url-pattern>/UserLogin</url-pattern>
</servlet-mapping>

<servlet>
<servlet-name>al</servlet-name>
<servlet-class>AdminLogin</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>al</servlet-name>
<url-pattern>/AdminLogin</url-pattern>
</servlet-mapping>

<servlet>
<servlet-name>sb</servlet-name>
<servlet-class>SearchBook</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>sb</servlet-name>
<url-pattern>/SearchBook</url-pattern>
</servlet-mapping>

<servlet>
<servlet-name>fee</servlet-name>
<servlet-class>Fee</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>fee</servlet-name>
<url-pattern>/Fee</url-pattern>
</servlet-mapping>

<welcome-file-list>
<welcome-file>index.html</welcome-file>
</welcome-file-list>
</web-app>

Next Link Program

Fee java File

import javax.servlet.http.*;
import java.sql.*;
import javax.servlet.*;
import java.io.*;
public class Fee extends HttpServlet
{
private Connection con;
private PreparedStatement ps=null;
public void init()throws ServletException
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","sysrem","system");
ps=con.prepareStatement("select *from AddBook where bookname=?");
}
catch(Exception e)
{
e.printStackTrace();
}

}
public void service(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException
{
response.setContentType("text/html");
PrintWriter out=response.getWriter();
try{
String fee=request.getParameter("fee");
if(fee==null||fee.equals(""))
{
out.println("<html><body>");
out.println("<li><i>enter the course</i></li><br/>");
out.println("</body></html>");
}
ps.setString(1,fee);
ResultSet rs=ps.executeQuery();
while(rs.next())
{
out.println("<html><body>");
out.println("<table border=1>");
out.println("<tr><td>rs.getString(1)<td>");
out.println("<td>rs.getString(2)</td>");
out.println("<td>rs.getString(3)</td>");
out.println("<td>rs.getString(4)</td>");
out.println("<tr><td>rs.getString(5)<td>");
out.println("<td>rs.getString(6)</td>");
out.println("<td>rs.getString(7)</td>");
out.println("<td>rs.getString(8)</td>");
out.println("</tr></table>");
out.println("</body></html>");
}
}
catch(Exception e)
{
}
}
public void destroy()
{
try{
con.close();
}
catch(Exception e)
{
}
}
}

Next Link Programe

AddBook java file

import javax.servlet.http.*;
import java.sql.*;
import javax.servlet.*;
import java.io.*;
public class AddBook extends HttpServlet
{
private Connection con;
private PreparedStatement ps=null;
public void init()throws ServletException
{
try
{ //we get the information from the web.xml file
ServletContext ctxt=getServletContext();
String driverclassname=ctxt.getInitParameter("driverclassname");
String url=ctxt.getInitParameter("url");
String dbuser=ctxt.getInitParameter("dbuser");
String dbpass=ctxt.getInitParameter("dbpass");
String sqlstmt=ctxt.getInitParameter("sqlstatement");
con=DriverManager.getConnection(url,dbuser,dbpass);
ps=con.prepareStatement(sqlstmt);
}
catch(Exception e)
{
e.printStackTrace();
}

}
public void service(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException
{
response.setContentType("text/html");
PrintWriter out=response.getWriter();
try{
String bookname=request.getParameter("bookname");
String auther=request.getParameter("auther");
String bookno=request.getParameter("bookno");
String desc=request.getParameter("desc");

ps.setString(1,bookname);
ps.setString(2,auther);
ps.setString(3,bookno);
ps.setString(4,desc);
int count=ps.executeUpdate();
if(count==1)
{
out.println("successfully added a book");
}
else
{
out.println("<html><body><h1> sorry try again</h1></body></html>");
}
}
catch(Exception e)
{
}
}
public void destroy()
{
try{
con.close();
}
catch(Exception e)
{
}
}
}

Next Link Program

UserLogin Java File

import javax.servlet.http.*;
import java.sql.*;
import javax.servlet.*;
import java.io.*;
public class UserLogin extends HttpServlet
{
private Connection con;
private PreparedStatement ps=null;
public void init()throws ServletException
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","sysrem","system");
ps=con.prepareStatement("select *from StudentRegForm where name=? and pass=?");
}
catch(Exception e)
{
e.printStackTrace();
}

}
public void service(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException
{
response.setContentType("text/html");
PrintWriter out=response.getWriter();
try{
String name=request.getParameter("name");
String pass=request.getParameter("pass");
if(name==null||name.equals("")||pass==null||pass.equals(""))
{
out.println("<html><body>");
out.println("<li><i>user name and pass word cnt be empty</i></li><br/>");
out.println("</body></html>");
}
ps.setString(1,name);
ps.setString(2,pass);
}
catch(Exception e)
{
out.println("<h2>un ble</h2>");
}
}
public void destroy()
{
try{
con.close();
}
catch(Exception e)
{
}
}
}
Next Link Program

StudentRegForm Java file

import javax.servlet.http.*;
import java.sql.*;
import javax.servlet.*;
import java.io.*;
public class StudentRegForm extends HttpServlet
{
private Connection con;
private PreparedStatement ps=null;
public void init()throws ServletException
{
try
{ //we get the information from the web.xml file
ServletContext ctxt=getServletContext();
String driverclassname=ctxt.getInitParameter("driverclassname");
String url=ctxt.getInitParameter("url");
String dbuser=ctxt.getInitParameter("dbuser");
String dbpass=ctxt.getInitParameter("dbpass");
String sqlstmt=ctxt.getInitParameter("sqlstatement");
con=DriverManager.getConnection(url,dbuser,dbpass);
ps=con.prepareStatement(sqlstmt);
}
catch(Exception e)
{
e.printStackTrace();
}

}
public void service(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException
{
response.setContentType("text/html");
PrintWriter out=response.getWriter();
try{
String sname=request.getParameter("sname");
String sid=request.getParameter("sid");
String pwd=request.getParameter("pwd");
String course=request.getParameter("course");
String email=request.getParameter("email");
String phone=request.getParameter("phone");
String addr=request.getParameter("addr");

ps.setString(1,sname);
ps.setString(2,sid);
ps.setString(3,pwd);
ps.setString(4,course);
ps.setString(5,email);
ps.setString(6,phone);
ps.setString(7,addr);
int count=ps.executeUpdate();
if(count==1)
{
out.println("successfully added a book");
}
else
{
out.println("<html><body><h1> sorry try again</h1></body></html>");
}
}
catch(Exception e)
{
}
}
public void destroy()
{
try{
con.close();
}
catch(Exception e)
{
}
}
}

Next Link Program

search a book

	<html>
	<head>
	<title>Search A Books</title>
	</head>

	<body bgcolor="#ffeebb">
	<div style="position:absolute;left:200;top:100;">
	<form name="sregform">
	<table border=0 bgcolor="#ffee33">
	<tr><td colspan="2"><center><h2>Search A Books</h2></center></td></tr>
	<tr><td>Book Name</td><td><input type="text" name="dur"></td></tr>
	<tR><td colspan="2"><center><button value="search">SEARCH</center></td></tr>
	</table>
	</form>
	</div>
	</body>
	</html> Next Link Program

add book to library

	<html>
	<head>
	<title>Add Books TO Library</title>
	</head>

	<body bgcolor="#ffeebb" action="./AddBook">
	<div style="position:absolute;left:200;top:100;">
	<form name="sregform">
	<table border=0 bgcolor="#ffee33">
	<tr><td colspan="2"><center><h2>Add New Books TO Library</h2></center></td></tr>
	<tr><td>Book Name</td><td><input type="text" name="bookname"></td></tr>
	<tr><td>Auther</td><td><input type="text" name="auther"></td></tr>
	<tr><td>Book No</td><td><input type="text" name="bookno"></td></tr>
	<tr><td>Description</td><td><textarea rows=4 cols=17 name="desc"></textarea></td></tr>
	<tR><td colspan="2"><center><button value="OK">OK</center></td></tr>
	</table>
	</form>
	</div>
	</body>
	</html> Next Link Program

get course details

	<html>
	<head>
	<title>Course</title>
	</head>
	<body bgcolor="#ffeebb" action="./Course">
	<div style="position:absolute;left:200;top:100;">
	<form name="">
	<table bgcolor="#ffee33">
	<tr><td colspan="2"><center><h2>Get Course Details</h2></center></td></tr>
	<tr><td>Course</td>
	<td>
	<select name="course">
	<option value="B.Tech">B.Tech</option>
	<option value="B.Sc">B.Sc</option>
	<option value="pharmacy">pharmacy</option>
	<option value="mca">MCA</option>
	<option value="mba">MBA</option>
	<option selected value="select course">select course</option>
	</select></td></tr>
	<tr><td colspan="2"><center><button>Get Details</button></center></td></tr>
	</table>
	</form>
	</div>
	</body>
	</html> Next Link Program

user login form

	<html>
	<head>
	<title>User Login</title>
	</head>

	<body bgcolor="#ffeebb" action="./UserLogin">
	<div style="position:absolute;left:200;top:100;">
	<form name="sregform">
	<table border=0 bgcolor="#ffee33">
	<tr><td colspan="2"><center><h2>User Login</h2></center></td></tr>
	<tr><td>Student Name</td><td><input type="text" name="name"></td></tr>
	<tr><td>PassWord</td><td><input type="text" name="pwd"></td></tr>
	<tR><td colspan="2"><center><input type="submit" value="login"></center></td></tr>
	</table>
	</form>
	</div>
	</body>
	</html> Next Link Programe

student reg form

	<html>
	<head>
	<title>student registration form</title>
	</head>

	<body bgcolor="#ffeebb" action="./StudentRegForm">
	<div style="position:absolute;left:200;top:100;">
	<form name="sregform">
	<table border=0 bgcolor="#ffee33">
	<tr><td colspan="2"><center><h2>Student Registration Form</h2></center></td></tr>
	<tr><td>Student Name</td><td><input type="text" name="sname"></td></tr>
	<tr><td>Student ID</td><td><input type="text" name="sid"></td></tr>
	<tr><td>Password</td><td><input type="text" name="pwd"></td></tr>
	<tr><td>Re-type pass word</td><td><input type="text" name="rpwd"></td></tr>
	<tr><td>Course</td><td><select name="course">
	<option value="B.Tech">B.Tech</option>
	<option value="B.Sc">B.Sc</option>
	<option value="pharmacy">Pharmacy</option>
	<option value="mca">MCA</option>
	<option value="mba">MBA</option>
	<option selected value="select course">select course</option>
	</select></td></tr>
	<tr><td>Email</td><td><input type="text" name="email"></td></tr>
	<tr><td>Phone</td><td><input type="text" name="phone"></td></tr>
	<tr><td>Address</td><td><textarea rows=4 cols=17 name="addr"></textarea></td></tr>
	<tR><td><input type="submit" value="REGISTER"></td><td><input type="reset"></td></tr>
	</table>
	</form>
	</div>
	</body>
	</html> Next Link Programe

Home Page

	<html>
	<head>
	</head>
	<frameset rows="20%,80%">
	<frame src="./log.html">
	<frameset cols="20%,60%,20%">
	<frame src="./sub.html">
	<frame src="./blank.html" name="mid">
	<frame src="./adds.html">
	</frameset>
	</frameset> </html> Next Link Programe

Spring

Saturday, October 1, 2011