常用数据库连接语句一：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的数据库连接语句 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.println(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.executeQuery(); 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);