Solve it

Home Answers Viewqa Java-Beginners Solve it

QuestionAsk Questions?

Ragini Shukla

Solve it
3 Answer(s) 3 years and 9 months ago
Posted in : Java Beginners

View Answers

August 26, 2009 at 1:42 PM

Hi Friend,

We have taken student_id=1.According to this id, we are retrieving the data.

1)DBOperation.java

package form;
import java.sql.*;
import java.util.*;

public class DBOperation
{
List dataList = new ArrayList();
Connection con;

public void connect() throws Exception{
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root";);
}
catch (ClassNotFoundException e) {
System.out.println(e);
}
}
public List getExamInfo()
{
try
{

Statement stmt = con.createStatement();
String query="select subject,marks,exam_date,exam_timing,exam_controller,exam_conducted_by,exam_supervision_by,percentage,remarks,exam_type from exam where student_id=1";
ResultSet rs=stmt.executeQuery(query);

while(rs.next())
{
dataList.add(rs.getString(1));
dataList.add(rs.getString(2));
dataList.add(rs.getString(3));
dataList.add(rs.getString(4));
dataList.add(rs.getString(5));
dataList.add(rs.getString(6));
dataList.add(rs.getString(7));
dataList.add(rs.getString(8));
dataList.add(rs.getString(9));
dataList.add(rs.getString(10));
}
}
catch(Exception e)
{
System.out.println(e);
}
return dataList;
}
}

August 26, 2009 at 1:46 PM

continue...

2)user.jsp:

<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<jsp:useBean id="test" class="form.DBOperation" />
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">

</style>
</head>
<body>
<form name="form" action="" method="post">
<table align="center" width="50%" border="0" cellspacing="10" cellpadding="0">
<tr>
<td height="30" valign="middle" bgcolor="#DA0C12"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="34%" align="center"><h3><span class="white_text"> Welcome to Binsys Technologies </span></h3></td>
<td width="16%" align="center" class="white_text"><a href="jsps/logout.jsp"> Logout</a></td>
</tr>
</table></td>
</tr>
<tr>
<td align="center" valign="top">
<table width="736" border="0" cellspacing="1" cellpadding="2">
<%test.connect ();
Object sub="";
Object mar="";
Object exam_da="";
Object exam_ti="";
Object exam_cont="";
Object exam_con="";
Object exam_supervision="";
Object percent="";
Object remark="";
Object exam_ty="";
Iterator itr;
List data= test.getExamInfo();
for (itr=data.iterator(); itr.hasNext(); ){
sub=itr.next();
mar=itr.next();
exam_da=itr.next();
exam_ti=itr.next();
exam_cont=itr.next();
exam_con=itr.next();
exam_supervision=itr.next();
percent=itr.next();
remark=itr.next();
exam_ty=itr.next();
}
String subject=sub.toString();
String marks=mar.toString();
String exam_date=exam_da.toString();
String exam_timing=exam_ti.toString();
String exam_controller=exam_cont.toString();
String exam_conducted_by=exam_con.toString();
String exam_supervision_by=exam_supervision.toString();
String percentage=percent.toString();
String remarks=remark.toString();
String exam_type=exam_ty.toString();
%>

August 26, 2009 at 1:47 PM

continue...........

<tr>
<td width="19%" align="left" bgcolor="#F4F4F4"><span class="style3">Exam Type</span></td>
<td width="26%" align="left" bgcolor="#F4F4F4"> <input type="text" name="exam_type" class="input" value="<%=exam_type%>"> </td>
<td width="25%" align="left" bgcolor="#F4F4F4">Subject</td>
<td width="30%" align="left" bgcolor="#F4F4F4"><input type="text" name="subject" class="input" value="<%=subject%>"> </td>
</tr>
<tr>
<td width="19%" align="left" bgcolor="#F4F4F4"><span class="style3">Exam Date </span></td>
<td width="26%" align="left" bgcolor="#F4F4F4"><input name="exam_date" type="text" class="input" value="<%=exam_date%>" /></td>
<td width="25%" align="left" bgcolor="#F4F4F4"><span class="style3">Exam Timing</span></td>
<td width="30%" align="left" bgcolor="#F4F4F4"><input name="exam_timing" type="text" class="input" value="<%=exam_timing%>" /></td>
</tr>
<tr>
<td width="19%" align="left" bgcolor="#F4F4F4"><span class="style3"> Marks</span></td>
<td width="26%" align="left" bgcolor="#F4F4F4"><input name="marks" type="text" class="input" value="<%=marks%>"/></td>
<td width="25%" align="left" bgcolor="#F4F4F4"><span class="style3">Exam Controller</span></td>
<td width="30%" align="left" bgcolor="#F4F4F4"><input name="exam_controller" type="text" class="input" value="<%=exam_controller%>"/></td>
</tr>
<tr>
<td align="left" bgcolor="#F4F4F4"><span class="style3">Exam Conduct By</span></td>
<td align="left" bgcolor="#F4F4F4"><input name="exam_conducted_by" type="text" class="input" value="<%=exam_conducted_by%>"/></td>
<td align="left" bgcolor="#F4F4F4"><span class="style3">Exam Supervision By</span></td>
<td align="left" bgcolor="#F4F4F4"><input name="exam_supervision_by" type="text" class="input" value="<%=exam_supervision_by%>"/></td>
</tr>
<tr>
<td width="19%" align="left" bgcolor="#F4F4F4"><span class="style3">Percentage</span></td>
<td width="26%" align="left" bgcolor="#F4F4F4"><input name="percentage" type="text" class="input" value="<%=percentage%>"/></td>
<td width="25%" align="left" bgcolor="#F4F4F4"><span class="style3">Remarks*</span></td>
<td width="30%" align="left" bgcolor="#F4F4F4"><TEXTAREA NAME="remarks" COLS=20 ROWS=6 ><%=remarks%></TEXTAREA>
</tr>
</body>
</html>

