当前位置： 移动技术网 > IT编程>开发语言>Java > jsp+mysql数据库操作常用方法实例总结

jsp+mysql数据库操作常用方法实例总结

2017年12月12日  | 移动技术网IT编程  | 我要评论

本文实例讲述了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程序设计有所帮助。

您可能感兴趣的文章:

如对本文有疑问， 点击进行留言回复！！

相关文章:

验证码：
最近更新的文章
大家感兴趣的文章
移动技术网