本文实例讲述了jsp+mysql数据库操作常用方法。分享给大家供大家参考。具体如下:
1. 查看:
<style>
<!--
body {
background-color: #99CCFF;
}
-->
</style>
<font>
</font><center>
");
out.print("<tr><td>考生数据</td></tr>");
out.print("<tr><td><a>添加考生信息</a></td></tr>");
out.print("<tr>");
out.print("<td>"+"姓名");
out.print("</td>
<td>"+"年龄");
out.print("</td>
<td>"+"出生日期");
out.print("</td>
<td>"+"操作");
out.print("</td>
</tr>");
while(rs.next())
{ out.print("<tr>");
out.print("<td>"+rs.getString(2)+"</td>");
out.print("<td>"+rs.getString(3)+"</td>");
out.print("<td>"+rs.getString(4)+"</td>");
String idstr=rs.getString(1);
out.print("<td><a>删除</a></td>");
out.print("<td><a>修改</a></td>");
out.print("</tr>") ;
}
out.print("");
con.close();
}
catch(SQLException e1)
{
out.print("SQL异常!!!!");
}
%>
</center>
2. add 添加:
<style>
<!--
body {
background-image: url();
background-color: #CCCCFF;
}
.STYLE5 {font-family: "Courier New", Courier, monospace; font-size: 14px; }
.STYLE6 {
font-family: "Courier New", Courier, monospace;
font-size: 24px;
}
-->
</style><meta><font>
<p>添加考生信息</p>
</font><center>
<form>
<table>
<tr>
<td><span>姓名:</span></td>
<td><input></td>
</tr>
<tr>
<td><span>年龄:</span></td>
<td><input></td>
</tr>
<tr>
<td><span>出生年月:</span></td>
<td><input></td>
</tr>
</table>
<table>
<tr>
<td><input></td>
<td> </td>
<td><input></td>
<td> </td>
</tr>
</table>
</form>
</center>
3. delete 删除:
<title>删除操作</title>
<meta><style>
<!--
body {
background-color: #FFCCFF;
}
-->
</style>
<center>
");
out.print("<tr><td>考生数据</td></tr>");
out.print("<tr><td><a>添加考生信息</a></td></tr>");
out.print("<tr>");
out.print("<td>"+"姓名");
out.print("</td>
<td>"+"年龄");
out.print("</td>
<td>"+"出生日期");
out.print("</td>
<td>"+"操作");
out.print("</td>
</tr>");
while(rs.next())
{ out.print("<tr>");
out.print("<td>"+rs.getString(2)+"</td>");
out.print("<td>"+rs.getString(3)+"</td>");
out.print("<td>"+rs.getString(4)+"</td>");
String idstr=rs.getString(1);
out.print("<td>"+idstr+"</td>");
out.print("<td><a>删除</a></td>");
out.print("<td><a>修改</a></td>");
out.print("</tr>") ;
}
out.print("");
con.close();
}
catch(SQLException e1)
{
out.print("SQL异常!!!!");
}
%>
</center>
4. update 示例1:
html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<meta><title>无标题文档</title><style>
<!--
body {
background-color: #FFCCFF;
}
-->
</style><center>
<form>
<center>
<p> </p>
<p>姓名:
<input>">
</p>
<p>
年龄:
<input>">
</p>
<p>出生日期:
<input>">
<input>" />
</p>
<p><input> <input></p>
</center>
</form>
</center>
5. update 示例2:
恭喜你,修改成功!<br><a>查看</a>
6. insert 插入
恭喜你,添加成功!<br><a>查看</a>
7. 创建数据库
/* MySQL Data Transfer Source Host: localhost Source Database: student Target Host: localhost Target Database: student Date: 2009-3-27 13:24:01 */ SET FOREIGN_KEY_CHECKS=0; create database student; use student; -- ---------------------------- -- Table structure for student -- ---------------------------- CREATE TABLE `student` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) default NULL, `age` varchar(255) default NULL, `birth` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gbk;
希望本文所述对大家的JSP程序设计有所帮助。
更多jsp+mysql数据库操作常用方法实例总结相关文章请关注PHP中文网!










