java写sqlhelper_自己写的SqlHelper类

今天老师复习了ADO ，因为代码的重复使用问题，所以老师就让我们写了sqlhelper类 这是我写的sqlhelper

public class SqlHelper

{

string constr = ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;

public int ExecuteNonQuery( string commandtext,params SqlParameter[] prms) {

using (SqlConnection conn = new SqlConnection(constr)) {

conn.Open();

using (SqlCommand cmd = new SqlCommand(commandtext,conn)){

if (prms != null) {

cmd.Parameters.AddRange(prms);

}

int r = cmd.ExecuteNonQuery();

return r;

}

}

}

public object ExecuteScalar(string commandtext,params SqlParameter[] prms)

{

using (SqlConnection conn = new SqlConnection(constr)) {

conn.Open();

using (SqlCommand cmd = new SqlCommand(commandtext, conn)) {

if (prms != null) {

cmd.Parameters.AddRange(prms);

}

object obj = cmd.ExecuteScalar();

return obj;

}

}

}

public SqlDataReader ExecuteReader(string commandtext, params SqlParameter[] prms) {

SqlConnection conn = new SqlConnection(constr); //此处不能使用using如果使用的话 内边就调用不到连接对象了

conn.Open();

using (SqlCommand cmd = new SqlCommand(commandtext, conn)) {

if (prms != null) {

cmd.Parameters.AddRange(prms);

}

SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection); //当你关闭reader的时候 SqlConnection也就关闭了

return reader;

}

}

public DataTable datatable(string commandtext) {

SqlDataAdapter adapter = new SqlDataAdapter(commandtext, constr);

DataTable dt = new DataTable();

adapter.Fill(dt);

return dt;

}

}