oracle数据库10g连接,Oracle10g数据库连接及增删改查(精)

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class JdbcConnection {

public static void main(String[] args {

//getCon(;

// insertTbUser(;

updateUser(;

//query(;

//delTbUser(;

}

public static void insertTbUser( {

String url = "jdbc:oracle:thin:@localhost:1521:orcl";

String driverClass = "oracle.jdbc.driver.OracleDriver";

try {

Class.forName(driverClass;

Connection con = java.sql.DriverManager.getConnection(url, "mm", "mm";

// statement开辟一个通道

java.sql.Statement st = con.createStatement(;

String insertSql = "insert into tb_user(userid,username,password" + // 执行sql语句，返回操作所影响的条数。

"values(101,'zhuyu','zhuyu'";

st.execute(insertSql;

st.close(;

con.close(;

} catch (ClassNotFoundException e {

e.printStackTrace(;