1.jdbc下载:http://www.microsoft.com/china/sql/downloads/2000/jdbc.asp
后setup.
2.加入classpath中
<%@ page contentType = "text/html; charSet=gb2312" %>
<%@ page language="java" import = "java.sql.*" %>
<%
/**address: SQL Server的连接参数*/
String address = "jdbc:microsoft:sqlserver://127.0.0.1:1433";
/***user: 数据库用户名*/
String user="sa";
/**passwd: 用户密码*/
String passwd="";
/*数据库名*/
String database = "online"; DatabaseMetaData conMD = null;
java.sql.Statement stmt = null;
Connection con = null;
ResultSet sqlRst = null; try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = DriverManager.getConnection(address,user,passwd); conMD = con.getMetaData();
con.setCatalog(database);
stmt = con.createStatement();
}catch(Exception fs) {
out.print("Connection ERROR</p> <br>");
}
out.print("Connection</p> <br>"); try
{
stmt=con.createStatement();
sqlRst = stmt.executeQuery("SELECT * FROM mytable");
out.print("stmt OK");
}catch(Exception gr)
{
out.print("stmt ERROR");
} while (sqlRst.next())
{
out.print("<p>name :" + sqlRst.getString("name") + "</p> <br>");
out.print("<p>old :" + sqlRst.getString("old") + "</p>");
}
%>
后setup.
2.加入classpath中
<%@ page contentType = "text/html; charSet=gb2312" %>
<%@ page language="java" import = "java.sql.*" %>
<%
/**address: SQL Server的连接参数*/
String address = "jdbc:microsoft:sqlserver://127.0.0.1:1433";
/***user: 数据库用户名*/
String user="sa";
/**passwd: 用户密码*/
String passwd="";
/*数据库名*/
String database = "online"; DatabaseMetaData conMD = null;
java.sql.Statement stmt = null;
Connection con = null;
ResultSet sqlRst = null; try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = DriverManager.getConnection(address,user,passwd); conMD = con.getMetaData();
con.setCatalog(database);
stmt = con.createStatement();
}catch(Exception fs) {
out.print("Connection ERROR</p> <br>");
}
out.print("Connection</p> <br>"); try
{
stmt=con.createStatement();
sqlRst = stmt.executeQuery("SELECT * FROM mytable");
out.print("stmt OK");
}catch(Exception gr)
{
out.print("stmt ERROR");
} while (sqlRst.next())
{
out.print("<p>name :" + sqlRst.getString("name") + "</p> <br>");
out.print("<p>old :" + sqlRst.getString("old") + "</p>");
}
%>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货