JDBC总结

1.导入sql包
import java.sql.*;


2.加载数据库驱动  要将数据库的驱动路劲加载到相应的classpath中 
classpath=.;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\lib\tools.jar;D:\Program Files\apache-tomcat-7.0.26\lib\servlet-api.jar;D:\app\HaoYunsheng\product\11.2.0\client_1\jdbc\lib\ojdbc6.jar;


DB2：Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
oracle: Class.forName("oracle.jdbc.driver.OracleDriver");


3.创建与数据库的Connection
DB2：Connection conn = DriverManager.getConnection("jdbc:db2:XXX","XXX","XXX");
oracle: Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@主机ip
:port:XXX","XXX","XXX");


4.执行操作
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);    //sql为要查询的String
int col = stmt.executeUpdate(sql);        //sql为要更新的String


PreparedStatement pstmt = conn.prepareStatement(sql);