81,108
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
saintKnight 2002-05-14
- 打赏
- 举报
可以使用JSP加Servlet来处理；
JSP页面如下：
<html>
<body>
<%
String logStatus=request.getParameter("logStatus");
if(logStatus!=null && logStatus.equals("1")) {
out.prinltn("<script langauge=javascript>");
out.prinltn("alert(\"登录失败！请重新登录！\");");
out.prinltn("</script>");
}
%>
<form name=login method=post action="login">
username:<input type="text" name="username" value=""><br>
pwd:<input type="password" name="userpwd" value=""><br>
<input type="submit" value="Login">
</form>
</body>
</html>
Servlet内容如下：
package login;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import sun.jdbc.rowset.CachedRowSet;
import java.sql.DriverManager;
public class myServlet extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=GBK";
/**Initialize global variables*/
public void init() throws ServletException {
}
/**Process the HTTP Post request*/
public void doPost(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
res.setContentType(CONTENT_TYPE);
PrintWriter out = res.getWriter();
out.println("<html>");
out.println("<head><title>myServlet</title></head>");
out.println("<body>");
String username=new String(req.getParameter("username").getBytes("ISO8859_1"),"GBK");
String userpwd=req.getParameter("userpwd");
if(username==null || userpwd==null) {
res.sendRedirect("login.jsp");
}else{
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(Exception ex) {
ex.printStackTrace();
}
try{
javax.sql.RowSet rs=getQuery("select * from login where username='"+username+"' and userpwd='"+userpwd+"'");
rs.beforeFirst();
if(!rs.next()) {
res.sendRedirect("login.jsp?logStatus=1");
}else{
out.println("<p align=\"center\">登录成功</p>");
}
}catch(Exception ex) {
ex.printStackTrace();
}
}
out.println("</body></html>");
}
/**Clean up resources*/
public void destroy() {
}
public javax.sql.RowSet getQuery(String sql) {
private sun.jdbc.rowset.CachedRowSet crs;
try {
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@myhost:1521:myOracle","usename","userpassword");
Statement Stmt = conn.createStatement();
java.sql.ResultSet rs= Stmt.executeQuery(sql);
crs=new CachedRowSet();
crs.populate(rs);
}catch(Exception ex) {
ex.printStackTrace();
}
return crs;
}
}
JSP页面如下：
<html>
<body>
<%
String logStatus=request.getParameter("logStatus");
if(logStatus!=null && logStatus.equals("1")) {
out.prinltn("<script langauge=javascript>");
out.prinltn("alert(\"登录失败！请重新登录！\");");
out.prinltn("</script>");
}
%>
<form name=login method=post action="login">
username:<input type="text" name="username" value=""><br>
pwd:<input type="password" name="userpwd" value=""><br>
<input type="submit" value="Login">
</form>
</body>
</html>
Servlet内容如下：
package login;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import sun.jdbc.rowset.CachedRowSet;
import java.sql.DriverManager;
public class myServlet extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=GBK";
/**Initialize global variables*/
public void init() throws ServletException {
}
/**Process the HTTP Post request*/
public void doPost(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
res.setContentType(CONTENT_TYPE);
PrintWriter out = res.getWriter();
out.println("<html>");
out.println("<head><title>myServlet</title></head>");
out.println("<body>");
String username=new String(req.getParameter("username").getBytes("ISO8859_1"),"GBK");
String userpwd=req.getParameter("userpwd");
if(username==null || userpwd==null) {
res.sendRedirect("login.jsp");
}else{
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(Exception ex) {
ex.printStackTrace();
}
try{
javax.sql.RowSet rs=getQuery("select * from login where username='"+username+"' and userpwd='"+userpwd+"'");
rs.beforeFirst();
if(!rs.next()) {
res.sendRedirect("login.jsp?logStatus=1");
}else{
out.println("<p align=\"center\">登录成功</p>");
}
}catch(Exception ex) {
ex.printStackTrace();
}
}
out.println("</body></html>");
}
/**Clean up resources*/
public void destroy() {
}
public javax.sql.RowSet getQuery(String sql) {
private sun.jdbc.rowset.CachedRowSet crs;
try {
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@myhost:1521:myOracle","usename","userpassword");
Statement Stmt = conn.createStatement();
java.sql.ResultSet rs= Stmt.executeQuery(sql);
crs=new CachedRowSet();
crs.populate(rs);
}catch(Exception ex) {
ex.printStackTrace();
}
return crs;
}
}
pengji 2002-05-14
- 打赏
- 举报
这种程序不是到处都是啊!?你可以去搞一个JSP+JAVABEAN做的BBS看看嘛!
Javatomchen 2002-05-14
- 打赏
- 举报
jsp:获取表单参数,strUser,strPWD
javaBean:连接数据库
执行下面的查询语句:
String strSQL="select * from "+dbname+"where user='"+strUser"'+pwd='"+strPWD+"'";
返回记录集不为空，登陆成功
javaBean:连接数据库
执行下面的查询语句:
String strSQL="select * from "+dbname+"where user='"+strUser"'+pwd='"+strPWD+"'";
返回记录集不为空，登陆成功
stavid 2002-05-14
- 打赏
- 举报
如果不用EJB，就用session （登陆）
jsp(html)->javaben（处理数据，）-》oracle
jsp(html)->javaben（处理数据，）-》oracle
