数据库连接

java：

package DAO;

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

public class DB {
    private Connection con = null;

    private PreparedStatement pstm = null;

    // private String user = "root";
    // private String user = "sa";
    private String user = "tims";
    // private String user = "scott";
    private String password = "tims";

    // private String className = "com.mysql.jdbc.Driver";//Mysql
    // private String className =
    // "com.microsoft.sqlserver.jdbc.SQLServerDriver";//SQL Server
    private String className = "oracle.jdbc.driver.OracleDriver";// Oracle

    // private String
    // url="jdbc:mysql://localhost/db_OOS?user=root&password=12345&useUnicode=true&characterEncoding=utf-8";
    // String url = "jdbc:oracle:" + "thin:@127.0.0.1:1521:XE";//
    // 127.0.0.1是本机地址，XE是精简版Oracle的默认数据库名
    String url = "jdbc:oracle:thin:@127.0.0.1:1521:tims";

    public DB() {
        try {
            Class.forName(className);// 加载Oracle驱动程序
            System.out.println("开始尝试连接数据库！");
        } catch (ClassNotFoundException e) {
            System.out.println("加载数据库驱动失败！");
            e.printStackTrace();
        }
    }

    /** 创建数据库连接 */
    public Connection getConnection() {
        try {
            con = DriverManager.getConnection(url, user, password);// 获取连接
            System.out.println("连接成功！");
        } catch (SQLException e) {
            System.out.println("创建数据库连接失败！");
            con = null;
            e.printStackTrace();
        }
        return con;
    }

    public void doPstm(String sql, Object[] params) {
        if (sql != null && !sql.equals("")) {
            if (params == null)
                params = new Object[0];

            getConnection();
            if (con != null) {
                try {
                    System.out.println(sql);
                    pstm = con.prepareStatement(sql,
                            ResultSet.TYPE_SCROLL_INSENSITIVE,
                            ResultSet.CONCUR_READ_ONLY);
                    //pstm = con.prepareStatement(sql);
                    System.out.println("参数列表：");
                    for (int i = 0; i < params.length; i++) {
                        pstm.setObject(i + 1, params[i]);
                        System.out.println(params[i]);
                    }
                    pstm.execute();
                    //pstm.executeQuery();
                } catch (SQLException e) {
                    System.out.println("doPstm()方法出错！");
                    e.printStackTrace();
                }
            }
        }
    }

    public ResultSet getRs() throws Exception {
        return pstm.getResultSet();
    }

    public int getCount() throws Exception {
        return pstm.getUpdateCount();
    }

    public void closed() {
        try {
            if (pstm != null)
                pstm.close();
        } catch (SQLException e) {
            System.out.println("关闭pstm对象失败！");
            e.printStackTrace();
        }
        try {
            if (con != null) {
                con.close();
            }
        } catch (SQLException e) {
            System.out.println("关闭con对象失败！");
            e.printStackTrace();
        }
    }
}

c#：

待整理