Java--应用场景--JDBC
一、连接mysql的例子
package cn.xiaoxiang.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class TestJDBC {/*** @param args* @throws ClassNotFoundException * @throws SQLException * @throws IOException */public static void main(String[] args){TestJDBC test = new TestJDBC();test.jdbc();}//没有开启事务的例子public void jdbc(){Connection conn = null;PreparedStatement ps = null;ResultSet rs = null;try{//1.注册驱动Class.forName("com.mysql.jdbc.Driver");//2.建立连接String url="jdbc:mysql://localhost:3306/tb_test";conn = DriverManager.getConnection(url);//3.创建SQL执行语句String sql = "select * from student where id=?";//4.执行SQL语句ps = conn.prepareStatement(sql);ps.setInt(1, 1);rs = ps.executeQuery();//5.处理执行结果if(rs!=null)while(rs.next()){String name = rs.getString("name");int age = rs.getInt("age");//.....}}catch(Exception e){e.printStackTrace()}finally{//6.释放资源free(rs,ps,conn);}}//开启事务的例子public void jdbcTransaction(){Connection conn = null;PreparedStatement ps = null;ResultSet rs = null;try{//1.注册驱动Class.forName("com.mysql.jdbc.Driver");//2.建立连接String url="jdbc:mysql://localhost:3306/tb_test";conn = DriverManager.getConnection(url);//开启事务conn.setAutoCommit(false);//设置隔离级别//conn.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);//3.创建SQL执行语句String sql = "select * from student where id=?";//4.执行SQL语句ps = conn.prepareStatement(sql);ps.setInt(1, 1);rs = ps.executeQuery();//5.处理执行结果if(rs!=null)while(rs.next()){String name = rs.getString("name");int age = rs.getInt("age");//.....}//提交事务conn.commit();}catch(Exception e){if(conn!=null)try{//事务回滚conn.rollback();}catch(SQLException qe){qe.printStackTrace();}}finally{//6.释放资源free(rs,ps,conn);}}//释放资源public static void free(ResultSet rs, Statement st, Connection conn) {try {if (rs != null) {rs.close();}} catch (SQLException e) {e.printStackTrace();} finally {try {if (st != null)st.close();} catch (SQLException e) {e.printStackTrace();} finally {if (conn != null)try {conn.close();} catch (SQLException e) {e.printStackTrace();}}}}}
二、常见数据库的驱动名称，和连接URL
| MySQL | com.mysql.jdbc.Driver | jdbc:mysql:// Eg: jdbc:mysql://localhost:3306/myDBName |
| Oracle | oracle.jdbc.driver.OracleDriver | dbc:oracle:thin:@ Eg:jdbc:oracle:thin:@localhost:1521:xe |
| IBM DB2 App | com.ibm.db2.jdbc.app.DB2Driver | jdbc:db2: Eg: jdbc:db2:myDBName |
| Microsoft SQL Server | com.microsoft.sqlserver .jdbc.SQLServerDriver | jdbc:sqlserver:// Eg:jdbc:sqlserver://localhost:1433;databaseName=myDBName |
参考链接：https://www.soapui.org/jdbc/reference/jdbc-drivers.html
转载于:https://my.oschina.net/u/3323607/blog/2413650
本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！