public class ConnectSQL {
/**
* 数据库的连接
* @return
* @throws Exception
*/
public static Connection getConnection() throws Exception{
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@localhost:1521:xe"; //1521是自己搭配的,不同环境不一样
String userID="system"; //用户名
String password="system"; //密码
Connection conn=DriverManager.getConnection(url,userID,password);
return conn;
}
/**
* 测试连接是否成功
*/
public static void main(String[] args){
try{
Connection conn=getConnection();
PreparedStatement stmt=conn.prepareStatement("SELECT * FROM M_DEPT");
ResultSet rSet=stmt.executeQuery();
while(rSet.next()){
System.out.println("success!");
}
}
catch(Exception e){
e.printStackTrace();
}
/**
* 数据库的连接
* @return
* @throws Exception
*/
public static Connection getConnection() throws Exception{
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@localhost:1521:xe"; //1521是自己搭配的,不同环境不一样
String userID="system"; //用户名
String password="system"; //密码
Connection conn=DriverManager.getConnection(url,userID,password);
return conn;
}
/**
* 测试连接是否成功
*/
public static void main(String[] args){
try{
Connection conn=getConnection();
PreparedStatement stmt=conn.prepareStatement("SELECT * FROM M_DEPT");
ResultSet rSet=stmt.executeQuery();
while(rSet.next()){
System.out.println("success!");
}
}
catch(Exception e){
e.printStackTrace();
}
}
}