JDBC连接数据库模板

来源:互联网 发布:断电后mysql无法启动 编辑:程序博客网 时间:2024/05/29 03:11

mysql:

    Class.forName("com.mysql.jdbc.Driver");    String url="jdbc:mysql://localhost:3306/spring_mybatis";    String user="root";    String password="root";    Connection conn= DriverManager.getConnection(url,   user, password);    Statement statement =conn.createStatement();    ResultSet rs=statement.executeQuery("select * from items");

orcale:

Class.forName("oracle.jdbc.driver.OracleDriver");    String url="jdbc:oracle:thin:@localhost:1521:test";    String user="root";    String password="root";    Connection conn= DriverManager.getConnection(url,   user, password);    Statement statement =conn.createStatement();    ResultSet rs=statement.executeQuery("select * from items");
0 0
原创粉丝点击