jdbc连接MySQL和Oracle_JDBC连接数据库MySQL和Oracle

连接MySQL的代码

package www.libinxuan.jdbc.exmp;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class TestJDBC {

public static void main(String[] args){

String url = "jdbc:mysql://localhost:3306/test";

String classname = "com.mysql.jdbc.Driver";

String username = "root";

String password = "root";

Connection conn = null;

String sql = "select * from user";

String sql1 = "insert into user_tabel(username,password) values(?,?)";

try {

Class.forName(classname);

conn = DriverManager.getConnection(url, username, password);

/*PreparedStatement pst = conn.prepareStatement(sql1);

pst.setString(1, "abc");

pst.setString(2, "123456");

pst.executeUpdate();*/

Statement st = conn.createStatement();

ResultSet rs = st.executeQuery(sql);

System.out.print("sdsds");

while(rs.next()){

System.out.println("用户名为： " + rs.getString("username"));

System.out.println("密码为： " + rs.getString("password"));

}

rs.close();

st.close();

conn.close();

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

连接Oracle的代码

package www.libinxuan.jdbc.exmp;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class TestOracle {

public static void main(String[] args){

String url = "jdbc:oracle:thin:@localhost:1521:orcl";

String classname = "oracle.jdbc.driver.OracleDriver";

String username1 = "system";

String password1 = "abc123456";

Connection conn = null;

String sql = "select * from user";

String sql1 = "insert into user_tabel(username,password) values(?,?)";

try {

Class.forName(classname);

conn = DriverManager.getConnection(url, username1, password1);

/*PreparedStatement pst = conn.prepareStatement(sql1);

pst.setString(1, "abc");

pst.setString(2, "123456");

pst.executeUpdate();*/

Statement st = conn.createStatement();

ResultSet rs = st.executeQuery(sql);

while(rs.next()){

System.out.println("用户名为： " + rs.getString("username"));

System.out.println("密码为： " + rs.getString("password"));

}

rs.close();

st.close();

conn.close();

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

}

}