<sql:setDataSource
var = "dbSource"
driver = "com.mysql.jdbc.Driver"
url = "jdbc:mysql://192.168.95.97:3306/attendance"
user="root"
password="root"
/>
<sql:transaction dataSource="${dbSource}">
<sql:query var="query" >
SELECT empInfo.name,empInfo.id,emp_category.name as type_name,department.name as dep_name FROM empInfo,emp_category,department where empInfo.type_id == emp_category.id and empInfo.department_id == department.id
</sql:query>
</sql:transaction>
错误信息org.apache.jasper.JasperException: /jsp/empList.jsp(23,3) According to TLD or attribute directive in tag file, attribute dataSource does not accept any expressions
org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:40)
org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:407)
org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:148)
org.apache.jasper.compiler.Validator$ValidateVisitor.checkXmlAttributes(Validator.java:1172)
org.apache.jasper.compiler.Validator$ValidateVisitor.visit(Validator.java:819)
org.apache.jasper.compiler.Node$CustomTag.accept(Node.java:1507)
org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2336)
org.apache.jasper.compiler.Node$Visitor.visitBody(Node.java:2386)
org.apache.jasper.compiler.Node$Visitor.visit(Node.java:2392)
org.apache.jasper.compiler.Node$Root.accept(Node.java:489)
org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2336)
org.apache.jasper.compiler.Validator.validate(Validator.java:1737)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:178)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:306)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:286)
貌似说它用的不对啊
LZ在看看这个属性都可以有什么值啊
改成
<sql:transaction dataSource="dbSource">
就行了。