properties文件:db.properties
#Oracle mysql db info
db_url_oracle = jdbc:oracle:thin:@127.0.0.1:1521:ora9
db_url_mysql = jdbc:mysql://localhost/dandan?characterEncoding=utf-8
username = root
password = dada
获取对mysql的连接并操作:
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;
public class MysqlConn {
public static Connection getConn() throws Exception {
//新建对象
Properties ps=new Properties();
//获取输入流
FileInputStream fis=new FileInputStream("src\\chapter18\\properties\\db.properties");
//把流加载到内存中
ps.load(fis);
//关闭流
fis.close();
//获取数据库url
String url=ps.getProperty("db_url_mysql");
//获取用户名
String user=ps.getProperty("username");
//获取密码
String password=ps.getProperty("password");
//获取连接
Connection conn=DriverManager.getConnection(url,user,password);
return conn;
}
public static void main(String[] args) throws Exception {
//加载驱动
Class.forName("org.gjt.mm.mysql.Driver");
//获取连接
Connection conn=MysqlConn.getConn();
//创建statement
Statement stmt=conn.createStatement();
//执行操作
ResultSet rs=stmt.executeQuery("select * from student");
while(rs.next()) {
System.out.println("id: "+rs.getInt(1)+"\tname: "+rs.getString(2)+
"\tsex: "+rs.getString(3)+"\tgrade: "+rs.getString(4));
}
rs.close();
stmt.close();
conn.close();
}
}
获取对Oracle的连接并操作
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;
public class OracleConn {
public static Connection getConnection() throws Exception {
//创建Properties对象
Properties ps=new Properties();
//创建读取流
FileInputStream fis=new FileInputStream("mydb.properties");
ps.load(fis);
fis.close();
String url=ps.getProperty("db_url_oracle");
String userName=ps.getProperty("userName");
String password=ps.getProperty("password");
Connection conn=DriverManager.getConnection(url,userName,password);
return conn;
}
public static void main(String[] args) throws Exception {
//1.加载驱动 2.获取连接 3.获取statement 4.执行操作
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn=OracleConn.getConnection();
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from student");
while(rs.next()){
System.out.print("stuId: " + rs.getInt(1));
System.out.print("\name: " + rs.getString(2));
System.out.println("\tgrade: " + rs.getString(3));
}
rs.close();
stmt.close();
conn.close();
}
}