Comments by Member 14639038 (Top 51 by date)

can you help me in this . please suggest another solution

for(Discom records:AdminPanel) // this is the line refering to line 46

NO ! it doesn't solve the issue

it was wrongly typed.
It is showData()method that is being implemented

bt still it is not working

i have used the jdbc code on the jsp

i have changed the code:

<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.util.Iterator"%>
<%@page import="com.rec.model.States"%>
<%@page import="org.hibernate.query.Query"%>
<%@page import="org.hibernate.SessionFactory"%>
<%@page import="org.hibernate.Session"%>
<%@page import="java.io.Console"%>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@page isELIgnored="false"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>





function showValue()
{

var e = document.getElementById("state");
var value=e.selectElement.options[e.selectedIndex].value;// get selected option value
var text=e.options[e.selectedIndex].text;//get the selected option text
alert(value);
}
showValue();





<script
src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js"
="" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous">
<script
src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js"
="" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous">




<title>Admin






.color {
background-color: #6595BA;
}

.alt {
background: #AFD5F2;
}

table td {
border-bottom: 2px solid #1c46a8;
border-right: 1px solid #1c46a8;
padding: 8px 6px;
vertical-align: top;
display: table-cell;
text-transform: uppercase;
}

tr:nth-child(even) {
background-color: #d9ecfe !important;
}

table th {
border-bottom: 2px solid #1c46a8;
border-right: 1px solid #1c46a8;
padding: 12px 6px;
vertical-align: top;
font-weight: bold;
text-transform: uppercase;
background: #003466;
color: #fff;
text-align: center;
}

tr:hover, .tr:nth-child(even):hover {
background: #bfddfa !important;
}

tr:nth-child(odd) {
background-color: #ebf5ff;
}

.table {
margin-right: 12%;
}





Logout










State:




<%
try
{
String query="select * from states";
Class.forName("com.mysql.cj.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/demp5?SslMode=none", "root", "root");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
while(rs.next())
{
int id = rs.getInt("stateId");

String StateName = rs.getString("state");
%>
"
<%
if(request.getParameter("state")!=null)
{
if(id==Integer.parseInt(request.getParameter("state")))
out.print("selected");
}
%>
><%=StateName%>


<%
}
}

catch(Exception ex)
{
ex.printStackTrace();
}
%>







Discom:

