<%@page import = "java.sql.*" %>
<%@page import = "oracle.jdbc.driver.*" %>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%
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){
%><%
}
else if((id == "") || (nombre == "") || (admin == "") || (sueldo == "") || (user == "") || (contraseña == "") ){
%><%
}
else{
%><%
}
}
%>