oracle数据库连接代码,Java代码库,德仔网

代码语言

代码分类

【Java】 oracle数据库连接

作者:Atlas_qf / 发布于2013/8/5/ 576


	import java.sql.*;
	public class ZipCompress {
	 private static String URL = "jdbc:oracle:thin:@10.128.50.23:1521:orcl";
	 private static String ID = "optixcms";
	 private static String PD = "optixcms";
	 public static Connection conn;
	 public static PreparedStatement ps;
	 public static ResultSet rs;
	 public static Statement st;
	 public void getConnection(){
	 try{
	 Class.forName("oracle.jdbc.driver.OracleDriver");
	 conn= DriverManager.getConnection(URL, ID, PD);
	 }
	 catch(Exception e){
	 e.printStackTrace();
	 }
	 }

	public static void main(String args[]){
	 ZipCompress zc= new ZipCompress();
	zc.getConnection();
	if(conn == null)
	{
	 System.out.println("与数据库链接失败！");
	
	}
	else
	{
	 System.out.println("与数据库链接成功");
	}
	try{
	 String sql = "insert into TEST(id,name) values(2,'wx')";
	 st= (Statement)conn.createStatement();
	 int count=st.executeUpdate(sql);
	 System.out.println("向数据库test插入" + count + "条数据");
	}catch(SQLException e){
	 System.out.println("插入数据失败"+e.getMessage());
	}
	
	
	}
	}

试试其它关键字

　oracle数据库　

同语言下

可能有用的

Atlas_qf贡献的其它代码(3)