Hope that it will be helpful for you.
Thanks

Solve it
Solve it How to calculate the value which contains oparator and operand both using command line argument

solve this
solve this Create a student class. The student object should have studentid, studentname, subject and marks as properties. Also generate the getter and setter methods. Create 5 objects of this class and populate values

Solve

solve this pbm
solve this pbm its not working the code for databae access using servlets

how to solve
how to solve log4j:WARN No appenders could be found for logger (org.apache.struts.util.PropertyMessageResources). log4j:WARN Please initialize the log4j system properly

solve this pbm
solve this pbm sir rows are also inserting i have checked in the database also the rows are not affected in the table . The first pbm wich i have sent to you is not yet solved.......... pls give me detail explaination how we

how to solve this..
how to solve this.. Given a list of students and their marks Name | Science | Math | English | Computer Ahmad | 28 | 100 | 66 | 34 Samad | 56 | 89 | 55

solve this problem
solve this problem I typed this program and compiled.The program is compiled but when i eneterd url in tomcat server. Its not giving error but only blank page is coming the text is not displaying and row is also inserted

A Program To Solve In Java
A Program To Solve In Java x!/x+(x+2)!/x+(x+4)!/x ... (x+n)!/x

help me to solve this question
help me to solve this question Write a program that inputs a series of integers into an array. The numbers are in the range 0 to 100. Calculate and display : a) The Largest number b) The Smallest Number c)The sum of the numbers

please solve this program
please solve this program Build a package EMPPACK that contains one stored function Validatesal() and two stored procedures Insertemp() and Getempdetails().The Insert_emp() procedure inserts a particular employee

