《常用数据库连接语句》由会员分享,可在线阅读,更多相关《常用数据库连接语句(2页珍藏版)》请在金锄头文库上搜索。
1、常用数据库连接语句一:Mysql的数据库连接语句 Class.forName(com.mysql.jdbc.Driver); Connection con = DriverManager.getConnection.(jdbc:mysql:/localhost:3306/bookinfo,root,123); Statement st = con.createStatement(); String sql = select * from book; ResultSet rs = st.executeQuery(sql); while(rs.next() 二:sqlserver的数据库连接语句
2、Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver); Connection con = DriverManager.getConnection.(jdbc:microsoft:sqlserver:/localhost:1433;databaseName=bookinfo,sa,123); PreparedStatement ps = con.prepareStatement(select * from book); ResultSet rs = ps.executeQuery(); while(rs.next() out.pr
3、intln(rs.getString(2); 三:sqlserver2005的数据库连接语句 Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver); Connection con = DriverManager.getConnection.(jdbc:sqlserver:/localhost:1433;databaseName=bookinfo,sa,123); PreparedStatement ps = con.prepareStatement(select * from book); ResultSet rs = ps.e
4、xecuteQuery(); while(rs.next() out.println(rs.getString(2); 四:oracle的数据库连接语句 jdbc:oracle:thin: Class.forName(oracle.jdbc.driver.OracleDriver); Connection con = DriverManager.getConnection.(jdbc:oracle:thin:localhost:1521:bookinfo,zhangsan,123); PreparedStatement ps = con.prepareStatement(select * from book); ResultSet rs = ps.executeQuery(); while(rs.next() out.println(rs.getString(2);