mysql+jsp

•

What is DaniWeb IT Discussion Community?

You're currently browsing the JSP section within the Web Development category of DaniWeb, a massive community of 361,548 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,063 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our JSP advertiser: Lunarpages JSP Web Hosting

Thread Tools Display Modes

Views: 500 | Replies: 4

•

Join Date: Mar 2008

Posts: 9

Reputation: nireekshan is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

nireekshan nireekshan is offline

Offline

Newbie Poster

mysql+jsp

Apr 4th, 2008

hai
i am nireekshan
i am using mySql database in this i am create employe table
Now i am davalep One .HTML Page in this i am write the employe table fieldes-----------And write Jsp page inThis i write MYSQL CONNection code And Insert Prapared Staments
Now i am run TOMCat 5.0 Server,open .HTML page INSERT EMploye Fied Values Submet ok
next Work is Down NOT store data in database
plse see my program tell me any ERROR plse ...............
HTML..............>jsp.................;

 Help with Code Tags 
 JSP Syntax (Toggle Plain Text) 
<%@ page import="javax.servlet.*" %>
<%@ page import="javax.servlet.http.*" %>
<%@ page import="java.io.*" %>
 
<%@ page import="java.sql.*" %>
<% 
 
	String vemp_code=request.getParameter("emp_code");
	String vemp_name=request.getParameter("emp_name");
 
Connection conn = null;
ResultSet rs=null;
String url = "jdbc:mysql://localhost:3306/";
String driverName = "com.mysql.jdbc.Driver";
String userName = "roor";
String password = "root";
		try{
			Class.forName(driverName).newInstance();	
			conn = DriverManager.getConnection("jdbc:mysql://localhost/niree",userName,password);
			Statement stmt = conn.createStatement();
			stmt.executeUpdate("use newuser;");
			 out.println(" connection is established");
 
	//Statement stmt = conn.createStatement();
  	//int val = //stmt.executeUpdate("INSERT employe VALUES(?,?)"); 
			PreparedStatement pst;				
			pst=conn.prepareStatement(" insert into employe values(?,?)");
			pst.setString(1,vemp_code);
			pst.setString(2,vemp_name);
					}   
			  catch(Exception e){
		      System.out.println("error occured");
		        e.printStackTrace();
							   }
 
 
 
%>
<%@ page import="javax.servlet.*" %>
<%@ page import="javax.servlet.http.*" %>
<%@ page import="java.io.*" %>

<%@ page import="java.sql.*" %>
<% 
  
	String vemp_code=request.getParameter("emp_code");
	String vemp_name=request.getParameter("emp_name");

Connection conn = null;
ResultSet rs=null;
String url = "jdbc:mysql://localhost:3306/";
String driverName = "com.mysql.jdbc.Driver";
String userName = "roor";
String password = "root";
		try{
			Class.forName(driverName).newInstance();	
			conn = DriverManager.getConnection("jdbc:mysql://localhost/niree",userName,password);
			Statement stmt = conn.createStatement();
			stmt.executeUpdate("use newuser;");
			 out.println(" connection is established");
 
	//Statement stmt = conn.createStatement();
  	//int val = //stmt.executeUpdate("INSERT employe VALUES(?,?)"); 
			PreparedStatement pst;				
			pst=conn.prepareStatement(" insert into employe values(?,?)");
			pst.setString(1,vemp_code);
			pst.setString(2,vemp_name);
					}   
			  catch(Exception e){
		      System.out.println("error occured");
		        e.printStackTrace();
							   }
		
		
	
%>

Last edited by peter_budo : Apr 4th, 2008 at 2:12 pm. Reason: Keep It Organized - please use [code] tags

•

Join Date: Jun 2006

Location: India

Posts: 6,689

Reputation: ~s.o.s~ is a splendid one to behold

Rep Power: 23

Solved Threads: 312

~s.o.s~

Offline

Rebellion Revamped

Re: mysql+jsp

Apr 7th, 2008

Don't write database connectivity code in a JSP; that's not what JSP's were meant for. Push all that database logic inside a servlet. Use JSP only as a presentation technology.

And BTW, have you hosted your files on the Tomcat server? What is the URL you are using to access your HTML? What kind of error do you get? Aren't the error logs useful?

"I don't accept change. I don't deserve to live."

"Working a real job is a win if you're lazy, greedy, or unmotivated. If you're average, you fit right in. And if you're above average, the basic terms of employment and premise of the arrangement is against your interests."

•

Join Date: Dec 2004

Location: UAE

Posts: 398

Reputation: Sulley's Boo will become famous soon enough

Rep Power: 5

Solved Threads: 9

Sulley's Boo Sulley's Boo is offline

Offline

Posting Whiz

Re: mysql+jsp

Apr 8th, 2008

and, this line is missing

Help with Code Tags

(Toggle Plain Text)

pst.executeUpdate();

right ppl?

*hides*

•

Join Date: Nov 2004

Location: Netherlands

Posts: 5,576

Reputation: jwenting is a jewel in the rough

Rep Power: 18

Solved Threads: 184

jwenting

Offline

duckman

Re: mysql+jsp

Apr 8th, 2008

I wouldn't know. As soon as I see a tag starting a scriptlet I quit reading and give the canned answer to not use Java code in JSP.

42 Private messages asking for help will be ignored
In the frozen land of Nador they were forced to eat Steve's iMinstrels, and there was much rejoicing.