Inserir Dados JSP

Pessoal ele está pegando os dados normal que vem dos inputs mas não salva, essa classe de conection e a classe que eu sempre uso em meus projetos porem JSP e o meu primeiro trabalho com Desktop
podemme dar uma força ?

<%–
Document : index
Created on : 30/08/2017, 09:47:43
Author : Administrador
–%>

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

 <%


conexoes.ConexaoMySql conn = new conexoes.ConexaoMySql();
String msg;
try
{
String usuario = request.getParameter("usuario");
String Senha = request.getParameter("senha");

 msg = usuario + Senha;
 
conn.conectar();

conn.insertSQL("INSERT INTO user (usuario,senha)VALUES(" + usuario + "," + Senha + ")");

     } catch (Exception e) {
        e.printStackTrace();
        msg = "Erro = "+e;
    } finally {
       
      conn.fecharConexao();
    }
 %>

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* 
these tags -->
<meta name="description" content="">
<meta name="author" content="">
<link rel="icon" href="../../favicon.ico">

<title>Cadastro de Clientes</title>

<!-- Bootstrap core CSS -->
<link href="bootstrap-3.3.7-dist/css/bootstrap.min.css" rel="stylesheet">

<!-- IE10 viewport hack for Surface/desktop Windows 8 bug -->
<link href="bootstrap-3.3.7-dist/css/ie10-viewport-bug-workaround.css" rel="stylesheet">

<!-- Custom styles for this template -->
<link href="signin.css" rel="stylesheet">

<!-- Just for debugging purposes. Don't actually copy these 2 lines! -->
<!--[if lt IE 9]><script src="../../assets/js/ie8-responsive-file-warning.js"></script><![endif]-->
<script src="bootstrap-3.3.7-dist/js/ie-emulation-modes-warning.js"></script>


<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
<!--[if lt IE 9]>
  <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
  <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
<![endif]-->

<div class="container">

      <form class="form-signin">
          <h2 class="form-signin-heading">Cadastro de Usuários</h2>

          <br>

          <label for="usuario">Usuário</label>
          <input type="email" id="inputEmail" name="usuario" class="form-control" placeholder="Digite o usuário..." required autofocus>
          <br>
          <label for="senha">Senha</label>
          <input type="senha" id="inputPassword" name="senha" class="form-control" placeholder="digite a senha..." required>
          <div class="checkbox">

          </div>
         
              <button type="btNovo"    name="ac" value="novo"      class="btn btn-primary">Novo</button>
            
              <button type="btAltera"  name="ac" value="alterar"   class="btn btn-warning">Alterar</button>
             
              <button type="btGravar"  name="ac" value="gravar"    class="btn btn-success">Gravar</button>
             
              <button type="btExcluir" name="ac" value="excluir"   class="btn btn-danger">Excluir</button>
              
          </div>
  
  <br><%=msg%>.<br> 
   
 </form>

          </div> <!-- /container -->


          <!-- IE10 viewport hack for Surface/desktop Windows 8 bug -->
                <script src="bootstrap-3.3.7-dist/js/ie10-viewport-bug-workaround.js"></script>
           </body>
  </html>

2 Respostas

Topicos relacionados