jsp连接Oracle数据库实现增删改查

javaweb开发，连接Oracle数据库，通过网页注册，登录后对数据库中的用户表进行增删查。实现了登录、注册、增删改查等功能。

package com.bzq.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import com.bzq.model.UserModel;

	public class DeleteDao {
	public static int  deleteMode=-1;
	public static void main（String[] args） {


	}
	public static void delete（UserModel um） {
		//用来连接oracle数据库
		Connection connection=null;
		//执行SQL语句
		PreparedStatement preparedStatement=null;
		
		try {
			//加载数据库驱动
			Class.forName（“oracle.jdbc.OracleDriver“）;
			//数据库地址jdbc:oracle:thin:@localhost:数据库端口号:数据库SID
			String url=“jdbc:oracle:thin:@localhost:1521:orcl“;
			
			//数据库用户名和密码
			String userName=“system“;
			String userPassword=“088413“;
			
			connection=DriverManager.getConnection（urluserNameuserPassword）;
	

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2019-01-09 21:12  jsp增删改查\
     文件         839  2018-12-24 14:57  jsp增删改查\.classpath
     文件         915  2019-01-04 18:02  jsp增删改查\.project
     目录           0  2019-01-09 21:12  jsp增删改查\.settings\
     文件         567  2018-12-24 14:57  jsp增删改查\.settings\.jsdtscope
     文件         358  2018-12-24 14:57  jsp增删改查\.settings\org.eclipse.jdt.core.prefs
     文件         767  2018-12-30 14:07  jsp增删改查\.settings\org.eclipse.wst.common.component
     文件         343  2018-12-24 14:57  jsp增删改查\.settings\org.eclipse.wst.common.project.facet.core.xml
     文件          49  2018-12-24 14:57  jsp增删改查\.settings\org.eclipse.wst.jsdt.ui.superType.container
     文件           6  2018-12-24 14:57  jsp增删改查\.settings\org.eclipse.wst.jsdt.ui.superType.name
     目录           0  2019-01-09 21:12  jsp增删改查\build\
     目录           0  2019-01-09 21:12  jsp增删改查\build\classes\
     目录           0  2019-01-09 21:12  jsp增删改查\build\classes\com\
     目录           0  2019-01-09 21:12  jsp增删改查\build\classes\com\bzq\
     目录           0  2019-01-09 21:12  jsp增删改查\build\classes\com\bzq\dao\
     文件        2518  2019-01-04 18:02  jsp增删改查\build\classes\com\bzq\dao\DeleteDao.class
     文件        2366  2019-01-04 18:02  jsp增删改查\build\classes\com\bzq\dao\InsertDao.class
     文件        2975  2019-01-04 18:02  jsp增删改查\build\classes\com\bzq\dao\SelectDao.class
     文件        2764  2019-01-04 18:02  jsp增删改查\build\classes\com\bzq\dao\UpdateDao.class
     目录           0  2019-01-04 18:02  jsp增删改查\build\classes\com\bzq\model\
     文件        1566  2019-01-04 18:02  jsp增删改查\build\classes\com\bzq\model\UserModel.class
     目录           0  2019-01-09 21:12  jsp增删改查\build\classes\com\bzq\servlet\
     文件        2200  2019-01-04 18:02  jsp增删改查\build\classes\com\bzq\servlet\DeleteServlet.class
     文件        2320  2019-01-04 18:02  jsp增删改查\build\classes\com\bzq\servlet\InsertServlet.class
     文件        2518  2019-01-04 18:02  jsp增删改查\build\classes\com\bzq\servlet\SelectServlet.class
     文件        2584  2019-01-04 18:02  jsp增删改查\build\classes\com\bzq\servlet\UpdateServlet.class
     目录           0  2019-01-09 21:12  jsp增删改查\src\
     目录           0  2019-01-09 21:12  jsp增删改查\src\com\
     目录           0  2019-01-09 21:12  jsp增删改查\src\com\bzq\
     目录           0  2019-01-09 21:12  jsp增删改查\src\com\bzq\dao\
     文件        2500  2018-12-28 19:23  jsp增删改查\src\com\bzq\dao\DeleteDao.java
............此处省略27个文件信息