1、 * author Administrator * TODO 要更改此生成的类型注释的模板,请转至public class UserDao String url = jdbc:microsoft:sqlserver:/localhost:1433;DatabaseName=db_database04; String username=sa String password=sql /数据库密码 private Connection con = null; private Statement stmt = null; private ResultSet rs = null; public User
2、Dao() /通过构造方法加载数据库驱动 try Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver); catch (Exception ex) System.out.println(数据库加载失败 public boolean Connection() /创建数据库连接 con = DriverManager.getConnection(url, username, password); catch (SQLException e) System.out.println(e.getMessage();creatConnect
3、ionError! return true; /对数据库的查询操作 public ResultSet selectStatic(String sql) throws SQLException ResultSet rs=null; if (con = null) Connection(); stmt = con.createStatement(); rs = stmt.executeQuery(sql); e.printStackTrace(); closeConnection(); return rs; /更新数据库 public boolean executeUpdate(String sq
4、l) int iCount = stmt.executeUpdate(sql);操作成功,所影响的记录数为 + String.valueOf(iCount); return false; /关闭数据库的操作 public void closeConnection() if (con != null & stmt ! rs != null) rs.close(); stmt.close(); con.close();Failed to close connection! finally con = null;4. 创建Filter,解决字符乱码问题Filter也是一个Java类,所以创建方法和创
5、建“UserDao.java”是一样的,右键src-Class,填写包名“com.pkh.charset”,类名“CharacterEncodingFilter”,其他选项保持默认值,点击Finish。创建完成,在目录结构中可以看到“CharacterEncodingFilter.java“文件。package com.pkh.charset;import java.io.IOException;import javax.servlet.Filter;import javax.servlet.FilterChain;import javax.servlet.FilterConfig;impor
6、t javax.servlet.ServletException;import javax.servlet.ServletRequest;import javax.servlet.ServletResponse;public class CharacterEncodingFilter implements Filter protected String encoding = null; protected FilterConfig filterConfig = null; public void init(FilterConfig config) throws ServletException
7、 /TODO Method stub generated by Lomboz this.filterConfig = config; this.encoding = filterConfig.getInitParameter(encoding public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException if (encoding ! request.setCharacterEncoding(encodin
8、g); response.setContentType(text/html; charset=+encoding); chain.doFilter(request, response); public void destroy() this.encoding = null; this.filterConfig = null; public FilterConfig getFilterConfig() return null; public void setFilterConfig(FilterConfig config)5. 创建jsp文件“index.jsp”%page contentTyp
9、e= charset=UTF-8 import=java.sql.* errorPage=% htmlheadmeta http-equiv=Content-Type content= charset=gbklink href=css/style.css type=text/css rel=stylesheet% boolean flag = false; if (request.getParameter(id) ! String id = request.getParameter( String sql = delete from tb_userOperation where id= + i
10、d + if (dao.executeUpdate(sql) flag = true;title删除指定记录/headbodytable width=500 height=395 border=0 cellpadding= cellspacing= align=center trtd background=images/1.giftable border= tr align=70tdnbsp;/td/trtd width=80编号姓名性别职业操作namesexprofessiona href=index.jsp?id=删除% catch (Exception e) %/table if (fl
11、ag) out.print(删除数据成功!/body/html6. 创建web.xml?xml version=1.0 encoding=web-app version=2.4 xmlns= xmlns:xsi=http:/www.w3.org/2001/XMLSchema-instance xsi:schemaLocation= filter-nameCharacterEncodingFilterfilter-classcom.pkh.charset.CharacterEncodingFilterinit-paramparam-nameencodingparam-valueUTF-8/ini
12、t-param/filterfilter-mappingurl-pattern/*dispatcherREQUESTFORWARDINCLUDEwelcome-file-listwelcome-fileindex.jsp/welcome-file-list/web-app7.引入JDBC驱动包“webproject2”右键-Build Path-Add External Archives,选择JBDC的三个文件:msbase.jar、mssqlserver.jar、msutil.jar。完成后,在目录结构中可以看到引入的三个文件。8.部署和访问点击部署按钮,选择“webproject1”,点击Add按钮,选择Tomcat6.x,点击Finish。服务器按钮,选择Tomcat6.x,选择Start启动Tomcat服务器,在控制台窗口可以看到启动信息“Server startup in 743 ms”,表示启动成功。打开浏览器,输入http:8080/webproject2/,出现人员信息界面,表示访问成功。9.测试点击删除超链接,显示“删除数据成功!”,从数据库中删除了一条数据。
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1