Class.forName(Driver).newInstance();
Connection conn= DriverManager.getConnection(ConnStr,User,Password);
Statement stmt = conn.createStatement();
Connection conn= DriverManager.getConnection(ConnStr,User,Password);
Statement stmt = conn.createStatement();
解决方案 »
- Java fresh blood 高级群
- 请教:怎么把一个对象包装成一个form,然后通过post传递给另外一个servlet
- tomcat、apache下相关问题
- 关于列表框动态增删的问题``用JSP做的``
- 利用jquery动态添加的元素,jq validation组件失效
- 定时刷新
- 如何在html页面中获得自己这个页面传过来的参数?
- 了解新浪微博开发的进来看看
- 在 jsp中为什么用request.getParameterMap()的方法获取不到表单中的值?
- freemarker从后台取生成的html字符串在页面显示成字符而不是html
- 关于在JSP中使用有返回值的存储过程
- struts中action动态地址及带参数跳转的方法
String url="jdbc:oracle:thin:@localhost:1521:myOracle"; //myorcle是你数据库的SID
String user="system";
String password="oracle";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="";
ResultSet rs=stmt.executeQuery(sql);
testoracle.jsp如下:<%@ page contentType="text/html;charset=gb2312"%> <%@ page import="java.sql.*"%><html> <body> <%Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();String url="jdbc:oracle:thin:@localhost:1521:orcl";//orcl为你的数据库的SID String user="scott"; String password="tiger"; 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>
String lUrl="java:oracle:thin:@10.98.0.100:1521:mgssfcs";
lConn=DriverManager.getConnection(lUrl,"scott","mdsmis");
stmt=lConn.createStatement();
string sql="";
rs=stmt.executeQuery(sql);
將oracle驅動class12.jar拷貝到tomcat\common\lib
import java.sql.*;
import java.util.*;
import java.io.PrintStream;
public class conn_oracle
{ String serverName;
String sDBDriver;
String sConnStr;
String login_name;
String pwd;
Connection con;
ResultSet rs; public conn_oracle()
{
login_name="scott";
pwd="tiger";
serverName = "localhost";
sDBDriver = "oracle.jdbc.driver.OracleDriver";
sConnStr = "jdbc:oracle:thin:@" + serverName + ":1521:abc";
con = null;
rs = null;
try
{
Class.forName(sDBDriver);
}
catch(ClassNotFoundException classnotfoundexception)
{
System.err.println(classnotfoundexception.getMessage());
}
}
public ResultSet executequery(String sql){
try{
con = DriverManager.getConnection(sConnStr, login_name, pwd);
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql);
}catch(SQLException e){
System.out.println("can't executeQuery");
}
return rs;
}
public int executeupdate(String sql) throws SQLException{
try
{
con = DriverManager.getConnection(sConnStr, login_name, pwd);
stmt=con.createStatement() ;
afint=stmt.executeUpdate(sql);
}catch(SQLException sqlexception)
{
System.err.println(sqlexception.getMessage());
} return afint;
}
public void closecon()
{
try{
if(rs!=null)
{
rs.close();
}
if(stmt!=null)
{
stmt.close();
}
if(con!=null)
{
con.close();
}
}catch(Exception e){}
}
}