连接数据库的五种方式
连接数据库的五种⽅式
⽅式1
⽅式2
祭奠英烈手抄报
⽅式3⽅式4(推荐使⽤)
//1.注册驱动        Driver driver = new  Driver ();
//2.得到连接
//(1)jdbc:mysql:// 规定好的协议，通过jdbc 的⽅式连接数据库
//(2)localhost 主机地址，可以是IP
//(3)3306表⽰mysql 监听接⼝
//(4)cyy_db02表⽰连接到mysql dbms 的哪个数据库
//(5)mysql 连接本质为socket 连接
String url ="jdbc:mysql://localhost:3306/cyy_db02";
//将⽤户名和密码放⼊到Properties 对象
Properties properties = new  Properties ();
properties .setProperty ("user","root");
properties .setProperty ("password","cyy");
祝高考顺利八字祝福语Connection connect = driver .connect (url , properties );
//3.执⾏sql
String sql ="insert into actor values(null,'xxx','男','1970-11-11','110')";
//⽤于执⾏静态的SQL 语句并返回其⽣成的结果的对象
Statement statement = connect .createStatement ();
int  rows =statement .executeUpdate (sql );//如果是dml 语句，返回的就是影响的⾏数
System .out .println (rows >0?"成功":"失败");
//4.关闭连接资源
statement .close ();
connect .close ();
//使⽤反射加载Driver 类，动态加载，更加灵活，减少依赖性
Class <?> aClass = Class .forName ("sql.jdbc.Driver");
Driver driver = (Driver ) aClass .newInstance ();
String url ="jdbc:mysql://localhost:3306/cyy_db02";
//将⽤户名和密码放⼊到Properties 对象
Properties properties = new  Properties ();
properties .
lol盲僧攻略setProperty ("user","root");
properties .setProperty ("password","cyy");
Connection connect = driver .connect (url , properties );
System .out .println ("⽅式2"+connect );
//⽅式3 使⽤DriverManager 代替Driver 进⾏统⼀管理
public  void  connect03() throws  ClassNotFoundException , InstantiationException , IllegalAccessException , SQLException {        //使⽤反射加载
Class <?> aClass = Class .forName ("sql.jdbc.Driver");
Driver driver = (Driver )aClass .newInstance ();
//创建url 和user 和password
String url ="jdbc:mysql://localhost:3306/cyy_db02";
String user ="root";
String password ="cyy";
DriverManager .registerDriver (driver );
Connection connection = DriverManager .getConnection (url , user , password );
System .out .println ("⽅式3"+connection );
}
⽅式5
这⾥为配置⽂件mysql.properties信息
url=jdbc:mysql://localhost:3306/cyy_db02
user=root
password=cyy sql.jdbc.Driver  public  void  connect04() throws  ClassNotFoundException , SQLException {        //使⽤反射加载Driver 类
//在加载Driver 类时，完成注册
/**
* 源码1.静态代码块，在类加载时会执⾏⼀次
*static {
*        try {
*            isterDriver(new Driver());
仙剑三魔剑养成
*        } catch (SQLException var1) {
*            throw new RuntimeException("Can't register driver!");
*        }
*    }湖南二本大学有哪些
*/
Class <?> aClass = Class .forName ("sql.jdbc.Driver");
//创建url 和user 和password
String url ="jdbc:mysql://localhost:3306/cyy_db02";
String user ="root";
String password ="cyy";
Connection connection = DriverManager .getConnection (url , user , password );        System .out .println ("⽅式4"+connection
);    }
//通过Properties 获得配置⽂件的信息
Properties properties = new  Properties ();
properties .load (new  FileInputStream ("src\\mysql.properties"));
//获取相关的值
String user = properties .getProperty ("user");
String password = properties .getProperty ("password");
String driver = properties .getProperty ("driver");
String url = properties .getProperty ("url");
中秋节日的简短精美句子Class .forName (driver );
Connection connection = DriverManager .getConnection (url , user , password );        System .out .println ("⽅式5"+connection );

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。