在tomcat administration里设置Data Sources
url="jdbc:microsoft:sqlserver://localhost;DatabaseName=库名";
JDBC Driver Class="com.microsoft.jdbc.sqlserver.SQLServerDriver"
后面填sqlserver用户名和密码
url="jdbc:microsoft:sqlserver://localhost;DatabaseName=库名";
JDBC Driver Class="com.microsoft.jdbc.sqlserver.SQLServerDriver"
后面填sqlserver用户名和密码
=============================================================
Data Sources
里面的JNDI Name:不用填写的吗???C:\Tomcat\webapps\ROOT\WEB-INF\classes我放了数据库链接class文件在jdk调用没问题,可以显示数据库内容:private final String DBIP = "192.168.100.110";
private final String Port = "1433";
private final String Account = "sa";
private final String Password = "sa";
private final String DataBaseName = "ZJTour";
private final String DriverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
private final String Url = "jdbc:microsoft:sqlserver://"+DBIP+":"+Port+";DatabaseName="+DataBaseName;
private Connection Conn;
private Statement Stmt;
但test.jsp里却打印不出来啊
============================================================== String SqlStr = "Select NewsContent,NewsComeFrom,"+(char)13
+"'NewsPublishDate'=substring(convert(char,NewsPublishDate,120),1,10),"+(char)13
+"IsValid,NewsStat,NewsKeyWord,typeid,NewsImageInfo,"
+"NewsTitleImage,NewsCreateTime"+(char)13
+" from TZ_News"+(char)13
+" where NewsID=11";
Conn conn = new Conn();
String[][] temp = null;
try{
temp = conn.getRows(SqlStr);
for(int i=0;i<temp[0].length;i++){
for(int j=0;j<temp.length;j++)
out.println(temp[j][i]+" ");
out.println("<br>");
}
conn.Close();
}catch(Exception e){
out.println(e.getMessage());
}
==========================================================================
能否再帮助我一下,我调试了半天了,真晕死
http://dev.csdn.net/develop/article/25/25942.shtm