栏目导航
热点推荐
- 流行的70个AJAX演示及下载
- 20个Ajax关键议题
- AJAX技术在PHP开发中的简单应用
- 如何选择使用AJAX的最佳时机
- 一日精通Ajax技术
- [四天学会ajax] 学习Ajax教程第
- [四天学会ajax] 学习Ajax教程第
- ajax的server部分(php版)
- 在Ajax 应用程序中实现数据之间
- 解决AJAX 跨域访问完整解决方案
- Ajax获取页面被缓存的解决方案
- ajax检测用户名
阅览排行
AJAX教程第一章—初识AJAX
www.jz123.cn 2009-10-26 来源: 中国建站 责任编辑(袁袁) 我要投递新闻
DB.java代码如下:
package classmate; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class DB { Connection conn = null; Statement stmt = null; ResultSet rs = null; public DB(){ try{ Class.forName("com.mysql.jdbc.Driver"); //System.out.println("classdb"); }catch(java.lang.ClassNotFoundException e){ e.printStackTrace(); } } public ResultSet executeQuery(String sql){ try{ conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/ajaxtest", "root", "888888"); //System.out.println("conn"); stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); //System.out.println("stmt"); rs = stmt.executeQuery(sql); //System.out.println("rs"); }catch(SQLException e){ e.printStackTrace(); } return rs; } public int executeUpdate(String sql){ int result = 0; try{ conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/ajaxtest?useunicode=true&characterEncoding=GBK", "root", "888888"); stmt = conn.createStatement(); result = stmt.executeUpdate(sql); }catch(SQLException e){ System.out.println(e.getMessage()); } return result; } public void close(){ if(rs != null){ try{ rs.close(); }catch(Exception e1){ e1.printStackTrace(); } } if(stmt != null){ try{ stmt.close(); }catch(Exception e1){ e1.printStackTrace(); } } if(conn != null){ try{ conn.close(); }catch(Exception e1){ e1.printStackTrace(); } } } } |
LoginAction.java代码如下:
package classmate; import java.io.IOException; import java.io.PrintWriter; import java.sql.ResultSet; import java.sql.SQLException; import javax.servlet.ServletConfig; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class LoginAction extends HttpServlet { @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { // TODO Auto-generated method stub req.setCharacterEncoding("UTF-8"); String uname = req.getParameter("uname"); String pwd = req.getParameter("pwd"); resp.setContentType("text/xml;charset=UTF-8"); resp.setHeader("Cache-Control", "no-cache"); PrintWriter out = resp.getWriter(); out.println(""); DB db = new DB(); ResultSet rs; String strSql = null; strSql = "select * from classuser where username='" + uname + "' and password='" + pwd + "';"; rs = db.executeQuery(strSql); try{ if(rs.next()){ out.println("" + "热烈欢迎" + ""); }else{ out.println("" + "登陆失败" + ""); } }catch(SQLException e){ e.printStackTrace(); } out.println(""); out.close(); } @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { // TODO Auto-generated method stub super.doGet(req, resp); } @Override public void init(ServletConfig config) throws ServletException { // TODO Auto-generated method stub } } |
web.xml代码如下:
<?xml version="1.0" encoding="UTF-8"?> <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5"> <display-name>ajaxtest</display-name> <servlet> <servlet-name>login</servlet-name> <servlet-class>classmate.LoginAction</servlet-class> </servlet> <servlet-mapping> <servlet-name>login</servlet-name> <url-pattern>/login</url-pattern> </servlet-mapping> <welcome-file-list> <welcome-file>login.jsp</welcome-file> </welcome-file-list> </web-app> |
这样就完成了AJAX实践咯。
有联系请联系QQ:540528747,我也在学习AJAX,大家一起研究,欢迎各位朋友一起交流技术。
本文出自 “sidney思派” 博客,请务必保留此出处http://sidneyyoung.blog.51cto.com/932743/212302
0
上一篇:20个Ajax关键议题 下一篇: Ajax学习:与其他库一起使用jQuery