jsp+mysql数据库操作常用方法实例总结-巨人网络通讯

主页 > 知识库 > jsp+mysql数据库操作常用方法实例总结

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

本文实例讲述了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 库

标签：西藏红河丹东云浮江西宿州贵州青岛

巨人网络通讯声明：本文标题《jsp+mysql数据库操作常用方法实例总结》，本文关键词 jsp+mysql,数据库,操作,常用,；如发现本文内容存在版权问题，烦请提供相关信息告之我们，我们将及时沟通与处理。本站内容系统采集于网络，涉及言论、版权与本站无关。