connect.java

一个特别简单的Jsp+javabean实现与Oracle数据库通讯

package bean;

import java.sql.*;

public   class   connect   { 
	private Statement stmt;
	private Connection conn;
	public static void main(String[] args){
		connect con = new connect();
		String sql = "insert into regist values('monk','F',21,'shandong','4-4-08','6-4-08','13439910228',21)";
	      con.executeUpdate(sql);
		ResultSet rs = con.executeQuery("select * from regist");
		try {
			while(rs.next()){
				System.out.println(rs.getString("姓名"));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public connect(){
		try 
		{ 
			Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); 
			String url="jdbc:oracle:thin:@localhost:1521:oracle"; 
			String user="jerry"; 
			String password="123456"; 
			conn = DriverManager.getConnection(url,user,password); 
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); 	
			}catch(Exception e){
				e.printStackTrace();
				System.out.println("failed!");
			}  
	}
	public ResultSet executeQuery(String sql){
		try {
			return stmt.executeQuery(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}
	public int executeUpdate(String sql){
		try {
			return stmt.executeUpdate(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return 0;
	}
	public void close(){
		try {
			this.conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}





/*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(); */




//package bean;
//
//import java.sql.*;
//
//public class connect {
//	
//	private String username = "jerry";
//	private String password = "123456";
//	private String database = "taskdata";
//	private Connection conn = null;
//	private ResultSet rs = null;
//	
//	public connect()
//	{
//		/*try{
//			Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
//		}
//		catch(Exception ex)
//		{
//			System.err.println(ex.getMessage());
//		}*/
//	}
//	
//	public ResultSet executeQuery(String sql)
//	{
//		rs = null;
//		try{
//			DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
//		    conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1527:oracle",username,password);
//			Statement stmt = conn.createStatement();
//			rs = stmt.executeQuery(sql);
//		}
//		catch(SQLException ex)
//		{
//			System.err.println("connect.executeQuery(): " + ex.getMessage());
//		}
//		
//		return rs;		
//	}
//	
//	public void executeInsert(String sql)
//	{
//		try{
//			DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
//		    conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1527:oracle"+ database,username,password);
//		    Statement stmt = conn.createStatement();
//			stmt.executeUpdate(sql);
//		}
//		catch(SQLException ex)
//		{
//			System.err.println("connect.executeInsert(): " + ex.getMessage());
//		}		
//	}
//	
//	public void executeDelete(String sql)
//	{
//		try{
//			DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
//		    conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1527:oracle"+ database,username,password);
//			Statement stmt = conn.createStatement();
//			stmt.executeUpdate(sql);
//		}
//		catch(SQLException ex)
//		{
//			System.err.println("connect.executeDelete(): " + ex.getMessage());
//		}		
//	}
//
//}


//import java.sql.*;
//
//public   class   connect   { 
//	private Statement stmt;
//	private Connection conn;
//	private ResultSet rs = null;
//	public connect(){			//实现数据库连接
//		try 
//		{ 
//			Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); 
//			String url="jdbc:oracle:thin:@localhost:1521:oracle"; 
//			String user="jerry"; 
//			String password="123456"; 
//			conn= DriverManager.getConnection(url,user,password); 
//				
//			}catch(Exception e){
//				e.printStackTrace();
//				System.out.println("failed!");
//			}  
//	}
//	public ResultSet executeQuery(String sql){			//执行查询
//		try {
//			this.stmt = this.conn.createStatement(
//					ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
//			this.rs = this.stmt.executeQuery(sql);
//		} catch (SQLException e) {
//			// TODO Auto-generated catch block
//			e.printStackTrace();
//		}
//		return rs;
//	}
//	public int executeUpdate(String sql){			//执行数据库更新
//		try {
//			return stmt.executeUpdate(sql);
//		} catch (SQLException e) {
//			// TODO Auto-generated catch block
//			e.printStackTrace();
//		}
//		return 0;
//	}
//	public void close(){
//		try {
//			this.conn.close();
//		} catch (SQLException e) {
//			// TODO Auto-generated catch block
//			e.printStackTrace();
//		}
//	}
//	public static void main(String[] args){
//		connect con = new connect();
//		String sql = "insert into regist values('monk','F',21,'shandong','04-4月-08','06-4月-08','13439910228',12)";
//		//con.executeQuery(sql);
//	    con.executeUpdate(sql);
//		ResultSet rs = con.executeQuery("select * from regist");
//		try {
//			while(rs.next()){
//				System.out.println(rs.getString("姓名"));
//			}
//		} catch (SQLException e) {
//			// TODO Auto-generated catch block
//			e.printStackTrace();
//		}
//		try{
//    		String sql = "SELECT * From regist;";
//    		ResultSet rs1 = con.executeQuery(sql);
//    		while(rs1.next()){
//    		System.out.println("floor");
//    		System.out.println("room");
//    		System.out.println("contain");
//    		System.out.println("price");
//    		System.out.println("remark");
//    		}
//       }
//    	catch (SQLException e){
//    		System.out.println(e.getMessage());
//    	}
//	}
//
//}