/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
import java.io.*;
import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.*;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
*
* @author Administrator
*/
public class login extends HttpServlet {
/**
* Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException, ClassNotFoundException, SQLException {
response.setContentType("text/html;charset=UTF-8");
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet 方法。单击左侧的 + 号以编辑代码。">
/**
* Handles the HTTP <code>GET</code> method.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
try {
processRequest(request, response);
} catch (ClassNotFoundException ex) {
Logger.getLogger(login.class.getName()).log(Level.SEVERE, null, ex);
} catch (SQLException ex) {
Logger.getLogger(login.class.getName()).log(Level.SEVERE, null, ex);
}
}
/**
* Handles the HTTP <code>POST</code> method.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
try {
processRequest(request, response);
} catch (ClassNotFoundException ex) {
Logger.getLogger(login.class.getName()).log(Level.SEVERE, null, ex);
} catch (SQLException ex) {
Logger.getLogger(login.class.getName()).log(Level.SEVERE, null, ex);
}
//response.setCharacterEncoding("UTF-8");
//byte[] b = request.getParameter("name").getBytes("ISO-8859-1");
//String t = new String(b,"GB2312");
String account = new String(request.getParameter("name").getBytes("iso-8859-1"),"GB2312");
String pin = new String(request.getParameter("PIN").getBytes("iso-8859-1"),"GB2312");
if (account.equals("guest") && pin.equals("*")) {
AnnoySet(request, response, "guest");
return;
}
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:OK");
java.sql.Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
String select = "Where Account='";
select += account + "' and Pin='";
select += pin + "'";
select = "select * from user " + select;
ResultSet rs = stmt.executeQuery(select); //建立ResultSet(结果集)对象，并执行SQL语句
if (!rs.next()) {
response.sendRedirect("index.jsp?errormsg=" + account);
return;
} else {
Set(request, response, account);
}
rs.close();
stmt.close();
con.close();
} catch (SQLException ex) {
response.sendRedirect("index.jsp?errormsg=" + account);
} catch (ClassNotFoundException ex) {
response.sendRedirect("index.jsp?errormsg=" + account);
}
}
private void Set(HttpServletRequest request, HttpServletResponse response, String account) {
PrintWriter out = null;
try {
response.setContentType("text/html;charset=GBK");
out = response.getWriter();
String name = new String(request.getParameter("name").getBytes("iso-8859-1"),"GB2312");
String html = "<html><body BGCOLOR='#889988' TEXT='#778899'> <center> " +
"<marquee behavior=slide direction=up><img src=topbg.jpg></marquee></center>" +
"<hr><marquee behavior=scroll direction=up height=8%><center><font size=7 color=668866 >Welcome ";
html += name + " to Our BBS Forum</font></marquee></center></marquee>";
html += "<marquee behavior=scroll direction=down height=8%><center><font size=7 color=668866 >Welcome ";
html += name + " to Our BBS Forum</font></marquee></center></marquee>";
out.println(html);
html = "<hr><br><br> <table width=100% border=0 cellspacing=0 cellpadding=0><tr>" +
"<td align=left><a href=EductTip.jsp?id=" + account + "|><font size=7 color=#006600/><b/>Education Area</td>" +
" <td align=center><a href=SportTip.jsp?id=" + account + "|><font size=7 color=#006600/><b/>Sport Zone</td>" +
" <td align=right><a href=RelaxTip.jsp?id=" + account + "|><font size=7 color=#006600/><b/>Leisure Region</td>" +
" </tr>" +
"</table>";
out.println(html);
html = "<hr><table width=100% border=0 cellspacing=0 cellpadding=0><tr color=#889988>" +
"<td ><marquee direction=right><a href=EductTip.jsp?id=" + account + "|><img src=Edu.jpg></marquee></td>" +
"<td ><marquee direction=left><a href=EductTip.jsp?id=" + account + "|><img src=Edu.jpg></marquee></td>" +
" <td ><marquee direction=right><a href=SportTip.jsp?id=" + account + "|><img src=Sport.jpg></marquee></td>" +
" <td ><marquee direction=left><a href=SportTip.jsp?id=" + account + "|><img src=Sport.jpg></marquee></td>" +
" <td ><marquee direction=right><a href=RelaxTip.jsp?id=" + account + "|><img src=Leisure.jpg></marquee></td>" +
" <td ><marquee direction=left><a href=RelaxTip.jsp?id=" + account + "|><img src=Leisure.jpg></marquee></td>" +
" </tr>" +
"</table>";
out.println(html);
html = "</body></html>";
out.println(html);
out.close();
} catch (IOException ex) {
Logger.getLogger(login.class.getName()).log(Level.SEVERE, null, ex);
} finally {
out.close();
}
}
private void AnnoySet(HttpServletRequest request, HttpServletResponse response, String guest) {
PrintWriter out = null;
try {
response.setContentType("text/html");
out = response.getWriter();
String html = "<html><body BGCOLOR='#889988' TEXT='#778899'> <center> " +
"<marquee behavior=slide direction=up><img src=topbg.jpg></marquee></center>" +
"<hr>" +
"<table width=100% border=0 cellspacing=0 cellpadding=0 >" +
"<tr><th><marquee direction=left height=8%><font size=7 color=668866 >muroF ";
html += "SBB ruO ot emocleW</font></marquee></marquee></th>";
html += "<th><marquee direction=right height=8%><font size=7 color=668866 >Welcome ";
html += "to Our BBS Forum</font></marquee></marquee></th></tr></table>";
out.println(html);
html = "<hr><br><br> <table width=100% border=0 cellspacing=0 cellpadding=0><tr>" +
"<td align=left><a href=
BBS.rar （84个子文件） 
BBS 
bbs.ldb 448B test build.xml 3KB bbs.mdb 444KB dist BBS.war 5.13MB src conf MANIFEST.MF 25B java login.java 10KB registed.java 6KB nbproject build-impl.xml 43KB private profiler configurations.xml 8KB private.xml 284B private.properties 3KB profiler-build-impl.xml 2KB ant-deploy.xml 3KB project.xml 683B genfiles.properties 628B project.properties 2KB web 
purple.jpg 117KB topbg.jpg 211KB Sport.jpg 43KB edu1.jpg 119KB elegent.jpg 15KB dm.jpg 249KB SportTip.jsp 11KB Publish.jsp 3KB WEB-INF web.xml 990B sun-web.xml 504B Delete_Modify.jsp 3KB Update.jsp 5KB ShowUserTip.jsp 7KB Reply.jsp 3KB
relax.bmp 1.37MB liu.bmp 1.37MB Read.jsp 9KB Edu.jpg 3KB index.jsp 3KB EductTip.jsp 11KB getbackpin.jsp 1KB Search.jsp 7KB regist.jsp 9KB yao.bmp 1.37MB green.jpg 24KB cloud.jpg 104KB olive.jpg 43KB Leisure.jpg 4KB RelaxTip.jsp 11KB ShowSubjectTip.jsp 473B OfferPin.jsp 4KB build-before-profiler.xml 3KB build web purple.jpg 117KB topbg.jpg 211KB Sport.jpg 43KB edu1.jpg 119KB elegent.jpg 15KB dm.jpg 249KB J2EE.dpf 504B META-INF MANIFEST.MF 25B SportTip.jsp 11KB Publish.jsp 3KB WEB-INF web.xml 990B classes login.class 7KB .netbeans_automatic_build 0B registed.class 5KB Update sun-web.xml 504B Delete_Modify.jsp 3KB Update.jsp 5KB ShowUserTip.jsp 7KB Reply.jsp 3KB relax.bmp 1.37MB liu.bmp 1.37MB Read.jsp 9KB Edu.jpg 3KB index.jsp 3KB EductTip.jsp 11KB getbackpin.jsp 1KB Search.jsp 7KB regist.jsp 9KB yao.bmp 1.37MB green.jpg 24KB cloud.jpg 104KB olive.jpg 43KB Leisure.jpg 4KB RelaxTip.jsp 11KB ShowSubjectTip.jsp 473B OfferPin.jsp 4KB资源评论
JaniceLu
- 粉丝: 94
- 资源: 1万+
最新资源
- 精选微信小程序源码：汤总便利小程序（门店店铺类）小程序（含源码+源码导入视频教程&文档教程，亲测可用）
- Excel弹窗“此工作簿包含到一个或多个可能不安全的外部源的链接” 场景范例
- C语言《基于ROS melodic，底盘控制器基于STM32的一个2D激光SLAM自主导小车》+项目源码+文档说明
- winform上位机图像采集控件.zip
- 工具变量全国供应链创新试点城市DID数据集（2007-2023年）.xlsx
- SasAppsUserKeyBarUserTech_86_1.0.0.1.kop
- 项目售后服务及培训.docx
- 贪心算法介绍及入门案例
- 项目实施管理方案.docx
- 精选微信小程序源码：熊猫签证小程序（含源码+源码导入视频教程&文档教程，亲测可用）
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
