Python语言技术文档

微信小程序技术文档

php语言技术文档

jsp语言技术文档

asp语言技术文档

C#/.NET语言技术文档

html5/css技术文档

javascript

点击排行

您现在的位置:首页 > 技术文档 > jsp入门教程

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

来源:中文源码网    浏览:420 次    日期:2024-03-25 00:02:29
【下载文档:  jsp+mysql数据库操作常用方法实例总结.txt 】


jsp+mysql数据库操作常用方法实例总结
本文实例讲述了jsp+mysql数据库操作常用方法。分享给大家供大家参考。具体如下:
1. 查看:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>




<% 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("");
out.print("");
out.print("");
out.print("");
out.print("");
while(rs.next())
{ out.print("");
out.print("");
out.print("");
out.print("");
String idstr=rs.getString(1);
out.print("");
out.print("");
out.print("") ;
}
out.print("
考生数据
添加考生信息
"+"姓名");
out.print("
"+"年龄");
out.print("
"+"出生日期");
out.print("
"+"操作");
out.print("
"+rs.getString(2)+""+rs.getString(3)+""+rs.getString(4)+"删除修改
");
con.close();
}
catch(SQLException e1)
{
out.print("SQL异常!!!!");
}
%>



2. add 添加:
<%@ page contentType="text/html;charset=gb2312" %>





添加考生信息













姓名:
年龄:
出生年月:










3. delete 删除:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*" %>


删除操作



<% 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("");
out.print("");
out.print("");
out.print("");
out.print("");
while(rs.next())
{ out.print("");
out.print("");
out.print("");
out.print("");
String idstr=rs.getString(1);
out.print("");
out.print("");
out.print("");
out.print("") ;
}
out.print("
考生数据
添加考生信息
"+"姓名");
out.print("
"+"年龄");
out.print("
"+"出生日期");
out.print("
"+"操作");
out.print("
"+rs.getString(2)+""+rs.getString(3)+""+rs.getString(4)+""+idstr+"删除修改
");
con.close();
}
catch(SQLException e1)
{
out.print("SQL异常!!!!");
}
%>



4. update 示例1:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>




无标题文档


<%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异常!!!!");
}
%>




姓名:



年龄:


出生日期:








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);
}
%>
恭喜你,修改成功!

查看
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);
}
%>
恭喜你,添加成功!

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

相关内容