常用的数据库连接语句
一：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:@<server>[:<1521>]:<database_name>
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));
}
