连接SQLSERVER的JAR包下载地址
连接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环境变量要设置到具体的文件