1 传统方式连接数据库(效率较低)
此方法连接数据库,其性能、可靠性与稳定性随着用户访问量的增加逐渐下降,跟踪测试表明,其根本问题与Connection对象的创建有关。不过在这里还是讲一下此方法的实现:添加记录到数据库表中
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@192.168.1.3:1521:ora92";
String username = "scott";
String password = "tiger";
String sql = "insert into users(username,password) values (?,?)";
try {
Class.forName(driver); //oracle.jdbc.driver.OracleDriver();
Connection conn = DriverManager.getConnection(url, username,password);
PreparedStatement ps = conn.prepareStatement(sql); //Statement stat=conn.createStatement();
ps.setString(1, "张三");
ps.setString(2