<%@ 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();
							   }
 
 
 
%>

pst.executeUpdate();