仅用Jsp实现对数据库的增删改查
首先,打开sql*plus,输入用户名(我用的scott)密码(我设置的是tiger)。先建个表student,
Create table student (
id number(30) not null primary key,
name varchar(50) ,
age number(30),
gender varchar(30),
major varchar(50) );
1,打开myeclipse8.5新建一个web project
2,在project name 中输入合法名字,比如normal
3,新建的normal工程
4,在webRoot目录下添加以下.jsp文件
4.1 submit.jsp文件
代码如下:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
function validate()
{
var id=document.forms[0].id.value;
var name=document.forms[0].name.value;
var age=document.forms[0].age.value;
var major=document.forms[0].major.value;
if(id<=0){
alert("学号不能为空,请输入学号!");
return false;
}
else if(name.length<=0){
alert("姓名不能为空,请输入姓名!");
return false;
}
else if(age<=0){
alert("请输入合法年龄!");
return false;
}
else if(major.length<=0){
alert("专业不能为空,请输入所学专业!");
return false;
}
else{
return true;
}
//document.getElementById("form").submit();
}
4.2 insert.jsp文件
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%
request.setCharacterEncoding("UTF-8");
String id=request.getParameter("id");
String name=request.getParameter("name");
System.out.println(name);
String age=request.getParameter("age");
String gender=request.getParameter("gender");
String major=request.getParameter("major");
Connection conn=null;
Statement stat=null;
ResultSet rs=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@localhost:1521:orcl";
String user="scott";
String password="tiger";
conn=DriverManager.getConnection(url,user,password);
stat=conn.createStatement();
rs=stat.executeQuery("insert into student(id,name,age,gender,major)values("+id+",'"+name+"',"+age+",'"+gender+"','"+major+"')"); %>
<%
if(rs.next())
{
out.print("
}
else{
out.print("
}
%>
<%
if(rs!=null)
{
rs.close();
}
if(stat!=null)
{
stat.close();
}
if(conn!=null)
{
conn.close();
}
%>
4.3 layout.jsp文件
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%
response.setCharacterEncoding("UTF-8");
request.setCharacterEncoding("UTF-8");
String id=request.getParameter("id");
String name=request.getParameter("name");
String age=request.getParameter("age");
String gender=request.getParameter("gender");
String major=request.getParameter("major");
Connection conn=null;
Statement stat=null;
ResultSet rs=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@localhost:1521:orcl";
String user="scott";
String password="tiger";
conn=DriverManager.getConnection(url,user,password);
stat=conn.createStatement();
// stat.execute("insert into student(id,name,age,gender,major)values("+id+",'"+name+"',"+age+",'"+gender+"','"+major+"')");
rs=stat.executeQuery("select * from student");
%>
学号 | 姓名 | 年龄 | 性别 | 专业 | ||
"+rs.getInt("id")+" | ");"+rs.getString("name")+" | ");"+rs.getInt("age")+" | ");"+rs.getString("gender")+" | ");"+rs.getString("major")+" | ");">删除 | ">修改 |
<%
if(rs!=null)
{
rs.close();
}
if(stat!=null)
{
stat.close();
}
if(conn!=null)
{
conn.close();
}
%>
4.4 delete.jsp文件
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%
String path = request.getContextPath();
String basePath =
request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %>
<%
request.setCharacterEncoding("UTF-8");
String id=request.getParameter("id");
// String name=request.getParameter("name");
// String age=request.getParameter("age");
// String gender=request.getParameter("gender");
// String major=request.getParameter("major");
Connection conn=null;
Statement stat=null;
ResultSet rs=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@localhost:1521:orcl";
String user="scott";
String password="tiger";
conn=DriverManager.getConnection(url,user,password);
stat=conn.createStatement();
rs=stat.executeQuery("delete from student where id="+id+"");
if(rs.next())
{
out.print("
}
else{
out.print("
}
%>
<%
if(rs!=null)
{
rs.close();
}
if(stat!=null)
{
stat.close();
}
if(conn!=null)
{
conn.close();
}
%>
4.5 idselect.jsp文件
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%
request.setCharacterEncoding("UTF-8");
String id=request.getParameter("id");
Connection conn=null;
Statement stat=null;
ResultSet rs=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@localhost:1521:orcl";
String user="scott";
String password="tiger";
conn=DriverManager.getConnection(url,user,password);
stat=conn.createStatement();
rs=stat.executeQuery("select * from student where id="+id+"");
%>
学号 | 姓名 | 年龄 | 性别 | 专业 | ||
"+rs.getInt("id")+" | ");"+rs.getString("name")+" | ");"+rs.getInt("age")+" | ");"+rs.getString("gender")+" | ");"+rs.getString("major")+" | ");">删除 | ">修改 |
<%
if(rs!=null)
{
rs.close();
}
if(stat!=null)
{
stat.close();
}
if(conn!=null)
{
conn.close();
}
%>
4.6 nameselect.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%
request.setCharacterEncoding("UTF-8");
String name=request.getParameter("name");
Connection conn=null;
Statement stat=null;
ResultSet rs=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@localhost:1521:orcl";
String user="scott";
String password="tiger";
conn=DriverManager.getConnection(url,user,password);
stat=conn.createStatement();
rs=stat.executeQuery("select * from student where name='"+name+"'");
%>
学号 | 姓名 | 年龄 | 性别 | 专业 | ||
"+rs.getInt("id")+" | ");"+rs.getString("name")+" | ");"+rs.getInt("age")+" | ");"+rs.getString("gender")+" | ");"+rs.getString("major")+" | ");">删除 | ">修改 |
<%
if(rs!=null)
{
rs.close();
}
if(stat!=null)
{
stat.close();
}
if(conn!=null)
{
conn.close();
}
%>
4.7 ageselect.jsp文件
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%
request.setCharacterEncoding("UTF-8");
// String id=request.getParameter("id");
// String name=request.getParameter("name");
String age=request.getParameter("age");
// String gender=request.getParameter("gender");
// String major=request.getParameter("major");
Connection conn=null;
Statement stat=null;
ResultSet rs=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@localhost:1521:orcl";
String user="scott";
String password="tiger";
conn=DriverManager.getConnection(url,user,password);
stat=conn.createStatement();
rs=stat.executeQuery("select * from student where age="+age+"");
%>
学号 | 姓名 | 年龄 | 性别 | 专业 | ||
"+rs.getInt("id")+" | ");"+rs.getString("name")+" | ");"+rs.getInt("age")+" | ");"+rs.getString("gender")+" | ");"+rs.getString("major")+" | ");">删除 | ">修改 | <%
<%
if(rs!=null)
{
rs.close();
}
if(stat!=null)
{
stat.close();
}
if(conn!=null)
{
conn.close();
}
%>
4.8 genderselect.jsp文件
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%
request.setCharacterEncoding("UTF-8");
// String id=request.getParameter("id");
// String name=request.getParameter("name");
// String age=request.getParameter("age");
String gender=request.getParameter("gender");
// String major=request.getParameter("major");
Connection conn=null;
Statement stat=null;
ResultSet rs=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@localhost:1521:orcl";
String user="scott";
String password="tiger";
conn=DriverManager.getConnection(url,user,password);
stat=conn.createStatement();
rs=stat.executeQuery("select * from student where gender='"+gender+"'");
%>
学号 | 姓名 | 年龄 | 性别 | 专业 | ||
"+rs.getInt("id")+" | ");"+rs.getString("name")+" | ");"+rs.getInt("age")+" | ");"+rs.getString("gender")+" | ");"+rs.getString("major")+" | ");">删除 | ">修改 |
<%
if(rs!=null)
{
rs.close();
}
if(stat!=null)
{
stat.close();
}
if(conn!=null)
{
conn.close();
}
%>
4.9 major.jsp文件
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%
request.setCharacterEncoding("UTF-8");
// String id=request.getParameter("id");
// String name=request.getParameter("name");
// String age=request.getParameter("age");
// String gender=request.getParameter("gender");
String major=request.getParameter("major");
//major=;
Connection conn=null;
Statement stat=null;
ResultSet rs=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@localhost:1521:orcl";
String user="scott";
String password="tiger";
conn=DriverManager.getConnection(url,user,password);
stat=conn.createStatement();
rs=stat.executeQuery("select * from student where major='"+major+"'");
%>
学号 | 姓名 | 年龄 | 性别 | 专业 | ||
"+rs.getInt("id")+" | ");"+rs.getString("name")+" | ");"+rs.getInt("age")+" | ");"+rs.getString("gender")+" | ");"+rs.getString("major")+" | ");">删除 | ">修改 |
学习收藏数据库增删改查 --查询信息系和计算机系的学生,并按学生所在系和学号排序。select sno,sname,Sdept from Student where Sdept='CS'OR Sdept='IS' order by Sdept,sno ASC --查询学生表中最小的年龄。 select MIN(sage from student --查询课程名中包含“数据”的课程名。 select cno,cname from course where Cname like'%数据%' --查询先行课程为空值的课程号、课程名及学分 select cno,cname,ccredit from Course where Cpno is null --查询李勇选修的数据库课程的成绩 select grade from SC where Sno=(select Sno from Student where Sname='李勇'and Cno=(select Cno from Course where cname='数据库' --查询平均成绩分以上的学生的学号 select distinct sno from SC scx where (select AVG(Grade from SC scy
where scy.sno=scx.Sno>85 --求计算机系没有选修数据库课程的学生姓名 select sname from Student where Sno not in(select Sno from SC where Cno in(select Cno from Course where Sname='数据库'and Sdept='IS' --求至少选修了学号为S1所选修的全部课程的学生学号 select distinct sno from SC scx where not exists(select*from SC scy where scy.Sno='20021522'and not exists(select* from sc scz where scz.sno=scx.sno and https://www.doczj.com/doc/e2269951.html,o=https://www.doczj.com/doc/e2269951.html,o --求各系的系的学生人数的,并将结果按学生人数的降序排序 select Sdept,COUNT(sno from Student group by Sdept order by Sdept ASC --查询选修了数学课程并且成绩高于该门课程平均分的学生学号和成绩 select sno,grade from SC scx where Grade>=(select AVG(Grade from SC scy where Cno=(select Cno from Course where Cname='数学'and Cno=(select Cno from Course
GridView简单的增删改查,自己做了个小项目和大家分享,希望有所帮助 (PS:我也是刚学者,有好的学习方法大家一起学习哈~) 先来贴出本文代码运行的结果: 点击增加一行,第一行出现空格输入内容,点击确定增加,就可以将数据保存到数据库,并绑定到gridview中 点击编辑出现更新和取消,就可以直接在gridview上修改内容了 (PS:编号id是自动生成的,所以不可以修改,在这边让它成为只读的) 前端代码 <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>