啊啊啊啊 我已經瘋掉了 剛學的java 代碼打了n編都不行 跪求哪位大佬 幫忙解決一下
登錄的程式 index.jsp
<%@ page contentType="text/html" pageEncoding="GBK"%>
<%@ page import="java.util.* "%>
<jsp:useBean id="reg" scope="request" class="zhbit.Register"/>
<html>
<head><title>www.zhbit.com</title></head>
<body>
<form action ="check.jsp" method="post" >
username:<input type="text" name="name" value='https://bbs.csdn.net/topics/
age:<input type="text" name="age" value='https://bbs.csdn.net/topics/
email:<input type="text" name="email" value='https://bbs.csdn.net/topics/
<input type="submit"><input type="reset">
</form>
</body>
</html>
檢查的程式 check.jsp
<%@ page contentType="text/html" pageEncoding="GBK"%>
<jsp:useBean id="reg" scope="request" class="zhbit.Register"/>
<jsp:useBean id="regi" scope="request" class="dao.RegisterDB"/>
<html>
<body>
<jsp:setProperty name="reg" property="*"/>
<%
if(reg.invalidate()){
regi.register(reg);%>
<jsp:forward page="success.jsp"/>
<% }else{%>
<jsp:forward page="index.jsp"/>
<% }
%>
</body>
</html>
登錄輸入的資訊是否合法的代碼
Register.java
package zhbit;
import java.util.*;
import java.util.List;
public class Register {
public Register() {
super();
this.name="";
this.age="";
this.email="";
errors= new HashMap<String,String>();
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getAge() {
return age;
}
public void setAge(String age) {
this.age = age;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
private String name;
private String age;
private String email;
private HashMap<String,String> errors;
public boolean invalidate(){
boolean flag=true;
if(!this.name.matches("\\w{6,15}")){
flag=false;
this.name="";
errors.put("errorname", "用戶名只能是6~15數字或字母");
}
if(!this.age.matches("\\d+")){
flag=false;
this.age="";
errors.put("errorage", "年齡是數字");
}
if(!this.email.matches("\\w+@\\w+\\.\\w+\\.?\\w*")){
flag=false;
this.email="";
errors.put("erroremail", "輸入合法email");
}
return flag;
}
public String getError(String key){
String value = errors.get(key);
return value != null? errors.get(key):"";
}
}
插入資料的代碼:RegisterDB.java
package dao;
import java.sql.*;
import dbc.DatabaseConnection;
import zhbit.Register;
public class RegisterDB {
Connection conn = null;
DatabaseConnection dbc = null;
public RegisterDB() {
super();
// TODO Auto-generated constructor stub
dbc = new DatabaseConnection();
conn= dbc.getConnection();
}
public boolean register(Register reg) throws Exception{
boolean flag=false;
String sql="INSTER INTO user(name,age,email)"
+"VALUES(?,?,?)";
PreparedStatement pstm = conn.prepareStatement(sql);
pstm.setString(1, reg.getName());
pstm.setString(2, reg.getAge());
pstm.setString(3, reg.getEmail());
pstm.executeUpdate();
pstm.close();
return flag;
}
}
錯誤提示:

myeclipse的錯誤提示:

uj5u.com熱心網友回復:
register.register(reg) reg里面有函式?應該是傳reg里面的欄位uj5u.com熱心網友回復:
PreparedStatement.tostring()看看是什么樣子,直接在資料庫里執行看看是哪里報錯。uj5u.com熱心網友回復:
檢查下你的插入sql陳述句 看錯誤是提示你語法有問題轉載請註明出處,本文鏈接:https://www.uj5u.com/qianduan/61128.html
標籤:JavaScript
上一篇:我在from標簽里面的action屬性寫了值,可是表單還是被提交到根目錄下的index.html的不存在地址了,求大佬解答
下一篇:求大佬告知,這是什么問題
