JDBC
JDBC(Java Data Base Connectivity,java数据库连接)是一种用于执行SQL语句的Java API,可以为多种关系数据库提供统一访问,它由一组用Java语言编写的类和接口组成。JDBC提供了一种基准,据此可以构建更高级的工具和接口,使数据库开发人员能够编写数据库应用程序,同时,JDBC也是个商标名。[引用自百度百科]
1.对oracle:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class JdbcOracle {
public static void main(String[] args) throws Exception {
Connection ct = null;
Statement statement = null;
ResultSet rs = null;
try {
// 1.加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
// 2.得到连接
ct = DriverManager.getConnection(
"jdbc:oracle:thin:@127.0.0.1:1521:orcl", "scott", "tiger");
// 把事务设为不自动提交
ct.setAutoCommit(false);
// 3.创建sql对象
statement = ct.createStatement();
// 4.執行查詢
// statement
// .executeUpdate("update emp set sal=sal+10 where ename='KING'");
rs = statement.executeQuery("select id,name from employee");
System.out.println("查询结果为:");
//从数据库获取行
while (rs.next()) {
System.out.println(rs.getInt("id")+rs.getString("name"));
}
// 提交所有事务
ct.commit();
} catch (Exception e) {
e.printStackTrace();
//回滚
ct.rollback();
} finally {
// 关闭资源[先开后闭];
rs.close();
statement.close();
ct.close();
}
}
}
1.对MySQL:
public class JdbcMysql {
public static void main(String[] args) throws Exception {
Connection con = null;
Statement st = null;
ResultSet rs = null;
try {
// 1.加載驅動
Class.forName("com.mysql.jdbc.Driver");
// 2.得到连接
con = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/test", "root", "root");
// 3.创建sql对象
st = (Statement) con.createStatement();
// 4.執行查詢
rs = st.executeQuery("select * from test");
System.out.println("查询结果为:");
while (rs.next()) {
System.out
.println(rs.getInt("id") + " " + rs.getString("name"));
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
// 关闭资源[先开后闭];
rs.close();
st.close();
con.close();
}
}
}