初学JSP有许多问题不懂,最近就有一个做登录的,在javabean中定义了两个类
public class ConnUtil {
public static Connection getuser() {
Connection conn = null;
try {
String url = "jdbc:odbc:news";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(url, "", "");
} catch (Exception e) { System.out.print(e.toString());
}
return conn;
} public static void closeConnection(Connection conn) {
try {
conn.close();
} catch (Exception e) {
System.out.println(e.toString());
}
}
}
还有一个查询表的
public class UserDenglu {
Connection conn = ConnUtil.getuser();
public ResultSet getdentlu(Connection conn, HttpServletRequest request) {
ResultSet rs = null;
try {
String username = request.getParameter("username");
String password = request.getParameter("password");
Statement smt = conn.createStatement();
String sql = "select username,password from usersdenglu where username='"+username+"'";
sql+= "and password='"+password+"'";
smt.executeQuery(sql);
System.out.println(sql);
} catch (Exception e) {
System.out.println(e.toString());
}
return rs;
}
在页面中这样调用:
<%
String username = request.getParameter("username");
String password = request.getParameter("password");
request.setCharacterEncoding("gb2312");
Connection conn = ConnUtil.getuser();
UserDenglu bean = new UserDenglu();
ResultSet rs = bean.getdentlu(conn, request);
if(rs.getString("Username")!=null && rs.getString("password")!=null){
if (rs.next()) {
session.setAttribute("username", username);
session.setAttribute("password", password);
response.sendRedirect("homepage.jsp");
}
} else {
out.print("<script language=javascript>alert('用户名或密码错误!')");
}
%>
但是运行时说第一个if语句哪儿有问题;真的不知道怎么解决,麻烦各位高手帮忙看一下,是哪儿错呢?在下不胜感激
public class ConnUtil {
public static Connection getuser() {
Connection conn = null;
try {
String url = "jdbc:odbc:news";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(url, "", "");
} catch (Exception e) { System.out.print(e.toString());
}
return conn;
} public static void closeConnection(Connection conn) {
try {
conn.close();
} catch (Exception e) {
System.out.println(e.toString());
}
}
}
还有一个查询表的
public class UserDenglu {
Connection conn = ConnUtil.getuser();
public ResultSet getdentlu(Connection conn, HttpServletRequest request) {
ResultSet rs = null;
try {
String username = request.getParameter("username");
String password = request.getParameter("password");
Statement smt = conn.createStatement();
String sql = "select username,password from usersdenglu where username='"+username+"'";
sql+= "and password='"+password+"'";
smt.executeQuery(sql);
System.out.println(sql);
} catch (Exception e) {
System.out.println(e.toString());
}
return rs;
}
在页面中这样调用:
<%
String username = request.getParameter("username");
String password = request.getParameter("password");
request.setCharacterEncoding("gb2312");
Connection conn = ConnUtil.getuser();
UserDenglu bean = new UserDenglu();
ResultSet rs = bean.getdentlu(conn, request);
if(rs.getString("Username")!=null && rs.getString("password")!=null){
if (rs.next()) {
session.setAttribute("username", username);
session.setAttribute("password", password);
response.sendRedirect("homepage.jsp");
}
} else {
out.print("<script language=javascript>alert('用户名或密码错误!')");
}
%>
但是运行时说第一个if语句哪儿有问题;真的不知道怎么解决,麻烦各位高手帮忙看一下,是哪儿错呢?在下不胜感激
解决方案 »
- 一个关于自动登录的问题 特殊网络下面对Cookie的操作
- 我的eclipse怎么了!!!!
- 关于登录设置cookie。。。
- Java天下招版主!
- JBuilder2005创建jsp怎么没有调试预览功能啊,还得在浏览器中输入网址浏览,真麻烦啊!
- 大家帮我看下如何取数据
- 现准备学习JavaBean,我在网上先看了一个例子,对其中的this.Rate不懂,隐约感觉是对像、属性之类,请问,要学好JavaBean,首先要恶补哪
- 【急问!!!】IP匹配问题,
- 我要配置,不要配偶!
- 关于运行servlet的问题!
- 边写html,边可预览的小点的软件有吗?也可以JSP的
- Vector<Message> messages; 有错吗?
table里面有没有值
你连接到那个数据库上?我怎么没有看到你连接数据库的名称?