|
三、JSP连接DB2数据库
testdb2.jsp如下:
<%@ page contentType=\"text/html;charset=gb2312\"%>
<%@ page import=\"Java.sql.*\"%>
<html>
<body>
<%Class.forName(\"com.ibm.db2.JDBC.app.DB2Driver \").newInstance();
String url=\"jdbc:db2://localhost:5000/sample\";
//sample为你的数据库名
String user=\"admin\";
String password=\"\";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql=\"select * from test\";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print(\"数据库操作成功,恭喜你\");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
四、JSP连接Informix数据库
testinformix.jsp如下:
<%@ page contentType=\"text/html;charset=gb2312\"%>
<%@ page import=\"Java.sql.*\"%>
<html>
<body>
<%Class.forName(\"com.informix.JDBC.IfxDriver\").newInstance();
String url =
\"jdbc:informix-sqli://123.45.67.89:1533/testDB:INFORMIXSERVER=myserver;
user=testuser;password=testpassword\";
//testDB为你的数据库名
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql=\"select * from test\";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print(\"数据库操作成功,恭喜你\");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
五、JSP连接Sybase数据库
testMySQL.jsp如下:
<%@ page contentType=\"text/html;charset=gb2312\"%>
<%@ page import=\"Java.sql.*\"%>
<html>
<body>
<%Class.forName(\"com.sybase.JDBC.SybDriver\").newInstance();
String url =\" jdbc:sybase:Tds:localhost:5007/tsdata\";
//tsdata为你的数据库名
Properties sysProps = System.getProperties();
SysProps.put(\"user\",\"userid\");
SysProps.put(\"password\",\"user_password\");
Connection conn= DriverManager.getConnection(url, SysProps);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql=\"select * from test\";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print(\"数据库操作成功,恭喜你\");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html> |
|