Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%@page import = "java.sql.*" %>
- <%@page import = "oracle.jdbc.driver.*" %>
- <%@page contentType="text/html" pageEncoding="UTF-8"%>
- <!DOCTYPE html>
- <html>
- <body>
- <%
- String id = request.getParameter("id");
- String nombre = request.getParameter("nombre");
- String admin = request.getParameter("admin");
- String sueldo = request.getParameter("sueldo");
- String user = request.getParameter("user");
- String contraseña = request.getParameter("pass");
- int admin_int = Integer.parseInt(admin);
- int sueldo_int = Integer.parseInt(sueldo);
- String sql1 = "insert into blostro.funcionario ('"+user +"','"+nombre+"',"+admin_int+","+sueldo_int+",'"+user+"','"+contraseña+"')";
- String url = "jdbc:oracle:thin:@localhost:1522:orcl";
- String username = "asdasd";
- String password = "asdasdasdasd";
- Connection conn = DriverManager.getConnection(url,username,password);
- Statement sentencia = conn.createStatement();
- if (sentencia.executeUpdate(sql1)==1){
- %><script language="JavaScript">
- alert("Su funcionario se ingreso correctamente")
- location.href("HomeAdmin.jsp");
- </script><%
- }
- else if((id == "") || (nombre == "") || (admin == "") || (sueldo == "") || (user == "") || (contraseña == "") ){
- %><script language="JavaScript">
- alert("Tiene un campo vacio, vuelva a ingresar los datos:")
- location.href("AgregarFuncionario.jsp");
- </script><%
- }
- else{
- %><script language="JavaScript">
- alert("Hubo un error, vuelva a ingresar los datos:")
- location.href("AgregarFuncionario.jsp");
- </script><%
- }
- }
- %>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement