Ignou Solved Assignment And Projects @nisecomputers-blog - Tumblr Blog

how to create procedure in php

How to create function In MySQL

What is the code to prove an original phone? To enter the following codes, simply open the phone's Phone application and enter each one:...

Hindi Review

Win 10 Bluetooth Earphones powered by TAGG in 3rd Giveaway 2017 @sharmajitech @sharmajitechnical

#smartphone giveaway

Like, Share and Tweet about this to win Smartphone and VR Headsets

Giveaway Announcement - Ye Sharmaji ka ek chota sa prayaas hai, aapko return gift dene ka. Jitna support aapne kiya hai hume, uske liye aapko hamari tara...

Like, Share and Tweet about this to win Smartphone and VR Headsets

#vr giveaway

My mom and dad also bhatija

pantheonbooks

November comes And November goes, With the last red berries And the first white snows. With night coming early, And dawn coming late, And ice in the bucket And frost by the gate. The fires burn And the kettles sing, And earth sinks to rest Until next spring.

Clyde Watson (via pantheonbooks)

How to displays a web page containing detailed Bio-Data of you using JSP page

info.JSP

<%@page language="java" import="java.io.*,java.util.*"%>

<html>

<head>

<title>Information</title>

</head>

<body>

<a href="academic.jsp" > click here to view academic Information</a>

</form>

</body>

</html>

academic.JSP

3. Personal.java

import java.io.*;

import java.text.*;

import java.util.*;

import javax.servlet.*;

import javax.servlet.http.*;

public class Personal extends HttpServlet {

public void doPost(HttpServletRequest req,HttpServletResponse res)

throws ServletException,IOException{

String name = req.getParameter("user");

PrintWriter out = res.getWriter();

out.println("<html>");

out.println("<head>");

out.println("<title>Personal Info</title>");

out.println("</head>");

out.println("<body>");

out.println("<h1>Personal Information </h1>");

out.println("<h1>Name: N Y Abhay </h1>");

out.println("<h1>Clss: Pre-Nursery </h1>");

out.println("<h1>Address: Bangalore </h1>");

out.println("</body>");

out.println("</html>");

}

academic.jsp

<%@page language="java" import="java.io.*,java.util.*"%>

<html><head><title>ASCII Conversion</title></head>

<body>

<form>

<br>

Name :<input type=’text’name=’OutputChar’value=’Abhay’>

<br>

Qualification :<input type=’text’name=’OutputChar’value=’MTech, MBA’>

<br>

</form></body></html>

<?xml version="1.0" encoding="ISO-8859-1"?>

<web-app xmlns="http://java.sun.com/xml/ns/j2ee"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee

http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"

version="2.4">

<servlet-name>hello</servlet-name>

<servlet-class>Personal</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>hello</servlet-name>

<url-pattern>/Personal</url-pattern>

</servlet-mapping>

</web-app>

Write a Program using Servlet and JDBC for developing online application for displaying the details of Cars owned by the residents in XYZ society.

Run in SQL

CREATE TABLE Student

( student_id INT NOT NULL AUTO_INCREMENT, student_name VARCHAR(25), student_enrol VARCHAR(10), student_add VARCHAR(70), student_prog VARCHAR(10), student_prog_start VARCHAR(5), student_prog_end VARCHAR(5), PRIMARY KEY(student_id) );

CREATE TABLE Course ( course_id INT NOT NULL AUTO_INCREMENT, course_code VARCHAR(10), course_name VARCHAR(20), course_prog VARCHAR(10), PRIMARY KEY(course_id) );

CREATE TABLE Result ( ID INT NOT NULL AUTO_INCREMENT, course_code VARCHAR(10), student_id VARCHAR(10), marks_assign_got VARCHAR(5), marks_pract_got VARCHAR(5), marks_theory_got VARCHAR(5), result_status VARCHAR(10), PRIMARY KEY(ID), FOREIGN KEY(course_code,student_id,marks_assign_got,marks_pract_got,marks_theory_got) REFERENCES Course (course_code) ,Student(student_id),Marks(marks_assign_got,marks_pract_got,marks_pract_got) );

Java Editor use for Result Servlet Code

package ignou;

import java.io.*;

import java.sql.*;

import java.util.*;

import javax.servlet.*;

import javax.servlet.http.*;

import java.net.URL;

public class Result extends HttpServlet {

public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {

res.setContentType("text/html");

PrintWriter out = res.getWriter();

out.println("<HTML><HEAD><TITLE>IGNOU MCA TEE Result:::</TITLE>");

out.println("</HEAD>");

out.println("<BODY >");

out.println("<P align=center>MCA TEE Result</P>");

out.println("<TABLE align=center border=1 width=\"65%\">");

Connection con=null;

Statement stm = null;

try{

Class.forName("org.gjt.mm.mysql.Driver");

String dbURL="jdbc:mysql://localhost/MCA";

String username="root";

String password="";

con=DriverManager.getConnection(dbURL,username,password);

stm=con.createStatement();

ResultSet rs=stm.executeQuery("SELECT student_name,course_code,marks_assign_got,marks_theory_got,marks_pract_got,result_status FROM Student,Result WHERE Result.student_id =Student.student_id");

while(rs.next()) //retreive all the records into the table

{

out.println("<TR>");

out.println("<TD>Name</TD><TD>" + rs.getString("student_name") + "</TD></TR>");

out.println("<TR><TD>Course code</TD><TD>" + rs.getString("course_code") + "</TD></TR>");

out.println("<TR><TD>Assignments marks</TD><TD>" + rs.getString("marks_assign_got") + "</TD></TR>");

out.println("<TR><TD>Theory marks</TD><TD>" + rs.getString("marks_theory_got") + "</TD></TR>");

out.println("<TR><TD>Practical marks</TD><TD>" + rs.getString("marks_pract_got") + "</TD></TR>");

out.println("<TR><TD>Result</TD><TD>" + rs.getString("result_status") + "</TD>");

out.println("</TR>");

rs.close();

stm.close();

con.close();

}}catch(Exception e){

out.println(e.getMessage());

}

out.println("<P> </P></FONT></BODY></HTML>");

}

#a Program using Servlet and JDBC for developing online application for displaying the details of Cars owned by the residents in XYZ society.#ignou #mca #MCS 051

Courses-availalbe-Certificate-Pro-January-and-July-ACISE on Flickr.

#ignoucourse #ignou #solved #assignment #project #bca #mca

Trending Blogs

Recently Viewed Blogs

Ignou Solved Assignment And Projects