Solve Program - Java Beginners
Solve Program Write a progaram in java to display all odd number from 1 to 100 hi use this code package rajanikant.code.sep_2008; public class EvenOdd { public static void main(String s

help me to solve this question...
help me to solve this question... Given below is a class definition for Book. Type and compile the class, and answer the following questions: class Book { String title; //bookâ??s title double price; //bookâ??s

help me to solve this problem..
help me to solve this problem.. Given below is a class definition for Book. Type and compile the class, and answer the following questions: class Book { String title; //bookâ??s title double price; //bookâ??s price

plz solve my query?
plz solve my query? how to remove all the options from select control in html using java script? JavaScript remove all items <html> <script language="javascript" > function removeAllItems(selectbox

Solve it - Java Beginners
Solve it Hi Friends, Thanks for continue reply.. I have some query please solved...its urgent.. I have two table,emp,exam.both have e... is write here. no information display in the jsp file please solve it and let me

Solve this problem plzzz
Solve this problem plzzz Prashant.jsp (this is my JSP file) <HTML> <HEAD> <TITLE>Login using jsp <BODY>... kindly help me and check all those files and solve my problem as soon as possible

solve it - Java Beginners
solve it Hi friend, I want to use switch case in jsp please let me know how to call page in jsp using include tag i want call this file using include tag please help me use switch statement in jsp

ArrayList question plz solve it
ArrayList question plz solve it An arraylist object stores an Emp Object, where there is name,age,address of the employee is stored, And i want to access the data in the basis of age based? Provide answer to the question

Solve my code
Solve my code import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; import java.io.*; public class ChangeDetails extends HttpServlet{ public void doPost(HttpServletRequest request,HttpServletResponse

to solve the error - Java Beginners
to solve the error class bubbleSort1{ public static void bubbleSort(int[] x) { int n = x.length; for (int pass=1; pass < n; pass++) { // count how many times // This next loop becomes shorter and shorter for (int i=0

help me to solve this question
help me to solve this question A user needs to key in data into system in order to save data into array. The data are: a. Lecturer ID, Lecturer name, School, course code, course name, session, semester A user can edit the data

solve my question shortly
solve my question shortly <html> <head> <script> function checkphoneNumber(number){ if(/[^\d ]/.test(number)){ alert('It should contain numbers [0-9] only!'); document.getElementById

I couldn't solve it
I couldn't solve it *A customer who wants to apply for getting a car license should provide information about the brand of the car. *Then the customer receives a request ID from the office. *The customer's request (represented

How to solve the Hibernate Common Exceptions?
How to solve the Hibernate Common Exceptions? How to solve the Hibernate Common Exceptions

plz help meto solve this question
plz help meto solve this question for a file that exist what will be the length() method in the file class return

i dont no how to solve it pls
i dont no how to solve it pls Calculate and display the sum of all prime number from 1 to 100 covert in java system codes

how to solve an internet connection problem
how to solve an internet connection problem when i run my application it give me this error: Exception in thread "AWT-EventQueue-0" java.lang.UnsupportedOperationException: Not yet implemented the problem is that i don`t know

can interface solve this problem in java
can interface solve this problem in java I have a JDialog which displays the calendar [from 2010-2020], i created this in a different class... this calander class. can interface solve this problem. If yes then how. pls

Please Help To Solve My Problem
Please Help To Solve My Problem PHP I Have 6 Textbox and 1 ok button. 6 Textbox to Add the 6 Team Name. Each Team Name In String(Like- A,B,C,D,E,F... With B Team when A Team Play With B Team Again Then Generate Error. I Am Solve

how to solve this problem for oracle connectivity
how to solve this problem for oracle connectivity Exception in thread "main" java.sql.SQLException: Io exception: The Network Adap ter could not establish the connection

i need help to solve this problem
i need help to solve this problem Write a stack class ArrayStack.java implements PureStack interface that reads in strings from standard input and prints them in reverse order. and Show step by step what queue will look like

How to Solve the Syntax Error in java??
How to Solve the Syntax Error in java?? Syntax error in java? i have tried this program its showing error like this in Eclipse "Syntax error on token "i", VariableDeclarator expected after this token" . in last line

how do i solve this problem?
how do i solve this problem? Define a class named Circle with the following properties: List item An integer data field named radius with protected access modifier, and a String data field named colour with private access

how do i solve this question?
how do i solve this question? 1.Define a class named Circle with the following properties: a) An integer data field named radius with protected access modifier, and a String data field named colour with private access modifier

plz anyone can solve my
plz anyone can solve my creat an applet prog which accepts the details of 10 customers like name , address , city , ect. and display it import java.awt.*; import javax.swing.*; import java.awt.event.*; import

Solve using only Javascript loops...
Solve using only Javascript loops... Write a JavaScript code, 1) to find a number of unique letters in string. (Eg. if keyword is unique, Unique count will be '4') 2) so that numbers appear in following format, 1 1 2

ajax code please help to solve this........
ajax code please help to solve this. in this i am trying to get data from datbase and put it in combo box and then display it down using table and use ajax onchange but when i am trying to do so it show some error

Simple problem to solve - JSP-Servlet

how should i can solve

please solve this error Warning: mail() [function.mail]:
please solve this error Warning: mail() [function.mail]: please solve this error Warning: mail() [function.mail]: "sendmail_from" not set in php.ini or custom "From:" header missing

write a java program to solve the infix expression
write a java program to solve the infix expression ==>> solve the below expression using java program: 2+5*2-5+6/2 using stack operations or any other process in java

plz solve this program - Java Interview Questions
plz solve this program write a program to out put this resault using two dimensional array this is an image of the reasult: http://www.4shared.com/file/154846107/dc2f1ac1/_2__Untitled-1.html so help me

need to solve the below question - Java Beginners
need to solve the below question I need to write an application that uses the circle class.it must read a radius of a circle from the user .create a circle object and return the object

Small Bug How to solve in my code
Small Bug How to solve in my code String season=""; pst = con.prepareStatement("SELECT DISTINCT(Season) season FROM specialdates where Regid...") + ","; it shows bug in findbugs tool.. but it executes successfully how to solve

OCI Connectivity For Oracle Plz Solve This Error
OCI Connectivity For Oracle Plz Solve This Error import java.io.*; import java.sql.*; import java.lang.*; import oracle.jdbc.OracleDriver; public...) { e.printStackTrace(); } } } ---> I found Error below how i can solve this error plz

help me about to solve my qustion
help me about to solve my qustion An employee receives 15 SR per hour for the first 8 hours of week. After 8 hours (overtime) his rate becomes 20 SR per hour . Write a java class that ask a user to enter the number of hours he

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics