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 >