java连接数据库实例

 

java连接sqlserver

 

import java.sql.*;

public class TestDB {
public static void main(String[] args) {
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=pubs";
String userName = "sa";
String userPwd = "";
Connection dbConn

try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!");
}
Catch (Exception e) {
e.printStackTrace();
}
}
}

 

java连接mysql

 

 

import java.sql.*;

public class SampleIntro
{
  public static void main(String[] args)
  {
    try
    {
      Connection conn;
      Statement stmt;
      ResultSet res;
      //加载Connector/J驱动
      //这一句也可写为：Class.forName("com.mysql.jdbc.Driver");
      Class.forName("com.mysql.jdbc.Driver").newInstance();
      //建立到MySQL的连接
      conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test",
                                         "root", "guapo");
      //执行SQL语句
      stmt = conn.createStatement();
      res = stmt.executeQuery("select * from pet");
      //处理结果集
      while (res.next())
      {
        String name = res.getString("name");
        System.out.println(name);
      }
      res.close();

    }
    catch (Exception ex)
    {
      System.out.println("Error : " + ex.toString());
    }
  }
}

 

 

java连接oracle

 

 

// 使用本地的jdbc连接串，查询oracle数据库表
import java.sql.* ;

public class lookup {
public static void main(String[] args)
throws SQLException, ClassNotFoundException {
//定义了数据库连接串
String dbUrl = "jdbc:odbc:dbjdbc" ;
//数据库的用户名
String user = "manager" ;
//数据库的用户口令
String password = "ora912" ;
// 加载jdbc-odbc bridge驱动程序
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver" );
// 与url指定的数据源建立连接
Connection c = DriverManager.getConnection(dbUrl, user, password);
//采用Statement进行查询
Statement s = c.createStatement();
ResultSet r = s.executeQuery("SELECT empno,name from emp" );
while (r.next()) {
// 打印字段信息
System.out.println(r.getString("empno") + " ,
" + r.getString("name " ) );
}
// 关闭Statement，其上的ResultSet也将关闭
s.close();
}
}