110,561
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
///数据访问
namespace MSSSQLConnection
{
public class ConnectionSQL
{
public static SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=StudentDB;Integrated Security=True");
public static SqlCommand command = new SqlCommand("",conn);
private static void OpenConn() {
if (conn.State != System.Data.ConnectionState.Open) {
conn.Open();
}
}
public static void CloseConn()
{
if (conn.State == System.Data.ConnectionState.Open)
{
conn.Close();
}
}
public static SqlDataReader ExecuteSelect(string sql) {
OpenConn();
command.CommandText = sql;
return command.ExecuteReader();
}
public static int ExecuteNonSelect(string sql)
{
OpenConn();
command.CommandText = sql;
return command.ExecuteNonQuery();
}
}
}