连接数据库 < sql:setDataSource driver ="com.microsoft.sqlserver.jdbc.SQLServerDriver" url ="jdbc:sqlserver://localhost:1433;Database=demo" user ="sa" password ="justforyou" var ="ts" /> 可以这样设置语言characterEncoding=GB2312 查询数据库 < sql:query var ="results" sql ="select MarriageID,HusbandID,WifeID from marriage" dataSource ="${ds}" ></ sql:query > 增加,修改,删除 < sql:update dataSource ="${ts}" var ="newTable" > create table mytable( nameid int primary key, name varchar(50), role varchar(50) ) </ sql:update > 对数据进行处理 < c:forEach var ="columnName" items ="${newresults.columnNames}" > < th >< c:out value ="${columnName}" /></ th > </ c:forEach > < c:forEach var = " newrow " items = " ${newresults.rowsByIndex} " > < tr > < c:forEach var = " column " items = " ${newrow} " > < td >< c: out value = " ${column} " /></ td > </ c:forEach > </ tr > </ c:forEach > --下面与上面不一样 < c:forEach var = " row " items = " ${results.rows} " > < tr > < td >< c: out value = " ${row.MarriageID} " /></ td > < td >< c: out value = " ${row.HusbandID} " /></ td > < td >< c: out value = " ${row.WifeID} " /></ td > </ tr > </ c:forEach >