如何使用JSP将数据存储在数据库中 [英] how to store data in database using JSP

问题描述

<tr>
 
                            <td class="text7">*</td>
 
                            <td class="text4">Name</td>
 
                            <td class="blacktext11"><input name="pname"  type="text" class="border2"  style="width: 180px;" /></td>
 
                          </tr>
 
                          <tr>
 
                            <td valign="top" class="text7">*</td>
 
                            <td class="text4" valign="top">Address</td>
 
                            <td class="blacktext11"><textarea name="address" cols="20" rows="2" class="border2"  style="width: 180px;" ></textarea></td>
 
                          </tr>
 
                          <tr>
 
                            <td class="text7">*</td>
 
                            <td class="text4">Contact Number</td>
 
                            <td class="blacktext11" valign="top"><input name="contact"  type="text" class="border2"  style="width: 180px;" /></td>
 
                          </tr>
 
                          <tr>
 
                            <td class="text7">*</td>
 
                            <td class="text4">Email Address</td>
 
                            <td class="blacktext11" valign="top"><input name="email" class="border2" style="width: 180px;"  type="text" /></td>
 
                          </tr>
 
                          <tr>
 
                            <td class="text7">*</td>
 
                            <td class="text4">Subject</td>
 
                            <td class="blacktext11" valign="top"><input name="subject" class="border2" style="width: 180px;" type="text" /></td>
 
                          </tr>
 
                          <tr>
 
                            <td class="text7">*</td>
 
                            <td class="text4">Comments</td>
 
                            <td class="blacktext11" valign="top"><textarea cols="20" rows="2" name="comments" class="border2" style="width: 180px;"></textarea></td>
 
                          </tr>
 
                          <tr>
 
                            <td> </td>
 
                            <td> </td>
 
                            <td style="text-align: left;" align="left"><input name="submit"  value="Submit" style="width: 60px; font-family:Arial, Helvetica, sans-serif; font-size:12px; color:#FFFFFF; font-weight:bold; border:1px solid #CCCCCC; background-color:#000000;" type="submit" />
 
                                
 
                              <input name="reset"  style="width: 60px; font-family:Arial, Helvetica, sans-serif; font-size:12px; color:#FFFFFF; font-weight:bold; border:1px solid #CCCCCC; background-color:#000000;" value="Reset" type="reset" />
 
                            </td>
 
                          </tr>

这些是我网站上的文本框.我想将这些字段数据存储在主机上的database.database中.
我的数据库名称是
"mis-db"
我数据库的字段是
名称，地址，联系电话，电子邮件，主题，评论
当用户单击提交"按钮时，这些字段数据必须存储在我的数据库中，
然后我的文本框对于下一个用户或下一个注释必须为空

但是我不知道如何执行此任务.所以请帮帮我.
提前非常感谢...

these are my text boxes which are in my website.i want to store these fields data in my database.database in on my hosting
my database name is
"mis-db"
and fields of my database are
name,address,contact number,email,subject,comments
when user click on submit button these fields data must store in my database,
and after that my text boxes must be empty for next user,or next comments

but i don''t know how can i perform this task.so please help out me.
thanks a lot in advance...

推荐答案

在此链接中尝试第一个答案

如何使用html + jsp [使用准备好的语句通过jsp在mysql数据库中插入数据 [

Try the 1st answer in this link

how to insert data in database using html+jsp[^]

EDIT
-----------------------
Insert data in mysql database through jsp using prepared statement[^]

这篇关于如何使用JSP将数据存储在数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！