posts - 710,  comments - 81,  views - 260万
< 2025年3月 >
日 一 二 三 四 五 六
23 24 25 26 27 28 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31 1 2 3 4 5
培训教程_数据库访问

oracle数据库访问

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
 
using System.Configuration;
using System.Data.OracleClient;
using System.Data;
 
/// <summary>
///sqlHelper 的摘要说明
/// </summary>
public class OracleSqlHelper
{
    string conStr = "";
    public OracleSqlHelper()
    {
        conStr = ConfigurationManager.ConnectionStrings["OraConStr"].ConnectionString;
    }
 
    public object ExecuteScalar(string sql)
    {
        object obj = null;
 
        OracleConnection conn = new OracleConnection(conStr);
        conn.Open();
 
        OracleCommand cmd = new OracleCommand(sql, conn);
        obj = cmd.ExecuteScalar();
 
        conn.Close();
        conn.Dispose();
 
        return obj;
    }
 
    public int ExecuteNonQuery(string sql)
    {
        int result = 0;
 
        OracleConnection conn = new OracleConnection(conStr);
        conn.Open();
 
        OracleCommand cmd = new OracleCommand(sql, conn);
        result = cmd.ExecuteNonQuery();
 
        conn.Close();
        conn.Dispose();
 
        return result;
    }
 
    public DataTable ExecuteDataTable(string sql)
    {
        DataTable result = new DataTable();
 
        OracleConnection conn = new OracleConnection(conStr);
        conn.Open();
 
        OracleCommand cmd = new OracleCommand(sql, conn);
        OracleDataAdapter oda = new OracleDataAdapter(cmd);
        oda.Fill(result);
 
        conn.Close();
        conn.Dispose();
 
        return result;
    }
 
    public DataSet ExecuteDataSet(string sql)
    {
        DataSet result = new DataSet();
 
        OracleConnection conn = new OracleConnection(conStr);
        conn.Open();
 
        OracleCommand cmd = new OracleCommand(sql, conn);
        OracleDataAdapter oda = new OracleDataAdapter(cmd);
        oda.Fill(result);
 
        conn.Close();
        conn.Dispose();
 
        return result;
    }
 
    public List<User> GetUsers(string sql)
    {
        List<User> users = new List<User>();
        OracleDataReader result = null;
 
        OracleConnection conn = new OracleConnection(conStr);
        conn.Open();
 
        OracleCommand cmd = new OracleCommand(sql, conn);
        result = cmd.ExecuteReader();
 
        while (result.Read())
        {
            User user = new User();
 
            var objName = result.GetValue(result.GetOrdinal("Name"));
            if (objName != DBNull.Value)
                user.Name = objName.ToString();
            var objAge = result.GetValue(result.GetOrdinal("Age"));
            if (objAge != DBNull.Value)
                user.Age = objAge.ToString();
 
            users.Add(user);
        }
 
        conn.Close();
        conn.Dispose();
 
        return users;
    }
}
 
public class User
{
    public string Name { get; set; }
    public string Age { get; set; }
}

　　

 

sqlserver教程

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
 
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
 
/// <summary>
///sqlHelper 的摘要说明
/// </summary>
public class SqlHelper
{
    string conStr = "";
    public SqlHelper()
    {
        conStr = ConfigurationManager.ConnectionStrings["SqlConStr"].ConnectionString;
    }
 
    public object ExecuteScalar(string sql)
    {
        object obj = null;
 
        SqlConnection conn = new SqlConnection(conStr);
        conn.Open();
 
        SqlCommand cmd = new SqlCommand(sql, conn);
        obj = cmd.ExecuteScalar();
 
        conn.Close();
        conn.Dispose();
 
        return obj;
    }
 
    public int ExecuteNonQuery(string sql)
    {
        int result = 0;
 
        SqlConnection conn = new SqlConnection(conStr);
        conn.Open();
 
        SqlCommand cmd = new SqlCommand(sql, conn);
        result = cmd.ExecuteNonQuery();
 
        conn.Close();
        conn.Dispose();
 
        return result;
    }
 
    public DataTable ExecuteDataTable(string sql)
    {
        DataTable result = new DataTable();
 
        SqlConnection conn = new SqlConnection(conStr);
        conn.Open();
 
        SqlCommand cmd = new SqlCommand(sql, conn);
        SqlDataAdapter oda = new SqlDataAdapter(cmd);
        oda.Fill(result);
 
        conn.Close();
        conn.Dispose();
 
        return result;
    }
 
    public DataSet ExecuteDataSet(string sql)
    {
        DataSet result = new DataSet();
 
        SqlConnection conn = new SqlConnection(conStr);
        conn.Open();
 
        SqlCommand cmd = new SqlCommand(sql, conn);
        SqlDataAdapter oda = new SqlDataAdapter(cmd);
        oda.Fill(result);
 
        conn.Close();
        conn.Dispose();
 
        return result;
    }
 
    public SqlDataReader ExecuteReader(string sql)
    {
        SqlDataReader result = null;
 
        SqlConnection conn = new SqlConnection(conStr);
        conn.Open();
 
        SqlCommand cmd = new SqlCommand(sql, conn);
        result = cmd.ExecuteReader();
 
        return result;
    }
 
    public List<User> GetUsers(string sql)
    {
        List<User> users = new List<User>();
        SqlDataReader result = null;
 
        SqlConnection conn = new SqlConnection(conStr);
        conn.Open();
 
        SqlCommand cmd = new SqlCommand(sql, conn);
        result = cmd.ExecuteReader();
 
        while (result.Read())
        {
            User user = new User();
 
            var objName = result.GetValue(result.GetOrdinal("Name"));
            if (objName != DBNull.Value)
                user.Name = objName.ToString();
            var objAge = result.GetValue(result.GetOrdinal("Age"));
            if (objAge != DBNull.Value)
                user.Age = objAge.ToString();
 
            users.Add(user);
        }
 
        conn.Close();
        conn.Dispose();
 
        return users;
    }
}
 
public class User
{
    public string Name { get; set; }
    public string Age { get; set; }
}

　　程序员的基础教程：菜鸟程序员

posted on   itprobie-菜鸟程序员  阅读(281)  评论(1)  编辑  收藏  举报
编辑推荐：
· AI与.NET技术实操系列：基于图像分类模型对图像进行分类
· go语言实现终端里的倒计时
· 如何编写易于单元测试的代码
· 10年+ .NET Coder 心语，封装的思维：从隐藏、稳定开始理解其本质意义
· .NET Core 中如何实现缓存的预热？
阅读排行：
· 分享一个免费、快速、无限量使用的满血 DeepSeek R1 模型，支持深度思考和联网搜索！
· 25岁的心里话
· 基于 Docker 搭建 FRP 内网穿透开源项目（很简单哒）
· ollama系列01：轻松3步本地部署deepseek，普通电脑可用
· 按钮权限的设计及实现
历史上的今天：
2015-08-12 VMWare windows找不到microsoft软件许可条款
2015-08-12 vmware 已将该虚拟机配置为使用 64 位客户机操作系统。但是，无法执行 64 位操作。
Powered by:
博客园
Copyright © 2025 itprobie-菜鸟程序员
Powered by .NET 9.0 on Kubernetes
点击右上角即可分享
微信分享提示