Ad:

JSP Discussion Thread
Unsolved
Views: 14521

Permalink

Oct 26th, 2007

how to update database using mysql and jsp

Expand Post »

can somebody prove me the coding to update the database (mysql) with JSP

Similar Threads

Update entire Mysql DataBase with PhP in PHP
How to Connect MySQL from JSP Page in JSP
facing problem in database connectivity in jsp to mysql in JSP
Please help me in connecting JSP to MySql in JSP
To update database through gridview in ASP.NET

nikhita

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

15 posts
since Oct 2007

Permalink

Oct 29th, 2007

Re: how to update database using mysql and jsp

Google is your friend! There are many examples over the internet, for example this site http://www.java2s.com/Tutorial/Java/...__Database.htm

peter_budo

Moderator

Featured Poster

Reputation Points: 2786

Solved Threads: 875

Code tags enforcer

Online

6,659 posts
since Dec 2004

Permalink

Nov 2nd, 2007

Re: how to update database using mysql and jsp

U can write all code using scriptlet. Simply start scriptlet,create connection, write and execute update query, close connection and scriptlet.
For Ex
<%
create connection
Create query
resultset
execute query
close connection
%>
Hope it provides u some help!!

U can find example code in google.

Shubhra

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

7 posts
since Nov 2007

Permalink

Nov 2nd, 2007

Re: how to update database using mysql and jsp

Click to Expand / Collapse Quote originally posted by Shubhra ...

U can write all code using scriptlet. Simply start scriptlet,create connection, write and execute update query, close connection and scriptlet.
For Ex
<%
create connection
Create query
resultset
execute query
close connection
%>
Hope it provides u some help!!

U can find example code in google.

Which is, of course, exactly the wrong way to do it, reagardless of whether it works or not.

You can also scratch your back with a butcher knife, but I wouldn't suggest it.

masijade

Moderator

Reputation Points: 1471

Solved Threads: 490

Industrious Poster

Offline

4,043 posts
since Feb 2006

Permalink

Nov 2nd, 2007

Re: how to update database using mysql and jsp

Ya OK.
What I provided was actually the short cut.
Correct way is to do all such stuff in class. Create object in jsp and simply execute the method!!

Am I correct now??

Shubhra

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

7 posts
since Nov 2007

Permalink

Nov 2nd, 2007

Re: how to update database using mysql and jsp

Well, if you knew the right way, why did you suggest the wrong way?

As I said:

You can also scratch your back with a butcher knife, but I wouldn't suggest it.

masijade

Moderator

Reputation Points: 1471

Solved Threads: 490

Industrious Poster

Offline

4,043 posts
since Feb 2006

Permalink

Nov 2nd, 2007

Re: how to update database using mysql and jsp

Actually I wrote what came first to my mind.
Your comment stroke me to give a2nd thought.
I apologise.

Shubhra

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

7 posts
since Nov 2007

Permalink

Nov 7th, 2007

how make a jsp page printer friendly

the link you provided was helpful. thanks a lot.

sorry for the delay in reply..

One more help needed....

can u tel me how make a jsp page printer friendly

nikhita

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

15 posts
since Oct 2007

Permalink

Mar 21st, 2010

use this may help u

Click to Expand / Collapse Quote originally posted by nikhita ...

can somebody prove me the coding to update the database (mysql) with JSP

-----------------------html.jsp---------------------------

JSP Syntax (Toggle Plain Text)
<%@ page contentType="text/html; charset=iso-8859-1" language="java" %>
<html>
<body>
<form name="frm" method="post" action="om.jsp">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="22%">&nbsp;</td>
    <td width="78%">&nbsp;</td>
    </tr>
  <tr>
    <td>Name Student </td>
    <td> to<input type="text" name="studentName"></td>
    <td>from<input type="text" name="studentName1"></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td><input type="submit" name="submit" value="Submit"></td>
    </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    </tr>
</table>
</form>
</body>
</html>
<%@ page contentType="text/html; charset=iso-8859-1" language="java" %>
<html>
<body>
<form name="frm" method="post" action="om.jsp">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="22%">&nbsp;</td>
    <td width="78%">&nbsp;</td>
    </tr>
  <tr>
    <td>Name Student </td>
    <td> to<input type="text" name="studentName"></td>
    <td>from<input type="text" name="studentName1"></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td><input type="submit" name="submit" value="Submit"></td>
    </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    </tr>
</table>
</form>
</body>
</html>

-----------------------------om.jsp-----------------------

JSP Syntax (Toggle Plain Text)
<html> 
<head> 
<title>result:</title> 
 
 
<%@ page import="java.io.*"%> 
<%@ page import="java.io.File"%> 
<%@ page import="java.util.*"%> 
<%@ page import="java.sql.*"%> 
<%@ page import="java.sql.Blob"%> 
<%@ page import="java.sql.PreparedStatement"%> 
<%@ page import="java.sql.BatchUpdateException"%> 
<%@ page import="javax.servlet.*"%> 
<%@ page import="javax.servlet.http.*"%> 
 
<% 
 
