<%
String user=request.getParameter("name");
String pass=request.getParameter("pw");
Connection con;
String userid = "temp";
String pwd = "temp";
String url = "jdbc:oracle:thin:@192.168.1.236:1521:dbname";
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
con = DriverManager.getConnection(url,userid,pwd);
try
{
if(con==null){
%>
数据库连接失败
<% } else {
Statement stmt=con.createStatement();
String sSql = "select TABLE_NAME,TABLE_TYPE from cat";
String user=request.getParameter("name");
String pass=request.getParameter("pw");
Connection con;
String userid = "temp";
String pwd = "temp";
String url = "jdbc:oracle:thin:@192.168.1.236:1521:dbname";
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
con = DriverManager.getConnection(url,userid,pwd);
try
{
if(con==null){
%>
数据库连接失败
<% } else {
Statement stmt=con.createStatement();
String sSql = "select TABLE_NAME,TABLE_TYPE from cat";
解决方案 »
- ORACLE10新手一篇入门
- 多类型同结构的数据库设计(模板,在线,离线)
- Oracle9i的TOOLS-Export的使用
- select t.*, t.rowid from user t WHERE t.name LIKE 'a%c' 有这种查询麽? 查出所有开头为a,结尾为c的数据? 怎么写?
- 各位大哥:关于fetch游标取值问题,急!!!
- 为什么我不能安装ORICALE 9I????急求答案.
- oracle中数组的存放
- 有哪张系统表能看到index的定义呢?
- 高手请进:怎样使用wrap工具加密字符串常量?
- oracle中的if语句怎么写
- 为什么在win2000 server上不能安装ORACLE9I??
- 怎么样实现根据数据库的系统时钟来触发?
在PATH里设置(用户变量)
c:\jdk1.3.1_02\bin
在CLASSPATH里设置(系统变量)
.;C:\JDK1.3.1_02\LIB\tools.jar;
c:\Program Files\Apache Tomcat 4.0\CLASSES;
c:\Program Files\Apache Tomcat 4.0\lib;
c:\Program Files\Apache Tomcat 4.0\lib\classes111.jar;
c:\Program Files\Apache Tomcat 4.0\lib\classes12.jar
将d:\oracle\ora81\jdbc\lib\classes111.zip和d:\oracle\ora81\jdbc\lib\classes12.zip
Copy 到c:\Program Files\Apache Tomcat 4.0\lib\ 下,并改文件名为 .jar
在JAVA_HOME里设置(系统变量)
jdk1.3.1_02
在TOMCAT_HOME里设置(系统变量)
C:\Program Files\Apache Tomcat 4.0
public static String USER_KEY = "ServletLogin.user";
public static String FIELD_USER = "username";
public static String FIELD_PASSWORD = "password";
Connection con = null;
PreparedStatement updstmt;
Statement dispStmt;
ResultSet rs = null;
String sDriverName ="sun.jdbc.odbc.JdbcOdbcDriver";
String sConnectURL = "jdbc:odbc:ComputerTaxData"; //ComputerTaxData 为通过odbc 配置程序时的一个名字
String sOpertorName ="taxuser";
String sOpertorPass ="taxuser"; public void init(ServletConfig config) throws ServletException {
super.init(config);
try
{
//DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver ());
Class.forName (sDriverName).newInstance ();
con = DriverManager.getConnection(sConnectURL,sOpertorName,sOpertorPass);
}
catch(Exception e)
{
//throw(new UnavailableException(this,"Sorry! the Database didn't load!"+e.toString ()));
}
}
dataSourse是什么?
用context.lookup("java:comp/env/jdbc/test")可以连接数据库吗?