常用数据库连接语句.doc

《常用数据库连接语句.doc》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、常用数据库连接语句一：Mysql的数据库连接语句   Class.forName("com.mysql.jdbc.Driver");   Connectioncon=DriverManager.getConnection.("jdbc:mysql://localhost:3306/bookinfo","root","123");   Statementst=con.createStatement();   Stringsql="select*frombook";   ResultSetrs=st.executeQuery(sql);    whil

2、e(rs.next()){   }二：sqlserver的数据库连接语句Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");   Connectioncon=DriverManager.getConnection.("jdbc:microsoft:sqlserver://localhost:1433;databaseName=bookinfo","sa","123");   PreparedStatementps=con.prepareStatement("select*fro

3、mbook"); ResultSetrs=ps.executeQuery(); while(rs.next()){ out.println(rs.getString(2));  }三：sqlserver2005的数据库连接语句   Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");   Connectioncon=DriverManager.getConnection.("jdbc:sqlserver://localhost:1433;databaseName=bookinf

4、o","sa","123");   PreparedStatementps=con.prepareStatement("select*frombook");   ResultSetrs=ps.executeQuery();   while(rs.next()){  out.println(rs.getString(2));  }四：oracle的数据库连接语句jdbc:oracle:thin:@[:<1521>]:Class.forName("oracle.jdbc.driver.OracleDrive

5、r");   Connectioncon=DriverManager.getConnection.("jdbc:oracle:thin:@localhost:1521:bookinfo","zhangsan","123");   PreparedStatementps=con.prepareStatement("select*frombook");   ResultSetrs=ps.executeQuery();   while(rs.next()){  out.println(rs.getString(2));  }