java 标准标签连接数据库
连接数据库
增加，修改，删除 对数据进行处理 
< 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 >
本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！