Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%@ page import ="java.sql.*" %>
- <h1>hello saurabh</h1>
- <%
- String s1 = request.getParameter("uname");
- String s2="saurabh";
- String driver ="com.mysql.jdbc.Driver";
- String url ="jdbc:mysql://localhost:3306/amber";
- String userName = "root";
- String password = "sameer0207";
- Connection conn = null;
- Statement st = null;
- out.println(s2);
- try {
- out.println("Enterd in try");
- Class.forName(driver);
- out.println(driver);
- conn = DriverManager.getConnection(url,userName,password);
- out.println("Connected to the database");
- String query="INSERT INTO quote VALUES (garima, 8588803860, 'tyagi619@gmail.com', 'kuchb bhi');";
- st = conn.createStatement();
- ResultSet rs = st.executeQuery(query);
- if(rs.next())
- {out.println("success");
- conn.close();}
- else
- {out.println("not success");}
- }catch(Exception e){
- System.out.println("Exception occured! "+e.getMessage()+" "+e.getStackTrace());
- }
- %>
Add Comment
Please, Sign In to add comment