ASP更新数据库的代码

<%set rst=server.createobject("adodb.recordset")sql="select top 1 * from wpjy where wpjy_id like '%" &id &"%' order by wpjy_id desc "rst.open sql,conn,1,3 if rst.eof thenrst.addnewrst("wpjy_rq")=rst("wpjy_rq")+1rst.update

end ifrst.closeset rst=nothing%></p>

public static void Update(Connection con, String sql, Object... objects) {

PreparedStatement pre = null

try {

pre = con.prepareStatement(sql)

for (int i = 0i <objects.lengthi++) {

pre.setObject(i + 1, objects[i])

}

pre.executeUpdate()

} catch (SQLException e) {

e.printStackTrace()

}

}

string ConnectionString = "Data Source=数据源Database=数据库名称uid=用户Pwd=密码"

string sql = "update 数据表 set 字段1= '开',字段2='" + dt + "' （where +限定条件）

SqlConnection conn = new SqlConnection(ConnectionString)

conn.Open()

SqlCommand cmd = conn.CreateCommand()

cmd.CommandText = sql

cmd.ExecuteNonQuery()

conn.Close()

---