Sunday, 14 October 2018

Forgot Password

Form 8 code

Option Explicit

Private Sub Command1_Click()
Module1.retdata ("select upass from Admin where uname='" & txtuname.Text & "' and sans='" & Text1.Text & "'")
If rs.RecordCount > 0 Then
MsgBox ("Your Password Is" & rs.Fields(0).Value)
MsgBox ("Wrong Answer")
End If

End Sub

Private Sub Form_Load()

End Sub

Private Sub txtuname_LostFocus()
Module1.retdata ("select sques from Admin where uname='" & txtuname.Text & "'")
If Not rs.EOF Then
lblq.Caption = rs.Fields(0).Value
MsgBox ("No Such User")
End If

End Sub

Saturday, 21 July 2018

VB6 Projects / Visual Basic Projects / TYBCA Projects / Projects for BCA

Here is the list of VB6 projects that you can refer to decide your academic project.

We at NR Classes Recommend students to do work on their own ideas which will make difference and definitely students will get more knowledge and confidence in that language.

Our Second Project Batch starting soon register your name as soon as possible. 

Call  9730381255


1) Blood bank management
2) Mobile Store Management
3) Attendance System
4) Hospital Management System
5) Library management System
6) Coffee Shop Management
7) Tours and Travel
8) Medical Store Manager
9) Electronic inventory  Management System
10) Examination system
11) Cafe Management System
12) Event Management
13) Society Management
14) Criminal File
15) Human Resource management
16) Placement Organizer
17) Coaching class management
18) Gym Management System
19) Employee Payroll
20) Quiz Application
21) RTO Exam Practice System
22) Painting Auction 
23) Pizza Order and Billing System
24) Gurukul
25) Marklist Generation
26) Result Analysis
27) College Club Management System
28) Agri Chemicals and Nursery Management System
29) Real Estate Management
30) Event Manager
31) Football and tournament mangement
32) School Health Care Management System
33) Cosmetics Inventory Management
34) Cateering management system
35) Cyber Cafe Management
36) Laptop stock maintenance system
37) Bike showroom management system.
38) Health club management system
39) Gas agency management 
40) The cake shop management 
41) Airline Reservation system
42) Campus Selection System
43)  Cab Service Management
44) Hotel Management System
45)  Shoe Shop and Billing Management System
46) Jewellery Shop Management SYstem
47) Electronic Shop Inventory System
48) Hostel Management System
49)  Institute Management System
50) Doctors Q'up
51) Construction Chemicals Store Management system
52) Mobile Shop Management System
53) Examination Management System
54) College Time Table Manager
55) Camera Rental Home
56) Venue to Menu
57) Substitute Medical checker
58) Street Food Counter 
59) Patients History
60) Doctors Appointment manager
61) Book Shop Management Ststem
62) Rental Laptop House
63) Electronics Store Management
64) Examination Practice System
65) Project Tracker
66) Employee Payroll Management System
67) Medico Inventory Management System
68) Pathology Management System
69) Apartment Management System
70)   Stationary Shop Management System
71) Computer and Peripheral Shop Management System
72) Nursing Home Management System
73) Pizza Hut Billing System
74) Cyber Cafe Management System
75) Taxi Service Management System
76) Hostel Management System
77) Courier Management System
78) RTO Practice Exam System
79) Marriage Match
80) Car Rental System
81) Vehicle Care
82)  Human Resource Managmeent System
83) Coaching Class Management System
84) Transport Management System
85) Painting Auction
86) Art Gallary Management
87) Automobile Service Center Management  System
88) Real Estate Management
89) Cake Shop Management
90) Footwear Shop Management
91) Hall Management System
92) Visitors Log ( for Societies / Apartments )
93) OldAge Home Manager
94) GST Calculator
95) Career Consultant  Office Manager
96) Company Purchase Handler
97) General Store Management and Billing with GST
98) Village Development and employment of Youths
99) Health Club Management
100) Cosmetic product Management


                                        Call On 9730381255 for Project HELP!!       

Saturday, 17 March 2018

Upload File In Mysql Database using JSP and Servlet


1. Servlet APT 3.x.x
 Otherwise through exceptions for getPart Method

2. Mysql Connector-5.1.x
Otherwise through exception for setBlob Method instead we use setBinaryStream

Create Three Files and Table in the Database

1. Upload.jsp (servlet File)

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>File Upload to Database Demo
        <h1>File Upload to Database Demo

        <form method="post" action="FileUploadDBServlet" enctype="multipart/form-data">
            <table border="0">
                    <td>Photo: </td>
                    <td><input type="file" name="photo" size="50"/></td>
                    <td colspan="2">
                        <input type="submit" value="Save">

2. FileUploadDBServlet

//package net.codejava.upload;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.annotation.MultipartConfig;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.Part;
import javax.servlet.*;
@MultipartConfig(maxFileSize = 16177215)    // upload file's size up to 16MB

public class FileUploadDBServlet extends HttpServlet

        // database connection settings
        private String dbURL = "jdbc:mysql://localhost:3306/imageupload";
        private String dbUser = "root";
        private String dbPass = "rsb";

        protected void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException
//            // gets values of text fields
//            String firstName = request.getParameter("firstName");
//            String lastName = request.getParameter("lastName");

            InputStream inputStream = null; // input stream of the upload file

            // obtains the upload file part in this multipart request
            Part filePart = request.getPart("photo");
            if (filePart != null) {
                // prints out some information for debugging

                // obtains input stream of the upload file
                inputStream = filePart.getInputStream();

            Connection conn = null; // connection to the database
            String message = null;  // message will be sent back to client

            try {
                // connects to the database
//                //DriverManager.registerDriver(new com.mysql.jdbc.Driver());
//                Class.forName("com.mysql.jdbc.Driver");
//                conn = DriverManager.getConnection(dbURL, dbUser, dbPass);
                }catch(Exception e){System.out.println(e);}

                // constructs SQL statement
                String sql = "INSERT INTO imageup (imagep) values (?)";
                PreparedStatement statement = conn.prepareStatement(sql);
                //statement.setString(1, firstName);
                //statement.setString(2, lastName);

                if (inputStream != null) {
                    // fetches input stream of the upload file for the blob column
                    statement.setBinaryStream(1, (InputStream)inputStream,100000);

                // sends the statement to the database server
                int row = statement.executeUpdate();
                if (row > 0) {
                    message = "File uploaded and saved into database";
            } catch (SQLException ex) {
                message = "ERROR: " + ex.getMessage();
            } finally {
                if (conn != null) {
                    // closes the database connection
                    try {
                    } catch (SQLException ex) {
                // sets the message in request scope
                request.setAttribute("Message", message);

                // forwards to the message page
                getServletContext().getRequestDispatcher("/Message.jsp").forward(request, response);

3. Message.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">


create table imageup(image longblog);