try 
{ 
 
boolean autho;
 
//String driver = "org.gjt.mm.mysql.Driver"; 
Class.forName("com.mysql.jdbc.Driver").newInstance(); 
Connection con=null; 
ResultSet rs=null; 
Statement stmt=null; 
 
 
String url="jdbc:mysql://localhost:3306/om?user=root&password=omshakthi"; 
 
out.println("no1");
con=DriverManager.getConnection(url); 
 
stmt=con.createStatement(rs.TYPE_SCROLL_SENSITIVE,rs.CONCUR_UPDATABLE);
 
 
String name=request.getParameter("studentName");
 
String name1=request.getParameter("studentName1");
 
//stmt.executeUpdate("insert into om1(name) values('"+name+"')"); //insert
 
 
//stmt.executeUpdate("update om1 set name='"+name+"' WHERE name='ykuy'");//update
 
 
//name: is where u enter as get parameter
//ykuy: is some store value in mysql
 
 
//rs = stmt.executeQuery("SELECT * FROM om1"); // select all
 
rs = stmt.executeQuery("SELECT * FROM om1 WHERE name='"+name+"'");//use of where
 
 
if(!rs.next()) 
{
autho=false;
//out.println("not autorized");
}
else
{
autho=true;
//out.println("autorized");
}
 
 
rs = stmt.executeQuery("SELECT * FROM om1 WHERE name='"+name1+"'");
 
 
if(!rs.next()) 
{
out.println("not autorized");
}
else if(autho==false) 
{
out.println("not autorized");
}
else
{
out.println("autorized");
out.println("<h1>new mail from   "+name1+"   to   "+name+"</h1>"); 
}
 
 
 
/*
 
while (rs.next()) 
{
out.println("no2");
out.println(rs.getString("name")+"<br>");
}*/
 
 
rs.close();
}
 
 
catch (Exception e) 
{ 
out.println("no3");
//out.println("<center><font size=5> Error in inserting the data</font></center>"); 
out.println("the error is:"+e.toString()); 
} 
 
 
%> 
</body> 
</html>
<html> 
<head> 
<title>result:</title> 


<%@ page import="java.io.*"%> 
<%@ page import="java.io.File"%> 
<%@ page import="java.util.*"%> 
<%@ page import="java.sql.*"%> 
<%@ page import="java.sql.Blob"%> 
<%@ page import="java.sql.PreparedStatement"%> 
<%@ page import="java.sql.BatchUpdateException"%> 
<%@ page import="javax.servlet.*"%> 
<%@ page import="javax.servlet.http.*"%> 

<% 

try 
{ 

boolean autho;

//String driver = "org.gjt.mm.mysql.Driver"; 
Class.forName("com.mysql.jdbc.Driver").newInstance(); 
Connection con=null; 
ResultSet rs=null; 
Statement stmt=null; 


String url="jdbc:mysql://localhost:3306/om?user=root&password=omshakthi"; 

out.println("no1");
con=DriverManager.getConnection(url); 

stmt=con.createStatement(rs.TYPE_SCROLL_SENSITIVE,rs.CONCUR_UPDATABLE);


String name=request.getParameter("studentName");

String name1=request.getParameter("studentName1");

//stmt.executeUpdate("insert into om1(name) values('"+name+"')"); //insert


//stmt.executeUpdate("update om1 set name='"+name+"' WHERE name='ykuy'");//update


//name: is where u enter as get parameter
//ykuy: is some store value in mysql


//rs = stmt.executeQuery("SELECT * FROM om1"); // select all

rs = stmt.executeQuery("SELECT * FROM om1 WHERE name='"+name+"'");//use of where


if(!rs.next()) 
{
autho=false;
//out.println("not autorized");
}
else
{
autho=true;
//out.println("autorized");
}


rs = stmt.executeQuery("SELECT * FROM om1 WHERE name='"+name1+"'");


if(!rs.next()) 
{
out.println("not autorized");
}
else if(autho==false) 
{
out.println("not autorized");
}
else
{
out.println("autorized");
out.println("<h1>new mail from   "+name1+"   to   "+name+"</h1>"); 
}



/*

while (rs.next()) 
{
out.println("no2");
out.println(rs.getString("name")+"<br>");
}*/


rs.close();
}


catch (Exception e) 
{ 
out.println("no3");
//out.println("<center><font size=5> Error in inserting the data</font></center>"); 
out.println("the error is:"+e.toString()); 
} 


%> 
</body> 
</html>

Last edited by peter_budo; Mar 21st, 2010 at 11:16 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)

jagadesh_pesit

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Mar 2010

Permalink

Mar 21st, 2010

Re: how to update database using mysql and jsp

@jagadesh_pesit

You are just some 3 years to late with your reply
You used no code tags
You show database connectivity from JSP that is frown upon (bad practice)
I can go on, but I rather close this thread as unproductive and sample of bad practises. You want to learn better? Then check 2 posts on the top of JSP section for more info...

peter_budo

Moderator

Featured Poster

Reputation Points: 2786

Solved Threads: 875

Code tags enforcer

Online

6,659 posts
since Dec 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

This thread is currently closed and is not accepting any new replies.

Previous Thread in JSP Forum Timeline: how to connect derby database to jsp

Next Thread in JSP Forum Timeline: javamail

DaniWeb Message

Cancel Changes

User Name
Password