Posted by TechBlogger on 1:05 PM
<!DOCTYPE html><html lang="en"><head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Income Tax Calculator</title> <style> body { font-family: Arial, sans-serif; text-align: center; margin: 50px; } .container { max-width: 400px; margin: auto; padding: 20px; border: 1px solid...
Posted by TechBlogger on 7:43 PM
Setting value to OD variables in Servlet node:
mySession.getVariableField(IProjectVariables.C__COUNTS,IProjectVariables.C__COUNTS_FIELD_MAXNI).setValue("");
Writing trace info
TraceInfo.trace(ITraceInfo.TRACE_LEVEL_INFO,this.getClass().getName() + " -> Value - " + mySession.getVariableField("OD", "OD_complex").getStringValue(), mySession);
...
Posted by TechBlogger on 7:39 PM
Configure below properties to configure Rolling and set limit to file size and index limit of ddlog4j library properties
log4j.appender.Rapp=org.apache.log4j.RollingFileAppender
log4j.appender.Rapp.File=C:/xx/logs/app/data/log/report.log
log4j.appender.Rapp.MaxFileSize = 10MB
log4j.appender.Rapp.MaxBackupIndex = 5
log4j.appender.Rapp.DatePattern='.'yyyy-MM-dd
log4j.appender.Rapp.layout=org.apache.log4j.PatternLayout
log4j.appender.Rapp.layout.ConversionPattern=%d{dd/MM/yyyy HH:mm:ss:SSS} %5p - %m%n
log4j.appender.Rapp.Encoding=UTF...
Posted by TechBlogger on 4:37 PM
Making JDBC Query to database using code
Connection conn=null;
ResultSet rs1=null;
try
{
PreparedStatement ps1=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection( "jdbc:oracle:thin:@127.0.0.1:1521:XE", "system", "manager");
Statement stmt = conn.createStatement();
rs1= stmt.executeQuery("select SUBJECT from HR.SUBJECT ");
}
catch(SQLException e)
{
while((e = e.getNextException()) != null) out.println(e.getMessage() + "");
}
catch(ClassNotFoundException e)
{
}
Reading the ResultSet
try{
while(rs1.next()){
String ComboBoxValue1=rs1.getString("SUBJECT") ;
}
...
Posted by TechBlogger on 4:37 PM
Making JDBC Query to database using code
Connection conn=null;
ResultSet rs1=null;
try
{
PreparedStatement ps1=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection( "jdbc:oracle:thin:@127.0.0.1:1521:XE", "system", "manager");
Statement stmt = conn.createStatement();
rs1= stmt.executeQuery("select SUBJECT from HR.SUBJECT ");
}
catch(SQLException e)
{
while((e = e.getNextException()) != null) out.println(e.getMessage() + "");
}
catch(ClassNotFoundException e)
{
}
Reading the ResultSet
try{
while(rs1.next()){
String ComboBoxValue1=rs1.getString("SUBJECT") ;
}
...
Posted by TechBlogger on 12:34 PM
In this post we will illustrate how to Search and display information from database.
This post is continued from previous post have a look on how to do:
1. Database settings and Insetion of data into SQL database.
2. Searching information from Database
3. Deleting informstion from database
Create a html form upinfo.html
<html>
<head>
<h1><u>student form</u></h1>
</head>
<body bgcolor="DarkSalmon">
<form name=Student method=POST action=http://localhost:8080/examples/servlet/upinfo>
<font face="Copperplate Gothic Bold">STUDENT NAME</font face>:<input type="text" name="t1"...
Posted by TechBlogger on 12:30 PM
In this post we will illustrate how to delete information from database.
This post is continued from previous post have a look on how to do:
1. Database settings and insetion of data into SQL database.
2. Searching information from database.
Create a html form delinfo.html
<html>
<head>
<h1><u>student form</u></h1>
</head>
<body bgcolor="DarkSalmon">
<form name=Student method=POST action=http://localhost:8080/examples/servlet/delinfo>
<font face="Copperplate Gothic Bold">ID</font face>:<input type="text" name="t2" size="30"><p><br>
<br>
<input type="submit"...
Posted by TechBlogger on 12:24 PM
In this post we will illustrate how to Search and display information from database.This post is continued from previous post have a look on how to do:
1. Database settings & Insetion of data into SQL database.
Create a HTML page named searchinfo.html
<html>
<head>
<h1><u>student form</u></h1>
</head>
<body bgcolor="DarkSalmon">
<form name=Student method=POST action=http://localhost:8080/examples/servlet/searchinfo>
<font face="Copperplate Gothic Bold">ID</font face>:<input type="text" name="t2" size="30"><p><br>
<br>
<input type="submit" value="submit">
</form>
</body>
</html>
Now...
Posted by TechBlogger on 12:18 PM
Unlike JSP and PHP Servlet is also server side scripting language. Servlet is Java based, Here this post we are going to illustrate how to add, delete , update and Search data from a form interacting with SQL database.
For consideration we will need tomcat server installed running on the system by default at port 8080 and sql database running on the system.
STEP 1:
Create database in Microsoft sql Query analyser .
Create table with 4 fields viz StudentName , ID , Age and Branch.
->Keep ID as INT and set it as primary key
->keep StudentName as VARCHAR(100)
->keep age as INTEGER
->Keep Branch as VARCHAR(100)
STEP 2 :
This...
Posted by TechBlogger on 8:00 PM
searchstud.jsp
<%@page session="true"import="java.io.*"%>
<html>
<body bgcolor="#d0d0d0">
<br></br>
<br></br>
<br></br>
<h2><center>enter stuent details</center></h2>
<form name="searchstud"action="searchstudinfo.jsp"method="post">
<table border="2"align=center>
<tr><td>
<b>enter the id u want to search:</b>
<input type="text"name="id"/>
<br/>
<br/>
</td></tr>
</table>
<center>
<input type="submit"value="submit"/>
<input type="reset"value="reset"/>
</form>
</body>
</html>
searchstudinfo.jsp
<%@page...
RSS Feed
Twitter
