============ORACLE 8i============================
Class.forName ("oracle.jdbc.driver.OracleDriver");
Connection conn =
DriverManager.getConnection ("jdbc:oracle:thin:@myhost:1521:orcl",
"scott", "tiger");=============MySQL=================================
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://myhost:3306/dbname","user","passwd");============InfoMax================================
Class.forName("com.informix.jdbc.IfxDriver");
conn = DriverManager.getConnection("jdbc:informix-sqli://myhost:1533:informixserver=myserver;user=rdtest;password=test");
============InforMix================================
Class.forName("com.informix.jdbc.IfxDriver");
conn = DriverManager.getConnection("jdbc:informix-sqli://myhost:1533:informixserver=myserver;user=rdtest;password=test");
=============SQLServer2000=========================
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection
("jdbc:microsoft:sqlserver://server1:1433","username","password");
///////////////////////////////////
jdbc driver download:SQLServer:http://www.microsoft.com/sql/downloads/default.asp
MySQL:http://www.mysql.com/downloads/api-jdbc.html
Oracle:http://otn.oracle.com/software/content.html ---------------------DB2--------------------
--------------------- --------------------
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();//For Application
String url = "jdbc:db2:sample";
con = DriverManager.getConnection(url, userid, passwd);
Class.forName("COM.ibm.db2.jdbc.net.DB2Driver").newInstance();//For Applet
String url = "jdbc:db2:// "+server+":"+port+"/sample";
con = DriverManager.getConnection(url, userid, password );
Class.forName ("oracle.jdbc.driver.OracleDriver");
Connection conn =
DriverManager.getConnection ("jdbc:oracle:thin:@myhost:1521:orcl",
"scott", "tiger");=============MySQL=================================
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://myhost:3306/dbname","user","passwd");============InfoMax================================
Class.forName("com.informix.jdbc.IfxDriver");
conn = DriverManager.getConnection("jdbc:informix-sqli://myhost:1533:informixserver=myserver;user=rdtest;password=test");
============InforMix================================
Class.forName("com.informix.jdbc.IfxDriver");
conn = DriverManager.getConnection("jdbc:informix-sqli://myhost:1533:informixserver=myserver;user=rdtest;password=test");
=============SQLServer2000=========================
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection
("jdbc:microsoft:sqlserver://server1:1433","username","password");
///////////////////////////////////
jdbc driver download:SQLServer:http://www.microsoft.com/sql/downloads/default.asp
MySQL:http://www.mysql.com/downloads/api-jdbc.html
Oracle:http://otn.oracle.com/software/content.html ---------------------DB2--------------------
--------------------- --------------------
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();//For Application
String url = "jdbc:db2:sample";
con = DriverManager.getConnection(url, userid, passwd);
Class.forName("COM.ibm.db2.jdbc.net.DB2Driver").newInstance();//For Applet
String url = "jdbc:db2:// "+server+":"+port+"/sample";
con = DriverManager.getConnection(url, userid, password );
解决方案 »
- sql语句中count函数的问题
- poi XSSFWorkbook 如何关闭打开的excel
- 网页表格到出到excel的方法,最好有源码,thanks
- 救命啊﹐急﹐搞了好久了
- java链接数据库都需要什么(工具)?具体点我比较笨的 。。呵呵谢谢 各位神一样的高手指点。呵呵
- ●●●Servlet到底是做什么用的?它在具体应用中,非常重要吗?●●●
- from里的参数传递为ENCTYPE="multipart/form-data"时的问题?
- 我想要显示繁体中文 为什么来乱码?
- hibernateTemplate.update() 方法 控制台已输出SQL语句,但数据库没有更新
- 请教大牛,java操作一个ftp传压缩文件到另外一个ftp
- 如何能在网上找到一个可以提供ORACLE进行JSP设计的主机展示我的作品啊,付费也行
- 两个奇怪的问题(Jbuilder作Servlet),给出合理的解释,分全送。
<head></head>
<body>
<form name="login" method="POST" action="first.jsp">
<p align="center">
用户名:<input type="text" name="username" size="20"></p>
<p align="center">
密 码:<input type="password" name="password" size="20"></p>
<p align="center"><input type="submit" value="提 交" name="login">
<input type="reset" value="重 写" name="reset"></p>
</form>
</body>
</html>
与之对应的first.jsp文件
<%@page import="java.sql.*"%>
<%@page contentType="text/html;charset=gb2312"%><%
String user1,pwd1;
user1=request.getParameter("username");
pwd1=request.getParameter("password");
%><%
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:bookserver";
String user="sa";
String password="zst";
Connection con=DriverManager.getConnection(url,user,password);
Statement stmt=con.createStatement();
String querystring="insert into userinfo(username,password) values('"+user1+"','"+pwd1+"')";
stmt.executeUpdate(querystring);
stmt.close();
con.close();
out.println("成功插入数据"); }
catch(Exception e)
{
System.err.println(" 数据插入没有成功!"+e.getMessage());
}
%>
不过首先要用sql server2000建一个数据库
bookserver是数据库名,
sa和zst是sql的超级用户名和密码!