我正在JSP中创建一个注册表单，我已经对代码进行了编码，并且在将其部署到服务器上时没有错误，没有输出，也没有在数据库中插入数据。任何人都可以解决我的问题。
用途服务器：Tomcat 8，IDE：Eclipse Luna，数据库：Oracle 12c。
index.jsp
<html>
<head>
<title>Registration Form</title>
</head>
<body>
<form action="process.jsp" method="post">
<input type="text" name="uname" value="Name..." onclick="this.value" /><br>
<input type="text" name="uemail" value="Email..." onclick="this.value" /><br>
<input type="password" name="upass" value="Password..."
onclick="this.value" /><br> <input type="submit"
value="Register">
</form>
</body>
</html>
process.jsp
<%@ page import="registration.RegisterDao"%>
<jsp:useBean id="obj" class="registration.User"></jsp:useBean>
<jsp:setProperty property="*" name="obj" />
<html>
<head>
</head>
<body>
<%
int status = RegisterDao.register(obj);
if (status > 0)
out.print("You are successfully registered");
%>
</body>
</html>
user.java
package registration;
public class User {
private String uname;
private String upass;
private String uemail;
public String getUname() {
return uname;
}
public void setUname(String uname) {
this.uname = uname;
}
public String getUpass() {
return upass;
}
public void setUpass(String upass) {
this.upass = upass;
}
public String getUemail() {
return uemail;
}
public void setUemail(String uemail) {
this.uemail = uemail;
}
}
provider.java
package registration;
public interface Provider {
String DRIVER = "oracle.jdbc.driver.OracleDriver";
String CONNECTION_URL = "jdbc:oracle:thin:@localhost:1521:oracle12c";
String USERNAME = "AtulRai";
String PASSWORD = "atulrai";
}
connectionProvider.java
package registration;
import java.sql.Connection;
import java.sql.DriverManager;
import static registration.Provider.*;
public class ConnectionProvider {
private static Connection con = null;
static {
try {
Class.forName(DRIVER);
con = DriverManager.getConnection(CONNECTION_URL, USERNAME,
PASSWORD);
} catch (Exception ex) {
ex.printStackTrace();
}
}
public static Connection getCon() {
return con;
}
}
Registerdao.java
package registration;
import java.sql.Connection;
import java.sql.PreparedStatement;
public class RegisterDao {
public static int register(User u) {
int status = 0;
try {
Connection con = ConnectionProvider.getCon();
PreparedStatement ps = con
.prepareStatement("insert into detail values(?,?,?)");
ps.setString(1, u.getUname());
ps.setString(2, u.getUemail());
ps.setString(3, u.getUpass());
} catch (Exception ex) {
ex.printStackTrace();
}
return status;
}
}
其他详细信息是：我的表名是DETAIL，列名是NAME，EMAIL，PASS。
最佳答案
您在DAO类内的register（）中缺少executeUpdate（）语句：
此方法在此PreparedStatement对象中执行SQL语句，该对象必须是SQL数据操作语言（DML）语句，例如INSERT，UPDATE或DELETE。或不返回任何内容的SQL语句，例如DDL语句。
http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#executeUpdate()
public static int register(User u) {
int status = 0;
try {
Connection con = ConnectionProvider.getCon();
PreparedStatement ps = con
.prepareStatement("insert into detail values(?,?,?)");
ps.setString(1, u.getUname());
ps.setString(2, u.getUemail());
ps.setString(3, u.getUpass());
status = ps.executeUpdate();
} catch (Exception ex) {
ex.printStackTrace();
}
return status;
}