JSP数据库内容大杂烩问题(新手提问) 关于JSP如何连接不同的数据库的代码?呵呵大家资源共享当连接好了数据库后操作数据库中的内容,如何提取数据库表中的内容以及如何实现分页的功能本人刚接触JSP谢谢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 这个网上有好多的百度或google一下都有源码的 JDBC驱动汇总Microsoft SQL Server series (6.5, 7.x and 2000) and Sybase 10JDBC Name: jTDSURL: http://jtds.sourceforge.net/Version: 0.5.1Download URL: http://sourceforge.net/project/showfiles.php?group_id=33291语法:Class.forName("net.sourceforge.jtds.jdbc.Driver ");Connection con = DriverManager.getConnection("jdbc:jtds:sqlserver://host:port/database","user","password");orConnection con = DriverManager.getConnection("jdbc:jtds:sybase://host:port/database","user","password");MySQLJDBC Name: Connector/J 3.0URL: http://www.mysql.com/Version: 3.0.8-stableDownload URL: http://www.mysql.com/downloads/api-jdbc-stable.html语法:Class.forName("com.mysql.jdbc.Driver");Connection con = DriverManager.getConnection("jdbc:mysql://host:port/database","user","password");OracleJDBC Name: Connector/J 3.0URL: http://otn.oracle.com/Version: 3.0.8-stableDownload URL: http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html语法:Class.forName("oracle.jdbc.driver.OracleDriver");Connection con = DriverManager.getConnection("jdbc:oracle:thin:@host:port:databse","user","password");SybaseDriver: jConnect 4.5/5.5 (JDBC 2.0 请使用5.5) 语法:Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance();DriverManager.getConnection("jdbc:sybase:Tds:IP地址:2638?ServiceName="+数据库名称,"账号","密码");PostgresqlJDBC Name: PostgreSQL JDBCURL: http://jdbc.postgresql.org/Version: 7.3.3 build 110Download URL: http://jdbc.postgresql.org/download.html语法:Class.forName("org.postgresql.Driver"); Connection con=DriverManager.getConnection("jdbc:postgresql://host:port/database","user","password");IBM AS400主机在用的JDBC语法有装V4R4以上版本的Client Access Express可以在C:\Program Files\IBM\Client Access\jt400\lib找到 driver 档案 jt400.zip,并更改扩展名成为 jt400.jar语法java.sql.DriverManager.registerDriver (new com.ibm.as400.access.AS400JDBCDriver ());Class.forName("com.ibm.as400.access.AS400JDBCConnection");con = DriverManager.getConnection("jdbc:as400://IP","user","password"); 请问这是什么?? 用multipart上传文件 跪求高手指点! JSP页面当前定义的变量,核心标签库如何引用? jsp 操作数据库问题 Microsoft SQL Server 2005 Express Edition数据库可以连接jdbc吗 面试了很多公司,都是有面试,没有消息. struts报错 请问为什么jsp中的多个ArrayList总是被指向同一个对象(附代码) 帮帮忙,非常急的一个问题... jsp页面出错,帮忙分析一下!惨惨。帮帮新手啊.谢谢 JSF 同名字段 提交问题
百度或google一下
都有源码的
Microsoft SQL Server series (6.5, 7.x and 2000) and Sybase 10JDBC Name: jTDS
URL: http://jtds.sourceforge.net/
Version: 0.5.1
Download URL: http://sourceforge.net/project/showfiles.php?group_id=33291语法:Class.forName("net.sourceforge.jtds.jdbc.Driver ");
Connection con = DriverManager.getConnection("jdbc:jtds:sqlserver://host:port/database","user","password");
or
Connection con = DriverManager.getConnection("jdbc:jtds:sybase://host:port/database","user","password");MySQLJDBC Name: Connector/J 3.0
URL: http://www.mysql.com/
Version: 3.0.8-stable
Download URL: http://www.mysql.com/downloads/api-jdbc-stable.html语法:Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://host:port/database","user","password");OracleJDBC Name: Connector/J 3.0
URL: http://otn.oracle.com/
Version: 3.0.8-stable
Download URL: http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html语法:Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@host:port:databse","user","password");SybaseDriver: jConnect 4.5/5.5 (JDBC 2.0 请使用5.5) 语法:
Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance();
DriverManager.getConnection("jdbc:sybase:Tds:IP地址:2638?ServiceName="+数据库名称,"账号","密码");PostgresqlJDBC Name: PostgreSQL JDBC
URL: http://jdbc.postgresql.org/
Version: 7.3.3 build 110
Download URL: http://jdbc.postgresql.org/download.html语法:Class.forName("org.postgresql.Driver");
Connection con=DriverManager.getConnection("jdbc:postgresql://host:port/database","user","password");IBM AS400主机在用的JDBC语法有装V4R4以上版本的Client Access Express
可以在C:\Program Files\IBM\Client Access\jt400\lib
找到 driver 档案 jt400.zip,并更改扩展名成为 jt400.jar语法java.sql.DriverManager.registerDriver (new com.ibm.as400.access.AS400JDBCDriver ());
Class.forName("com.ibm.as400.access.AS400JDBCConnection");
con = DriverManager.getConnection("jdbc:as400://IP","user","password");