Boas;
Não estou conseguindo receber o valores do text area no meu mysql, aparece sempre null.
Alguem me poderia ajudar?
HTML CODE:<%@page contentType="text/html" pageEncoding="UTF-8"%>
<html>
<head>
</head>
<body>
:<form method="POST" action="teste.jsp">
<p><input type="text" name="a" size="20"></p>
<p><textarea rows="5" name="b" cols="20"></textarea></p>
<p><input type="submit" value="Submeter" name="B1"><input type="reset" value="Repor" name="B2"></p>
</form>
</body>
</html>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<%
String valor = request.getParameter("a");
String valo = request.getParameter("b");
java.sql.Connection conn = null;
String url="jdbc:mysql://localhost:3306/try";
String user="root";
String password="123456";
String xt;
Statement st;
Class.forName ("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection (url, user, password);
st = conn.createStatement();
xt = "INSERT INTO try(nome, campo) VALUES ('"+valor+"', '"+valo+"');";
st.executeUpdate (xt);
conn.close ();
%>
INSERIDO
</body>
</html>
create database try;
use try;
create table registo (nome varchar(20) not null, campo varchar (20) not null);
describe registo;
select *from registo;