在JBOSS的\server\default\deploy目录下，修改mssql-ds.xml(我用的MSSQL)
显示被隐藏内容
然后通过incdb.jsp文件调用
<%@ page import="javax.naming.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="java.sql.*" %>
<%!
javax.sql.DataSource ds;
%>
<%
try {
Context ctx = new InitialContext();
ds = (javax.sql.DataSource)ctx.lookup("java:/MSSQLDS");
} catch (Exception e) {
out.println("erro when connect to java naming api");
}
Connection conn = ds.getConnection();
Statement st = conn.createStatement();
//String sqlStr = "Select truename FROM SalesMan";
//ResultSet rs = st.executeQuery(sqlStr);
%>
JSP传递中的中文乱码解决：
request.setCharacterEncoding("gb2312"); //
