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%3a%2f%2fdownload.microsoft.com%2fdownload%2f4%2f1%2fd%2f41d3e9c0-64d1-451e-947b-7a4cba273b2d%2fmssqlserver.tar&oRef=http%3a%2f%2fwww.microsoft.com%2fdownloads%2fBrowse.aspx%3fdisplaylang%3den%26categoryid%3d3

 

连接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环境变量要设置到具体的文件