本文實例講述了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">nbsp;/td>
td width="42" wnameth="50">Input type="reset" name="h" value="重置">/td>
td width="33" wnameth="42">nbsp;/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>nbsp; /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="修改">nbsp; nbsp; nbsp;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程序設計有所幫助。
您可能感興趣的文章:- 國內常用的js類庫大全(CDN公共庫)
- Java幾種常用JSON庫性能比較詳解
- Python常用的json標準庫
- 常用的9個JavaScript圖表庫詳解
- JSP中操作數據庫的常用SQL標簽用法總結
- JavaScript 常用函數庫詳解
- 簡單了解常用的JavaScript 庫
