Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- res.setContentType("text/html");
- PrintWriter out = res.getWriter();
- try
- {
- Class.forName("oracle.jdbc.driver.OracleDriver");
- Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE" , "system" , "connect");
- String name = request.getParameter("name");
- String id = request.getParameter("id");
- String required = request.getParameter("required");
- String website = request.getParameter("website");
- String password = request.getParameter("password");
- PreparedStatement ps = con.PreparedStatement("insert into ngo values(?,?,?,?,?)");
- ps.setString(1,id);
- ps.setString(2,name);
- ps.setString(4,required);
- ps.setString(3,website);
- ps.setString(5,password);
- if(!userExists(id,con))
- {
- int i = ps.executeUpdate();
- if(i>0)
- {
- out.println("Account created")
- }
- HttpSeesion session = request.getSession();
- session.setAttribute("id",id);
- res.sendRedirect();
- }
- else
- {
- out.println("account already exists");
- }
- }
- catch(Exception e)
- {}
- }
- boolean userExists(String id,Connection con)
- {
- Statement st = con.createStatement();
- ResultSet rs = st.executeQuery("select * from id where id="+id);
- if(rs.next())
- {
- return true;
- }
- else
- {
- return false;
- }
- }
Add Comment
Please, Sign In to add comment