Javaweb和Oracle数据库的连接

Javaweb和Oracle数据库的连接

1.导入相关jar包（ojdbc）

右击项目名 - build path - configure build path，上方选择Libraries - Add External JARs。

2.编写连接代码

package getdata;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.ArrayList; 
import java.util.List; 

public class OracleConn {
	   private static Connection conn = null;
	     
	    private static String driver = "oracle.jdbc.driver.OracleDriver"; 
	     
	    private static String url = "jdbc:oracle:thin:@//127.0.0.1:1521/orcl";
	     
	    private static String username = "system"; 
	     
	    private static String password = "123456"; 
	          
	    private static synchronized Connection getConn(){
	        if(conn == null){
	            try {
	                Class.forName(driver);
	                conn = DriverManager.getConnection(url, username, password);
	            } catch (ClassNotFoundException e) {
	                e.printStackTrace();
	            }catch (SQLException e) {
	                e.printStackTrace();
	            }
	        }
	        return conn;
	    } 
	    	     
	    public void query(String sql) throws SQLException{
	        PreparedStatement pstmt;
	        pstmt = getConn().prepareStatement(sql);
	        pstmt.executeUpdate();
	        pstmt.close();
	    }
    
	    public void close(){
	        try {
	            getConn().close();
	             
	        } catch (SQLException e) {
	            e.printStackTrace();
	        }
	    }
}

3.验证，编写main.java

package getdata;

public class main {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
        OracleConn test=new OracleConn();
        String sql="insert into userinfo values('admin1','123456','女','本科三年级','计算机科学与技术学院/人工智能学院','管理员1，系统测试。',1,to_date('2018-12-01 18:03:57','yyyy-mm-dd hh24:mi:ss'))";
    	try
    	{
    		test.query(sql);
    	}catch(Exception e)
    	{
    	}
	}
}