连接oracle，sqlserver中数据库的示例代码

来源：互联网发布：海尔轰天雷x3网络受限编辑：程序博客网时间：2024/05/22 05:02

一在Oracle中连接数据库

public class Test1 {
public static void main(String[] args) {
  try {
   Class.forName("oracle.jdbc.driver.OracleDriver");
   Connection conn = DriverManager.getConnection(
                           主机名端口 SID      帐号    密码
     "jdbc:oracle:thin:@haha:1521:oracle", "hehe", "a");
   Statement stt = conn.createStatement();
   ResultSet rs = stt.executeQuery("select * from emp");
   while (rs.next()) {
    System.out.print(rs.getObject(2).toString());
    System.out.println("/t" + rs.getObject(3).toString());
   }
   rs.close();
   stt.close();
   conn.close();
  } catch (Exception e) {
   e.printStackTrace();
  }
}
}

二在sqlserver中连接数据库

public class DBManager {

String url="jjdbc:microsoft:sqlserver://localhost:1433;databaseName='student'";
String driver ="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String useName="sa";
String pwd="sa";
Connection con =null;
Statement sta=null;
ResultSet rs=null;

public ResultSet getQiery(String sql)
{
  try {
   Class.forName(driver);
   con =DriverManager.getConnection(url,useName,pwd);
   sta = con.createStatement();
   rs =sta.executeQuery(sql);
  } catch (Exception e) {
        e.printStackTrace();
  }
  return rs;
}
public int getUpd(String sql)
{
  int i=0;
  try {
   Class.forName(driver);
   con = DriverManager.getConnection(url,useName,pwd);
   sta=con.createStatement();
   i=sta.executeUpdate(sql);
  } catch (Exception e) {
   e.printStackTrace();
  }
  return i;
}