<%
try
{
Class.forName("com.mysql.cj.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/demp5?SslMode=none", "root", "root");
String query="select * from statediscom where stateId=?";
PreparedStatement pst= con.prepareStatement(query);
pst.setString(1, request.getParameter("state"));
ResultSet rs = pst.executeQuery();
while(rs.next())
{

%>
"><%=rs.getString("name") %>
<%
int id = rs.getInt("stateId");

pls help me

State:

when i click this button i got no response .

by USING HIBERNATE , i HAVE FOUND SAME PROBLEM.
NO ERRORS,EXCEPTION .
I AM posting code:

HibernateUtil.java----->

package com.mvc.util;

import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

public class HibernateUtil {
private static SessionFactory sessionfactory=null;
static
{
try
{
sessionfactory = new Configuration().configure("/com/mvc/resources/hibernate.cfg.xml").buildSessionFactory();

}
catch (Throwable ex) {
// Log the exception.
System.err.println("Initial SessionFactory creation failed." + ex);
throw new ExceptionInInitializerError(ex);
}
}

public static SessionFactory getSessionFactory() {
return sessionfactory;

}
}



BoqDaoImpl.java-------->

package com.mvc.dao;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.mvc.bean.BOQ;
import com.mvc.dao.BoqDao;
import com.mvc.util.HibernateUtil;

public class BoqDaoImpl implements BoqDao{

@Override
public void updateBoqData(String hsnCode, String hsnCode_Confirmed, String gstRate, String gstRate_Confirmed,
String itemDescription, String uNit, String qTy, String p1, String W1, String v1, String ID1) {
// TODO Auto-generated method stub
Session session = HibernateUtil.getSessionFactory().openSession();
Transaction transact = session.beginTransaction();
BOQ boq = (BOQ)session.load(BOQ.class, ID1);
boq.setHsn_code(hsnCode);
boq.setIs_hsnConfirmed(hsnCode_Confirmed);
boq.setGst_rate(gstRate);
boq.setIs_gstRate_confirmed(gstRate_Confirmed);
boq.setItem_Description(itemDescription);
boq.setUnit(uNit);
boq.setQty(qTy);
boq.setP(p1);
boq.setW(W1);
boq.setV(v1);
session.update(boq);
transact.commit();
session.close();
}

}

BoqDao.java----------->
package com.mvc.dao;

public interface BoqDao {
public void updateBoqData (String hsnCode,String hsnCode_Confirmed,String gstRate,String gstRate_Confirmed,String itemDescription, String uNit,String qTy,String p1, String W1,String v1,String ID1);
}


BoqController.java------>

package com.mvc.controller;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.mvc.bean.BOQ;
import com.mvc.dao.BoqDao;
import com.mvc.dao.BoqDaoImpl;

@WebServlet("/boqController")
public class BoqController extends HttpServlet{
BOQ bo = new BOQ();
BoqDaoImpl boqDaoimpl = new BoqDaoImpl();
public static BoqDao boqDao=null;
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
PrintWriter out = response.getWriter();
String hsn = request.getParameter("HSNCode");
String hsnCode_confirmed = request.getParameter("HsnCode_Confirmed");
String gst_rate = request.getParameter("GStRate");
String gstRate_Confirmed = request.getParameter("GSTRate_Confirmed");
String item_description = request.getParameter("item_Description");
String _unit = request.getParameter("UNIT");
String Quantities = request.getParameter("quantities");
String P2 = request.getParameter("P1");
String W3 = request.getParameter("W2");
String V3 = request.getParameter("V2");
RequestDispatcher rd = request.getRequestDispatcher("jkpddReport.jsp");
rd.forward(request, response);


}
}


EditBoq.jsp------->

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>




<title>Edit BOQ

Update BOQ

but it is also not working

what's the syntax error in my code

bt when i add this catch block below:
catch (NullPointerException e) {
//e.printStackTrace();
e.getStackTrace();
out.println("stack trace"+e.getMessage());
out.println("\n localized message"+e.getMessage());
// TODO: handle exception
}
then nothing displayed on page

k ! sir ! i will try it .
but i want both formats to be accept.
bt how i can do it

"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" this mime type is not wrking for both .xls and .xlsx

i have not idea about that

what will be the mime type for excel with .xslx and .xls both

i know this is due to mime extension

please send me sir the links .

i mean to say that i am not getting any idea about the issue going on???????

I ameans thati am not getting idea !

i have tried it but i am not able to do it

this is my studentsbean class:
package dbUtils_impl;

public class StudentsBean {
private int id;
private String stud_name, mob_no,Addr,Stream,pass_yr,percentage, userName,pass;
public int getId() {
return id;
}
public String getStud_name() {
return stud_name;
}
public String getMob_no() {
return mob_no;
}
public String getAddr() {
return Addr;
}
public String getStream() {
return Stream;
}
public String getPass_yr() {
return pass_yr;
}
public String getPercentage() {
return percentage;
}
public String getUserName() {
return userName;
}
public String getPass() {
return pass;
}
public void setId(int id) {
this.id = id;
}
public void setStud_name(String stud_name) {
this.stud_name = stud_name;
}
public void setMob_no(String mob_no) {
this.mob_no = mob_no;
}
public void setAddr(String addr) {
Addr = addr;
}
public void setStream(String stream) {
Stream = stream;
}
public void setPass_yr(String pass_yr) {
this.pass_yr = pass_yr;
}
public void setPercentage(String percentage) {
this.percentage = percentage;
}
public void setUserName(String userName) {
this.userName = userName;
}
public void setPass(String pass) {
this.pass = pass;
}


}

i have not idea

when i written this lines:
int rows = my_worksheet.getLastRowNum();
short cols = row.getLastCellNum();
System.out.println("no. of cols"+cols);
it returns me 22 columns whereas in my excel has 30 columns

no sir

but i have set the cells to string format

but i have set the values for 29 parameters.

i have tried this:
while(cellIterator.hasNext()) {
Cell cell = cellIterator.next();
if(row.getCell(1)==null)
{
months = null;
}
else
{
pstmt.setString(1, cell.getStringCellValue());
}

if(row.getCell(2)==null)
{
_adverExpenses = 0;
}
else
{
pstmt.setDouble(2, cell.getNumericCellValue());
}

if(row.getCell(3)==null)
{
_photocopy=0;
}
else
{
pstmt.setDouble(3, cell.getNumericCellValue());
}
if(row.getCell(4)==null)
{
_swachBharatExpenses = 0;
}
else
{
pstmt.setDouble(4, cell.getNumericCellValue());
}

if(row.getCell(5)==null)
{
_postageCourierExpenses = 0;
}
else
{
pstmt.setDouble(5, cell.getNumericCellValue());
}
if(row.getCell(6)==null)
{
_meetingConference = 0;
}
else
{
pstmt.setDouble(6, cell.getNumericCellValue());
}

if(row.getCell(7)==null)
{
_manpowerExpensesContact=0;
}
else
{

pstmt.setDouble(7,cell.getNumericCellValue());
}
if(row.getCell(8)==null)
{
_manpowerFlexi_staffTour=0;
}
else
{
pstmt.setDouble(8, cell.getNumericCellValue());
}
if(row.getCell(9)==null)
{
_salary_FTS = 0;
}

else
{
pst

i am not able to to do ! atleast pls guide me

sir i have modified code using jasper report bt it's not generating the pdf from .jrxml format. i have written the following code;
package com.mvc.jasperToPDF;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.HashMap;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.mvc.util.DBConnection;

import net.sf.jasperreports.engine.JRDataSource;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JRField;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperExportManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;

@WebServlet("/pdf2")
public class SaveAs_Pdf extends HttpServlet {
public static final String jrxmlPath="com/mvc/resources/boq_report.jrxml";
public static JasperReport jasper_report=null;
public static JasperPrint jasperPrint = null;
public static Connection conn=null;

//public static final String query="select"
protected void doGet(HttpServletRequest request , HttpServletResponse response) throws IOException,ServletException
{
try
{
response.setContentType("application/pdf");
conn = DBConnection.createConnection();
HashMap jasperParameter = new HashMap();
jasper_report = JasperCompileManager.compileReport(jrxmlPath);
jasperPrint = JasperFillManager.fillReport(jasper_report,jasperParameter,conn);
JasperExportManager.exportReportToPdfFile(jasperPrint, "C://sample_report.pdf");
conn.close();

}
catch (Exception e) {
System.out.println(e.getMessage());

// TODO: handle exception
}




}


}

how to convert that html output into text

it is still giving me sql grammar exception

k !thanks

can conflict of jdbc and hibernate is the cause of failure of the both of servlet

but they are not executing .
neither file is not uploaded nor data is saved.
2nd point is i have used hibernate in readExcel method whereas jdbc in the uploadDB servlet

code of uploadDB servlet.
package com.mvc.upload;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.RequestDispatcher;
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 com.mvc.util.DBConnection;

@WebServlet("/uploadToDB")
@MultipartConfig(fileSizeThreshold = 1024 * 1024 * 2, // 2MB
maxFileSize = 1024 * 1024 * 10, // 10MB
maxRequestSize = 1024 * 1024 * 50) // 50MB
public class UploadToDBServlet extends HttpServlet{

/**
*
*/
private static final long serialVersionUID = 1L;
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
// TODO Auto-generated method stub
//super.doGet(req, resp);
RequestDispatcher dispatcher = req.getServletContext().getRequestDispatcher("/WebContent/uploading_client.jsp");

dispatcher.forward(req, resp);

// try {
// readExcel.read_SaveToDB();
// } catch (SQLException e) {
// // TODO Auto-generated catch block
// e.printStackTrace();
// }
// String message = "data uploaded and saved into database";
// req.setAttribute("Message", message);
//
//RequestDispatcher dispatchData_toDB = req.getServletContext().getRequestDispatcher("/WebContent/DataUploaded.jsp");
//req.setAttribute("Message", message);
}

@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
Connection conn = null;
try {
// Connection to Database
// (See more in JDBC Tutorial).
conn = DBConnection.createConnection();
conn.setAutoCommit(false);

String description = request.getParameter("description");

// Part list (multi files).
for (Part part : request.getParts()) {
String fileName = extractFileName(part);
if (fileName != null && fileName.length() > 0) {
// File data
InputStream is = part.getInputStream();
// Write to file
this.writeToDB(conn, fileName, is, description);
}
}
conn.commit();

// Upload successfully!.
response.sendRedirect(request.getContextPath() + "/uploadToDBResults");
} catch (Exception e) {
e.printStackTrace();
request.setAttribute("errorMessage", "Error: " + e.getMessage());
RequestDispatcher dispatcher = getServletContext().getRequestDispatcher("/WebContent/uploading_client.jsp");
dispatcher.forward(request, response);
} finally {
this.closeQuietly(conn);
}
}

private String extractFileName(Part part) {
// form-data; name="file"; filename="C:\file1.zip"
// form-data; name="file"; filename="C:\Note\file2.zip"
String contentDisp = part.getHeader("content-disposition");
String[] items = contentDisp.split(";");
for (String s : items) {
if (s.trim().startsWith("filename")) {
// C:\file1.zip
// C:\Note\file2.zip
String clientFileName = s.substring(s.indexOf("=") + 2, s.length() - 1);
clientFileName = clientFileName.replace("\\", "/");
int i = clientFileName.lastIndexOf('/');
// file1.zip

file uploaded but not excel data is not saved in the database

actual problem is that : data cannot be read from the excel sheet.
and another problem is : data is not inserted into database from the excel.

data is not inserted into the database table

data contained in excel is not exported to mysql database table namely exportdata.

but how i can do it ?????
actually by mistake i forgot to post as a question