100 points for jsp servlet questions. Can you take them all_html/css_WEB-ITnose

求jsp写的修改个人信息的代码！数据库是access。
8ea34c13f5ee190d9584130bf24cf537
9a4ec0d93f040a5cc60c085c5e7510d0
4de58c63270ca2bf56ba78f5d69d346a
83183605e3da2bae59f8a17841c21066
da985fd7cfd455149f72f088bcf1640b
5e5200d5a3232c4a41f658de43b68682

eacfe5c98fd51b64d547f9b34e767f01
100db36a723c770d327fc0aef2ce13b1
93f0f5c25f18dab9d176bd4f6de5d30e
bf8013613327e9c91f09b515fd16eab7 
function IsDigit(cCheck) 
{ 
return (('0'884902482f91960e1024c0bd93252d81
2152286ec1283e1f019fa3edb9f85059
td,th {
font-family: Arial, Helvetica, sans-serif;
font-size: 14px;
line-height: 24px;
color: #333333;
}

img {
background-repeat: none;
background-position: center;
}
a2d87b9af1e305217ec9648d1e8a0a47
9c3bca370b5104690d9ef395f2c5f8d1

4c0689f7a7c67762f2ead4394ad0efe3/image/content.jpg">

         c4c301dcb1be101387d74f534d7a2778尊敬的9a9c638221ccb0578231f1f2993597e889ebc65ab00c00e024876424e0ba31c354bdf357c58b8a65c66d7c19c8e4d114请修改个人资料473f0a7621bec819994bb5020d29372a
21296ce11a81ae463c84d9d11841395d
b8855cfe8461639c2d1299b6a9dde4ca/servlet/lybControServlet"
method="post" onSubmit="docheck()">
62af02dbd00361d7a017da56014ce9de
a34de1251f0d9fe1e645927f19a896e8
35dddbd68a7cd631b1c061dc2fbb5831a9ef2fa1c18333df6529b9b0d7743c8a用户名：e6e38b3c62e8df885fe2e3986461aa63b90dd5946f0946207856a8a37f441edf
b996519a06c773e629e2f8a47d245fce8b2f7b5bafffae0cc7330a8d69f59168"> 3ac56ae2fb374f77cb0791e8d89427c2 0c6dc11e160d3b678d68754cc175188a 
b90dd5946f0946207856a8a37f441edf
fd273fcf5bcad3dfdad3c41bd81ad3e5
a34de1251f0d9fe1e645927f19a896e8
35dddbd68a7cd631b1c061dc2fbb5831请修改昵称：b90dd5946f0946207856a8a37f441edf
b996519a06c773e629e2f8a47d245fce9b82f53ff7038389717eae092dbe5bd4b90dd5946f0946207856a8a37f441edf
fd273fcf5bcad3dfdad3c41bd81ad3e5
a34de1251f0d9fe1e645927f19a896e8
35dddbd68a7cd631b1c061dc2fbb5831请修改性别：b90dd5946f0946207856a8a37f441edf
b996519a06c773e629e2f8a47d245fce52f4d67e967d81b6eec080fef690660c男 d5291f3a9ad737a7e0f6188b68aca8b9女b90dd5946f0946207856a8a37f441edf
fd273fcf5bcad3dfdad3c41bd81ad3e5
a34de1251f0d9fe1e645927f19a896e8
35dddbd68a7cd631b1c061dc2fbb5831请修改Email地址：b90dd5946f0946207856a8a37f441edf
b996519a06c773e629e2f8a47d245fcedad40cec6a0ad125cd55b9ba533b5a8db90dd5946f0946207856a8a37f441edf
fd273fcf5bcad3dfdad3c41bd81ad3e5
f16b1740fad44fb09bfe928bcc527e08
e388a4556c0f65e1904146cc1a846bee
ee19a338397b49e3d9171357d95b2a3d 8d0abc56909067734374fbff5cb6f394
94b3e26ee717c64999d7867364b1b4a3
e388a4556c0f65e1904146cc1a846bee
5d9317694b6bae4484c48179b88f136f返回5db79b134e9f6b82c0b36e0489ee08ed
94b3e26ee717c64999d7867364b1b4a3
f5a47148e367a6035fd7a2faa965022e
16b28748ea4df4d9c2150843fecfba68
36cc49f0c466276486e50c850b7e4956
73a6ac4ed44ffec12cee46588e518a5e
这是前台的代码，后台方法怎么写？

回复讨论(解决方案)

我的问题 难还是？

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远成协助一下你就知道怎么回事了