JDBC常规驱动连接配置
1.驱动类加载
Class.forName(driverClass)
//加载Oracle驱动
Class.forName("oracle.jdbc.driver.OracleDriver")
//加载Sqlserver驱动
Class.froName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
//加载MySQL驱动
Class.forName("com.mysql.jdbc.Driver")
2.连接数据库
Connection conn = DriverManager.getConnection("");
//Orcale
DriverManager.getConnection("jdbc:mysql://host:port/database", "user", "password");
//Sqlserver
DriverManager.getConnection("jdbc:microsoft:sqlserver://host:port; DatabaseName=database", "user", "password");
//MySQL
DriverManager.getConnection("jdbc:mysql://host:port/database", "user", "password");
3.构建SQL语句发送对象
Statement st = conn.createStatement();
st.executeUpdate("sql");
PreparedStatement pst = conn.preparedStatement(sql);
String sql = "update table set id=‘?’, name = '?' ";
st.setInt(1,1);
st.setString(2,name);
st.execute();