java数据库连接

1、连接mysql

 Class.forName("com.mysql.jdbc.Driver");
 第一节或者是：new com.mysql.jdbc.Driver();                                           
 conn = DriverManager.getConnection("jdbc:mysql://localhost/mydata?"+"user=root&password=root");
 stmt = conn.createStatement();                     
 rs = stmt.executeQuery("select * from dept");

2、连接SQLServer2005
 Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
 conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=mydata","sa","root");
 stmt = conn.createStatement();
 rs = stmt.executeQuery("select * from users");
 while(rs.next()) {
  System.out.println(rs.getString(2));
 }

3、连接access
 首先建立数据库和数据源lxhdb， 当数据库没密码时：
 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 conn = DriverManager.getConnection("jdbc:odbc:lxhdb");
 如果有密码conn = DriverManager.getConnection("jdbc:odbc:数据源","用户名","密码");
 stmt = conn.createStatement();
 rs = stmt.executeQuery("select * from user");

4、连接excel
 数据源(ODBC)点击添加，在弹出窗口中选择“Driver do Microsoft Excel(*.xls)” 名为myxls
 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 conn = DriverManager.getConnection("jdbc:odbc:myxls");
 stmt = conn.createStatement();
 rs = stmt.executeQuery("select * from [Sheet1$]");