资源简介

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个文件信息

评论

共有 条评论