


求jsp写的修改个人信息的代码!数据库是access。
String path = request.getContextPath();
String basePath = request.getScheme() "://" request.getServerName() ":" request.getServerPort() path "/";
UserinfoBean userinfo=(UserinfoBean)session.getAttribute("userinfors");
%>
UserinfoBean userinfoBean = (UserinfoBean)request.getSession().getAttribute("userinfoBean");
%>
HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<script> <br /> function IsDigit(cCheck) <br /> { <br /> return (('0'<=cCheck) && (cCheck<='9')); <br /> } <br /> <br /> function IsAlpha(cCheck) <br /> { <br /> return ((('a'<=cCheck) && (cCheck<='z')) || (('A'<=cCheck) && (cCheck<='Z'))) <br /> } <br /> <br /> function IsValid() <br /> { <br /> var struserName = reg.UserName.value; <br /> for (nIndex=0; nIndex<struserName.length; nIndex ) <br /> { <br /> cCheck = struserName.charAt(nIndex); <br /> if (!(IsDigit(cCheck) || IsAlpha(cCheck))) <br /> { <br /> return false; <br /> } <br /> } <br /> return true; <br /> } <br /> function chkEmail(str) <br /> { <br /> return str.search(/[w-]{1,}@[w-]{1,}.[w-]{1,}/)==0?true:false ; <br /> } <br /> <br /> function docheck() <br /> { <br /> if(reg.NickName.value =="") <br /> { <br /> alert("昵称不能为空"); <br /> return false; <br /> } <br /> else if(reg.Email.value =="") <br /> { <br /> alert("邮箱不能为空"); <br /> return false; <br /> } <br /> else if(!chkEmail(reg.Email.value)) <br /> { <br /> alert("请填写有效的Email地址"); <br /> return false; <br /> } <br /> else <br /> { <br /> return true; <br /> } <br /> } <br /> </script>
/image/content.jpg">
尊敬的请修改个人资料
action="/servlet/lybControServlet"
method="post" onSubmit="docheck()">
face="Arial, Helvetica, sans-serif">用户名: |
name="UserName" readonly value=""> value="edituser"> |
请修改昵称: | name="NickName"> |
请修改性别: | name="Sex" value="0" checked>男 name="Sex" value="1">女 |
请修改Email地址: | name="Email"> |
name="res" value="重填">
这是前台的代码,后台方法怎么写?
回复讨论(解决方案)
我的问题 难还是?
public void changeUserInfo(HttpServletRequest req, HttpServletResponse res) throws IOException, SQLException{
int user_id = Integer.parseInt(req.getParameter("user_id"));
UserinfoBean userinfoBean = new UserinfoBean();
userinfoBean.setUser_name("");
userinfoBean.setUser_nicheng("");
userinfoBean.setUser_sex("");
userinfoBean.setUser_mail("");
userinfoBean.setUser_id(user_id);
HttpSession session = req.getSession() ;
session.setAttribute("userinfoBean", userinfoBean);
res.sendRedirect(req.getContextPath() "/jsp/mofy.jsp");
}
这个方法我已经能调用了 但是没有写,不会 菜鸟,求大神高数我怎么写
在docheck()方法内实现写入数据库就可以。你看看用struts框架怎么搞吧
求更改代码码,struts框架没用过
给你写了一个简单的,
首先真的很简单,是W7 mysql5.5 servlet
mysql的sql语句:
create database person;use personcreate table student( id int not null auto_increment, username varchar(100), name varchar(50), sex varchar(10), email varchar(50), primary key(id));-- 插入一条测试数据insert into student(username,name,sex,email)values('test123','fdsaas','1','fdsafkldjsklfds@qq.com');
------------------
下面是Java部分:
DB类[时间仓促,可改进地方很多,自己慢慢练吧]
package test;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.Statement;/** * Created by prd on 2014/11/6. */public class DB { private Connection conn = null; /** * 获取连接 * * @return * @throws java.sql.SQLException */ public Connection getConn() { try { Class.forName("com.mysql.jdbc.Driver");// 加载Mysql数据驱动 conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/person", "root", "123456"); return conn; } catch (Exception e) { e.printStackTrace(); } return conn; } /** * 关闭连接 * * @throws SQLException */ public void closeConn() { try { if (conn != null && conn.isClosed()) { conn.close(); } } catch (SQLException e) { e.printStackTrace(); } } /** * 更新数据. * <p/> * 数组分别是:username,name,sex,email, * id为固定.可动态修改. * * @param params * @return */ public int update(String[] params) { conn = getConn(); String sql = " update student set username='" + params[0] + "',name='" + params[1] + "',sex='" + params[2] + "',email='" + params[3] + "' where id=1 "; Statement st = null; int count = 0; try { st = conn.createStatement(); count = st.executeUpdate(sql); } catch (SQLException e) { e.printStackTrace(); } closeConn(); return count; }}
下面是servlet类:
package test;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import java.io.IOException;/** * Created by prd on 2014/11/6. */public class UpdateUserServlet extends HttpServlet { protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); String name = request.getParameter("name"); String username = request.getParameter("username"); String sex = request.getParameter("sex"); String email = request.getParameter("email"); if(sex.equals("0")) { sex="男"; }else { sex="女"; } DB db = new DB(); int count =db.update(new String[]{username,name,sex,email}); if(count>0) { System.out.println("更新成功"); }else { System.out.println("更新失败"); } } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { }}
下面是jsp页面[ 替换你原来的表单部分]:
<form name="reg" action="<%=request.getContextPath()%>/servlet/UpdateUserServlet" method="post" onSubmit="docheck()"> <table width="90%" border="0"> <tr> <td width="50%" align="right" height="25"><font face="Arial, Helvetica, sans-serif">用户名:</font></td> <td width="50%" align="left" height="25"><input type="text" name="username" value=""> <input type="hidden" name="method" value="edituser"> <br> </td> </tr> <tr> <td width="50%" align="right" height="25">请修改昵称:</td> <td width="50%" align="left" height="25"><input type="text" name="name"></td> </tr> <tr> <td width="50%" align="right" height="25">请修改性别:</td> <td width="50%" align="left" height="25"><input type="radio"h name="sex" value="0" checked>男 <input type="radio" name="sex" value="1">女</td> </tr> <tr> <td width="50%" align="right" height="25">请修改Email地址:</td> <td width="50%" align="left" height="25"><input type="text" name="email"></td> </tr> </table> <p> <input type="submit" name="sub" value="更改"> <input type="reset" name="res" value="重填"> </p> <p> <a href="index.jsp">返回</a> </p> </form>
下面是web.xml的配置:
<?xml version="1.0" encoding="UTF-8"?><web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" version="3.1"> <servlet> <servlet-name>UpdateUserServlet</servlet-name> <servlet-class>test.UpdateUserServlet</servlet-class> </servlet> <servlet-mapping> <servlet-name>UpdateUserServlet</servlet-name> <url-pattern>/servlet/UpdateUserServlet</url-pattern> </servlet-mapping></web-app>
记得一定要导入mysql的驱动包,直接百度搜索java连接mysql驱动包就可以,加入到项目里面。
如果你要用access,改掉这两句就可以了.
Class.forName("com.mysql.jdbc.Driver");// 加载Access数据的驱动 conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/person", "root", "123456");//连接地址
sql code这个放到那里,表已经有了,叫userinfo,而且那个db 最下面的更新数据我怎么加到我的db里面啊
大神,完全跟你写的不一样,我已经打私信给你了,你打开加我qq远成协助一下你就知道怎么回事了

The article discusses the HTML <datalist> element, which enhances forms by providing autocomplete suggestions, improving user experience and reducing errors.Character count: 159

The article discusses the HTML <progress> element, its purpose, styling, and differences from the <meter> element. The main focus is on using <progress> for task completion and <meter> for stati

The article discusses using HTML5 form validation attributes like required, pattern, min, max, and length limits to validate user input directly in the browser.

The article discusses the <iframe> tag's purpose in embedding external content into webpages, its common uses, security risks, and alternatives like object tags and APIs.

The article discusses the HTML <meter> element, used for displaying scalar or fractional values within a range, and its common applications in web development. It differentiates <meter> from <progress> and ex

Article discusses best practices for ensuring HTML5 cross-browser compatibility, focusing on feature detection, progressive enhancement, and testing methods.

The article discusses the viewport meta tag, essential for responsive web design on mobile devices. It explains how proper use ensures optimal content scaling and user interaction, while misuse can lead to design and accessibility issues.

This article explains the HTML5 <time> element for semantic date/time representation. It emphasizes the importance of the datetime attribute for machine readability (ISO 8601 format) alongside human-readable text, boosting accessibilit


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.

Atom editor mac version download
The most popular open source editor

MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.
