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程序设计有所帮助。

以上是 jsp+mysql数据库操作常用方法实例总结 的全部内容, 来源链接: utcz.com/z/320722.html

回到顶部