Tuesday, 24 March 2015

JSP code to insert value in mysql database using type 4 driver

<%@page  language="java" import="java.sql.*" contentType="text/html" pageEncoding="UTF-8"%>

   
       
        JSP Page
   
   
        <%
        Connection con;
        PreparedStatement ps;
        String n,c;
        int x;
        n=request.getParameter("t1");
        c=request.getParameter("t2");
        try
        {
          Class.forName("com.mysql.jdbc.Driver");
          con=DriverManager.getConnection("jdbc:mysql://localhost/school","root","admin");
          ps=con.prepareStatement("insert into login(uname,pass) values(?,?)");
ps.setString(1,n);
ps.setString(2,c);
x=ps.executeUpdate();
if(x==1)
{
out.println("Record has been saved");
}        
        }
        catch(Exception e){}
        %>
   


No comments:

Post a Comment