java和.net连接数据库的方法

.net连接数据库的方法

 

App.config

<connectionStrings>
<add name="" connectionString="Database=;Server=;user id=;password=;"/>
</connectionStrings>

 

DAL

public static class DbHelper
{
public static readonly string ConnectionString = ConfigurationManager.ConnectionStrings["SCCE"].ConnectionString;

public static SqlCommand CreateCommand(string commandText,SqlConnection con)
{
if (con.State != System.Data.ConnectionState.Open)
{
con.Open();
}
return new SqlCommand(commandText,con);
}

public static SqlDataReader ExecuteReader(string commandText, SqlConnection con)
{
SqlCommand cmd = CreateCommand(commandText,con);
SqlDataReader dr = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
return dr;
}

public static void ExecuteNonQuery(string commandText, CommandType commandType, params SqlParameter[] parameters)
{
using (SqlConnection con = new SqlConnection(ConnectionString))
{
SqlCommand cmd = CreateCommand(commandText, con);
cmd.CommandType = commandType;
if (parameters != null)
{
cmd.Parameters.AddRange(parameters);
}
cmd.ExecuteNonQuery();
}
}
}

页面

static void Main(string[] args)
{
SqlConnection con = new SqlConnection(DbHelper.ConnectionString);
SqlDataReader dr=DbHelper.ExecuteReader("select * from Teacher",con);
while (dr.Read())
{
Console.WriteLine(dr["TeacherName"]);
}
dr.Close();

string input = Console.ReadLine();
DbHelper.ExecuteNonQuery(
"insert into Teacher values(@TeacherName);",
System.Data.CommandType.Text,
new SqlParameter("@TeacherName", input)
);
}
}

 

 

 

不喜勿喷。