java数据库操作(改进版)

最新推荐文章于 2024-01-26 09:25:13 发布

yinxing2006

最新推荐文章于 2024-01-26 09:25:13 发布

阅读量866

点赞数

分类专栏： java 文章标签：数据库 java string insert sql delete

本文链接：https://blog.csdn.net/yinxing2006/article/details/443107

版权

java 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

package model;

import java.io.PrintStream;
import java.sql.*;

public class DBConnector
{

String DriverName;
String DBUrl;
Connection conn;
ResultSet rs;

public String getDBUrl()
{
     return DBUrl;
}
public void setDBUrl(String url)
{
     DBUrl = url;
}
public String getDriverName()
{
     return DriverName;
}
public void setDriverName(String driverName)
{
     DriverName = driverName;
}

public DBConnector()
{
      DriverName = "sun.jdbc.odbc.JdbcOdbcDriver";
      DBUrl = "jdbc:odbc:test";
      conn = null;
      rs = null;
}
public void getConnection()
{
     try
     {
         Class.forName(DriverName);
         conn = DriverManager.getConnection(DBUrl);
     }
     catch(Exception e){}
}
public void executeInsert(String s)
{
      try
      {
          Statement statement = conn.createStatement();
          int i = statement.executeUpdate(s);
      }
      catch(SQLException sqlexception)
      {
          System.err.println("faq.executeUpdate:" + sqlexception.getMessage());
      }
}

public ResultSet executeQuery(String s)
{
      rs = null;
      try
      {
          Statement statement = conn.createStatement();
          rs = statement.executeQuery(s);
      }
      catch(SQLException sqlexception)
      {
          System.err.println("aq.executeQuery: " + sqlexception.getMessage());
      }
      return rs;
}

public void executeDelete(String s)
{
      try
      {
          Statement statement = conn.createStatement();
          statement.executeUpdate(s);
      }
      catch(SQLException sqlexception)
      {
          System.err.println("faq.executeDelete: " + sqlexception.getMessage());
      }
}

public int executeUpdate(String s)
{
      int i = 0;
      try
      {
          Statement statement = conn.createStatement();
          i = statement.executeUpdate(s);
      }
      catch(SQLException sqlexception)
      {
          System.err.println("faq.executeDelete: " + sqlexception.getMessage());
      }
      return i;
}

public void close()
{
      try
      {
          if(rs != null)
              rs.close();
          if(conn != null)
              conn.close();
      }
      catch(SQLException sqlexception)
      {
          System.err.println("faq.executeDelete: " + sqlexception.getMessage());
      }
}
}

package model;

import lib.Lib;
import java.sql.*;

public class QueryDBModel
{
    /*
     * 如果是执行查询,则返回相应ReSultSet,否则返回null
     */
    public ResultSet DBAction(DBConnector dbc,int way,String sql)
    {
        switch(way)
        {
        case Lib.DB_INSERT:
             dbc.executeInsert(sql);
             break;
        case Lib.DB_QEURY:
             return dbc.executeQuery(sql);
        case Lib.DB_UPDATE:
             dbc.executeUpdate(sql);
             break;
        case Lib.DB_DELETE:
             dbc.executeDelete(sql);
             break;
        }
        return null;
    }

    public static void main(String[] args)
    {
        String sql;
        QueryDBModel qdbm = new QueryDBModel();
        DBConnector dbc = new DBConnector();
        dbc.getConnection();
        //sql = "insert into project(name) values('link')";
        //qdbm.DBAction(dbc,Lib.DB_INSERT,sql);
        sql = "delete from project";
        qdbm.DBAction(dbc,Lib.DB_DELETE,sql);
        dbc.close();
    }
}

package lib;

public class Lib
{
    //定义操作数据库的四种类型
    public static final int DB_INSERT = 1;
    public static final int DB_QEURY = 2;
    public static final int DB_UPDATE = 3;
    public static final int DB_DELETE = 4;
}