菜鸟问题急求解答!
我不知道哪里错了,,,希望哪位朋友帮我调试一下,,,我实在找不出哪里错了。。。。。。。我是个新手,很多知识点还不懂。
这是一个JSP接受页面的代码,check.jsp
<%@ page language="java" import="java.util.*,util.Tool" pageEncoding="GBK"%>
<%@ page import="vo.UserInfo"%>
<%@ page import="bean.T_userInfo" %>
<%
String username=Tool.getParameter(request,"username","");
UserInfo findUser = new UserInfo();
findUser.setUsername(username);
T_userInfo cu = new T_userInfo();
if(cu.checkUsername(findUser)){
out.println("恭喜您!该用户未被注册!");
}else{
out.println("该用户名已被占用,请您重新填写一个用户名!");
}
%>
这是一个包,其中包括了上面代码所用到checkUsername类
package bean;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.ResultSet;
import util.DBConnect;
import vo.UserInfo;
public class T_userInfo {
public boolean addUserInfo(UserInfo userInfo){ Connection conn = null; PreparedStatement pstmt = null;
try{
conn = DBConnect.getConnect();
String sql = "insert into user_info(userName,password,name,year,month,day,sex,telephone,email,province,city,agree,regIp,regTime) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; pstmt = conn.prepareStatement(sql);
int i = 1;
pstmt.setString(i++,userInfo.getUsername());
pstmt.setString(i++,userInfo.getPassword());
pstmt.setString(i++,userInfo.getName());
pstmt.setString(i++,userInfo.getYear());
pstmt.setString(i++,userInfo.getMonth());
pstmt.setString(i++,userInfo.getDay());
pstmt.setString(i++,userInfo.getSex());
pstmt.setString(i++,userInfo.getTelephone());
pstmt.setString(i++,userInfo.getEmail());
pstmt.setString(i++,userInfo.getProvince());
pstmt.setString(i++,userInfo.getCity());
pstmt.setString(i++,userInfo.getAgree());
pstmt.setString(i++,userInfo.getRegIp());
pstmt.setString(i++,userInfo.getRegTime());
pstmt.execute();
}
catch(SQLException e){
e.printStackTrace();
return false;
}
finally{
try{ pstmt.close();
conn.close();
}
catch(SQLException e){
e.printStackTrace();
return false;
}
}
return true;
}
public boolean checkUsername(UserInfo findUser){
Connection conn=null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
conn = DBConnect.getConnect();
String sql = "select * from user_info where username= ?";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1,findUser.getUsername());
rs = pstmt.executeQuery();
if(rs == null || rs.next()){
return false;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
pstmt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return true;
}
}