实际上注册是为了在解析连接数据库的URL时,可以找到相应的子协议,例如:
String URL = "jdbc:microsoft:sqlServer://127.0.0.1:1433" 中的microsoft,驱动管理器会遍历登记的驱动,调用他们的接口,测试可以通过该URL的驱动并使用它来和数据库通讯.1.jdbc下载:http://www.microsoft.com/china/sql/downloads/2000/jdbc.asp后setup.2.加入classpath中 jsp:<%@ 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>"); }%>
String URL = "jdbc:microsoft:sqlServer://127.0.0.1:1433" 中的microsoft,驱动管理器会遍历登记的驱动,调用他们的接口,测试可以通过该URL的驱动并使用它来和数据库通讯.1.jdbc下载:http://www.microsoft.com/china/sql/downloads/2000/jdbc.asp后setup.2.加入classpath中 jsp:<%@ 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分钟通话, 中国电信官方发货