本文实例讲述了jsp+mysql数据库操作常用方法。分享给大家供大家参考。具体如下：
1. 查看：
<%@ page contenttype="text/html;charset=gb2312" %>
<%@ page import="java.sql.*" %>
<html><style type="text/css">
<!--
body {
background-color: #99ccff;
}
-->
</style>
<body>
<font color="#ffffff">
<center>
<% connection con;
class.forname("com.mysql.jdbc.driver");
con = drivermanager.getconnection("jdbc:mysql://localhost:3306/student","root","123456");
statement sql;
resultset rs;
try
{
sql=con.createstatement();
rs=sql.executequery("select * from student");
out.print("<table border style='font-size: 10pt'>");
out.print("<tr><td colspan=5 align=center>考生数据</td></tr>");
out.print("<tr><td colspan=5 align=center><a href='add.jsp' target='_self'>添加考生信息</a></td></tr>");
out.print("<tr>");
out.print("<td width=50 >"+"姓名");
out.print("<td width=100 >"+"年龄");
out.print("<td width=100>"+"出生日期");
out.print("<td width=100 colspan=2>"+"操作");
out.print("</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 href='delete.jsp?id="+idstr+"'>删除</a></td>");
out.print("<td><a href='update.jsp?id="+idstr+"'>修改</a></td>");
out.print("</tr>") ;
}
out.print("</table>");
con.close();
}
catch(sqlexception e1)
{
out.print("sql异常！！！！");
}
%>
</center>
</body>
</html>
2. add 添加：
<%@ page contenttype="text/html;charset=gb2312" %>
<html><head>
<style type="text/css">
<!--
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 http-equiv="content-type" content="text/html; charset=gb2312"></head>
<body>
<font size=2>
<p align="center" class="style6">添加考生信息</p>
<center>
<form action="insert.jsp" name=form>
<table>
<tr><td height="36"><span class="style5">姓名:</span></td>
<td><input name="name" type=text size="15" ></td></tr>
<tr>
<td height="36"><span class="style5">年龄:</span></td>
<td><input name="age" type=text size="15"></td></tr>
<tr>
<td height="36"><span class="style5">出生年月:</span></td>
<td><input name="birth" type=text size="15"></td></tr>
</table>
<table width="165">
<tr><td width="42" wnameth="42"><input type=submit name="g" value="添加"></td>
<td width="28" wnameth="50"> </td>
<td width="42" wnameth="50"><input type="reset" name="h" value="重置"></td>
<td width="33" wnameth="42"> </td>
</tr>
</table>
</form></center>
</body></html>
3. delete 删除：
<%@ page contenttype="text/html;charset=gb2312" %>
<%@ page import="java.sql.*" %>
<html>
<head>
<title>删除操作</title>
<meta http-equiv="content-type" content="text/html; charset=gb2312"><style type="text/css">
<!--
body {
background-color: #ffccff;
}
-->
</style></head>
<body>
<center>
<% connection con;
class.forname("com.mysql.jdbc.driver");
con = drivermanager.getconnection("jdbc:mysql://localhost:3306/student","root","123456");
statement stmt;
statement s;
resultset rs;
string id=request.getparameter("id");
try
{
stmt=con.createstatement();
string sql="delete from student where id="+id;
stmt.executeupdate(sql);
s=con.createstatement();
rs=s.executequery("select * from student");
out.print("<table border style='font-size: 10pt'>");
out.print("<tr><td colspan=5 align=center>考生数据</td></tr>");
out.print("<tr><td colspan=5 align=center><a href='add.jsp' target='_self'>添加考生信息</a></td></tr>");
out.print("<tr>");
out.print("<td width=50 >"+"姓名");
out.print("<td width=100 >"+"年龄");
out.print("<td width=100>"+"出生日期");
out.print("<td width=100 colspan=2>"+"操作");
out.print("</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 href='delete.jsp?id="+idstr+"'>删除</a></td>");
out.print("<td><a href='update.jsp?id="+idstr+"'>修改</a></td>");
out.print("</tr>") ;
}
out.print("</table>");
con.close();
}
catch(sqlexception e1)
{
out.print("sql异常！！！！");
}
%>
</center>
</body>
</html>
4. update 示例1：
<%@ page contenttype="text/html; charset=gb2312" language="java" import="java.sql.*" errorpage="" %>
<!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
body {
background-color: #ffccff;
}
-->
</style></head>
<body>
<%string id=request.getparameter("id");
connection con;
string name=null;
string age=null;
string birth=null;
string id1=null;
class.forname("com.mysql.jdbc.driver");
con = drivermanager.getconnection("jdbc:mysql://localhost:3306/student","root","123456");
statement sql;
resultset rs;
try
{
sql=con.createstatement();
rs=sql.executequery("select * from student");
while(rs.next())
{
name=rs.getstring(2);
age=rs.getstring(3);
birth=rs.getstring(4);
id1=rs.getstring(1);
}
con.close();
}
catch(sqlexception e1)
{
out.print("sql异常！！！！");
}
%>
<center>
<form action="update2.jsp">
<center>
<p> </p>
<p>姓名：
<input name="name" type="text" size="15" value="<%=name%>">
</p>
<p>
年龄：
<input name="age" type="text" size="15" value="<%=age%>">
</p>
<p>出生日期：
<input name="birth" type="text" size="15" value="<%=birth%>">
<input name="id1" type="hidden" value="<%=id1%>" />
</p>
<p><input name="g" type="submit" value="修改"> <input name="h" type="reset" value="重置"></p>
</form>
</center>
</body>
</html>
5. update 示例2：
<%@ page contenttype="text/html;charset=gb2312" %>
<%@ page import="java.sql.*" %>
<%
string name=request.getparameter("name");
string age=request.getparameter("age");
string birth=request.getparameter("birth");
string id1=request.getparameter("id1");
system.out.println(id1);
connection con=null;
try
{
class.forname("com.mysql.jdbc.driver");
con = drivermanager.getconnection("jdbc:mysql://localhost:3306/student","root","123456");
statement sql;
sql=con.createstatement();
string sql2="update student set name='"+name+"',age='"+age+"',birth='"+birth+"' where id="+id1;
system.out.print(sql2);
int s=sql.executeupdate(sql2);
}
catch(exception e){
system.out.println(e);
}
%>
恭喜你，修改成功！<br />
<a href="chakan.jsp">查看</a>
6. insert 插入
<%@ page contenttype="text/html;charset=gb2312" %>
<%@ page import="java.sql.*" %>
<%
string name=request.getparameter("name");
string age=request.getparameter("age");
string birth=request.getparameter("birth");
connection con=null;
try
{
class.forname("com.mysql.jdbc.driver");
con = drivermanager.getconnection("jdbc:mysql://localhost:3306/student","root","123456");
statement sql;
sql=con.createstatement();
string sql2="insert into student(name,age,birth) values('"+name+"','"+age+"','"+birth+"')";
system.out.print(sql2);
int s=sql.executeupdate(sql2);
}
catch(exception e){
system.out.println(e);
}
%>
恭喜你，添加成功！<br />
<a href="chakan.jsp">查看</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程序设计有所帮助。
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！