Jump to content


rohanawaw

Member Since 05 Jun 2017
Offline Last Active Jan 17 2019 06:45 PM
-----

Posts I've Made

In Topic: [Solved] access denied to database

05 December 2018 - 04:58 AM

now

javax.servlet.ServletException: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

my code

 

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
    <%@ page import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<%
boolean ok=false;
 
 String req_pass=request.getParameter("pass");
 String req_motherboard_id=request.getParameter("mot_id");
 String req_cpu_id=request.getParameter("cpu_id");
 String req_mac_id=request.getParameter("mac_id");
   // String ProductNamez=request.getParameter("ProductName");
   Connection conn=null;
   Statement st=null;
   ResultSet rs=null;
try
{
    Class.forName("com.mysql.jdbc.Driver").newInstance();
     conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/rajesha1_password","rajesha1_azhar", "pass");
     st=conn.createStatement();
     rs = st.executeQuery("SELECT * FROM machineid WHERE pass = '"+
  req_pass +"' ");
    while(rs.next()){ 
   
   
   
    if(rs.getString(3).equals(req_mac_id))
    {
   
    }
   
    if(rs.getString(2).equals(req_cpu_id))
    {
   
    }
    if(rs.getString(1).equals(req_motherboard_id))
    {
    ok=true;
   
    }
   
   
    }
    //rs.close();
   // st.close();
  //  conn.close();
   
}
catch(Exception e)
{
out.println(e.getMessage()) ;
}
    
         %>
 
 
 
 
 
 
 
 
 
 
<%
if(!ok)
{
 // String ProductNamez=request.getParameter("ProductName");
try
{
    Class.forName("com.mysql.jdbc.Driver").newInstance();
   
 
st=conn.createStatement();
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/rajesha1_password","rajesha1_azhar", "pass");
    

 

     rs = st.executeQuery("SELECT count(*) FROM machineid WHERE pass = '"+req_pass +"' ");
    
    while(rs.next()){ 
   
    int h= rs.getInt(1);
    if(h<5)
    {
    String sql = "INSERT INTO machineid " +
                    "VALUES ('"+req_motherboard_id+"', '"+req_cpu_id+"', '"+req_mac_id+"','"+req_pass+"')";
      
    int rsu = st.executeUpdate(sql);
      
   
    }
    }
    //PrintWriter output = response.getWriter();
    out.println("yes");
    //String no="no";
    //respose.send("yes");
}
    catch(Exception e)
    {
    out.println(e.getMessage());
    }
 
    
}
else
{
String no="no";
out.println("no");
 
 
 
 
    rs.close();
    st.close();
    conn.close();
   
}
 
 
 
out.println("yes");
 
 
%>
</body>
</html>
 
 
operation not allow after resultset close

In Topic: [Solved] access denied to database

05 December 2018 - 04:12 AM

now

javax.servlet.ServletException: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

 

 

 

i guess the same old problem of not closing the connectio in database

 

 rs.close();
    st.close();
    conn.close();
   

where to put these lines exactly


In Topic: [Solved] access denied to database

05 December 2018 - 03:47 AM

all preveliges are given, user assign to database

 

solved database name was wrong _ instead of __


In Topic: Servlet Deploy

05 December 2018 - 02:25 AM

deployment pending taking hour or so today.

 

if its going to take long , please deploy my war

 

user rajesha1

war machine_id


In Topic: upload database .sql file and import with jsp

07 September 2018 - 09:18 PM

LOAD DATA LOCAL INLINE

LOCAL was missing

this method inserted 10 million rows in just 15 sec